I seem to remember an inadvertent launch of a Harpoon missile from a Navy ship in port in Italy during a maintenance operation back in the 70’s.
In San Diego, it was bad enough just latching on to a live Tartar missile instead of a TSAM in the magazine. The permissions required to cycle it onto the rail and back into the magazine were horrendous. I thought it was going to take an act of Congress to finish that day’s DSOT.