openerp-expert-framework team mailing list archive

[Albert Cervera i Areny <albert@xxxxxxxxxxx>]

A Divendres, 15 de gener de 2010, Cloves Almeida va escriure:
> I didn't test it, but maybe adding the code below to stock.py:276 should 
> do the trick.
> 
> cr.execute("select id from stock_move where location_dest_id=%s and 
> location_id<>%s and product_id=%s and state='done' FOR UPDATE", (id, id, 
> product_id));
> cr.execute("select id from stock_move where location_id=%s and 
> location_dest_id<>%s and product_id=%s and state in ('done', 'assigned') 
> FOR UPDATE", (id, id, product_id))
> 

That was my first thought but it doesn't work because the WHERE clause states 
that the query will only select (and thus block for update) those records in 
'done' or 'assigned' state.

We'd need another query only to do the SELECT FOR UPDATE, and I eventually 
decided I'd better use the LOCK, to avoid too many sequential scans on the 
table. I'm not sure which option would be better from a performance point of 
view but I've posted a bug report in launchpad with the fix.

-- 
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: +34 669 40 40 18