6.0.0-beta1
7/16/25

[#10906] Updating preferences are not committed on InnoDB tables
Summary Updating preferences are not committed on InnoDB tables
Queue Horde Framework Packages
Queue Version Git master
Type Bug
State Resolved
Priority 3. High
Owners jan (at) horde (dot) org
Requester claude.tompers (at) restena (dot) lu
Created 01/06/2012 (4940 days ago)
Due
Updated 01/25/2012 (4921 days ago)
Assigned
Resolved 01/25/2012 (4921 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
01/25/2012 11:07:48 AM Jan Schneider Assigned to Jan Schneider
State ⇒ Resolved
 
01/25/2012 11:07:28 AM Git Commit Comment #3 Reply to this comment
Changes have been made in Git for this ticket:

[jan] Use separate database connection for SQL session handler (Bug #10906).

  2 files changed, 4 insertions(+), 1 deletions(-)
http://git.horde.org/horde-git/-/commit/1d280685e99dec37d5b82eaa43eb2036b22b159d
01/25/2012 11:07:25 AM Jan Schneider Version ⇒ Git master
Queue ⇒ Horde Framework Packages
 
01/25/2012 11:07:23 AM Git Commit Comment #2 Reply to this comment
Changes have been made in Git for this ticket:

We need to start a transaction too, when reconnecting during session 
write (Bug #10906).

  2 files changed, 3 insertions(+), 2 deletions(-)
http://git.horde.org/horde-git/-/commit/959cddc8a37e48ef8643a03db2a75cd6d58f0de3
01/06/2012 10:10:26 AM claude (dot) tompers (at) restena (dot) lu Comment #1
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ Updating preferences are not committed on InnoDB tables
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
When updating the prefs (changing the language for example), a lot
of session handling queries happen as well as the actual UPDATE
horde_prefs query.

All these queries seem to be handled by the same Horde_Db_Adapter_Mysqli
instance. Immediately after the UPDATE query, the Adapter is closed
without committing to the database, therefore the changes are not applied.

The session handler needs a separate DB connection.

Saved Queries