Gnucash in "MySQL server has gone away" loop

[John Ralls]

On Oct 4, 2011, at 1:28 PM, Christopher X. Candreva wrote:

> 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 ? :-)
> 

Sorry, https://bugzilla.gnome.org/show_bug.cgi?id=660926

Regards,
John Ralls