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
