BUG #18599: server closed the connection unexpectedly

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: kchaid(at)hotmail(dot)com
Subject: BUG #18599: server closed the connection unexpectedly
Date: 2024-09-03 23:38:29
Message-ID: 18599-7e0d56c68f6c3dfc@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: 18599
Logged by: Karim Chaid
Email address: kchaid(at)hotmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2024-09-04 05:05:01 Re: BUG #18599: server closed the connection unexpectedly
Previous Message PG Bug reporting form 2024-09-01 19:00:01 BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()