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