Skip to content

Instantly share code, notes, and snippets.

@lamanotrama

lamanotrama/lock.txt

Created April 1, 2015 07:10
Show Gist options
  • Save lamanotrama/e5c64d37a51610f0bf7f to your computer and use it in GitHub Desktop.
Save lamanotrama/e5c64d37a51610f0bf7f to your computer and use it in GitHub Desktop.
Download ZIP
mogilefs innodb lock log
Raw
lock.txt
blocking_id: 727576
requesting_id: 770256
blocking_host: mogfs001.30d.lan:57789
requesting_host: mogfs002.30d.lan:55519
lock_table: `mogilefs`.`file_to_replicate`
lock_index: `nexttry`
lock_mode: X,GAP
seconds: 54
blocking_info: UPDATE file_to_replicate SET nexttry = UNIX_TIMESTAMP() + 1000 WHERE fid IN (1935286784,1935286875,1935286818,1935286831,1935286825,1935286806,1935286837,1935286813,1935286865,1935286862,1935286777,1935286856,1935286836,1935286832,1935286844,1935286797,1935286883,1935286828,1935286877,1935286874,1935286823,1935286886,1935286809,1935286849,1935286840,1935286815,1935286810,1935286847,1935286811,1935286860,1935286833,1935286838,1935286869,1935286876,1935286845,1935286814,1935286884,1935286864,1935286839,1935286881,1935286880,1935286852,1935286817,1935286853,1935286866,1935286893,1935286758,1935286834,1935286841,1935286843,1935286846,1935286873,1935286872,1935286745,1935286848,1935286821,1935286826,1935286805,1935286871,1935286879,1935286827,1935286867,1935286855,1935286819,1935286858,1935286824,1935286868,1935286816,1935286822,1935286812,1935286863,1935286870,1935286850,1935286878,1935286857,1935286851,1935286830,1935286820,1935286765,1935286842,1935286861,1935286854,1935286859,1935286829,1935286835)
requesting_info: INSERT IGNORE INTO file_to_replicate (fid, fromdevid, nexttry) VALUES ('1935297244',NULL,0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment