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

Crash on with/window functions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.9
    • 10.2.18, 10.3.10
    • N/A
    • None
    • centos 7.4

    Description

      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: This could be because you hit a bug. It is also possible that this binary
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: or one of the libraries it was linked against is corrupt, improperly built,
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: or misconfigured. This error can also be caused by malfunctioning hardware.
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: We will try our best to scrape up some info that will hopefully help
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: diagnose the problem, but since we have already crashed,
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: something is definitely wrong and this may fail.
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: Server version: 10.3.9-MariaDB
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: key_buffer_size=134217728
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: read_buffer_size=131072
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: max_used_connections=1
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: max_threads=153
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: thread_count=10
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: It is possible that mysqld could use up to
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467396 K  bytes of memory
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: Hope that's ok; if not, decrease some variables in the equation.
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: Thread pointer: 0x7f5bf40009a8
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: Attempting backtrace. You can use the following information to find out
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: where mysqld died. If you see no messages after this, something went
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: terribly wrong...
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: stack_bottom = 0x7f5c90664d00 thread_stack 0x49000
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: ======= Backtrace: =========
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /lib64/libc.so.6(__fortify_fail+0x37)[0x7f672522f6e7]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /lib64/libc.so.6(+0x116862)[0x7f672522d862]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /lib64/libc.so.6(+0x118647)[0x7f672522f647]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x5614e5aec17a]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x5614e5ad5802]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(handle_fatal_signal+0x357)[0x5614e5565f37]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /lib64/libpthread.so.0(+0xf6d0)[0x7f6726e796d0]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z19find_field_in_tableP3THDP5TABLEPKcmbPj+0x1d)[0x5614e533a75d]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z23find_field_in_table_refP3THDP10TABLE_LISTPKcmS4_S4_S4_PP4ItembbPjbPS2_+0x774)[0x5614e533b0a4]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z20find_field_in_tablesP3THDP10Item_identP10TABLE_LISTS4_PP4Item27find_item_error_report_typebb+0x2cc)[0x5614e533b5ec]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN10Item_field10fix_fieldsEP3THDPP4Item+0x317)[0x5614e558ac97]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0x13f)[0x5614e55d153f]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z13setup_on_exprP3THDP10TABLE_LISTb+0x1c0)[0x5614e533d9b0]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z11setup_condsP3THDP10TABLE_LISTR4ListIS1_EPP4Item+0x19e)[0x5614e533dbde]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0x4c9)[0x5614e53db209]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN18st_select_lex_unit12prepare_joinEP3THDP13st_select_lexP13select_resultmb+0x113)[0x5614e542a243]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN18st_select_lex_unit7prepareEP10TABLE_LISTP13select_resultm+0xfbd)[0x5614e542dc4d]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z21mysql_derived_prepareP3THDP3LEXP10TABLE_LIST+0x266)[0x5614e535be96]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z20mysql_handle_derivedP3LEXj+0x215)[0x5614e535c845]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x94)[0x5614e533a6b4]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN18Prepared_statement7prepareEPKcj+0x673)[0x5614e53a8c33]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN18Prepared_statement17execute_immediateEPKcj+0x66)[0x5614e53acf16]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z32mysql_sql_stmt_execute_immediateP3THD+0x1c3)[0x5614e53ad173]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2dfa)[0x5614e539313a]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x5614e52ff366]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5614e5306e19]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x63b)[0x5614e530785b]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x860)[0x5614e5302cf0]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x74d)[0x5614e5303f0d]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(+0x5a3039)[0x5614e5389039]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(+0x5a4566)[0x5614e538a566]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x5614e538ad80]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1585)[0x5614e53918c5]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x5614e52ff366]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5614e5306e19]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x63b)[0x5614e530785b]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x860)[0x5614e5302cf0]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x74d)[0x5614e5303f0d]
      		 
      Aug 28 22:02:47 ip-10-0-192-142.ec2.internal mysqld[26776]: /usr/sbin/mysqld(+0x5a3039)[0x5614e5389039]

      Attachments

        1. crashy2.sql
          9 kB
          Aria Stewart
        2. schema.sql
          4 kB
          Aria Stewart

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16992 Assertion `table_ref->table || table_ref->view' failed in Field_iterator_table_ref::set_field_iterator

          • Major - Major loss of function.
          • Closed

          Activity

            People

              alice Alice Sherepa
              aredridel Aria Stewart
              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.