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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: emmanuel(dot)ona(at)seetickets(dot)fr
Subject: BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command
Date: 2020-11-13 18:14:26
Message-ID: 16717-990bd4d9bb55acab@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16717
Logged by: Emmanuel O
Email address: emmanuel(dot)ona(at)seetickets(dot)fr
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andy S 2020-11-13 18:30:39 Re: BUG #16714: INSERT ON CONFLICT DO UPDATE fails to infer constraint if it's not at top-level partition
Previous Message PG Bug reporting form 2020-11-13 16:11:42 BUG #16716: postgresql11-devel pckage from Refreshing service 'spacewalk' complains about missing