[Building Sakai] Deadlocks in SAM_ITEMGRADING_T
Daniel Merino
daniel.merino at unavarra.es
Tue Jan 14 03:36:28 PST 2014
Hi everybody.
After several months using Sakai 2.9.2, today we have had one single
case of deadlocks in the middle of an exam.
Not sure if it was related but yesterday we patched Samigo with SAM-2160
(1) that is applied on trunk but not backported for 2.9.x. Just in case,
we have reverted it.
Searching in JIRA I have seen that there is one JIRA (2) about Samigos's
deadlocks (not sure if it is the same case) that was applied on trunk
and reverted after some time. I would like to know if it has been more
work about this JIRA and if it is advisable to apply it.
I hope that this has been an isolated issue. But in case it is not, I
paste some deadlocks logs in the end of this mail. If somebody knows any
solution, I would be grateful to know it.
Thanks.
Best regards.
1) https://jira.sakaiproject.org/browse/SAM-2160
2) https://jira.sakaiproject.org/browse/SAM-2080
------------------------
LATEST DETECTED DEADLOCK
------------------------
140108 10:47:02
*** (1) TRANSACTION:
TRANSACTION 0 316593326, ACTIVE 0 sec, process no 29589, OS thread id
140062524274432 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1216, 2 row lock(s), undo log
entries 1
MySQL thread id 3452521, query id 3894824103 haya2.unavarra.es
130.206.159.60 sinfo Updating
update SAM_ITEMGRADING_T set ASSESSMENTGRADINGID=156060,
PUBLISHEDITEMID=225039, PUBLISHEDITEMTEXTID=245068,
AGENTID='8af302af-b3ea-4e79-839e-d32bfc8fbfd9',
SUBMITTEDDATE='2014-01-08 10:47:02', PUBLISHEDANSWERID=988817,
RATIONALE='', ANSWERTEXT='much is cost', AUTOSCORE=0.0,
OVERRIDESCORE=0.0, COMMENTS=null, GRADEDBY=null, GRADEDDATE=null,
REVIEW=null, ATTEMPTSREMAINING=null, LASTDURATION=null, ISCORRECT=0
where ITEMGRADINGID=2105562
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 511519 n bits 192 index `PRIMARY` of
table `sakaiprod`.`SAM_ITEMGRADING_T` trx id 0 316593326 lock_mode X
locks rec but not gap waiting
Record lock, heap no 94 PHYSICAL RECORD: n_fields 20; compact format;
info bits 0
0: len 8; hex 80000000002020da; asc ;; 1: len 6; hex
000012ded4a9; asc ;; 2: len 7; hex 0000274031061e; asc '@1 ;; 3:
len 8; hex 800000000002619c; asc a ;; 4: len 8; hex
8000000000036f0f; asc o ;; 5: len 8; hex 800000000003bd4c; asc
L;; 6: len 30; hex
38616633303261662d623365612d346537392d383339652d643332626663; asc
8af302af-b3ea-4e79-839e-d32bfc;...(truncated); 7: len 8; hex
800012513bfd439a; asc Q; C ;; 8: len 8; hex 80000000000f1691; asc
;; 9: len 0; hex ; asc ;; 10: len 12; hex 6d75636820697320636f7374;
asc much is cost;; 11: len 4; hex 00000000; asc ;; 12: len 4; hex
00000000; asc ;; 13: SQL NULL; 14: SQL NULL; 15: SQL NULL; 16: SQL
NULL; 17: SQL NULL; 18: SQL NULL; 19: len 1; hex 00; asc ;;
*** (2) TRANSACTION:
TRANSACTION 0 316593321, ACTIVE 0 sec, process no 29589, OS thread id
140062777091840 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
25 lock struct(s), heap size 3024, 87 row lock(s), undo log entries 86
MySQL thread id 3452550, query id 3894824136 haya2.unavarra.es
130.206.159.60 sinfo Updating
update SAM_ITEMGRADING_T set ASSESSMENTGRADINGID=156060,
PUBLISHEDITEMID=225039, PUBLISHEDITEMTEXTID=245068,
AGENTID='8af302af-b3ea-4e79-839e-d32bfc8fbfd9',
SUBMITTEDDATE='2014-01-08 10:46:02', PUBLISHEDANSWERID=988818,
RATIONALE='', ANSWERTEXT='doy you live', AUTOSCORE=0.0,
OVERRIDESCORE=0.0, COMMENTS=null, GRADEDBY=null, GRADEDDATE=null,
REVIEW=null, ATTEMPTSREMAINING=null, LASTDURATION=null, ISCORRECT=0
where ITEMGRADINGID=2105561
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 511519 n bits 192 index `PRIMARY` of
table `sakaiprod`.`SAM_ITEMGRADING_T` trx id 0 316593321 lock_mode X
locks rec but not gap
Record lock, heap no 94 PHYSICAL RECORD: n_fields 20; compact format;
info bits 0
0: len 8; hex 80000000002020da; asc ;; 1: len 6; hex
000012ded4a9; asc ;; 2: len 7; hex 0000274031061e; asc '@1 ;; 3:
len 8; hex 800000000002619c; asc a ;; 4: len 8; hex
8000000000036f0f; asc o ;; 5: len 8; hex 800000000003bd4c; asc
L;; 6: len 30; hex
38616633303261662d623365612d346537392d383339652d643332626663; asc
8af302af-b3ea-4e79-839e-d32bfc;...(truncated); 7: len 8; hex
800012513bfd439a; asc Q; C ;; 8: len 8; hex 80000000000f1691; asc
;; 9: len 0; hex ; asc ;; 10: len 12; hex 6d75636820697320636f7374;
asc much is cost;; 11: len 4; hex 00000000; asc ;; 12: len 4; hex
00000000; asc ;; 13: SQL NULL; 14: SQL NULL; 15: SQL NULL; 16: SQL
NULL; 17: SQL NULL; 18: SQL NULL; 19: len 1; hex 00; asc ;;
Record lock, heap no 97 PHYSICAL RECORD: n_fields 20; compact format;
info bits 0
0: len 8; hex 80000000002020d8; asc ;; 1: len 6; hex
000012ded4a9; asc ;; 2: len 7; hex 0000274031044e; asc '@1 N;;
3: len 8; hex 800000000002619c; asc a ;; 4: len 8; hex
8000000000036f0f; asc o ;; 5: len 8; hex 800000000003bd4c; asc
L;; 6: len 30; hex
38616633303261662d623365612d346537392d383339652d643332626663; asc
8af302af-b3ea-4e79-839e-d32bfc;...(truncated); 7: len 8; hex
800012513bfd439a; asc Q; C ;; 8: len 8; hex 80000000000f168f; asc
;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 4; hex
00000000; asc ;; 12: len 4; hex 00000000; asc ;; 13: SQL NULL; 14:
SQL NULL; 15: SQL NULL; 16: SQL NULL; 17: SQL NULL; 18: SQL NULL; 19:
len 1; hex 00; asc ;;
Record lock, heap no 98 PHYSICAL RECORD: n_fields 20; compact format;
info bits 0
0: len 8; hex 80000000002020d7; asc ;; 1: len 6; hex
000012ded4a9; asc ;; 2: len 7; hex 0000274031087f; asc '@1 ;; 3:
len 8; hex 800000000002619c; asc a ;; 4: len 8; hex
8000000000036f0f; asc o ;; 5: len 8; hex 800000000003bd4c; asc
L;; 6: len 30; hex
38616633303261662d623365612d346537392d383339652d643332626663; asc
8af302af-b3ea-4e79-839e-d32bfc;...(truncated); 7: len 8; hex
800012513bfd439a; asc Q; C ;; 8: len 8; hex 80000000000f1690; asc
;; 9: len 0; hex ; asc ;; 10: len 20; hex
697320796f75722070686f6e65206e756d626572; asc is your phone number;; 11:
len 4; hex cdcccc3e; asc >;; 12: len 4; hex 00000000; asc ;; 13:
SQL NULL; 14: SQL NULL; 15: SQL NULL; 16: SQL NULL; 17: SQL NULL; 18:
SQL NULL; 19: len 1; hex 01; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 511519 n bits 192 index `PRIMARY` of
table `sakaiprod`.`SAM_ITEMGRADING_T` trx id 0 316593321 lock_mode X
locks rec but not gap waiting
Record lock, heap no 95 PHYSICAL RECORD: n_fields 20; compact format;
info bits 0
0: len 8; hex 80000000002020d9; asc ;; 1: len 6; hex
000012ded4ae; asc ;; 2: len 7; hex 00002740320110; asc '@2 ;; 3:
len 8; hex 800000000002619c; asc a ;; 4: len 8; hex
8000000000036f0f; asc o ;; 5: len 8; hex 800000000003bd4c; asc
L;; 6: len 30; hex
38616633303261662d623365612d346537392d383339652d643332626663; asc
8af302af-b3ea-4e79-839e-d32bfc;...(truncated); 7: len 8; hex
800012513bfd43fe; asc Q; C ;; 8: len 8; hex 80000000000f1692; asc
;; 9: len 0; hex ; asc ;; 10: len 9; hex 5061756c206c697665; asc
Paul live;; 11: len 4; hex 00000000; asc ;; 12: len 4; hex 00000000;
asc ;; 13: SQL NULL; 14: SQL NULL; 15: SQL NULL; 16: SQL NULL; 17:
SQL NULL; 18: SQL NULL; 19: len 1; hex 00; asc ;;
*** WE ROLL BACK TRANSACTION (1)
--
Daniel Merino Echeverría
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.
More information about the sakai-dev
mailing list