[Openstack] [swift] Frequent OperationalError (database locked) in 1.10.0 (Havana)

Juan J. Martinez juan at memset.com
Wed Nov 13 13:59:15 UTC 2013


Hello,

I've upgraded to Havana and I'm getting frequent errors like this:

Nov 11 11:48:29 storage2 container-server ERROR __call__ error with GET
/device1/250/AUTH_memseaa1_42308e3988554f77b4b3c84e8b1f17cd/container :
#012Traceback (most recent call last):
#012  File "/usr/lib/pymodules/python2.6/swift/container/server.py",
line 486, in __call__
#012    res = method(req)
#012  File "/usr/lib/pymodules/python2.6/swift/common/utils.py", line
1870, in wrapped
#012    return func(*a, **kw)
#012  File "/usr/lib/pymodules/python2.6/swift/common/utils.py", line
686, in _timing_stats
#012    resp = func(ctrl, *args, **kwargs)
#012  File "/usr/lib/pymodules/python2.6/swift/container/server.py",
line 368, in GET
#012    if broker.is_deleted():
#012  File "/usr/lib/pymodules/python2.6/swift/container/backend.py",
line 246, in is_deleted
#012    with self.get() as conn:
#012  File "/usr/lib/python2.6/contextlib.py", line 16, in __enter__
#012    return self.gen.next()
#012  File "/usr/lib/pymodules/python2.6/swift/common/db.py", line 325,
in get
#012    self.possibly_quarantine(*sys.exc_info())
#012  File "/usr/lib/pymodules/pytho...

The exception is OperationalError: database is locked.

Looks like the problem described in this bug report:
https://bugs.launchpad.net/swift/+bug/1224253

I can reproduce the problem with Python 2.6.6 (sqlite3 version 2.4.1, in
case is related... although the LP issue shows Python 2.7 and I tried
using pysqlite2 version 2.6.0 with no change).

Before the upgrade I was running 1.7.4 with no issues.

Any help with this would be appreciated.

Kind regards,

Juan

-- 
Juan J. Martinez
Software Developer, MEMSET

mail: juan at memset.com
 web: http://www.memset.com/

Memset Ltd., registration number 4504980.
Building 87, Dunsfold Park, Stovolds Hill, Cranleigh, Surrey GU6 8TB, UK.




More information about the Openstack mailing list