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

Not able to shutdown MariaDB after upgrade. Happening randomly.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.4.12
    • N/A
    • Server
    • Centos 6.10

    Description

      It was observed that mysql.server stop not working all the times. It seems get stuck in loop. We have upgraded Maria DB 10.3.15 to 10.4.12 and observing this issue. Here are some more details:
      Environment : Centos 6.10
      Attaching "bash -x /opt/proofpoint/current/opt/mysql/support-files/mysql.server stop" output (bashtrace.txt)

      Also did strace on mysqld pid 

      [testing@rajxxx abcdef]$ ps aux | grep mysql
      		 
      testing      16488  0.0  0.0 103328   896 pts/1    S+   20:23   0:00 grep mysql
      		 
      testing      21007  0.0  0.1 125820 10652 ?        S    10:23   0:00 /bin/sh /opt/testing/testing-7.2.y/opt/mysql/bin/mysqld_safe --defaults-file=/opt/testing/testing-7.2.y/etc/db/my.cnf --ledir=/opt/testing/testing-7.2.y/opt/mysql/bin --datadir=/opt/testing/testing-7.2.y/opt/mysql/data --pid-file=/opt/testing/testing-7.2.y/var/run/mysqld.pid
      		 
      testing      21297  0.2  3.6 2608196 302196 ?      Sl   10:23   1:37 /opt/testing/testing-7.2.y/opt/mysql/bin/mysqld --defaults-file=/opt/testing/testing-7.2.y/etc/db/my.cnf --basedir=/opt/testing/testing-7.2.y/opt/mysql --datadir=/opt/testing/testing-7.2.y/opt/mysql/data --plugin-dir=/opt/testing/testing-7.2.y/opt/mysql/lib/plugin --log-error=/opt/testing/testing-7.2.y/var/log/db/mysqld.err --pid-file=/opt/testing/testing-7.2.y/var/run/mysqld.pid --socket=/opt/testing/testing-7.2.y/opt/mysql/data/mysql.sock --port=3306
      		 
      [testing@rajxxx abcdef]$
      		 
      ============
      		 
      strace -p 21297   getting stuck at below
      		 
      -------
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      select(0, NULL, NULL, NULL, {0, 1000})  = 0 (Timeout)
      		 
      -----------

      Attachments

        1. bashtrace.txt
          20 kB
        2. killmysqld.txt
          1 kB
        3. mysql.server_when_hang.log
          0.6 kB
        4. mysqld_bt_all_threads.txt
          16 kB
        5. mysqld_full_bt_all_threads_when_hang.txt
          18 kB
        6. mysqld_when_hang.err
          20 kB
        7. mysqld.err
          8.49 MB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21707 Mariadb doesn't exit correctly

          • Major - Major loss of function.
          • Closed

          Activity

            People

              wlad Vladislav Vaintroub
              vrpprasad prasad
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.