Как исправить — mariadb не запускается после зменения расположения датафайлов?

Question

[uglug]

Изменил data directory для MariaDb по инструкции https://www.digitalocean.com/community/tutorials/h...
После этого сервис не стартует. Ошибка ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, st>

x mariadb.service - MariaDB 11.3.2 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             `-migrated-from-my.cnf-settings.conf
     Active: failed (Result: exit-code) since Fri 2024-04-26 21:02:22 MSK; 2min 1s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 3406 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCE>
    Process: 3407 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCC>
    Process: 3409 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/>
    Process: 3417 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, st>
   Main PID: 3417 (code=exited, status=1/FAILURE)
        CPU: 32ms

Apr 26 21:02:22 mariadb systemd[1]: Starting mariadb.service - MariaDB 11.3.2 database server...
Apr 26 21:02:22 mariadb sh[3414]: [103B blob data]
Apr 26 21:02:22 mariadb sh[3414]: Fatal error in defaults handling. Program aborted
Apr 26 21:02:22 mariadb mariadbd[3417]: [95B blob data]
Apr 26 21:02:22 mariadb mariadbd[3417]: Fatal error in defaults handling. Program aborted
Apr 26 21:02:22 mariadb systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Apr 26 21:02:22 mariadb systemd[1]: mariadb.service: Failed with result 'exit-code'.
Apr 26 21:02:22 mariadb systemd[1]: Failed to start mariadb.service - MariaDB 11.3.2 database server.
~

Уже перепробовал и перепроверил все что удалось найти в интернете.
Может кто-то с подобной оибкой сталкивался?

Comments

[Valentin Barbolin]

В статье не описано как сделать правильно mount, соответственно ты уверен что у user от которого запускается mariadb есть права в новой локации?

[uglug]

Valentin Barbolin, Вроде как да

root@mariadb:/etc/mysql# id mysql
uid=103(mysql) gid=112(mysql) groups=112(mysql),10000(lxc_shares)
root@mariadb:/etc/mysql# ls -ald /mnt/data/              
drwxrwx--- 2 root lxc_shares 0 Apr 26 20:12 /mnt/data/
root@mariadb:/etc/mysql#

[Valentin Barbolin]

uglug, Вроде да, но нет. Будет работать только если mysql полный владелец.
chowd -R mysql:mysql /mnt/data
chmod -R 0751 /mnt/data

[uglug]

Valentin Barbolin, к сожалению не помогло. Та же ошбка

[Akina]

Ну а что показывает Error Log?

[uglug]

Akina,

root@mariadb:~# journalctl -xeu mariadb.service
-- A start job for unit mariadb.service has begun execution.
-- A start job for unit mariadb.service has begun execution.
-- 
-- The job identifier is 914.
Apr 27 09:52:35 mariadb sh[735]: [103B blob data]
Apr 27 09:52:35 mariadb sh[735]: Fatal error in defaults handling. Program aborted
Apr 27 09:52:35 mariadb mariadbd[738]: [95B blob data]
Apr 27 09:52:35 mariadb mariadbd[738]: Fatal error in defaults handling. Program aborted
Apr 27 09:52:35 mariadb systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- 
-- An ExecStart= process belonging to unit mariadb.service has exited.
-- 
-- The process' exit code is 'exited' and its exit status is 1.
Apr 27 09:52:35 mariadb systemd[1]: mariadb.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- 
-- The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Apr 27 09:52:35 mariadb systemd[1]: Failed to start mariadb.service - MariaDB 11.3.2 database server.

[Akina]

При чём тут лог операционки?

https://mariadb.com/kb/en/error-log/

[Михаил Ливач]

а право на чтение/исполнение /mnt у mysql есть?

[uglug]

2024-04-27 13:51:58 0 [Note] Starting MariaDB 11.3.2-MariaDB-1:11.3.2+maria~deb12-log source revision 068a6819eb63bcb01fdfa037c9bf3bf63c33ee42 as process 584
2024-04-27 13:51:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-27 13:51:58 0 [Note] InnoDB: Number of transaction pools: 1
2024-04-27 13:51:58 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-04-27 13:51:58 0 [Note] InnoDB: Using liburing
2024-04-27 13:51:58 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB
2024-04-27 13:51:58 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-27 13:51:58 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-04-27 13:51:58 0 [Note] InnoDB: End of log at LSN=1288337475923
2024-04-27 13:51:59 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-04-27 13:51:59 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-04-27 13:51:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-04-27 13:51:59 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-04-27 13:51:59 0 [Note] InnoDB: log sequence number 1288337475923; transaction id 150850
2024-04-27 13:51:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-27 13:51:59 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-04-27 13:51:59 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/data/mysql/ib_buffer_pool
2024-04-27 13:52:01 0 [Note] InnoDB: Buffer pool(s) load completed at 240427 13:52:01
2024-04-27 13:52:01 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-04-27 13:52:01 0 [Note] Server socket created on IP: '::'.
2024-04-27 13:52:01 0 [ERROR] Can't start server : Bind on unix socket: Operation not permitted
2024-04-27 13:52:01 0 [ERROR] Do you already have another server running on socket: /mnt/data/mysql/mysql.sock ?
2024-04-27 13:52:01 0 [ERROR] Aborting

root@mariadb:~# ps ax | grep mysql
631 pts/1 S+ 0:00 grep mysql
root@mariadb:~#

[Akina]

Can't start server : Bind on unix socket: Operation not permitted
Do you already have another server running on socket: /mnt/data/mysql/mysql.

Проверяйте...