Re: Segmentation Fault Issue in PostgreSQL 13.4

From: Pierre Forstmann <pierre(dot)forstmann(at)gmail(dot)com>
To: Veerendra Pulapa <veerendra(dot)pulapa(at)ashnik(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Segmentation Fault Issue in PostgreSQL 13.4
Date: 2024-06-22 08:21:10
Message-ID: CAM-sOH9KmbrmjmQ2Yijuof3YvxB1QB7VsaYAXXVWDB3Kh1gwhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

have encountered similar issues in my own code when developing C
extension. Root cause is very likely a bug in the cause_segfault() C
function.
You should compile your C code in debug mode and use debugger to check what
invalid memory access you have in your code.
See
https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Identifying_the_backend_to_connect_to

Le sam. 22 juin 2024 à 09:05, Veerendra Pulapa <veerendra(dot)pulapa(at)ashnik(dot)com>
a écrit :

> Hello Folks,
>
> I’m encountering a segmentation fault issue in PostgreSQL 13.4 when
> executing a specific function (cause_segfault()). The server process
> terminates with a signal 11 (Segmentation fault), but the database service
> continues running without a full shutdown.
>
> Details:
>
> • PostgreSQL Version: 13.4
> • Environment: RHEL 8
> • Steps to Reproduce:
> 1. Create function: CREATE FUNCTION cause_segfault() RETURNS void AS
> 'cause_segfault', 'cause_segfault' LANGUAGE C STRICT;
> 2. Execute function: SELECT cause_segfault();
>
> Observations:
>
> • Logs indicate the segmentation fault (LOG: server process (PID XXX) was
> terminated by signal 11: Segmentation fault).
>
> Request for Assistance:
>
> • Has anyone encountered similar issues with PostgreSQL 13.4?
> • Are there known bugs or fixes related to segmentation faults in recent
> PostgreSQL versions?
> • Any advice on troubleshooting or resolving this issue would be greatly
> appreciated.
>
> Thank you for your assistance.
>
> Get Outlook for iOS <https://aka.ms/o0ukef>
>
>
> *______________________________________________________________________________________This
> email may contain confidential, privileged or copyright material and is
> solely for the use of the intended recipient(s). If you are not the
> rightful recipient of this email, please delete this email immediately and
> inform the recipient. *
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Ikram 2024-06-22 10:59:42 Re: My Database getting dropped anonymously
Previous Message Vijaykumar Jain 2024-06-22 08:17:01 Re: Segmentation Fault Issue in PostgreSQL 13.4