Describe the issue

The command listtransactions doesn't return up-to-date transaction information, unless the client is restarted - even though the transaction overview in the GUI is correct, and the balance returned by getinfo is correct.
This behavior occurs with regular transactions, stakes, MN rewards etc.

Can you reliably reproduce the issue?

If so, please list the steps to reproduce below:

1. Note recent incoming transactions in the GUI, the balance returned by getinfo and the last transaction returned by listtransactions from the command line.
2. Send a transaction to your wallet.
3. Again note recent incoming transactions in the GUI, the balance returned by getinfo and the last transaction returned by listtransactions from the command line.
4. Shut down and restart wallet.
5. Again note recent incoming transactions in the GUI, the balance returned by getinfo and the last transaction returned by listtransactions from the command line.

Expected behavior

The incoming transaction is expected to show in step 3 - and that list is expected to be identical to the list returned in step 5.

Actual behavior

The transaction does not show in step 3. The transaction does show in step 5.

Screenshots.

What version of PIVX Core are you using?

Compiled from commit aedf80b

Any extra information that might be useful in the debugging process.

Bitcoin has the following line, which isn't present in PIVX:
https://github.com/bitcoin/bitcoin/blob/master/src/wallet/wallet.cpp#L904

You could cherry-pick cevap/ion@5491b06 to amend it that way.

PIVX itself uses slightly different inserts during startup etc, and to stay closer to PIVX practice you coud cherry-pick this: wagerr/wagerr@8f5c430