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 <[EMAIL PROTECTED]> > Date: November 12, 2008 7:39:00 AM PST > To: Dan Langille <[EMAIL PROTECTED]> > Cc: bacula-users@lists.sourceforge.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. > [EMAIL PROTECTED] > 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
