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
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() |