transaction keeps on refreshing fake-change setting even during its lifetime (where-in trx should honor and lock setting at start only as per the semantics)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Low
|
Krunal Bauskar | ||
5.1 |
New
|
Undecided
|
Unassigned | ||
5.5 |
New
|
Undecided
|
Unassigned | ||
5.6 |
Triaged
|
Low
|
Krunal Bauskar |
Bug Description
2013-09-16 17:14:17 14022 [Note] /ssd/Percona-
Version: '5.6.13-
InnoDB: error in sec index entry update in
InnoDB: index `c23` of table `test`.
InnoDB: tuple DATA TUPLE: 2 fields;
0: len 1; hex 8f; asc ;;
1: len 1; hex 20; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 20; asc ;;
TRANSACTION 29504, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 16, OS thread handle 0x7f4e3a54a700, query id 5470 127.0.0.1 root update
REPLACE INTO `view_table1_
InnoDB: Submit a detailed bug report to http://
2013-09-16 17:16:07 7f4e3a54a700 InnoDB: Assertion failure in thread 139973962802944 in file row0upd.cc line 1803
InnoDB: Failing assertion: 0
InnoDB: We intentionally generate a memory trap.
[...]
Query (7f4dd8004c50): REPLACE INTO `view_table1_
Connection ID (thread ID): 16
Status: NOT_KILLED
===========
Thread 1 (LWP 14270):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000af951e in row_upd_
#6 0x0000000000afbe77 in row_upd_sec_step (thr=0x7f4dd805
#7 row_upd (thr=0x7f4dd805
#8 row_upd_step (thr=0x7f4dd805
#9 0x0000000000acce5b in row_update_
#10 0x0000000000a04e87 in ha_innobase:
#11 0x00000000005c1375 in handler:
#12 0x00000000007050ed in write_record (thd=0x3168880, table=0x7f4dd80
#13 0x000000000070c949 in mysql_insert (thd=0x3168880, table_list=
#14 0x0000000000724bf9 in mysql_execute_
#15 0x0000000000728628 in mysql_parse (thd=0x3168880, rawbuf=0x316ac40 "P\303\070\001", length=<optimized out>, parser_
#16 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x3168880, packet=
#17 0x000000000072a987 in do_command (thd=0x3168880) at /bzr/5.
#18 0x00000000006ee1ef in do_handle_
#19 0x00000000006ee2d7 in handle_
#20 0x00000000009e033a in pfs_spawn_thread (arg=0x3133d30) at /bzr/5.
#21 0x0000003637207851 in start_thread () from /lib64/
#22 0x0000003636ee890d in clone () from /lib64/libc.so.6
Changed in percona-server: | |
milestone: | none → 5.6.13-61.0 |
tags: | added: fake-changes |
RQG @ 909 <email address hidden> Server- 5.6.13- rc60.5- 437-debug. Linux.x86_ 64 (5.6-QA)
PS @ Percona-