Relates to WebDSL issue 572

Some researchr specific data from mysql error log, which might help in debugging:

LATEST FOREIGN KEY ERROR
------------------------
120715 13:18:32 Error in foreign key constraint of table researchr/#sql-5b0d_28552:
 foreign key (Usergroup_messagesend) references _Access (id):
Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
for correct foreign key definition.
------------------------
LATEST DETECTED DEADLOCK
------------------------
120715  3:03:50
*** (1) TRANSACTION:
TRANSACTION 0 507260733, ACTIVE 13 sec, process no 23309, OS thread id 140111119369984 updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 96 lock struct(s), heap size 14320, 82 row lock(s), undo log entries 106
MySQL thread id 162487, query id 1322639021 localhost 127.0.0.1 researchr Updating
update _Publication set `_abstract`='', Publication_aliasOf=null, `_annote`='', Publication_backwardEntries='da4ace4fde35434295b4de5646812b7f', `_bibtexTitle`='Model-Based Esophagus Segmentation from CT Scans Usin
g a Spatial Probability Map', `_conflicts`=0, `_conversionErrorFixed`=0, `_created`='2012-07-15 03:03:46', `_dblpKey`='conf/miccai/FeulnerZHCHC10', `_dblpURL`='db/conf/miccai/miccai2010-1.html#FeulnerZHCHC10', `_d
elete`=0, `_doi`='http://dx.doi.org/10.1007/978-3-642-15705-9_12', `_ee`='http://dx.doi.org/10.1007/978-3-642-15705-9_12', Publication_forwardEntries='3fced4c508cf4371999710ce7fdb01f9', `_hasAbstract`=1, `_isbn`='
', `_issn`='', `_key`='FeulnerZHCHC10', `_locked`=0, `_markedAsDuplicateOn`=null, `_mergedWithAlias`=0, `_modified`='2012-07-15 03:03:47', `_month`='', `_nonselfviews`=0, `_note`='', Publication_poster=null, Publi
cation_preprint=null, `_references`='', `_referencesTo`='', `_refsMigrated`=1, Publicati
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 16752 page no 165749 n bits 88 index `PRIMARY` of table `researchr`.`_Publication` trx id 0 507260733 lock mode S locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 78; compact format; info bits 0
 0: len 30; hex 396635653134336539363461343862653839626431653839663339383731; asc 9f5e143e964a48be89bd1e89f39871;...(truncated); 1: len 6; hex 00001e3c2f50; asc    </P;; 2: len 7; hex 000003802b1249; asc     + I;;
 3: len 11; hex 50726f63656564696e6773; asc Proceedings;; 4: len 0; hex ; asc ;; 5: len 0; hex ; asc ;; 6: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and
Co;...(truncated); 7: len 1; hex 00; asc  ;; 8: len 8; hex 800012482df89e9d; asc    H-   ;; 9: len 18; hex 636f6e662f6d69636361692f323031302d31; asc conf/miccai/2010-1;; 10: len 30; hex 64622f636f6e662f6d696363616
92f6d6963636169323031302d312e6874; asc db/conf/miccai/miccai2010-1.ht;...(truncated); 11: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated)
; 12: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated); 13: len 17; hex 3937382d332d3634322d31353730342d32; asc 978-3-642-15704-2;; 14: le
n 0; hex ; asc ;; 15: len 13; hex 6d69636361692d323031302d31; asc miccai-2010-1;; 16: len 1; hex 00; asc  ;; 17: len 8; hex 800012482df89e9d; asc    H-   ;; 18: len 0; hex ; asc ;; 19: len 4; hex 80000000; asc
 ;; 20: SQL NULL; 21: len 0; hex ; asc ;; 22: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and Co;...(truncated); 23: len 4; hex 8000005c; asc    \;; 24: le
n 4; hex 80000000; asc     ;; 25: len 4; hex 32303130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 8; hex 537072696e676572; asc Springer;; 30: len 30; hex 4c656374757265204e6f74657320696e20436f6d70757465722053636965; asc Lecture Notes in Computer Scie;...(truncated); 31: len 4; hex 36333631; asc 6361;; 32: len 4; hex 80000000; asc     ;; 33: len 6; hex 6d6963636169; asc miccai;; 34: len 4; hex 80000000; asc     ;; 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: len 30; hex 653331636632653466396261343365646232636365336536353964313838; asc e31cf2e4f9ba43edb2cce3e659d188;...(truncated); 56: len 30; hex 393131356335613037343933346430353933633265353165643966656461; asc 9115c5a074934d0593c2e51ed9feda;...(truncated); 57: len 30; hex 333131306334363637323738343033633963646538316337386365383231; asc 3110c4667278403c9cde81c78ce821;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 00; asc  ;; 67: len 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc  ;; 75: len 30; hex 663539633865373664313832346533656165366264383964626530303936; asc f59c8e76d1824e3eae6bd89dbe0096;...(truncated); 76: len 30; hex 333461636634363035303533343038626164626335353664643966353231; asc 34acf4605053408badbc556dd9f521;...(truncated); 77: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 0 507260752, ACTIVE 10 sec, process no 23309, OS thread id 140111115376384 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
120 lock struct(s), heap size 14320, 105 row lock(s), undo log entries 142
MySQL thread id 161826, query id 1322639552 localhost 127.0.0.1 researchr Updating
update _Publication set `_abstract`='', Publication_aliasOf=null, `_annote`='', Publication_backwardEntries='9cd655efdf7d45fab5b3ae3914cdd82e', `_bibtexTitle`='Registration-based propagation for whole heart segmentation from compounded 3D echocardiography', `_conflicts`=0, `_conversionErrorFixed`=0, `_created`='2012-07-15 03:03:48', `_dblpKey`='conf/isbi/ZhuangYMHPO10', `_dblpURL`='db/conf/isbi/isbi2010.html#ZhuangYMHPO10', `_delete`=0, `_doi`='http://dx.doi.org/10.1109/ISBI.2010.5490183', `_ee`='http://dx.doi.org/10.1109/ISBI.2010.5490183', Publication_forwardEntries='4ecac8336a774b59a23d198454fe2f76', `_hasAbstract`=1, `_isbn`='', `_issn`='', `_key`='ZhuangYMHPO10', `_locked`=0, `_markedAsDuplicateOn`=null, `_mergedWithAlias`=0, `_modified`='2012-07-15 03:03:50', `_month`='', `_nonselfviews`=0, `_note`='', Publication_poster=null, Publication_preprint=null, `_references`='', `_referencesTo`='', `_refsMigrated`=1, Publication
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 16752 page no 165749 n bits 88 index `PRIMARY` of table `researchr`.`_Publication` trx id 0 507260752 lock_mode X locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 78; compact format; info bits 0
 0: len 30; hex 396635653134336539363461343862653839626431653839663339383731; asc 9f5e143e964a48be89bd1e89f39871;...(truncated); 1: len 6; hex 00001e3c2f50; asc    </P;; 2: len 7; hex 000003802b1249; asc     + I;; 3: len 11; hex 50726f63656564696e6773; asc Proceedings;; 4: len 0; hex ; asc ;; 5: len 0; hex ; asc ;; 6: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and Co;...(truncated); 7: len 1; hex 00; asc  ;; 8: len 8; hex 800012482df89e9d; asc    H-   ;; 9: len 18; hex 636f6e662f6d69636361692f323031302d31; asc conf/miccai/2010-1;; 10: len 30; hex 64622f636f6e662f6d69636361692f6d6963636169323031302d312e6874; asc db/conf/miccai/miccai2010-1.ht;...(truncated); 11: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated); 12: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated); 13: len 17; hex 3937382d332d3634322d31353730342d32; asc 978-3-642-15704-2;; 14: len 0; hex ; asc ;; 15: len 13; hex 6d69636361692d323031302d31; asc miccai-2010-1;; 16: len 1; hex 00; asc  ;; 17: len 8; hex 800012482df89e9d; asc    H-   ;; 18: len 0; hex ; asc ;; 19: len 4; hex 80000000; asc     ;; 20: SQL NULL; 21: len 0; hex ; asc ;; 22: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and Co;...(truncated); 23: len 4; hex 8000005c; asc    \;; 24: len 4; hex 80000000; asc     ;; 25: len 4; hex 32303130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 8; hex 537072696e676572; asc Springer;; 30: len 30; hex 4c656374757265204e6f74657320696e20436f6d70757465722053636965; asc Lecture Notes in Computer Scie;...(truncated); 31: len 4; hex 36333631; asc 6361;; 32: len 4; hex 80000000; asc     ;; 33: len 6; hex 6d6963636169; asc miccai;; 34: len 4; hex 80000000; asc     ;; 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: len 30; hex 653331636632653466396261343365646232636365336536353964313838; asc e31cf2e4f9ba43edb2cce3e659d188;...(truncated); 56: len 30; hex 393131356335613037343933346430353933633265353165643966656461; asc 9115c5a074934d0593c2e51ed9feda;...(truncated); 57: len 30; hex 333131306334363637323738343033633963646538316337386365383231; asc 3110c4667278403c9cde81c78ce821;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 00; asc  ;; 67: len 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc  ;; 75: len 30; hex 663539633865373664313832346533656165366264383964626530303936; asc f59c8e76d1824e3eae6bd89dbe0096;...(truncated); 76: len 30; hex 333461636634363035303533343038626164626335353664643966353231; asc 34acf4605053408badbc556dd9f521;...(truncated); 77: SQL NULL;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 16752 page no 394139 n bits 80 index `PRIMARY` of table `researchr`.`_Publication` trx id 0 507260752 lock mode S locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 78; compact format; info bits 0
 0: len 30; hex 396339633065363861393230346265616130623964326561346461383633; asc 9c9c0e68a9204beaa0b9d2ea4da863;...(truncated); 1: len 6; hex 00001e3c2f3d; asc    </=;; 2: len 7; hex 00000380291214; asc     )  ;; 3: len 11; hex 50726f63656564696e6773; asc Proceedings;; 4: len 0; hex ; asc ;; 5: len 0; hex ; asc ;; 6: len 30; hex 50726f63656564696e6773206f6620746865203230313020494545452049; asc Proceedings of the 2010 IEEE I;...(truncated); 7: len 1; hex 00; asc  ;; 8: len 8; hex 8000124a70407f8a; asc    Jp@  ;; 9: len 14; hex 636f6e662f697362692f32303130; asc conf/isbi/2010;; 10: len 26; hex 64622f636f6e662f697362692f69736269323031302e68746d6c; asc db/conf/isbi/isbi2010.html;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 17; hex 3937382d312d343234342d343132352d39; asc 978-1-4244-4125-9;; 14: len 0; hex ; asc ;; 15: len 9; hex 697362692d32303130; asc isbi-2010;; 16: len 1; hex 00; asc  ;; 17: len 8; hex 8000124a70407f8a; asc    Jp@  ;; 18: len 0; hex ; asc ;; 19: len 4; hex 80000000; asc     ;; 20: SQL NULL; 21: len 0; hex ; asc ;; 22: len 30; hex 50726f63656564696e6773206f6620746865203230313020494545452049; asc Proceedings of the 2010 IEEE I;...(truncated); 23: len 4; hex 80000147; asc    G;; 24: len 4; hex 80000000; asc     ;; 25: len 4; hex 32303130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 4; hex 49454545; asc IEEE;; 30: len 0; hex ; asc ;; 31: len 0; hex ; asc ;; 32: len 4; hex 80000000; asc     ;; 33: len 4; hex 69736269; asc isbi;; 34: len 4; hex 80000000; asc     ;; 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: len 30; hex 333264623465636165383532346165313862346533346538343533643032; asc 32db4ecae8524ae18b4e34e8453d02;...(truncated); 56: len 30; hex 393965323734663935313764346330316163303630616431323666333439; asc 99e274f9517d4c01ac060ad126f349;...(truncated); 57: len 30; hex 376435333339316363346535343366646161366433396163363139326638; asc 7d53391cc4e543fdaa6d39ac6192f8;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 00; asc  ;; 67: len 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc  ;; 75: len 30; hex 343535666138313666333738343962393966623734613934633737653865; asc 455fa816f37849b99fb74a94c77e8e;...(truncated); 76: len 30; hex 633838646133633933613736343838336265316530393730323062313764; asc c88da3c93a764883be1e097020b17d;...(truncated); 77: SQL NULL;

*** WE ROLL BACK TRANSACTION (1)
n 4; hex 80000000; asc     ;; 25: len 4; hex 32303130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 8; hex 537072696e676572; asc Springer;; 30: len 30; hex 4c656374757
265204e6f74657320696e20436f6d70757465722053636965; asc Lecture Notes in Computer Scie;...(truncated); 31: len 4; hex 36333631; asc 6361;; 32: len 4; hex 80000000; asc     ;; 33: len 6; hex 6d6963636169; asc miccai
;; 34: len 4; hex 80000000; asc     ;; 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: SQ
L NULL; 48: SQL NULL; 49: SQL NULL; 50: SQL NULL; 51: SQL NULL; 52: SQL NULL; 53: SQL NULL; 54: SQL NULL; 55: len 30; hex 653331636632653466396261343365646232636365336536353964313838; asc e31cf2e4f9ba43edb2cce3e65
9d188;...(truncated); 56: len 30; hex 393131356335613037343933346430353933633265353165643966656461; asc 9115c5a074934d0593c2e51ed9feda;...(truncated); 57: len 30; hex 3331313063343636373237383430336339636465383163
37386365383231; asc 3110c4667278403c9cde81c78ce821;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 00; asc  ;; 67: len
 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc  ;; 75: len 30; hex 6635396338
65373664313832346533656165366264383964626530303936; asc f59c8e76d1824e3eae6bd89dbe0096;...(truncated); 76: len 30; hex 333461636634363035303533343038626164626335353664643966353231; asc 34acf4605053408badbc556dd9f5
21;...(truncated); 77: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 0 507260752, ACTIVE 10 sec, process no 23309, OS thread id 140111115376384 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
120 lock struct(s), heap size 14320, 105 row lock(s), undo log entries 142
MySQL thread id 161826, query id 1322639552 localhost 127.0.0.1 researchr Updating
update _Publication set `_abstract`='', Publication_aliasOf=null, `_annote`='', Publication_backwardEntries='9cd655efdf7d45fab5b3ae3914cdd82e', `_bibtexTitle`='Registration-based propagation for whole heart segmen
tation from compounded 3D echocardiography', `_conflicts`=0, `_conversionErrorFixed`=0, `_created`='2012-07-15 03:03:48', `_dblpKey`='conf/isbi/ZhuangYMHPO10', `_dblpURL`='db/conf/isbi/isbi2010.html#ZhuangYMHPO10'
, `_delete`=0, `_doi`='http://dx.doi.org/10.1109/ISBI.2010.5490183', `_ee`='http://dx.doi.org/10.1109/ISBI.2010.5490183', Publication_forwardEntries='4ecac8336a774b59a23d198454fe2f76', `_hasAbstract`=1, `_isbn`=''
, `_issn`='', `_key`='ZhuangYMHPO10', `_locked`=0, `_markedAsDuplicateOn`=null, `_mergedWithAlias`=0, `_modified`='2012-07-15 03:03:50', `_month`='', `_nonselfviews`=0, `_note`='', Publication_poster=null, Publica
tion_preprint=null, `_references`='', `_referencesTo`='', `_refsMigrated`=1, Publication
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 16752 page no 165749 n bits 88 index `PRIMARY` of table `researchr`.`_Publication` trx id 0 507260752 lock_mode X locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 78; compact format; info bits 0
 0: len 30; hex 396635653134336539363461343862653839626431653839663339383731; asc 9f5e143e964a48be89bd1e89f39871;...(truncated); 1: len 6; hex 00001e3c2f50; asc    </P;; 2: len 7; hex 000003802b1249; asc     + I;;
 3: len 11; hex 50726f63656564696e6773; asc Proceedings;; 4: len 0; hex ; asc ;; 5: len 0; hex ; asc ;; 6: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and
Co;...(truncated); 7: len 1; hex 00; asc  ;; 8: len 8; hex 800012482df89e9d; asc    H-   ;; 9: len 18; hex 636f6e662f6d69636361692f323031302d31; asc conf/miccai/2010-1;; 10: len 30; hex 64622f636f6e662f6d696363616
92f6d6963636169323031302d312e6874; asc db/conf/miccai/miccai2010-1.ht;...(truncated); 11: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated)
; 12: len 30; hex 687474703a2f2f64782e646f692e6f72672f31302e313030372f3937382d; asc http://dx.doi.org/10.1007/978-;...(truncated); 13: len 17; hex 3937382d332d3634322d31353730342d32; asc 978-3-642-15704-2;; 14: le
n 0; hex ; asc ;; 15: len 13; hex 6d69636361692d323031302d31; asc miccai-2010-1;; 16: len 1; hex 00; asc  ;; 17: len 8; hex 800012482df89e9d; asc    H-   ;; 18: len 0; hex ; asc ;; 19: len 4; hex 80000000; asc
 ;; 20: SQL NULL; 21: len 0; hex ; asc ;; 22: len 30; hex 4d65646963616c20496d61676520436f6d707574696e6720616e6420436f; asc Medical Image Computing and Co;...(truncated); 23: len 4; hex 8000005c; asc    \;; 24: le
n 4; hex 80000000; asc     ;; 25: len 4; hex 32303130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 8; hex 537072696e676572; asc Springer;; 30: len 30; hex 4c656374757
265204e6f74657320696e20436f6d70757465722053636965; asc Lecture Notes in Computer Scie;...(truncated); 31: len 4; hex 36333631; asc 6361;; 32: len 4; hex 80000000; asc     ;; 33: len 6; hex 6d6963636169; asc miccai
;; 34: len 4; hex 80000000; asc     ;; 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: SQ
L NULL; 48: SQL NULL; 49: SQL NULL; 50: SQL NULL; 51: SQL NULL; 52: SQL NULL; 53: SQL NULL; 54: SQL NULL; 55: len 30; hex 653331636632653466396261343365646232636365336536353964313838; asc e31cf2e4f9ba43edb2cce3e65
9d188;...(truncated); 56: len 30; hex 393131356335613037343933346430353933633265353165643966656461; asc 9115c5a074934d0593c2e51ed9feda;...(truncated); 57: len 30; hex 3331313063343636373237383430336339636465383163
37386365383231; asc 3110c4667278403c9cde81c78ce821;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 00; asc  ;; 67: len
 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc  ;; 75: len 30; hex 6635396338
65373664313832346533656165366264383964626530303936; asc f59c8e76d1824e3eae6bd89dbe0096;...(truncated); 76: len 30; hex 333461636634363035303533343038626164626335353664643966353231; asc 34acf4605053408badbc556dd9f5
21;...(truncated); 77: SQL NULL;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 16752 page no 394139 n bits 80 index `PRIMARY` of table `researchr`.`_Publication` trx id 0 507260752 lock mode S locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 78; compact format; info bits 0
 0: len 30; hex 396339633065363861393230346265616130623964326561346461383633; asc 9c9c0e68a9204beaa0b9d2ea4da863;...(truncated); 1: len 6; hex 00001e3c2f3d; asc    </=;; 2: len 7; hex 00000380291214; asc     )  ;;
 3: len 11; hex 50726f63656564696e6773; asc Proceedings;; 4: len 0; hex ; asc ;; 5: len 0; hex ; asc ;; 6: len 30; hex 50726f63656564696e6773206f6620746865203230313020494545452049; asc Proceedings of the 2010 IEEE
 I;...(truncated); 7: len 1; hex 00; asc  ;; 8: len 8; hex 8000124a70407f8a; asc    Jp@  ;; 9: len 14; hex 636f6e662f697362692f32303130; asc conf/isbi/2010;; 10: len 26; hex 64622f636f6e662f697362692f6973626932303
1302e68746d6c; asc db/conf/isbi/isbi2010.html;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 17; hex 3937382d312d343234342d343132352d39; asc 978-1-4244-4125-9;; 14: len 0; hex ; asc ;; 15: len 9; hex 69
7362692d32303130; asc isbi-2010;; 16: len 1; hex 00; asc  ;; 17: len 8; hex 8000124a70407f8a; asc    Jp@  ;; 18: len 0; hex ; asc ;; 19: len 4; hex 80000000; asc     ;; 20: SQL NULL; 21: len 0; hex ; asc ;; 22: le
n 30; hex 50726f63656564696e6773206f6620746865203230313020494545452049; asc Proceedings of the 2010 IEEE I;...(truncated); 23: len 4; hex 80000147; asc    G;; 24: len 4; hex 80000000; asc     ;; 25: len 4; hex 323
03130; asc 2010;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex ; asc ;; 29: len 4; hex 49454545; asc IEEE;; 30: len 0; hex ; asc ;; 31: len 0; hex ; asc ;; 32: len 4; hex 80000000; asc     ;; 33:
 len 4; hex 69736269; asc isbi;; 34: len 4; hex 80000000; asc     ;; 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: len 30; hex 333264623465636165383532346165313862346533346538343533643032;
 asc 32db4ecae8524ae18b4e34e8453d02;...(truncated); 56: len 30; hex 393965323734663935313764346330316163303630616431323666333439; asc 99e274f9517d4c01ac060ad126f349;...(truncated); 57: len 30; hex 3764353333393163
63346535343366646161366433396163363139326638; asc 7d53391cc4e543fdaa6d39ac6192f8;...(truncated); 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66:
len 1; hex 00; asc  ;; 67: len 1; hex 00; asc  ;; 68: len 0; hex ; asc ;; 69: len 1; hex 01; asc  ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: SQL NULL; 73: len 1; hex 00; asc  ;; 74: len 1; hex 01; asc
 ;; 75: len 30; hex 343535666138313666333738343962393966623734613934633737653865; asc 455fa816f37849b99fb74a94c77e8e;...(truncated); 76: len 30; hex 633838646133633933613736343838336265316530393730323062313764; as
c c88da3c93a764883be1e097020b17d;...(truncated); 77: SQL NULL;

*** WE ROLL BACK TRANSACTION (1)
Submitted by Elmer van Chastelet on 15 July 2012 at 14:44

Log in to post comments