[GENERAL] deadlock debug methodology

2008-05-22 Thread antiochus antiochus
Hi All, I have a deadlock situation, two transactions waiting on each other to complete. Based on the details below, does anyone have recommendations for me. Thanks. Regards, A. I am using: rpm -qa|grep postgres compat-postgresql-libs-4-2PGDG.rhel5_x86_64 postgresql-server-8.2.6-1PGDG.rhel5 po

Re: [GENERAL] deadlock debug methodology question

2008-05-22 Thread antiochus antiochus
On Thu, May 22, 2008 at 4:20 PM, Bill Moran <[EMAIL PROTECTED]> wrote: > > Please don't top-post. I've attempted to reconstruct the conversation > flow. > > In response to "antiochus antiochus" <[EMAIL PROTECTED]>: > > > > On Th

Re: [GENERAL] deadlock debug methodology question

2008-05-22 Thread antiochus antiochus
22, 2008 at 2:57 PM, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "antiochus antiochus" <[EMAIL PROTECTED]>: > > > > I have a deadlock situation, two transactions waiting on each other to > > complete. Based on the details below, would anyone ha

[GENERAL] deadlock debug methodology question

2008-05-22 Thread antiochus antiochus
Hi All, I have a deadlock situation, two transactions waiting on each other to complete. Based on the details below, would anyone have recommendations for me, please? Regards, A. I am using: rpm -qa|grep postgres compat-postgresql-libs-4-2PGDG.rhel5_x86_64 postgresql-server-8.2.6-1PGDG.rhel5 p