Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4(EOL), 10.5
Description
CREATE TABLE t (a INT) ENGINE=InnoDB; |
INSERT INTO t (a) VALUES (0); |
XA BEGIN 'a'; |
SELECT * FROM mysql.innodb_index_stats LOCK IN SHARE MODE; |
INSERT INTO t (a) VALUES (0); |
Leads to:
10.5.23 b06ac9a8cd2146e89270cc2150d306d8ed1b33fb (Optimized, UBASAN) |
/test/10.5_opt_san/storage/innobase/dict/dict0stats.cc:2407:14: runtime error: load of value 190, which is not a valid value for type 'bool'
|
#0 0x561fbcf92411 in dict_stats_save_index_stat(dict_index_t*, long, char const*, unsigned long, unsigned long*, char const*, trx_t*) /test/10.5_opt_san/storage/innobase/dict/dict0stats.cc:2407
|
#1 0x561fc104d73c in dict_stats_save /test/10.5_opt_san/storage/innobase/dict/dict0stats.cc:2595
|
#2 0x561fc1056056 in dict_stats_update(dict_table_t*, dict_stats_upd_option_t) /test/10.5_opt_san/storage/innobase/dict/dict0stats.cc:3235
|
#3 0x561fc1065d14 in dict_stats_process_entry_from_recalc_pool /test/10.5_opt_san/storage/innobase/dict/dict0stats_bg.cc:399
|
#4 0x561fc1065d14 in dict_stats_func /test/10.5_opt_san/storage/innobase/dict/dict0stats_bg.cc:418
|
#5 0x561fc13e7e1c in tpool::thread_pool_generic::timer_generic::run() /test/10.5_opt_san/tpool/tpool_generic.cc:361
|
#6 0x561fc13e7e1c in tpool::thread_pool_generic::timer_generic::execute(void*) /test/10.5_opt_san/tpool/tpool_generic.cc:382
|
#7 0x561fc13f0295 in tpool::task::execute() /test/10.5_opt_san/tpool/task.cc:52
|
#8 0x561fc13db98b in tpool::thread_pool_generic::worker_main(tpool::worker_data*) /test/10.5_opt_san/tpool/tpool_generic.cc:599
|
#9 0x561fc13e701a in void std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*>(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::*&&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) /usr/include/c++/9/bits/invoke.h:73
|
#10 0x561fc13e701a in std::__invoke_result<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*>::type std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*>(void (tpool::thread_pool_generic::*&&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) /usr/include/c++/9/bits/invoke.h:95
|
#11 0x561fc13e701a in void std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul>(std::_Index_tuple<0ul, 1ul, 2ul>) /usr/include/c++/9/thread:244
|
#12 0x561fc13e701a in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator()() /usr/include/c++/9/thread:251
|
#13 0x561fc13e701a in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run() /usr/include/c++/9/thread:195
|
#14 0x148c08187de3 (/usr/lib/x86_64-linux-gnu/libstdc++.so.6+0xd6de3)
|
#15 0x148c082a1608 in start_thread /build/glibc-SzIz7B/glibc-2.31/nptl/pthread_create.c:477
|
#16 0x148c07516132 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f132)
|
 |
2023-11-03 5:16:20 0 [ERROR] InnoDB: Cannot save index statistics for table `test`.`t`, index `GEN_CLUST_INDEX`, stat name "n_diff_pfx01": Lock wait timeout
|
|
Setup:
Compiled with GCC >=7.5.0 (I use GCC 11.4.0) and:
|
-DWITH_ASAN=ON -DWITH_ASAN_SCOPE=ON -DWITH_UBSAN=ON -DWSREP_LIB_WITH_ASAN=ON
|
Set before execution:
|
export UBSAN_OPTIONS=print_stacktrace=1
|
Bug confirmed present in:
MariaDB: 10.4.32 (dbg), 10.4.32 (opt), 10.5.23 (dbg), 10.5.23 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.6.16 (dbg), 10.6.16 (opt), 10.9.8 (dbg), 10.9.8 (opt), 10.10.7 (dbg), 10.10.7 (opt), 10.11.6 (dbg), 10.11.6 (opt), 11.0.4 (dbg), 11.0.4 (opt), 11.1.3 (dbg), 11.1.3 (opt), 11.2.2 (dbg), 11.2.2 (opt), 11.3.0 (dbg), 11.3.0 (opt)
Attachments
Issue Links
- relates to
-
MDEV-35363 Avoid cloning of table statistics while saving the InnoDB table stats
- Closed
- split to
-
MDEV-35374 [ERROR] InnoDB: Cannot save index statistics...Lock wait timeout and slow INSERT
- Confirmed