8000 "Unique constraint failed" while updating db · Issue #3 · Stefan-Code/gglsbl3 · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

"Unique constraint failed" while updating db #3

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
Stefan-Code opened this issue Nov 11, 2015 · 2 comments
Open

"Unique constraint failed" while updating db #3

Stefan-Code opened this issue Nov 11, 2015 · 2 comments
Labels
bug

Comments

@Stefan-Code
Copy link
Owner 
INFO: raw data length: 6782 - protocol.py:265
INFO: Deleting "add" chunks ['188931-188949'] - storage.py:223
INFO: Deleting "sub" chunks ['180475-180476,180478-180490'] - storage.py:233
Failed to synchronize with GSB service: UNIQUE constraint failed: hash_prefix.value, hash_prefix.chunk_number, hash_prefix.list_name, hash_prefix.chunk_type
Traceback (most recent call last):
  File "/tmp/virtalenv/bin/gglsbl_client.py", line 67, in run_sync
    sbl.update_hash_prefix_cache()
  File "/tmp/virtalenv/lib/python3.4/site-packages/gglsbl3/client.py", line 44, in update_hash_prefix_cache
    self.storage.store_chunk(chunk)
  File "/tmp/virtalenv/lib/python3.4/site-packages/gglsbl3/storage.py", line 132, in store_chunk
    self.insert_hash_prefix(hash_prefix)
  File "/tmp/virtalenv/lib/python3.4/site-packages/gglsbl3/storage.py", line 147, in insert_hash_prefix
    self.dbc.execute(q, params)
sqlite3.IntegrityError: UNIQUE constraint failed: hash_prefix.value, hash_prefix.chunk_number, hash_prefix.list_name, hash_prefix.chunk_type
@Stefan-Code
Copy link
Owner Author

Seems like this is either caused by a wrong response by the google servers or (maybe more likely) a broken method to report the existing chunks/prefixes in the request process.

Stefan-Code referenced this issue in afilipovich/gglsbl Jan 31, 2016
903C
@afilipovich
Error handling for DB insertion of already existing chunks
90fee60
Stefan-Code added a commit that referenced this issue Feb 13, 2016
@Stefan-Code
changed logging level for duplicate hash prefix because of #3
e39cd2a
@Stefan-Code
Copy link
Owner Author

TODO: check if afilipovich/gglsbl#10 is relevant

@Stefan-Code Stefan-Code reopened this May 19, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Stefan-Code
0