Right-clicking on an unconfirmed transaction pops up a contextual menu that has the option "Abandon transaction". It is usually grayed out. How much time needs to pass for Bitcoin Core to allow one to choose "Abandon transaction"?
When I run
abandontransaction on my transaction, it says:
Transaction not eligible for abandonment (code -5)