Bacula-users

[Bacula-users] Jobs OK but not in catalog

2011-12-19 08:52:08
Subject: [Bacula-users] Jobs OK but not in catalog
From: C.Keschnat AT internet-mit-iQ DOT de
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 19 Dec 2011 14:22:37 +0100
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 http://www.mail-archive.com/bacula-users AT lists.sourceforge DOT net/msg18806.html 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
------------------------------------------------------------------------------
Learn Windows Azure Live!  Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for 
developers. It will provide a great way to learn Windows Azure and what it 
provides. You can attend the event by watching it streamed LIVE online.  
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] Jobs OK but not in catalog, C . Keschnat <=