I don't believe this is a duplicate bug. the res_users lock error, is ignored for the most part, even though it is logged. if you look at res_users.py, there is a workaround for the login portion there.
the problem is that the correct number of partners is not created. for example use the JMeter test and run 10 users (threads) with one look - 10 users creating 1 partner all at the same time. In my test environment only 8 partners are created.
An example error is :
<?xml version='1.0'?>
<methodResponse>
<fault>
<value><struct>
<member>
<name>faultCode</name>
<value><string>could not serialize access due to concurrent update
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
</string></value>
</member>
<member>
<name>faultString</name>
<value><string>Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/wsgi/core.py", line 79, in xmlrpc_return
result = openerp.netsvc.dispatch_rpc(service, method, params)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 572, in dispatch
res = fn(db, uid, *params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4154, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
res = self._obj.execute(query, params)
TransactionRollbackError: could not serialize access due to concurrent update
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
I don't believe this is a duplicate bug. the res_users lock error, is ignored for the most part, even though it is logged. if you look at res_users.py, there is a workaround for the login portion there.
the problem is that the correct number of partners is not created. for example use the JMeter test and run 10 users (threads) with one look - 10 users creating 1 partner all at the same time. In my test environment only 8 partners are created.
An example error is :
<?xml version='1.0'?> </name> <string> could not serialize access due to concurrent update ."res_users" x WHERE "id" OPERATOR( pg_catalog. =) $1 FOR SHARE OF x" ng</name> <string> Traceback (most recent call last): pymodules/ python2. 7/openerp/ wsgi/core. py", line 79, in xmlrpc_return netsvc. dispatch_ rpc(service, method, params) pymodules/ python2. 7/openerp/ netsvc. py", line 360, in dispatch_rpc getService( service_ name).dispatch( method, params) pymodules/ python2. 7/openerp/ service/ web_services. py", line 572, in dispatch pymodules/ python2. 7/openerp/ osv/osv. py", line 121, in wrapper pymodules/ python2. 7/openerp/ osv/osv. py", line 176, in execute pymodules/ python2. 7/openerp/ osv/osv. py", line 164, in execute_cr pymodules/ python2. 7/openerp/ osv/orm. py", line 4154, in create execute( 'insert into "'+self._table+'" (id'+upd0+") values ("+str( id_new) +upd1+' )', tuple(upd2)) pymodules/ python2. 7/openerp/ sql_db. py", line 152, in wrapper pymodules/ python2. 7/openerp/ sql_db. py", line 212, in execute execute( query, params) backError: could not serialize access due to concurrent update ."res_users" x WHERE "id" OPERATOR( pg_catalog. =) $1 FOR SHARE OF x"
<methodResponse>
<fault>
<value><struct>
<member>
<name>faultCode
<value>
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"
</string></value>
</member>
<member>
<name>faultStri
<value>
File "/usr/lib/
result = openerp.
File "/usr/lib/
result = ExportService.
File "/usr/lib/
res = fn(db, uid, *params)
File "/usr/lib/
return f(self, dbname, *args, **kwargs)
File "/usr/lib/
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/
cr.
File "/usr/lib/
return f(self, *args, **kwargs)
File "/usr/lib/
res = self._obj.
TransactionRoll
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"
</string></value>
</member>
</struct></value>
</fault>
</methodResponse>