John Lockard wrote:
> 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
Nice to hear that. A quick an easy fix ;-)
--
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
