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