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.