Dear All, My database has grown in size to the point where it's now 18GB.
I'd like to see if that can be pruned at all, but unfortunately my box only has 1GB of RAM and dbcheck fails rather horribly with an out of memory error when doing check for orphaned file records: Checking for orphaned File entries. This may take some time! Query failed: SELECT File.FileId,Job.JobId FROM File LEFT OUTER JOIN Job ON (File.JobId=Job.JobId) WHERE Job.JobId IS NULL: ERR=out of memory for query result Even with 20GB of swap this doesn't help in the slightest. I notice that it doesn't use anywhere near that amount of swap before running out of memory, though - perhaps the per-process memory limit is the problem? Has anyone encountered (and more importantly solved) a similar problem in the past? James Cort -- U4EA Technologies http://www.u4eatech.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
