XMLWordPrintable

Details

    Description

      This query crashes my database:

      DELETE indeclaratievoortgangsuggestie FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=476
      7788

      A select * FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=476
      7788

      Works fine and returns one record.

      Server version: 11.2.3-MariaDB-1:11.2.3+maria~ubu2204-log source revision: 79580f4f96fc2547711f674eb8dd514abd312b4a
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=241
      max_threads=802
      thread_count=241
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1897788 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x7ee1ac000c68
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7ee4b445fc38 thread_stack 0x49000
      /usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x5582d20d6d02]
      /usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x5582d1ba9968]
      /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f45d6242520]
      /usr/sbin/mariadbd(handler_rowid_filter_check+0x58)[0x5582d1bb7a38]
      /usr/sbin/mariadbd(+0xe82984)[0x5582d1f5f984]
      /usr/sbin/mariadbd(+0xe861c7)[0x5582d1f631c7]
      /usr/sbin/mariadbd(+0xdc12ac)[0x5582d1e9e2ac]
      /usr/sbin/mariadbd(ZN7handler10ha_rnd_posEPhS0+0x2da)[0x5582d1bb169a]
      /usr/sbin/mariadbd(_Z16rr_from_pointersP11READ_RECORD+0x3c)[0x5582d185607c]
      /usr/sbin/mariadbd(_ZN12multi_delete16do_table_deletesEP5TABLEP9SORT_INFOb+0x98)[0x5582d18df048]
      /usr/sbin/mariadbd(_ZN12multi_delete10do_deletesEv+0x88)[0x5582d18df308]
      /usr/sbin/mariadbd(_ZN12multi_delete8send_eofEv+0x75)[0x5582d18df3e5]
      /usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0xf8a)[0x5582d19abe6a]
      /usr/sbin/mariadbd(_ZN4JOIN4execEv+0x3f)[0x5582d19ac31f]
      /usr/sbin/mariadbd(_ZN11Sql_cmd_dml13execute_innerEP3THD+0x7a)[0x5582d19ac44a]
      /usr/sbin/mariadbd(_ZN14Sql_cmd_delete13execute_innerEP3THD+0x2a)[0x5582d18decea]
      /usr/sbin/mariadbd(_ZN11Sql_cmd_dml7executeEP3THD+0xc3)[0x5582d1963f23]
      /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x4672)[0x5582d192ce22]
      /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5582d192ddb7]
      /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14cd)[0x5582d19305ad]
      /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x5582d19324b8]
      /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5582d1a5e8ff]
      /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x5582d1a5ec4d]
      /usr/sbin/mariadbd(+0xcfce26)[0x5582d1dd9e26]
      /lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f45d6294ac3]
      nptl/pthread_create.c:442(start_thread)[0x7f45d6326850]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7ee1ac011650): DELETE indeclaratievoortgangsuggestie FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=4767788

      Connection ID (thread ID): 6923
      Status: NOT_KILLED

      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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=off

      The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
      information that should help you find out what is causing the crash.
      Writing a core file...
      Working directory at /intel1/mydata/data
      Resource Limits:
      Limit Soft Limit Hard Limit Units
      Max cpu time unlimited unlimited seconds
      Max file size unlimited unlimited bytes
      Max data size unlimited unlimited bytes
      Max stack size 8388608 unlimited bytes
      Max core file size 0 unlimited bytes
      Max resident set unlimited unlimited bytes
      Max processes 2062195 2062195 processes
      Max open files 100000 100000 files
      Max locked memory 524288 524288 bytes
      Max address space unlimited unlimited bytes
      Max file locks unlimited unlimited locks
      Max pending signals 2062195 2062195 signals
      Max msgqueue size 819200 819200 bytes
      Max nice priority 0 0
      Max realtime priority 0 0
      Max realtime timeout unlimited unlimited us
      Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g – %E

      Kernel version: Linux version 6.2.0-39-generic (buildd@lcy02-amd64-045) (x86_64-linux-gnu-gcc-11 (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #40~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Thu Nov 16 10:53:04 UTC 2

      Attachments

        Issue Links

          Activity

            People

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