Hivemind docker doesn't start up
INFO - hive.conf:261 - The database is disconnected...
Traceback (most recent call last):
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.AmbiguousFunction: function hive.wait_for_ready_instance(interval) is not unique
LINE 1: SELECT hive.wait_for_ready_instance('178000000 years'::inter...
^
HINT: Could not choose a best candidate function. You might need to add explicit type casts.
QUERY: SELECT hive.wait_for_ready_instance('178000000 years'::interval)
CONTEXT: PL/pgSQL function hive.app_next_block_forking_app(hive.contexts_group) line 6 at PERFORM
PL/pgSQL function hive.app_next_block(hive.contexts_group) line 12 at RETURN
PL/pgSQL function hive.app_next_block(hive.context_name) line 3 at RETURN
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/hivemind/.hivemind-venv/bin/hive", line 8, in <module>
sys.exit(run())
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/cli.py", line 73, in run
launch_mode(mode, conf)
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/cli.py", line 87, in launch_mode
sync.run()
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/indexer/sync.py", line 102, in run
self._lbound, self._ubound = self._query_for_app_next_block()
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/indexer/sync.py", line 187, in _query_for_app_next_block
lbound, ubound = self._db.query_row(f"SELECT * FROM hive.app_next_block('{SCHEMA_NAME}')")
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/db/adapter.py", line 175, in query_row
res = self._query(sql, **kwargs)
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/db/adapter.py", line 276, in _query
raise e
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/hive/db/adapter.py", line 269, in _query
result = self._basic_connection.execution_options(autocommit=False).execute(query, **kwargs)
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1385, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
ret = self._execute_context(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
self._handle_dbapi_exception(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
util.raise_(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "/home/hivemind/.hivemind-venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.AmbiguousFunction) function hive.wait_for_ready_instance(interval) is not unique
LINE 1: SELECT hive.wait_for_ready_instance('178000000 years'::inter...
^
HINT: Could not choose a best candidate function. You might need to add explicit type casts.
QUERY: SELECT hive.wait_for_ready_instance('178000000 years'::interval)
CONTEXT: PL/pgSQL function hive.app_next_block_forking_app(hive.contexts_group) line 6 at PERFORM
PL/pgSQL function hive.app_next_block(hive.contexts_group) line 12 at RETURN
PL/pgSQL function hive.app_next_block(hive.context_name) line 3 at RETURN
[SQL: SELECT * FROM hive.app_next_block('hivemind_app')]
(Background on this error at: https://sqlalche.me/e/14/f405)
Edited by Mahdi Yari