MySQL Workbench - Tables could not be fetched
Versie door Jeroen Strompf (overleg | bijdragen) op 27 jan 2021 om 17:18 (Nieuwe pagina aangemaakt met '== Problem == On one beautiful afternoon in Januari 2021, MySQL Worbench greeted me with these worrying messages, when I opened my oh so precious database: <pre>...')
Problem
On one beautiful afternoon in Januari 2021, MySQL Worbench greeted me with these worrying messages, when I opened my oh so precious database:
Tables could not be fetched Views could not be fetched Stored procedures could not be fetched Functions could not be fetched
Some sources suggested running mysql_upgrade
, but that routine really doesn't seem to exist anymore.
Cause
The cause of the problem: A faulty view that referred to a column that no longer existed.
Solution
- Copy the content of the view to a text editor
- Delete the view
- Restart MySQL Workbench
- Recreate the view.
Just correcting the view didn't seem to be working: After waiting for a little while, I killed MySQL Workbench.