Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.8
-
None
-
CentOS Linux release 7.4.1708 (Core)
Description
did a yum update to install the latest version and rebooted my machine, now maridb refuses to start.
Sep 23 11:24:13 hornbillsql1 polkitd[759]: Registered Authentication Agent for unix-process:6449:287204 (system bus name :1.74 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, l |
Sep 23 11:24:13 hornbillsql1 systemd[1]: Starting MariaDB database server... |
-- Subject: Unit mariadb.service has begun start-up
|
-- Defined-By: systemd
|
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel |
--
|
-- Unit mariadb.service has begun starting up.
|
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] /usr/sbin/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 6682 ... |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Warning] Can't create test file /home/mysql/hornbillsql1.lower-test |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] mysqld: File '/home/mysql/aria_log_control' not found (Errcode: 30 "Read-only file system") |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/home/mysql/aria_log_control' |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Plugin 'Aria' init function returned error. |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Uses event mutexes |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Compressed tables use zlib 1.2.7 |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Using Linux native AIO |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Number of pools: 1 |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Using SSE2 crc32 instructions |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Completed initialization of buffer pool |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140564997007104 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] InnoDB: Plugin initialization aborted with error Generic error |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] InnoDB: Starting shutdown... |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Plugin 'InnoDB' init function returned error. |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [Note] Plugin 'FEEDBACK' is disabled. |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Unknown/unsupported storage engine: InnoDB |
Sep 23 11:24:14 hornbillsql1 mysqld[6682]: 2017-09-23 11:24:14 140567722469504 [ERROR] Aborting |
Sep 23 11:24:14 hornbillsql1 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE |
Sep 23 11:24:14 hornbillsql1 systemd[1]: Failed to start MariaDB database server. |
-- Subject: Unit mariadb.service has failed
|
-- Defined-By: systemd
|
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel |
--
|
-- Unit mariadb.service has failed.
|
--
|
-- The result is failed.
|
Its saying permission are wrong on ibdata1 though they are set as owned by the mysql user.
-rw-rw----. 1 mysql mysql 3667918848 Sep 23 10:16 ibdata1
|
SELinux is also currently set as permissive so cant be that.
[root@hornbillsql1 mysql]# sestatus
|
SELinux status: enabled
|
SELinuxfs mount: /sys/fs/selinux
|
SELinux root directory: /etc/selinux
|
Loaded policy name: targeted
|
Current mode: permissive
|
Mode from config file: permissive
|
Policy MLS status: enabled
|
Policy deny_unknown status: allowed
|
Max kernel policy version: 28
|
also seems I'm not the only one https://stackoverflow.com/questions/46345170/mariadb-ibdata1-file-cannot-be-written#
Attachments
Issue Links
- is caused by
-
MDEV-10298 Improve systemd service hardening
- Closed