I have the same problem.
Status: 0/unconfirmed, not in memory pool, abandoned
but my txid does not show on the block explorer - how can i get my balance back? I tried -zapwallet -rescan and etc... but nothing yet. It's stuck there in a limbo
Are you guys using Bitcoin Core to the latest version and are you guys sure you still control the private keys of these addresses? because after -zapwallettxs they should show up if they are really unconfirmed.
A more extreme measure would be to delete all the folders (be sure to backup wallet.dat) and re-scan the entire thing, but still, it's pretty weird. You guys need to post your txid on a blockchain page if you want more detailed help.