I was having issue with low fee transaction. Did a double spend and after 2 weeks still no confirmation, and bitcoin balance was off in wallet. Deleted the mempool.dat file in bitcoin folder and entered -zapwallettxes=2 in the bitcoin-qt shortcut (backed up wallet first) and transaction eliminated from core and bitcoin balance restored to correct amount.