Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
Description
CREATE TABLE t1 (a INT) ENGINE=Aria; |
CREATE VIEW v1 AS SELECT * FROM t1; |
CREATE TABLE t2 (b INT) ENGINE=Aria; |
CREATE TABLE t3 (a INT); |
LOCK TABLES t1 WRITE CONCURRENT, v1 WRITE, t2 WRITE CONCURRENT;
|
--error ER_BAD_FIELD_ERROR
|
ALTER TABLE t1 CHANGE x xx INT; |
--connect (con1,localhost,root,,test)
|
REPLACE INTO t3 VALUES (NULL); |
--connection default
|
--error ER_TABLE_NOT_LOCKED_FOR_WRITE
|
FLUSH TABLES;
|
DELETE FROM t1; |
10.2 93dc3e26 |
2020-02-17 21:45:51 140619617933056 [Note] /data/bld/10.2-debug-nightly/bin/mysqld (initiated by: root[root] @ localhost [127.0.0.1]): Normal shutdown
|
2020-02-17 21:45:51 140619617933056 [Note] Event Scheduler: Purging the queue. 0 events
|
mysqld: /data/src/10.2/mysys/thr_mutex.c:747: add_to_locked_mutex: Assertion `0' failed.
|
200217 21:45:51 [ERROR] mysqld got signal 6 ;
|
|
stdlib/abort.c:91(__GI_abort)[0x7fe49436b42a]
|
assert/assert.c:92(__assert_fail_base)[0x7fe494362e67]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2bf12)[0x7fe494362f12]
|
mysys/thr_mutex.c:749(add_to_locked_mutex)[0x562c1ea5fd2c]
|
mysys/thr_mutex.c:723(add_used_to_locked_mutex)[0x562c1ea5fc30]
|
mysys/thr_mutex.c:387(safe_mutex_lock)[0x562c1ea5efc0]
|
psi/mysql_thread.h:673(inline_mysql_mutex_lock)[0x562c1e925920]
|
maria/ma_close.c:68(maria_close)[0x562c1e925dfd]
|
maria/ha_maria.cc:1278(ha_maria::close())[0x562c1e8a1ed4]
|
sql/handler.cc:2650(handler::ha_close())[0x562c1e317853]
|
sql/table.cc:3490(closefrm(TABLE*))[0x562c1e19b2a6]
|
sql/table_cache.cc:223(intern_close_table(TABLE*))[0x562c1e288d67]
|
sql/table_cache.cc:334(tc_purge(bool))[0x562c1e28918b]
|
sql/sql_base.cc:376(close_cached_tables(THD*, TABLE_LIST*, bool, unsigned long))[0x562c1e01d5ed]
|
sql/table_cache.cc:648(tdc_start_shutdown())[0x562c1e28a20c]
|
sql/mysqld.cc:2225(clean_up(bool))[0x562c1df9be5c]
|
sql/mysqld.cc:2100(unireg_end())[0x562c1df9b95c]
|
sql/mysqld.cc:2026(kill_server(void*))[0x562c1df9b856]
|
sql/mysqld.cc:2051(kill_server_thread)[0x562c1df9b898]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x562c1e9fd6de]
|
nptl/pthread_create.c:456(start_thread)[0x7fe4962eb4a4]
|
x86_64/clone.S:99(clone)[0x7fe49441fd0f]
|
Coredump isn't created.
If I add a cleanup section to the end of the MTR test case, the assertion fails on DROP TABLE rather than on shutdown, but the server hangs before it finally aborts. The coredump is still not created.
CREATE TABLE t1 (a INT) ENGINE=Aria; |
CREATE VIEW v1 AS SELECT * FROM t1; |
CREATE TABLE t2 (b INT) ENGINE=Aria; |
CREATE TABLE t3 (a INT); |
LOCK TABLES t1 WRITE CONCURRENT, v1 WRITE, t2 WRITE CONCURRENT;
|
--error ER_BAD_FIELD_ERROR
|
ALTER TABLE t1 CHANGE x xx INT; |
--connect (con1,localhost,root,,test)
|
REPLACE INTO t3 VALUES (NULL); |
--connection default
|
--error ER_TABLE_NOT_LOCKED_FOR_WRITE
|
FLUSH TABLES;
|
DELETE FROM t1; |
|
# Cleanup
|
UNLOCK TABLES;
|
--disconnect con1
|
DROP VIEW v1; |
DROP TABLE t1, t2, t3; |
10.2 93dc3e26 |
mysqld: /data/src/10.2/mysys/thr_mutex.c:747: add_to_locked_mutex: Assertion `0' failed.
|
200217 21:48:51 [ERROR] mysqld got signal 6 ;
|
|
linux/raise.c:51(__GI_raise)[0x7f5db397cfff]
|
stdlib/abort.c:91(__GI_abort)[0x7f5db397e42a]
|
assert/assert.c:92(__assert_fail_base)[0x7f5db3975e67]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2bf12)[0x7f5db3975f12]
|
mysys/thr_mutex.c:749(add_to_locked_mutex)[0x55d52ade3d2c]
|
mysys/thr_mutex.c:723(add_used_to_locked_mutex)[0x55d52ade3c30]
|
mysys/thr_mutex.c:387(safe_mutex_lock)[0x55d52ade2fc0]
|
psi/mysql_thread.h:673(inline_mysql_mutex_lock)[0x55d52aca9920]
|
maria/ma_close.c:68(maria_close)[0x55d52aca9dfd]
|
maria/ha_maria.cc:1278(ha_maria::close())[0x55d52ac25ed4]
|
sql/handler.cc:2650(handler::ha_close())[0x55d52a69b853]
|
sql/table.cc:3490(closefrm(TABLE*))[0x55d52a51f2a6]
|
sql/table_cache.cc:223(intern_close_table(TABLE*))[0x55d52a60cd67]
|
sql/table_cache.cc:1131(tdc_remove_table(THD*, enum_tdc_remove_table_type, char const*, char const*, bool))[0x55d52a60f7fa]
|
sql/sql_table.cc:2440(mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool))[0x55d52a4db229]
|
sql/sql_table.cc:2089(mysql_rm_table(THD*, TABLE_LIST*, char, char))[0x55d52a4da5f5]
|
sql/sql_parse.cc:4505(mysql_execute_command(THD*))[0x55d52a41985b]
|
sql/sql_parse.cc:7739(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d52a423bea]
|
sql/sql_parse.cc:1833(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d52a411f43]
|
sql/sql_parse.cc:1384(do_command(THD*))[0x55d52a410897]
|
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x55d52a5658d3]
|
sql/sql_connect.cc:1242(handle_one_connection)[0x55d52a56563e]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55d52ad816de]
|
nptl/pthread_create.c:456(start_thread)[0x7f5db58fe4a4]
|
x86_64/clone.S:99(clone)[0x7f5db3a32d0f]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f5d9c012448): DROP TABLE t1, t2, t3
|
Connection ID (thread ID): 4
|
Status: NOT_KILLED
|
Reproducible on 10.2, 10.3.
Not reproducible on 10.1, 10.4.
No visible effect on a non-debug build.
Is likely to be related to MDEV-21754.
Attachments
Issue Links
- relates to
-
MDEV-18088 Assertion `share->in_trans == 0' failed in maria_close upon double ALTER under lock
- Closed
-
MDEV-21754 Assertion `file->trn == trn' failed in ha_maria::start_stmt upon DML under concurrent locks
- Closed