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

Server 10.4 sporadically crashes when issuing simple INSERT commands

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.4.10
    • N/A
    • Server
    • None
    • Linux 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1 (2019-04-12) x86_64 GNU/Linux

      AMD Epyc, 256Go RAM, 3xNVMe disks, software RAID
      Linux

    Description

      Since we upgraded to 10.4.10 less than a week ago, we encountered 6 crashes, all occurred during a simple INSERT statement, all seemingly crashing in _ZN4JOIN7destroyEv (we don't have debug symbols so this is all we have).

      The problem NEVER occurred on our preproduction server, which has Intel Xeon processor and SSD SATA hard drives, but the load on that one is several orders of magnitude smaller.

      Stack traces attached. 5 crashed during an INSERT, 1 during an INSERT IGNORE

      Also we had a dozen records inserted in the course of last week, and we were able to execute some more without crashing the server, and as we got only 6 crashes we are rather confident that not all queries crash.

      On the other hand that's about 50% of them !

      Attachments

        1. 191211-16-11-02
          6 kB
          Christophe Migliorini
        2. 191212-13-31-05
          6 kB
          Christophe Migliorini
        3. 191213-11-49-20
          6 kB
          Christophe Migliorini
        4. 191213-12-14-01
          6 kB
          Christophe Migliorini
        5. 191213-12-54-02
          6 kB
          Christophe Migliorini
        6. 191213-14-11-47
          6 kB
          Christophe Migliorini
        7. 191215 12-37-28
          4 kB
          Christophe Migliorini

        Issue Links

          Activity

            People

              Unassigned Unassigned
              c_migliorini Christophe Migliorini
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.