| View previous topic :: View next topic |
| Author |
Message |
IYQ2 New User


Joined: 15 Jan 2007 Posts: 9 Location: Sterling, VA
|
Posted: Wed Feb 21, 2007 9:59 pm Post subject: NMP crashing when performing scheduled PowerPurge |
|
|
| 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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Thu Feb 22, 2007 1:05 am Post subject: |
|
|
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 |
|
 |
IYQ2 New User


Joined: 15 Jan 2007 Posts: 9 Location: Sterling, VA
|
Posted: Thu Feb 22, 2007 1:41 am Post subject: |
|
|
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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Thu Feb 22, 2007 2:30 am Post subject: |
|
|
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 |
|
 |
BZB Expert

Joined: 26 Apr 2005 Posts: 1387
|
Posted: Thu Feb 22, 2007 9:53 am Post subject: |
|
|
| 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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Thu Feb 22, 2007 12:02 pm Post subject: |
|
|
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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Thu Feb 22, 2007 8:23 pm Post subject: |
|
|
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 |
|
 |
codethought Experienced


Joined: 12 Feb 2007 Posts: 63
|
Posted: Fri Feb 23, 2007 4:11 am Post subject: |
|
|
Speaking of which, when will the next beta happen, anyway?  |
|
| Back to top |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Fri Feb 23, 2007 2:30 pm Post subject: |
|
|
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 |
|
 |
codethought Experienced


Joined: 12 Feb 2007 Posts: 63
|
Posted: Fri Feb 23, 2007 4:54 pm Post subject: |
|
|
| administrator wrote: | As soon as it's ready...
|
Heh.. good answer...  |
|
| Back to top |
|
 |
BinaryTB Experienced

Joined: 25 May 2005 Posts: 210
|
Posted: Sun Feb 25, 2007 5:54 am Post subject: |
|
|
| 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 |
|
 |
BinaryTB Experienced

Joined: 25 May 2005 Posts: 210
|
Posted: Sun Feb 25, 2007 6:43 am Post subject: |
|
|
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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Sun Feb 25, 2007 6:55 am Post subject: |
|
|
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 |
|
 |
BinaryTB Experienced

Joined: 25 May 2005 Posts: 210
|
Posted: Sat Apr 07, 2007 9:14 pm Post subject: |
|
|
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 |
|
 |
administrator Developer


Joined: 24 Jul 2004 Posts: 4750 Location: King William, VA
|
Posted: Sat Apr 07, 2007 9:17 pm Post subject: |
|
|
How much RAM do you have on your machine?
Regards |
|
| Back to top |
|
 |
|