pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
6+ messages / 4 participants
[nested] [flat]
* BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
@ 2021-05-13 14:08 PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: PG Bug reporting form @ 2021-05-13 14:08 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: kamalvarun2004@gmail.com
The following bug has been logged on the website:
Bug reference: 17007
Logged by: varun kamal
Email address: kamalvarun2004@gmail.com
PostgreSQL version: 12.2
Operating system: RHEL 7.5
Description:
Dear Team,
We are facing an issue once in 2 days that Postgres instance crashes with
following error
"server process (PID XXXX) was terminated by signal 11: Segmentation fault"
with following query.
DETAIL: Failed process was running: SELECT NULL AS TABLE_CAT, n.nspname AS
TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,
(i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct
JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN
pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN (SELECT
i.indexrelid, i.indrelid, i.indisprimary,
information_schema._pg_expandarray(i.indkey) AS keys FROM
pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid =
i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE
true AND ct.relname = '<REL_NAME>' AND i.indisprimary ORDER BY table_name,
pk_name, key_seq
Regards,
Varun
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
@ 2021-05-13 14:41 ` David G. Johnston <david.g.johnston@gmail.com>
2021-05-13 15:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: David G. Johnston @ 2021-05-13 14:41 UTC (permalink / raw)
To: kamalvarun2004@gmail.com <kamalvarun2004@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Thursday, May 13, 2021, PG Bug reporting form <noreply@postgresql.org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17007
> Logged by: varun kamal
> Email address: kamalvarun2004@gmail.com
> PostgreSQL version: 12.2
> Operating system: RHEL 7.5
> Description:
>
> Dear Team,
>
> We are facing an issue once in 2 days that Postgres instance crashes with
> following error
>
>
You need to upgrade to a supported version (12.7 in your major version
line).
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
@ 2021-05-13 15:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-05-13 16:54 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault varun kamal <kamalvarun2004@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2021-05-13 15:41 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: kamalvarun2004@gmail.com <kamalvarun2004@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, May 13, 2021, PG Bug reporting form <noreply@postgresql.org>
> wrote:
>> PostgreSQL version: 12.2
>> We are facing an issue once in 2 days that Postgres instance crashes with
>> following error
> You need to upgrade to a supported version (12.7 in your major version
> line).
Yeah, that would certainly be the first thing to try. If the problem is
still there, we'd really need quite a bit more information to diagnose
it. A stack trace from the point of the crash would be quite helpful:
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
Even better would be if you can reduce the problem to a self-contained
test case, though I realize that might be hard.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
2021-05-13 15:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault Tom Lane <tgl@sss.pgh.pa.us>
@ 2021-05-13 16:54 ` varun kamal <kamalvarun2004@gmail.com>
2021-05-15 07:39 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault varun kamal <kamalvarun2004@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: varun kamal @ 2021-05-13 16:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-bugs@lists.postgresql.org
Many thanks Tom and David.
We will try to upgrade to supported version.
Regards,
Varun
On Thu, May 13, 2021, 9:11 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > On Thursday, May 13, 2021, PG Bug reporting form <noreply@postgresql.org
> >
> > wrote:
> >> PostgreSQL version: 12.2
> >> We are facing an issue once in 2 days that Postgres instance crashes
> with
> >> following error
>
> > You need to upgrade to a supported version (12.7 in your major version
> > line).
>
> Yeah, that would certainly be the first thing to try. If the problem is
> still there, we'd really need quite a bit more information to diagnose
> it. A stack trace from the point of the crash would be quite helpful:
>
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>
> Even better would be if you can reduce the problem to a self-contained
> test case, though I realize that might be hard.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
2021-05-13 15:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault Tom Lane <tgl@sss.pgh.pa.us>
2021-05-13 16:54 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault varun kamal <kamalvarun2004@gmail.com>
@ 2021-05-15 07:39 ` varun kamal <kamalvarun2004@gmail.com>
2021-05-15 15:15 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: varun kamal @ 2021-05-15 07:39 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-bugs@lists.postgresql.org
Dear Tom and David,
Kindly help me to understand below points.
1. Is it known bug in this particular version (12.2).
2. Upgrading to 12.7 will resolve this issue.
Regards,
Varun
On Thu, May 13, 2021, 10:24 PM varun kamal <kamalvarun2004@gmail.com> wrote:
> Many thanks Tom and David.
>
> We will try to upgrade to supported version.
>
> Regards,
> Varun
>
> On Thu, May 13, 2021, 9:11 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> "David G. Johnston" <david.g.johnston@gmail.com> writes:
>> > On Thursday, May 13, 2021, PG Bug reporting form <
>> noreply@postgresql.org>
>> > wrote:
>> >> PostgreSQL version: 12.2
>> >> We are facing an issue once in 2 days that Postgres instance crashes
>> with
>> >> following error
>>
>> > You need to upgrade to a supported version (12.7 in your major version
>> > line).
>>
>> Yeah, that would certainly be the first thing to try. If the problem is
>> still there, we'd really need quite a bit more information to diagnose
>> it. A stack trace from the point of the crash would be quite helpful:
>>
>>
>> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>>
>> Even better would be if you can reduce the problem to a self-contained
>> test case, though I realize that might be hard.
>>
>> regards, tom lane
>>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault David G. Johnston <david.g.johnston@gmail.com>
2021-05-13 15:41 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault Tom Lane <tgl@sss.pgh.pa.us>
2021-05-13 16:54 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault varun kamal <kamalvarun2004@gmail.com>
2021-05-15 07:39 ` Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault varun kamal <kamalvarun2004@gmail.com>
@ 2021-05-15 15:15 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2021-05-15 15:15 UTC (permalink / raw)
To: varun kamal <kamalvarun2004@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Saturday, May 15, 2021, varun kamal <kamalvarun2004@gmail.com> wrote:
> Dear Tom and David,
>
> Kindly help me to understand below points.
>
> 1. Is it known bug in this particular version (12.2).
> 2. Upgrading to 12.7 will resolve this issue.
>
You are welcome to scan the release notes to figure out whether the
described behavior was seen and fixed in the last year plus. But when we
say releases are unsupported the expectation is that bug reports against
those releases are expected to be ignored (though exceptions do arise).
If you could provide a self-contained reproducible test case I’m sure
someone would be willing to run that against both the older and newer
versions.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-05-15 15:15 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-13 14:08 BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault PG Bug reporting form <noreply@postgresql.org>
2021-05-13 14:41 ` David G. Johnston <david.g.johnston@gmail.com>
2021-05-13 15:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-05-13 16:54 ` varun kamal <kamalvarun2004@gmail.com>
2021-05-15 07:39 ` varun kamal <kamalvarun2004@gmail.com>
2021-05-15 15:15 ` David G. Johnston <david.g.johnston@gmail.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