From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: kchaid@hotmail.com
Subject: BUG #18599: server closed the connection unexpectedly
Date: Tue, 03 Sep 2024 23:38:29 +0000
Message-ID: <18599-7e0d56c68f6c3dfc@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18599
Logged by: Karim Chaid
Email address: kchaid@hotmail.com
PostgreSQL version: 16.4
Operating system: rhel 8.9
Description:
I am getting the following message
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
When I run the following query.
scdpdb-# select
scdpdb-# count(*)
scdpdb-# from scdpq01la_raw.GLTRANS glt
scdpdb-# inner join scdpq01la_raw.GLCONTROL glc on
glc.company=glt.company
scdpdb-# and glc.fiscal_year=glt.fiscal_year
scdpdb-# and glc.acct_period=glt.acct_period
scdpdb-# and glc.r_system=glt.r_system
scdpdb-# and glc.je_type=glt.je_type
scdpdb-# and glc.control_group=glt.control_group
scdpdb-# and glc.je_sequence=glt.je_sequence
scdpdb-# inner join scdpq01la_raw.GLSYSTEM gls on
gls.company=glt.to_company
scdpdb-# left outer join scdpq01la_raw.GLNAMES gln on
gln.company=gls.company and gln.acct_unit=glt.acct_unit
scdpdb-# left outer join scdpq01la_raw.GLMASTER glm on
glm.company=glt.company and glm.account=glt.account
scdpdb-# and glm.sub_account=glt.sub_account
scdpdb-# and glm.acct_unit=glt.acct_unit
scdpdb-# left outer join scdpq01la_raw.GLCHARTDTL gdt on
gdt.chart_name=glm.chart_name
scdpdb-# and gdt.account=glm.account
scdpdb-# and gdt.sub_account=glm.sub_account
scdpdb-# left outer join scdpq01la_raw.GLCHARTSUM gcs on
gcs.chart_name=gdt.chart_name
scdpdb-# and gcs.sumry_acct_id=gdt.sumry_acct_id
scdpdb-# left join scdpq01la_raw.L_HGLC hglc on hglc.l_index=glc.l_index
and hglc.type='1'
scdpdb-# and 1=0
scdpdb-# ;
I have a dev environment and I can share config and reproduce it at will.
Regards
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, kchaid@hotmail.com
Subject: Re: BUG #18599: server closed the connection unexpectedly
In-Reply-To: <18599-7e0d56c68f6c3dfc@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