[Bacula-users] PostgreSQL & dbcheck query

Hi all,

I’ve detected serious problems on my PostgreSQL to manage following query

SELECT Filename.FilenameId,File.FilenameId FROM Filename LEFT OUTER JOIN File ON (Filename.FilenameId=File.FilenameId) WHERE File.FilenameId IS NULL LIMIT 300000

Causing the whole Bacula to stop working since it needs to lock tables for inserting attributes. I had to kill the query after 2 whole days running... I believe it is related to the execution of

15 16 * * * /opt/bacula/sbin/dbcheck -c /opt/bacula/etc/bacula-dir.conf -f –b

(1 processor –out of 4- at 100% with postmaster)

My count(*) for Filename is 345721, and for File is 27851725.

These are normal values? It may run fine in a default PostgreSQL installation?

I disabled the cron right now but I’m not sure how shall I proceed.

CentOS 5.4

PostgreSQL 8.4.2

Bacula 3.0.2

(same server)

Xeon quadcore E5320 1.86GHZ

6 GB RAM

RAID1 SAS Disks

Thank you very much,

Xavier Romero.

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users