audittrail module overrides OpenERP's execute() function. It creates a new cursor, executes default execute() function and registers necessary events. The problem is that as the cursor created holds the transaction until the very end this may become incompatible with code of certain modules.
For example, full_text_search module must create a table which references "ir_model" table. As the transaction started by the cr record in audittrail module has done a SELECT on "ir_model" table, full_text_search CREATE TABLE statement cannot end until audittrail's cursor has finised and thus producing a deadlock.
The following diff solves the problem by setting cr cursor into autocommit mode. This way audittrail module does not interfere in transactions created by the functions it calls and thus making it really transparent as it should.
@@ -315,6 +300,7 @@
def execute(self, db, uid, passwd, model, method, *args):
pool = pooler.get_pool(db)
cr = pooler.get_db(db).cursor()
+ cr.autocommit(True)
try:
proxy = pool.get(model)
if proxy is None:
Here it's a diff with a file so indentation is honoured.