>Also very strange,.... What is strange?
>Apr-28-09 18:24:49 [Worker_10001] Error: rebuildspamdb failed - This in nearly impossible - but true - it has taken too long to find a new pair to put it in to spamdb - meanwhile the DB-conn was gone - will be fixed in 0.0.23 > It takes ages for rebuildspamdb to complete. CPU usage is very low reduce 'RebuildThreadCycleTime' to 10 or 0 >As you can see it took a lot longer then 5988 seconds. It took 3 hours >Apr-28-09 16:45:01 [Worker_10001] File Count: 15,516 >Apr-28-09 18:24:49 [Worker_10001] Finished in 5988 second(s) Was this your first time using any rebuild ? some simple Mathematics 16:45:01 - 18:24:49 = 1h 39m 48s = 5988 seconds ! Thomas Pascal Dreissen <[email protected]> 28.04.2009 18:34 Bitte antworten an ASSP development mailing list <[email protected]> An ASSP list development mailing <[email protected]> Kopie Thema [Assp-test] Fwd: Rebuildspam problems RC 0.0.20 Also very strange, here is the complete sniplet of the rebuilding: Apr-28-09 15:10:35 [Worker_10001] RebuildSpamDB started Apr-28-09 15:10:35 [Worker_10001] Maxfiles: 18009 Apr-28-09 15:10:35 [Worker_10001] /usr/local/assp/errors/spam Apr-28-09 15:10:35 [Worker_10001] File Count: 334 Apr-28-09 15:10:35 [Worker_10001] Processing... errors/spam with 334 files Apr-28-09 15:13:25 [Worker_10001] Imported Files: 334 Apr-28-09 15:13:25 [Worker_10001] Finished in 170 second(s) Apr-28-09 15:13:25 [Worker_10001] /usr/local/assp/errors/notspam Apr-28-09 15:13:25 [Worker_10001] File Count: 1,000 Apr-28-09 15:13:25 [Worker_10001] Processing... errors/notspam with 1000 files Apr-28-09 15:23:47 [Worker_10001] Imported Files: 1,000 Apr-28-09 15:23:47 [Worker_10001] Finished in 622 second(s) Apr-28-09 15:23:47 [Worker_10001] /usr/local/assp/spam Apr-28-09 15:23:47 [Worker_10001] File Count: 14,036 Apr-28-09 15:23:47 [Worker_10001] Processing... spam with 14036 files Apr-28-09 16:45:01 [Worker_10001] Imported Files: 14,036 Apr-28-09 16:45:01 [Worker_10001] Finished in 4874 second(s) Apr-28-09 16:45:01 [Worker_10001] /usr/local/assp/notspam Apr-28-09 16:45:01 [Worker_10001] File Count: 15,516 Apr-28-09 16:45:01 [Worker_10001] Processing... notspam with 15516 files Apr-28-09 18:24:49 [Worker_10001] Imported Files: 15,516 Apr-28-09 18:24:49 [Worker_10001] Finished in 5988 second(s) Apr-28-09 18:24:49 [Worker_10001] Error: rebuildspamdb failed - Update: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.0.67-log]MySQL server has gone away (SQL-08S01) at /usr/local/assp/assp.pl line 33125 Apr-28-09 18:24:49 [Worker_10001] INFO: RebuildSpamdb removed from queue Apr-28-09 18:24:49 [Worker_10001] Info: RebuildSpamdb Scheduler stopped As you can see it took a lot longer then 5988 seconds. It took 3 hours to complete. This behaviour haven't i seen before. Server has 8Gb of ram, Quad Core proc, so processing power enough dito memory! Begin doorgestuurd bericht: > Van: Pascal Dreissen <[email protected]> > Datum: 28 april 2009 18:28:39 GMT+02:00 > Aan: ASSP mailing list development <[email protected]> > Onderwerp: Rebuildspam problems RC 0.0.20 > > Apr-28-09 18:24:49 [Worker_10001] Finished in 5988 second(s) > Apr-28-09 18:24:49 [Worker_10001] Error: rebuildspamdb failed - > Update: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.0.67-log]MySQL > server has gone away (SQL-08S01) at /usr/local/assp/assp.pl line 33125 > Apr-28-09 18:24:49 [Worker_10001] INFO: RebuildSpamdb removed from > queue > Apr-28-09 18:24:49 [Worker_10001] Info: RebuildSpamdb Scheduler > stopped > > > It takes ages for rebuildspamdb to complete. CPU usage is very low > (0.01) it does not replace the records! > > > Met vriendelijke groet / Best regards, > > Pascal Dreissen > > Virus > Inside > Switch > To > Apple > > > > > Met vriendelijke groet / Best regards, Pascal Dreissen Virus Inside Switch To Apple ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test DISCLAIMER: ******************************************************* This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. This email was multiple times scanned for viruses. There should be no known virus in this email! ******************************************************* ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
