search

charles-001 / dolphie

Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL
https://pypi.org/project/dolphie/
GNU General Public License v3.0
589 stars 36 forks source link

View "sys.innodb_lock_waits" references invalid table(s) or column(s) #43

Closed klemenb closed 7 months ago

klemenb commented 7 months ago

Hi!

I am seeing the error in the attachment when trying to connect to a MySQL server with the following version string:

mysql Ver 8.0.34-26 for Linux on x86_64 (Percona Server (GPL), Release '26', Revision '5dfee7bd')

Dolphie 3.1.2 worked and after upgrading to 3.3.1 this error appeared. I am guessing this is related to the added "Locks" panel in 3.2.0.

failed_to_execute_query

charles-001 commented 7 months ago

Hi @klemenb - can you check to see if you have the sys schema and if so, provide the output of SHOW CREATE TABLE sys.innodb_lock_waits? This isn't an issue with Dolphie, but with your MySQL server and/or permissions.

klemenb commented 7 months ago

Hi, sorry, yes the schema was there and I thought it was something that either Percona changed or was changed in a recent MySQL release. It was indeed a permission issue. Sorry for spamming your issue tracker and thank you for your help.

charles-001 commented 7 months ago

No worries! Feel free to reach out anytime :)