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

Crash using two window functions

    XMLWordPrintable

Details

    Description

      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: 181003 19:47:09 [ERROR] mysqld got signal 11 ;
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: This could be because you hit a bug. It is also possible that this binary
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: or one of the libraries it was linked against is corrupt, improperly built,
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: We will try our best to scrape up some info that will hopefully help
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: diagnose the problem, but since we have already crashed,
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: something is definitely wrong and this may fail.
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: Server version: 10.3.9-MariaDB
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: key_buffer_size=134217728
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: read_buffer_size=131072
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: max_used_connections=2
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: max_threads=153
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: thread_count=10
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: It is possible that mysqld could use up to
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467396 K  bytes of memory
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: Hope that's ok; if not, decrease some variables in the equation.
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: Thread pointer: 0x7f59c40009a8
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: Attempting backtrace. You can use the following information to find out
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: where mysqld died. If you see no messages after this, something went
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: terribly wrong...
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: stack_bottom = 0x7f64e00bdd00 thread_stack 0x49000
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: ======= Backtrace: =========
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /lib64/libc.so.6(__fortify_fail+0x37)[0x7f64ed0d06e7]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /lib64/libc.so.6(+0x116862)[0x7f64ed0ce862]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /lib64/libc.so.6(+0x118647)[0x7f64ed0d0647]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x563a65a4517a]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x563a65a2e802]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(handle_fatal_signal+0x357)[0x563a654bef37]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /lib64/libpthread.so.0(+0xf6d0)[0x7f64eed1a6d0]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(+0x6df944)[0x563a6541e944]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(+0x6dfb75)[0x563a6541eb75]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN24Window_funcs_computation5setupEP3THDP4ListI16Item_window_funcEP13st_join_table+0x1b2)[0x563a65421ef2]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN21make_aggr_tables_infoEv+0x170a)[0x563a6533756a]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN15optimize_stage2Ev+0x1433)[0x563a6533e2c3]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0xfbc)[0x563a6534026c]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x37)[0x563a65341a97]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0xd3)[0x563a652b62e3]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xe4)[0x563a652b5bd4]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x5a4)[0x563a6533f854]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x37)[0x563a65341a97]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x563a65343064]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x563a65343bfc]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(+0x4ba19f)[0x563a651f919f]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6c7d)[0x563a652effbd]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x563a652f27cb]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1d25)[0x563a652f5315]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x563a652f617e]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x563a653c650a]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x563a653c662d]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /usr/sbin/mysqld(+0x93291d)[0x563a6567191d]
      Oct 03 19:47:09 ip-10-0-192-142.ec2.internal mysqld[26921]: /lib64/libpthread.so.0(+0x7e25)[0x7f64eed12e25]
      

      Attachments

        Issue Links

          Activity

            People

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