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
          prasad
        2. killmysqld.txt
          1 kB
          prasad
        3. mysql.server_when_hang.log
          0.6 kB
          prasad
        4. mysqld_bt_all_threads.txt
          16 kB
          prasad
        5. mysqld_full_bt_all_threads_when_hang.txt
          18 kB
          prasad
        6. mysqld_when_hang.err
          20 kB
          prasad
        7. mysqld.err
          8.49 MB
          prasad

        Issue Links

          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.