[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