From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: inratneshk@gmail.com
Subject: BUG #18412: could not send data to client: Broken pipe
Date: Wed, 27 Mar 2024 18:04:04 +0000
Message-ID: <18412-e4fd5f026ad1fe52@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18412
Logged by: Ratnesh Kumar
Email address: inratneshk@gmail.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]@10.120.11.91@test@test LOG: could not send data to client: Broken
pipe
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown]@10.120.11.91@test@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]@10.120.11.91@test@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]@10.120.11.91@test@test FATAL: connection to client lost
2024-03-27 03:28:50.218 EDT [pid=33124] [txid=227405892]
[unknown]@10.120.11.91@test@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]@10.120.11.91@test@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]@10.120.11.91@test@test LOG: disconnection: session time:
0:33:34.610 user=test database=test host=10.120.11.91 port=56976
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, inratneshk@gmail.com
Subject: Re: BUG #18412: could not send data to client: Broken pipe
In-Reply-To: <18412-e4fd5f026ad1fe52@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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