pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedINSERT statement going in IPC Wait_event
3+ messages / 3 participants
[nested] [flat]
* INSERT statement going in IPC Wait_event
@ 2023-03-01 20:40 aditya desai <admad123@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: aditya desai @ 2023-03-01 20:40 UTC (permalink / raw)
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: INSERT statement going in IPC Wait_event
@ 2023-03-01 21:36 Andrew Dunstan <andrew@dunslane.net>
parent: aditya desai <admad123@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Andrew Dunstan @ 2023-03-01 21:36 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; Pgsql Performance <pgsql-performance@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: INSERT statement going in IPC Wait_event
@ 2023-03-11 10:37 Samed YILDIRIM <samed@reddoc.net>
parent: aditya desai <admad123@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Samed YILDIRIM @ 2023-03-11 10:37 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
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.
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-03-11 10:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-01 20:40 INSERT statement going in IPC Wait_event aditya desai <admad123@gmail.com>
2023-03-01 21:36 ` Andrew Dunstan <andrew@dunslane.net>
2023-03-11 10:37 ` Samed YILDIRIM <samed@reddoc.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox