[MDEV-19407] Assertion `field->table->stats_is_read' failed in is_eits_usable - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.25, 10.1.41, 10.3.16, 10.4.5
Component/s: Optimizer
Labels:
None

Description

10.2 1214674b712d855d7cd0
mysqld: /10.2/sql/sql_statistics.cc:4094: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed.
190507 12:53:28 [ERROR] mysqld got signal 6 ;

linux/raise.c:54(__GI_raise)[0x7f544fa35428]
stdlib/abort.c:91(__GI_abort)[0x7f544fa3702a]
assert/assert.c:92(__assert_fail_base)[0x7f544fa2dbd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f544fa2dc82]
sql/sql_statistics.cc:4104(is_eits_usable(Field*))[0x5599dc61e251]
sql/opt_range.cc:2730(create_key_parts_for_pseudo_indexes(RANGE_OPT_PARAM, st_bitmap))[0x5599dcd40d2d]
sql/opt_range.cc:3057(calculate_cond_selectivity_for_table(THD, TABLE, Item**))[0x5599dcd42830]
sql/sql_select.cc:4497(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x5599dc514061]
sql/sql_select.cc:1583(JOIN::optimize_inner())[0x5599dc4f8f54]
sql/sql_select.cc:1116(JOIN::optimize())[0x5599dc4f4753]
sql/sql_select.cc:3806(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x5599dc50dcbb]
sql/sql_select.cc:376(handle_select(THD, LEX, select_result*, unsigned long))[0x5599dc4ed59b]
sql/sql_parse.cc:4003(mysql_execute_command(THD*))[0x5599dc4643e5]
sql/sql_parse.cc:8020(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x5599dc47d79b]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x5599dc458e25]
sql/sql_parse.cc:1387(do_command(THD*))[0x5599dc455fa2]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x5599dc77f796]
sql/sql_connect.cc:1242(handle_one_connection)[0x5599dc77f19e]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f54506726ba]
x86_64/clone.S:111(clone)[0x7f544fb0741d]

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mdev19407.yy
0.2 kB
2019-05-09 11:55
mysql.err
8 kB
2019-05-09 11:55
mysql.log
26 kB
2019-05-09 11:55

Issue Links

relates to

MDEV-19061 table_share used for reading statistical tables is not protected

Closed

MDEV-19334 bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed.

Closed

Activity

Ascending order - Click to sort in descending order

Marko Mäkelä added a comment - 2019-05-07 18:39

I am raising the priority to Blocker for the 10.4.5 release due to a few reasons:

The 10.2 revision for which this was reported does include the ~~MDEV-19344~~ fix.
As of this writing, the ~~MDEV-19344~~ fix has not been merged to 10.3 or 10.4 yet.
~~MDEV-19344~~ was filed because the assertion was failing in numerous tests in 10.4 after a merge from 10.1. The assertion in 10.4 is currently disabled.

Before removing the blocker status, I think that at the very least, the ~~MDEV-19344~~ assertion should be enabled in 10.4 and all existing tests in the 10.4 should run successfully. This is not meaningful without merging (or cherry-picking) the ~~MDEV-19344~~ fix to 10.4. A bonus would be to diagnose and fix the reported 10.2 crash as well.

The reason why I think that this is a blocker for the 10.4.5 release is that in 10.4, EITS is enabled by default, while in older versions it needs to be enabled explicitly.

Marko Mäkelä added a comment - 2019-05-07 18:39 I am raising the priority to Blocker for the 10.4.5 release due to a few reasons: The 10.2 revision for which this was reported does include the MDEV-19344 fix. As of this writing, the MDEV-19344 fix has not been merged to 10.3 or 10.4 yet. MDEV-19344 was filed because the assertion was failing in numerous tests in 10.4 after a merge from 10.1. The assertion in 10.4 is currently disabled. Before removing the blocker status, I think that at the very least, the MDEV-19344 assertion should be enabled in 10.4 and all existing tests in the 10.4 should run successfully. This is not meaningful without merging (or cherry-picking) the MDEV-19344 fix to 10.4. A bonus would be to diagnose and fix the reported 10.2 crash as well. The reason why I think that this is a blocker for the 10.4.5 release is that in 10.4, EITS is enabled by default, while in older versions it needs to be enabled explicitly.

Alice Sherepa added a comment - 2019-05-09 11:55

1) On 10.2 9d3e2a7ca29143028cea0053 - assertion repeatable with 2 or more threads with rqg

perl ./runall-new.pl --grammar=conf/mariadb/bugs/mdev19407.yy --skip-gendata  --queries=1M --duration=300  --seed=time  --mysqld=--optimizer-use-condition-selectivity=4 --mysqld=--use-stat-tables='preferably' --basedir=/git/10.2 --vardir=/1  --threads=2

mdev19407.yy
thread1_init:
create table t1 (pk int);
INSERT INTO t1 values (1),(2),(3);

query:
CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 \|
SELECT 1 FROM t1 WHERE pk >2 \|
OPTIMIZE TABLE t1;

3) While trying the same on 10.1 410585ca639dc6b40b56d8e, server hangs:

[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".

0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84

84	../sysdeps/unix/syscall-template.S: No such file or directory.

Thread 29 (Thread 0x7f2bd5762700 (LWP 20303)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e45a248a in safe_cond_timedwait (cond=0x7f2bb1653188, mp=0x7f2bb16b21e0, abstime=0x7f2bd575f920, file=0x5575e4889140 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547

#2  0x00005575e459e8cf in inline_mysql_cond_timedwait (that=0x7f2bb1653188, mutex=0x7f2bb16b21e0, abstime=0x7f2bd575f920, src_file=0x5575e4889178 "/git/10.1/mysys/thr_lock.c", src_line=575) at /git/10.1/include/mysql/psi/mysql_thread.h:1202

#3  0x00005575e459ef4a in wait_for_lock (wait=0x7f2bb16b22b0, data=0x7f2bb1691c60, in_wait_list=0 '\000', lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:575

#4  0x00005575e459faa3 in thr_lock (data=0x7f2bb1691c60, owner=0x7f2bb1641888, lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:1012

#5  0x00005575e45a0369 in thr_multi_lock (data=0x7f2bb1669230, count=1, owner=0x7f2bb1641888, lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:1291

#6  0x00005575e3fd65be in mysql_lock_tables (thd=0x7f2bb1640008, sql_lock=0x7f2bb1669210, flags=0) at /git/10.1/sql/lock.cc:320

#7  0x00005575e3fd63f2 in mysql_lock_tables (thd=0x7f2bb1640008, tables=0x7f2bb166a6f0, count=1, flags=0) at /git/10.1/sql/lock.cc:275

#8  0x00005575e3c2ef4b in open_ltable (thd=0x7f2bb1640008, table_list=0x7f2bb166a620, lock_type=TL_WRITE, lock_flags=0) at /git/10.1/sql/sql_base.cc:5342

#9  0x00005575e3de4ee3 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f2bb1640008, tables=0x7f2bb166a620, check_opt=0x7f2bb1644aa0, operator_name=0x5575e46d1678 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5575e3eed478 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /git/10.1/sql/sql_admin.cc:982

#10 0x00005575e3de5fe9 in Sql_cmd_optimize_table::execute (this=0x7f2bb16600f0, thd=0x7f2bb1640008) at /git/10.1/sql/sql_admin.cc:1307

#11 0x00005575e3c9dd61 in mysql_execute_command (thd=0x7f2bb1640008) at /git/10.1/sql/sql_parse.cc:5702

#12 0x00005575e3ca290b in mysql_parse (thd=0x7f2bb1640008, rawbuf=0x7f2bb92afea0 "OPTIMIZE TABLE t1 /* QNO 2 CON_ID 7 */", length=38, parser_state=0x7f2bd57610a0) at /git/10.1/sql/sql_parse.cc:7469

#13 0x00005575e3c90f96 in dispatch_command (command=COM_QUERY, thd=0x7f2bb1640008, packet=0x7f2bb1646009 "", packet_length=39) at /git/10.1/sql/sql_parse.cc:1499

#14 0x00005575e3c8fd18 in do_command (thd=0x7f2bb1640008) at /git/10.1/sql/sql_parse.cc:1131

#15 0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb1640008) at /git/10.1/sql/sql_connect.cc:1330

#16 0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb1640008) at /git/10.1/sql/sql_connect.cc:1242

#17 0x00007f2bd71866ba in start_thread (arg=0x7f2bd5762700) at pthread_create.c:333

#18 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 28 (Thread 0x7f2bd84d3700 (LWP 20301)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e45a248a in safe_cond_timedwait (cond=0x7f2bb16301b0, mp=0x7f2bb1630100, abstime=0x7f2bd84ced40, file=0x5575e46cf7a0 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547

#2  0x00005575e3ddb5dc in inline_mysql_cond_timedwait (that=0x7f2bb16301b0, mutex=0x7f2bb1630100, abstime=0x7f2bd84ced40, src_file=0x5575e46cfaf8 "/git/10.1/sql/mdl.cc", src_line=1088) at /git/10.1/include/mysql/psi/mysql_thread.h:1202

#3  0x00005575e3ddc92f in MDL_wait::timed_wait (this=0x7f2bb1630100, owner=0x7f2bb16300b8, abs_timeout=0x7f2bd84ced40, set_status_on_timeout=false, wait_state_name=0x5575e4e76d70 <MDL_key::m_namespace_to_wait_state_name+48>) at /git/10.1/sql/mdl.cc:1088

#4  0x00005575e3dde46c in MDL_context::acquire_lock (this=0x7f2bb1630100, mdl_request=0x7f2bd84cee00, lock_wait_timeout=31536000) at /git/10.1/sql/mdl.cc:2125

#5  0x00005575e3ddeb6e in MDL_context::upgrade_shared_lock (this=0x7f2bb1630100, mdl_ticket=0x7f2ba88162c0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /git/10.1/sql/mdl.cc:2318

#6  0x00005575e3c28bf9 in wait_while_table_is_used (thd=0x7f2bb1630008, table=0x7f2ba890bc08, function=HA_EXTRA_PREPARE_FOR_RENAME) at /git/10.1/sql/sql_base.cc:1879

#7  0x00005575e3d5b836 in mysql_inplace_alter_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620, table=0x7f2ba890bc08, altered_table=0x7f2ba894d008, ha_alter_info=0x7f2bd84cf230, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f2bd84cf2a0, alter_ctx=0x7f2bd84cfe50) at /git/10.1/sql/sql_table.cc:7190

#8  0x00005575e3d60501 in mysql_alter_table (thd=0x7f2bb1630008, new_db=0x0, new_name=0x0, create_info=0x7f2bd84d0a60, table_list=0x7f2ba8b1d620, alter_info=0x7f2bd84d09a0, order_num=0, order=0x0, ignore=false) at /git/10.1/sql/sql_table.cc:9078

#9  0x00005575e3d62c0d in mysql_recreate_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620, table_copy=false) at /git/10.1/sql/sql_table.cc:9855

#10 0x00005575e3de1e08 in admin_recreate_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620) at /git/10.1/sql/sql_admin.cc:58

#11 0x00005575e3de4db8 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f2bb1630008, tables=0x7f2ba8b1d620, check_opt=0x7f2bb1634aa0, operator_name=0x5575e46d1678 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5575e3eed478 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /git/10.1/sql/sql_admin.cc:966

#12 0x00005575e3de5fe9 in Sql_cmd_optimize_table::execute (this=0x7f2ba780e0f0, thd=0x7f2bb1630008) at /git/10.1/sql/sql_admin.cc:1307

#13 0x00005575e3c9dd61 in mysql_execute_command (thd=0x7f2bb1630008) at /git/10.1/sql/sql_parse.cc:5702

#14 0x00005575e3ca290b in mysql_parse (thd=0x7f2bb1630008, rawbuf=0x7f2ba8aef0e0 "OPTIMIZE TABLE t1 /* QNO 3 CON_ID 6 */", length=38, parser_state=0x7f2bd84d20a0) at /git/10.1/sql/sql_parse.cc:7469

#15 0x00005575e3c90f96 in dispatch_command (command=COM_QUERY, thd=0x7f2bb1630008, packet=0x7f2bb163b009 "", packet_length=39) at /git/10.1/sql/sql_parse.cc:1499

#16 0x00005575e3c8fd18 in do_command (thd=0x7f2bb1630008) at /git/10.1/sql/sql_parse.cc:1131

#17 0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb1630008) at /git/10.1/sql/sql_connect.cc:1330

#18 0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb1630008) at /git/10.1/sql/sql_connect.cc:1242

#19 0x00007f2bd71866ba in start_thread (arg=0x7f2bd84d3700) at pthread_create.c:333

#20 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 27 (Thread 0x7f2bd851d700 (LWP 20292)):

#0  0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e4647592 in vio_io_wait (vio=0x7f2bd4c50c08, event=VIO_IO_EVENT_READ, timeout=28800000) at /git/10.1/vio/viosocket.c:992

#2  0x00005575e4645dfe in vio_socket_io_wait (vio=0x7f2bd4c50c08, event=VIO_IO_EVENT_READ) at /git/10.1/vio/viosocket.c:108

#3  0x00005575e4645fb1 in vio_read (vio=0x7f2bd4c50c08, buf=0x7f2bb9390008 "\a", size=4) at /git/10.1/vio/viosocket.c:184

#4  0x00005575e3bd10e4 in my_real_read (net=0x7f2bb162a2c8, complen=0x7f2bd851c800, header=1 '\001') at /git/10.1/sql/net_serv.cc:877

#5  0x00005575e3bd1878 in my_net_read_packet (net=0x7f2bb162a2c8, read_from_server=1 '\001') at /git/10.1/sql/net_serv.cc:1140

#6  0x00005575e3c8f750 in do_command (thd=0x7f2bb162a008) at /git/10.1/sql/sql_parse.cc:1002

#7  0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb162a008) at /git/10.1/sql/sql_connect.cc:1330

#8  0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb162a008) at /git/10.1/sql/sql_connect.cc:1242

#9  0x00007f2bd71866ba in start_thread (arg=0x7f2bd851d700) at pthread_create.c:333

#10 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 26 (Thread 0x7f2bd8567700 (LWP 20291)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x00005575e45a2180 in safe_cond_wait (cond=0x5575e5049b80 <COND_slave_background>, mp=0x5575e504cc40 <LOCK_slave_background>, file=0x5575e46845c0 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1165) at /git/10.1/mysys/thr_mutex.c:493

#2  0x00005575e3be66f8 in inline_mysql_cond_wait (that=0x5575e5049b80 <COND_slave_background>, mutex=0x5575e504cc40 <LOCK_slave_background>, src_file=0x5575e4684e28 "/git/10.1/sql/slave.cc", src_line=336) at /git/10.1/include/mysql/psi/mysql_thread.h:1165

#3  0x00005575e3be73e8 in handle_slave_background (arg=0x0) at /git/10.1/sql/slave.cc:336

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bd8567700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 25 (Thread 0x7f2bd85b1700 (LWP 20290)):

#0  do_sigwait (sig=0x7f2bd85b0ca0, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64

#1  __sigwait (set=<optimized out>, sig=0x7f2bd85b0ca0) at ../sysdeps/unix/sysv/linux/sigwait.c:96

#2  0x00005575e3bc278b in signal_hand (arg=0x0) at /git/10.1/sql/mysqld.cc:3408

#3  0x00007f2bd71866ba in start_thread (arg=0x7f2bd85b1700) at pthread_create.c:333

#4  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 24 (Thread 0x7f2ba9ffe700 (LWP 20289)):

#0  0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307

#2  0x00005575e43fce9a in btr_defragment_thread () at /git/10.1/storage/xtradb/btr/btr0defragment.cc:708

#3  0x00007f2bd71866ba in start_thread (arg=0x7f2ba9ffe700) at pthread_create.c:333

#4  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 23 (Thread 0x7f2baa7ff700 (LWP 20288)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x00005575e429aba4 in os_cond_wait (cond=0x7f2bd4f2d2e8, fast_mutex=0x7f2bd4f2d2b0) at /git/10.1/storage/xtradb/os/os0sync.cc:196

#2  0x00005575e429af12 in os_event_wait_low (event=0x7f2bd4f2d2b0, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:477

#3  0x00005575e4417fb1 in buf_dump_thread () at /git/10.1/storage/xtradb/buf/buf0dump.cc:731

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2baa7ff700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 22 (Thread 0x7f2babffe700 (LWP 20287)):

#0  0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307

#2  0x00005575e4421baa in page_cleaner_sleep_if_needed (next_loop_time=1557401217676) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2678

#3  0x00005575e442262d in buf_flush_lru_manager_thread (arg=0x0) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2979

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2babffe700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 21 (Thread 0x7f2bac7ff700 (LWP 20286)):

#0  0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307

#2  0x00005575e4421baa in page_cleaner_sleep_if_needed (next_loop_time=1557401217678) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2678

#3  0x00005575e4421f0a in buf_flush_page_cleaner_thread (arg=0x0) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2819

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bac7ff700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 20 (Thread 0x7f2bae3f9700 (LWP 20285)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x00005575e429aba4 in os_cond_wait (cond=0x7f2bd4f2d198, fast_mutex=0x7f2bd4f2d160) at /git/10.1/storage/xtradb/os/os0sync.cc:196

#2  0x00005575e429af12 in os_event_wait_low (event=0x7f2bd4f2d160, reset_sig_count=3) at /git/10.1/storage/xtradb/os/os0sync.cc:477

#3  0x00005575e4365264 in srv_resume_thread (slot=0x5575e58a5298 <srv_sys+536>, sig_count=3, wait=true, timeout_usec=0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:1082

#4  0x00005575e436b190 in srv_purge_coordinator_suspend (slot=0x5575e58a5298 <srv_sys+536>, rseg_history_len=13) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3492

#5  0x00005575e436b542 in srv_purge_coordinator_thread (arg=0x0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3583

#6  0x00007f2bd71866ba in start_thread (arg=0x7f2bae3f9700) at pthread_create.c:333

#7  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 19 (Thread 0x7f2baebfa700 (LWP 20284)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2ea88, fast_mutex=0x7f2bd4f2ea50, abstime=0x7f2baebf9c60) at /git/10.1/storage/xtradb/os/os0sync.cc:159

#2  0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2ea50, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591

#3  0x00005575e43b4fa1 in ib_wqueue_timedwait (wq=0x7f2bd4c5b4f8, wait_in_usecs=5000000) at /git/10.1/storage/xtradb/ut/ut0wqueue.cc:155

#4  0x00005575e44c33da in fts_optimize_thread (arg=0x7f2bd4c5b4f8) at /git/10.1/storage/xtradb/fts/fts0opt.cc:2916

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2baebfa700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 18 (Thread 0x7f2baf3fb700 (LWP 20283)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2e7e8, fast_mutex=0x7f2bd4f2e7b0, abstime=0x7f2baf3fad10) at /git/10.1/storage/xtradb/os/os0sync.cc:159

#2  0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2e7b0, time_in_usec=10000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591

#3  0x00005575e4475cf5 in dict_stats_thread () at /git/10.1/storage/xtradb/dict/dict0stats_bg.cc:534

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2baf3fb700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 17 (Thread 0x7f2bafbfc700 (LWP 20282)):

#0  0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307

#2  0x00005575e436a5e5 in srv_master_sleep () at /git/10.1/storage/xtradb/srv/srv0srv.cc:3116

#3  0x00005575e436a729 in srv_master_thread (arg=0x0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3166

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bafbfc700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 16 (Thread 0x7f2bb03fd700 (LWP 20281)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2d208, fast_mutex=0x7f2bd4f2d1d0, abstime=0x7f2bb03fccb0) at /git/10.1/storage/xtradb/os/os0sync.cc:159

#2  0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2d1d0, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591

#3  0x00005575e436836a in srv_error_monitor_thread () at /git/10.1/storage/xtradb/srv/srv0srv.cc:2424

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bb03fd700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 15 (Thread 0x7f2bb0bfe700 (LWP 20280)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2e548, fast_mutex=0x7f2bd4f2e510, abstime=0x7f2bb0bfdcf0) at /git/10.1/storage/xtradb/os/os0sync.cc:159

#2  0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2e510, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591

#3  0x00005575e4267221 in lock_wait_timeout_thread () at /git/10.1/storage/xtradb/lock/lock0wait.cc:597

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bb0bfe700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 14 (Thread 0x7f2bb13ff700 (LWP 20274)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2d278, fast_mutex=0x7f2bd4f2d240, abstime=0x7f2bb13fecc0) at /git/10.1/storage/xtradb/os/os0sync.cc:159

#2  0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2d240, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591

#3  0x00005575e4367d3c in srv_monitor_thread () at /git/10.1/storage/xtradb/srv/srv0srv.cc:2183

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bb13ff700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 13 (Thread 0x7f2bb2bf6700 (LWP 20273)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=3, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=9, message1=0x7f2bb2bf5cc0, message2=0x7f2bb2bf5cc8, type=0x7f2bb2bf5cd0, space_id=0x7f2bb2bf5cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=9) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99e8 <n+72>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb2bf6700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 12 (Thread 0x7f2bb33f7700 (LWP 20272)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=2, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=8, message1=0x7f2bb33f6cc0, message2=0x7f2bb33f6cc8, type=0x7f2bb33f6cd0, space_id=0x7f2bb33f6cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=8) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99e0 <n+64>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb33f7700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 11 (Thread 0x7f2bb3bf8700 (LWP 20271)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=1, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=7, message1=0x7f2bb3bf7cc0, message2=0x7f2bb3bf7cc8, type=0x7f2bb3bf7cd0, space_id=0x7f2bb3bf7cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=7) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99d8 <n+56>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb3bf8700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 10 (Thread 0x7f2bb43f9700 (LWP 20270)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=6, message1=0x7f2bb43f8cc0, message2=0x7f2bb43f8cc8, type=0x7f2bb43f8cd0, space_id=0x7f2bb43f8cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=6) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99d0 <n+48>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb43f9700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 9 (Thread 0x7f2bb4bfa700 (LWP 20269)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=3, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=5, message1=0x7f2bb4bf9cc0, message2=0x7f2bb4bf9cc8, type=0x7f2bb4bf9cd0, space_id=0x7f2bb4bf9cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=5) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99c8 <n+40>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb4bfa700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 8 (Thread 0x7f2bb53fb700 (LWP 20268)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=2, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=4, message1=0x7f2bb53facc0, message2=0x7f2bb53facc8, type=0x7f2bb53facd0, space_id=0x7f2bb53facd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=4) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99c0 <n+32>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb53fb700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 7 (Thread 0x7f2bb5bfc700 (LWP 20267)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=1, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=3, message1=0x7f2bb5bfbcc0, message2=0x7f2bb5bfbcc8, type=0x7f2bb5bfbcd0, space_id=0x7f2bb5bfbcd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=3) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99b8 <n+24>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb5bfc700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 6 (Thread 0x7f2bb63fd700 (LWP 20266)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=2, message1=0x7f2bb63fccc0, message2=0x7f2bb63fccc8, type=0x7f2bb63fccd0, space_id=0x7f2bb63fccd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=2) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99b0 <n+16>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb63fd700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 5 (Thread 0x7f2bb6bfe700 (LWP 20265)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83440, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=1, message1=0x7f2bb6bfdcc0, message2=0x7f2bb6bfdcc8, type=0x7f2bb6bfdcd0, space_id=0x7f2bb6bfdcd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=1) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99a8 <n+8>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb6bfe700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 4 (Thread 0x7f2bb73ff700 (LWP 20264)):

#0  0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c834a0, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618

#2  0x00005575e4297b35 in os_aio_linux_handle (global_seg=0, message1=0x7f2bb73fecc0, message2=0x7f2bb73fecc8, type=0x7f2bb73fecd0, space_id=0x7f2bb73fecd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772

#3  0x00005575e448aaa8 in fil_aio_wait (segment=0) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239

#4  0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99a0 <n>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bb73ff700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 3 (Thread 0x7f2bc2fff700 (LWP 20263)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e45a248a in safe_cond_timedwait (cond=0x5575e5877b20 <COND_checkpoint>, mp=0x5575e5877a60 <LOCK_checkpoint>, abstime=0x7f2bc2ffec90, file=0x5575e47a8760 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547

#2  0x00005575e40f4fb3 in inline_mysql_cond_timedwait (that=0x5575e5877b20 <COND_checkpoint>, mutex=0x5575e5877a60 <LOCK_checkpoint>, abstime=0x7f2bc2ffec90, src_file=0x5575e47a8798 "/git/10.1/storage/maria/ma_servicethread.c", src_line=116) at /git/10.1/include/mysql/psi/mysql_thread.h:1202

#3  0x00005575e40f544a in my_service_thread_sleep (control=0x5575e4e81b00 <checkpoint_control>, sleep_time=30000000000) at /git/10.1/storage/maria/ma_servicethread.c:115

#4  0x00005575e40e92bc in ma_checkpoint_background (arg=0x1e) at /git/10.1/storage/maria/ma_checkpoint.c:708

#5  0x00007f2bd71866ba in start_thread (arg=0x7f2bc2fff700) at pthread_create.c:333

#6  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 2 (Thread 0x7f2bd4bff700 (LWP 20262)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005575e45a248a in safe_cond_timedwait (cond=0x5575e58cc260 <COND_timer>, mp=0x5575e58cc1a0 <LOCK_timer>, abstime=0x7f2bd4bfed40, file=0x5575e4889c20 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547

#2  0x00005575e45a386a in inline_mysql_cond_timedwait (that=0x5575e58cc260 <COND_timer>, mutex=0x5575e58cc1a0 <LOCK_timer>, abstime=0x7f2bd4bfed40, src_file=0x5575e4889c58 "/git/10.1/mysys/thr_timer.c", src_line=292) at /git/10.1/include/mysql/psi/mysql_thread.h:1202

#3  0x00005575e45a4318 in timer_handler (arg=0x0) at /git/10.1/mysys/thr_timer.c:292

#4  0x00007f2bd71866ba in start_thread (arg=0x7f2bd4bff700) at pthread_create.c:333

#5  0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 1 (Thread 0x7f2bd85cd900 (LWP 20261)):

#0  0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x00005575e3bc82f1 in handle_connections_sockets () at /git/10.1/sql/mysqld.cc:6548

#2  0x00005575e3bc729c in mysqld_main (argc=16, argv=0x7f2bd4c5e238) at /git/10.1/sql/mysqld.cc:5973

#3  0x00005575e3bbc310 in main (argc=16, argv=0x7ffc910235c8) at /git/10.1/sql/main.cc:25

3) On 10.3 09aa5d3f6988e92f869ad

set use_stat_tables='preferably';

set optimizer_use_condition_selectivity=4;

CREATE TABLE test.tmp AS SELECT * FROM mysql.proxies_priv WHERE `User`='root' ;

10.3/sql/sql_statistics.cc:4087: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed.

sql/sql_statistics.cc:4088(is_eits_usable(Field*))[0x5600db3dd26f]

sql/opt_range.cc:2737(create_key_parts_for_pseudo_indexes(RANGE_OPT_PARAM*, st_bitmap*))[0x5600dbc41e37]

sql/opt_range.cc:3065(calculate_cond_selectivity_for_table(THD*, TABLE*, Item**))[0x5600dbc43950]

sql/sql_select.cc:5003(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x5600db2cc2fd]

sql/sql_select.cc:1888(JOIN::optimize_inner())[0x5600db2af99c]

sql/sql_select.cc:1451(JOIN::optimize())[0x5600db2ab704]

sql/sql_select.cc:4226(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5600db2c5a3d]

sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5600db2a0f4b]

sql/sql_parse.cc:4293(mysql_execute_command(THD*))[0x5600db218904]

sql/sql_parse.cc:8091(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5600db2307f8]

sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5600db20b327]

sql/sql_parse.cc:1404(do_command(THD*))[0x5600db20848d]

sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5600db55d5d0]

sql/sql_connect.cc:1309(handle_one_connection)[0x5600db55cfad]

perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5600dc88105d]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3707f586ba]

x86_64/clone.S:111(clone)[0x7f37073ed41d]

Marko, you probably meant ~~MDEV-19334~~ ^^ (not 19344?)

Alice Sherepa added a comment - 2019-05-09 11:55 1) On 10.2 9d3e2a7ca29143028cea0053 - assertion repeatable with 2 or more threads with rqg perl ./runall-new.pl --grammar=conf/mariadb/bugs/mdev19407.yy --skip-gendata --queries=1M --duration=300 --seed=time --mysqld=--optimizer-use-condition-selectivity=4 --mysqld=--use-stat-tables='preferably' --basedir=/git/10.2 --vardir=/1 --threads=2 mdev19407.yy thread1_init: create table t1 (pk int); INSERT INTO t1 values (1),(2),(3); query: CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 | SELECT 1 FROM t1 WHERE pk >2 | OPTIMIZE TABLE t1; 3) While trying the same on 10.1 410585ca639dc6b40b56d8e, server hangs: [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84 84 ../sysdeps/unix/syscall-template.S: No such file or directory. Thread 29 (Thread 0x7f2bd5762700 (LWP 20303)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e45a248a in safe_cond_timedwait (cond=0x7f2bb1653188, mp=0x7f2bb16b21e0, abstime=0x7f2bd575f920, file=0x5575e4889140 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547 #2 0x00005575e459e8cf in inline_mysql_cond_timedwait (that=0x7f2bb1653188, mutex=0x7f2bb16b21e0, abstime=0x7f2bd575f920, src_file=0x5575e4889178 "/git/10.1/mysys/thr_lock.c", src_line=575) at /git/10.1/include/mysql/psi/mysql_thread.h:1202 #3 0x00005575e459ef4a in wait_for_lock (wait=0x7f2bb16b22b0, data=0x7f2bb1691c60, in_wait_list=0 '\000', lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:575 #4 0x00005575e459faa3 in thr_lock (data=0x7f2bb1691c60, owner=0x7f2bb1641888, lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:1012 #5 0x00005575e45a0369 in thr_multi_lock (data=0x7f2bb1669230, count=1, owner=0x7f2bb1641888, lock_wait_timeout=31536000) at /git/10.1/mysys/thr_lock.c:1291 #6 0x00005575e3fd65be in mysql_lock_tables (thd=0x7f2bb1640008, sql_lock=0x7f2bb1669210, flags=0) at /git/10.1/sql/lock.cc:320 #7 0x00005575e3fd63f2 in mysql_lock_tables (thd=0x7f2bb1640008, tables=0x7f2bb166a6f0, count=1, flags=0) at /git/10.1/sql/lock.cc:275 #8 0x00005575e3c2ef4b in open_ltable (thd=0x7f2bb1640008, table_list=0x7f2bb166a620, lock_type=TL_WRITE, lock_flags=0) at /git/10.1/sql/sql_base.cc:5342 #9 0x00005575e3de4ee3 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f2bb1640008, tables=0x7f2bb166a620, check_opt=0x7f2bb1644aa0, operator_name=0x5575e46d1678 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5575e3eed478 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /git/10.1/sql/sql_admin.cc:982 #10 0x00005575e3de5fe9 in Sql_cmd_optimize_table::execute (this=0x7f2bb16600f0, thd=0x7f2bb1640008) at /git/10.1/sql/sql_admin.cc:1307 #11 0x00005575e3c9dd61 in mysql_execute_command (thd=0x7f2bb1640008) at /git/10.1/sql/sql_parse.cc:5702 #12 0x00005575e3ca290b in mysql_parse (thd=0x7f2bb1640008, rawbuf=0x7f2bb92afea0 "OPTIMIZE TABLE t1 /* QNO 2 CON_ID 7 */", length=38, parser_state=0x7f2bd57610a0) at /git/10.1/sql/sql_parse.cc:7469 #13 0x00005575e3c90f96 in dispatch_command (command=COM_QUERY, thd=0x7f2bb1640008, packet=0x7f2bb1646009 "", packet_length=39) at /git/10.1/sql/sql_parse.cc:1499 #14 0x00005575e3c8fd18 in do_command (thd=0x7f2bb1640008) at /git/10.1/sql/sql_parse.cc:1131 #15 0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb1640008) at /git/10.1/sql/sql_connect.cc:1330 #16 0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb1640008) at /git/10.1/sql/sql_connect.cc:1242 #17 0x00007f2bd71866ba in start_thread (arg=0x7f2bd5762700) at pthread_create.c:333 #18 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 28 (Thread 0x7f2bd84d3700 (LWP 20301)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e45a248a in safe_cond_timedwait (cond=0x7f2bb16301b0, mp=0x7f2bb1630100, abstime=0x7f2bd84ced40, file=0x5575e46cf7a0 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547 #2 0x00005575e3ddb5dc in inline_mysql_cond_timedwait (that=0x7f2bb16301b0, mutex=0x7f2bb1630100, abstime=0x7f2bd84ced40, src_file=0x5575e46cfaf8 "/git/10.1/sql/mdl.cc", src_line=1088) at /git/10.1/include/mysql/psi/mysql_thread.h:1202 #3 0x00005575e3ddc92f in MDL_wait::timed_wait (this=0x7f2bb1630100, owner=0x7f2bb16300b8, abs_timeout=0x7f2bd84ced40, set_status_on_timeout=false, wait_state_name=0x5575e4e76d70 <MDL_key::m_namespace_to_wait_state_name+48>) at /git/10.1/sql/mdl.cc:1088 #4 0x00005575e3dde46c in MDL_context::acquire_lock (this=0x7f2bb1630100, mdl_request=0x7f2bd84cee00, lock_wait_timeout=31536000) at /git/10.1/sql/mdl.cc:2125 #5 0x00005575e3ddeb6e in MDL_context::upgrade_shared_lock (this=0x7f2bb1630100, mdl_ticket=0x7f2ba88162c0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /git/10.1/sql/mdl.cc:2318 #6 0x00005575e3c28bf9 in wait_while_table_is_used (thd=0x7f2bb1630008, table=0x7f2ba890bc08, function=HA_EXTRA_PREPARE_FOR_RENAME) at /git/10.1/sql/sql_base.cc:1879 #7 0x00005575e3d5b836 in mysql_inplace_alter_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620, table=0x7f2ba890bc08, altered_table=0x7f2ba894d008, ha_alter_info=0x7f2bd84cf230, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f2bd84cf2a0, alter_ctx=0x7f2bd84cfe50) at /git/10.1/sql/sql_table.cc:7190 #8 0x00005575e3d60501 in mysql_alter_table (thd=0x7f2bb1630008, new_db=0x0, new_name=0x0, create_info=0x7f2bd84d0a60, table_list=0x7f2ba8b1d620, alter_info=0x7f2bd84d09a0, order_num=0, order=0x0, ignore=false) at /git/10.1/sql/sql_table.cc:9078 #9 0x00005575e3d62c0d in mysql_recreate_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620, table_copy=false) at /git/10.1/sql/sql_table.cc:9855 #10 0x00005575e3de1e08 in admin_recreate_table (thd=0x7f2bb1630008, table_list=0x7f2ba8b1d620) at /git/10.1/sql/sql_admin.cc:58 #11 0x00005575e3de4db8 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f2bb1630008, tables=0x7f2ba8b1d620, check_opt=0x7f2bb1634aa0, operator_name=0x5575e46d1678 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5575e3eed478 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /git/10.1/sql/sql_admin.cc:966 #12 0x00005575e3de5fe9 in Sql_cmd_optimize_table::execute (this=0x7f2ba780e0f0, thd=0x7f2bb1630008) at /git/10.1/sql/sql_admin.cc:1307 #13 0x00005575e3c9dd61 in mysql_execute_command (thd=0x7f2bb1630008) at /git/10.1/sql/sql_parse.cc:5702 #14 0x00005575e3ca290b in mysql_parse (thd=0x7f2bb1630008, rawbuf=0x7f2ba8aef0e0 "OPTIMIZE TABLE t1 /* QNO 3 CON_ID 6 */", length=38, parser_state=0x7f2bd84d20a0) at /git/10.1/sql/sql_parse.cc:7469 #15 0x00005575e3c90f96 in dispatch_command (command=COM_QUERY, thd=0x7f2bb1630008, packet=0x7f2bb163b009 "", packet_length=39) at /git/10.1/sql/sql_parse.cc:1499 #16 0x00005575e3c8fd18 in do_command (thd=0x7f2bb1630008) at /git/10.1/sql/sql_parse.cc:1131 #17 0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb1630008) at /git/10.1/sql/sql_connect.cc:1330 #18 0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb1630008) at /git/10.1/sql/sql_connect.cc:1242 #19 0x00007f2bd71866ba in start_thread (arg=0x7f2bd84d3700) at pthread_create.c:333 #20 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 27 (Thread 0x7f2bd851d700 (LWP 20292)): #0 0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e4647592 in vio_io_wait (vio=0x7f2bd4c50c08, event=VIO_IO_EVENT_READ, timeout=28800000) at /git/10.1/vio/viosocket.c:992 #2 0x00005575e4645dfe in vio_socket_io_wait (vio=0x7f2bd4c50c08, event=VIO_IO_EVENT_READ) at /git/10.1/vio/viosocket.c:108 #3 0x00005575e4645fb1 in vio_read (vio=0x7f2bd4c50c08, buf=0x7f2bb9390008 "\a", size=4) at /git/10.1/vio/viosocket.c:184 #4 0x00005575e3bd10e4 in my_real_read (net=0x7f2bb162a2c8, complen=0x7f2bd851c800, header=1 '\001') at /git/10.1/sql/net_serv.cc:877 #5 0x00005575e3bd1878 in my_net_read_packet (net=0x7f2bb162a2c8, read_from_server=1 '\001') at /git/10.1/sql/net_serv.cc:1140 #6 0x00005575e3c8f750 in do_command (thd=0x7f2bb162a008) at /git/10.1/sql/sql_parse.cc:1002 #7 0x00005575e3dd16cd in do_handle_one_connection (thd_arg=0x7f2bb162a008) at /git/10.1/sql/sql_connect.cc:1330 #8 0x00005575e3dd141c in handle_one_connection (arg=0x7f2bb162a008) at /git/10.1/sql/sql_connect.cc:1242 #9 0x00007f2bd71866ba in start_thread (arg=0x7f2bd851d700) at pthread_create.c:333 #10 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 26 (Thread 0x7f2bd8567700 (LWP 20291)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005575e45a2180 in safe_cond_wait (cond=0x5575e5049b80 <COND_slave_background>, mp=0x5575e504cc40 <LOCK_slave_background>, file=0x5575e46845c0 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1165) at /git/10.1/mysys/thr_mutex.c:493 #2 0x00005575e3be66f8 in inline_mysql_cond_wait (that=0x5575e5049b80 <COND_slave_background>, mutex=0x5575e504cc40 <LOCK_slave_background>, src_file=0x5575e4684e28 "/git/10.1/sql/slave.cc", src_line=336) at /git/10.1/include/mysql/psi/mysql_thread.h:1165 #3 0x00005575e3be73e8 in handle_slave_background (arg=0x0) at /git/10.1/sql/slave.cc:336 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bd8567700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 25 (Thread 0x7f2bd85b1700 (LWP 20290)): #0 do_sigwait (sig=0x7f2bd85b0ca0, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 __sigwait (set=<optimized out>, sig=0x7f2bd85b0ca0) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x00005575e3bc278b in signal_hand (arg=0x0) at /git/10.1/sql/mysqld.cc:3408 #3 0x00007f2bd71866ba in start_thread (arg=0x7f2bd85b1700) at pthread_create.c:333 #4 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 24 (Thread 0x7f2ba9ffe700 (LWP 20289)): #0 0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307 #2 0x00005575e43fce9a in btr_defragment_thread () at /git/10.1/storage/xtradb/btr/btr0defragment.cc:708 #3 0x00007f2bd71866ba in start_thread (arg=0x7f2ba9ffe700) at pthread_create.c:333 #4 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 23 (Thread 0x7f2baa7ff700 (LWP 20288)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005575e429aba4 in os_cond_wait (cond=0x7f2bd4f2d2e8, fast_mutex=0x7f2bd4f2d2b0) at /git/10.1/storage/xtradb/os/os0sync.cc:196 #2 0x00005575e429af12 in os_event_wait_low (event=0x7f2bd4f2d2b0, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:477 #3 0x00005575e4417fb1 in buf_dump_thread () at /git/10.1/storage/xtradb/buf/buf0dump.cc:731 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2baa7ff700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 22 (Thread 0x7f2babffe700 (LWP 20287)): #0 0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307 #2 0x00005575e4421baa in page_cleaner_sleep_if_needed (next_loop_time=1557401217676) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2678 #3 0x00005575e442262d in buf_flush_lru_manager_thread (arg=0x0) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2979 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2babffe700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 21 (Thread 0x7f2bac7ff700 (LWP 20286)): #0 0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307 #2 0x00005575e4421baa in page_cleaner_sleep_if_needed (next_loop_time=1557401217678) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2678 #3 0x00005575e4421f0a in buf_flush_page_cleaner_thread (arg=0x0) at /git/10.1/storage/xtradb/buf/buf0flu.cc:2819 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bac7ff700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 20 (Thread 0x7f2bae3f9700 (LWP 20285)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005575e429aba4 in os_cond_wait (cond=0x7f2bd4f2d198, fast_mutex=0x7f2bd4f2d160) at /git/10.1/storage/xtradb/os/os0sync.cc:196 #2 0x00005575e429af12 in os_event_wait_low (event=0x7f2bd4f2d160, reset_sig_count=3) at /git/10.1/storage/xtradb/os/os0sync.cc:477 #3 0x00005575e4365264 in srv_resume_thread (slot=0x5575e58a5298 <srv_sys+536>, sig_count=3, wait=true, timeout_usec=0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:1082 #4 0x00005575e436b190 in srv_purge_coordinator_suspend (slot=0x5575e58a5298 <srv_sys+536>, rseg_history_len=13) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3492 #5 0x00005575e436b542 in srv_purge_coordinator_thread (arg=0x0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3583 #6 0x00007f2bd71866ba in start_thread (arg=0x7f2bae3f9700) at pthread_create.c:333 #7 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 19 (Thread 0x7f2baebfa700 (LWP 20284)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2ea88, fast_mutex=0x7f2bd4f2ea50, abstime=0x7f2baebf9c60) at /git/10.1/storage/xtradb/os/os0sync.cc:159 #2 0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2ea50, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591 #3 0x00005575e43b4fa1 in ib_wqueue_timedwait (wq=0x7f2bd4c5b4f8, wait_in_usecs=5000000) at /git/10.1/storage/xtradb/ut/ut0wqueue.cc:155 #4 0x00005575e44c33da in fts_optimize_thread (arg=0x7f2bd4c5b4f8) at /git/10.1/storage/xtradb/fts/fts0opt.cc:2916 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2baebfa700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 18 (Thread 0x7f2baf3fb700 (LWP 20283)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2e7e8, fast_mutex=0x7f2bd4f2e7b0, abstime=0x7f2baf3fad10) at /git/10.1/storage/xtradb/os/os0sync.cc:159 #2 0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2e7b0, time_in_usec=10000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591 #3 0x00005575e4475cf5 in dict_stats_thread () at /git/10.1/storage/xtradb/dict/dict0stats_bg.cc:534 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2baf3fb700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 17 (Thread 0x7f2bafbfc700 (LWP 20282)): #0 0x00007f2bd68275d3 in select () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e429b9a7 in os_thread_sleep (tm=1000000) at /git/10.1/storage/xtradb/os/os0thread.cc:307 #2 0x00005575e436a5e5 in srv_master_sleep () at /git/10.1/storage/xtradb/srv/srv0srv.cc:3116 #3 0x00005575e436a729 in srv_master_thread (arg=0x0) at /git/10.1/storage/xtradb/srv/srv0srv.cc:3166 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bafbfc700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 16 (Thread 0x7f2bb03fd700 (LWP 20281)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2d208, fast_mutex=0x7f2bd4f2d1d0, abstime=0x7f2bb03fccb0) at /git/10.1/storage/xtradb/os/os0sync.cc:159 #2 0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2d1d0, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591 #3 0x00005575e436836a in srv_error_monitor_thread () at /git/10.1/storage/xtradb/srv/srv0srv.cc:2424 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bb03fd700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 15 (Thread 0x7f2bb0bfe700 (LWP 20280)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2e548, fast_mutex=0x7f2bd4f2e510, abstime=0x7f2bb0bfdcf0) at /git/10.1/storage/xtradb/os/os0sync.cc:159 #2 0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2e510, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591 #3 0x00005575e4267221 in lock_wait_timeout_thread () at /git/10.1/storage/xtradb/lock/lock0wait.cc:597 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bb0bfe700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 14 (Thread 0x7f2bb13ff700 (LWP 20274)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e429aabc in os_cond_wait_timed (cond=0x7f2bd4f2d278, fast_mutex=0x7f2bd4f2d240, abstime=0x7f2bb13fecc0) at /git/10.1/storage/xtradb/os/os0sync.cc:159 #2 0x00005575e429b0bd in os_event_wait_time_low (event=0x7f2bd4f2d240, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/storage/xtradb/os/os0sync.cc:591 #3 0x00005575e4367d3c in srv_monitor_thread () at /git/10.1/storage/xtradb/srv/srv0srv.cc:2183 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bb13ff700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 13 (Thread 0x7f2bb2bf6700 (LWP 20273)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=3, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=9, message1=0x7f2bb2bf5cc0, message2=0x7f2bb2bf5cc8, type=0x7f2bb2bf5cd0, space_id=0x7f2bb2bf5cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=9) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99e8 <n+72>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb2bf6700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 12 (Thread 0x7f2bb33f7700 (LWP 20272)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=2, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=8, message1=0x7f2bb33f6cc0, message2=0x7f2bb33f6cc8, type=0x7f2bb33f6cd0, space_id=0x7f2bb33f6cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=8) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99e0 <n+64>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb33f7700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 11 (Thread 0x7f2bb3bf8700 (LWP 20271)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=1, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=7, message1=0x7f2bb3bf7cc0, message2=0x7f2bb3bf7cc8, type=0x7f2bb3bf7cd0, space_id=0x7f2bb3bf7cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=7) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99d8 <n+56>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb3bf8700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 10 (Thread 0x7f2bb43f9700 (LWP 20270)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83500, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=6, message1=0x7f2bb43f8cc0, message2=0x7f2bb43f8cc8, type=0x7f2bb43f8cd0, space_id=0x7f2bb43f8cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=6) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99d0 <n+48>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb43f9700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 9 (Thread 0x7f2bb4bfa700 (LWP 20269)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=3, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=5, message1=0x7f2bb4bf9cc0, message2=0x7f2bb4bf9cc8, type=0x7f2bb4bf9cd0, space_id=0x7f2bb4bf9cd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=5) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99c8 <n+40>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb4bfa700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 8 (Thread 0x7f2bb53fb700 (LWP 20268)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=2, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=4, message1=0x7f2bb53facc0, message2=0x7f2bb53facc8, type=0x7f2bb53facd0, space_id=0x7f2bb53facd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=4) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99c0 <n+32>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb53fb700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 7 (Thread 0x7f2bb5bfc700 (LWP 20267)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=1, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=3, message1=0x7f2bb5bfbcc0, message2=0x7f2bb5bfbcc8, type=0x7f2bb5bfbcd0, space_id=0x7f2bb5bfbcd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=3) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99b8 <n+24>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb5bfc700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 6 (Thread 0x7f2bb63fd700 (LWP 20266)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c833e0, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=2, message1=0x7f2bb63fccc0, message2=0x7f2bb63fccc8, type=0x7f2bb63fccd0, space_id=0x7f2bb63fccd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=2) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99b0 <n+16>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb63fd700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 5 (Thread 0x7f2bb6bfe700 (LWP 20265)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c83440, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=1, message1=0x7f2bb6bfdcc0, message2=0x7f2bb6bfdcc8, type=0x7f2bb6bfdcd0, space_id=0x7f2bb6bfdcd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=1) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99a8 <n+8>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb6bfe700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 4 (Thread 0x7f2bb73ff700 (LWP 20264)): #0 0x00007f2bd7c2964a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005575e429776f in os_aio_linux_collect (array=0x7f2bd4c834a0, segment=0, seg_size=256) at /git/10.1/storage/xtradb/os/os0file.cc:5618 #2 0x00005575e4297b35 in os_aio_linux_handle (global_seg=0, message1=0x7f2bb73fecc0, message2=0x7f2bb73fecc8, type=0x7f2bb73fecd0, space_id=0x7f2bb73fecd8) at /git/10.1/storage/xtradb/os/os0file.cc:5772 #3 0x00005575e448aaa8 in fil_aio_wait (segment=0) at /git/10.1/storage/xtradb/fil/fil0fil.cc:6239 #4 0x00005575e436d8c1 in io_handler_thread (arg=0x5575e58a99a0 <n>) at /git/10.1/storage/xtradb/srv/srv0start.cc:585 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bb73ff700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 3 (Thread 0x7f2bc2fff700 (LWP 20263)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e45a248a in safe_cond_timedwait (cond=0x5575e5877b20 <COND_checkpoint>, mp=0x5575e5877a60 <LOCK_checkpoint>, abstime=0x7f2bc2ffec90, file=0x5575e47a8760 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547 #2 0x00005575e40f4fb3 in inline_mysql_cond_timedwait (that=0x5575e5877b20 <COND_checkpoint>, mutex=0x5575e5877a60 <LOCK_checkpoint>, abstime=0x7f2bc2ffec90, src_file=0x5575e47a8798 "/git/10.1/storage/maria/ma_servicethread.c", src_line=116) at /git/10.1/include/mysql/psi/mysql_thread.h:1202 #3 0x00005575e40f544a in my_service_thread_sleep (control=0x5575e4e81b00 <checkpoint_control>, sleep_time=30000000000) at /git/10.1/storage/maria/ma_servicethread.c:115 #4 0x00005575e40e92bc in ma_checkpoint_background (arg=0x1e) at /git/10.1/storage/maria/ma_checkpoint.c:708 #5 0x00007f2bd71866ba in start_thread (arg=0x7f2bc2fff700) at pthread_create.c:333 #6 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 2 (Thread 0x7f2bd4bff700 (LWP 20262)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005575e45a248a in safe_cond_timedwait (cond=0x5575e58cc260 <COND_timer>, mp=0x5575e58cc1a0 <LOCK_timer>, abstime=0x7f2bd4bfed40, file=0x5575e4889c20 "/git/10.1/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/mysys/thr_mutex.c:547 #2 0x00005575e45a386a in inline_mysql_cond_timedwait (that=0x5575e58cc260 <COND_timer>, mutex=0x5575e58cc1a0 <LOCK_timer>, abstime=0x7f2bd4bfed40, src_file=0x5575e4889c58 "/git/10.1/mysys/thr_timer.c", src_line=292) at /git/10.1/include/mysql/psi/mysql_thread.h:1202 #3 0x00005575e45a4318 in timer_handler (arg=0x0) at /git/10.1/mysys/thr_timer.c:292 #4 0x00007f2bd71866ba in start_thread (arg=0x7f2bd4bff700) at pthread_create.c:333 #5 0x00007f2bd683141d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 1 (Thread 0x7f2bd85cd900 (LWP 20261)): #0 0x00007f2bd682574d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005575e3bc82f1 in handle_connections_sockets () at /git/10.1/sql/mysqld.cc:6548 #2 0x00005575e3bc729c in mysqld_main (argc=16, argv=0x7f2bd4c5e238) at /git/10.1/sql/mysqld.cc:5973 #3 0x00005575e3bbc310 in main (argc=16, argv=0x7ffc910235c8) at /git/10.1/sql/main.cc:25 3) On 10.3 09aa5d3f6988e92f869ad set use_stat_tables= 'preferably' ; set optimizer_use_condition_selectivity=4; CREATE TABLE test.tmp AS SELECT * FROM mysql.proxies_priv WHERE ` User `= 'root' ; 10.3/sql/sql_statistics.cc:4087: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed. sql/sql_statistics.cc:4088(is_eits_usable(Field*))[0x5600db3dd26f] sql/opt_range.cc:2737(create_key_parts_for_pseudo_indexes(RANGE_OPT_PARAM*, st_bitmap*))[0x5600dbc41e37] sql/opt_range.cc:3065(calculate_cond_selectivity_for_table(THD*, TABLE*, Item**))[0x5600dbc43950] sql/sql_select.cc:5003(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x5600db2cc2fd] sql/sql_select.cc:1888(JOIN::optimize_inner())[0x5600db2af99c] sql/sql_select.cc:1451(JOIN::optimize())[0x5600db2ab704] sql/sql_select.cc:4226(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5600db2c5a3d] sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5600db2a0f4b] sql/sql_parse.cc:4293(mysql_execute_command(THD*))[0x5600db218904] sql/sql_parse.cc:8091(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5600db2307f8] sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5600db20b327] sql/sql_parse.cc:1404(do_command(THD*))[0x5600db20848d] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5600db55d5d0] sql/sql_connect.cc:1309(handle_one_connection)[0x5600db55cfad] perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5600dc88105d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3707f586ba] x86_64/clone.S:111(clone)[0x7f37073ed41d] Marko, you probably meant MDEV-19334 ^^ (not 19344?)

Varun Gupta (Inactive) added a comment - 2019-05-13 11:09 - edited

The test case that affects from 10.1 onwards

create table t1(pk int);

insert into t1 values (4),(3);

set optimizer_use_condition_selectivity=4;

set use_stat_tables='preferably';

--error ER_NO_SUCH_TABLE

INSERT INTO t1 SELECT * FROM x;

CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2;

drop table t2;

Here we again encounter a problem, that statistics(table,column and index) were allocated
in the query INSERT INTO t1 SELECT * FROM x, but were not read.

And then in the CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2, we try to use the statistics for table t1 but we have not read it , so we hit the ASSERT.

Varun Gupta (Inactive) added a comment - 2019-05-13 11:09 - edited The test case that affects from 10.1 onwards create table t1(pk int); insert into t1 values (4),(3); set optimizer_use_condition_selectivity=4; set use_stat_tables='preferably'; --error ER_NO_SUCH_TABLE INSERT INTO t1 SELECT * FROM x; CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2; drop table t2; Here we again encounter a problem, that statistics(table,column and index) were allocated in the query INSERT INTO t1 SELECT * FROM x, but were not read. And then in the CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2, we try to use the statistics for table t1 but we have not read it , so we hit the ASSERT.

Varun Gupta (Inactive) added a comment - 2019-05-14 19:39

Discussed this on the optimizer call, we want to collect statistics for CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2, so we would allow reading of statistics even for CREATE command.
Also it was decided to include DO and SET command.

Varun Gupta (Inactive) added a comment - 2019-05-14 19:39 Discussed this on the optimizer call, we want to collect statistics for CREATE TABLE t2 SELECT 1 FROM t1 WHERE pk>2, so we would allow reading of statistics even for CREATE command. Also it was decided to include DO and SET command.

Varun Gupta (Inactive) added a comment - 2019-05-14 20:19

Patch
http://lists.askmonty.org/pipermail/commits/2019-May/013771.html

Varun Gupta (Inactive) added a comment - 2019-05-14 20:19 Patch http://lists.askmonty.org/pipermail/commits/2019-May/013771.html

Igor Babaev (Inactive) added a comment - 2019-05-15 06:22 - edited

Ok to push into 10.1

Igor Babaev (Inactive) added a comment - 2019-05-15 06:22 - edited Ok to push into 10.1

Varun Gupta (Inactive) added a comment - 2019-05-16 08:31 - edited

Another test case encountered making it for all versions

--source include/have_innodb.inc

set use_stat_tables='preferably';

set optimizer_use_condition_selectivity=4;

create table t1(a int,b int, key k1(a) )engine=INNODB;

insert into t1 values(1,1),(2,2),(3,3);

analyze table t1;

select * from mysql.index_stats, t1 where index_name='k1' and t1.a > 1 and t1.b > 1;

drop table t1;

For the select statement, we have statistics table(index_stats) in the FROM list, so for such cases statistics are not read for any tables because we may have a deadlock.

Varun Gupta (Inactive) added a comment - 2019-05-16 08:31 - edited Another test case encountered making it for all versions --source include/have_innodb.inc set use_stat_tables='preferably'; set optimizer_use_condition_selectivity=4; create table t1(a int,b int, key k1(a) )engine=INNODB; insert into t1 values(1,1),(2,2),(3,3); analyze table t1; select * from mysql.index_stats, t1 where index_name='k1' and t1.a > 1 and t1.b > 1; drop table t1; For the select statement, we have statistics table(index_stats) in the FROM list, so for such cases statistics are not read for any tables because we may have a deadlock.

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-05-07 11:00

Updated:: 2019-05-16 08:37

Resolved:: 2019-05-16 03:12

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration