Then what will happy with the coin involved in my transaction?
Shows up in my wallet again?
It depends on the wallets that the sender and receiver are using.
You're question can't be answered accurately until we know exactly what wallet the
sender is using,
and what wallet the
receiver is using.
The most likely possibilities:
Both wallets stop transmitting the transaction. The number of bitcoins that the sender's wallet calculates and displays increases by the sum of bitcoins sent in the transaction to addresses outside the wallet plus the transaction fees.
One of the wallets continues to re-transmit the transaction on a regular basis. The transaction remains waiting to be confirmed at some time in the future.