[MDEV-27599] after restore missing information_schema tables Created: 2022-01-24  Updated: 2022-01-24

Status: Open
Project: MariaDB Server
Component/s: Backup, Information Schema
Affects Version/s: 10.6.5
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Karsten Budde Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: restore
Environment:

centos 7, centos 8


 Description   

Hello,

I have restored the backup from a MariaDB of one server to a second server. I expected all tables in the information_schema to be built on the second server as well. Unfortunately, I find that the following two tables are not present after the restore:
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

Because the two tables are not present, the queries run much slower on the second server.

Why are the two tables not built during the restore?
How can I regenerate the two tables?

with kind regards
Karsten
Generated at Thu Feb 08 09:54:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.