[GENERAL] Deadlocks - Mailing list pgsql-general

From Martin Moore
Subject [GENERAL] Deadlocks
Date
Msg-id 0C9CB0D9-3D98-4917-B9B5-83313785C04C@avbrief.com
Whole thread Raw
Responses Re: [GENERAL] Deadlocks  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Hi, I’m having issues with deadlocks.

v9.6 on Debian Jessie.

I have a number of ‘select’ functions which for logging purposes also call another fn that inserts a record into a
‘logging’table. 

However, even with only 1 or 2 users making very infrequent calls to the parent fn, deadlocks are occurring. I’m hoping
there’ssomething I’m unaware of as this shouldn’t happen! 

What could this be? I don’t have any logs at present as I removed the insert statement some time ago, but need to get
thisissue resolved. 

Thanks,

Martin.




pgsql-general by date:

Previous
From: marcelo
Date:
Subject: Re: [GENERAL] Porting libpq to QNX 4.25
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Deadlocks