> and, by the way, crashing the perl process
retried and it worked... until it reached the point in which it imports
the spamdb data into the DB, at that point the rebuild bombed again
(but this time assp kept running) with the following
<====================================================>
2012-03-07 01:26:33 [Worker_10001] Error: rebuildspamdb failed -
Database delete all statement failed: Can't Execute Command 'delete
from spamdb'
Package : DBD::ADO::st
Filename : C:/Perl/site/lib/DBD/ADO.pm
Line : 1244
Last error : -2147217871
OLE exception from "Microsoft OLE DB Provider for ODBC Drivers":
[Microsoft][SQL Server Native Client 10.0]Query timeout expired
Win32::OLE(0.1709) error 0x80040e31
in METHOD/PROPERTYGET "Execute"
Description : [Microsoft][SQL Server Native Client
10.0]Query timeout expired HelpContext :
HelpFile :
NativeError :
Number : -2147217871
Source : Microsoft OLE DB Provider for ODBC Drivers
SQLState : S1T00
at sub main::importDB line 120 thread 2
2012-03-07 01:26:33 [Worker_10001] INFO: RebuildSpamdb removed from
queue 2012-03-07 01:26:33 [Worker_10001] Info: RebuildSpamdb Scheduler
stopped 2012-03-07 01:26:34 [Worker_10001] Info: starting RebuildSpamdb
Scheduler with '15 1 * * *'
<====================================================>
so I decided to bite the bullet and to manually empty the spamdb table
and it sounds like the import is running now
May I humbly suggest to replace that "delete from spamdb" with a
(faster) "truncate table spamdb" ?
------------------------------------------------------------------------------
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
