On Monday 01 October 2007 12:58:27 Alejandro Alfonso wrote: > Thank you for the fast answer! > > Um... maybe the problem is related with my server? Its a big backup > (about 1'7 Tb, many small files), and 770Gb of SQL sentences > > >>01-Oct 04:05 poe-sd: Sending spooled attrs to the Director. Despooling > >> *****767,610,414***** bytes ... > >> 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: > >> sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES > > My /tmp partition its like this: > > poe etc # df -h > Filesystem Size Used Avail Use% Mounted on > /dev/sda4 67G 8.9G 58G 14% / > udev 505M 2.8M 502M 1% /dev > /dev/sda2 976M 531M 446M 55% /tmp > shm 505M 0 505M 0% /dev/shm > > And there's a problem in that partition: > >>Incorrect key file for table '/tmp/#sql1439_10_0.MYI';try to repair it > >>01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: > > The question is... that table was created by bacula or by mysql? >
temp tables are, I think, created in /tmp with mysql. So if you have to despool a lot of data, all will go into the temp table in /tmp. 500Mb free is probably much too small. It would explain why it says the table is corrupted and you have to repair it. I don't see a link with Bug #965. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
