[Bug 273612] Local Folders: Unknown error. (There is no transaction in progress.)

[Mark Gannon]

https://bugs.kde.org/show_bug.cgi?id=273612





--- Comment #7 from Mark Gannon <mark truenorth nu>  2011-09-26 19:12:06 ---
This problem (at least in my case) occurs because the connection between the
external to Akonadi MYSQL database connection times out do to inactivity. It
might also occur if there are network connectivity issues.  The default Mysql
timeout period is 8 hours.  Consequently, it might appear to happen over night.
 The problem can be ameliorated, but not solved, by increasing the wait_timeout
value in the Mysql database config file.

By default the Mysql client library (called by Akonadi through the qt sql
library) doesn't attempt to reconnect.  Reconnection is controlled via a
database connection initialization setting.  While not set in either the
Akonadi or QT SQL code, it can be set via the ~/.config/akonadi/akonadiserverrc
file.  Change the Options line to read:
Options="MYSQL_OPT_RECONNECT=1"

Since it is difficult to imagine a scenario where a reconnection would be the
desired behaviour, it might be worth considering a change to the MYSQL
initialization code.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.