Directadmin Version : 1.663
MariaDB : 10.6.17
Hi,
On friday night mariadb down itself so after restart of server its start working but its showing following error
[*@server16 ~]$ sudo systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/etc/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 Sat 2024-05-25 03:52:19 PKT; 1 day 8h ago
Process: 1536 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 981 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_P>
Process: 960 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 1003 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 177 (limit: 407509)
Memory: 2.7G
CGroup: /system.slice/mariadb.service
└─1003 /usr/sbin/mysqld
May 26 11:33:20 server16.mydomain.net mysqld[1003]: 2024-05-26 11:33:20 433435 [ERROR] Couldn't repair table: mysql.proc
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Note] Zerofilling moved table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Warning] Checking table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Warning] Recovering table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [ERROR] Couldn't repair table: mysql.proc
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Note] Zerofilling moved table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Warning] Checking table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Warning] Recovering table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [ERROR] Couldn't repair table: mysql.proc
Now problem is that as today weekly backup runs mysqldump gives error for all databases as follows
<4:15:48>
Error while backing up database ittreasure_wp398
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'ittreasure_wp398'': Index for table 'proc' is corrupt; try to repair it (1034)
Error while backing up database ittreasure_wp679
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'ittreasure_wp679'': Index for table 'proc' is corrupt; try to repair it (1034)
All websites are up but in da control panel, every users control panel section databases are not showing there.
pls suggest, how to resolve that issue.
MariaDB : 10.6.17
Hi,
On friday night mariadb down itself so after restart of server its start working but its showing following error
[*@server16 ~]$ sudo systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/etc/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 Sat 2024-05-25 03:52:19 PKT; 1 day 8h ago
Process: 1536 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 981 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_P>
Process: 960 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 1003 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 177 (limit: 407509)
Memory: 2.7G
CGroup: /system.slice/mariadb.service
└─1003 /usr/sbin/mysqld
May 26 11:33:20 server16.mydomain.net mysqld[1003]: 2024-05-26 11:33:20 433435 [ERROR] Couldn't repair table: mysql.proc
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Note] Zerofilling moved table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Warning] Checking table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [Warning] Recovering table: './mysql/proc'
May 26 11:37:23 server16.mydomain.net mysqld[1003]: 2024-05-26 11:37:23 434349 [ERROR] Couldn't repair table: mysql.proc
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Note] Zerofilling moved table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Warning] Checking table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [Warning] Recovering table: './mysql/proc'
May 26 12:25:01 server16.mydomain.net mysqld[1003]: 2024-05-26 12:25:01 446221 [ERROR] Couldn't repair table: mysql.proc
Now problem is that as today weekly backup runs mysqldump gives error for all databases as follows
<4:15:48>
Error while backing up database ittreasure_wp398
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'ittreasure_wp398'': Index for table 'proc' is corrupt; try to repair it (1034)
Error while backing up database ittreasure_wp679
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'ittreasure_wp679'': Index for table 'proc' is corrupt; try to repair it (1034)
All websites are up but in da control panel, every users control panel section databases are not showing there.
pls suggest, how to resolve that issue.
