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?
What about increase /tmp partition?
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 ***
--
------------------------------------------------------------------------
* Alejandro Alfonso Fernandez
Responsable Área Corporativa * [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
http://www.telecyl.com/
------------------------------------------------------------------------
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
