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
