Huh, It started here:
Apr-28-09 15:10:35 [Worker_10001] RebuildSpamDB started 15:10 Op 28 apr 2009, om 19:25 heeft Thomas Eckardt/eck het volgende geschreven: >> 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 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
