Hi all, I use Postgresql 8.3.8 for the ASSP databases. When I try to rebuild the spamdb, the run stops after half the work. This is what the logfile shows (filtered for Worker_10001):
Dec 3 11:44:27 mail assp[23126]: [Worker_10001] RebuildSpamDB-thread started Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Maxfiles: 14000 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' started for spamlog Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' processed 1 files in spamlog Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' started for notspamlog Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' processed 1 files in notspamlog Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' started for correctednotspam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' processed 1 files in correctednotspam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' started for correctedspam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] 'move to num' processed 1 files in correctedspam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] /opt/assp/errors/spam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] File Count:#01112 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Processing... errors/spam with 12 files Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Imported Files:#01112 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Finished in 1 second(s) Dec 3 11:44:27 mail assp[23126]: [Worker_10001] /opt/assp/errors/notspam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] File Count:#011216 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Processing... errors/notspam with 216 files Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Imported Files:#011216 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Finished in 3 second(s) Dec 3 11:44:27 mail assp[23126]: [Worker_10001] /opt/assp/spam Dec 3 11:44:27 mail assp[23126]: [Worker_10001] File Count:#0112,052 Dec 3 11:44:27 mail assp[23126]: [Worker_10001] Processing... spam with 2052 files Dec 3 11:45:01 mail assp[23126]: [Worker_10001] Imported Files:#0112,052 Dec 3 11:45:01 mail assp[23126]: [Worker_10001] Finished in 36 second(s) Dec 3 11:45:01 mail assp[23126]: [Worker_10001] /opt/assp/notspam Dec 3 11:45:01 mail assp[23126]: [Worker_10001] File Count:#0114,193 Dec 3 11:45:01 mail assp[23126]: [Worker_10001] Processing... notspam with 4193 files Dec 3 11:47:09 mail assp[23126]: [Worker_10001] Imported Files:#0114,193 Dec 3 11:47:09 mail assp[23126]: [Worker_10001] Finished in 128 second(s) Dec 3 11:47:10 mail assp[23126]: [Worker_10001] Error: rebuildspamdb failed - Can't call method "fetchrow_arrayref" on an undefined value at /usr/local/share/perl/5.10.0/Tie/RDBM.pm line 166. Dec 3 11:47:10 mail assp[23126]: [Worker_10001] INFO: RebuildSpamdb removed from queue Dec 3 11:47:10 mail assp[23126]: [Worker_10001] Info: RebuildSpamdb Scheduler stopped Dec 3 11:47:10 mail assp[23126]: [Worker_10001] Info: ReStart Scheduler stopped Dec 3 11:47:10 mail assp[23126]: [Worker_10001] Info: starting RebuildSpamdb Scheduler with '32 3 * * *' The file rebuildrun.txt gets touched, but remains at 0 bytes. As far as I read fetchrow_arrayref returns an undefined value either if there is an error or if there are no more rows. Now: does "rebuildspamdb" _think_ there is an error and stop, or is there a real error? How to fix? Best regards Dirk Kulmsee ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test