Endless loop of reindexing
after a full resynch from scratch, hivemind goes into an endless loop of reindexing after that error: hivelog.txt
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1629, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 663, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "hive_notification_cache" does not exist
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/bin/hive", line 11, in <module>
load_entry_point('hivemind==0.0.1+b9058cd6', 'console_scripts', 'hive')()
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/cli.py", line 69, in run
launch_mode(mode, conf)
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/cli.py", line 79, in launch_mode
Sync(conf=conf).run()
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/indexer/sync.py", line 263, in run
DbState.finish_initial_sync(current_imported_block)
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/db/db_state.py", line 75, in finish_initial_sync
cls._after_initial_sync(current_imported_block)
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/db/db_state.py", line 255, in _after_initial_sync
cls.processing_indexes( False, force_index_rebuild, True )
File "/usr/local/lib/python3.6/dist-packages/hivemind-0.0.1+b9058cd6-py3.6.egg/hive/db/db_state.py", line 187, in processing_indexes
index.create(engine)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/sql/schema.py", line 3890, in create
bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2844, in _run_ddl_visitor
conn._run_ddl_visitor(visitorcallable, element, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1939, in _run_ddl_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/sql/visitors.py", line 486, in traverse_single
return meth(obj, **kw)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/sql/ddl.py", line 816, in visit_index
self.connection.execute(CreateIndex(index))
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1123, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/sql/ddl.py", line 78, in _execute_on_connection
self, multiparams, params, execution_options
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1219, in _execute_ddl
compiled,
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1672, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1853, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/util/compat.py", line 180, in raise_
raise exception
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1629, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.4.0b1-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 663, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "hive_notification_cache" does not exist
[SQL: CREATE INDEX hive_notification_cache_block_num_idx ON hive_notification_cache (block_num)]
Edited by Jolly Pirate