[MDEV-27786] Server crashes on shutdown after select from INFORMATION_SCHEMA.ALL_PLUGINS on sles 12 Created: 2022-02-09  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Platform SUSE
Affects Version/s: 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.5, 10.6

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None


 Description   

repeatable on 10.5-10.8 on sles-12-amd64-build-5ztsi6 4.12.14-122.91-default

cmake . -DCMAKE_BUILD_TYPE=Debug -DPLUGIN_MROONGA=NO -DPLUGIN_ROCKSDB=NO
reason - s3 engine. if I delete it from lib/plugin -> then server does not crash

SELECT plugin_name, plugin_version, plugin_status, plugin_maturity from INFORMATION_SCHEMA.ALL_PLUGINS ORDER BY plugin_name;

10.5 34c5019698ae2cab5be

jenkins@jenkins-sles-12-amd64-build-5ztsi6:~/10.5/mysql-test> gdb --batch --eval-command="thread apply all bt" ~/10.5/sql/mysqld ~/10.5/mysql-test/var/mysqld.1/data/core.1854
[New LWP 1854]
[New LWP 1861]
[New LWP 1857]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/10.5/sql/mariadbd --defaults-group-suffix=.1 --de'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x00007f786bb92a80 in ?? ()
[Current thread is 1 (Thread 0x7f7888eaa8c0 (LWP 1854))]
 
Thread 3 (Thread 0x7f7880688700 (LWP 1857)):
#0  0x00007f788681b023 in sigwaitinfo () from /lib64/libc.so.6
#1  0x00005559c6ee106a in my_sigwait (set=0x7f7880687cb0, sig=0x7f7880687c74, code=0x7f7880687c78) at /10.5/include/my_pthread.h:196
#2  0x00005559c6ee6ddb in signal_hand (arg=0x0) at /10.5/sql/mysqld.cc:2963
#3  0x00005559c7736966 in pfs_spawn_thread (arg=0x5559cb892518) at /10.5/storage/perfschema/pfs.cc:2201
#4  0x00007f78876af71a in start_thread () from /lib64/libpthread.so.0
#5  0x00007f78868d216d in clone () from /lib64/libc.so.6
 
Thread 2 (Thread 0x7f78805f4700 (LWP 1861)):
#0  0x00007f78868c954d in poll () from /lib64/libc.so.6
#1  0x00005559c7d133a1 in addr_resolve (ptr=0x5559c7d13471 <my_addr_resolve>, loc=0x7f78805f28b0) at /10.5/mysys/my_addr_resolve.c:244
#2  0x00005559c7d1356a in my_addr_resolve (ptr=0x5559c7cea484 <my_print_stacktrace+64>, loc=0x7f78805f28b0) at /10.5/mysys/my_addr_resolve.c:330
#3  0x00005559c7cea3b8 in print_with_addr_resolve (addrs=0x7f78805f2910, n=4) at /10.5/mysys/stacktrace.c:197
#4  0x00005559c7cea4c3 in my_print_stacktrace (stack_bottom=0x0, thread_stack=299008, silent=0 '\000') at /10.5/mysys/stacktrace.c:216
#5  0x00005559c73a58c6 in handle_fatal_signal (sig=11) at /10.5/sql/signal_handler.cc:223
#6  <signal handler called>
#7  0x00007f786bb92a80 in ?? ()
#8  0x00007f78879f28c8 in ERR_remove_thread_state () from /lib64/libcrypto.so.1.0.0
#9  0x00005559c71dea82 in handle_one_connection (arg=0x5559cb8b3a48) at /10.5/sql/sql_connect.cc:1316
#10 0x00005559c7736966 in pfs_spawn_thread (arg=0x5559cb959ae8) at /10.5/storage/perfschema/pfs.cc:2201
#11 0x00007f78876af71a in start_thread () from /lib64/libpthread.so.0
#12 0x00007f78868d216d in clone () from /lib64/libc.so.6
 
Thread 1 (Thread 0x7f7888eaa8c0 (LWP 1854)):
#0  0x00007f786bb92a80 in ?? ()
#1  0x00007f78879f28c8 in ERR_remove_thread_state () from /lib64/libcrypto.so.1.0.0
#2  0x00005559c75e9bba in vio_end () at /10.5/vio/vio.c:360
#3  0x00005559c6ee4a23 in clean_up (print_message=true) at /10.5/sql/mysqld.cc:1992
#4  0x00005559c6eec8ac in mysqld_main (argc=147, argv=0x5559cb373cd0) at /10.5/sql/mysqld.cc:5686
#5  0x00005559c6ee0fb5 in main (argc=6, argv=0x7ffe951e1788) at /10.5/sql/main.cc:25

if built with RocksDB -
cmake . -DCMAKE_BUILD_TYPE=Debug -DPLUGIN_MROONGA=NO -DPLUGIN_ROCKSDB=YES

10.8 12cd3dc78d2a58a15377000a

New LWP 19116]
[New LWP 19119]
[New LWP 19123]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/workspace/10.8/sql/mariadbd --defaults-group-suffix=.1 --de'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x00007ff332746d9d in std::_Deque_iterator<rocksdb::DBImpl::LogWriterNumber, rocksdb::DBImpl::LogWriterNumber const&, rocksdb::DBImpl::LogWriterNumber const*>::_M_set_node (this=0x55ceee39ffba, __new_node=0x5b72ffa35f9bffa3) at /usr/include/c++/4.8/bits/stl_deque.h:236
236		_M_node = __new_node;
[Current thread is 1 (Thread 0x7ff33fab08c0 (LWP 19116))]
 
Thread 3 (Thread 0x7ff338191700 (LWP 19123)):
#0  0x00007ff33d6d654d in poll () from /lib64/libc.so.6
#1  0x000055ceeddd32ad in addr_resolve (ptr=0x55ceeddd337d <my_addr_resolve>, loc=0x7ff33818f870) at /workspace/10.8/mysys/my_addr_resolve.c:244
#2  0x000055ceeddd3476 in my_addr_resolve (ptr=0x55ceeddaabf4 <my_print_stacktrace+64>, loc=0x7ff33818f870) at /workspace/10.8/mysys/my_addr_resolve.c:330
#3  0x000055ceeddaab28 in print_with_addr_resolve (addrs=0x7ff33818f8d0, n=8) at /workspace/10.8/mysys/stacktrace.c:197
#4  0x000055ceeddaac33 in my_print_stacktrace (stack_bottom=0x0, thread_stack=299008, silent=0 '\000') at /workspace/10.8/mysys/stacktrace.c:216
#5  0x000055ceed4d85ba in handle_fatal_signal (sig=11) at /workspace/10.8/sql/signal_handler.cc:224
#6  <signal handler called>
#7  0x00007ff332746d9d in std::_Deque_iterator<rocksdb::DBImpl::LogWriterNumber, rocksdb::DBImpl::LogWriterNumber const&, rocksdb::DBImpl::LogWriterNumber const*>::_M_set_node (this=0x55ceed2ebb20 <handle_one_connection(void*)+144>, __new_node=0xe8ca37c074abe888) at /usr/include/c++/4.8/bits/stl_deque.h:236
#8  0x00007ff332740aa2 in std::_Deque_iterator<rocksdb::DBImpl::LogWriterNumber, rocksdb::DBImpl::LogWriterNumber const&, rocksdb::DBImpl::LogWriterNumber const*>::operator+= (this=0x55ceed2ebb20 <handle_one_connection(void*)+144>, __n=0) at /usr/include/c++/4.8/bits/stl_deque.h:199
#9  0x000055ceed82bb8c in pfs_spawn_thread (arg=0x55cef182a2b8) at /workspace/10.8/storage/perfschema/pfs.cc:2201
#10 0x00007ff33e4bc71a in start_thread () from /lib64/libpthread.so.0
#11 0x00007ff33d6df16d in clone () from /lib64/libc.so.6
 
Thread 2 (Thread 0x7ff338225700 (LWP 19119)):
#0  0x00007ff33d628023 in sigwaitinfo () from /lib64/libc.so.6
#1  0x000055ceecf860ca in my_sigwait (set=0x7ff338224cb0, sig=0x7ff338224c74, code=0x7ff338224c78) at /workspace/10.8/include/my_pthread.h:195
#2  0x000055ceecf8c4b9 in signal_hand (arg=0x0) at /workspace/10.8/sql/mysqld.cc:3152
#3  0x000055ceed82bb8c in pfs_spawn_thread (arg=0x55cef18245f8) at /workspace/10.8/storage/perfschema/pfs.cc:2201
#4  0x00007ff33e4bc71a in start_thread () from /lib64/libpthread.so.0
#5  0x00007ff33d6df16d in clone () from /lib64/libc.so.6
 
Thread 1 (Thread 0x7ff33fab08c0 (LWP 19116)):
#0  0x00007ff332746d9d in std::_Deque_iterator<rocksdb::DBImpl::LogWriterNumber, rocksdb::DBImpl::LogWriterNumber const&, rocksdb::DBImpl::LogWriterNumber const*>::_M_set_node (this=0x55ceee39ffba, __new_node=0x5b72ffa35f9bffa3) at /usr/include/c++/4.8/bits/stl_deque.h:236
#1  0x00007ff332740aa2 in std::_Deque_iterator<rocksdb::DBImpl::LogWriterNumber, rocksdb::DBImpl::LogWriterNumber const&, rocksdb::DBImpl::LogWriterNumber const*>::operator+= (this=0x55ceee39ffba, __n=94347248402356) at /usr/include/c++/4.8/bits/stl_deque.h:199
#2  0x000055ceecf89b19 in clean_up (print_message=true) at /workspace/10.8/sql/mysqld.cc:1994
#3  0x000055ceecf92221 in mysqld_main (argc=139, argv=0x55cef12fcd40) at /workspace/10.8/sql/mysqld.cc:5896
#4  0x000055ceecf86015 in main (argc=6, argv=0x7ffe98127548) at /workspace/10.8/sql/main.cc:34

if built with Mroonga - then it fails somewhere in mroonga
cmake . -DCMAKE_BUILD_TYPE=Debug -DPLUGIN_MROONGA=YES

10.8 12cd3dc78d2a58a15377000a

 
[New LWP 22629]
[New LWP 22633]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/10.8/sql/mariadbd --defaults-group-suffix=.1 --de'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x00007f732a037a6e in ha_mroonga::storage_delete_row_unique_indexes (this=0x1000057b99cfe) at /10.8/storage/mroonga/ha_mroonga.cpp:7283
7283	    if (i == table->s->primary_key) {
[Current thread is 1 (Thread 0x7f733326d8c0 (LWP 22626))]
 
Thread 3 (Thread 0x7f732a9af700 (LWP 22633)):
#0  0x00007f7330e9354d in poll () from /lib64/libc.so.6
#1  0x000055c957bc42ad in addr_resolve (ptr=0x55c957bc437d <my_addr_resolve>, loc=0x7f732a9ad8b0) at /10.8/mysys/my_addr_resolve.c:244
#2  0x000055c957bc4476 in my_addr_resolve (ptr=0x55c957b9bbf4 <my_print_stacktrace+64>, loc=0x7f732a9ad8b0) at /10.8/mysys/my_addr_resolve.c:330
#3  0x000055c957b9bb28 in print_with_addr_resolve (addrs=0x7f732a9ad910, n=7) at /10.8/mysys/stacktrace.c:197
#4  0x000055c957b9bc33 in my_print_stacktrace (stack_bottom=0x0, thread_stack=299008, silent=0 '\000') at /10.8/mysys/stacktrace.c:216
#5  0x000055c9572c95ba in handle_fatal_signal (sig=11) at /10.8/sql/signal_handler.cc:224
#6  <signal handler called>
#7  0x00007f732a037a6e in ha_mroonga::storage_delete_row_unique_indexes (this=0x0) at /10.8/storage/mroonga/ha_mroonga.cpp:7283
#8  0x000055c95761cb8c in pfs_spawn_thread (arg=0x55c95a07a2b8) at /10.8/storage/perfschema/pfs.cc:2201
#9  0x00007f7331c7971a in start_thread () from /lib64/libpthread.so.0
#10 0x00007f7330e9c16d in clone () from /lib64/libc.so.6
 
Thread 2 (Thread 0x7f732aa43700 (LWP 22629)):
#0  0x00007f7330de5023 in sigwaitinfo () from /lib64/libc.so.6
#1  0x000055c956d770ca in my_sigwait (set=0x7f732aa42cb0, sig=0x7f732aa42c74, code=0x7f732aa42c78) at /10.8/include/my_pthread.h:195
#2  0x000055c956d7d4b9 in signal_hand (arg=0x0) at /10.8/sql/mysqld.cc:3152
#3  0x000055c95761cb8c in pfs_spawn_thread (arg=0x55c95a0745f8) at /10.8/storage/perfschema/pfs.cc:2201
#4  0x00007f7331c7971a in start_thread () from /lib64/libpthread.so.0
#5  0x00007f7330e9c16d in clone () from /lib64/libc.so.6
 
Thread 1 (Thread 0x7f733326d8c0 (LWP 22626)):
#0  0x00007f732a037a6e in ha_mroonga::storage_delete_row_unique_indexes (this=0x1000057b99cfe) at /10.8/storage/mroonga/ha_mroonga.cpp:7283
#1  0x000055c956d7ab19 in clean_up (print_message=true) at /10.8/sql/mysqld.cc:1994
#2  0x000055c956d83221 in mysqld_main (argc=139, argv=0x55c959b4cd40) at /10.8/sql/mysqld.cc:5896
#3  0x000055c956d77015 in main (argc=6, argv=0x7ffe73565ca8) at /10.8/sql/main.cc:34


Generated at Thu Feb 08 09:55:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.