BUG #18412: could not send data to client: Broken pipe

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: inratneshk(at)gmail(dot)com
Subject: BUG #18412: could not send data to client: Broken pipe
Date: 2024-03-27 18:04:04
Message-ID: 18412-e4fd5f026ad1fe52@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18412
Logged by: Ratnesh Kumar
Email address: inratneshk(at)gmail(dot)com
PostgreSQL version: 15.2
Operating system: CentOS Linux release 7.9.2009 (Core)
Description:

Hello Postgres Support Team,
I need your help to identify the issue and apply the fix for it.
I am running few queries from a windows client machine and while running one
query through Application and getting error like below.

2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test LOG: could not send data to client: Broken
pipe
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test CONTEXT: PL/pgSQL function
uspx_alignment_users(xml,xml) line 318 at RAISE
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test STATEMENT: SELECT * FROM
Uspx_Alignment_Users("cb_data" := $1,"cb_configuration" := $2)
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test FATAL: connection to client lost
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test CONTEXT: PL/pgSQL function
uspx_alignment_users(xml,xml) line 318 at RAISE
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test STATEMENT: SELECT * FROM
Uspx_Alignment_Users("cb_data" := $1,"cb_configuration" := $2)
2024-03-27 03:28:50.221 EDT [pid=33124] [txid=0]
[unknown](at)10(dot)120(dot)11(dot)91@test(at)test LOG: disconnection: session time:
0:33:34.610 user=test database=test host=10.120.11.91 port=56976

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-03-27 21:00:59 Re: BUG #18411: Unable to create database with owner on AWS RDS
Previous Message PG Bug reporting form 2024-03-27 17:32:16 BUG #18411: Unable to create database with owner on AWS RDS