NMP crashing when performing scheduled PowerPurge
Goto page 1, 2  Next
 
Post new topic   This topic is locked: you cannot edit posts or make replies.    newsmanpro.com Forum Index : Technical Support
View previous topic :: View next topic  
Author Message
IYQ2
New User
New User


Joined: 15 Jan 2007
Posts: 9
Location: Sterling, VA

PostPosted: Wed Feb 21, 2007 9:59 pm    Post subject: NMP crashing when performing scheduled PowerPurge Reply with quote

NMP appears to be crashing on me when performing a scheduled PowerPurge. I've got it set to download new headers at 1:00am and then perform a PowerPurge at 5:00am. When I leave for work at 6:00am I can see that a PowerPurge is running. However, when I get home after work NMP has shut down and when it restarts I get a warning notice that the program terminated unexpectedly and I have to do a repair. The repair runs, everything works fine, and then the problem repeats the next day. Any suggestions? Thanks!
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Thu Feb 22, 2007 1:05 am    Post subject: Reply with quote

Are there any errors recorded in the Errorlog files stored in NMP's UserAppData folder?

Are there any errors reported in MySQL's error log?

Have you tried running a PowerPurge while you are at the computer to see if it crashes then?

How much RAM do you have?

Regards
Back to top
View user's profile Send private message Send e-mail
IYQ2
New User
New User


Joined: 15 Jan 2007
Posts: 9
Location: Sterling, VA

PostPosted: Thu Feb 22, 2007 1:41 am    Post subject: Reply with quote

Since posting this question, I've gone back to scratch with NMP and reloaded MySQL using the 4.x version rather than 5.x. The difference in performance is ASTOUNDING. It was dog slow before, now it's screaming so fast I can't believe it. I've got 1 Gig of RAM.

Couldn't see the folder you were talking about with the error files. Where would it be located?

Crossing my fingers and hoping this fixes the issues. Possibly, this was a SQL problem. With MySQL 5.x it took a very, very long time to process headers -- up to two or three DAYS if downloading headers for a large group. Now, it's processing headers almost as fast as they come in.
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Thu Feb 22, 2007 2:30 am    Post subject: Reply with quote

The UserAppData folder for NMP would be located:

Code:
C:\Documents and Settings\<user>\Local Settings\Application Data\Newsman Pro


I suspect, but I can't be sure, that MySQL may have been running out of memory while performing the PowerPurge queries. We've had a few reports of the symptoms you reported prior to yours, but no one has been able to reproduce it in a way that can give us information on what's really happening. We can't reproduce it here at all.

It is possible that if MySQL runs out of memory, it could crash and take NMP with it, but I just don't have enough information to prove that theory, one way or the other.

For the most part, MySQL 4.x is much faster than MySQL 5.x. We believe that it is in large part due to changes made in the 5.x series to enforce stricter SQL standards.

Regards
Back to top
View user's profile Send private message Send e-mail
BZB
Expert
Expert


Joined: 26 Apr 2005
Posts: 1387

PostPosted: Thu Feb 22, 2007 9:53 am    Post subject: Reply with quote

I've also been seeing these kinds of intermittent Powerpurge crashes, and NMP just bombs out at various points during the powerpurge, closing down without leaving anything in the logs. I think it's more likely to happen when you have more messages to purge.
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Thu Feb 22, 2007 12:02 pm    Post subject: Reply with quote

I really do think it is memory related. The original PowerPurge was a script written by one of our users that NMP passed to MySQL. The current PowerPurge has NMP performing the queries internally, so this may be where the problem is.

We'll have to re-examine the PowerPurge queries and see if some of them can be broken down into smaller queries or whether we should go back to using a script...

Regards
Back to top
View user's profile Send private message Send e-mail
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Thu Feb 22, 2007 8:23 pm    Post subject: Reply with quote

We've added logging of the entire PowerPurge process to a log file for the next beta. This will allow those of you who are experiencing this issue to tell us exactly at what point the process is failing.

Regards
Back to top
View user's profile Send private message Send e-mail
codethought
Experienced
Experienced


Joined: 12 Feb 2007
Posts: 63

PostPosted: Fri Feb 23, 2007 4:11 am    Post subject: Reply with quote

Speaking of which, when will the next beta happen, anyway? Wink
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Fri Feb 23, 2007 2:30 pm    Post subject: Reply with quote

As soon as it's ready...

We are in the process of adding Par2 verification/repair and Rar extraction to the post processing engine.

The par2 stuff has been tested and seems to be working well. Last night was our first successful test of the Rar extraction.

The bigger issue with this is that the Post Processing engine never really got a lot of working out from users, so we've been trying to anticipate issues that will come up now that there is a good reason to learn how to use it.

Regards
Back to top
View user's profile Send private message Send e-mail
codethought
Experienced
Experienced


Joined: 12 Feb 2007
Posts: 63

PostPosted: Fri Feb 23, 2007 4:54 pm    Post subject: Reply with quote

administrator wrote:
As soon as it's ready...



Heh.. good answer... Wink
Back to top
View user's profile Send private message
BinaryTB
Experienced
Experienced


Joined: 25 May 2005
Posts: 210

PostPosted: Sun Feb 25, 2007 5:54 am    Post subject: Reply with quote

administrator wrote:
We've added logging of the entire PowerPurge process to a log file for the next beta. This will allow those of you who are experiencing this issue to tell us exactly at what point the process is failing.

Oh btw, I'm no longer experiencing that NMP + PowerPurge crash, all it took was an XP reinstall. NMP and MySQL (4 or 5) reinstall didn't seem to affect anything. Used the same exact mysql.ini tweaks before and after XP reinstall too, so don't know where the problem could've been.
Back to top
View user's profile Send private message
BinaryTB
Experienced
Experienced


Joined: 25 May 2005
Posts: 210

PostPosted: Sun Feb 25, 2007 6:43 am    Post subject: Reply with quote

Nevermind...

Just ran PowerPurge with about ~40k headers in the trash, bam, NMP crashes silently. Upon starting it up again I get a Repair option. I never did try it with that many headers in my trash after the reinstall. Back to background purging.

Kinda ironic that the crash actually happened after I posted about it not happening on my system anymore. How poltergeist-y.
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Sun Feb 25, 2007 6:55 am    Post subject: Reply with quote

Very strange. I regularly run PowerPurge with 200,000+ headers in the Trash...never a crash.

It's got to be something peculiar that we just can't see. Hopefully the new PowerPurge logging will give some direction.

Regards
Back to top
View user's profile Send private message Send e-mail
BinaryTB
Experienced
Experienced


Joined: 25 May 2005
Posts: 210

PostPosted: Sat Apr 07, 2007 9:14 pm    Post subject: Reply with quote

Crash with 2.7.0.0:

Code:
PowerPurge started: 4/7/2007 4:28:14 PM
4/7/2007 4:28:15 PM: Gathering Workgroups...
4/7/2007 4:28:15 PM: Found 11 Workgroups...
4/7/2007 4:28:15 PM: Purging wgparts00...
4/7/2007 4:28:15 PM: Counting records in wgparts00...
4/7/2007 4:28:15 PM: 7182 records found...
4/7/2007 4:28:15 PM: Counting records to be purged in wgparts00...
4/7/2007 4:28:16 PM: 0 records found...
4/7/2007 4:28:16 PM: Purging wgparts01...
4/7/2007 4:28:16 PM: Counting records in wgparts01...
4/7/2007 4:28:16 PM: 1380801 records found...
4/7/2007 4:28:16 PM: Counting records to be purged in wgparts01...
4/7/2007 4:28:59 PM: 175839 records found...
4/7/2007 4:28:59 PM: Purging records for wgparts01 using DIRECT method...
4/7/2007 4:30:49 PM: Purge complete for wgparts01...
4/7/2007 4:30:49 PM: Checking for orphaned records in wgparts01...
4/7/2007 4:31:15 PM: Check for orphaned records complete for wgparts01...
4/7/2007 4:31:15 PM: Purging wgparts02...
4/7/2007 4:31:15 PM: Counting records in wgparts02...
4/7/2007 4:31:15 PM: 0 records found...
4/7/2007 4:31:15 PM: Purging wgparts03...
4/7/2007 4:31:15 PM: Counting records in wgparts03...
4/7/2007 4:31:15 PM: 1170138 records found...
4/7/2007 4:31:15 PM: Counting records to be purged in wgparts03...
4/7/2007 4:32:06 PM: 218365 records found...
4/7/2007 4:32:06 PM: Purging records for wgparts03 using DIRECT method...
4/7/2007 4:34:25 PM: Purge complete for wgparts03...
4/7/2007 4:34:25 PM: Checking for orphaned records in wgparts03...
4/7/2007 4:35:11 PM: Check for orphaned records complete for wgparts03...
4/7/2007 4:35:11 PM: Purging wgparts04...
4/7/2007 4:35:11 PM: Counting records in wgparts04...
4/7/2007 4:35:11 PM: 4384412 records found...
4/7/2007 4:35:11 PM: Counting records to be purged in wgparts04...
4/7/2007 4:52:46 PM: 1135519 records found...
4/7/2007 4:52:46 PM: Purging records for wgparts04 using DIRECT method...
4/7/2007 5:06:38 PM: Purge complete for wgparts04...
4/7/2007 5:06:38 PM: Checking for orphaned records in wgparts04...
4/7/2007 5:11:14 PM: Check for orphaned records complete for wgparts04...
4/7/2007 5:11:14 PM: Purging wgparts05...
Back to top
View user's profile Send private message
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4750
Location: King William, VA

PostPosted: Sat Apr 07, 2007 9:17 pm    Post subject: Reply with quote

How much RAM do you have on your machine?

Regards
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    newsmanpro.com Forum Index : Technical Support All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Copyright 2003-2006, Daniel Cumpian
NMP Default By ::Dementeddogz.com::