Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Assertion `e->usag e() == 1' failed

Description

GDB Info

#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x0000000004db1f18 in my_write_core (sig=6) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:305 #2 0x0000000003b6eb5f in handle_fatal_signal (sig=6) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:183 #3 <signal handler called> #4 0x00007f14940d0428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54 #5 0x00007f14940d202a in __GI_abort () at abort.c:89 #6 0x00007f14940c8bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x67a540b "e->usage() == 1", file=file@entry=0x67a5390 "/mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/shared_multi_map.cc", line=line@entry=82, function=function@entry=0x67b1820 <dd::cache::Shared_multi_map<dd::Tablespace>::remove(dd::cache::Cache_element<dd::Tablespace>*, dd::cache::Shared_multi_map<dd::Tablespace>::Autolocker*)::__PRETTY_FUNCTION__> "void dd::cache::Shared_multi_map<T>::remove(dd::cache::Cache_element<T>*, dd::cache::Shared_multi_map<T>::Autolocker*) [with T = dd::Tablespace]") at assert.c:92 #7 0x00007f14940c8c82 in __GI___assert_fail (assertion=0x67a540b "e->usage() == 1", file=0x67a5390 "/mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/shared_multi_map.cc", line=82, function=0x67b1820 <dd::cache::Shared_multi_map<dd::Tablespace>::remove(dd::cache::Cache_element<dd::Tablespace>*, dd::cache::Shared_multi_map<dd::Tablespace>::Autolocker*)::__PRETTY_FUNCTION__> "void dd::cache::Shared_multi_map<T>::remove(dd::cache::Cache_element<T>*, dd::cache::Shared_multi_map<T>::Autolocker*) [with T = dd::Tablespace]") at assert.c:101 #8 0x0000000004c17b21 in dd::cache::Shared_multi_map<dd::Tablespace>::remove (this=0x8363668 <dd::cache::Shared_dictionary_cache::instance()::s_cache+4968>, element=0x7f135c1cb200, lock=0x7f141c3f43c0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/shared_multi_map.cc:82 #9 0x0000000004c1aa62 in dd::cache::Shared_multi_map<dd::Tablespace>::drop_if_present<dd::Primary_id_key> (this=0x8363668 <dd::cache::Shared_dictionary_cache::instance()::s_cache+4968>, key=...) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/shared_multi_map.cc:438 #10 0x0000000004b96ee6 in dd::cache::Shared_dictionary_cache::drop_if_present<dd::Primary_id_key, dd::Tablespace> (this=0x8362300 <dd::cache::Shared_dictionary_cache::instance()::s_cache>, key=...) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/shared_dictionary_cache.h:327 #11 0x0000000004b7f402 in dd::cache::Dictionary_client::invalidate<dd::Tablespace> (this=0x7f1350004d90, object=0x7f1350227e78) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/dictionary_client.cc:2371 #12 0x0000000004b6b9ea in dd::cache::Dictionary_client::drop<dd::Tablespace> (this=0x7f1350004d90, object=0x7f1350227e78) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/cache/dictionary_client.cc:2437 #13 0x00000000053b8771 in dd_drop_tablespace (dd_client=0x7f1350004d90, thd=0x7f1350000cf0, dd_space_id=210) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/dict/dict0dd.cc:3289 #14 0x0000000004efa7e5 in innobase_basic_ddl::delete_impl<dd::Table> (thd=0x7f1350000cf0, name=0x7f141c3f5b00 "./test/#sql2-7c46-2a", dd_tab=0x7f13502888c8) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/handler/ha_innodb.cc:15715 #15 0x0000000004ed4050 in ha_innobase::delete_table (this=0x7f13502cdcb0, name=0x7f141c3f5b00 "./test/#sql2-7c46-2a", table_def=0x7f13502888c8) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/handler/ha_innodb.cc:16714 #16 0x0000000003503765 in handler::ha_delete_table (this=0x7f13502cdcb0, name=0x7f141c3f5b00 "./test/#sql2-7c46-2a", table_def=0x7f13502888c8) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/handler.cc:5334 #17 0x00000000034fa2e1 in ha_delete_table (thd=0x7f1350000cf0, table_type=0x9ca9c10, path=0x7f141c3f5b00 "./test/#sql2-7c46-2a", db=0x7f13501927f0 "test", alias=0x7f141c3f7c70 "#sql2-7c46-2a", table_def=0x7f13502888c8, generate_warning=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/handler.cc:2806 #18 0x0000000003a0d304 in quick_rm_table (thd=0x7f1350000cf0, base=0x9ca9c10, db=0x7f13501927f0 "test", table_name=0x7f141c3f7c70 "#sql2-7c46-2a", flags=11) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_table.cc:3688 #19 0x0000000003a392dd in mysql_alter_table (thd=0x7f1350000cf0, new_db=0x7f13501927f0 "test", new_name=0x0, create_info=0x7f141c3f8280, table_list=0x7f1350192248, alter_info=0x7f141c3f8390) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_table.cc:17614 #20 0x000000000383e809 in Sql_cmd_alter_table::execute (this=0x7f13501927f8, thd=0x7f1350000cf0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_alter.cc:607 #21 0x000000000396414a in mysql_execute_command (thd=0x7f1350000cf0, first_level=true) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5396 #22 0x000000000396747d in mysql_parse (thd=0x7f1350000cf0, parser_state=0x7f141c3fab90, update_userstat=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6272 #23 0x000000000396b3c9 in wsrep_mysql_parse (thd=0x7f1350000cf0, rawbuf=0x7f1350191458 "ALTER TABLE tt_7_p ENCRYPTION = 'N'", length=35, parser_state=0x7f141c3fab90, update_userstat=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7541 #24 0x00000000039586fd in dispatch_command (thd=0x7f1350000cf0, com_data=0x7f141c3fbc60, command=COM_QUERY) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2064 #25 0x0000000003956266 in do_command (thd=0x7f1350000cf0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1430 #26 0x0000000003b563bd in handle_connection (arg=0x9c58930) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:312 #27 0x00000000055ab065 in pfs_spawn_thread (arg=0x9cb51a0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2855 #28 0x00007f14960ba6ba in start_thread (arg=0x7f141c3fc700) at pthread_create.c:333 #29 0x00007f14941a241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Testcase
1) Start 3 node cluster with encryption
sample cnf

[mysqld] wsrep-debug=1 wsrep_node_incoming_address=127.0.0.1 wsrep_node_address=127.0.0.1 innodb_file_per_table innodb_autoinc_lock_mode=2 innodb_flush_log_at_trx_commit=0 wsrep_sst_method=xtrabackup-v2 core-file log-output=none wsrep_slave_threads=8 wsrep_cluster_address=gcomm://127.0.0.1:19108,127.0.0.1:19208,127.0.0.1:19308, log_error_verbosity=3 port=19100 wsrep_provider_options='gmcast.listen_addr=tcp://127.0.0.1:19108;socket.ssl_key=/ssd/ramesh/cert/server-key.pem;socket.ssl_cert=/ssd/ramesh/cert/server-cert.pem;socket.ssl_ca=/ssd/ramesh/cert/ca.pem' socket = /ssd/ramesh/node1/mysql.sock server_id=11 pxc_encrypt_cluster_traffic = ON encrypt_tmp_files = ON binlog_encryption = ON default_table_encryption = ON innodb_redo_log_encrypt = ON innodb_undo_log_encrypt = ON innodb_temp_tablespace_encrypt = ON early-plugin-load = keyring_file.so keyring_file_data = keyring ssl-ca = /ssd/ramesh/cert/ca.pem ssl-cert = /ssd/ramesh/cert/server-cert.pem ssl-key = /ssd/ramesh/cert/server-key.pem [client] ssl-ca = /ssd/ramesh/cert/ca.pem ssl-cert = /ssd/ramesh/cert/client-cert.pem ssl-key = /ssd/ramesh/cert/client-key.pem [sst] encrypt = 4 ssl-ca = /ssd/ramesh/cert/ca.pem ssl-cert = /ssd/ramesh/cert/server-cert.pem ssl-key = /ssd/ramesh/cert/server-key.pem

2) run pstress (pquery3)

git clone https://github.com/Percona-QA/pstress cd pstress/ cmake . -DPERCONACLUSTER=ON -DBASEDIR=/ssd/ramesh/Percona-XtraDB-Cluster_8.0.18.9_debug.Linux.x86_64 make cd ../ /ssd/ramesh/pstress/src/pstress-pxc --mso=innodb_parallel_dblwr_encrypt=on=off --tables 30 --sql-file /ssd/ramesh/pstress/src/grammer.sql --logdir=$PWD/log --records 2000 --threads 10 --seconds 200 --socket /ssd/ramesh/node1/mysql.sock

3) Check node1 error log

Environment

None

blocks

Smart Checklist

Activity

Duplicate

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created March 30, 2020 at 5:30 AM
Updated March 6, 2024 at 9:39 PM
Resolved March 30, 2020 at 6:58 AM

Flag notifications