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

Server 10.4 sporadically crashes when issuing simple INSERT commands

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.4.10
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
      None
    • Environment:
      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
        2. 191212-13-31-05
          6 kB
        3. 191213-11-49-20
          6 kB
        4. 191213-12-14-01
          6 kB
        5. 191213-12-54-02
          6 kB
        6. 191213-14-11-47
          6 kB
        7. 191215 12-37-28
          4 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              c_migliorini Christophe Migliorini
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: