From: "Blum, Kimber" <kimber7@illinois.edu>
To: "pgsql-interfaces@lists.postgresql.org"
	<pgsql-interfaces@lists.postgresql.org>
Subject: Issue with mysql_fdw
Thread-Topic: Issue with mysql_fdw
Thread-Index: AdbOcTk8QjVMs0U4QDOuPwigB5cAjQ==
Date: Wed, 9 Dec 2020 21:29:03 +0000
Message-ID: 
 <DM6PR11MB3594998C2D815126FE44231B96CC0@DM6PR11MB3594.namprd11.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_DM6PR11MB3594998C2D815126FE44231B96CC0DM6PR11MB3594namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 1511bbac-0dd3-4f11-7a55-08d89c897364
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Dec 2020 21:29:03.2223
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 44467e6f-462c-4ea2-823f-7800de5434e3
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 RzH4997mSjUTOX+vLEm07sKB0HxQ2XNB26yGmT83rLbx49nroFaW3bbyi/q8q6499T7zw8YFac4CsfsubDVPVA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR1101MB2106
X-Spam-Details: rule=cautious_plus_nq_notspam policy=cautious_plus_nq score=0
 suspectscore=0 malwarescore=0 phishscore=0 spamscore=0 mlxscore=0
 mlxlogscore=862 lowpriorityscore=0 adultscore=0 bulkscore=0 clxscore=1011
 priorityscore=1501 impostorscore=0 classifier=spam adjust=0 reason=mlx
 scancount=1 engine=8.12.0-2009150000 definitions=main-2012090147
X-Spam-Score: 0
X-Spam-OrigSender: kimber7@illinois.edu
X-Spam-Bar: 
List-Id: <pgsql-interfaces.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-interfaces@lists.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-interfaces>
Precedence: bulk

--_000_DM6PR11MB3594998C2D815126FE44231B96CC0DM6PR11MB3594namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm getting a persistent error when trying to get data from MariaDB to post=
gres via foreign table. Both are on the same server. I'm able to create the=
 server, map a user, and create a foreign table. As soon as I try to select=
 from the foreign table, however, Postgres crashes, and reports this error =
to the log:

kernel: traps: postmaster[8455] general protection ip:7fc8c78bd430 sp:7ffc0=
69d57c0 error:0 in libmysqlclient.so[7fc8c719f000+147e000]

I'm using postgres 12, MariaDB 10.5, and mysql_fdw_12. I've check path, per=
missions and links on the .so file.

Any insight would be greatly appreciated!

Thank you,
Kimber

--_000_DM6PR11MB3594998C2D815126FE44231B96CC0DM6PR11MB3594namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I&#8217;m getting a persistent error when trying to =
get data from MariaDB to postgres via foreign table. Both are on the same s=
erver. I&#8217;m able to create the server, map a user, and create a foreig=
n table. As soon as I try to select from the foreign
 table, however, Postgres crashes, and reports this error to the log:<o:p><=
/o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:.5in">kernel: traps: postmaster=
[8455] general protection ip:7fc8c78bd430 sp:7ffc069d57c0 error:0 in libmys=
qlclient.so[7fc8c719f000+147e000]<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I&#8217;m using postgres 12, MariaDB 10.5, and mysql=
_fdw_12. I&#8217;ve check path, permissions and links on the .so file.
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Any insight would be greatly appreciated!<o:p></o:p>=
</p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thank you,<o:p></o:p></p>
<p class=3D"MsoNormal">Kimber<o:p></o:p></p>
</div>
</body>
</html>

--_000_DM6PR11MB3594998C2D815126FE44231B96CC0DM6PR11MB3594namp_--