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

table with too much redundant key coz 10.5.9 crash signal kill 11

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.5.9
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
      None
    • Environment:
      ubuntu 20.04 and also mariadb docker

      Description

      after migrate to mariadb 10.5.9. docker ( default config)
      I found some sql can crash database (got signal 11).
      after scrutinize , found that coz old table with too much redundant key index and
      long IN condition sql.

      attachment
      1. sample of tables create (test_creat.sql)
      2. sql which got signal 11 ( test_kill.sql)
      3. similar sql just reduce IN one array which no problem ( test_notkill.sql)

        Attachments

        1. test_creat.sql
          0.6 kB
        2. test_kill.sql
          7 kB
        3. test_notkill.sql
          7 kB
        4. log
          17 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              densin densin
              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.