Skip to main content

Troubleshooting

[ERROR] mariadbd: Got error '144 "Table is crashed and last repair failed"' for './mysql/global_priv'​

That error means MariaDB cannot read the mysql.global_priv system table because it is corrupted, and an automatic repair already failed. Since this table controls users, passwords, and privileges, MariaDB refuses to start or operate correctly.

Below is a safe, ordered recovery process. Follow it carefully.

Stop MariaDB completely​

systemctl stop mariadb

Verify it’s not running:

ps aux | grep mariadbd

Check the table engine (important)​

MariaDB stores mysql.global_priv as Aria (not InnoDB).

Confirm:

ls -l /var/lib/mysql/mysql/global_priv.*

You should see files like:

  • global_priv.frm
  • global_priv.MAD
  • global_priv.MAI

Try Aria repair (offline)​

Run aria_chk, not mysqlcheck.

cd /var/lib/mysql/mysql
aria_chk -r global_priv

If that fails, try force recovery:

aria_chk --force --recover global_priv