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

[draft] protocol.cc:587: void Protocol::end_statement(): Assertion `0' failed.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2(EOL)
    • N/A
    • N/A
    • None

    Description

      ./runall-new.pl --duration=600 --seed=time --threads=1 --grammar=conf/optimizer/1my.yy  --gendata-advance  --basedir1=/home/alice/git/10.2 --mysqld=--optimizer-switch='materialization=on' --mysqld2=--optimizer-switch='materialization=off' 
      

      Version: '10.2.14-MariaDB-debug-log'  socket: '/home/alice/git/10.2/mysql-test/var/mysql.sock'  port: 19300  Source distribution
      mysqld: /home/alice/git/10.2/sql/protocol.cc:587: void Protocol::end_statement(): Assertion `0' failed.
      180319 16:00:56 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.2.14-MariaDB-debug-log
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=2
      max_threads=153
      thread_count=8
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467401 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x7fda88000a98
      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 = 0x7fdadd3fdec0 thread_stack 0x49000
      mysys/stacktrace.c:267(my_print_stacktrace)[0x55a46b905621]
      sql/signal_handler.cc:168(handle_fatal_signal)[0x55a46b19e0ab]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fdaf3958390]
      linux/raise.c:54(__GI_raise)[0x7fdaf2d11428]
      stdlib/abort.c:91(__GI_abort)[0x7fdaf2d1302a]
      assert/assert.c:92(__assert_fail_base)[0x7fdaf2d09bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fdaf2d09c82]
      sql/protocol.cc:584(Protocol::end_statement())[0x55a46ae63759]
      sql/sql_parse.cc:2364(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55a46af2a954]
      sql/sql_parse.cc:1360(do_command(THD*))[0x55a46af2778d]
      sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55a46b075f35]
      sql/sql_connect.cc:1242(handle_one_connection)[0x55a46b075cb5]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fdaf394e6ba]
      x86_64/clone.S:111(clone)[0x7fdaf2de341d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fda888e9600): ANALYZE FORMAT=JSON UPDATE IGNORE E AS OUTR1 LEFT OUTER JOIN C AS OUTR2 ON ( OUTR1.`col_varchar_nokey` = OUTR2.`col_varchar_nokey` ) INNER JOIN C AS OUTR3 ON ( OUTR1.`col_varchar_key` = OUTR3.`col_varchar_key` ) SET OUTR1.`col_varchar_nokey` = 'lmkpykmyxuijmngxndtucfftz', OUTR2.`col_varchar_key` = 1 WHERE OUTR1.`col_varchar_nokey` = ( SELECT INNR1.`col_varchar_nokey` AS y FROM DD AS INNR2 JOIN BB AS INNR1 ON ( INNR2.`pk` > INNR1.`col_int_nokey` ) WHERE OUTR1.`col_int_key` <> 6 ORDER BY INNR1.`col_datetime_key` )  /* QNO 829 CON_ID 14 */
      Connection ID (thread ID): 14
      Status: NOT_KILLED
      

      Thread 1 (Thread 0x7fdadd3fe700 (LWP 18936)):
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x000055a46b905713 in my_write_core (sig=6) at /home/alice/git/10.2/mysys/stacktrace.c:477
      #2  0x000055a46b19e4d3 in handle_fatal_signal (sig=6) at /home/alice/git/10.2/sql/signal_handler.cc:305
      #3  <signal handler called>
      #4  0x00007fdaf2d11428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fdaf2d1302a in __GI_abort () at abort.c:89
      #6  0x00007fdaf2d09bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55a46b9f62d0 "0", file=file@entry=0x55a46b9f6068 "/home/alice/git/10.2/sql/protocol.cc", line=line@entry=587, function=function@entry=0x55a46b9f6b30 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()") at assert.c:92
      #7  0x00007fdaf2d09c82 in __GI___assert_fail (assertion=0x55a46b9f62d0 "0", file=0x55a46b9f6068 "/home/alice/git/10.2/sql/protocol.cc", line=587, function=0x55a46b9f6b30 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()") at assert.c:101
      #8  0x000055a46ae63759 in Protocol::end_statement (this=0x7fda88001058) at /home/alice/git/10.2/sql/protocol.cc:587
      #9  0x000055a46af2a954 in dispatch_command (command=COM_QUERY, thd=0x7fda88000a98, packet=0x7fda88387bb9 " ANALYZE FORMAT=JSON UPDATE IGNORE E AS OUTR1 LEFT OUTER JOIN C AS OUTR2 ON ( OUTR1.`col_varchar_nokey` = OUTR2.`col_varchar_nokey` ) INNER JOIN C AS OUTR3 ON ( OUTR1.`col_varchar_key` = OUTR3.`col_va"..., packet_length=544, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:2363
      #10 0x000055a46af2778d in do_command (thd=0x7fda88000a98) at /home/alice/git/10.2/sql/sql_parse.cc:1360
      #11 0x000055a46b075f35 in do_handle_one_connection (connect=0x55a46da40348) at /home/alice/git/10.2/sql/sql_connect.cc:1335
      #12 0x000055a46b075cb5 in handle_one_connection (arg=0x55a46da40348) at /home/alice/git/10.2/sql/sql_connect.cc:1241
      #13 0x00007fdaf394e6ba in start_thread (arg=0x7fdadd3fe700) at pthread_create.c:333
      #14 0x00007fdaf2de341d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      also with ANALYZE DELETE

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.