hivemind not working in docker
Using the latest develop branch with the recent potential fix in Dockerfile (not using pip3), hivemind still doesn't work when trying to synch it from scratch with a fresh postgres database. It keeps crashing and restarting without processing any blocks. It's also curious showing database_head_block : 23376000
!
hivemind-eclipse | postgres:5432 - accepting connections
hivemind-eclipse | hivemind: starting sync
hivemind-eclipse | hivemind: starting server
hivemind-eclipse | INFO:root:Used command line args: server
hivemind-eclipse | INFO:root:Used command line args: sync
hivemind-eclipse | INFO:hive.indexer.sync:Using hived url: `{"default":"http://192.168.2.200:8190"}'
hivemind-eclipse | INFO:hive.steem.client:Endpoint default will be routed to node http://192.168.2.200:8190
hivemind-eclipse | INFO:hive.steem.http_client:using node: http://192.168.2.200:8190
hivemind-eclipse | INFO:hive.indexer.sync:hivemind_version : 0.0.1
hivemind-eclipse | INFO:hive.indexer.sync:hivemind_git_rev : 437b7ac
hivemind-eclipse | INFO:hive.indexer.sync:database_schema_version : 18
hivemind-eclipse | INFO:hive.db.db_state:[INIT] Welcome to hive!
hivemind-eclipse | INFO:hive.db.db_state:[INIT] Create db schema...
hivemind-eclipse | WARNING:hive.db.adapter:[SQL-ERR] ProgrammingError in query ALTER TABLE hive_accounts SET (autovacuum_vacuum_scale_factor = 0,
hivemind-eclipse | autovacuum_vacuum_threshold = 50000,
hivemind-eclipse | autovacuum_analyze_scale_factor = 0,
hivemind-eclipse | autovacuum_analyze_threshold = 100000) ({})
hivemind-eclipse | Traceback (most recent call last):
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1277, in _execute_context
hivemind-eclipse | cursor, statement, parameters, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
hivemind-eclipse | cursor.execute(statement, parameters)
hivemind-eclipse | psycopg2.errors.UndefinedTable: relation "hive_accounts" does not exist
hivemind-eclipse |
hivemind-eclipse |
hivemind-eclipse | The above exception was the direct cause of the following exception:
hivemind-eclipse |
hivemind-eclipse | Traceback (most recent call last):
hivemind-eclipse | File "/usr/local/bin/hive", line 11, in <module>
hivemind-eclipse | load_entry_point('hivemind==0.0.1+437b7ac', 'console_scripts', 'hive')()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/cli.py", line 42, in run
hivemind-eclipse | launch_mode(mode, conf)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/cli.py", line 52, in launch_mode
hivemind-eclipse | Sync(conf=conf).run()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/indexer/sync.py", line 232, in run
hivemind-eclipse | DbState.initialize()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/db_state.py", line 52, in initialize
hivemind-eclipse | setup(cls.db())
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/schema.py", line 448, in setup
hivemind-eclipse | reset_autovac(db)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/schema.py", line 2238, in reset_autovac
hivemind-eclipse | db.query(sql % (table, n_vacuum, n_analyze))
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 82, in query
hivemind-eclipse | return self._query(sql, **kwargs)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 193, in _query
hivemind-eclipse | raise e
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 185, in _query
hivemind-eclipse | result = self._exec(query, **kwargs)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1011, in execute
hivemind-eclipse | return meth(self, multiparams, params)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
hivemind-eclipse | return connection._execute_clauseelement(self, multiparams, params)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
hivemind-eclipse | distilled_params,
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1317, in _execute_context
hivemind-eclipse | e, statement, parameters, cursor, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
hivemind-eclipse | sqlalchemy_exception, with_traceback=exc_info[2], from_=e
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/util/compat.py", line 182, in raise_
hivemind-eclipse | raise exception
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1277, in _execute_context
hivemind-eclipse | cursor, statement, parameters, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
hivemind-eclipse | cursor.execute(statement, parameters)
hivemind-eclipse | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "hive_accounts" does not exist
hivemind-eclipse |
hivemind-eclipse | [SQL: ALTER TABLE hive_accounts SET (autovacuum_vacuum_scale_factor = 0,
hivemind-eclipse | autovacuum_vacuum_threshold = 50000,
hivemind-eclipse | autovacuum_analyze_scale_factor = 0,
hivemind-eclipse | autovacuum_analyze_threshold = 100000)]
hivemind-eclipse | (Background on this error at: http://sqlalche.me/e/13/f405)
hivemind-eclipse | WARNING:aiocache.serializers.serializers:msgpack not installed, MsgPackSerializer unavailable
hivemind-eclipse | INFO:aiocache:aioredis not installed, RedisCache unavailable
hivemind-eclipse | INFO:aiocache:aiomcache not installed, Memcached unavailable
hivemind-eclipse | INFO:hive.server.serve:hivemind_version : 0.0.1
hivemind-eclipse | INFO:hive.server.serve:hivemind_git_rev : 437b7ac
hivemind-eclipse | INFO:hive.server.serve:database_schema_version : 18
hivemind-eclipse | INFO:hive.server.serve:database_head_block : 23376000
hivemind-eclipse | NOTIFYALERT! hivemindsync quit unexpectedly, restarting hive sync...
hivemind-eclipse | INFO:root:Used command line args: sync
hivemind-eclipse | INFO:hive.indexer.sync:Using hived url: `{"default":"http://192.168.2.200:8190"}'
hivemind-eclipse | INFO:hive.steem.client:Endpoint default will be routed to node http://192.168.2.200:8190
hivemind-eclipse | INFO:hive.steem.http_client:using node: http://192.168.2.200:8190
hivemind-eclipse | INFO:hive.indexer.sync:hivemind_version : 0.0.1
hivemind-eclipse | INFO:hive.indexer.sync:hivemind_git_rev : 437b7ac
hivemind-eclipse | INFO:hive.indexer.sync:database_schema_version : 18
hivemind-eclipse | INFO:hive.db.db_state:[INIT] Welcome to hive!
hivemind-eclipse | INFO:hive.db.db_state:[HIVE] db version: 18
hivemind-eclipse | INFO:hive.db.db_state:[INIT] Continue with initial sync...
hivemind-eclipse | WARNING:hive.db.adapter:[SQL-ERR] ProgrammingError in query SELECT update_communities_posts_data_and_rank() ({})
hivemind-eclipse | Traceback (most recent call last):
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1277, in _execute_context
hivemind-eclipse | cursor, statement, parameters, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
hivemind-eclipse | cursor.execute(statement, parameters)
hivemind-eclipse | psycopg2.errors.UndefinedFunction: function update_communities_posts_data_and_rank() does not exist
hivemind-eclipse | LINE 1: SELECT update_communities_posts_data_and_rank()
hivemind-eclipse | ^
hivemind-eclipse | HINT: No function matches the given name and argument types. You might need to add explicit type casts.
hivemind-eclipse |
hivemind-eclipse |
hivemind-eclipse | The above exception was the direct cause of the following exception:
hivemind-eclipse |
hivemind-eclipse | Traceback (most recent call last):
hivemind-eclipse | File "/usr/local/bin/hive", line 11, in <module>
hivemind-eclipse | load_entry_point('hivemind==0.0.1+437b7ac', 'console_scripts', 'hive')()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/cli.py", line 42, in run
hivemind-eclipse | launch_mode(mode, conf)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/cli.py", line 52, in launch_mode
hivemind-eclipse | Sync(conf=conf).run()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/indexer/sync.py", line 245, in run
hivemind-eclipse | update_communities_posts_and_rank()
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/utils/communities_rank.py", line 7, in update_communities_posts_and_rank
hivemind-eclipse | DB.query_no_return(sql)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 85, in query_no_return
hivemind-eclipse | self._query(sql, **kwargs)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 193, in _query
hivemind-eclipse | raise e
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/hivemind-0.0.1+437b7ac-py3.6.egg/hive/db/adapter.py", line 185, in _query
hivemind-eclipse | result = self._exec(query, **kwargs)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1011, in execute
hivemind-eclipse | return meth(self, multiparams, params)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
hivemind-eclipse | return connection._execute_clauseelement(self, multiparams, params)
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
hivemind-eclipse | distilled_params,
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1317, in _execute_context
hivemind-eclipse | e, statement, parameters, cursor, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
hivemind-eclipse | sqlalchemy_exception, with_traceback=exc_info[2], from_=e
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/util/compat.py", line 182, in raise_
hivemind-eclipse | raise exception
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1277, in _execute_context
hivemind-eclipse | cursor, statement, parameters, context
hivemind-eclipse | File "/root/.local/lib/python3.6/site-packages/SQLAlchemy-1.3.19-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
hivemind-eclipse | cursor.execute(statement, parameters)
hivemind-eclipse | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) function update_communities_posts_data_and_rank() does not exist
hivemind-eclipse | LINE 1: SELECT update_communities_posts_data_and_rank()
hivemind-eclipse | ^
hivemind-eclipse | HINT: No function matches the given name and argument types. You might need to add explicit type casts.
hivemind-eclipse |
hivemind-eclipse | [SQL: SELECT update_communities_posts_data_and_rank()]
hivemind-eclipse | (Background on this error at: http://sqlalche.me/e/13/f405)