Hi, this is an update to the thread from June 2012 started by Gaëtan Minet <[email protected]>:
> It is only when I try to logout the key for the second time that the > interface freezes until what looks like a lock timeout has elapsed (and this > time the DBI exception is displayed). > > At this moment here is the output in the log: > > 2012/06/19 23:01:03 openxpki.system.DEBUG [OpenXPKI::Server::DBI::DBH > (/usr/lib/perl5/OpenXPKI/Server/DBI/DBH.pm:294); root(CA Operator)@9438] > Exception: I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED; __ERRNO__ => 1205; > __ERRVAL__ => Lock wait timeout exceeded; try restarting transaction; > __QUERY__ => delete from secret where group_id=? and pki_realm=? > 2012/06/19 23:01:03 openxpki.system.DEBUG [OpenXPKI::Server::DBI::DBH > (/usr/lib/perl5/OpenXPKI/Server/DBI/DBH.pm:294); root(CA Operator)@9438] > Exception: I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED; __ERRNO__ => 1205; > __ERRVAL__ => Lock wait timeout exceeded; try restarting transaction; > __QUERY__ => delete from secret where group_id=? and pki_realm=? > > > > > Restarting the openxpki daemon process stops some pids and then unlocks the > table. I think I have found and fixed the problem. I have just pushed hotfix 0.10.0.1 to Github. It should fix the problem with transaction locks that causes frontend lockups and also addresses a (very rare) problem that can result in incomplete results from DBI select queries. The fixes have been committed to master and develop. Cheers Martin ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
