Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3, 10.4
-
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 ()
|
|