← Back to team overview

openerp-india team mailing list archive

[Bug 949907] Re: could not obtain lock on row in relation "res_users"

 

Hello Marcel  van,

I have checked this issue again at my end .I did not face traceback as mention 
in bug discription. I have 'sync remote calendars' with 3 or more calendars
defined in thunderbird. It give me a traceback like ....

2012-05-01 23:43:27,179 21080 ERROR ? openerp.sql_db: bad query: UPDATE res_users
                        SET date=now() AT TIME ZONE 'UTC'
                        WHERE id=1 AND password=E'$1$lpCf4bge$1jipE0iiK8/.d6TJR2ZmV.' AND active
                        RETURNING id
Traceback (most recent call last):
  File "/home/jir/workspace/trunk6/server/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: could not serialize access due to concurrent update

2012-05-01 23:43:27,180 21080 ERROR ? netsvc: Could not authenticate
Traceback (most recent call last):
  File "/home/jir/workspace/trunk6/addons/base_crypt/crypt.py", line 180, in login
    return self._login(cr, db, login, password)
  File "/home/jir/workspace/trunk6/addons/base_crypt/crypt.py", line 218, in _login
    (int(id), encrypted_pw.encode('utf-8')))
  File "/home/jir/workspace/trunk6/server/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/jir/workspace/trunk6/server/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: could not serialize access due to concurrent update

As bug : lp:992525
 
So would you please provide a more information regarding this issue.

Thanks and waiting for reply!


** Changed in: openobject-server
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/949907

Title:
  could not obtain lock on row in relation "res_users"

Status in OpenERP Server:
  Incomplete

Bug description:
  I received a number of these with the

  2012-03-08 13:00:58,104 18563 ERROR ? openerp.sql_db: bad query: SELECT id from res_users
                            WHERE login='admin' AND password='admin'
                                  AND active FOR UPDATE NOWAIT
  Traceback (most recent call last):
    File "/home/richard/src/openerp/server/6.1/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  OperationalError: could not obtain lock on row in relation "res_users"

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/949907/+subscriptions


References