diff --git a/utils/stuck-write.sh b/utils/stuck-write.sh index 274ca9e..2909f7e 100755 --- a/utils/stuck-write.sh +++ b/utils/stuck-write.sh @@ -1,16 +1,16 @@ #!/bin/bash function req { ssh c4science-db01 "mysql -B -e \"$@\" phabricator_repository" 2> /dev/null } -repo=$(req 'select w.writeProperties,r.phid from repository_workingcopyversion as w,repository as r where r.phid=w.repositoryPHID and w.isWriting=1;' | tail -n +2) +repo=$(req 'select w.writeProperties,r.phid,a.name from repository_workingcopyversion as w,repository as r, phabricator_almanac.almanac_device as a where a.phid=w.devicePHID and r.phid=w.repositoryPHID and w.isWriting=1;' | tail -n +2) if [ -z "$repo" ]; then echo "Nothing to do.. exiting"; exit; fi while read -r r; do TS=$(echo "$r" | cut -f1 | jq -r '.epoch') if [ $TS -lt $(($(date +%s)-3600)) ]; then # older than 1 hour - echo "$r" | cut -f2 + echo "$r" | cut -f2,3 fi done <<< "$repo"