BUG #18599: server closed the connection unexpectedly

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18599: server closed the connection unexpectedly
Дата
Msg-id 18599-7e0d56c68f6c3dfc@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18599: server closed the connection unexpectedly
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления: