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

Occasional crashes during execution of events

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.6.21
    • N/A
    • Server
    • Ubuntu 22.04
      Dedicated Hetzner EX130-S
      CPU: Intel Xeon Gold 5412U with multi-threading enabled
      Motherboard: ASRock SPC741D8UD-2T/X550/H
      Memory: Samsung M321R4GA3BB6-CQKEG 32GBx4 DIMM (128GB)
    • Not for Release Notes

    Description

      Hello,

      MariaDB 10.6.21 server (10.6.21-0ubuntu0.22.04.2) on Ubuntu 22.04 has been sporadically crashing during execution of stored procedures (detailed specifications in Environment field). The two stored procedures in question (TennisProcessSubqueueV2 and BasketballProcessSubqueueV2) run each second 24x7 via similarly named events (TennisProcessSubqueue and BasketballProcessSubqueue), mostly without problems. The followling lines may be of special interest:
      Apr 08 11:55:15 prematch-mysql-2 mariadbd[1780740]: Status: KILL_SERVER
      Apr 08 11:55:15 prematch-mysql-2 mariadbd[1780740]: Query (0x7fbaece3dae0): CALL TennisProcessSubqueueV2()

      I have attached the backtrace recorded in logs, the crash dump, list of active plugins and the stored procedures. Unfortunately, I do not have a query log saved for this crash.

      I am open to any suggestions, e.g., if a MariaDB update will resolve this bug or any other information that is needed from my side.

      Thank you in advance for your time. Best regards.

      Attachments

        1. TennisProcessSubqueueV2.txt
          11 kB
        2. mysql_plugins.txt
          6 kB
        3. my.cnf
          4 kB
        4. gdb.log
          1.16 MB
        5. crash_dump.txt
          0.1 kB
        6. cpuinfo.txt
          2 kB
        7. BasketballProcessSubqueueV2.txt
          11 kB
        8. backtrace.txt
          16 kB

        Activity

          People

            Unassigned Unassigned
            SportsEnjoyer Exefeed Admin
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.