Re: constant crashing - Mailing list pgsql-general

From Tom Lane
Subject Re: constant crashing
Date
Msg-id 533979.1713123045@sss.pgh.pa.us
Whole thread Raw
In response to re: constant crashing  (jack <jack4pg@a7q.com>)
List pgsql-general
jack <jack4pg@a7q.com> writes:
> Here is an excerpt of /var/log/postgresql/postgresql-16-main.log
> 2024-04-14 12:17:43.153 EDT [1227] LOG: server process (PID 7289) was terminated by signal 11: Segmentation fault

That's pretty interesting; it suggests an actual PG bug.
Can you get a stack trace from that?  See

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

Also, it's probably time you showed us the complete DDL definition
for the tables you're working with.  It's fairly hard to believe
this would happen without something rather out-of-the-ordinary
in the definitions.  Or ... do you have any PG extensions installed?

            regards, tom lane



pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: constant crashing
Next
From: jack
Date:
Subject: re: constant crashing