[MDEV-17822] [Draft] InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/include/trx0trx.ic line 61 Created: 2018-11-23  Updated: 2023-11-28  Resolved: 2023-11-28

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: File BT-16274.yy     File BT-16274.zz    

 Description   

Possibly related to MDEV-14409

10.4 46a411088

2018-11-23 23:09:05 0x7fe3f4195700  InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/include/trx0trx.ic line 61
InnoDB: We intentionally generate a memory trap.
 
#5  0x00007fe3f766e3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6  0x000055a2b55838f4 in ut_dbg_assertion_failed (expr=0x0, file=0x55a2b5aece00 "/data/src/10.4/storage/innobase/include/trx0trx.ic", line=61) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
#7  0x000055a2b53e631e in trx_state_eq (trx=0x7fe3f4278418, state=TRX_STATE_NOT_STARTED, relaxed=false) at /data/src/10.4/storage/innobase/include/trx0trx.ic:61
#8  0x000055a2b53fd9b7 in PrintNotStarted::operator() (this=0x7fe3f4193ad0, trx=0x7fe3f4278418) at /data/src/10.4/storage/innobase/lock/lock0lock.cc:4640
#9  0x000055a2b53fe8b5 in ut_list_map<ut_list_base<trx_t, ut_list_node<trx_t> trx_t::*>, PrintNotStarted> (list=..., functor=...) at /data/src/10.4/storage/innobase/include/ut0lst.h:449
#10 0x000055a2b53f4d70 in lock_print_info_all_transactions (file=0x55a2b8bee730) at /data/src/10.4/storage/innobase/lock/lock0lock.cc:4767
#11 0x000055a2b55244a1 in srv_printf_innodb_monitor (file=0x55a2b8bee730, nowait=0, trx_start_pos=0x7fe3f4193be0, trx_end=0x7fe3f4193be8) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:1258
#12 0x000055a2b5372a73 in innodb_show_status (hton=0x55a2b8ba7a30, thd=0x7fe388000b00, stat_print=0x55a2b5044fbb <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:15638
#13 0x000055a2b53734e0 in innobase_show_status (hton=0x55a2b8ba7a30, thd=0x7fe388000b00, stat_print=0x55a2b5044fbb <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>, stat_type=HA_ENGINE_STATUS) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:16056
#14 0x000055a2b5045355 in ha_show_status (thd=0x7fe388000b00, db_type=0x55a2b8ba7a30, stat=HA_ENGINE_STATUS) at /data/src/10.4/sql/handler.cc:5897
#15 0x000055a2b4d31c52 in mysql_execute_command (thd=0x7fe388000b00) at /data/src/10.4/sql/sql_parse.cc:4012
#16 0x000055a2b4d3e9d8 in mysql_parse (thd=0x7fe388000b00, rawbuf=0x7fe388015b48 "SHOW ENGINE INNODB STATUS /* QNO 45512 CON_ID 14 */", length=51, parser_state=0x7fe3f4194650, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8091
#17 0x000055a2b4d2bcd7 in dispatch_command (command=COM_QUERY, thd=0x7fe388000b00, packet=0x7fe37579a251 "", packet_length=52, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#18 0x000055a2b4d2a6fb in do_command (thd=0x7fe388000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#19 0x000055a2b4e94b3c in do_handle_one_connection (connect=0x55a2b96c2590) at /data/src/10.4/sql/sql_connect.cc:1402
#20 0x000055a2b4e948c0 in handle_one_connection (arg=0x55a2b96c2590) at /data/src/10.4/sql/sql_connect.cc:1308
#21 0x00007fe3f9121494 in start_thread (arg=0x7fe3f4195700) at pthread_create.c:333
#22 0x00007fe3f772293f in clone () from /lib/x86_64-linux-gnu/libc.so.6

elenst-jira-refs 0025eb562b

perl ./runall-trials.pl --trials=2 --basedir=/data/bld/10.4 --vardir=/dev/shm/vardir2 --duration=350 --threads=2 --seed=1542950052 --reporters=Backtrace,ErrorLog,Deadlock  --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy  --redefine=conf/mariadb/redefine_temporary_tables.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=5 --mysqld=--loose-innodb-lock-wait-timeout=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=BT-16274.yy --gendata=BT-16274.zz  --mysqld=--sql-mode=

Appeared once so far during the chase for MDEV-14409 and MDEV-14126.



 Comments   
Comment by Elena Stepanova [ 2019-04-01 ]

On 10.3: https://travis-ci.org/elenst/travis-tests/jobs/513765565

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