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

MariaDB crashes because of "long semaphore wait"after migrating from 10.1 to 10.3

    Details

      Description

      We have a Windows server that has been running MariaDB 10.1 successfully for over a year. The server remains mostly idle for long times with some read access, but occasionally there are transactions that add data (about 500k rows per commit). There can be up to 10 such transactions (one per database) at the same time and during those times the server is under quite some load (the code processing the data resides on the same server as the database).

      When trying to use MariaDB 10.3, during those load times the database crashes and logs "[FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung."

      I figure it could be related to MariaDB switching from XtraDB to InnoDB and on the mailing list it was suggested to file a bug.

      I'm attaching the error log. I cannot attach a minidump as-is because upon inspection it contained sensitive data that I'm not allowed to disclose. If absolutely neccessary, I can try and reproduce the problem with random test data, but this might take a few days.

      The mailing list entry mentioned above can be found here: https://lists.launchpad.net/maria-discuss/msg05139.html

      Regards,
      Tom.

        Attachments

        1. uniqstack.txt
          17 kB
        2. my.ini
          1 kB
        3. mariadb_clean.err
          1.17 MB
        4. gdb.180561.txt.gz
          519 kB
        5. gdb_short.txt
          9.18 MB
        6. gdb_core.64996.txt
          39 kB
        7. gdb_core.180561.txt
          5 kB
        8. error_mysqld.log
          635 kB

          Issue Links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                tdcf Tom Deory
              • Votes:
                2 Vote for this issue
                Watchers:
                12 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: