Alexandre Fayolle <alexandre.fayolle@logilab.fr> [Wed, 02 Jun 2010 16:12:18 +0000] rev 5639
[win32] fix deadlock occuring on the sequence tables with SQLServer
actually, this deadlock would occur with any db backend other that PostgreSQL
as the previous code was heavily relying on PG's SEQUENCE facility, not available
elsewhere.
Deadlock description:
Thread1 starts creating entities (and therefore calls create_eid):
-> this creates a DB-level lock on the entities_id_seq table, which
will last until end of transaction
Thread2 calls create_eid, which acquires the Python lock object, but
updating the entities_id_seq is held by the DB lock
Thread1 wants to create a new entity, calls create_eid, and is stuck by
the Python lock object held by Thread2.
Solution:
use a separate connection to read and write the entities_id_seq table.
Alexandre Fayolle <alexandre.fayolle@logilab.fr> [Wed, 02 Jun 2010 16:05:40 +0000] rev 5638
log the user name on session opening for easier debugging
Alexandre Fayolle <alexandre.fayolle@logilab.fr> [Wed, 02 Jun 2010 15:55:58 +0000] rev 5637
more robust handling of looping task configuration in ldap source
* use minimum times
* updated documentation and help strings
* fix the minutes vs. seconds confusion
Sylvain Thénault <sylvain.thenault@logilab.fr> [Wed, 02 Jun 2010 16:15:05 +0200] rev 5636
backport stable
Sylvain Thénault <sylvain.thenault@logilab.fr> [Wed, 02 Jun 2010 16:13:28 +0200] rev 5635
[rql2sql] fix scope computation of variable from temporary table
Sylvain Thénault <sylvain.thenault@logilab.fr> [Wed, 02 Jun 2010 15:55:16 +0200] rev 5634
stop being dumb please
Sylvain Thénault <sylvain.thenault@logilab.fr> [Wed, 02 Jun 2010 15:29:18 +0200] rev 5633
backport stable
Sylvain Thénault <sylvain.thenault@logilab.fr> [Wed, 02 Jun 2010 15:28:19 +0200] rev 5632
[tableview / facets] to work properly with facet, initial table should handle case where actualrql isn't specified