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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users