[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] sql query with PathId=0 during verify job


Hello Ralf,

I just took my dog out for his late night run.  The nice thing about that is 
that it gave me a chance to think about your problem given your new 
information, and I now am about 95% sure I now know what is going wrong.  

The FFFFFFFA you are seeing is a negative integer, as I previously mentioned.  
In fact, it is a -6, which is exactly the code that Bacula uses to signal a 
heartbeat. 

So, I imagine that my hypothesis #3 is kicking in (a Bacula bug). You most 
likely have heartbeat turned on between the DIR and the FD, and you probably 
have it set it to a low interval.  Unfortunately, the heartbeat during a 
Verify is very likely to create exactly this problem.

The workaround is either to turn off heartbeat in your FD for your Verify jobs 
(not possible on a job by job basis) or set it longer than the time it takes 
to run the verify.

The longterm solution is that Bacula should not use the heartbeat code during 
a Verify.  

Best regards,

Kern

On Monday 24 March 2008 22:20:01 Ralf Gross wrote:
> Ralf Gross schrieb:
> > sql_get.c:73-0 db_get_file_att_record
> > fname=/server/cvsroot/iprep/ANTSRT/SRC/Components/UTA2/ImageRectification
> >OpenGl/ip/ip_hi<FF><FF><FF><FA>ghlevel/src/pelCont.cc,v sql_get.c:127-0
> > Get_file_record JobId=1683 FilenameId=539133 PathId=0 sql_get.c:129-0
> > Query=SELECT FileId, LStat, MD5 FROM File WHERE File.JobId=1683 AND
> > File.PathId=0 AND File.FilenameId=539133 sql_get.c:133-0 get_file_record
> > num_rows=0
> > verify.c:580-0 File not in catalog:
> > /server/cvsroot/iprep/ANTSRT/SRC/Components/UTA2/ImageRectificationOpenGl
> >/ip/ip_hi<FF><FF><FF><FA>ghlevel/src/pelCont.cc,v
>
> Just retried the same job after reboot.
>
> 24-Mar 21:33 VUMEM004-sd JobId 1701: Ready to read from volume "06D124L3"
> on device "LTO3" (/dev/ULTRIUM-TD3). 24-Mar 21:33 VUMEM004-sd JobId 1701:
> Forward spacing Volume "06D124L3" to file:block 4:0. 24-Mar 21:59
> VUMEM004-dir JobId 1701: File:
> /server/cvsroot/iprep/lane_recog/simulation/simulator.pro,v 24-Mar 21:59
> VUMEM004-dir JobId 1701:       st_ino   differ. Cat: 2685916587 File:
> 45057986506511787 24-Mar 21:59 VUMEM004-dir JobId 1701: Fatal error:
> bsock.c:416 DEBUG: Packet size 541261824 too big from "Client:
> VUMEM004-fd:10.60.1 .231. Terminating connection.
> 24-Mar 21:59 VUMEM004-dir JobId 1701: Fatal error: bsock.c:419 Packet size
> too big from "Client: VUMEM004-fd:10.60.1.231:9102. Termin ating
> connection.
>
>
> The packet size 541261824 is the value I always get when a verify jobs
> fails with the bsock error.
>
> bacula-dir debug:
>
> getmsg.c:110-0 bget_dirmsg 140: 130489 1 pinsug5
> /server/cvsroot/iprep/lane_recog/simulation/simulator.pro,v verify.c:570-0
> dird<filed: stream=1
> /server/cvsroot/iprep/lane_recog/simulation/simulator.pro,v verify.c:571-0
> dird<filed: attr=P0C CgF<FF><FF><FF><FA>9Wr IEk B BQu Sg A u4 BAA I BH2lKA
> BH2lKA BH2lKA A A sql_get.c:73-0 db_get_file_att_record
> fname=/server/cvsroot/iprep/lane_recog/simulation/simulator.pro,v
> sql_get.c:127-0 Get_file_record JobId=1683 FilenameId=1929406 PathId=753722
> sql_get.c:129-0 Query=SELECT FileId, LStat, MD5 FROM File WHERE
> File.JobId=1683 AND File.PathId=753722 AND File.FilenameId=1929406
> sql_get.c:133-0 get_file_record num_rows=1
>
>
> Again these <FF><FF><FF><FA> characters, but this time not in the path,
> instead in the attribute field.
>
> Ralf
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Bacula-devel mailing list
> Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/bacula-devel



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.