Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4
-
None
Description
Note: The failure became possible after MDEV-371, without it the key without a length in the table definition is rejected.
Reproducible on 10.4 fb01193c and bb-10.4-release-long_unique 5ddae0e0.
--source include/have_innodb.inc
|
|
|
CREATE TABLE t1 (f MULTIPOLYGON, UNIQUE(f)) ENGINE=InnoDB WITH SYSTEM VERSIONING; |
INSERT INTO t1 () VALUES (); |
DELETE FROM t1; |
DROP TABLE t1; |
|
|
--source include/restart_mysqld.inc
|
|
|
--echo # All done |
|
bb-10.4-release-long_unique 5ddae0e0 |
mysqld: /data/src/bb-10.4-release-long_unique/storage/innobase/trx/trx0trx.cc:411: void trx_free(trx_t*&): Assertion `!trx->n_mysql_tables_in_use' failed.
|
190225 15:30:59 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f3e63b3dee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000056209eb5b7e6 in trx_free (trx=@0x7f3e5ce66bc8: 0x7f3e5d94d140) at /data/src/bb-10.4-release-long_unique/storage/innobase/trx/trx0trx.cc:411
|
#9 0x000056209e94101c in innobase_close_connection (hton=0x5620a1a548a0, thd=0x7f3e08000b00) at /data/src/bb-10.4-release-long_unique/storage/innobase/handler/ha_innodb.cc:5130
|
#10 0x000056209e5ffafe in closecon_handlerton (thd=0x7f3e08000b00, plugin=0x7f3e08137c10, unused=0x0) at /data/src/bb-10.4-release-long_unique/sql/handler.cc:796
|
#11 0x000056209e2da315 in plugin_foreach_with_mask (thd=0x7f3e08000b00, func=0x56209e5ffa83 <closecon_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=10, arg=0x0) at /data/src/bb-10.4-release-long_unique/sql/sql_plugin.cc:2432
|
#12 0x000056209e5ffb4c in ha_close_connection (thd=0x7f3e08000b00) at /data/src/bb-10.4-release-long_unique/sql/handler.cc:811
|
#13 0x000056209e249958 in THD::free_connection (this=0x7f3e08000b00) at /data/src/bb-10.4-release-long_unique/sql/sql_class.cc:1590
|
#14 0x000056209e18612f in unlink_thd (thd=0x7f3e08000b00) at /data/src/bb-10.4-release-long_unique/sql/mysqld.cc:2622
|
#15 0x000056209e1865c2 in one_thread_per_connection_end (thd=0x7f3e08000b00, put_in_cache=true) at /data/src/bb-10.4-release-long_unique/sql/mysqld.cc:2759
|
#16 0x000056209e42f92d in do_handle_one_connection (connect=0x5620a1dd9fa0) at /data/src/bb-10.4-release-long_unique/sql/sql_connect.cc:1414
|
#17 0x000056209e42f614 in handle_one_connection (arg=0x5620a1dd9fa0) at /data/src/bb-10.4-release-long_unique/sql/sql_connect.cc:1302
|
#18 0x000056209e9269cf in pfs_spawn_thread (arg=0x5620a1e1fe10) at /data/src/bb-10.4-release-long_unique/storage/perfschema/pfs.cc:1862
|
#19 0x00007f3e65814494 in start_thread (arg=0x7f3e5ce67700) at pthread_create.c:333
|
#20 0x00007f3e63bfa93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Server restart is not necessary, but it makes the failure more obvious in MTR.