Every node can have it's own mempool settings. As long as the inputs used in your transaction still exist, a miner can confirm your transaction.
It depends on your wallet how it handles this. If it keeps broadcasting your transaction, it won't "return". If it gives you the option to "abandon" it, you can try that. Or import your keys in a different wallet. So to start: which wallet do you use?