GLOBALEAKS
UNIQUE constraint failed at internaltipanswers.internaltip_id, internaltipanswers.questionnaire_hash
#4122
Replies: 1 comment 1 reply
-
|
This was probably due to a network error and the execution of a request
twice.
I suggest anyhow you update to 4.15 since you seem to be running a very
outdated version
…On Mon, Jul 1, 2024, 12:56 PM S03M ***@***.***> wrote:
Hi,
recently, using GlobaLeaks v.4.10.18, without making any modifications, we
have received an error when inserting a value in the *internaltipanswers*
table, as you can see below. This error has generated a series of 7 alerts
that have arrived in the form of email, all with the same data.
Does anyone knows the function of this table and have any idea why this
could be happennig?
We have tried to reproduce it in many ways but no results.
Thanks!
_sqlalchemy.exc.IntegrityError Wraps a DB-API IntegrityError.
Traceback (most recent call last):
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1277, in _execute_context
cursor, statement, parameters, context
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/default.py",
line 609, in do_execute
cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed:
internaltipanswers.internaltip_id, internaltipanswers.questionnaire_hash
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/threadpool.py",
line 250, in inContext
result = inContext.theWork()
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/threadpool.py",
line 266, in
inContext.theWork = lambda: context.call(ctx, func, *args, **kw)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/context.py",
line 122, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/context.py",
line 85, in callWithContext
return func(*args,**kw)
File "/opt/globaleaks/backend/globaleaks/orm.py", line 185, in _wrap
result = function(session, *args, **kwargs)
File "/opt/globaleaks/backend/globaleaks/handlers/wbtip.py", line 166, in
store_additional_questionnaire_answers
db_notify_recipients_of_tip_update(session, itip.id)
File "/opt/globaleaks/backend/globaleaks/handlers/wbtip.py", line 32, in
db_notify_recipients_of_tip_update
models.InternalTip.id == itip_id):
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/query.py",
line 3534, in *iter*
self.session._autoflush()
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 1633, in
*autoflush util.raise*(e, with_traceback=sys.exc_info()[2])
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 1622, in _autoflush
self.flush()
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2540, in flush
self._flush(objects)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2682, in _flush
transaction.rollback(_capture_exception=True)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 70, in *exit*
with_traceback=exc_tb,
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2642, in _flush
flush_context.execute()
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 422, in execute
rec.execute(self)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 589, in execute
uow,
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py",
line 245, in save_obj
insert,
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py",
line 1083, in _emit_insert_statements
c = cached_connections[connection].execute(statement, multiparams)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1011, in execute
return meth(self, multiparams, params)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py",
line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1130, in _execute_clauseelement
distilled_params,
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1317, in _execute_context
e, statement, parameters, cursor, context
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1511, in
*handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2],
from*=e
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1277, in _execute_context
cursor, statement, parameters, context
File
"/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/default.py",
line 609, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked
autoflush; consider using a session.no_autoflush block if this flush is
occurring prematurely)
(sqlite3.IntegrityError) UNIQUE constraint failed:
internaltipanswers.internaltip_id, internaltipanswers.questionnaire_hash
[SQL: INSERT INTO internaltipanswers (internaltip_id, questionnaire_hash,
creation_date, answers) VALUES (?, ?, ?, ?)]
[parameters: ('db9192a5-0663-4ba8-b6c2-06cceb4e8294',
'9341cbb580c012d07347775352297462e9cbfe394002df69fa45a7c0ca9470a1',
'2024-06-30 07:56:22.499319',
'"+yAlcVAj1orCA37EnO0jbvQ6Kw4E8TB3vHfVSQbvmVtHOtFTaqa6po1G0P2U4JTUjE26ZwyCx5pytk8pLeh2s4jAuatQvFGAE+WQh9dFOvF5kpTDeM4MSAV+LHtB4YPcJeCDiPU6EbXfY1H2b+Do
... (340 characters truncated) ...
D/KeZjhnD8ODBBoCJBlvW+Q0dIjgTpObaLxfShHtmZXv3iWsnfR/DyUBboEZlIPEEX9DOR3O2vPPgYLuf2X+A0jQhtbyw7vT0P1Q5qDbYk24r313jT0RFSw+kPvf0Z5cqBX8Rbpn0cDzfNup3A=="')]_
—
Reply to this email directly, view it on GitHub
<#4122>, or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AABU7SXWWFCGAZQCDTBGDFLZKEYXLAVCNFSM6AAAAABKFKMMQKVHI2DSMVQWIX3LMV43ERDJONRXK43TNFXW4OZWHA4DKMRVGM>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Thanks a lot! |
Beta Was this translation helpful? Give feedback.
Answer selected by
S03M
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi,
recently, using GlobaLeaks v.4.10.18, without making any modifications, we have received an error when inserting a value in the internaltipanswers table, as you can see below. This error has generated a series of 7 alerts that have arrived in the form of email, all with the same data.
Does anyone knows the function of this table and have any idea why this could be happennig?
We have tried to reproduce it in many ways but no results.
Thanks!
_sqlalchemy.exc.IntegrityError Wraps a DB-API IntegrityError.
Traceback (most recent call last):
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: internaltipanswers.internaltip_id, internaltipanswers.questionnaire_hash
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/threadpool.py", line 250, in inContext
result = inContext.theWork()
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/threadpool.py", line 266, in
inContext.theWork = lambda: context.call(ctx, func, *args, **kw)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/context.py", line 122, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/twisted/python/context.py", line 85, in callWithContext
return func(*args,**kw)
File "/opt/globaleaks/backend/globaleaks/orm.py", line 185, in _wrap
result = function(session, *args, **kwargs)
File "/opt/globaleaks/backend/globaleaks/handlers/wbtip.py", line 166, in store_additional_questionnaire_answers
db_notify_recipients_of_tip_update(session, itip.id)
File "/opt/globaleaks/backend/globaleaks/handlers/wbtip.py", line 32, in db_notify_recipients_of_tip_update
models.InternalTip.id == itip_id):
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3534, in iter
self.session._autoflush()
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 1633, in autoflush
util.raise(e, with_traceback=sys.exc_info()[2])
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 1622, in _autoflush
self.flush()
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2540, in flush
self._flush(objects)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2682, in _flush
transaction.rollback(_capture_exception=True)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit
with_traceback=exc_tb,
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2642, in _flush
flush_context.execute()
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
uow,
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
insert,
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1083, in _emit_insert_statements
c = cached_connections[connection].execute(statement, multiparams)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/opt/globaleaks/backend/env/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(sqlite3.IntegrityError) UNIQUE constraint failed: internaltipanswers.internaltip_id, internaltipanswers.questionnaire_hash
[SQL: INSERT INTO internaltipanswers (internaltip_id, questionnaire_hash, creation_date, answers) VALUES (?, ?, ?, ?)]
[parameters: ('db9192a5-0663-4ba8-b6c2-06cceb4e8294', '9341cbb580c012d07347775352297462e9cbfe394002df69fa45a7c0ca9470a1', '2024-06-30 07:56:22.499319', '"+yAlcVAj1orCA37EnO0jbvQ6Kw4E8TB3vHfVSQbvmVtHOtFTaqa6po1G0P2U4JTUjE26ZwyCx5pytk8pLeh2s4jAuatQvFGAE+WQh9dFOvF5kpTDeM4MSAV+LHtB4YPcJeCDiPU6EbXfY1H2b+Do ... (340 characters truncated) ... D/KeZjhnD8ODBBoCJBlvW+Q0dIjgTpObaLxfShHtmZXv3iWsnfR/DyUBboEZlIPEEX9DOR3O2vPPgYLuf2X+A0jQhtbyw7vT0P1Q5qDbYk24r313jT0RFSw+kPvf0Z5cqBX8Rbpn0cDzfNup3A=="')]_
Beta Was this translation helpful? Give feedback.
All reactions