errno: 168 "Unknown (generic) error from engine"

[mosenth]

hi,
i have this error in cpanel since upgraded miaradb to the last version,
rename query dosnt work and when i export a database and import right there again, i have this error too:
Error on rename of (table name) 1025 - 71c-4a830' (errno: 168 "Unknown (generic) error from engine")

 

[vanessa]

I'd first suggest checking the MySQL/MariaDB error logs in /var/lib/mysql/$hostname.err - there can be quite a few things that cause this.

 

[mosenth]

thanks but checked it before,
there is no file with err format in that location or any errorlog file.

 

[vanessa]

Then check in /var/log. Or adjust my.cnf to log errors to a specific file, try the conversion again, and see if anything is logged.

 

[mosenth]

i found mysqld.log,
there is a lot of account in this server(+200) and this erros in the latest lines right after the error:
[Warning] InnoDB: Recalculation of persistent statistics requested for table `database_name`.`table_name` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
and i see this a lot:
[ERROR] InnoDB: Column last_update in table mysql.innodb_table_stats is BINARY(4) NOT NULL but should be INT UNSIGNED NOT NULL
this log totally consists of these two errors.

 

[vanessa]

You may have to drop and recreate that table:

server/scripts/mysql_system_tables.sql at 10.11 · MariaDB/server

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stab...

github.com

Errors in the innodb engine could be the cause of the generic engine error you are getting. The warnings can be fixed too by creating the innodb schema.

mysql error: Table "mysql"."innodb_table_stats" not found

I'm getting the following error in mysql 5.6 community edition: : Error: Table "mysql"."innodb_table_stats" not found. InnoDB: Recalculation of persistent statistics requested for table "mydata...

stackoverflow.com

 

[mosenth]

thanks but nothing helpful!
someone told me it is due to incompatibility between my mariadb 10.6 and centos 7.9
cause cpanel cant update anymore and there is no inconsistency between these two,
is it correct?

 

[cPRex]

No, that wouldn't be correct. If we didn't support the version, the update would not have succeeded.

You're welcome to submit a ticket to our team so we can take a look at the issue for you.

 

[mosenth]

thanks, cant sent a ticket,
does anyone know about this problem?

 

[cPRex]

Can you post the ticket number here so I can follow along?

 

[mosenth]

thanks, but i said "cant" send a ticket,
please let someone else help me with this.

 

[cPRex]

Is there a reason you can't create a ticket? If you have a license purchased through us, you'd be eligible for free support.

If not, you would want to contact a professional MySQL admin to ensure you avoid data loss, as messing with InnoDB can get messy quickly.