saved to a SQL server, now it won't load it

[George Riner]

Thanks for the tip.  I now see that gc sends several giant sql 
statements, a bit over 1.36 million characters long each, to the server 
to load things by guid from the slots table.  The server is 
choking/refusing. Setting the max_allowed_packet size to something 
larger (say, 2,097,152) allows the sql to process.  GC now loads the 
books from the db, but it's really slower than loading the same data 
from a local '.gnucash' file.  Maybe there's db tuning that could be 
done on the server to improve performance... or GC has some features for 
tuning its performance (I'm windows 10 64-bit)...  For the time being, 
I'm sticking with the 4.5 Mb .gnucash file on my local drive which 
*only* takes 50 seconds to load.

As noted in a 2011 posting here: 
https://lists.gnucash.org/pipermail/gnucash-user/2011-October/041336.html
where the user, like me, has data (imported and cleaned up from Quicken) 
going back to 1993.

:George


On 2/18/2017 4:58 PM, John Ralls wrote:
>> On Feb 18, 2017, at 4:36 PM, George Riner <georgeriner at mycogeo.com> wrote:
>>
>> Just to add...
>>
>> Gnucash spins for 4-5 seconds, and the lights on the NAS box blink busily, and Gnucash has that 'loading user data' progress bar in the lower right. All my accounts show up with my names, my AccountCodes, and the "Price Editor" shows my stocks and their price histories.
>>
>> But all the accounts are empty of transactions and have $0.00 balances.
>>
>> --------------
>>
>> I setup a SQL server on my Synology NAS box. It's their MariaDB implementation of MySQL. I then did a Save as... to a new database on that server. The save appears to have worked.  I can login to the server through the MyPHPadmin tool and see that the database now has the expected tables and that the 'transactions' table has ~38,000 records in it - which is about right. I can look in the tables and see my transactions - they look like they are there.
>>
>> So... I restart GnuCash, open up my books from the SQL server and ... all the accounts are empty! No errors are shown in Gnucash.
>>
>> I have to enter my login and password to get to the SQL server on the NAS, and I've given myself all the permissions on that Gnucash database.  So... why does nothing load in? I can still see all the tables with all their data in them. (I haven't edited any values directly in the tables, so I'm really sure I haven't broken anything by manually fiddling around in the db.)
> Please start GnuCash from the command line with arguments --log gnc.backend.dbi=debug, then examine the trace file (http://wiki.gnucash.org/wiki/Tracefile) for clues. If you want still more verbosity about the SQL queries made, you can add a second --log gnc.backend.sql=debug argument.
>
> Regards,
> John Ralls
>
>