Gnucash in "MySQL server has gone away" loop

[Christopher X. Candreva]

On Tue, 4 Oct 2011, John Ralls wrote:

> 
> On Oct 4, 2011, at 11:41 AM, Christopher X. Candreva wrote:
> 
> > On Tue, 4 Oct 2011, John Ralls wrote:
> > 
> >> So, try jacking up the max_allowed_packet on the server side (apparently 
> >> in /etc/my.cnf) and see if that makes a difference.
> > 
> > It can also be done via an SQL command. I just did and was able to load from 
> > the database successfully, without the loop or SQL error in gnucash.trace

> And the command is...?

>From within the mysql command line client, to view current value:
mysql> show global variables like 'max_allowed_packet';
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.00 sec)

To set a new value:
mysql> set global max_allowed_packet=(1048576 * 2);
or
mysql> set global max_allowed_packet=2097152;


> I've opened a bug [1] to track fixing this.

URL ? :-)


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