I updated the cyberpanel to the latest version. After the update mariadb stop suddenly several times a day. When mariadb stops, neither the sites can be accessed, nor the cyberpanel. how can i solve it.
Welcome @stbolen Happy you are here
Post the contents of /var/log/mysql/error.log using cat command or just copy paste here
Thanks
cat: /var/log/mysql/error.log: No such file or directory
Unfortunately the log file could not be found. Where else could it be.
Do you have any logs here ls /var/log/mysql/
ls: cannot access /var/log/mysql/: No such file or directory
What is the status of mariadb service:
$ service mariadb status
service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.16 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2023-03-07 13:07:18 +03; 1min 39s ago
Docs: man:mariadbd(8)
systemd - MariaDB Knowledge Base
Process: 122939 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 122859 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 122857 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 122924 (mariadbd)
Status: “Taking your SQL requests now…”
CGroup: /system.slice/mariadb.service
└─122924 /usr/sbin/mariadbd
Mar 07 13:08:02 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:02 37 [ERROR] mariadbd: Table ‘./sensoyjewe_sensoj/counter_ips’ is marked as crashed and s… repaired
Mar 07 13:08:02 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:02 37 [Warning] Checking table: ‘./sensoyjewe_sensoj/counter_ips’
Mar 07 13:08:19 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:19 40 [ERROR] mariadbd: Table ‘./kaba_kabatas/yazi’ is marked as crashed and should be repaired
Mar 07 13:08:19 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:19 40 [Warning] Checking table: ‘./kaba_kabatas/yazi’
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [ERROR] mariadbd: Table ‘./ebasaglik_eba/sayfalar’ is marked as crashed and should be repaired
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [Warning] Checking table: ‘./ebasaglik_eba/sayfalar’
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [ERROR] mariadbd: Table ‘./ebasaglik_eba/counter_values’ is marked as crashed and sh… repaired
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [Warning] Checking table: ‘./ebasaglik_eba/counter_values’
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [ERROR] mariadbd: Table ‘./ebasaglik_eba/counter_ips’ is marked as crashed and shoul… repaired
Mar 07 13:08:47 vesair-cloud-1 mariadbd[122924]: 2023-03-07 13:08:47 43 [Warning] Checking table: ‘./ebasaglik_eba/counter_ips’
Hint: Some lines were ellipsized, use -l to show in full.
There is a table that crashed. It seems mariadb cannot repair it. You cannot recover that if you did not Incremental Backup and Restore with Mariabackup - MariaDB Knowledge Base . Can you delete this database and restart mariadb the issue should go away
Hello mate, I’m facing similar issues with MariaDB after upgrading my CyberPanel.
This is a sample of the output when I run $ service mariadb status: 2023-08-24 4:55:08 12344 [ERROR] mysqld: Disk full (/tmp/#sql_1a8_0.MAI); waiting for someone to free some space… …on device")