Skip to content
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.

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

Issue getting through backfill #26

Open
robcxyz opened this issue Feb 16, 2022 · 0 comments
Open

Issue getting through backfill #26

robcxyz opened this issue Feb 16, 2022 · 0 comments
Assignees

Comments

@robcxyz
Copy link
Contributor

robcxyz commented Feb 16, 2022

From ES, right before crash.

{"timestamp": 1645048136.92667, "message": "set delegation 0x6aad8a13c15caaf4721eb89ee0794ee9fe806e5773218056e0e6977fbb255924"}
13:48:56.936
/opt/icon_governance/workers/delegations.py:57: SAWarning: DELETE statement on table "delegations" expected to delete 6 row(s); 0 were matched.  Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.
13:48:56.936
  session.commit()
13:48:56.941
Traceback (most recent call last):
13:48:56.941
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
13:48:56.941
    self.dialect.do_execute(
13:48:56.941
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
13:48:56.941
    cursor.execute(statement, parameters)
13:48:56.941
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "delegations_pkey"
13:48:56.941
DETAIL:  Key (address, prep_address)=(hx17b32b10810eeb06ba2e9771620a635cba3fee5e, hx9121c5914ce34f59de52fe15efd6f7982c2ab8ae) already exists.
13:48:56.941
13:48:56.941
13:48:56.941
The above exception was the direct cause of the following exception:
13:48:56.941
13:48:56.941
Traceback (most recent call last):
13:48:56.941
  File "/opt/icon_governance/main_worker.py", line 79, in <module>
13:48:56.941
    main(args.worker_type)
13:48:56.941
  File "/opt/icon_governance/main_worker.py", line 32, in main
13:48:56.941
    transactions_worker_tail()
13:48:56.941
  File "/opt/icon_governance/workers/transactions.py", line 191, in transactions_worker_tail
13:48:56.942
    kafka.start()
13:48:56.942
  File "/opt/icon_governance/workers/kafka.py", line 186, in start
13:48:56.942
    self.process(msg)
13:48:56.942
  File "/opt/icon_governance/workers/transactions.py", line 146, in process
13:48:56.942
    set_delegation(
13:48:56.942
  File "/opt/icon_governance/workers/delegations.py", line 68, in set_delegation
13:48:56.942
    session.commit()
13:48:56.942
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1431, in commit
13:48:56.942
    self._transaction.commit(_to_root=self.future)
13:48:56.942
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
13:48:56.943
    self._prepare_impl()
13:48:56.943
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
13:48:56.943
    self.session.flush()
13:48:56.943
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3363, in flush
13:48:56.944
    self._flush(objects)
13:48:56.944
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3503, in _flush
13:48:56.944
    transaction.rollback(_capture_exception=True)
13:48:56.944
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
13:48:56.945
    compat.raise_(
13:48:56.945
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
13:48:56.945
    raise exception
13:48:56.945
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3463, in _flush
13:48:56.945
    flush_context.execute()
13:48:56.945
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
13:48:56.946
    rec.execute(self)
13:48:56.946
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
13:48:56.946
    util.preloaded.orm_persistence.save_obj(
13:48:56.946
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 244, in save_obj
13:48:56.946
    _emit_insert_statements(
13:48:56.946
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1096, in _emit_insert_statements
13:48:56.946
    c = connection._execute_20(
13:48:56.946
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1614, in _execute_20
13:48:56.947
    return meth(self, args_10style, kwargs_10style, execution_options)
13:48:56.947
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
13:48:56.947
    return connection._execute_clauseelement(
13:48:56.947
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1481, in _execute_clauseelement
13:48:56.947
    ret = self._execute_context(
13:48:56.947
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context
13:48:56.948
    self._handle_dbapi_exception(
13:48:56.948
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception
13:48:56.948
    util.raise_(
13:48:56.948
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
13:48:56.948
    raise exception
13:48:56.948
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
13:48:56.949
    self.dialect.do_execute(
13:48:56.949
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
13:48:56.949
    cursor.execute(statement, parameters)
13:48:56.949
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "delegations_pkey"
13:48:56.949
DETAIL:  Key (address, prep_address)=(hx17b32b10810eeb06ba2e9771620a635cba3fee5e, hx9121c5914ce34f59de52fe15efd6f7982c2ab8ae) already exists.
13:48:56.949
13:48:56.949
[SQL: INSERT INTO delegations (address, prep_address, value, last_updated_block) VALUES (%(address)s, %(prep_address)s, %(value)s, %(last_updated_block)s)]
13:48:56.949
[parameters: {"address": "hx17b32b10810eeb06ba2e9771620a635cba3fee5e", "prep_address": "hx9121c5914ce34f59de52fe15efd6f7982c2ab8ae", "value": Decimal("613998545468626300000"), "last_updated_block": 34002745}]
13:48:56.949
(Background on this error at: https://sqlalche.me/e/14/gkpj)
13:48:56.949
    self.dialect.do_execute(
13:48:56.949
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
13:48:56.949
    cursor.execute(statement, parameters)
13:48:56.949
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "delegations_pkey"
13:48:56.949
DETAIL:  Key (address, prep_address)=(hx17b32b10810eeb06ba2e9771620a635cba3fee5e, hx9121c5914ce34f59de52fe15efd6f7982c2ab8ae) already exists.
13:48:56.949
13:48:56.949
[SQL: INSERT INTO delegations (address, prep_address, value, last_updated_block) VALUES (%(address)s, %(prep_address)s, %(value)s, %(last_updated_block)s)]
13:48:56.949
[parameters: {"address": "hx17b32b10810eeb06ba2e9771620a635cba3fee5e", "prep_address": "hx9121c5914ce34f59de52fe15efd6f7982c2ab8ae", "value": Decimal("613998545468626300000"), "last_updated_block": 34002745}]
13:48:56.949
(Background on this error at: https://sqlalche.me/e/14/gkpj)
@robcxyz robcxyz self-assigned this Feb 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant