We may have a problem with deadlock on batch insert.

I have not looked closely, it it appears to be two batch inserts  
running at the same time.

Begin forwarded message:

> From: Jason Dixon <jdixon AT omniti DOT com>
> Date: November 12, 2008 7:39:00 AM PST
> To: Dan Langille <dan AT langille DOT org>
> Cc: bacula-users AT lists.sourceforge DOT net
> Subject: Re: [Bacula-users] Hung on "Dir inserting attributes"
>
> 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
>
> Thanks,
>
> -- 
> Jason Dixon
> OmniTI Computer Consulting, Inc.
> jdixon AT omniti DOT com
> 443.325.1357 x.241

-- 
Dan Langille
http://langille.org/





-------------------------------------------------------------------------
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