Dotaz: MariaDB / Active: active / ERROR 2002 (HY000)

[Dobrack]

Dobry den,

resim problem s MariaDB. Pokud dam systemctl status mysql.service, hlasi se jako Active: active (exited), soubor /var/run/mysqld/mysqld.sock existuje, ale po nejake dobe se k MariaDB nelze prihlasit a zacne hlasit"

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

Pri kontrole, ale soubor /var/run/mysqld/mysqld.sock existuje, ma konkretne nazev =mysqld.sock

Netusite nekdo proc MariaDB prestane fungovat? V tomto pripade se sluzba ani nerestartuje, protoze nedojde k jejimu padu a pro system se hlasi jako kdyby byla v pohode, protoze je active.

root@deb1:~# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (exited) since Wed 2022-07-27 18:58:00 CEST; 9h ago
  Process: 19732 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 19764 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)

Jul 27 18:58:00 deb1 mysqld[19928]: 220727 18:58:00 [Note] /usr/sbin/mysqld: ready for connections.
Jul 27 18:58:00 deb1 mysqld[19928]: Version: '10.0.30-MariaDB-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Jul 27 18:58:00 deb1 mysql[19764]: Starting MariaDB database server: mysqld.
Jul 27 18:58:00 deb1 systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Jul 27 18:58:00 deb1 /etc/mysql/debian-start[19976]: Upgrading MySQL tables if necessary.
Jul 27 18:58:00 deb1 /etc/mysql/debian-start[19980]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jul 27 18:58:00 deb1 /etc/mysql/debian-start[20000]: Checking for insecure root accounts.
Jul 27 18:58:00 deb1 /etc/mysql/debian-start[20010]: Triggering myisam-recover for all MyISAM tables
Hint: Some lines were ellipsized, use -l to show in full.
root@deb1:~# mysql -u root -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

Odpovědi

[X]

Mame hadat? Prvni vec co udelam je, ze se podivam do logu = journalctl -xeu mysql.service + /var/log ..

[Dobrack]

Jedine co v logu najdu je:

Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [ERROR] mysqld: Table './dbispconfig/monitor_data' is marked as crashed and should be repaired
Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [Warning] Checking table:   './dbispconfig/monitor_data'
Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [ERROR] mysqld: Table './dbispconfig/sys_cron' is marked as crashed and should be repaired
Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [Warning] Checking table:   './dbispconfig/sys_cron'
Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [ERROR] mysqld: Table './dbispconfig/sys_session' is marked as crashed and should be repaired
Jul 28 09:04:48 deb1 mysqld[18392]: 220728  9:04:48 [Warning] Checking table:   './dbispconfig/sys_session'

Tabulky jsem jiz opravoval

mysqlcheck -uroot -p --repair --all-databases

Pridal jsem aktualne toto, nevim zda-li to pomuze:

myisam-recover-options=FORCE,BACKUP

https://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_myisam-recover-options

[Max]

A co

dmesg
df -h
df -i

Logy ve /var/log nic neříkají?
Po opravě tabulek se už chyby s tabulkami neobjevují?
Zdar Max

[Dobrack]

To jsem kontroloval. Logy nic moc nerikaji, mista je dost.... Ted jsem tak udelal to, ze jsem u vsech tabulek presel z MyISAM na InnoDB. Koukal jsem, ze nektere tabulky maji vice jak milion radku a je dost mozne, ze pri nejake akci to proste neustoji. Nevim, jen hadam. Ted cekam zda-li to znovu spadne.

Po oprave take dochazelo k padu. Doufal jsem, ze treba dochazi misto, ze tam bude takovy problem, ale neni...

Testuji a hledam pricinu.

[Dobrack]

Od vcerejsiho dne od prevodu z MyISAM na InnoDB MariaDB nespadlo. Vypada to, ze jsem to tim vyresil.