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

Reproducible crash (mysqld got signal 11) in multi_delete::initialize_tables with semijoin+materialization

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.2, 5.5.30, 5.5.29-galera, 5.3.12
    • 10.0.3, 5.5.31, 5.3.13
    • None
    • ubuntu 12.04 percise

    Description

      The attached sql file causes MariaDB to crash, leaving the following in syslog:

      mysqld: Server version: 5.5.29-MariaDB-mariadb1~precise-log
      mysqld: key_buffer_size=134217728
      mysqld: read_buffer_size=2097152
      mysqld: max_used_connections=1
      mysqld: max_threads=102
      mysqld: thread_count=1
      mysqld: It is possible that mysqld could use up to 
      mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759225 K  bytes of memory
      mysqld: Hope that's ok; if not, decrease some variables in the equation.
      mysqld: 
      mysqld: Thread pointer: 0x0x7ff296d2bfd0
      mysqld: Attempting backtrace. You can use the following information to find out
      mysqld: where mysqld died. If you see no messages after this, something went
      mysqld: terribly wrong...
      mysqld: stack_bottom = 0x7ff2920bee40 thread_stack 0x48000
      mysqld: ??:0(??)[0x7ff292a542fb]
      mysqld: ??:0(??)[0x7ff292679aa1]
      mysqld: ??:0(??)[0x7ff290eedcb0]
      mysqld: ??:0(??)[0x7ff292794ccc]
      mysqld: ??:0(??)[0x7ff2925716ed]
      mysqld: ??:0(??)[0x7ff29257617b]
      mysqld: ??:0(??)[0x7ff29252fa9b]
      mysqld: ??:0(??)[0x7ff29252fcf7]
      mysqld: ??:0(??)[0x7ff29252ffdf]
      mysqld: ??:0(??)[0x7ff29253204f]
      mysqld: ??:0(??)[0x7ff2925326c3]
      mysqld: ??:0(??)[0x7ff2925eee63]
      mysqld: ??:0(??)[0x7ff2925eef61]
      mysqld: ??:0(??)[0x7ff290ee5e9a]
      mysqld: ??:0(??)[0x7ff290616ccd]
      mysqld: 
      mysqld: Trying to get some variables.
      mysqld: Some pointers may be invalid and cause the dump to abort.
      mysqld: Query (0x7ff2500699e8): is an invalid pointer
      mysqld: Connection ID (thread ID): 34
      mysqld: Status: NOT_KILLED
      mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off

      Attachments

        1. crash.sql
          0.7 kB
          Israel Tsadok

        Activity

          People

            psergei Sergei Petrunia
            itsadok Israel Tsadok
            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.