[horde] commit problem

[Claude Tompers]

Hi Jan,

Thanks for your reply. We did some digging this afternoon and had quite
a few results.
In short, we're using the mysqli driver and session handling is also
done in the mysql database.
When I try updating my prefs (changing the language for example), a lot
of session handling query go through 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. I'm surprised that nobody else
has this issue because we did not fiddle around in the code (At least
not until we added a few error_log commands this afternoon).

kind regards,
Claude Tompers


On 01/05/2012 10:43 AM, Jan Schneider wrote:
>
> Zitat von Claude Tompers <claude.tompers at restena.lu>:
>
>> Hello,
>>
>> Our MySQL admin recently migrated all our Horde tables to INNODB. Since
>> then, at least the horde_prefs table can not be edited anymore.
>> What we can see from a tcpdump is, that autocommit is explicitly set to
>> 0, but it seems that the final commit command is never sent.
>> We just rolled back (temporarily) to MyISAM and now it works again.
>>
>> Is this a known issue or is there any config parameter that should fix
>> this ?
>
> Since InnoDB is the default engine for Horde 4, and such an behavior
> would break everybody's ability to save preferences, I can clearly say
> that this is not a known issue.
>
> Jan.
>


-- 
Claude Tompers
Ingénieur réseau et système
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.horde.org/archives/horde/attachments/20120105/a177dfe1/attachment.bin>