Gnucash in "MySQL server has gone away" loop

Christopher X. Candreva chris at westnet.com
Tue Oct 4 09:09:04 EDT 2011


On Tue, 4 Oct 2011, Andrew Sullivan wrote:


> Could the confusion here be a mismatch in the setup of MySQL?  Does
> GNUCash check that MySQL actually supports transactions on all the
> tables it is using?  The only practical way to ensure that is to
> ensure that MyISAM isn't supported at all.
> 
> The problem with MySQL is that not all its table types support
> transactions.  If you include a non-transactional table in a
> transaction and a failure happens on that table, the behaviour is
> surprising.  Note that by default on most distributions, MySQL comes
> with MyISAM enabled.

In my specific case, all tables are InnoDB.


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


More information about the gnucash-user mailing list