On Wed, 7 Feb 2007, James Cort wrote: > 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:
More ram is cheap, if your box can fit it... > > 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. Assuming Mysql: Look in /etc/my.cnf for "memlock" and comment it out, or set it to FALSE. The memlock directive prevents Mysql being swapped out. > 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? This should probably go in the "infrequently asked questions" somewhere as it took several days to solve why mysql was refusing to startup. AB ------------------------------------------------------------------------- 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