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
        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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20290 Server crash in st_select_lex::cleanup or Assertion `sl->join == 0' failed in reinit_stmt_before_use

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16529 [Draft] Server crashes in cleanup_empty_jtbm_semi_joins on 2nd execution of SP

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20803 IF NOT EXISTS AND NOT EXISTS crash DB server

          • Major - Major loss of function.
          • Closed

          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.