From: Lucas B. C. <lb...@bn...> - 2012-03-22 12:24:47
|
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. |