How do I resolve a MariaDB possibly corrupted table error when it doesn't look corrupted

Question

I had 2 theories. 1. that it was a permissions error 2. that the table was corrupt. I seem to addressed both without result. What could cause this ERROR 1728 message?

Running it as mysql user does not work

MariaDB [mysql]> DROP FUNCTION IF EXISTS civicrm_strip_non_numeric; ERROR 1728 (HY000): Cannot load from mysql.proc. The table is probably corrupted

It does not say that it is corrupt.

MariaDB [mysql]> repair table proc; +------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------+--------+----------+----------+ | mysql.proc | repair | status | OK | +------------+--------+----------+----------+

Interlated · Accepted Answer · 2018-05-20 20:11:38Z

11

This fixes it

mysql_upgrade -u root -pxxx

wasn't aware that I upgraded as this is a new installation.
same for mariadb as mysql

answered May 20, 2018 at 20:11

Interlated

6,02610 gold badges54 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Interlated Over a year ago

Mainly checks the system table schema mariadb.com/kb/en/mysql_upgrade

Collectives™ on Stack Overflow

How do I resolve a MariaDB possibly corrupted table error when it doesn't look corrupted

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related