0

I'm moving from MySql to MariaDB and I have several databases using federated tables. Everything works fine in the MariaDB but when the server restarts, all federated tables stop working as if the remote server's entry doesn't exists on the local MariaDB server.

After every restart the servers' entries remain in the servers table in the mysql db. If I try to add them again with the CREATE SERVER command, I get an error as if they exist. If I try to drop them with DROP SERVER, I get an error as if they don't exist.

The only way to make it work again is to manually remove the entries from the server table with DELETE FROM servers and create them again with the command CREATE SERVER. How can I make those configurations persistent?

I've searched extensible and couldn't find any solution or mention about this issue. The tables work fine in MySql. The logs doesn't mention anything related to the FederatedX engine between restarts. I'm using MariaDB 10.3.18 on CentOS 7.

Enrico Dias
  • 1,417
  • 9
  • 21
  • PS: This issue occurs with the FederatedX plugin only. – Enrico Dias Sep 19 '19 at 18:52
  • I don't see it happen on 10.3.18. Could you please create a complete test case and file a bug report at jira.mariadb.org? – elenst Sep 19 '19 at 21:12
  • @elenst I just found out that this issue only occurs if the servers table is using the InnoDB engine. With MyISAM or Aria engine it works normally. I'll file a bug report. – Enrico Dias Sep 21 '19 at 19:16

1 Answers1

0

I just found that this issue only occurs if the servers table is using the InnoDB engine. Changing it to MyISAM or Aria solves the problem.

For some reason my server was installed with the wrong engine for this table.

Edit: bug report here.

Enrico Dias
  • 1,417
  • 9
  • 21