|
Hello! We have used bacula for many years and we're totally satisfied. Until now we have used several devices DAT DDS4, DDS5 and Raid, and a old PIII server Now we have a new backup sever (Xeon,1Gb), and a LTO3 DELL PV-124T Autocharger, new bacula 2.2.4 and MySQL 5.0.44. After some test (using one LTO3 Tapes), we have clean (by bacula/etc/drop_mysql_tables, bacula/etc/make_mysql_tables scripts) our MySQL database, and start a seriously backup (using three LTO3 Tapes). When bacula starts sending attrs to MySQL, we get the error display bellow 1) Table "batch" doesn't exists in "make_mysql_tables" script provided by bacula! 2) I've search google; do I need "--enable-batch-insert" at configure time? I've done one compilation with that option, and Table "batch" still doesn't exists in "make_mysql_tables" script provided by bacula! 3) In my old baculas database table "batch" dosen't exists. Is it caused by the new Autocharger device? 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 *** --
|
------------------------------------------------------------------------- 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
