On Fri, May 15, 2009 at 01:30:57PM +0200, Bruno Friedmann wrote:
> 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.
Hi Bruno,
No, I didn't have batch insert enabled. I've now recompiled with.
I think you may be entirely correct on the tmpdir setting in MySQL,
I've relocated the tmpdir location.
I've just started one of my large jobs. We'll see if these changes
fix my problems.
Thanks,
John
--
"If you take out the killings, Washington actually
has a very, very low crime rate." - Marion Barry
-------------------------------------------------------------------
John M. Lockard | U of Michigan - School of Information
Unix and Security Admin | 1214 SI North - 1075 Beal Ave.
jlockard AT umich DOT edu | Ann Arbor, MI 48109-2112
www.umich.edu/~jlockard | 734-615-8776 | 734-647-8045 FAX
-------------------------------------------------------------------
------------------------------------------------------------------------------
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
|
