Gnucash in "MySQL server has gone away" loop

[Christopher X. Candreva]

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
* ....


==========================================================
Chris Candreva  -- chris at westnet.com -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/