Skip to content

Instantly share code, notes, and snippets.

@dyangrev

dyangrev/gist:29193ec6abeffca85d43

Created March 4, 2015 21:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dyangrev/29193ec6abeffca85d43 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dyangrev/29193ec6abeffca85d43 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
150304 12:19:16
*** (1) TRANSACTION:
TRANSACTION 95B6, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2
MySQL thread id 587, OS thread handle 0x7fa5fdc76700, query id 5596 localhost 127.0.0.1 root Updating
UPDATE GuestStay SET updated_at = '2015-03-04 20:19:16', average_room_rate = '0', es_version = 2 WHERE id = 3434580
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 37 page no 13025 n bits 88 index `PRIMARY` of table `inguest`.`GuestStay` trx id 95B6 lock_mode X locks rec but not gap waiting
Record lock, heap no 16 PHYSICAL RECORD: n_fields 80; compact format; info bits 0
0: len 4; hex 80346854; asc 4hT;;
1: len 6; hex 0000000095a9; asc ;;
2: len 7; hex 8600000feb0110; asc ;;
3: len 4; hex 8000016a; asc j;;
4: SQL NULL;
5: len 0; hex ; asc ;;
6: len 0; hex ; asc ;;
7: len 3; hex 8fbe64; asc d;;
8: SQL NULL;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: SQL NULL;
13: SQL NULL;
14: len 1; hex 80; asc ;;
15: SQL NULL;
16: SQL NULL;
17: len 30; hex 333039623965336464383538336463396661393837613433616434376365; asc 309b9e3dd8583dc9fa987a43ad47ce; (total 32 bytes);
18: len 21; hex 64616979692b656540726576696e6174652e636f6d; asc [email protected];;
19: len 10; hex 34313532363931393833; asc 4152691983;;
20: SQL NULL;
21: len 8; hex 0000000000000000; asc ;;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: len 7; hex 44616979696565; asc Daiyiee;;
27: len 6; hex 59616e676565; asc Yangee;;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: len 7; hex 556e6b6e6f776e; asc Unknown;;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: len 8; hex 800012539bb95cba; asc S \ ;;
66: SQL NULL;
67: len 8; hex 800012539bb95cba; asc S \ ;;
68: SQL NULL;
69: len 8; hex 0000000000000000; asc ;;
70: SQL NULL;
71: SQL NULL;
72: len 8; hex 0000000000000000; asc ;;
73: len 8; hex 0000000000000000; asc ;;
74: SQL NULL;
75: SQL NULL;
76: SQL NULL;
77: SQL NULL;
78: SQL NULL;
79: len 4; hex 80000001; asc ;;
*** (2) TRANSACTION:
TRANSACTION 95B8, ACTIVE 0 sec starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2
MySQL thread id 588, OS thread handle 0x7fa6202ee700, query id 5597 localhost 127.0.0.1 root Updating
UPDATE GuestStay SET updated_at = '2015-03-04 20:19:16', average_room_rate = '0', es_version = 2 WHERE id = 3434580
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 37 page no 13025 n bits 88 index `PRIMARY` of table `inguest`.`GuestStay` trx id 95B8 lock mode S locks rec but not gap
Record lock, heap no 16 PHYSICAL RECORD: n_fields 80; compact format; info bits 0
0: len 4; hex 80346854; asc 4hT;;
1: len 6; hex 0000000095a9; asc ;;
2: len 7; hex 8600000feb0110; asc ;;
3: len 4; hex 8000016a; asc j;;
4: SQL NULL;
5: len 0; hex ; asc ;;
6: len 0; hex ; asc ;;
7: len 3; hex 8fbe64; asc d;;
8: SQL NULL;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: SQL NULL;
13: SQL NULL;
14: len 1; hex 80; asc ;;
15: SQL NULL;
16: SQL NULL;
17: len 30; hex 333039623965336464383538336463396661393837613433616434376365; asc 309b9e3dd8583dc9fa987a43ad47ce; (total 32 bytes);
18: len 21; hex 64616979692b656540726576696e6174652e636f6d; asc [email protected];;
19: len 10; hex 34313532363931393833; asc 4152691983;;
20: SQL NULL;
21: len 8; hex 0000000000000000; asc ;;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: len 7; hex 44616979696565; asc Daiyiee;;
27: len 6; hex 59616e676565; asc Yangee;;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: len 7; hex 556e6b6e6f776e; asc Unknown;;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: len 8; hex 800012539bb95cba; asc S \ ;;
66: SQL NULL;
67: len 8; hex 800012539bb95cba; asc S \ ;;
68: SQL NULL;
69: len 8; hex 0000000000000000; asc ;;
70: SQL NULL;
71: SQL NULL;
72: len 8; hex 0000000000000000; asc ;;
73: len 8; hex 0000000000000000; asc ;;
74: SQL NULL;
75: SQL NULL;
76: SQL NULL;
77: SQL NULL;
78: SQL NULL;
79: len 4; hex 80000001; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 37 page no 13025 n bits 88 index `PRIMARY` of table `inguest`.`GuestStay` trx id 95B8 lock_mode X locks rec but not gap waiting
Record lock, heap no 16 PHYSICAL RECORD: n_fields 80; compact format; info bits 0
0: len 4; hex 80346854; asc 4hT;;
1: len 6; hex 0000000095a9; asc ;;
2: len 7; hex 8600000feb0110; asc ;;
3: len 4; hex 8000016a; asc j;;
4: SQL NULL;
5: len 0; hex ; asc ;;
6: len 0; hex ; asc ;;
7: len 3; hex 8fbe64; asc d;;
8: SQL NULL;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: SQL NULL;
13: SQL NULL;
14: len 1; hex 80; asc ;;
15: SQL NULL;
16: SQL NULL;
17: len 30; hex 333039623965336464383538336463396661393837613433616434376365; asc 309b9e3dd8583dc9fa987a43ad47ce; (total 32 bytes);
18: len 21; hex 64616979692b656540726576696e6174652e636f6d; asc [email protected];;
19: len 10; hex 34313532363931393833; asc 4152691983;;
20: SQL NULL;
21: len 8; hex 0000000000000000; asc ;;
22: SQL NULL;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: len 7; hex 44616979696565; asc Daiyiee;;
27: len 6; hex 59616e676565; asc Yangee;;
28: SQL NULL;
29: SQL NULL;
30: SQL NULL;
31: SQL NULL;
32: SQL NULL;
33: SQL NULL;
34: len 7; hex 556e6b6e6f776e; asc Unknown;;
35: SQL NULL;
36: SQL NULL;
37: SQL NULL;
38: SQL NULL;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: SQL NULL;
46: SQL NULL;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;
50: SQL NULL;
51: SQL NULL;
52: SQL NULL;
53: SQL NULL;
54: SQL NULL;
55: SQL NULL;
56: SQL NULL;
57: SQL NULL;
58: SQL NULL;
59: SQL NULL;
60: SQL NULL;
61: SQL NULL;
62: SQL NULL;
63: SQL NULL;
64: SQL NULL;
65: len 8; hex 800012539bb95cba; asc S \ ;;
66: SQL NULL;
67: len 8; hex 800012539bb95cba; asc S \ ;;
68: SQL NULL;
69: len 8; hex 0000000000000000; asc ;;
70: SQL NULL;
71: SQL NULL;
72: len 8; hex 0000000000000000; asc ;;
73: len 8; hex 0000000000000000; asc ;;
74: SQL NULL;
75: SQL NULL;
76: SQL NULL;
77: SQL NULL;
78: SQL NULL;
79: len 4; hex 80000001; asc ;;
*** WE ROLL BACK TRANSACTION (2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment