Hi, what you encounter is the batch-insert option ( choosen at compilation time
)
Try to search manual for more description.
The most usual case is there's no more place to /tmp or where mysql writes tmp
table.
Try to watch your space disk during the backup, you will find the culprits.
in your case -> table '/tmp/#sql1941_1c_0.MYI';
Riho Lodi wrote:
> Hi!
>
> Bacula must make backup to the DAT72 tape, but I get following message
> what includes errors what I don't understand. Can anyone explain please.
>
> 10-okt 01:00 server02-dir JobId 458: Start Backup JobId 458,
> Job=ntserver.2008-10-10_01.00.21
> 10-okt 01:00 server02-dir JobId 458: Using Device "DAT72"
> 10-okt 01:00 server02-sd JobId 458: Wrote label to prelabeled Volume
> "thursday" on device "DAT72" (/dev/st0)
> 10-okt 01:05 ntserver-fd JobId 458: Generate VSS snapshots.
> Driver="VSS Win 2003", Drive(s)="E"
> 10-okt 01:18 server02-dir JobId 458: Fatal error: sql_create.c:732
> sql_create.c:732 insert INSERT INTO batch VALUES
> (7054,458,'e:/ShareFiles/arendus/Mudelid.
> Styles/PTA/Pta/051pta/','ALBANIUM-4.FH10','A A IH/ B A A A EwE A A
> BIUaOZ BB5Xqq BIS7Xl A A M','0') failed:
> Incorrect key file for table '/tmp/#sql1941_1c_0.MYI'; try to repair it
> 10-okt 01:18 server02-dir JobId 458: Fatal error: catreq.c:408
> Attribute create error. 10-okt 01:18 server02-sd JobId 458: Job
> ntserver.2008-10-10_01.00.21 marked to be canceled.
> 10-okt 01:18 server02-sd JobId 458: Job write elapsed time = 00:18:04,
> Transfer rate = 2.642 M bytes/second
> 10-okt 01:18 server02-sd JobId 458: Job ntserver.2008-10-10_01.00.21
> marked to be canceled.
> 10-okt 01:18 server02-sd JobId 458: Job ntserver.2008-10-10_01.00.21
> marked to be canceled.
> 10-okt 01:18 server02-sd JobId 458: Job ntserver.2008-10-10_01.00.21
> marked to be canceled.
> 10-okt 01:18 server02-sd JobId 458: Job ntserver.2008-10-10_01.00.21
> marked to be canceled.
> 10-okt 01:24 ntserver-fd JobId 458: Fatal error:
> ../../filed/backup.c:892 Network send error to SD. ERR=Input/output error
> 10-okt 01:18 server02-dir JobId 458: Fatal error: sql_create.c:732
> sql_create.c:732 insert INSERT INTO batch VALUES
> (7055,458,'e:/ShareFiles/arendus/Mudelid.
> Styles/PTA/Pta/051pta/','ALBANIUM.FH10','A A IH/ B A A A E0O A A BIUaOZ
> BBB6/c BIS7Xl A A M','0') failed:
> Incorrect key file for table '/tmp/#sql1941_1c_0.MYI'; try to repair it
> 10-okt 01:18 server02-dir JobId 458: Fatal error: sql.c:368 Attribute
> create error. 10-okt 01:24 ntserver-fd JobId 458: Error:
> ../../lib/bsock.c:306 Write error sending 64726 bytes to Storage
> daemon:192.168.1.42:9103: ERR=Input/output error
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "FSRM
> Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete):
> "System Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "FRS
> Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "IIS
> Metabase Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "Dhcp
> Jet Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete):
> "Event Log Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete):
> "MSDEWriter", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete):
> "Registry Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "COM+
> REGDB Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "WINS
> Jet Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "DFS
> Replication service writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete):
> "NTDS", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:25 ntserver-fd JobId 458: VSS Writer (BackupComplete): "WMI
> Writer", State: 0x1 (VSS_WS_STABLE)
> 10-okt 01:20 server02-dir JobId 458: Fatal error: sql_get.c:359
> sql_get.c:359 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media
> WHERE JobMedia.JobId=458 AND JobMedia.MediaId=Media.MediaId GROUP BY
> VolumeName ORDER BY 2 ASC failed:
> Got error 28 from storage engine
> 10-okt 01:20 server02-dir JobId 458: Error: Bacula server02-dir 2.2.8
> (26Jan08): 10-okt -2008 01:20:14
> Build OS: i486-pc-linux-gnu debian lenny/sid
> JobId: 458
> Job: ntserver.2008-10-10_01.00.21
> Backup Level: Full
> Client: "ntserver-fd" 2.2.8 (26Jan08)
> Linux,Cross-compile,Win32
> FileSet: "Ntserver Set" 2008-07-22 23:05:00
> Pool: "ThursdayPool" (From Run pool override)
> Storage: "DAT72" (From Job resource)
> Scheduled time: 10-okt -2008 01:00:00
> Start time: 10-okt -2008 01:00:03
> End time: 10-okt -2008 01:20:14
> Elapsed time: 20 mins 11 secs
> Priority: 10
> FD Files Written: 7,267
> SD Files Written: 7,059
> FD Bytes Written: 2,866,257,740 (2.866 GB)
> SD Bytes Written: 2,864,133,119 (2.864 GB)
> Rate: 2366.9 KB/s
> Software Compression: 21.6 %
> VSS: yes
> Storage Encryption: no
> Volume name(s): Volume Session Id: 10
> Volume Session Time: 1223457227
> Last Volume Bytes: 2,866,655,232 (2.866 GB)
> Non-fatal FD errors: 1
> SD Errors: 0
> FD termination status: Error
> SD termination status: Canceled
> Termination: *** Backup Error ***
>
>
>
--
Bruno Friedmann
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|