John Lockard wrote:
> Hi all,
>
> Saw this last night. What would cause these Fatal errors?
>
> Server: Linux 2.6.18 x86_64
> Bacula Version:
> Server: 3.0.0
> Client: 2.4.4 (SPARC Solaris 8)
> Filesystem: just under 1TB
>
> Thanks for any help,
> John
>
> 13-May 22:25 tibor-sd JobId 3833: Labeled new Volume "Monthly-SIN-0363" on
> device "Storage_Array_1" (/data1/bacula/storage).
> 13-May 22:25 tibor-sd JobId 3833: Wrote label to prelabeled Volume
> "Monthly-SIN-0363" on device "Storage_Array_1" (/data1/bacula/storage)
> 13-May 22:25 tibor-sd JobId 3833: New volume "Monthly-SIN-0363" mounted on
> device "Storage_Array_1" (/data1/bacula/storage) at 13-May-2009
> +22:25.
> 13-May 23:06 tibor-dir JobId 3833: Fatal error: sql_create.c:731
> sql_create.c:731 insert INSERT INTO batch VALUES
> +(10889201,3833,'/data0/projects/polisci/corpora/bills/106txt-preferred/','106-H.R.01517.txt','gAD4
> Fs06a IG0 B CY9 HYs A iV CAA I BKCOdS
> +BDxzxI BDxz0l A A C','GanvMb5SbMX2t+HvG3WbzQ') failed:
> Incorrect key file for table '/tmp/#sqlbf2_fe_0.MYI'; try to repair it
> 13-May 23:06 tibor-dir JobId 3833: sql_create.c:731 INSERT INTO batch VALUES
> +(10889201,3833,'/data0/projects/polisci/corpora/bills/106txt-preferred/','106-H.R.01517.txt','gAD4
> Fs06a IG0 B CY9 HYs A iV CAA I BKCOdS
> +BDxzxI BDxz0l A A C','GanvMb5SbMX2t+HvG3WbzQ')
> 13-May 23:06 tibor-dir JobId 3833: Fatal error: catreq.c:488 Attribute create
> error. sql_get.c:1029 Media record for Volume "Monthly-SIN-0363"
> +not found.
> 13-May 23:06 tibor-sd JobId 3833: Job Tangra-Data0.2009-05-11_05.15.00_47
> marked to be canceled.
> 13-May 23:06 tibor-sd JobId 3833: Fatal error: fd_cmds.c:181 FD command not
> found: and variable operation maintenance and replacement for such
> +Central Arizona Project
> water.
> `f WATER RIGHTS UNAFFECTED BY USE OR NON-USE- The lack of use of water by
> the Nation or the use or lack of use of water by any person or
> +entity with whom the Nation enters into a contract for an exchange lease
> option for the lease or disposition of water pursuant to subsection c
> +shall not diminish reduce or impair.
> `1 the water rights of the Nation as established under this title or any
> other applicable law; or
> `2 any use rights
>
>
>
>
Has you use the batch insert enable, could you verify that during the backup
you doesn't go out of space in /tmp ( indicate in
trace )
I suspect your big jobs are creating a too big sql big ( temp db ) and have no
more space ...
You should tell mysql to write tmp table to another place with fast disk and
lot of space.
--
Bruno Friedmann
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
