pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command
2+ messages / 2 participants
[nested] [flat]

* BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command
@ 2020-11-13 18:14 PG Bug reporting form <noreply@postgresql.org>
  2020-11-13 19:03 ` Re: BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-11-13 18:14 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: emmanuel.ona@seetickets.fr

The following bug has been logged on the website:

Bug reference:      16717
Logged by:          Emmanuel O
Email address:      emmanuel.ona@seetickets.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command
  2020-11-13 18:14 BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command PG Bug reporting form <noreply@postgresql.org>
@ 2020-11-13 19:03 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2020-11-13 19:03 UTC (permalink / raw)
  To: emmanuel.ona@seetickets.fr; +Cc: pgsql-bugs@lists.postgresql.org

PG Bug reporting form <noreply@postgresql.org> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-11-13 19:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-13 18:14 BUG #16717: ERRORDATA_STACK_SIZE exceeded after 5 times of the same command PG Bug reporting form <noreply@postgresql.org>
2020-11-13 19:03 ` Tom Lane <tgl@sss.pgh.pa.us>

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