[Building Sakai] Deadlocks in SAM_ITEMGRADING_T
Stephen Marquard
stephen.marquard at uct.ac.za
Tue Jan 14 04:22:07 PST 2014
Hi Daniel,
Did you see incorrect behaviour as a result of this? e.g. lost data. The code as-is seems to retry if there's a deadlock exception.
The changes in SAM-2080 are best described as "experimental" - I believe we had them in production briefly at UCT and reverted them because they may have caused other problems.
Regards
Stephen
________________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Daniel Merino [daniel.merino at unavarra.es]
Sent: 14 January 2014 01:36 PM
To: sakai-dev; samigo-team at collab.sakaiproject.org
Subject: [Building Sakai] Deadlocks in SAM_ITEMGRADING_T
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.
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
________________________________
UNIVERSITY OF CAPE TOWN
This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
More information about the sakai-dev
mailing list