Broken information_schema on Aurora MySQL 8.0 3.06

0

I hope someone has some ideas on how to resolve the following issue I'm facing.

Here's the setup:

  • 8.0.mysql_aurora.3.06.0 cluster with a writer and a reader instance(db.r7g.large)
  • PHP web application using a database on the cluster(~2GB) using the DB reader endpoint
  • another PHP application which refreshes some of the tables with a total of ~5mil rows via the DB writer endpoint, using:
INSERT INTO :tmpTableName VALUES (value1, value2, value3, ...);
RENAME TABLE :tableName TO :oldTableName, :tmpTableName TO :tableName;
DROP TABLE :oldTableName;

Unfortunately after the refresh PHP app finishes, we get the following error on the DB reader:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.table' doesn't exist.

while the table is fully functional on the DB writer.

The error disappears after DB reader reboot.

Any help will be greatly appreciated!

asked 16 days ago104 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions