looking at the details of the transaction:

Status: 0/unconfirmed, in memory pool
Date: 8/29/2016 20:35
To: 1LpZAeJthyUueRwZMjv7K471L7Vyg4Abqv
Debit: -2.90900000 BTC
Net amount: -2.90900000 BTC
Transaction ID: 417b1e741a30571bf27138a965864c27d5bb99c617a7b5864a3d3a24c959b928
Output index: 0

i see that it is in the memory pool. will it drop out of the memory pool at some point and return to my wallet?