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