OperationalError: no such column: SQLITE_SEQUENCE

Which OS, version of SQLITE, etc are you running? Also is /srv/node/ owned by the swift user (or the user you are running swift services as)?

Ha, trying to get it to work on RHEL5 with sqlite-3.3.6-5 and I have python-sqlite-1.1.7-1.2.1 -- not sure if that is used
but I think it might be)

I can put and get and list objects, create containers, etc.

/srv/node is owned by user swift (the user I am running all services as, well...

The only funny business is that auth service doesnt work unless I run it as root--
I get "Cannot open database file" even though the perms are correct and owned by the swift user.
but that is a different issue i think.

Anyhow it seems that that column is created automatically by sqlite if you have an autoincrement column
and are working in version 3, which I am.

Make sure /etc/swift the directory itself is writable by the user. I believe sqlite makes some journal files and such next to the db file during transactions.

Well, I wonder if there's any way to get the current autoincrement value on older sqlites. It's almost but not quite the same thing as "select max(ROWID) from object".

Well Iam still getting no such column: SQLITE_SEQUENCE

Oct 26 19:32:02 segment1 account-replicator ERROR reading db /srv/node/4/sdb4/accounts/126530/556/7b90a4fea22125d2b01dd4f328ff6556/7b90a4fea22125d2b01dd4f328ff6556.db: Traceback (most recent call last): File "/usr/lib/python2.6/site-packages/swift-1.1.0_rc1-py2.6.egg/swift/common/db_replicator.py", line 323, in _replicate_object info = broker.get_replication_info() File "/usr/lib/python2.6/site-packages/swift-1.1.0_rc1-py2.6.egg/swift/common/db.py", line 420, in get_replication_info curs = conn.execute(query_part1 + 'metadata' + query_part2) File "/usr/lib/python2.6/site-packages/swift-1.1.0_rc1-py2.6.egg/swift/common/db.py", line 81, in execute return self._timeout(lambda: sqlite3.Connection.execute( File "/usr/lib/python2.6/site-packages/swift-1.1.0_rc1-py2.6.egg/swift/common/db.py", line 74, in _timeout return call() File "/usr/lib/python2.6/site-packages/swift-1.1.0_rc1-py2.6.egg/swift/common/db.py", line 82, in <lambda> self, *args, **kwargs)) OperationalError: no such column: SQLITE_SEQUENC

would it be useful to try to upgrade the sqlite version?

Based on Mike Barton's comment about older sqlites not having max(ROWID) I think an upgrade of sqlite is needed. I know with my uses it's 3.6.x.

Sorry, my comment was a bit off, but my recommendation remains the same. I searched through sqlite's version history and couldn't find any references that made sense for what you're seeing. But I'd upgrade and see how it goes.