>>>>> On Thu, 22 Mar 2012 13:24:30 +0100, Lucas B Cohen said: > > On 2012.03.22 13:12, Martin Simmons wrote: > >>>>>> On Wed, 21 Mar 2012 23:01:02 +0100, Lucas B Cohen said: > > >> with one of my (multiple, and otherwise working) > >> media pools, the director fails to find a usable volume for use with a > >> backup job > >> > >> Washington-dir: sql_find.c:323-0 fnextvol=SELECT > >> MediaId,VolumeName,<snip> FROM Media WHERE PoolId=5 AND MediaType='LTO2 > >> Ultrium' AND Enabled=1 AND VolStatus='Append' ORDER BY LastWritten IS > >> NULL,LastWritten DESC,MediaId LIMIT 1 > >> Washington-dir: sql_find.c:331-0 item=1 got=0 > >> > >> 'got=0' means the query returned 0 rows. But copying and pasting the > >> exact same query in fact returns the expected result of the tape I'm > >> expecting > > > > Seems very strange. Is it repeatable, i.e. does the backup still fail to > > find > > a volume after your manual query has returned that volume? > > Absolutely. Restarting storage and director daemons doesn't help either.
Which database backend are you using? I can think of three possible causes. 1. Bug in the database. 2. Bug in Bacula. 3. Bacula's query is somehow different from yours. __Martin ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
