mysql_fdw crash

From: 066ce286(at)free(dot)fr
To: pgsql-hackers(at)postgresql(dot)org
Subject: mysql_fdw crash
Date: 2018-11-20 10:09:31
Message-ID: 1685704780.1222956404.1542708571533.JavaMail.root@zimbra82-e14.priv.proxad.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I do have a reproductible crash with mysql_fdw when executing a plpgsql function. I'm running pg 11.1 with current mysql_fdw, but I had the same crash with the pg 9.6 and mysql_fdw provided with ubuntu packages.

From psql side :

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

In syslog :

Nov 20 10:52:58 sact2Dev kernel: [322982.294765] postgres[10364]: segfault at 0 ip 00007fc8ab7b5350 sp 00007ffc4312a4f0 error 6 in mysql_fdw.so[7fc8ab7ac000+d000]

I've located the crash cause on the line :

*param_types[i] = exprType(param_expr);

( file mysql_fdw.c ; function prepare_query_params() ; in the forEach() loop)

I've recompiled the fdw with a -g option. Could you please tell me (or point me a documentation) how to have a core dump from the segfaulted lib ; so that I can open it in a debugger to inspect variable contents ?

Or any advice ?

Thank you.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message REIX, Tony 2018-11-20 10:11:30 Shared Memory: How to use SYSV rather than MMAP ?
Previous Message Andres Freund 2018-11-20 09:52:27 Re: [RFC] Removing "magic" oids