DA 1.661 - Internal Error - Failed to load databases list

[ngoisaoso]

When trying to log in to the user I get the message.

Internal Error​

Failed to load databases list

I tried restarting mysql and the list was reloaded but just a few minutes later the same error appeared again. I tried searching for the error but couldn't find anything related. My server is using cloudlinux, mysql 5.7

 

[Zhenyapan]

have you checked mysql status from console? logs?

 

[ngoisaoso]

yes I checked, everything still works, the sites are normal, phpmyadmin can still query the database list

 

[kristian]

Might be this: https://docs.directadmin.com/other-...00-prepared-statement-needs-to-be-re-prepared

 

[ngoisaoso]

Might be this: https://docs.directadmin.com/other-...00-prepared-statement-needs-to-be-re-prepared

The problem has been resolved by your way, thanks for your support

 

[xar123]

With MariaDB 10.3 the same problem.

Already try to set the table_definition_cache but this is not working.

 

[Zhenyapan]

@xar123 https://endoflife.date/mariadb
you are using EOL version, try upgrade to 10.4->10.5->10.6

 

[xar123]

With 10.4 we have the same problem (not EOL).

 

[johannes]

he wrote: "try upgrade to 10.4->10.5->10.6"

 

[xar123]

he wrote: "try upgrade to 10.4->10.5->10.6"

Why? 10.4.33 newest version is from Feb 2024.
https://mariadb.com/kb/en/mariadb-10-4-33-release-notes/

It is a DirectAdmin bug.

 

[ericosman]

Why not update to the latest and greatest ?

Why? 10.4.33 newest version is from Feb 2024.
https://mariadb.com/kb/en/mariadb-10-4-33-release-notes/

It is a DirectAdmin bug.

 

[kristian]

Already try to set the table_definition_cache but this is not working.

And what values did you try before you came to this conclusion?

 

[xar123]

And what values did you try before you came to this conclusion?

SET GLOBAL table_definition_cache = 1600;

 

[Ohm J]

SET GLOBAL table_definition_cache = 1600;

bros, that's value can't change from query. you must put it into my.cnf and fully restart.

 

[xar123]

bros, that's value can't change from query. you must put it into my.cnf and fully restart.

Eh? Check:

Troubleshooting | Directadmin Docs

DirectAdmin Knowledge Base

docs.directadmin.com

 

[floyd]

Why? 10.4.33 newest version is from Feb 2024.
https://mariadb.com/kb/en/mariadb-10-4-33-release-notes/

It is a DirectAdmin bug.

If it were a DA bug then it would be happening with everybody. This is something specific to your server.

 

[floyd]

Even if I only make the folder for the database DA will read it as a database with no users.

 

[kristian]

SET GLOBAL table_definition_cache = 1600;

This might not be enough.

 

[exemaco]

I have this same issue on my servers.

 

[Zhenyapan]

@exemaco in my recent case - there wasn't problem in enhanced skin, was only in evolution skin, solved by updating DA to 1.663