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® 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
