Hello!
i've benn an idiot! I should search before in bugs.bacula.org
http://bugs.bacula.org/view.php?id=965
Best regards!
Bye!
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 ***
--
 |
Patrocinador
Oficial: |
 |
| |
Alejandro Alfonso Fernandez
Responsable Área Corporativa
|
[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
|
|
