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

[signal 11]Running simple query with many input values in MariaDB results in signal 11

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.15

    Description

      Hello
      A signal 11 crash occurred when I received about 1220 input values from the BI tool called Tableau and executed a simple query.
      I don't know what the cause is.
      Attach the mysql_error.log where the crash occurred.
      Give them a hand.

      [OS]
      Ubuntu 22.04.2 LTS
      CPU 48 Core (Intel(R) Xeon(R) Silver 4310 CPU @ 2.10GHz)
      MEMORY 263752616 KB

      [DB]
      MariaDB 10.6.15
      table_open_cache = 4096
      join_buffer_size = 512K
      read_buffer_size = 512K
      read_rnd_buffer_size = 1M
      sort_buffer_size = 8M
      bulk_insert_buffer_size = 32M
      thread_stack = 512K
      max_heap_table_size = 256M
      tmp_table_size = 256M
      max_prepared_stmt_count = 256K
      innodb_buffer_pool_size = 175G
      innodb_data_file_path = ibdata1:10M:autoextend
      innodb_log_buffer_size = 64M
      innodb_log_file_size = 512M

      Attachments

        Issue Links

          Activity

            danblack Daniel Black added a comment -

            Thank you for the bug report.

            The crash information you have provided looks like the bug MDEV-32064, and a fix for this is due out any day now in version 10.6.16.

            When this is released, can you please with the same query confirm if it is fixed.

            danblack Daniel Black added a comment - Thank you for the bug report. The crash information you have provided looks like the bug MDEV-32064 , and a fix for this is due out any day now in version 10.6.16. When this is released, can you please with the same query confirm if it is fixed.
            danblack Daniel Black added a comment -

            In the mean time, setting in_predicate_conversion_threshold either globally or session to a higher value than the default 1000 (or whatever you are using) might avoid the crash successfully.

            danblack Daniel Black added a comment - In the mean time, setting in_predicate_conversion_threshold either globally or session to a higher value than the default 1000 (or whatever you are using) might avoid the crash successfully.
            jmlee 이종명 added a comment -

            Thank you for the cause of the problem and for your help to resolve it temporarily

            jmlee 이종명 added a comment - Thank you for the cause of the problem and for your help to resolve it temporarily

            People

              Unassigned Unassigned
              jmlee 이종명
              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.