Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.2.2, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-asan/builds/5389/steps/mtr_nm/logs/stdio
|
10.6 f691d9865becfd242ba44cc63 |
rpl.rpl_parallel_temptable 'innodb,stmt' w3 [ fail ]
|
Test ended at 2021-03-04 18:34:59
|
|
|
CURRENT_TEST: rpl.rpl_parallel_temptable
|
mysqltest: In included file "./include/stop_slave.inc":
|
included from /home/buildbot/buildbot/build/mariadb-10.6.0/mysql-test/suite/rpl/t/rpl_parallel_temptable.test at line 257:
|
At line 82: query 'STOP SLAVE' failed: 2013: Lost connection to MySQL server during query
|
|
|
The result from queries just before the failure was:
|
< snip >
|
INSERT INTO t4 VALUES (33);
|
INSERT INTO t1 SELECT a, "optimistic" FROM t4;
|
DROP TEMPORARY TABLE t4;
|
SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
|
a b
|
30 conservative
|
31 conservative
|
32 optimistic
|
33 optimistic
|
include/save_master_gtid.inc
|
connection server_2;
|
include/start_slave.inc
|
include/sync_with_master_gtid.inc
|
SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
|
a b
|
30 conservative
|
31 conservative
|
32 optimistic
|
33 optimistic
|
include/stop_slave.inc
|
|
|
More results from queries before failure can be found in /dev/shm/var/3/log/rpl_parallel_temptable.log
|
|
|
|
|
Server [mysqld.2 - pid: 61746, winpid: 61746, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2021-03-04 18:34:51 0 [Note] /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd (mysqld 10.6.0-MariaDB-debug-log) starting as process 61747 ...
|
2021-03-04 18:34:51 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
|
2021-03-04 18:34:51 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2021-03-04 18:34:51 0 [Warning] setrlimit could not change the size of core files to 'infinity'; We may not be able to generate a core file on signals
|
2021-03-04 18:34:51 0 [Note] Plugin 'partition' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'SEQUENCE' is disabled.
|
2021-03-04 18:34:51 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2021-03-04 18:34:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2021-03-04 18:34:51 0 [Note] InnoDB: Number of pools: 1
|
2021-03-04 18:34:51 0 [Note] InnoDB: Using generic crc32 instructions
|
2021-03-04 18:34:51 0 [Note] mariadbd: O_TMPFILE is not supported on /dev/shm/var/tmp/3/mysqld.2 (disabling future attempts)
|
2021-03-04 18:34:51 0 [Note] InnoDB: Using Linux native AIO
|
2021-03-04 18:34:51 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
|
2021-03-04 18:34:51 0 [Note] InnoDB: Completed initialization of buffer pool
|
2021-03-04 18:34:51 0 [Note] InnoDB: Setting O_DIRECT on file ./ibdata1 failed
|
2021-03-04 18:34:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2021-03-04 18:34:51 0 [Note] InnoDB: 128 rollback segments are active.
|
2021-03-04 18:34:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2021-03-04 18:34:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2021-03-04 18:34:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2021-03-04 18:34:51 0 [Note] InnoDB: 10.6.0 started; log sequence number 45179; transaction id 25
|
2021-03-04 18:34:51 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/3/mysqld.2/data/ib_buffer_pool
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_CMP' is disabled.
|
2021-03-04 18:34:51 0 [Note] InnoDB: Buffer pool(s) load completed at 210304 18:34:51
|
2021-03-04 18:34:51 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'user_variables' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
|
2021-03-04 18:34:51 0 [Note] Plugin 'unix_socket' is disabled.
|
2021-03-04 18:34:51 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd: unknown option '--loose-pam-debug'
|
2021-03-04 18:34:51 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd: unknown option '--loose-aria'
|
2021-03-04 18:34:51 0 [Note] Server socket created on IP: '127.0.0.1'.
|
2021-03-04 18:34:51 0 [Note] Reading of all Master_info entries succeeded
|
2021-03-04 18:34:51 0 [Note] Added new Master_info '' to hash table
|
2021-03-04 18:34:51 0 [Note] /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd: ready for connections.
|
Version: '10.6.0-MariaDB-debug-log' socket: '/dev/shm/var/tmp/3/mysqld.2.sock' port: 16061 Source distribution
|
2021-03-04 18:34:52 5 [Note] Deleted Master_info file '/dev/shm/var/3/mysqld.2/data/master.info'.
|
2021-03-04 18:34:52 5 [Note] Deleted Master_info file '/dev/shm/var/3/mysqld.2/data/relay-log.info'.
|
2021-03-04 18:34:52 5 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
|
2021-03-04 18:34:52 5 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='127.0.0.1', master_port='16060', master_log_file='master-bin.000001', master_log_pos='4'.
|
2021-03-04 18:34:52 7 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:16060' in log 'master-bin.000001' at position 4
|
2021-03-04 18:34:52 8 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 4, relay log './slave-relay-bin.000001' position: 4
|
2021-03-04 18:34:52 7 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16060',replication started in log 'master-bin.000001' at position 4
|
2021-03-04 18:34:52 8 [Note] Error reading relay log event: slave SQL thread was killed
|
2021-03-04 18:34:52 8 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000001' at position 329, master: 127.0.0.1:16060
|
2021-03-04 18:34:52 7 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 329, master 127.0.0.1:16060
|
2021-03-04 18:34:52 5 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
|
2021-03-04 18:34:52 5 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='127.0.0.1', master_port='16060', master_log_file='master-bin.000001', master_log_pos='329'. New state master_host='127.0.0.1', master_port='16060', master_log_file='master-bin.000001', master_log_pos='329'.
|
2021-03-04 18:34:52 5 [Note] Previous Using_Gtid=No. New Using_Gtid=Current_Pos
|
2021-03-04 18:34:52 9 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:16060' in log 'master-bin.000001' at position 329
|
2021-03-04 18:34:52 9 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16060',replication starts at GTID position ''
|
2021-03-04 18:34:52 10 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 329, relay log './slave-relay-bin.000001' position: 4; GTID position ''
|
2021-03-04 18:34:53 10 [Note] Error reading relay log event: slave SQL thread was killed
|
2021-03-04 18:34:53 10 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000001' at position 508; GTID position '0-1-1', master: 127.0.0.1:16060
|
2021-03-04 18:34:53 9 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 508; GTID position 0-1-1, master 127.0.0.1:16060
|
2021-03-04 18:34:55 16 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:16060' in log 'master-bin.000001' at position 508
|
2021-03-04 18:34:55 16 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16060',replication starts at GTID position '0-1-1'
|
2021-03-04 18:34:55 17 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 508, relay log './slave-relay-bin.000001' position: 4; GTID position '0-1-1'
|
2021-03-04 18:34:55 17 [Note] Error reading relay log event: slave SQL thread was killed
|
2021-03-04 18:34:55 17 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000002' at position 585; GTID position '0-1-2,1-1-23,2-1-13', master: 127.0.0.1:16060
|
2021-03-04 18:34:55 16 [Note] Slave I/O thread exiting, read up to log 'master-bin.000002', position 585; GTID position 1-1-23,2-1-13,0-1-2, master 127.0.0.1:16060
|
2021-03-04 18:34:57 23 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:16060' in log 'master-bin.000002' at position 585
|
2021-03-04 18:34:57 23 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16060',replication starts at GTID position '1-1-23,0-1-2,2-1-13'
|
2021-03-04 18:34:57 24 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000002' at position 585, relay log './slave-relay-bin.000001' position: 4; GTID position '0-1-2,1-1-23,2-1-13'
|
2021-03-04 18:34:57 27 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO t1 SELECT a, 'default' FROM t3
|
2021-03-04 18:34:57 28 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO t1 SELECT a, 'server_1' FROM t2
|
2021-03-04 18:34:57 26 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO t1 SELECT a+2, '+server_1' FROM t2
|
2021-03-04 18:34:57 29 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO t1 SELECT a+4, '++server_1' FROM t2
|
2021-03-04 18:34:57 24 [Note] Error reading relay log event: slave SQL thread was killed
|
2021-03-04 18:34:57 24 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000004' at position 1354; GTID position '0-1-9,1-1-31,2-1-17', master: 127.0.0.1:16060
|
2021-03-04 18:34:57 23 [Note] Slave I/O thread exiting, read up to log 'master-bin.000004', position 1354; GTID position 1-1-32,0-1-9,2-1-17, master 127.0.0.1:16060
|
2021-03-04 18:34:57 30 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:16060' in log 'master-bin.000004' at position 1354
|
2021-03-04 18:34:57 30 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16060',replication starts at GTID position '1-1-31,0-1-9,2-1-17'
|
2021-03-04 18:34:57 31 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000004' at position 1354, relay log './slave-relay-bin.000001' position: 4; GTID position '0-1-9,1-1-31,2-1-17'
|
=================================================================
|
==61747==ERROR: AddressSanitizer: heap-use-after-free on address 0x6180000a5790 at pc 0x55b4e3c52d82 bp 0x7f67a6c47a40 sp 0x7f67a6c47a30
|
WRITE of size 8 at 0x6180000a5790 thread T48
|
#0 0x55b4e3c52d81 in std::__atomic_base<long>::store(long, std::memory_order) /usr/include/c++/9/bits/atomic_base.h:397
|
#1 0x55b4e3c52d81 in Atomic_relaxed<long>::operator=(long) /home/buildbot/buildbot/build/mariadb-10.6.0/include/my_atomic_wrapper.h:46
|
#2 0x55b4e40ec094 in trx_t::commit_tables() /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/trx/trx0trx.cc:1239
|
#3 0x55b4e40ecf17 in trx_t::commit_in_memory(mtr_t const*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/trx/trx0trx.cc:1333
|
#4 0x55b4e40e4abd in trx_t::commit_low(mtr_t*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/trx/trx0trx.cc:1507
|
#5 0x55b4e40e4bf2 in trx_t::commit() /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/trx/trx0trx.cc:1521
|
#6 0x55b4e40e534a in trx_commit_for_mysql(trx_t*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/trx/trx0trx.cc:1638
|
2021-03-04 18:34:58 31 [Note] Error reading relay log event: slave SQL thread was killed
|
#7 0x55b4e3bdaff7 in innobase_commit_low(trx_t*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:3827
|
#8 0x55b4e3bdb724 in innobase_commit_ordered_2 /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:3933
|
#9 0x55b4e3bdc1f1 in innobase_commit /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:4037
|
#10 0x55b4e30d48a8 in commit_one_phase_2 /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:1942
|
#11 0x55b4e30d45bc in ha_commit_one_phase(THD*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:1921
|
#12 0x55b4e30d290c in ha_commit_trans(THD*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:1715
|
#13 0x55b4e2d447b8 in trans_commit(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/transaction.cc:266
|
#14 0x55b4e28e2dc7 in mysql_execute_command(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:5573
|
#15 0x55b4e28f2f5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:7972
|
#16 0x55b4e34471db in Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1906
|
#17 0x55b4e34443fc in Query_log_event::do_apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1581
|
#18 0x55b4e2669fd2 in Log_event::apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event.h:1498
|
#19 0x55b4e264bb66 in apply_event_and_update_pos_apply /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:3850
|
#20 0x55b4e264c8ed in apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:4036
|
#21 0x55b4e2e464d8 in rpt_handle_event /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:62
|
#22 0x55b4e2e4dd3d in handle_rpl_parallel_thread /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1363
|
#23 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#24 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
#25 0x7f67b6c22102 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x122102)
|
|
|
0x6180000a5790 is located 784 bytes inside of 816-byte region [0x6180000a5480,0x6180000a57b0)
|
freed by thread T45 here:
|
#0 0x7f67b729d7cf in __interceptor_free (/lib/x86_64-linux-gnu/libasan.so.5+0x10d7cf)
|
#1 0x55b4e3c48f5d in ut_allocator<unsigned char, true>::deallocate(unsigned char*, unsigned long) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/include/ut0new.h:426
|
#2 0x55b4e3e0d745 in mem_heap_block_free(mem_block_info_t*, mem_block_info_t*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/mem/mem0mem.cc:416
|
#3 0x55b4e429cd34 in mem_heap_free /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/include/mem0mem.ic:419
|
#4 0x55b4e429ff3d in dict_mem_table_free(dict_table_t*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/dict/dict0mem.cc:246
|
#5 0x55b4e4262a5e in dict_sys_t::remove(dict_table_t*, bool, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/dict/dict0dict.cc:2063
|
#6 0x55b4e3f8c4ad in row_drop_table_for_mysql(char const*, trx_t*, enum_sql_command, bool, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/row/row0mysql.cc:3320
|
#7 0x55b4e3c46817 in ha_innobase::delete_table(char const*, enum_sql_command) (/home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd+0x2de4817)
|
#8 0x55b4e3c0ffd4 in ha_innobase::delete_table(char const*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:13146
|
#9 0x55b4e30cd713 in hton_drop_table /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:564
|
#10 0x55b4e2f254df in THD::rm_temporary_table(handlerton*, char const*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/temporary_tables.cc:703
|
#11 0x55b4e2f2a505 in THD::free_tmp_table_share(TMP_TABLE_SHARE*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/temporary_tables.cc:1460
|
#12 0x55b4e2f250da in THD::drop_temporary_table(TABLE*, bool*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/temporary_tables.cc:669
|
#13 0x55b4e2b461a8 in mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:2365
|
#14 0x55b4e2b44dbe in mysql_rm_table(THD*, TABLE_LIST*, bool, bool, bool, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:2137
|
#15 0x55b4e28de484 in mysql_execute_command(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:4903
|
#16 0x55b4e28f2f5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:7972
|
#17 0x55b4e34471db in Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1906
|
#18 0x55b4e34443fc in Query_log_event::do_apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1581
|
#19 0x55b4e2669fd2 in Log_event::apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event.h:1498
|
#20 0x55b4e264bb66 in apply_event_and_update_pos_apply /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:3850
|
#21 0x55b4e264c8ed in apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:4036
|
#22 0x55b4e2e464d8 in rpt_handle_event /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:62
|
#23 0x55b4e2e4dd3d in handle_rpl_parallel_thread /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1363
|
#24 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#25 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
|
|
previously allocated by thread T48 here:
|
#0 0x7f67b729dbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
|
#1 0x55b4e3c48b1c in ut_allocator<unsigned char, true>::allocate(unsigned long, unsigned char const*, unsigned int, bool, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/include/ut0new.h:377
|
#2 0x55b4e3e0c9f9 in mem_heap_create_block_func(mem_block_info_t*, unsigned long, char const*, unsigned int, unsigned long) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/mem/mem0mem.cc:277
|
#3 0x55b4e3e0d339 in mem_heap_add_block(mem_block_info_t*, unsigned long) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/mem/mem0mem.cc:378
|
#4 0x55b4e429c9c1 in mem_heap_alloc /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/include/mem0mem.ic:193
|
#5 0x55b4e429c7d5 in mem_heap_zalloc /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/include/mem0mem.ic:162
|
#6 0x55b4e429ee1e in dict_mem_table_create(char const*, fil_space_t*, unsigned long, unsigned long, unsigned long, unsigned long) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/dict/dict0mem.cc:152
|
#7 0x55b4e3c40c3d in create_table_info_t::create_table_def() (/home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd+0x2ddec3d)
|
#8 0x55b4e3c0ba3e in create_table_info_t::create_table(bool) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:12196
|
#9 0x55b4e3c45ec6 in ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*, bool, trx_t*) (/home/buildbot/buildbot/build/mariadb-10.6.0/sql/mariadbd+0x2de3ec6)
|
#10 0x55b4e3c0e43d in ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*) /home/buildbot/buildbot/build/mariadb-10.6.0/storage/innobase/handler/ha_innodb.cc:12792
|
#11 0x55b4e30f1e17 in handler::ha_create(char const*, TABLE*, HA_CREATE_INFO*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:5094
|
#12 0x55b4e30f650f in ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, st_mysql_const_unsigned_lex_string*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/handler.cc:5559
|
#13 0x55b4e2b5cb22 in create_table_impl /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:5376
|
#14 0x55b4e2b5d496 in mysql_create_table_no_lock(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, Alter_info*, bool*, int, TABLE_LIST*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:5460
|
#15 0x55b4e2b5e102 in mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:5564
|
#16 0x55b4e2b8f194 in Sql_cmd_create_table_like::execute(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_table.cc:12248
|
#17 0x55b4e28e55ed in mysql_execute_command(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:5946
|
#18 0x55b4e28f2f5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:7972
|
#19 0x55b4e34471db in Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1906
|
#20 0x55b4e34443fc in Query_log_event::do_apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event_server.cc:1581
|
#21 0x55b4e2669fd2 in Log_event::apply_event(rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/log_event.h:1498
|
#22 0x55b4e264bb66 in apply_event_and_update_pos_apply /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:3850
|
#23 0x55b4e264c8ed in apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:4036
|
#24 0x55b4e2e464d8 in rpt_handle_event /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:62
|
#25 0x55b4e2e4dd3d in handle_rpl_parallel_thread /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1363
|
#26 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#27 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
|
|
Thread T48 created by T43 here:
|
#0 0x7f67b71ca805 in pthread_create (/lib/x86_64-linux-gnu/libasan.so.5+0x3a805)
|
#1 0x55b4e39f0694 in my_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/my_thread.h:38
|
#2 0x55b4e39f5a93 in pfs_spawn_thread_v1 /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2252
|
#3 0x55b4e2e4516d in inline_mysql_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/include/mysql/psi/mysql_thread.h:1139
|
#4 0x55b4e2e4f69d in rpl_parallel_change_thread_count /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1607
|
#5 0x55b4e2e50773 in rpl_parallel_activate_pool(rpl_parallel_thread_pool*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1747
|
#6 0x55b4e2653cbf in handle_slave_sql /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:5240
|
#7 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#8 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
|
|
Thread T43 created by T15 here:
|
#0 0x7f67b71ca805 in pthread_create (/lib/x86_64-linux-gnu/libasan.so.5+0x3a805)
|
#1 0x55b4e39f0694 in my_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/my_thread.h:38
|
#2 0x55b4e39f5a93 in pfs_spawn_thread_v1 /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2252
|
#3 0x55b4e26325fe in inline_mysql_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/include/mysql/psi/mysql_thread.h:1139
|
#4 0x55b4e263a4bb in start_slave_thread(unsigned int, void* (*)(void*), st_mysql_mutex*, st_mysql_mutex*, st_mysql_cond*, unsigned int volatile*, unsigned long volatile*, Master_info*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:1148
|
#5 0x55b4e263affa in start_slave_threads(THD*, bool, bool, Master_info*, char const*, char const*, int) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:1274
|
#6 0x55b4e296f4f2 in start_slave(THD*, Master_info*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_repl.cc:3241
|
#7 0x55b4e28d85d6 in mysql_execute_command(THD*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:4201
|
#8 0x55b4e28f2f5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:7972
|
#9 0x55b4e28c9a60 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:1886
|
#10 0x55b4e28c67a2 in do_command(THD*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:1397
|
#11 0x55b4e2d040cb in do_handle_one_connection(CONNECT*, bool) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_connect.cc:1410
|
#12 0x55b4e2d03a2f in handle_one_connection /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_connect.cc:1312
|
#13 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#14 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
|
|
Thread T15 created by T0 here:
|
#0 0x7f67b71ca805 in pthread_create (/lib/x86_64-linux-gnu/libasan.so.5+0x3a805)
|
#1 0x55b4e39f0694 in my_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/my_thread.h:38
|
#2 0x55b4e39f5a93 in pfs_spawn_thread_v1 /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2252
|
#3 0x55b4e25bfcda in inline_mysql_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/include/mysql/psi/mysql_thread.h:1139
|
#4 0x55b4e25d591f in create_thread_to_handle_connection(CONNECT*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mysqld.cc:5795
|
#5 0x55b4e25d5f94 in create_new_thread(CONNECT*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mysqld.cc:5854
|
#6 0x55b4e25d62ea in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mysqld.cc:5919
|
#7 0x55b4e25d6f0b in handle_connections_sockets() /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mysqld.cc:6046
|
#8 0x55b4e25d5135 in mysqld_main(int, char**) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/mysqld.cc:5690
|
#9 0x55b4e25bf00c in main /home/buildbot/buildbot/build/mariadb-10.6.0/sql/main.cc:25
|
#10 0x7f67b6b270b2 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x270b2)
|
|
|
Thread T45 created by T43 here:
|
#0 0x7f67b71ca805 in pthread_create (/lib/x86_64-linux-gnu/libasan.so.5+0x3a805)
|
#1 0x55b4e39f0694 in my_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/my_thread.h:38
|
#2 0x55b4e39f5a93 in pfs_spawn_thread_v1 /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2252
|
#3 0x55b4e2e4516d in inline_mysql_thread_create /home/buildbot/buildbot/build/mariadb-10.6.0/include/mysql/psi/mysql_thread.h:1139
|
#4 0x55b4e2e4f69d in rpl_parallel_change_thread_count /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1607
|
#5 0x55b4e2e50773 in rpl_parallel_activate_pool(rpl_parallel_thread_pool*) /home/buildbot/buildbot/build/mariadb-10.6.0/sql/rpl_parallel.cc:1747
|
#6 0x55b4e2653cbf in handle_slave_sql /home/buildbot/buildbot/build/mariadb-10.6.0/sql/slave.cc:5240
|
#7 0x55b4e39f56a0 in pfs_spawn_thread /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
|
#8 0x7f67b704e608 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x9608)
|
|
|
SUMMARY: AddressSanitizer: heap-use-after-free /usr/include/c++/9/bits/atomic_base.h:397 in std::__atomic_base<long>::store(long, std::memory_order)
|
Shadow bytes around the buggy address:
|
0x0c308000caa0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
|
0x0c308000cab0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
|
0x0c308000cac0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
|
0x0c308000cad0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
|
0x0c308000cae0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
|
=>0x0c308000caf0: fd fd[fd]fd fd fd fa fa fa fa fa fa fa fa fa fa
|
0x0c308000cb00: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
|
0x0c308000cb10: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
|
0x0c308000cb20: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
|
0x0c308000cb30: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
|
0x0c308000cb40: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
|
Shadow byte legend (one shadow byte represents 8 application bytes):
|
Addressable: 00
|
Partially addressable: 01 02 03 04 05 06 07
|
Heap left redzone: fa
|
Freed heap region: fd
|
Stack left redzone: f1
|
Stack mid redzone: f2
|
Stack right redzone: f3
|
Stack after return: f5
|
Stack use after scope: f8
|
Global redzone: f9
|
Global init order: f6
|
Poisoned by user: f7
|
Container overflow: fc
|
Array cookie: ac
|
Intra object redzone: bb
|
ASan internal: fe
|
Left alloca redzone: ca
|
Right alloca redzone: cb
|
Shadow gap: cc
|
==61747==ABORTING
|
210304 18:34:58 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.6.0-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=153
|
thread_count=10
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63794 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x62b000299288
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f67a6c4a850 thread_stack 0x5fc00
|
??:0(__interceptor_tcgetattr)[0x7f67b71fcd30]
|
mysys/stacktrace.c:212(my_print_stacktrace)[0x55b4e45ffb7b]
|
sql/signal_handler.cc:212(handle_fatal_signal)[0x55b4e30c4faf]
|
??:0(__restore_rt)[0x7f67b705a3c0]
|
??:0(gsignal)[0x7f67b6b4618b]
|
??:0(abort)[0x7f67b6b25859]
|
??:0(__sanitizer_set_report_fd)[0x7f67b72bb6a2]
|
??:0(__sanitizer_get_module_and_offset_for_pc)[0x7f67b72c624c]
|
??:0(__sanitizer_ptr_cmp)[0x7f67b72a78ec]
|
??:0(__asan_on_error)[0x7f67b72a7363]
|
??:0(__asan_report_store8)[0x7f67b72a874e]
|
bits/atomic_base.h:397(std::__atomic_base<long>::store(long, std::memory_order))[0x55b4e3c52d82]
|
trx/trx0trx.cc:1240(trx_t::commit_tables())[0x55b4e40ec095]
|
trx/trx0trx.cc:1334(trx_t::commit_in_memory(mtr_t const*))[0x55b4e40ecf18]
|
trx/trx0trx.cc:1508(trx_t::commit_low(mtr_t*))[0x55b4e40e4abe]
|
trx/trx0trx.cc:1514(trx_t::commit())[0x55b4e40e4bf3]
|
trx/trx0trx.cc:1639(trx_commit_for_mysql(trx_t*))[0x55b4e40e534b]
|
handler/ha_innodb.cc:3827(innobase_commit_low(trx_t*))[0x55b4e3bdaff8]
|
handler/ha_innodb.cc:3935(innobase_commit_ordered_2(trx_t*, THD*))[0x55b4e3bdb725]
|
handler/ha_innodb.cc:4047(innobase_commit(handlerton*, THD*, bool))[0x55b4e3bdc1f2]
|
sql/handler.cc:1942(commit_one_phase_2(THD*, bool, THD_TRANS*, bool))[0x55b4e30d48a9]
|
sql/handler.cc:1921(ha_commit_one_phase(THD*, bool))[0x55b4e30d45bd]
|
sql/handler.cc:1715(ha_commit_trans(THD*, bool))[0x55b4e30d290d]
|
sql/transaction.cc:266(trans_commit(THD*))[0x55b4e2d447b9]
|
sql/sql_parse.cc:5573(mysql_execute_command(THD*))[0x55b4e28e2dc8]
|
sql/sql_parse.cc:7972(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55b4e28f2f60]
|
sql/log_event_server.cc:1908(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55b4e34471dc]
|
sql/log_event_server.cc:1582(Query_log_event::do_apply_event(rpl_group_info*))[0x55b4e34443fd]
|
sql/log_event.h:1498(Log_event::apply_event(rpl_group_info*))[0x55b4e2669fd3]
|
sql/slave.cc:3850(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55b4e264bb67]
|
sql/slave.cc:4037(apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*))[0x55b4e264c8ee]
|
sql/rpl_parallel.cc:62(rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*))[0x55b4e2e464d9]
|
sql/rpl_parallel.cc:1363(handle_rpl_parallel_thread)[0x55b4e2e4dd3e]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55b4e39f56a1]
|
??:0(start_thread)[0x7f67b704e609]
|
??:0(clone)[0x7f67b6c22103]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x612000106753): COMMIT
|
|
|
Connection ID (thread ID): 36
|
Status: NOT_KILLED
|
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
|
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /dev/shm/var/3/mysqld.2/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 0 bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 23441 23441 processes
|
Max open files 1024 1024 files
|
Max locked memory 67108864 67108864 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 23441 23441 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E
|
|
|
----------SERVER LOG END-------------
|
Attachments
Issue Links
- blocks
-
MDEV-17805 Do not add temporary tables to dict_sys->table_hash
-
- Stalled
-
- duplicates
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Open
-
-
-
- Confirmed
-
-
-
- Closed
-
-
-
- Confirmed
-
-
-
- Open
-
(4 relates to)