From: | Michael Nolan <htfoot(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with FDW wrapper errors |
Date: | 2020-07-14 17:03:41 |
Message-ID: | CAOzAquL6Fu+6ZfZmu9TEmh4mBgn+QpTYimvqisJKQ-2ddCwWbw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
An application I wrote is being modified by our development team to use a
FDW to a remote MySQL table instead of the postgresql table for a query.
We're getting this error in the logs periodically. Maybe about once every
50,000 queries:
2020-07-14 11:35:22.799 CDT uscf ::1 ERROR: failed to execute the MySQL
query:
Prepared statement needs to be re-prepared
2020-07-14 11:35:22.799 CDT uscf ::1 STATEMENT: select memtp,
('2004-12-18'::date-membirthdt)/365.25 as mage from
memmast_simulant_ratings where memid = '13036134'
If I restart it, it usually goes through, but might fail on that query, but
using different data.
Is this possibly due to transient communication issues between the
postgresql server and the remote MySQL server
If I just trap the error, wait a few seconds and re-issue the query, is
that likely to be sufficient?
--
Mike Nolan
htfoot(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-07-14 17:05:14 | Re: how to "explain" some ddl |
Previous Message | Kenneth Marshall | 2020-07-14 16:42:36 | Re: Same query taking less time in low configuration machine |