MySQL Forums
Forum List  »  InnoDB

Strange deadlock problem - deadlock in same trnsaction
Posted by: Peter Chang
Date: October 13, 2011 11:06AM

I've experienced deadlock after updating the code. I checked the innodb status and noticed transaction 2 is waiting for the same lock which it already had. Why is that? The update sql in txn 2 is using the primay key. The other point is why txn 1 is terminated instead? It is just waiting for S-lock and it is not holding any lock itslef. It looks to me txn 2 is deadlocked with itself and has nothing to do with txn 1.

This is innodb status:

TRANSACTION 0 273782284, ACTIVE 18 sec, process no 3333, OS thread id 1101826368 starting index read
mysql tables in use 3, locked 3
LOCK WAIT 53 lock struct(s), heap size 14320
MySQL thread id 11662, query id 137990824 localhost 127.0.0.1 hrs Sending data
create table prog_1318503580550 select r.id, r.duration, r.type, s.pay_weekend, r.website_grp_id, r.date, convert_tz(r.date, '+0:0', '+8:0') as kl_date from ratingrecord r, websitegroup w, urlsource s where r.website_grp_id = w.id and w.source_id = s.id and r.user_id=536870920 and ((r.date>= '2011-10-12 16:00:00' and r.date <'2011-10-13 16:00:00'))
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 105 page no 79829 n bits 248 index `PRIMARY` of table `hrs/websitegroup` trx id 0 273782284 lock mode S locks rec but not gap waiting
Record lock, heap no 68 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4597; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d322f; asc -2/;; 3: len 1; hex 00; asc ;; 4: len 17; hex 6d796d696e69737472796170702e636f6d; asc myministryapp.com;; 5: len 13; hex 6d796d696e6973747279617070; asc myministryapp;; 6: len 3; hex 636f6d; asc com;; 7: len 4; hex 4e972700; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d1a; asc 0 = ;; 16: len 4; hex 4e70ecfa; asc Np ;; 17: len 1; hex 01; asc ;;

*** (2) TRANSACTION:
TRANSACTION 0 273780557, ACTIVE 117 sec, process no 3333, OS thread id 1102092608 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1216, undo log entries 26
MySQL thread id 18336, query id 138053895 localhost 127.0.0.1 hrs Updating
update websitegroup set date='2011-10-13 10:59:58', created_date='2011-09-14 11:05:44', type=0, state=4, site_key='ideayouthforum.org', dom='ideayouthforum', tld='org', qa=0, updated_master=1, cache_proc=3, source_id=6, license_type=2, lang_id=10, location_id=3, rating_rec_id=816921876 where id=17646987
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 105 page no 79829 n bits 248 index `PRIMARY` of table `hrs/websitegroup` trx id 0 273780557 lock_mode X locks rec but not gap
Record lock, heap no 61 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4582; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2ec3; asc -. ;; 3: len 1; hex 00; asc ;; 4: len 17; hex 6d6565737465726d6174686965752e6265; asc meestermathieu.be;; 5: len 14; hex 6d6565737465726d617468696575; asc meestermathieu;; 6: len 2; hex 6265; asc be;; 7: len 4; hex 4e9726d4; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d41; asc 0 =A;; 16: len 4; hex 4e70ecf7; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 62 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4585; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d30ce; asc -0 ;; 3: len 1; hex 00; asc ;; 4: len 20; hex 6c616d6172636f6d6d756e6963617469652e6e6c; asc lamarcommunicatie.nl;; 5: len 17; hex 6c616d6172636f6d6d756e696361746965; asc lamarcommunicatie;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726ef; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d32; asc 0 =2;; 16: len 4; hex 4e70ecf7; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 63 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4588; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d32db; asc -2 ;; 3: len 1; hex 00; asc ;; 4: len 18; hex 6b696e642d656e2d766f6564696e672e6e6c; asc kind-en-voeding.nl;; 5: len 15; hex 6b696e642d656e2d766f6564696e67; asc kind-en-voeding;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e972709; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d35; asc 0 =5;; 16: len 4; hex 4e70ecf8; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 65 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d458e; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2bf0; asc -+ ;; 3: len 1; hex 00; asc ;; 4: len 17; hex 696e76656e742d73797374656d732e6e6c; asc invent-systems.nl;; 5: len 14; hex 696e76656e742d73797374656d73; asc invent-systems;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726b2; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d38; asc 0 =8;; 16: len 4; hex 4e70ecf9; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 66 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4591; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2e15; asc -. ;; 3: len 1; hex 00; asc ;; 4: len 20; hex 6f6e6c696e65706f6b65727370656c656e2e6265; asc onlinepokerspelen.be;; 5: len 17; hex 6f6e6c696e65706f6b65727370656c656e; asc onlinepokerspelen;; 6: len 2; hex 6265; asc be;; 7: len 4; hex 4e9726cb; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d1d; asc 0 = ;; 16: len 4; hex 4e70ecf9; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 67 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4594; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3022; asc -0";; 3: len 1; hex 00; asc ;; 4: len 16; hex 6c69616d6b656c6c797765622e636f6d; asc liamkellyweb.com;; 5: len 12; hex 6c69616d6b656c6c79776562; asc liamkellyweb;; 6: len 3; hex 636f6d; asc com;; 7: len 4; hex 4e9726e5; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d23; asc 0 =#;; 16: len 4; hex 4e70ecfa; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 68 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d4597; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d322f; asc -2/;; 3: len 1; hex 00; asc ;; 4: len 17; hex 6d796d696e69737472796170702e636f6d; asc myministryapp.com;; 5: len 13; hex 6d796d696e6973747279617070; asc myministryapp;; 6: len 3; hex 636f6d; asc com;; 7: len 4; hex 4e972700; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d1a; asc 0 = ;; 16: len 4; hex 4e70ecfa; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 74 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45a9; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3441; asc -4A;; 3: len 1; hex 00; asc ;; 4: len 19; hex 676f677265656e626f6f7463616d702e636f6d; asc gogreenbootcamp.com;; 5: len 15; hex 676f677265656e626f6f7463616d70; asc gogreenbootcamp;; 6: len 3; hex 636f6d; asc com;; 7: len 4; hex 4e97271a; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d26; asc 0 =&;; 16: len 4; hex 4e70ecfd; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 79 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45b8; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2b9a; asc -+ ;; 3: len 1; hex 00; asc ;; 4: len 15; hex 696e74657270726f746563742e6e6c; asc interprotect.nl;; 5: len 12; hex 696e74657270726f74656374; asc interprotect;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726ad; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d3b; asc 0 =;;; 16: len 4; hex 4e70ed00; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 80 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45bb; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2d5d; asc --];; 3: len 1; hex 00; asc ;; 4: len 21; hex 696b77696c65656e7363686f6f6e687569732e6e6c; asc ikwileenschoonhuis.nl;; 5: len 18; hex 696b77696c65656e7363686f6f6e68756973; asc ikwileenschoonhuis;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726c3; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d2c; asc 0 =,;; 16: len 4; hex 4e70ed00; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 81 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45be; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2f72; asc -/r;; 3: len 1; hex 00; asc ;; 4: len 22; hex 6b756e73747370657572656e696e64657a616b2e6e6c; asc kunstspeurenindezak.nl;; 5: len 19; hex 6b756e73747370657572656e696e64657a616b; asc kunstspeurenindezak;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726dd; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d44; asc 0 =D;; 16: len 4; hex 4e70ed01; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 82 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45c1; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3180; asc -1 ;; 3: len 1; hex 00; asc ;; 4: len 21; hex 6472756b6b6572696a76616e6b65756c656e2e6e6c; asc drukkerijvankeulen.nl;; 5: len 18; hex 6472756b6b6572696a76616e6b65756c656e; asc drukkerijvankeulen;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726f7; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d3e; asc 0 =>;; 16: len 4; hex 4e70ed01; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 83 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45c4; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d33e2; asc -3 ;; 3: len 1; hex 00; asc ;; 4: len 24; hex 6b756e6766757363686f6f6c616d7374657264616d2e6e6c; asc kungfuschoolamsterdam.nl;; 5: len 21; hex 6b756e6766757363686f6f6c616d7374657264616d; asc kungfuschoolamsterdam;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e972716; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d89; asc 0 = ;; 16: len 4; hex 4e70ed02; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 87 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45d0; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2d00; asc -- ;; 3: len 1; hex 00; asc ;; 4: len 22; hex 6275696a7a657665727a656b6572696e67656e2e6e6c; asc buijzeverzekeringen.nl;; 5: len 19; hex 6275696a7a657665727a656b6572696e67656e; asc buijzeverzekeringen;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726bf; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d71; asc 0 =q;; 16: len 4; hex 4e70ed04; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 88 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45d3; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2f1b; asc -/ ;; 3: len 1; hex 00; asc ;; 4: len 16; hex 76616e626f7572676f6e6469652e6575; asc vanbourgondie.eu;; 5: len 13; hex 76616e626f7572676f6e646965; asc vanbourgondie;; 6: len 2; hex 6575; asc eu;; 7: len 4; hex 4e9726d8; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d8c; asc 0 = ;; 16: len 4; hex 4e70ed05; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 89 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45d6; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3129; asc -1);; 3: len 1; hex 00; asc ;; 4: len 16; hex 776572656c64696e6265656c642e6265; asc wereldinbeeld.be;; 5: len 13; hex 776572656c64696e6265656c64; asc wereldinbeeld;; 6: len 2; hex 6265; asc be;; 7: len 4; hex 4e9726f3; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d8f; asc 0 = ;; 16: len 4; hex 4e70ed05; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 93 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45e2; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3334; asc -34;; 3: len 1; hex 00; asc ;; 4: len 16; hex 737461636b696e67636173682e636f6d; asc stackingcash.com;; 5: len 12; hex 737461636b696e6763617368; asc stackingcash;; 6: len 3; hex 636f6d; asc com;; 7: len 4; hex 4e97270d; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d77; asc 0 =w;; 16: len 4; hex 4e70ed07; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 97 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45ee; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2c48; asc -,H;; 3: len 1; hex 00; asc ;; 4: len 16; hex 62656e6574746f6e7a656973742e6e6c; asc benettonzeist.nl;; 5: len 13; hex 62656e6574746f6e7a65697374; asc benettonzeist;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726b6; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d95; asc 0 = ;; 16: len 4; hex 4e70ed09; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 99 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45f4; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3079; asc -0y;; 3: len 1; hex 00; asc ;; 4: len 14; hex 706c6173746963736f65702e6e6c; asc plasticsoep.nl;; 5: len 11; hex 706c6173746963736f6570; asc plasticsoep;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726e9; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d92; asc 0 = ;; 16: len 4; hex 4e70ed0a; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 178 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45f7; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d3287; asc -2 ;; 3: len 1; hex 00; asc ;; 4: len 13; hex 6f73647369676e61616c2e6e6c; asc osdsignaal.nl;; 5: len 10; hex 6f73647369676e61616c; asc osdsignaal;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e972704; asc N ' ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d9e; asc 0 = ;; 16: len 4; hex 4e70ed0b; asc Np ;; 17: len 1; hex 01; asc ;;

Record lock, heap no 179 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d45f1; asc E ;; 1: len 6; hex 000010518f4d; asc Q M;; 2: len 7; hex 000000002d2e70; asc -.p;; 3: len 1; hex 00; asc ;; 4: len 12; hex 73616e746f756368612e6e6c; asc santoucha.nl;; 5: len 9; hex 73616e746f75636861; asc santoucha;; 6: len 2; hex 6e6c; asc nl;; 7: len 4; hex 4e9726d0; asc N & ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 00000009; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13da1; asc 0 = ;; 16: len 4; hex 4e70ed0a; asc Np ;; 17: len 1; hex 01; asc ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 105 page no 79829 n bits 248 index `PRIMARY` of table `hrs/websitegroup` trx id 0 273780557 lock_mode X locks rec but not gap waiting
Record lock, heap no 64 PHYSICAL RECORD: n_fields 18; compact format; info bits 0
0: len 4; hex 010d458b; asc E ;; 1: len 6; hex 000010518120; asc Q ;; 2: len 7; hex 000000002d3537; asc -57;; 3: len 1; hex 00; asc ;; 4: len 18; hex 69646561796f757468666f72756d2e6f7267; asc ideayouthforum.org;; 5: len 14; hex 69646561796f757468666f72756d; asc ideayouthforum;; 6: len 3; hex 6f7267; asc org;; 7: len 4; hex 4e9725de; asc N % ;; 8: len 1; hex 04; asc ;; 9: len 4; hex 00000006; asc ;; 10: len 4; hex 00000003; asc ;; 11: len 4; hex 0000000a; asc ;; 12: len 4; hex 00000002; asc ;; 13: len 1; hex 03; asc ;; 14: len 1; hex 00; asc ;; 15: len 4; hex 30b13d14; asc 0 = ;; 16: len 4; hex 4e70ecf8; asc Np ;; 17: len 1; hex 00; asc ;;

*** WE ROLL BACK TRANSACTION (1)



Edited 3 time(s). Last edit at 10/13/2011 10:17AM by Peter Chang.

Options: ReplyQuote


Subject
Views
Written By
Posted
Strange deadlock problem - deadlock in same trnsaction
1900
October 13, 2011 11:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.