Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13896

Upgraded to 10.2.8 on Centos 7.4 ibdata error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.2.8
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
      None
    • Environment:
      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              jeffsmith82 Jeffrey Smith
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration