Hi Oliver
>> > > You get the DBI exception when you try to log out the key? In that case > I cant tell you why but it explains the behaviour why the key is not > logged out…. yes, the first time I logout the key, no exception is reported on the fronted, it's just behaving like if the key had been deleted from de secret table. But it is not, and the table is then locked (I cannot 'delete from' the table at that moment: it says it's locked). If I refresh the page (click on the home link) immediately, it still says its incomplete/logged out. If I refresh some seconds later, it then it says it's still logged . 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. (did I tell you I also get this on squeeze with your packages ?) What version of perl and DBI are you using ? By the way, are you using InnoDB ? > Can you check the mysql log for any hints? > I'm afraid it's empty :( Ho, any idea why log records do always show up twice ? Thanks Gaetan ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
