It looks like the DB-connection is gone at this point. Please try 2.0.1_RC0.6.09 if available.
btw.: how is DB connection in Pg - socket or pipe based? Thomas "Dirk Kulmsee" <kulm...@capricomp.de> 03.12.2009 13:04 Bitte antworten an ASSP development mailing list <assp-test@lists.sourceforge.net> An "'ASSP development mailing list'" <assp-test@lists.sourceforge.net> Kopie Thema [Assp-test] ASSP 2.01_RC0.6.08 / Pg DB / rebuildspamdb stops 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 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! ******************************************************* ------------------------------------------------------------------------------ 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
