[Note] Slave SQL: Rolling back unfinished transaction (no COMMIT or ROLLBACK in relay log). A probable cause is that the master died while writing the transaction to its binary log, thus rolled back too. Error_code: 0 | mysqld got signal 11 ; | handle_fatal_signal (sig=11) in inline_mysql_prlock_rdlock
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
| 5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
| 5.5 |
New
|
Undecided
|
Unassigned | |||
| 5.6 |
New
|
Undecided
|
Unassigned | |||
| 5.7 |
New
|
Undecided
|
Unassigned | |||
Bug Description
2014-10-18 11:28:26 25769 [Note] /sda/Percona-
Version: '5.6.21-69.0-debug' socket: '/dev/shm/
2014-10-18 11:28:27 25769 [Warning] Did not write failed 'GRANT ALL ON *.* TO 'test2'
InnoDB: user stopword table not_defined does not exist.
2014-10-18 11:28:32 25769 [Note] Slave SQL: Rolling back unfinished transaction (no COMMIT or ROLLBACK in relay log). A probable cause is that the master died while writing the transaction to its binary log, thus rolled back too. Error_code: 0
00:28:32 UTC - mysqld got signal 11 ;
Thread 1 (Thread 0x7f37c5811700 (LWP 25867)):
+bt
#0 0x00007f37debda771 in pthread_kill () from /lib64/
#1 0x0000000000ab7586 in my_write_core (sig=11) at /mnt/workspace/
#2 0x000000000072f9ff in handle_fatal_signal (sig=11) at /mnt/workspace/
#3 <signal handler called>
#4 0x000000000071a7f1 in inline_
#5 0x000000000071c29c in MDL_lock:
#6 0x000000000071e293 in MDL_ticket:
#7 0x00000000007be997 in mysql_ha_flush (thd=0x1b4c510) at /mnt/workspace/
#8 0x0000000000774586 in open_tables (thd=0x1b4c510, start=0x7f37c58
#9 0x0000000000775932 in open_normal_
#10 0x00000000007ea71c in execute_
#11 0x00000000007e2de9 in mysql_execute_
#12 0x00000000007ed193 in mysql_parse (thd=0x1b4c510, rawbuf=
#13 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x1b4c510, packet=0x233c401 "select * from t2 where firstname='john' and firstname = binary 'john';", packet_length=70) at /mnt/workspace/
#14 0x00000000007de528 in do_command (thd=0x1b4c510) at /mnt/workspace/
#15 0x00000000008c2c30 in threadpool_
#16 0x00000000008c5572 in handle_event (connection=
#17 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/
#18 0x0000000000dc5bac in pfs_spawn_thread (arg=0x2303960) at /mnt/workspace/
#19 0x00007f37debd5df3 in start_thread () from /lib64/
#20 0x00007f37dd89f01d in clone () from /lib64/libc.so.6
| Roel Van de Paar (roel11) wrote | #1 |
| Roel Van de Paar (roel11) wrote | #2 |
| Roel Van de Paar (roel11) wrote | #3 |
| summary: |
2014-10-18 11:28:32 25769 [Note] Slave SQL: Rolling back unfinished transaction (no COMMIT or ROLLBACK in relay log). A probable cause is that the master died while writing the transaction to its binary log, - thus rolled back too. Error_code: 0 | 00:28:32 UTC - mysqld got signal - 11 ; | handle_fatal_signal (sig=11) in inline_mysql_prlock_rdlock + thus rolled back too. Error_code: 0 | mysqld got signal 11 ; | + handle_fatal_signal (sig=11) in inline_mysql_prlock_rdlock |
| summary: |
- 2014-10-18 11:28:32 25769 [Note] Slave SQL: Rolling back unfinished - transaction (no COMMIT or ROLLBACK in relay log). A probable cause is - that the master died while writing the transaction to its binary log, - thus rolled back too. Error_code: 0 | mysqld got signal 11 ; | - handle_fatal_signal (sig=11) in inline_mysql_prlock_rdlock + [Note] Slave SQL: Rolling back unfinished transaction (no COMMIT or + ROLLBACK in relay log). A probable cause is that the master died while + writing the transaction to its binary log, thus rolled back too. + Error_code: 0 | mysqld got signal 11 ; | handle_fatal_signal (sig=11) + in inline_mysql_prlock_rdlock |
| Roel Van de Paar (roel11) wrote | #4 |
| Laurynas Biveinis (laurynas-biveinis) wrote | #5 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #6 |
Query (7f3774004e90): select * from t2 where firstname='john' and firstname = binary 'john'