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

Server crashes on shutdown after select from INFORMATION_SCHEMA.ALL_PLUGINS on sles 12

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7, 10.8
    • 10.5, 10.6
    • Platform SUSE
    • 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
      
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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