MariaDB update issues

[kbarg]

I had mysql and switched over to MariaDB. 10.6. Today I had this problem when I went to upgrade. What do I do?

Found created package: mariadb-10.6.8-linux-x86_64.tar.gz
tar: stdout: write error
Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Job for mysqld.service failed because a fatal signal was delivered to the control process.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local server through socket '/usr/local/mysql/data/mysql.sock' (111)
FATAL ERROR: Upgrade failed
[1mError running '/usr/local/mysql/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --skip-version-check'(B[m
Restarting MySQL.
Job for mysqld.service failed because a fatal signal was delivered to the control process.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
Installation completed.

 

[factor]

I had mysql and switched over to MariaDB.

today? long ago?
What is the OS and version?

What do you get with:

cd /usr/local/directadmin/custombuild
./build set_fastest
./build clean
./build update
./build set mysql_backup yes
./build set "mysql" 10.6
./build set mysql_inst "mariadb"
./build "mysql"

 

[kbarg]

Sorry.

It was Debian 11, latest DirectAdmin. I did an OS reload about two weeks ago.

 

[smtalk]

May you try:

cd /usr/local/directadmin/custombuild
./build update
./build mariadb

It's likely caused by ProtectHome=true and mysql data in /home/mysql, CustomBuild sets ProtectHome=false in latest versions.

 

[kbarg]

Why is it spouting about MariaDB 10.5.15 when on a fresh install I converted from MySQL to MariaDB 10.6, I never even installed the 10.5 series

This is what I got from the footer of the 'systemctl status mariadb'

Jul 21 15:48:22 hostname.server.net systemd[1]: Started MariaDB 10.5.15 database server.
Jul 21 15:48:22 hostname.server.net mariadbd[2539170]: 2022-07-21 15:48:22 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Jul 21 15:48:22 hostname.server.net /etc/mysql/debian-start[2539224]: Looking for 'mysql' as: /usr/bin/mysql
Jul 21 15:48:22 hostname.server.net /etc/mysql/debian-start[2539224]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
Jul 21 15:48:22 hostname.server.net /etc/mysql/debian-start[2539224]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Jul 21 15:48:22 hostname.server.net /etc/mysql/debian-start[2539224]: FATAL ERROR: Upgrade failed
Jul 21 15:48:22 hostname.server.net debian-start[2539233]: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
Jul 21 15:48:34 hostname.server.net mariadbd[2539170]: 2022-07-21 15:48:34 0 [Note] InnoDB: Buffer pool(s) load completed at 220721 15:48:34
Jul 21 16:04:26 hostname.server.net mariadbd[2539170]: 2022-07-21 16:04:26 385 [ERROR] Incorrect definition of table mysql.proc: expected column 'definer' at position 11 to have type char(, found type varchar(384).
Jul 22 14:20:27 hostname.server.net mariadbd[2539170]: 2022-07-22 14:20:27 21464 [Warning] Aborted connection 21464 to db: ‘db_name’ user: ‘db_user’ host: 'localhost' (Got timeout reading communication packets)

When I 'mariadb --version' I get: 'mariadb Ver 15.1 Distrib 10.6.8-MariaDB, for Linux (x86_64) using readline 5.1'

But when I stop and restart and run a new 'systemctl status mariadb'

I get

Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(, found type varchar(384).


Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.


Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 0 [Note] Reading of all Master_info entries succeeded


Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 0 [Note] Added new Master_info '' to hash table


Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 0 [Note] /usr/sbin/mariadbd: ready for connections.


Jul 23 15:22:32 host.server.net mariadbd[34967]: Version: '10.5.15-MariaDB-0+deb11u1' socket: '/usr/local/mysql/data/mysql.sock' port: 3306 Debian 11


Jul 23 15:22:32 host.server.net systemd[1]: Started MariaDB 10.5.15 database server.


Jul 23 15:22:32 host.server.net mariadbd[34967]: 2022-07-23 15:22:32 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)


Jul 23 15:22:32 host.server.net debian-start[35029]: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)


Jul 23 15:22:33 host.server.net mariadbd[34967]: 2022-07-23 15:22:33 0 [Note] InnoDB: Buffer pool(s) load completed at 220723 15:22:33

Why is it still talking about mariadb 10.5.15? I never installed any 10.5

I cannot control it via 'Service Monitor' in DA


I need to backup all my databases before the somehow get corrupted but half of the time, when I 'mysqldump' or 'mysql' I get my sock error.

What DO I need to do?

I have conflicting MariaDB, when 10.5 shouldn't be on there at all. It had successfully swapped from MySQL to MariaDB, but why is it saying on version that it is 10.6, yet everything else say 10.5.

 

[Richard G]

What DO I need to do?

Since you created a unneccessary new post agian.... do you have your backup yet? Or not.

It seems something is wrong when upgrading or converting.
Hard to help as we don't exactly know what happened or why there suddenly are 2 versions.

Best is to wait if @smtalk answers again, or if you are on a paid license, shoot in a ticket.