Hi, 01.10.2007 11:50,, Alejandro Alfonso wrote:: > 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!
That table should be created as necessary, as it's only a temporary table. > 2) I've search google; do I need "--enable-batch-insert" at configure > time? I'd rather suggest to disable it first and try again; the build seems to be a bit problematic there... > I've done one compilation with that option, and Table "batch" > still doesn't exists in "make_mysql_tables" script provided by bacula! See above - this is normal. > 3) In my old baculas database table "batch" dosen't exists. Is it caused > by the new Autocharger device? No, by the batch insert feature. By the way - in the thread "Funny problem..." on the -devel list, there was a suggested patch which you might want to try. Also, if you want the underlying problem fixed, I suggest you collect the necessary information and have a look at bugs.bacula.org. I'm not sure this problem is reported there, but you could start that bug report... Arno > 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 *** > > -- > Patrocinador Oficial: > > > * Alejandro Alfonso Fernandez > Responsable Área Corporativa * [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > http://www.telecyl.com/ > > Proción 7, Portales 1-2 Edificio América II > 28023 Madrid > Tfn: 902 60 25 55 - Fax: 91 452 18 08 Juan García Hortelano, 43 > Edificio Telecyl > 47014 Valladolid > Tfn: 902 60 25 55 - Fax: 983 428 223 > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > 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 -- 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
