Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXU7z-0005UT-TG for pgsql-performance@arkaria.postgresql.org; Wed, 01 Mar 2023 21:36:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXU7y-0002NL-Ao for pgsql-performance@arkaria.postgresql.org; Wed, 01 Mar 2023 21:36:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXU7y-0002NB-0R for pgsql-performance@lists.postgresql.org; Wed, 01 Mar 2023 21:36:46 +0000 Received: from relay6-d.mail.gandi.net ([2001:4b98:dc4:8::226]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXU7v-00061p-9x for pgsql-performance@lists.postgresql.org; Wed, 01 Mar 2023 21:36:45 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id 5D365C0002; Wed, 1 Mar 2023 21:36:39 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------0TwisC0YldQWJBGwCjMonQif" Message-ID: Date: Wed, 1 Mar 2023 16:36:38 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: INSERT statement going in IPC Wait_event Content-Language: en-US To: aditya desai , Pgsql Performance References: From: Andrew Dunstan In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0TwisC0YldQWJBGwCjMonQif Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------0TwisC0YldQWJBGwCjMonQif Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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

--------------0TwisC0YldQWJBGwCjMonQif--