Arch Linux

CaptainKirk

Member

Registered: 2009-06-07

Posts: 393

MariaDB user table is damaged

Here is what I see:

$ sudo systemctl  status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: protocol) since Mon 2017-10-02 17:17:34 IDT; 2h 11min ago
  Process: 5633 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 5581 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environme
  Process: 5580 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 5633 (code=exited, status=1/FAILURE)

Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792672192 [Note] Recovering after a crash using mysql-bin
Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792672192 [Note] Starting crash recovery...
Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792672192 [Note] Crash recovery finished.
Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792650496 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: T
Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792672192 [Note] Server socket created on IP: '::'.
Oct 02 17:17:34 arch mysqld[5633]: 2017-10-02 17:17:34 140092792672192 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
Oct 02 17:17:34 arch systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 02 17:17:34 arch systemd[1]: Failed to start MariaDB database server.
Oct 02 17:17:34 arch systemd[1]: mariadb.service: Unit entered failed state.
Oct 02 17:17:34 arch systemd[1]: mariadb.service: Failed with result 'protocol'.
$ mysqlcheck –repair mysql user
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory") when trying to connect

Not sure what to do now.

I would be happy to delete all data and reinstall Maria from scratch as I have nothing important there.

Any way I can get back my Maria will work for me.

Milo.Shaw

Member

From: Shenzhen, China

Registered: 2017-10-06

Posts: 2

Re: MariaDB user table is damaged

I get the same error information as you.  I just install mariadb on my new arch linux with command pacman -Sy mariadb ,  no configure , no data.  It seams there is something wrong with mariadb itself, not with  system  enviroment .