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

Upgrade Instructions 10.1 to 10.2 Result In Indefinite Shutdown Duration

    XMLWordPrintable

Details

    Description

      The directions to upgrade from 10.1 to 10.2.

      Step 2 spent nearly 2 days shutting down before I killed it (-9).

      Every minute, the mysql/error.log emits a message like:

      InnoDB: number of bytes of change buffer just merged: 18433

      The number changes a bit but not much each time.

      I can't query the database's system variables to discover the size of the change buffer so I can't estimate how long it's going to take.

      The change buffer defaults to 25% of the buffer pool size which defaults to 128M, which would imply over 24 hours to shut down. This seems to be a bug – particularly since taking down a database server for 24 hours must be scheduled into a maintenance cycle and all services, such as websites, are down for the duration.

      This symptom has cropped up with the percona server upgrade as well in the last few days.

      Of possible relevance is the fact that I had, previously, updated my apt sources.list.d to contain:

      # cat /etc/apt/sources.list.d/MariaDB.list 
      # MariaDB 10.2 repository list - created 2017-06-13 00:34 UTC
      # http://downloads.mariadb.org/mariadb/repositories/
      deb [arch=i386,amd64] https://mirrors.evowise.com/mariadb/repo/10.2/debian stretch main
      deb-src https://mirrors.evowise.com/mariadb/repo/10.2/debian stretch main
      

      And done an apt-get update and apt-get upgrade to install 10.2, not understanding that this would not be completed automatically – and that the aforelinked upgrade instructions from 10.1 to 10.2 must be followed.

      I've attached an strace of the threads involved.

      Here is a list of the logs accessed by mysql currently.

      # lsof -nc mysqld | grep -vE '(.so(..*)?$|.frm|.MY?|.ibd|ib_logfile|ibdata|TCP)'
      mysqld  21386 mysql  cwd    DIR    8,0       4096   49910 /var/lib/mysql
      mysqld  21386 mysql  rtd    DIR    8,0       4096       2 /
      mysqld  21386 mysql  txt    REG    8,0   17504392   10289 /usr/sbin/mysqld
      mysqld  21386 mysql  mem    REG    8,0      24576   49290 /var/lib/mysql/tc.log
      mysqld  21386 mysql  DEL    REG   0,12            1535549 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535548 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535547 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535546 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535545 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535544 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535543 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535542 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535541 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535540 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535539 /[aio]
      mysqld  21386 mysql  DEL    REG   0,12            1535538 /[aio]
      mysqld  21386 mysql    0r   CHR    1,3        0t0 1532830 /dev/null
      mysqld  21386 mysql    1w   REG    8,0     238675   65782 /var/log/mysql/error.log.1
      mysqld  21386 mysql    2w   REG    8,0     238675   65782 /var/log/mysql/error.log.1
      mysqld  21386 mysql    3uW  REG    8,0         52   49333 /var/lib/mysql/aria_log_control
      mysqld  21386 mysql    4r   DIR    8,0       4096   49910 /var/lib/mysql
      mysqld  21386 mysql    5u   REG    8,0      16384   49498 /var/lib/mysql/aria_log.00000001
      mysqld  21386 mysql    7u   REG    8,0          0  303444 /tmp/ibyVu6X2 (deleted)
      mysqld  21386 mysql    9u   REG    8,0          0  303542 /tmp/ibg6db2S (deleted)
      mysqld  21386 mysql   10u   REG    8,0          0  303543 /tmp/ib6iaebJ (deleted)
      mysqld  21386 mysql   14u   REG    8,0          0  303544 /tmp/ibC6qilE (deleted)
      mysqld  21386 mysql  129u   REG    8,0      24576   49290 /var/lib/mysql/tc.log
      

      Here are the relevant packages that are installed according to apt-show-versions:

      # apt-show-versions|grep maria
      libmariadbclient18:amd64/stretch 10.1.23-9+deb9u1 upgradeable to 10.2.6+maria~stretch
      libmariadbclient18:i386 not installed
      mariadb-client-10.1:amd64/stretch 10.1.23-9+deb9u1 uptodate
      mariadb-client-10.1:i386 not installed
      mariadb-client-core-10.1:amd64/stretch 10.1.23-9+deb9u1 uptodate
      mariadb-client-core-10.1:i386 not installed
      mariadb-common:all/stretch 10.2.6+maria~stretch uptodate
      mariadb-server-10.1:amd64/stretch 10.1.23-9+deb9u1 uptodate
      mariadb-server-10.1:i386 not installed
      mariadb-server-core-10.1:amd64/stretch 10.1.23-9+deb9u1 uptodate
      mariadb-server-core-10.1:i386 not installed
      mysql-common:all/stretch 10.2.6+maria~stretch uptodate
      # apt-show-versions|grep mysql
      dbconfig-mysql:all/stretch 2.0.8 uptodate
      default-mysql-server:all/stretch 1.0.2 uptodate
      erlang-p1-mysql:amd64/stretch 1.0.1-4 uptodate
      erlang-p1-mysql:i386 not installed
      libdbd-mysql-perl:amd64/stretch 4.041-2 uptodate
      libdbd-mysql-perl:i386 not installed
      mysql-common:all/stretch 10.2.6+maria~stretch uptodate
      php-mysql:all/stretch 1:7.1+52+0~20170504085116.17+stretch~1.gbpd2ab76 uptodate
      php5-mysqlnd:amd64 5.6.30+dfsg-0+deb8u1 installed: No available version in archive
      php5-mysqlnd-ms:amd64 1.6.0-1+b1 installed: No available version in archive
      php5.6-mysql:amd64/stretch 5.6.30-12+0~20170609083959.35+stretch~1.gbp12ca9d uptodate
      php5.6-mysql:i386 not installed
      php7.0-mysql:amd64/stretch 7.0.20-1+0~20170609083149.33+stretch~1.gbp2cd6b6 uptodate
      php7.0-mysql:i386 not installed
      php7.1-mysql:amd64/stretch 7.1.6-1+0~20170609083224.26+stretch~1.gbpa2f43a uptodate
      php7.1-mysql:i386 not installed
      

      Attachments

        Issue Links

          Activity

            People

              greenman Ian Gilfillan
              jabowery James Bowery
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.