just waked up surprisingly still unconfirmed, can you tell me more about how can i create new transaction there and sign with bitcoin core??
You already said that you used the fee rate of 5.2 sat/vbyte for your transaction.
With that fee rate your transaction should have been confirmed by now, unless it has an unconfirmed parent with the fee rate of 1 sat/vbyte.
Can you see your transaction in block explorers? Maybe, your transaction hasn't been broadcasted to the network at all and it's just a local transaction.