[samigo-team] [Building Sakai] Deadlocks in SAM_ITEMGRADING_T
Daniel Merino
daniel.merino at unavarra.es
Tue Jan 14 05:10:09 PST 2014
Hi, Stephen.
The main issue has been that while these deadlocks were happening, the
full server was suffering a big slowness for everybody else. Do you
think this is not usual?
Thanks.
Best regards.
El 14/01/14 13:22, Stephen Marquard escribió:
> 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.
>
>
--
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.
--
Es una increible estafa creer algo ahora a cambio de algo despues de la
muerte. Ni siquiera las grandes empresas intentan que sus bonificaciones
por objetivos sean postumas. (Gloria Steinem)
More information about the samigo-team
mailing list