On Fri, May 15, 2009 at 04:28:23PM -0400, John Lockard wrote:
> 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
This indeed took care of my problems. I will guess that it
was the relocation of the MySQL tmpdir, but I implemented
both changes at the same time, so can't be 100% sure.
I am running a job right now where the temp DB is around
4G in size, which would have WAY overfilled the original
location's space.
-John
--
(In this one, Pinky is smart.)
Brain: Pinky, Are you pondering what I'm pondering?
Pinky: Yes I am.
-------------------------------------------------------------------
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
|