pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18599: server closed the connection unexpectedly
8+ messages / 5 participants
[nested] [flat]
* BUG #18599: server closed the connection unexpectedly
@ 2024-09-03 23:38 PG Bug reporting form <noreply@postgresql.org>
2024-09-04 05:05 ` Re: BUG #18599: server closed the connection unexpectedly David Rowley <dgrowleyml@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: PG Bug reporting form @ 2024-09-03 23:38 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: kchaid@hotmail.com
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
2024-09-03 23:38 BUG #18599: server closed the connection unexpectedly PG Bug reporting form <noreply@postgresql.org>
@ 2024-09-04 05:05 ` David Rowley <dgrowleyml@gmail.com>
2024-09-04 21:09 ` Re: BUG #18599: server closed the connection unexpectedly Thomas Munro <thomas.munro@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: David Rowley @ 2024-09-04 05:05 UTC (permalink / raw)
To: kchaid@hotmail.com; pgsql-bugs@lists.postgresql.org
On Wed, 4 Sept 2024 at 11:58, PG Bug reporting form
<noreply@postgresql.org> wrote:
> 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.
Thanks for the report. The query text is not really enough to go on
unless it also comes with the schema and a way to recreate the crash.
> I have a dev environment and I can share config and reproduce it at will.
Ideally, if you could use that to get a stack trace include that here.
Alternatively, an even better option would be a self-contained series
of SQL statements that we can run and recreate the issue.
David
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
2024-09-03 23:38 BUG #18599: server closed the connection unexpectedly PG Bug reporting form <noreply@postgresql.org>
2024-09-04 05:05 ` Re: BUG #18599: server closed the connection unexpectedly David Rowley <dgrowleyml@gmail.com>
@ 2024-09-04 21:09 ` Thomas Munro <thomas.munro@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Thomas Munro @ 2024-09-04 21:09 UTC (permalink / raw)
To: David Rowley <dgrowleyml@gmail.com>; +Cc: kchaid@hotmail.com; pgsql-bugs@lists.postgresql.org
On Wed, Sep 4, 2024 at 5:05 PM David Rowley <dgrowleyml@gmail.com> wrote:
> Ideally, if you could use that to get a stack trace include that here.
> Alternatively, an even better option would be a self-contained series
> of SQL statements that we can run and recreate the issue.
If this is an ARM CPU (like AWS Graviton), and if setting "jit=off"
fixes it, then it could be the known LLVM relocation issue[1], for
which we have a candidate solution pending. I mention this wild guess
because we're seeing a lot of these reports and it'd be much easier to
check that than figure out stack traces etc.
[1] https://www.postgresql.org/message-id/flat/CAO6_Xqr63qj%3DSx7HY6ZiiQ6R_JbX%2B-p6sTPwDYwTWZjUmjsYBg%4...
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
@ 2024-09-06 02:31 Karim Chaid <kchaid@hotmail.com>
2024-09-06 22:18 ` Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Karim Chaid @ 2024-09-06 02:31 UTC (permalink / raw)
To: Thomas Munro <thomas.munro@gmail.com>; +Cc: David Rowley <dgrowleyml@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
This is a VM based on IBM hardware.
I can dig into the HW side if needed.
I will check on jit setting and see if the issue can be resolved.
As for the stack trace, there is no coredump and the search i did, look ile the pg_backtrace may be the way to go. I have downloaded the sourxe code from GitHub but looking for the make command options for rhel8.9 and any dependencies.
Regards
Sent from my iPhone
> On Sep 4, 2024, at 4:10 PM, Thomas Munro <thomas.munro@gmail.com> wrote:
>
> On Wed, Sep 4, 2024 at 5:05 PM David Rowley <dgrowleyml@gmail.com> wrote:
>> Ideally, if you could use that to get a stack trace include that here.
>> Alternatively, an even better option would be a self-contained series
>> of SQL statements that we can run and recreate the issue.
>
> If this is an ARM CPU (like AWS Graviton), and if setting "jit=off"
> fixes it, then it could be the known LLVM relocation issue[1], for
> which we have a candidate solution pending. I mention this wild guess
> because we're seeing a lot of these reports and it'd be much easier to
> check that than figure out stack traces etc.
>
> [1] https://www.postgresql.org/message-id/flat/CAO6_Xqr63qj%3DSx7HY6ZiiQ6R_JbX%2B-p6sTPwDYwTWZjUmjsYBg%4...
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
2024-09-06 02:31 Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
@ 2024-09-06 22:18 ` Karim Chaid <kchaid@hotmail.com>
2024-09-07 06:22 ` Re: BUG #18599: server closed the connection unexpectedly Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 8+ messages in thread
From: Karim Chaid @ 2024-09-06 22:18 UTC (permalink / raw)
To: Thomas Munro <thomas.munro@gmail.com>; +Cc: David Rowley <dgrowleyml@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
One quick test recommended for me is to convert the columnar tables to heap.
Upon doing it, the query worked. It was hung in the first attempt but in the second attempt worked fine.
I would to get this resolved for columnar setup.
Regards
Sent from my iPhone
> On Sep 5, 2024, at 9:31 PM, Karim Chaid <kchaid@hotmail.com> wrote:
>
> This is a VM based on IBM hardware.
> I can dig into the HW side if needed.
> I will check on jit setting and see if the issue can be resolved.
> As for the stack trace, there is no coredump and the search i did, look ile the pg_backtrace may be the way to go. I have downloaded the sourxe code from GitHub but looking for the make command options for rhel8.9 and any dependencies.
> Regards
>
> Sent from my iPhone
>
>>> On Sep 4, 2024, at 4:10 PM, Thomas Munro <thomas.munro@gmail.com> wrote:
>>>
>>> On Wed, Sep 4, 2024 at 5:05 PM David Rowley <dgrowleyml@gmail.com> wrote:
>>> Ideally, if you could use that to get a stack trace include that here.
>>> Alternatively, an even better option would be a self-contained series
>>> of SQL statements that we can run and recreate the issue.
>>
>> If this is an ARM CPU (like AWS Graviton), and if setting "jit=off"
>> fixes it, then it could be the known LLVM relocation issue[1], for
>> which we have a candidate solution pending. I mention this wild guess
>> because we're seeing a lot of these reports and it'd be much easier to
>> check that than figure out stack traces etc.
>>
>> [1] https://www.postgresql.org/message-id/flat/CAO6_Xqr63qj%3DSx7HY6ZiiQ6R_JbX%2B-p6sTPwDYwTWZjUmjsYBg%4...
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
2024-09-06 02:31 Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
2024-09-06 22:18 ` Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
@ 2024-09-07 06:22 ` Magnus Hagander <magnus@hagander.net>
2024-09-10 19:29 ` Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Magnus Hagander @ 2024-09-07 06:22 UTC (permalink / raw)
To: Karim Chaid <kchaid@hotmail.com>; +Cc: Thomas Munro <thomas.munro@gmail.com>; David Rowley <dgrowleyml@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Sat, Sep 7, 2024, 00:18 Karim Chaid <kchaid@hotmail.com> wrote:
> One quick test recommended for me is to convert the columnar tables to
> heap.
> Upon doing it, the query worked. It was hung in the first attempt but in
> the second attempt worked fine.
>
> I would to get this resolved for columnar setup.
>
There's no such thing as columnar in PostgreSQL. You must be using either a
fork or some pretty complex extension. It seems pretty clear that the
problem is in that code and not in PostgreSQL since it goes away when you
switch off it. So you're probablh better off reporting it to them.
/Magnus
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: BUG #18599: server closed the connection unexpectedly
2024-09-06 02:31 Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
2024-09-06 22:18 ` Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
2024-09-07 06:22 ` Re: BUG #18599: server closed the connection unexpectedly Magnus Hagander <magnus@hagander.net>
@ 2024-09-10 19:29 ` Karim Chaid <kchaid@hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Karim Chaid @ 2024-09-10 19:29 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: Thomas Munro <thomas.munro@gmail.com>; David Rowley <dgrowleyml@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Thank you all in helping with this issue.
Regards
________________________________
From: Magnus Hagander <magnus@hagander.net>
Sent: Saturday, September 7, 2024 1:22 AM
To: Karim Chaid <kchaid@hotmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>; David Rowley <dgrowleyml@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18599: server closed the connection unexpectedly
On Sat, Sep 7, 2024, 00:18 Karim Chaid <kchaid@hotmail.com<mailto:kchaid@hotmail.com>> wrote:
One quick test recommended for me is to convert the columnar tables to heap.
Upon doing it, the query worked. It was hung in the first attempt but in the second attempt worked fine.
I would to get this resolved for columnar setup.
There's no such thing as columnar in PostgreSQL. You must be using either a fork or some pretty complex extension. It seems pretty clear that the problem is in that code and not in PostgreSQL since it goes away when you switch off it. So you're probablh better off reporting it to them.
/Magnus
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: BUG #18599: server closed the connection unexpectedly
@ 2024-09-06 02:35 Karim Chaid <kchaid@hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Karim Chaid @ 2024-09-06 02:35 UTC (permalink / raw)
To: David Rowley <dgrowleyml@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2024-09-10 19:29 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-03 23:38 BUG #18599: server closed the connection unexpectedly PG Bug reporting form <noreply@postgresql.org>
2024-09-04 05:05 ` David Rowley <dgrowleyml@gmail.com>
2024-09-04 21:09 ` Thomas Munro <thomas.munro@gmail.com>
2024-09-06 02:31 Re: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
2024-09-06 22:18 ` Karim Chaid <kchaid@hotmail.com>
2024-09-07 06:22 ` Magnus Hagander <magnus@hagander.net>
2024-09-10 19:29 ` Karim Chaid <kchaid@hotmail.com>
2024-09-06 02:35 RE: BUG #18599: server closed the connection unexpectedly Karim Chaid <kchaid@hotmail.com>
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