Re: [Bacula-users] Backup errors...

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