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