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