Description
I have accidentally added myself as a reviewer to a merged request. Now there is no way for me to remove myself as a reviewer as there is no X button if it's merged. This bug was fixed in Gerrit 2.2.2.1 (http://code.google.com/p/gerrit/issues/detail?id=1139).
Unfortunately it's stuck there on my dashboard even after upgrading to Gerrit 2.2.2.1. To fix this for existing review requests:
ssh user@host gerrit gsql -c 'UPDATE patch_set_approvals PSA, changes SET PSA.change_open = C.open WHERE PSA.change_id = C.change_id AND PSA.change_open <> C.open'