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
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 |