All Scheduled Transaction Disappear

Tommy Trussell tommy.trussell at gmail.com
Fri Dec 23 17:06:24 EST 2016


On Fri, Dec 23, 2016 at 3:51 PM, Tommy Trussell <tommy.trussell at gmail.com>
wrote:

> On Thu, Dec 22, 2016 at 2:40 PM, aeneas <receiver at gowdygroup.net> wrote:
>
>> Without my intending to do anything to them all of my scheduled
>> transactions
>> suddenly went missing.  In that I went to update the amount for next years
>> premium, on one of my insurance policies, and found that the Scheduled
>> Transaction Editor seems to have no transactions.
>>
>> It might be worth pointing out that I store data in a remote MySQL DB that
>> is accessed using GnuCash from different computers, which have slightly
>> different versions of GnuCash.  However, this is not a new development.  I
>> started using GnuCash for 2016 which means that just about 1 year ago I
>> started using it.  No problem with scheduled transactions until now.
>>
>
> I don't use the MySQL DB store, so I cannot say whether that part is
> relevant.
>
> Can you inventory the systems you use that access the DB and state what
> operating systems and what versions of GnuCash they are running? Some
> particular version of GnuCash may have a known bug with scheduled
> transactions, so that's the first thing to look at, and if so, you would
> want to upgrade that system for sure.
>
> How long has it been since you backed up the data? You may want to
> preserve whatever backups you have until you get this sorted out.
>
> You might also make a new full backup (be sure to include your current DB
> files as well as any relevant logs on the "client" systems) before you look
> to see if any other data is missing on your systems.
>
>

I just saw your other thread and John Ralls' response, advising the point
to which you might roll back your DB.

You might also want to consider (since GnuCash is not able to support
concurrent DB access), you might look for cases where one machine might not
have finished writing to the DB when another GnuCash instance (on the same
or another machine) started up, or something similar.




> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>


More information about the gnucash-user mailing list