[MDEV-12388] InnoDB: Failing assertion: rollback in innobase/btr/btr0cur.cc line 7142 upon upgrade - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.5
Component/s: Storage Engine - InnoDB
Labels:
None

Description

2017-03-27 04:47:43 0x7f2efc3fb700  InnoDB: Assertion failure in file /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc line 7142

InnoDB: Failing assertion: rollback

10.2 b56262f69677fd
#6 0x00007f2f297f710f in ut_dbg_assertion_failed (expr=0x7f2f29de6455 "rollback", file=0x7f2f29de3b48 "/home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc", line=7142) at /home/elenst/git/10.2/storage/innobase/ut/ut0dbg.cc:60
#7 0x00007f2f29831ad8 in btr_free_externally_stored_field (index=0x7f2ef8c84d08, field_ref=0x7f2f0aa3b511 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rollback=false, local_mtr=0x7f2efc3fa6a0) at /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc:7142
#8 0x00007f2f297445ab in row_purge_upd_exist_or_extern_func (thr=0x7f2f26069228, node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214") at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:785
#9 0x00007f2f29744bf7 in row_purge_record_func (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228, updated_extern=true) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:966
#10 0x00007f2f29744d47 in row_purge (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1010
#11 0x00007f2f29745000 in row_purge_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1089
#12 0x00007f2f296d0f56 in que_thr_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1052
#13 0x00007f2f296d1151 in que_run_threads_low (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1114
#14 0x00007f2f296d1305 in que_run_threads (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1154
#15 0x00007f2f297c2a9f in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at /home/elenst/git/10.2/storage/innobase/trx/trx0purge.cc:1743
#16 0x00007f2f29792882 in srv_do_purge (thd=0x7f2ef8c16070, n_threads=4, n_total_purged=0x7f2efc3fae30) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2818
#17 0x00007f2f29792e40 in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2963
#18 0x00007f2f27491e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#19 0x00007f2f269a8cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6

The test ran 10.1.20 server, executed some DDL/DML on it, shut down it normally, and then tried to start 10.2 on the datadir.

10.1.20 startup options
--log-bin
--binlog-format=ROW
--innodb-page-size=4K
--innodb-compression-algorithm=zlib
--file-key-management
--file-key-management-filename=encryption_keys.txt
--plugin-load-add=file_key_management.so
--innodb-encrypt-tables
--innodb-encrypt-log
--innodb-encryption-threads=4
--aria-encrypt-tables=1
--encrypt-tmp-disk-tables=1
--encrypt-binlog
--ignore-builtin-innodb
--plugin-load-add=ha_innodb

10.2 startup options
--log-bin
--binlog-format=ROW
--innodb-page-size=4K
--innodb-compression-algorithm=zlib
--file-key-management
--file-key-management-filename=encryption_keys.txt
--plugin-load-add=file_key_management.so
--innodb-encrypt-tables
--innodb-encrypt-log
--innodb-encryption-threads=4
--aria-encrypt-tables=1
--encrypt-tmp-disk-tables=1
--encrypt-binlog

Datadir, coredump and mysqld binary: ftp://ftp.askmonty.org/public/mdev12388.tar.gz

Attachments

Issue Links

duplicates

MDEV-12289 Keep 128 persistent rollback segments for compatibility and performance

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2017-03-28 23:03

Elena Stepanova made changes - 2017-03-28 23:09

Field	Original Value	New Value
Description	{noformat} 2017-03-27 04:47:43 0x7f2efc3fb700 InnoDB: Assertion failure in file /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc line 7142 InnoDB: Failing assertion: rollback {noformat} {noformat:title=10.2 b56262f69677fd} #6 0x00007f2f297f710f in ut_dbg_assertion_failed (expr=0x7f2f29de6455 "rollback", file=0x7f2f29de3b48 "/home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc", line=7142) at /home/elenst/git/10.2/storage/innobase/ut/ut0dbg.cc:60 #7 0x00007f2f29831ad8 in btr_free_externally_stored_field (index=0x7f2ef8c84d08, field_ref=0x7f2f0aa3b511 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rollback=false, local_mtr=0x7f2efc3fa6a0) at /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc:7142 #8 0x00007f2f297445ab in row_purge_upd_exist_or_extern_func (thr=0x7f2f26069228, node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214") at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:785 #9 0x00007f2f29744bf7 in row_purge_record_func (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228, updated_extern=true) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:966 #10 0x00007f2f29744d47 in row_purge (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1010 #11 0x00007f2f29745000 in row_purge_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1089 #12 0x00007f2f296d0f56 in que_thr_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1052 #13 0x00007f2f296d1151 in que_run_threads_low (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1114 #14 0x00007f2f296d1305 in que_run_threads (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1154 #15 0x00007f2f297c2a9f in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at /home/elenst/git/10.2/storage/innobase/trx/trx0purge.cc:1743 #16 0x00007f2f29792882 in srv_do_purge (thd=0x7f2ef8c16070, n_threads=4, n_total_purged=0x7f2efc3fae30) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2818 #17 0x00007f2f29792e40 in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2963 #18 0x00007f2f27491e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #19 0x00007f2f269a8cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} The test ran 10.1.20 server, executed some DDL/DML on it, shut down it normally, and then tried to start 10.2 on the datadir. {noformat:title=10.1.20 startup options} --log-bin --binlog-format=ROW --innodb-page-size=4K --innodb-compression-algorithm=zlib --file-key-management --file-key-management-filename=encryption_keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog --ignore-builtin-innodb --plugin-load-add=ha_innodb {noformat} {noformat:title=10.2 startup options} --log-bin --binlog-format=ROW --innodb-page-size=4K --innodb-compression-algorithm=zlib --file-key-management --file-key-management-filename=encryption_keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog {noformat}	{noformat} 2017-03-27 04:47:43 0x7f2efc3fb700 InnoDB: Assertion failure in file /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc line 7142 InnoDB: Failing assertion: rollback {noformat} {noformat:title=10.2 b56262f69677fd} #6 0x00007f2f297f710f in ut_dbg_assertion_failed (expr=0x7f2f29de6455 "rollback", file=0x7f2f29de3b48 "/home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc", line=7142) at /home/elenst/git/10.2/storage/innobase/ut/ut0dbg.cc:60 #7 0x00007f2f29831ad8 in btr_free_externally_stored_field (index=0x7f2ef8c84d08, field_ref=0x7f2f0aa3b511 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rollback=false, local_mtr=0x7f2efc3fa6a0) at /home/elenst/git/10.2/storage/innobase/btr/btr0cur.cc:7142 #8 0x00007f2f297445ab in row_purge_upd_exist_or_extern_func (thr=0x7f2f26069228, node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214") at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:785 #9 0x00007f2f29744bf7 in row_purge_record_func (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228, updated_extern=true) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:966 #10 0x00007f2f29744d47 in row_purge (node=0x7f2f260692f0, undo_rec=0x7f2ef8c66088 "\th\214", thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1010 #11 0x00007f2f29745000 in row_purge_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/row/row0purge.cc:1089 #12 0x00007f2f296d0f56 in que_thr_step (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1052 #13 0x00007f2f296d1151 in que_run_threads_low (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1114 #14 0x00007f2f296d1305 in que_run_threads (thr=0x7f2f26069228) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1154 #15 0x00007f2f297c2a9f in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at /home/elenst/git/10.2/storage/innobase/trx/trx0purge.cc:1743 #16 0x00007f2f29792882 in srv_do_purge (thd=0x7f2ef8c16070, n_threads=4, n_total_purged=0x7f2efc3fae30) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2818 #17 0x00007f2f29792e40 in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2963 #18 0x00007f2f27491e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #19 0x00007f2f269a8cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} The test ran 10.1.20 server, executed some DDL/DML on it, shut down it normally, and then tried to start 10.2 on the datadir. {noformat:title=10.1.20 startup options} --log-bin --binlog-format=ROW --innodb-page-size=4K --innodb-compression-algorithm=zlib --file-key-management --file-key-management-filename=encryption_keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog --ignore-builtin-innodb --plugin-load-add=ha_innodb {noformat} {noformat:title=10.2 startup options} --log-bin --binlog-format=ROW --innodb-page-size=4K --innodb-compression-algorithm=zlib --file-key-management --file-key-management-filename=encryption_keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog {noformat} Datadir, coredump and mysqld binary: ftp://ftp.askmonty.org/public/mdev12388.tar.gz

Elena Stepanova made changes - 2017-03-28 23:09

Assignee

Elena Stepanova [ elenst ]

Marko Mäkelä [ marko ]

Marko Mäkelä made changes - 2017-04-04 07:56

Link

This issue duplicates ~~MDEV-12289~~ [ ~~MDEV-12289~~ ]

Elena Stepanova made changes - 2017-04-04 10:28

Assignee

Marko Mäkelä [ marko ]

Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2017-04-04 18:21

Fix Version/s		10.2.5 [ 22117 ]
Fix Version/s	10.2 [ 14601 ]
Assignee	Elena Stepanova [ elenst ]	Marko Mäkelä [ marko ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:44

Workflow

MariaDB v3 [ 80161 ]

MariaDB v4 [ 151877 ]

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-03-28 23:03

Updated:: 2017-04-04 18:21

Resolved:: 2017-04-04 18:21

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server