>and the error is due to a timeout during the "delete" so

use a faster DB server

Thomas



Von:    "Grayhat" <gray...@gmx.net>
An:     "ASSP development mailing list" <assp-test@lists.sourceforge.net>
Datum:  11.03.2012 16:07
Betreff:        Re: [Assp-test] Assp 2.0 12068 Crashing very freqent




> Matti... given that I'm facing the very same kind of issues; could you
> please
> (please !!! :D) detail the steps you took to solve this ?

Different experience here; the rebuild "randomly" crashes if the corpus
(spam/notspam folders) contains more than 14000 files and/or contains
files w/o subject (that is "--*.*") removing those and trimming the corpus
down to 8...9000 files does the trick and the rebuild works or at least,
if doesn't crash the ASSP main process until...

2012-03-11 07:20:42 [Worker_10001] Start populating Spamdb with 137865 
records -
 Bayesian check is now disabled!
2012-03-11 07:20:42 [Worker_10001] Try to lock Spamdb database in 5 
second(s)
2012-03-11 07:20:47 [Worker_10001] Database import started for table 
spamdb
2012-03-11 07:21:17 [Worker_10001] Error: rebuildspamdb failed - Database 
delete
 all statement failed: Can't Execute Command 'delete from spamdb'
2012-03-11 07:21:17 [Worker_10001] INFO: RebuildSpamdb removed from queue

and the error is due to a timeout during the "delete" so, definitely we're 

facing
a couple of bugs here; I even tried a number of tricks (with the DB) to no 

luck,
the only way to avoid such a timeout was to wipe (truncate table...) the 
spamdb
but, by the way, that isn't exactly a good thing


------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
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!
*******************************************************


------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test

Reply via email to