[MDEV-18731] Assertion `!trx->n_mysql_tables_in_use' failed in trx_free after actions on versioned table with blob key Created: 2019-02-25  Updated: 2019-03-04  Resolved: 2019-03-04

Status: Closed
Project: MariaDB Server
Component/s: Data types, Storage Engine - InnoDB, Versioned Tables
Affects Version/s: 10.4
Fix Version/s: 10.4.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: 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.



 Comments   
Comment by Sachin Setiya (Inactive) [ 2019-03-04 ]

This mdev no longer fails , Serg patches have also fixed this issue.

Generated at Thu Feb 08 08:46:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.