BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16717
Logged by:          Emmanuel O
Email address:      [hidden email]
PostgreSQL version: 11.9
Operating system:   debian stretch
Description:        

Hi guys,

this behaviour drives me crazy, using a data wrapper (mysql_fdw) from a
mariadb instance to initialize a postgres foreign table, i'm facing the
following issue after running the fifth's time the same "import foreign
schema..." command.
The max_stack_depth is high (128Mb), but any change of this parameter have
no effect, it fails at the #5 try

api=# DROP FOREIGN TABLE IF EXISTS import_zzz.zzz_contact_event_prod;IMPORT
FOREIGN SCHEMA "schema_V3" limit to ( "zzz_contact__prod") FROM SERVER
mysql_zzz INTO import_zzz;
NOTICE:  foreign table "zzz_contact_event_prod" does not exist, skipping
DROP FOREIGN TABLE
IMPORT FOREIGN SCHEMA
api=# DROP FOREIGN TABLE IF EXISTS import_zzz.zzz_contact_event_prod;IMPORT
FOREIGN SCHEMA "schema_V3" limit to ( "zzz_contact__prod") FROM SERVER
mysql_zzz INTO import_zzz;
DROP FOREIGN TABLE
IMPORT FOREIGN SCHEMA
api=# DROP FOREIGN TABLE IF EXISTS import_zzz.zzz_contact_event_prod;IMPORT
FOREIGN SCHEMA "schema_V3" limit to ( "zzz_contact__prod") FROM SERVER
mysql_zzz INTO import_zzz;
DROP FOREIGN TABLE
IMPORT FOREIGN SCHEMA
api=# DROP FOREIGN TABLE IF EXISTS import_zzz.zzz_contact_event_prod;IMPORT
FOREIGN SCHEMA "schema_V3" limit to ( "zzz_contact__prod") FROM SERVER
mysql_zzz INTO import_zzz;
DROP FOREIGN TABLE
IMPORT FOREIGN SCHEMA
api=# DROP FOREIGN TABLE IF EXISTS import_zzz.zzz_contact_event_prod;IMPORT
FOREIGN SCHEMA "schema_V3" limit to ( "zzz_contact__prod") FROM SERVER
mysql_zzz INTO import_zzz;
DROP FOREIGN TABLE
PANIC:  ERRORDATA_STACK_SIZE exceeded
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.

Any help will be quite appreciated,

Thanks
Emmanuel

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> this behaviour drives me crazy, using a data wrapper (mysql_fdw) from a
> mariadb instance to initialize a postgres foreign table, i'm facing the
> following issue after running the fifth's time the same "import foreign
> schema..." command.

Can't reproduce any such thing with postgres_fdw, so I suppose this
is a bug in mysql_fdw, not IMPORT FOREIGN SCHEMA generally.  It is
probably dealing with some situation by catching an error, and then
forgetting to clean up after itself (with FlushErrorState).  I'd
suggest reporting this to whatever the contact address for mysql_fdw
is.

                        regards, tom lane