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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.5.9
    • N/A
    • Server
    • None
    • 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. log
          17 kB
          densin
        2. test_creat.sql
          0.6 kB
          densin
        3. test_kill.sql
          7 kB
          densin
        4. test_notkill.sql
          7 kB
          densin

        Issue Links

          Activity

            People

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