I do not think you should be running dbcheck and bacula at the same
time. Turn off the director, run dbcheck, turn on the director. If
dbcheck is running slow, you may need to create a few extra temporary
indexes to speed it up.
On 3/26/2010 10:36 AM, Xavier Romero wrote:
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
