InnoDB: Failing assertion: rw_lock_own(&index->lock, 352) || rw_lock_own(&index->lock, 351) in file row0log.cc line 977 | abort (sig=6) in row_log_table_get_pk

Bug #1226529 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Expired
Medium
Unassigned
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Expired
Medium
Unassigned

Bug Description

Version: '5.6.13-rc60.5-debug-log' socket: '/ssd//128776/current1_5/tmp/master.sock' port: 13080 Percona Server with XtraDB (GPL), Release rc60.5, Revision 437-debug
2013-09-16 15:05:52 7faa82301700 InnoDB: Assertion failure in thread 140370305357568 in file row0log.cc line 977
InnoDB: Failing assertion: rw_lock_own(&index->lock, 352) || rw_lock_own(&index->lock, 351)
[...]
Query (7faa1c004c50): REPLACE INTO `table500_innodb_compressed_int` ( `c10` ) VALUES ( LOAD_FILE('/ssd/randgen/data/earth215kb.jpg') )
Connection ID (thread ID): 19
Status: NOT_KILLED

==============

Thread 1 (LWP 21215):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000599bf9 in row_log_table_get_pk (rec=0x7faa901b4087 "\200", index=0x7faa0c050668, offsets=0x7faa822fe950, heap=0x7faa822fe3d8) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0log.cc:976
#6 0x0000000000af7c26 in row_upd_clust_rec (node=0x7faa1c083bc8, index=0x7faa0c050668, offsets=0x7faa822fe950, offsets_heap=0x7faa822fec78, thr=0x7faa1c084210, mtr=0x7faa822fe480) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2163
#7 0x0000000000afb58f in row_upd_clust_step (node=0x7faa1c083bc8, thr=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2517
#8 0x0000000000afbccd in row_upd (thr=0x7faa1c084210, node=0x7faa1c083bc8) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2572
#9 row_upd_step (thr=0x7faa1c084210) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2724
#10 0x0000000000acce5b in row_update_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7faa1c082a98) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0mysql.cc:1729
#11 0x0000000000a07629 in ha_innobase::update_row (this=0x7faa1c070bb0, old_row=0x7faa1c0301d0 "\277\217", new_row=0x7faa1c030140 "\377\377") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:7412
#12 0x00000000005bf78a in handler::ha_update_row (this=0x7faa1c070bb0, old_data=0x7faa1c0301d0 "\277\217", new_data=0x7faa1c030140 "\377\377") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/handler.cc:7480
#13 0x000000000070559a in write_record (thd=0x1f86f70, table=0x7faa1c0466d0, info=0x7faa822ff260, update=0x7faa822ff1e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_insert.cc:1869
#14 0x000000000070c949 in mysql_insert (thd=0x1f86f70, table_list=0x7faa1c004e78, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_insert.cc:1073
#15 0x0000000000724bf9 in mysql_execute_command (thd=0x1f86f70) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:3649
#16 0x0000000000728628 in mysql_parse (thd=0x1f86f70, rawbuf=0x1f89330 "P\303\070\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#17 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x1f86f70, packet=0x7faa82300a90 "po\370\001", packet_length=112) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#18 0x000000000072a987 in do_command (thd=0x1f86f70) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#19 0x00000000006ee1ef in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#20 0x00000000006ee2d7 in handle_one_connection (arg=0x1f86f70) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#21 0x00000000009e033a in pfs_spawn_thread (arg=0x1f1dfc0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#22 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#23 0x0000003636ee890d in clone () from /lib64/libc.so.6

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

RQG @ 909 <email address hidden>
PS @ Percona-Server-5.6.13-rc60.5-437-debug.Linux.x86_64 (5.6-QA)

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

(gdb) up
#9 row_upd_step (thr=0x7faa1c084210) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2724
2724 err = row_upd(node, thr);
(gdb) p trx->fake_changes
$1 = 1

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Pushing a provisional fix.

tags: added: fake-changes
Revision history for this message
Roel Van de Paar (roel11) wrote :

Fake changes in alpha, so no 56qual

tags: removed: 56qual
Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

* Scenario looks bit difficult to imagine given that DDL operation are blocked.
* Also, lately we have resolved lot of bugs in this area so may be this issue may not persist. Can you check if we can get a reproducible test-case ?

Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for Percona Server 5.6 because there has been no activity for 60 days.]

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1418

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.