From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: emmanuel.ona@seetickets.fr
Subject: BUG #16633: Foreign data wrapper mysql-fdw issue
Date: Thu, 24 Sep 2020 08:46:59 +0000
Message-ID: <16633-3ec02076d6cb6dc8@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16633
Logged by: Emmanuel O
Email address: emmanuel.ona@seetickets.fr
PostgreSQL version: 11.9
Operating system: Debian GNU/Linux 10 (buster)
Description:
Hi
i'm facing an issue with PG11 using the mysql_fdw with a remote Mariadb
Column Store database (10.2.10-MariaDB-log Columnstore 1.1.2-1)
Requesting a simple select on a foreign table the error message is
postgres=# select * from mysql_foreign_table1 limit 5;
ERROR: failed to execute the MySQL query:
Commands out of sync; you can't run this command now
the select is still requesting on the MariaCS server until the PG session is
closed
i'm in trouble to see that this select runs well with this environment:
PG11/debian Stretch
but not with:
PG11/debian Buster
PG12/debian Buster
A Mysql client on the PG server requests with no issues in all cases
Thanks a lot
Emmanuel
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, emmanuel.ona@seetickets.fr
Subject: Re: BUG #16633: Foreign data wrapper mysql-fdw issue
In-Reply-To: <16633-3ec02076d6cb6dc8@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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