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

Upgrade from 10.0.22 to 10.1.9 fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.9
    • 10.1.10
    • Plugins, XA
    • None
    • CentOS 6.6
    • 10.1.11

    Description

      Trying to upgrade MariaDB from 10.0.22 to 10.1.9 fails. Downgrading back to 10.0.22 makes mariaDB work again.
      Here are the logs during upgrade:

      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-client.rpm
      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-devel.rpm
      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-server.rpm
      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-shared.rpm
      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-common.rpm
      Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.9-centos6-x86_64-compat.rpm
      Installing libjemalloc...
      Found /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el6.x86_64.rpm
      Found /usr/local/directadmin/custombuild/mysql/jemalloc-devel-3.6.0-1.el6.x86_64.rpm
      warning: /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
      Preparing...                ########################################### [100%]
         1:jemalloc               ########################################### [ 50%]
         2:jemalloc-devel         ########################################### [100%]
      Stopping mysqld ...
      Shutting down MySQL..................................... SUCCESS! 
      Upgrading MariaDB 10.0.22 to 10.1.9
      warning: /etc/my.cnf.d/server.cnf saved as /etc/my.cnf.d/server.cnf.rpmsave
      warning: MariaDB-10.1.9-centos6-x86_64-client.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
      Preparing...                ########################################### [100%]
         1:MariaDB-compat         ########################################### [ 17%]
         2:MariaDB-common         ########################################### [ 33%]
         3:MariaDB-client         ########################################### [ 50%]
         4:MariaDB-server         ########################################### [ 67%]
         5:MariaDB-devel          ########################################### [ 83%]
         6:MariaDB-shared         ########################################### [100%]
      Starting MySQL.... ERROR! 
      Giving mysqld a few seconds to start up...
      Version check failed. Got the following error when calling the 'mysql' command line client
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
      FATAL ERROR: Upgrade failed
      /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") when trying to connect
      cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
      Restarting MySQL.
       ERROR! MySQL server PID file could not be found!
      Starting MySQL... ERROR! 
       ERROR! Failed to restart server.

      and mysql error log:

      151125 17:54:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
      /usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
      2015-11-25 17:54:18 140379608573984 [Note] /usr/sbin/mysqld (mysqld 10.1.9-MariaDB) starting as process 11140 ...
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: The InnoDB memory heap is disabled
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Memory barrier is not used
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Using Linux native AIO
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Using CPU crc32 instructions
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Completed initialization of buffer pool
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Highest supported file format is Barracuda.
      2015-11-25 17:54:19 140379608573984 [Warning] InnoDB: Resizing redo log from 2*16384 to 2*3072 pages, LSN=307161985788
      2015-11-25 17:54:19 140379608573984 [Warning] InnoDB: Starting to delete and rewrite log files.
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
      2015-11-25 17:54:19 140379608573984 [Warning] InnoDB: New log files created, LSN=307161986060
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: 128 rollback segment(s) are active.
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB: Waiting for purge to start
      2015-11-25 17:54:19 140379608573984 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 307161985788
      2015-11-25 17:54:20 140378833417984 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2015-11-25 17:54:20 140379608573984 [Note] Plugin 'FEEDBACK' is disabled.
      2015-11-25 17:54:20 140379608573984 [Note] Recovering after a crash using tc.log
      2015-11-25 17:54:20 140379608573984 [ERROR] Recovery failed! You must enable exactly 3 storage engines that support two-phase commit protocol
      2015-11-25 17:54:20 140379608573984 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
      2015-11-25 17:54:20 140379608573984 [ERROR] Can't init tc log
      2015-11-25 17:54:20 140379608573984 [ERROR] Aborting

      Attachments

        1. SafariSchermSnapz001.jpg
          69 kB
          Sander Vancanneyt
        2. Schermafbeelding 2015-11-27 om 23.34.16.png
          65 kB
          Sander Vancanneyt

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              vancanneyt Sander Vancanneyt
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.