I’m getting a persistent error when trying to get data from MariaDB to postgres via foreign table. Both are on the same server. I’m able to create the server, map a user, and create a foreign table. As soon as I try to select from the foreign table, however, Postgres crashes, and reports this error to the log:
kernel: traps: postmaster[8455] general protection ip:7fc8c78bd430 sp:7ffc069d57c0 error:0 in libmysqlclient.so[7fc8c719f000+147e000]
I’m using postgres 12, MariaDB 10.5, and mysql_fdw_12. I’ve check path, permissions and links on the .so file.
Any insight would be greatly appreciated!
Thank you,
Kimber