Gnucash in "MySQL server has gone away" loop

[John Ralls]

On Oct 3, 2011, at 7:50 PM, Christopher X. Candreva wrote:

> On Mon, 3 Oct 2011, John Ralls wrote:
> 
>> When the db loads successfully from your F14 box, how long do those two 
>> queries -- the slots and splits ones that are the last two logged in the 
>> mysql log -- take to complete? It would show in the gnucash tracefile as a 
>> time lag between ending the Transasction loading and beginning to load 
>> whichever of the two starts first.
> 
> Ah, running with --debug on against the F14 mysql  -- the one that 
> actually works -- shows an error:
> 
> * 22:45:23  INFO <gnc.engine> [xaccTransSetDateInternal] addr=0x3a74aa0 set date to 1313358140.000000000 Sun Aug 14 17:42:20 2011
> * 22:45:58  CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1153: Got a packet bigger than 'max_allowed_packet' bytes
> * 22:45:58  CRIT <gnc.backend.dbi> [conn_execute_select_statement()] Error executing SQL SELECT * FROM slots WHERE obj_guid IN  ('ffff1bfc2a5abdd083f93e6409e27516', ...
> * 22:45:58  CRIT <gnc.backend.sql> [gnc_sql_execute_select_statement()] SQL error: SELECT * FROM slots WHERE obj_guid IN ('ffff1bfc2a5abdd083f93e6409e27516', ...
> 
> Then a bunch of lines like:
> * 22:45:58  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback trans=0x3a74b70
> * 22:45:58  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback trans=0x3a749d0
> * 22:45:58  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback trans=0x3a74830
> * 22:45:58  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback trans=0x3a735d0
> * ....

Interesting. 36 seconds later, same as the time between the query and the "reconnecting" loop on the F15.

Googling the error, it appears that perhaps we're being too aggressive in batching the slots query, so that the response is bigger than can be accommodated without tuning the database (which the stacktrace crowd says must be done at both ends). Odd that the newer version croaks silently.

I think that's telling you that you can't safely use the db, even on the F14, since it's dropping a bunch of your transactions after the error.

How big is the db?

Regards,
John Ralls