Why did you attach such a small fee? You'll have to resend the tx with a higher fee.
Not possible as the attached fee is too low.
I put the minimum amount of fee as I wasn't in rush but didn't expect it will take so long.
I've tried to abandon my transaction (Bitcoin Core) and zapwallettexd but nothing happened.
I cant resend the transaction due the issues above.
from the console? You should be able to resend your transaction once the command is executed.
abandontransaction e49aad910d19bc1f47ec2f0d4ceb7defcf0c335bd4937eb02587711ab6b2acfd