Once I had a transaction sitting in the mempool one week.

Eventually it got concerned.