[01:13:15] <thwarted>	 https://we.phorge.it/source/phorge/browse/master/src/applications/harbormaster/event/HarbormasterUIEventListener.php#L55-61
[01:14:03] <thwarted>	 The executeOne fails when there are multiple buildablePHIDs in harbormaster_buildable that match this query, resulting in an exception and no content being shown.
[01:16:29] <thwarted>	 I don't know how the database ended up in this state; I counted 32 occurrences in our database going back to 2017.  The difference between the dateCreated on the duplicate entries are hours apart.
[01:20:39] <thwarted>	 It's annoying that this fails like this when the expected data constraint of a single row isn't satisfied, since it entirely breaks the Diffusion (rREPOabcdef) page view.  Not using executeOne would address it and it shows all entries.  I mitigated the exception so the specific revision Diffusion page is viewable, by updating the database manually to set a non-duplicate buildablePHID value.  This results in it showing "Harbormaster completed building 
[01:20:39] <thwarted>	 Unknown Object (Buildable)." for that entry, which is fine for my immediate use case because it gets the page shown.