Hi,
this weekend I had several successful jobs but for some of them there is no entry in the database. There are no errors in the bacula-log. There are some errors in the pgsql log before and after a job finished but I don't know if they are related:
2011-12-17 02:02:47 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 02:11:35 CET ERROR: table "delcandidates" does not exist
2011-12-17 02:11:35 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 02:23:06 CET WARNING: pgstat wait timeout
2011-12-17 02:23:46 CET ERROR: table "delcandidates" does not exist
2011-12-17 02:23:46 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 03:00:37 CET ERROR: table "delcandidates" does not exist
2011-12-17 03:00:37 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 04:17:05 CET ERROR: table "delcandidates" does not exist
2011-12-17 04:17:05 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 04:39:02 CET ERROR: table "delcandidates" does not exist
2011-12-17 04:39:02 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 05:23:22 CET ERROR: table "delcandidates" does not exist
2011-12-17 05:23:22 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 05:25:27 CET ERROR: table "delcandidates" does not exist
2011-12-17 05:25:27 CET STATEMENT: DROP TABLE DelCandidates
2011-12-17 07:09:42 CET LOG: checkpoints are occurring too frequently (27 seconds apart)
2011-12-17 07:09:42 CET HINT: Consider increasing the configuration parameter "checkpoint_segments".
2011-12-17 07:09:47 CET ERROR: table "delcandidates" does not exist
2011-12-17 07:09:47 CET STATEMENT: DROP TABLE DelCandidates
According to [url=http://www.mail-archive.com/bacula-users < at > lists.sourceforge.net/msg18806.html]http://www.mail-archive.com/bacula-users < at > lists.sourceforge.net/msg18806.html[/url] the "delcandidates" can be ignored. The "checkpoint" messages occur regularly and I have not had any problems yet. So the only thing left is "pgstat wait timeout" but this is hours before the first job finished. All in all there are 5 of 14 jobs in the catalog. The rest is missing. So I'm at a loss here. Any hints?
dir: 5.0.3
sd: 5.0.3
fd: mostly 5.0.3, one client 5.2.1
Postgresql: 8.4 running on Debian squeeze
