Обсуждение: INSERT statement going in IPC Wait_event
Hi All,
Unfortunately I am unable to share a query plan or query.
I have a SQL which is getting called from a web service. At a certain point where it inserts data in the table . Process is going in a hung state. pg_stat_activity shows wait_even='IPC' , wait_even_type=MessageQueueSend. In Webservice log we see I/O error occurred message.
Surprisingly when I run it from PSQL or pgadmin it runs fine.
Has anyone come across this issue? Could you please help?
Regards,
Aditya.
On 2023-03-01 We 15:40, aditya desai wrote:
Hi All,Unfortunately I am unable to share a query plan or query.I have a SQL which is getting called from a web service. At a certain point where it inserts data in the table . Process is going in a hung state. pg_stat_activity shows wait_even='IPC' , wait_even_type=MessageQueueSend. In Webservice log we see I/O error occurred message.Surprisingly when I run it from PSQL or pgadmin it runs fine.
Doesn't this suggest that the problem is probably not with Postgres but with your web service (about which you have given us no information whatsoever)?
cheers
andrew
-- Andrew Dunstan EDB: https://www.enterprisedb.com
Hello Aditya,
How many connections do you have on your PostgreSQL cluster? And, do your webserver and database service run on the same machine/VM?
I would check system logs on the server on which PostgreSQL cluster run.
Best regards.
Samed YILDIRIM
On Wed, 1 Mar 2023 at 22:40, aditya desai <admad123@gmail.com> wrote:
Hi All,Unfortunately I am unable to share a query plan or query.I have a SQL which is getting called from a web service. At a certain point where it inserts data in the table . Process is going in a hung state. pg_stat_activity shows wait_even='IPC' , wait_even_type=MessageQueueSend. In Webservice log we see I/O error occurred message.Surprisingly when I run it from PSQL or pgadmin it runs fine.Has anyone come across this issue? Could you please help?Regards,Aditya.