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

Assertion `0' failed in Protocol::end_statement

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3, 10.4
    • N/A
    • N/A
    • None

    Description

      --source include/have_partition.inc
       
      set join_cache_level = 5;
      set optimizer_switch="mrr=on";
       
      create table t1 (pk int, id int) engine=myisam;
      insert into t1 values (10,null),(11,8),(12,1);
       
      create table t2 (pk int not null primary key, id int) engine=myisam 
      partition by hash(pk) partitions 2;
       
      insert into t2 values (10,null),(13,9),(14,1);
       
      select 1 from (t2 as t straight_join (t1 straight_join t2 on t2.pk = t1.id) on (t2.id = t1.pk));
      

      Reproducible with MyIsam/Aria, not with InnoDB

      10.3 d46ffaf6afdcfc5b9241d

      mysqld: /10.3/sql/protocol.cc:588: void Protocol::end_statement(): Assertion `0' failed.
      190502 15:15:52 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:54(__GI_raise)[0x7fe6a1c70428]
      stdlib/abort.c:91(__GI_abort)[0x7fe6a1c7202a]
      assert/assert.c:92(__assert_fail_base)[0x7fe6a1c68bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe6a1c68c82]
      sql/protocol.cc:585(Protocol::end_statement())[0x55c99e122ae1]
      sql/sql_parse.cc:2416(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c99e36ce9c]
      sql/sql_parse.cc:1404(do_command(THD*))[0x55c99e36711b]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c99e6bcbf8]
      sql/sql_connect.cc:1309(handle_one_connection)[0x55c99e6bc5d5]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55c99f9eb9f1]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe6a28ad6ba]
      x86_64/clone.S:111(clone)[0x7fe6a1d4241d]
      

      On non-debug server hangs:

      10.4 2b7e080faece853f

      Thread 6 (Thread 0x7ff9447b1700 (LWP 27919)):
      #0  0x00007ff94b4fb74d in poll () at ../sysdeps/unix/syscall-template.S:84
      #1  0x00005600d6f90f40 in poll (__timeout=28800000, __nfds=1, __fds=0x7ff9447b05a0) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46
      #2  vio_io_wait (vio=vio@entry=0x5600da40f288, event=<optimized out>, timeout=28800000) at /10.4/vio/viosocket.c:976
      #3  0x00005600d6f91042 in vio_socket_io_wait (vio=0x5600da40f288, event=<optimized out>) at /10.4/vio/viosocket.c:118
      #4  0x00005600d6f91125 in vio_read (vio=0x5600da40f288, buf=0x7ff934009be8 "\001", size=4) at /10.4/vio/viosocket.c:195
      #5  0x00005600d6b71a4e in my_real_read (net=0x7ff934000c18, complen=complen@entry=0x7ff9447b0838, header=header@entry=1 '\001') at /10.4/sql/net_serv.cc:962
      #6  0x00005600d6b72901 in my_net_read_packet_reallen (net=net@entry=0x7ff934000c18, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7ff9447b0888) at /10.4/sql/net_serv.cc:1243
      #7  0x00005600d6b729fb in my_net_read_packet (net=net@entry=0x7ff934000c18, read_from_server=read_from_server@entry=1 '\001') at /10.4/sql/net_serv.cc:1227
      #8  0x00005600d689cff1 in do_command (thd=0x7ff9340009a8) at /10.4/sql/sql_parse.cc:1234
      #9  0x00005600d696a534 in do_handle_one_connection (connect=connect@entry=0x5600da40ecd8) at /10.4/sql/sql_connect.cc:1398
      #10 0x00005600d696a654 in handle_one_connection (arg=arg@entry=0x5600da40ecd8) at /10.4/sql/sql_connect.cc:1301
      #11 0x00005600d6f01c44 in pfs_spawn_thread (arg=0x5600da40ef38) at /10.4/storage/perfschema/pfs.cc:1862
      #12 0x00007ff94c2766ba in start_thread (arg=0x7ff9447b1700) at pthread_create.c:333
      #13 0x00007ff94b50741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       
      Thread 5 (Thread 0x7ff9447fb700 (LWP 27916)):
      #0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
      #1  0x00005600d67f6edd in inline_mysql_cond_wait (src_file=0x5600d6fe77d0 "/10.4/sql/slave.cc", src_line=519, mutex=<optimized out>, that=<optimized out>) at /10.4/include/mysql/psi/mysql_thread.h:1167
      #2  handle_slave_background (arg=arg@entry=0x0) at /10.4/sql/slave.cc:519
      #3  0x00005600d6f01c44 in pfs_spawn_thread (arg=0x5600da3f9fd8) at /10.4/storage/perfschema/pfs.cc:1862
      #4  0x00007ff94c2766ba in start_thread (arg=0x7ff9447fb700) at pthread_create.c:333
      #5  0x00007ff94b50741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       
      Thread 4 (Thread 0x7ff944845700 (LWP 27915)):
      #0  0x00007ff94b436b26 in __GI___sigwaitinfo (set=<optimized out>, set@entry=0x7ff944844c20, info=info@entry=0x7ff944844ca0) at ../sysdeps/unix/sysv/linux/sigwaitinfo.c:56
      #1  0x00005600d67d9bb3 in my_sigwait (code=<synthetic pointer>, sig=0x7ff944844c18, set=0x7ff944844c20) at /10.4/include/my_pthread.h:196
      #2  signal_hand (arg=arg@entry=0x0) at /10.4/sql/mysqld.cc:3245
      #3  0x00005600d6f01c44 in pfs_spawn_thread (arg=0x5600da395638) at /10.4/storage/perfschema/pfs.cc:1862
      #4  0x00007ff94c2766ba in start_thread (arg=0x7ff944845700) at pthread_create.c:333
      #5  0x00007ff94b50741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       
      Thread 3 (Thread 0x7ff945046700 (LWP 27914)):
      #0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
      #1  0x00005600d6c1360d in inline_mysql_cond_timedwait (src_file=0x5600d7103f38 "/10.4/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7ff945045c80, mutex=0x5600d81743e0 <LOCK_checkpoint>, that=0x5600d81743a0 <COND_checkpoint>) at /10.4/include/mysql/psi/mysql_thread.h:1204
      #2  my_service_thread_sleep (control=control@entry=0x5600d78b42c0 <checkpoint_control>, sleep_time=<optimized out>) at /10.4/storage/maria/ma_servicethread.c:115
      #3  0x00005600d6c0cb3a in ma_checkpoint_background (arg=arg@entry=0x1e) at /10.4/storage/maria/ma_checkpoint.c:707
      #4  0x00005600d6f01c44 in pfs_spawn_thread (arg=0x5600da32b1d8) at /10.4/storage/perfschema/pfs.cc:1862
      #5  0x00007ff94c2766ba in start_thread (arg=0x7ff945046700) at pthread_create.c:333
      #6  0x00007ff94b50741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       
      Thread 2 (Thread 0x7ff9463b2700 (LWP 27913)):
      #0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
      #1  0x00005600d6f48807 in inline_mysql_cond_timedwait (that=0x5600d81d3e20 <COND_timer>, mutex=0x5600d81d3e60 <LOCK_timer>, src_file=0x5600d7161de8 "/10.4/mysys/thr_timer.c", src_line=292, abstime=0x7ff9463b1cf0) at /10.4/include/mysql/psi/mysql_thread.h:1204
      #2  timer_handler (arg=arg@entry=0x0) at /10.4/mysys/thr_timer.c:292
      #3  0x00005600d6f01c44 in pfs_spawn_thread (arg=0x5600da24a328) at /10.4/storage/perfschema/pfs.cc:1862
      #4  0x00007ff94c2766ba in start_thread (arg=0x7ff9463b2700) at pthread_create.c:333
      #5  0x00007ff94b50741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       
      Thread 1 (Thread 0x7ff94d9308c0 (LWP 27912)):
      #0  0x00007ff94b4fb74d in poll () at ../sysdeps/unix/syscall-template.S:84
      #1  0x00007ff94b5190be in __poll_chk (fds=<optimized out>, nfds=<optimized out>, timeout=<optimized out>, fdslen=<optimized out>) at poll_chk.c:27
      #2  0x00005600d67e3069 in poll (__timeout=-1, __nfds=2, __fds=0x7ffe544701a0) at /usr/include/x86_64-linux-gnu/bits/poll2.h:41
      #3  handle_connections_sockets () at /10.4/sql/mysqld.cc:6440
      #4  0x00005600d67e4372 in mysqld_main (argc=131, argv=0x5600da14a818) at /10.4/sql/mysqld.cc:5876
      #5  0x00007ff94b420830 in __libc_start_main (main=0x5600d67be640 <main(int, char**)>, argc=7, argv=0x7ffe54470548, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffe54470538) at ../csu/libc-start.c:291
      #6  0x00005600d67d7769 in _start ()
      
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            alice Alice Sherepa
            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.