How to erase transaction and get coins back in wallet

[PublicP2poolNode]

So something strange happened the other day, all of a sudden it appeared I had many more bitcoins in my wallet than I should have had. Also I believe I was under the malleability attack because every time I sent coins it appeared twice on my wallet although only one would confirm.

Trying to see if I really had the coins it said I had I sent them to myself.

That didn't confirm either.

Then I tried spending what I new I should have in the wallet for sure. And of course it didn't confirm either with a fee of .0001

Question, if I sent coins I actually had combined with coins I didn't have to myself, then tried to send coins I actually had but now they were from a transaction that will never clear becasue they were mixed with coins that didn't exist... Arghh

How can i erase all the ones that haven't confirmed and get my actual coins back?

[1713296710]

1713296710

[JumperX]

you are referring about the "ghost" transaction right? if my understand is right then you only need to wait 2-3days and the unconfirmed transaction will be dropped by the memory pool and your coins will be back in your wallet as there is nothing happened

[PublicP2poolNode]

If the network forgets about it then how will the coins return if my wallet says that I spent them. Don't I need to somehow erase the transaction from my bitcoin-qt and then let the network forget about it. And if so how do I delete it from my bitcoin-qt so that it appears it never happened and let the network forget about it?

[JumperX]

If the network forgets about it then how will the coins return if my wallet says that I spent them. Don't I need to somehow erase the transaction from my bitcoin-qt and then let the network forget about it. And if so how do I delete it from my bitcoin-qt so that it appears it never happened and let the network forget about it?

if the transaction is dropped in the network, then i guess you only need to resync your wallet and your coins will appear to it again and the transaction wont show up in the logs as if it never happened

[achow101]

If the network forgets about it then how will the coins return if my wallet says that I spent them. Don't I need to somehow erase the transaction from my bitcoin-qt and then let the network forget about it. And if so how do I delete it from my bitcoin-qt so that it appears it never happened and let the network forget about it?

You can run Bitcoin core with the -zapwallettxes option. It will remove all unconfirmed transactions from your wallet so it will have forgotten about it. All you need to do is wait for the network to drop it.