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

MariaDB 10.2.10 fails to run on Debian Stretch with ext3 and O_DIRECT

    Details

      Description

      I first spotted this issue when upgrading a production server to 10.2.10, it would fail to start MariaDB after the upgrade with some error along the lines of ibtmp1 failing to be created. I purged mariadb-server-10.2 and tried reinstalling, it still failed, so I downgraded that server to 10.1 and it's now running fine.

      Now I tried installing mariadb-server-10.2 on a different server where it has never been installed before, and this is the output from apt-get install mariadb-server-10.2:

      # apt-get install mariadb-server-10.2
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      The following additional packages will be installed:
        galera-3 gawk libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl
        libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
        libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
        liblwp-mediatypes-perl libmariadb3 libmariadbclient18 libreadline5
        libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl
        mariadb-client-10.2 mariadb-client-core-10.2 mariadb-common
        mariadb-server-core-10.2 mysql-common psmisc socat
      Suggested packages:
        gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl
        libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl
        mailx mariadb-test netcat-openbsd tinyca
      The following NEW packages will be installed:
        galera-3 gawk libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl
        libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
        libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
        liblwp-mediatypes-perl libmariadb3 libmariadbclient18 libreadline5
        libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl
        mariadb-client-10.2 mariadb-client-core-10.2 mariadb-common
        mariadb-server-10.2 mariadb-server-core-10.2 mysql-common psmisc socat
      0 upgraded, 30 newly installed, 0 to remove and 0 not upgraded.
      Need to get 22.6 MB of archives.
      After this operation, 186 MB of additional disk space will be used.
      Do you want to continue? [Y/n] 
      Get:1 http://ftp.debian.org/debian stretch/main amd64 libsigsegv2 amd64 2.10-5 [28.9 kB]
      Get:2 http://ftp.debian.org/debian stretch/main amd64 gawk amd64 1:4.1.4+dfsg-1 [571 kB]
      Get:3 http://ftp.debian.org/debian stretch/main amd64 libdbi-perl amd64 1.636-1+b1 [766 kB]
      Get:4 http://ftp.debian.org/debian stretch/main amd64 libreadline5 amd64 5.2+dfsg-3+b1 [119 kB]
      Get:5 http://ftp.debian.org/debian stretch/main amd64 psmisc amd64 22.21-2.1+b2 [123 kB]
      Get:6 http://ftp.debian.org/debian stretch/main amd64 socat amd64 1.7.3.1-2+deb9u1 [353 kB]
      Get:7 http://ftp.debian.org/debian stretch/main amd64 libhtml-tagset-perl all 3.20-3 [12.7 kB]
      Get:8 http://ftp.debian.org/debian stretch/main amd64 liburi-perl all 1.71-1 [88.6 kB]
      Get:9 http://ftp.debian.org/debian stretch/main amd64 libhtml-parser-perl amd64 3.72-3 [104 kB]
      Get:10 http://ftp.debian.org/debian stretch/main amd64 libcgi-pm-perl all 4.35-1 [222 kB]
      Get:11 http://ftp.debian.org/debian stretch/main amd64 libfcgi-perl amd64 0.78-2 [38.2 kB]
      Get:12 http://ftp.debian.org/debian stretch/main amd64 libcgi-fast-perl all 1:2.12-1 [11.2 kB]
      Get:13 http://ftp.debian.org/debian stretch/main amd64 libdbd-mysql-perl amd64 4.041-2 [114 kB]
      Get:14 http://ftp.debian.org/debian stretch/main amd64 libencode-locale-perl all 1.05-1 [13.7 kB]
      Get:15 http://ftp.debian.org/debian stretch/main amd64 libhtml-template-perl all 2.95-2 [67.1 kB]
      Get:16 http://ftp.debian.org/debian stretch/main amd64 libtimedate-perl all 2.3000-2 [42.2 kB]
      Get:17 http://ftp.debian.org/debian stretch/main amd64 libhttp-date-perl all 6.02-1 [10.7 kB]
      Get:18 http://ftp.debian.org/debian stretch/main amd64 libio-html-perl all 1.001-1 [17.6 kB]
      Get:19 http://ftp.debian.org/debian stretch/main amd64 liblwp-mediatypes-perl all 6.02-1 [22.1 kB]
      Get:20 http://ftp.debian.org/debian stretch/main amd64 libhttp-message-perl all 6.11-1 [75.9 kB]
      Get:21 http://ftp.debian.org/debian stretch/main amd64 libterm-readkey-perl amd64 2.37-1 [27.2 kB]
      Get:22 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main i386 mysql-common all 10.2.10+maria~stretch [8432 B]
      Get:23 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main i386 mariadb-common all 10.2.10+maria~stretch [3328 B]
      Get:24 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 galera-3 amd64 25.3.20-stretch [8267 kB]
      Get:25 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 mariadb-client-core-10.2 amd64 10.2.10+maria~stretch [741 kB]
      Get:26 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 mariadb-client-10.2 amd64 10.2.10+maria~stretch [1101 kB]
      Get:27 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 mariadb-server-core-10.2 amd64 10.2.10+maria~stretch [5474 kB]
      Get:28 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 mariadb-server-10.2 amd64 10.2.10+maria~stretch [4112 kB]
      Get:29 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 libmariadb3 amd64 10.2.10+maria~stretch [110 kB]
      Get:30 http://ftp.ddg.lth.se/mariadb/repo/10.2/debian stretch/main amd64 libmariadbclient18 amd64 10.2.10+maria~stretch [2940 B]
      Fetched 22.6 MB in 2s (9522 kB/s)             
      perl: warning: Setting locale failed.
      perl: warning: Please check that your locale settings:
      	LANGUAGE = (unset),
      	LC_ALL = (unset),
      	LC_CTYPE = "UTF-8",
      	LANG = "en_US.UTF-8"
          are supported and installed on your system.
      perl: warning: Falling back to a fallback locale ("en_US.UTF-8").
      locale: Cannot set LC_CTYPE to default locale: No such file or directory
      locale: Cannot set LC_ALL to default locale: No such file or directory
      Preconfiguring packages ...
      /usr/bin/locale: Cannot set LC_CTYPE to default locale: No such file or directory
      /usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory
      Selecting previously unselected package libsigsegv2:amd64.
      (Reading database ... 76085 files and directories currently installed.)
      Preparing to unpack .../libsigsegv2_2.10-5_amd64.deb ...
      Unpacking libsigsegv2:amd64 (2.10-5) ...
      Setting up libsigsegv2:amd64 (2.10-5) ...
      Selecting previously unselected package gawk.
      (Reading database ... 76095 files and directories currently installed.)
      Preparing to unpack .../00-gawk_1%3a4.1.4+dfsg-1_amd64.deb ...
      Unpacking gawk (1:4.1.4+dfsg-1) ...
      Selecting previously unselected package mysql-common.
      Preparing to unpack .../01-mysql-common_10.2.10+maria~stretch_all.deb ...
      Unpacking mysql-common (10.2.10+maria~stretch) ...
      Selecting previously unselected package mariadb-common.
      Preparing to unpack .../02-mariadb-common_10.2.10+maria~stretch_all.deb ...
      Unpacking mariadb-common (10.2.10+maria~stretch) ...
      Selecting previously unselected package galera-3.
      Preparing to unpack .../03-galera-3_25.3.20-stretch_amd64.deb ...
      Unpacking galera-3 (25.3.20-stretch) ...
      Selecting previously unselected package libdbi-perl.
      Preparing to unpack .../04-libdbi-perl_1.636-1+b1_amd64.deb ...
      Unpacking libdbi-perl (1.636-1+b1) ...
      Selecting previously unselected package libreadline5:amd64.
      Preparing to unpack .../05-libreadline5_5.2+dfsg-3+b1_amd64.deb ...
      Unpacking libreadline5:amd64 (5.2+dfsg-3+b1) ...
      Selecting previously unselected package mariadb-client-core-10.2.
      Preparing to unpack .../06-mariadb-client-core-10.2_10.2.10+maria~stretch_amd64.deb ...
      Unpacking mariadb-client-core-10.2 (10.2.10+maria~stretch) ...
      Selecting previously unselected package mariadb-client-10.2.
      Preparing to unpack .../07-mariadb-client-10.2_10.2.10+maria~stretch_amd64.deb ...
      Unpacking mariadb-client-10.2 (10.2.10+maria~stretch) ...
      Selecting previously unselected package mariadb-server-core-10.2.
      Preparing to unpack .../08-mariadb-server-core-10.2_10.2.10+maria~stretch_amd64.deb ...
      Unpacking mariadb-server-core-10.2 (10.2.10+maria~stretch) ...
      Selecting previously unselected package psmisc.
      Preparing to unpack .../09-psmisc_22.21-2.1+b2_amd64.deb ...
      Unpacking psmisc (22.21-2.1+b2) ...
      Selecting previously unselected package socat.
      Preparing to unpack .../10-socat_1.7.3.1-2+deb9u1_amd64.deb ...
      Unpacking socat (1.7.3.1-2+deb9u1) ...
      Setting up mysql-common (10.2.10+maria~stretch) ...
      Setting up mariadb-common (10.2.10+maria~stretch) ...
      Selecting previously unselected package mariadb-server-10.2.
      (Reading database ... 76669 files and directories currently installed.)
      Preparing to unpack .../00-mariadb-server-10.2_10.2.10+maria~stretch_amd64.deb ...
      locale: Cannot set LC_CTYPE to default locale: No such file or directory
      locale: Cannot set LC_ALL to default locale: No such file or directory
      Unpacking mariadb-server-10.2 (10.2.10+maria~stretch) ...
      Selecting previously unselected package libhtml-tagset-perl.
      Preparing to unpack .../01-libhtml-tagset-perl_3.20-3_all.deb ...
      Unpacking libhtml-tagset-perl (3.20-3) ...
      Selecting previously unselected package liburi-perl.
      Preparing to unpack .../02-liburi-perl_1.71-1_all.deb ...
      Unpacking liburi-perl (1.71-1) ...
      Selecting previously unselected package libhtml-parser-perl.
      Preparing to unpack .../03-libhtml-parser-perl_3.72-3_amd64.deb ...
      Unpacking libhtml-parser-perl (3.72-3) ...
      Selecting previously unselected package libcgi-pm-perl.
      Preparing to unpack .../04-libcgi-pm-perl_4.35-1_all.deb ...
      Unpacking libcgi-pm-perl (4.35-1) ...
      Selecting previously unselected package libfcgi-perl.
      Preparing to unpack .../05-libfcgi-perl_0.78-2_amd64.deb ...
      Unpacking libfcgi-perl (0.78-2) ...
      Selecting previously unselected package libcgi-fast-perl.
      Preparing to unpack .../06-libcgi-fast-perl_1%3a2.12-1_all.deb ...
      Unpacking libcgi-fast-perl (1:2.12-1) ...
      Selecting previously unselected package libmariadb3.
      Preparing to unpack .../07-libmariadb3_10.2.10+maria~stretch_amd64.deb ...
      Unpacking libmariadb3 (10.2.10+maria~stretch) ...
      Selecting previously unselected package libmariadbclient18.
      Preparing to unpack .../08-libmariadbclient18_10.2.10+maria~stretch_amd64.deb ...
      Unpacking libmariadbclient18 (10.2.10+maria~stretch) ...
      Selecting previously unselected package libdbd-mysql-perl.
      Preparing to unpack .../09-libdbd-mysql-perl_4.041-2_amd64.deb ...
      Unpacking libdbd-mysql-perl (4.041-2) ...
      Selecting previously unselected package libencode-locale-perl.
      Preparing to unpack .../10-libencode-locale-perl_1.05-1_all.deb ...
      Unpacking libencode-locale-perl (1.05-1) ...
      Selecting previously unselected package libhtml-template-perl.
      Preparing to unpack .../11-libhtml-template-perl_2.95-2_all.deb ...
      Unpacking libhtml-template-perl (2.95-2) ...
      Selecting previously unselected package libtimedate-perl.
      Preparing to unpack .../12-libtimedate-perl_2.3000-2_all.deb ...
      Unpacking libtimedate-perl (2.3000-2) ...
      Selecting previously unselected package libhttp-date-perl.
      Preparing to unpack .../13-libhttp-date-perl_6.02-1_all.deb ...
      Unpacking libhttp-date-perl (6.02-1) ...
      Selecting previously unselected package libio-html-perl.
      Preparing to unpack .../14-libio-html-perl_1.001-1_all.deb ...
      Unpacking libio-html-perl (1.001-1) ...
      Selecting previously unselected package liblwp-mediatypes-perl.
      Preparing to unpack .../15-liblwp-mediatypes-perl_6.02-1_all.deb ...
      Unpacking liblwp-mediatypes-perl (6.02-1) ...
      Selecting previously unselected package libhttp-message-perl.
      Preparing to unpack .../16-libhttp-message-perl_6.11-1_all.deb ...
      Unpacking libhttp-message-perl (6.11-1) ...
      Selecting previously unselected package libterm-readkey-perl.
      Preparing to unpack .../17-libterm-readkey-perl_2.37-1_amd64.deb ...
      Unpacking libterm-readkey-perl (2.37-1) ...
      Setting up libhtml-tagset-perl (3.20-3) ...
      Setting up libmariadb3 (10.2.10+maria~stretch) ...
      Setting up psmisc (22.21-2.1+b2) ...
      Setting up libencode-locale-perl (1.05-1) ...
      Setting up libtimedate-perl (2.3000-2) ...
      Setting up socat (1.7.3.1-2+deb9u1) ...
      Setting up libio-html-perl (1.001-1) ...
      Setting up libmariadbclient18 (10.2.10+maria~stretch) ...
      Setting up gawk (1:4.1.4+dfsg-1) ...
      Setting up libterm-readkey-perl (2.37-1) ...
      Setting up liblwp-mediatypes-perl (6.02-1) ...
      Processing triggers for libc-bin (2.24-11+deb9u1) ...
      Setting up galera-3 (25.3.20-stretch) ...
      Setting up liburi-perl (1.71-1) ...
      Processing triggers for systemd (232-25+deb9u1) ...
      Setting up libhtml-parser-perl (3.72-3) ...
      Setting up libcgi-pm-perl (4.35-1) ...
      Processing triggers for man-db (2.7.6.1-2) ...
      Setting up libreadline5:amd64 (5.2+dfsg-3+b1) ...
      Setting up mariadb-server-core-10.2 (10.2.10+maria~stretch) ...
      Setting up libfcgi-perl (0.78-2) ...
      Setting up libdbi-perl (1.636-1+b1) ...
      Setting up mariadb-client-core-10.2 (10.2.10+maria~stretch) ...
      Setting up mariadb-client-10.2 (10.2.10+maria~stretch) ...
      Setting up libhttp-date-perl (6.02-1) ...
      Setting up libhtml-template-perl (2.95-2) ...
      Setting up libcgi-fast-perl (1:2.12-1) ...
      Setting up mariadb-server-10.2 (10.2.10+maria~stretch) ...
      locale: Cannot set LC_CTYPE to default locale: No such file or directory
      locale: Cannot set LC_ALL to default locale: No such file or directory
      2017-11-01 18:34:37 140273120094400 [Note] /usr/sbin/mysqld (mysqld 10.2.10-MariaDB-10.2.10+maria~stretch) starting as process 14433 ...
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Uses event mutexes
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Compressed tables use zlib 1.2.8
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Using Linux native AIO
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Number of pools: 1
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Using SSE2 crc32 instructions
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
      2017-11-01 18:34:37 140273120094400 [Note] InnoDB: Completed initialization of buffer pool
      2017-11-01 18:34:37 140272383637248 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2017-11-01 18:34:37 140273120094400 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
      2017-11-01 18:34:37 140273120094400 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
      2017-11-01 18:34:38 140273120094400 [Note] InnoDB: Starting shutdown...
      2017-11-01 18:34:38 140273120094400 [ERROR] Plugin 'InnoDB' init function returned error.
      2017-11-01 18:34:38 140273120094400 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2017-11-01 18:34:38 140273120094400 [Note] Plugin 'FEEDBACK' is disabled.
      ERROR: 1146  Table 'mysql.user' doesn't exist
      2017-11-01 18:34:38 140273120094400 [ERROR] Aborting
       
      /usr/bin/locale: Cannot set LC_CTYPE to default locale: No such file or directory
      /usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory
      Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
      Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
      Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
      Job for mariadb.service failed because the control process exited with error code.
      See "systemctl status mariadb.service" and "journalctl -xe" for details.
      invoke-rc.d: initscript mysql, action "start" failed.
      ● mariadb.service - MariaDB database server
         Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
        Drop-In: /etc/systemd/system/mariadb.service.d
                 └─migrated-from-my.cnf-settings.conf
         Active: failed (Result: exit-code) since Wed 2017-11-01 18:34:43 CET; 10ms ago
        Process: 14950 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
        Process: 14791 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
        Process: 14787 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
        Process: 14784 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
       Main PID: 14950 (code=exited, status=1/FAILURE)
         Status: "MariaDB server is down"
       
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [ERROR] Plugin 'InnoDB' init function returned error.
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [Note] Plugin 'FEEDBACK' is disabled.
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [ERROR] Could not open mysql.plugin table. Some plugin…ot loaded
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [ERROR] Unknown/unsupported storage engine: InnoDB
      Nov 01 18:34:43 vps.ovh.net mysqld[14950]: 2017-11-01 18:34:43 140586479507648 [ERROR] Aborting
      Nov 01 18:34:43 vps.ovh.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
      Nov 01 18:34:43 vps.ovh.net systemd[1]: Failed to start MariaDB database server.
      Nov 01 18:34:43 vps.ovh.net systemd[1]: mariadb.service: Unit entered failed state.
      Nov 01 18:34:43 vps.ovh.net systemd[1]: mariadb.service: Failed with result 'exit-code'.
      Hint: Some lines were ellipsized, use -l to show in full.
      dpkg: error processing package mariadb-server-10.2 (--configure):
       subprocess installed post-installation script returned error exit status 1
      Setting up libhttp-message-perl (6.11-1) ...
      Setting up libdbd-mysql-perl (4.041-2) ...
      Processing triggers for libc-bin (2.24-11+deb9u1) ...
      Processing triggers for systemd (232-25+deb9u1) ...
      Errors were encountered while processing:
       mariadb-server-10.2
      E: Sub-process /usr/bin/dpkg returned an error code (1)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                Samman Mark Samman
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: