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

Not able to shutdown MariaDB after upgrade. Happening randomly.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.4.12
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              vrpprasad prasad
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration