This was for Bacula 2.2.5 running on RHEL4 with MySQL 4.1. I do happen to
have a pool named "Monthly Pool". You are correct, there is a quoting
error. If I adjust the quotes, I can get the query to work. Do I need to
rename my pool?
Jay
On Dec 5, 2007 10:38 AM, Arno Lehmann <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 05.12.2007 15:10,, jay wrote::
> > All,
> >
> > I had an email sitting in my inbox this morning, that was generated by
> > Bacula, but I'm not sure why or how.
> >
> > 04-Dec 11:32 cbtsscdb-dir JobId 0: Fatal error: sql_get.c:595
> > sql_get.c:595 query SELECT
> >
> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId
> > FROM Pool WHERE Pool.Name=''Monthly' failed:
>
> If the above line really is the complete SQL query (I'm always a bit
> unsure with MySQL...) then there is a qouting error.
>
> > You have an error in your SQL syntax; check the manual that corresponds
> > to your MySQL server version for the right syntax to use near 'Monthly''
> > at line 1
> >
> > I see where the SQL failed, but what generated this? Is it a bug?
>
> Most probably, yes.
>
> Which version of Bacula was this?
>
> > All
> > my backups completed successfully, so its a bit perplexing. Did a job
> > generated this or did it come from a daemon?
>
> The JobId given in the mail is 0, which would indicate your DIR issued
> that query. Perhaps in searching for a usable volume, or as part of a
> query command. I don't know, but if the time the mail was generated
> doesn't tell you anything, a search for this query in the source might
> turn up something. Of course, there will be some variable substitution
> in the source code... I couldn't find anything except cats/sql_list.c,
> which look good. Unless you've got a Pool named 'Monthly (which might
> be a problem).
>
> > Should I be concerned? Thanks
>
> A bit... if similar errors are generated again, I would investigate.
> Otherwise, especially if you're unsure which task generated the query,
> it's a problem to find the cause for this SQL error.
>
> Arno
>
> > Jay
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> -------------------------------------------------------------------------
> > SF.Net email is sponsored by: The Future of Linux Business White Paper
> > from Novell. From the desktop to the data center, Linux is going
> > mainstream. Let it simplify your IT future.
> > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> --
> Arno Lehmann
> IT-Service Lehmann
> www.its-lehmann.de
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell. From the desktop to the data center, Linux is going
> mainstream. Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
