'performance_schema.session_variables' doesn't exist

choi.pw's profile image choi.pw posted 1 month ago in General Permalink

When trying to connect to mysql version 5.7.41, the error below occurs. "performance_schema.session_variables doesn't exist" I know this is a problem with the server, but I cannot fix it because I do not have DB management rights. I can access and query this database with DBeaver, but the same error occurs when i try to access system info. Is there a way to connect and query using heidisql?

ansgar's profile image ansgar posted 1 month ago Permalink

Do you probably have a startup script in your HeidiSQL session (on the "Advanced" tab)? If yes, does it probably contain a session related query?

choi.pw's profile image choi.pw posted 1 month ago Permalink

no. The startup script is empty, and an error occurs when connecting.

ansgar's profile image ansgar posted 1 month ago Permalink

Probably the server has a broken data directory, from an earlier migration?

ansgar's profile image ansgar posted 1 month ago Permalink

Does the error occur also with other clients?

choi.pw's profile image choi.pw posted 1 month ago Permalink

I tried using 'dbeaver' as another client. There is no problem when connecting from dbeaver, and queries are executed normally. However, when trying to access system information such as 'Session Status' and 'Global Status', the error 'performance_schema.session_variables doesn't exist' occurs.

choi.pw's profile image choi.pw posted 1 month ago Permalink

It is assumed that information may have been corrupted during the process of updating the mysql version. However, as I said above, I am not a DB administrator, so I cannot solve this problem. Services using the DB are currently operating normally. So, I think there is no problem in the connection and query process.

ansgar's profile image ansgar posted 1 month ago Permalink

Then it's obviously a corrupted MySQL update which caused the non existing table.

I am just reading on stackoverflow, your server administrator may try to upgrade to solve the issue:

mysql_upgrade -u root -p --force

Afterwards restart the server.

choi.pw's profile image choi.pw posted 1 month ago Permalink

Thanks for the comment. It's unfortunate that I can't fix the server problem myself, but I have no choice but to suggest it to the administrator. Thank you again for your comment.

Please login to leave a reply, or register at first.