Hello, 01.10.2007 12:58,, 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
That's quite a size, but Bacula should be able to handle that. The catalog backend might be a bit under stress, though. >>> 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 So there's space left. > 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: That's bad. > The question is... that table was created by bacula or by mysql? This is a MySQL table, so MySQL created it. Of course it did because the DIR issued a statement like 'create temporary table blah...', but the work is done by MySQL. > What about increase /tmp partition? That might help, but from what I can see above there's space on that partition, so this should not be the origin of this problem. Perhaps it would be better to start analyzing what MySQL does. A look into MySQLs log files might reveal a more basic problem. Arno > Thanks again! > >> Hi, >> >>> 1) Table "batch" doesn't exists in "make_mysql_tables" script provided >>> by bacula! > >> >>> Thanks in advance! >>> >>> 28-Sep 23:13 poe-dir: BeforeJob: run command "/usr/local/bacula/doSms.sh >>> Inicio FileServerFull Traer_DAT Full" >>> 28-Sep 23:13 poe-dir: Start Backup JobId 1, >>> Job=FileServerFull.2007-09-28_23.13.09 >>> 28-Sep 23:18 poe-dir: Using Device "LTO3_DELL" >>> 28-Sep 23:18 poe-sd: 3301 Issuing autochanger "loaded? drive 0" command. >>> 28-Sep 23:18 poe-sd: 3302 Autochanger "loaded? drive 0", result is Slot 1. >>> 28-Sep 23:18 poe-sd: Wrote label to prelabeled Volume "FileServerFull01" >>> on device "LTO3_DELL" (/dev/nst0) >>> 01-Oct 03:28 poe-sd: Spooling data again ... >>> [...] >>> 01-Oct 04:02 poe-sd: Job write elapsed time = 52:40:19, Transfer rate = >>> 7.261 M bytes/second >>> 01-Oct 04:02 poe-sd: Committing spooled data to Volume >>> "FileServerFull03". Despooling 8,243,721,756 bytes ... >>> 01-Oct 04:05 poe-sd: Despooling elapsed time = 00:02:50, Transfer rate = >>> 48.49 M bytes/second >>> 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 >>> (2036153,1,'/raid/files/usuario01/ProyectoX/X/css/','071.css','gQ BADAp4 >>> IHt B T6 Po A BBm BAA Q BG2xPz BG2xPz BG2yww A A >>> C','FSzqZbiVCyGfAIdIkrTfsw') failed: >>> 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: >>> catreq.c:478 Attribute create error. sql_update.c:454 Update failed: >>> affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND >>> StorageId=1 AND MediaId!=3 >>> 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 >>> (2036154,1,'/raid/files/usuario01/ProyectoX/X/css/','070.css','gQ BADAp5 >>> IHt B T6 Po A BS0 BAA Q BG2xPz BG2xPz BG2yww A A >>> C','nU4ZTR7fa5ULberAoYT3rg') failed: >>> 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: >>> catreq.c:478 Attribute create error. sql_update.c:454 Update failed: >>> affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND >>> StorageId=1 AND MediaId!=3 >>> 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 >>> (2036155,1,'/raid/files/usuario01/ProyectoX/X/css/','069.css','gQ BADAp6 >>> IHt B T6 Po A BJK BAA Q BG2xPz BG2xPz BG2yww A A >>> C','EvsK8raW7YYwP14dxjgzug') failed: >>> 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: >>> catreq.c:478 Attribute create error. sql_update.c:454 Update failed: >>> affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND >>> StorageId=1 AND MediaId!=3 >>> 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 >>> (2036156,1,'/raid/files/usuario01/ProyectoX/X/css/','068.css','gQ BADAp7 >>> IHt B T6 Po A CUi BAA Y BG2xPz BG2xPz BG2yww A A >>> C','jFl6MXs0fFPF7mAX6aoa3g') failed: >>> 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: >>> catreq.c:478 Attribute create error. sql_update.c:454 Update failed: >>> affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND >>> StorageId=1 AND MediaId!=3 >>> 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Error: Bacula >>> poe-dir 2.2.4 (14Sep07): 01-Oct-2007 04:08:49 >>> Build OS: i686-pc-linux-gnu gentoo >>> JobId: 1 >>> Job: FileServerFull.2007-09-28_23.13.09 >>> Backup Level: Full >>> Client: "fileserver-fd" 2.2.4 (14Sep07) >>> i686-pc-linux-gnu,gentoo, >>> FileSet: "FileServerFull" 2007-09-28 23:13:09 >>> Pool: "FileServerFull" (From Job resource) >>> Storage: "LTO3_DELL" (From Job resource) >>> Scheduled time: 28-Sep-2007 23:13:06 >>> Start time: 28-Sep-2007 23:18:41 >>> End time: 01-Oct-2007 04:08:49 >>> Elapsed time: 2 days 4 hours 50 mins 8 secs >>> Priority: 1 >>> FD Files Written: 2,078,249 >>> SD Files Written: 0 >>> FD Bytes Written: 1,376,452,747,911 (1.376 TB) >>> SD Bytes Written: 0 (0 B) >>> Rate: 7236.6 KB/s >>> Software Compression: None >>> VSS: no >>> Encryption: no >>> Volume name(s): FileServerFull01|FileServerFull02|FileServerFull03 >>> Volume Session Id: 1 >>> Volume Session Time: 1191012478 >>> Last Volume Bytes: 120,928,969,728 (120.9 GB) >>> Non-fatal FD errors: 0 >>> SD Errors: 0 >>> FD termination status: OK >>> SD termination status: Running >>> Termination: *** Backup Error *** > > -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
