Jason Dixon-6 wrote:
> 
> On Wed, Nov 12, 2008 at 07:07:13AM -0800, Dan Langille wrote:
>>
>> On Nov 11, 2008, at 2:32 PM, Jason Dixon wrote:
>>
>>> We have a new Bacula server (2.4.2 on Solaris 10 x86) that runs fine for
>>> most backup jobs.  However, we've encountered a particular job that
>>> hangs indefinitely with the status "Dir inserting attributes".  It's
>>> important to note that all of our other jobs complete successfully
>>> except this one.
>>
>> What others have said confirmed what I thought.  I too think this job
>> is not hanging.  It is inserting.
> 
> For two days?  This isn't a slow box.  Here is the pg_stat_activity we
> gathered yesterday.  According to our DBA, it was deadlocked as
> exhibited by pids 6192 and 21732 both having ExclusiveLock's.
> 
> http://pastebin.com/f26d96438
> 

Could you ask to your DBA to give us more information about locks ? This
page don't indicate which object is locked.

The last "INSERT INTO File" query doesn't need any exclusive lock (it was
designed in this
way). And postgresql should detect this dead lock situation and rollback
transactions.

Bye

-- 
View this message in context: 
http://www.nabble.com/Hung-on-%22Dir-inserting-attributes%22-tp20450040p20477571.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users