Comment 1 for bug 1414588

Revision history for this message
Gil Vernik (gilv) wrote : Re: db replicator - object count not found

Adding more to this, i have couple of container DB that constantly fail in container replication.
Getting errros like this:

 File "/home/swift/OpenStack/swift/swift/common/db.py", line 130, in <lambda>#012 self, *args, **kwargs))#012OperationalError: no such column: object_count
Jan 26 13:47:08 ubuntu-swift-dev container-replicator: Replication run OVER
Jan 26 13:47:08 ubuntu-swift-dev container-replicator: Attempted to replicate 105 dbs in 0.32922 seconds (318.93944/s)
Jan 26 13:47:08 ubuntu-swift-dev container-replicator: Removed 0 dbs
Jan 26 13:47:08 ubuntu-swift-dev container-replicator: 202 successes, 4 failures
Jan 26 13:47:08 ubuntu-swift-dev container-replicator: no_change:202 ts_repl:0 diff:0 rsync:0 diff_capped:0 hashmatch:0 empty:0
Jan 26 13:47:11 ubuntu-swift-dev container-replicator: Beginning replication run
Jan 26 13:47:11 ubuntu-swift-dev container-replicator: ERROR reading db /srv/4/node/sdb4/containers/544/3e5/8811f9249de0f711d6f652ab48aba3e5/8811f9249de0f711d6f652ab48aba3e5.db: #012Traceback (most recent call last):#012 File "/home/swift/OpenStack/swift/swift/common/db_replicator.py", line 436, in _replicate_object#012 info = broker.get_replication_info()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 543, in get_replication_info#012 info = self.get_info()#012 File "/home/swift/OpenStack/swift/swift/container/backend.py", line 411, in get_info#012 ''') % (trailing_sync, trailing_pol)).fetchone()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 129, in execute#012 self.timeout, self.db_file, lambda: sqlite3.Cursor.execute(#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 67, in _db_timeout#012 return call()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 130, in <lambda>#012 self, *args, **kwargs))#012OperationalError: no such column: object_count
Jan 26 13:47:11 ubuntu-swift-dev container-replicator: ERROR reading db /srv/4/node/sdb4/containers/462/54e/7383600001a3888360f31a2c9257a54e/7383600001a3888360f31a2c9257a54e.db: #012Traceback (most recent call last):#012 File "/home/swift/OpenStack/swift/swift/common/db_replicator.py", line 436, in _replicate_object#012 info = broker.get_replication_info()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 543, in get_replication_info#012 info = self.get_info()#012 File "/home/swift/OpenStack/swift/swift/container/backend.py", line 411, in get_info#012 ''') % (trailing_sync, trailing_pol)).fetchone()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 129, in execute#012 self.timeout, self.db_file, lambda: sqlite3.Cursor.execute(#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 67, in _db_timeout#012 return call()#012 File "/home/swift/OpenStack/swift/swift/common/db.py", line 130, in <lambda>#012 self, *args, **kwargs))#012OperationalError: no such column: object_count