Broke the hivemind (2025-12-15)
I was pulling the steemit/hivemind:latest but unfortunately something is not right, the hivemind failed to sync.
logs
ERROR:aiohttp.server:Error handling request
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/aiohttp/web_protocol.py", line 332, in data_received
messages, upgraded, tail = self._request_parser.feed_data(data)
File "aiohttp/_http_parser.pyx", line 557, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: 400, message:
Invalid method encountered:
b'\x16\x03\x01'
^
INFO:jsonrpcserver.dispatcher.request:{"jsonrpc":"2.0","id":0,"method":"hive.db_head_state","params":{}}
INFO:jsonrpcserver.dispatcher.response:{"jsonrpc": "2.0", "result": {"db_head_block": 102032275, "db_head_time": "2025-12-25 19:14:18", "db_head_age": 11929}, "id": 0}
INFO:jsonrpcserver.dispatcher.request:{"jsonrpc":"2.0","id":0,"method":"hive.db_head_state","params":{}}
INFO:jsonrpcserver.dispatcher.response:{"jsonrpc": "2.0", "result": {"db_head_block": 102032275, "db_head_time": "2025-12-25 19:14:18", "db_head_age": 11936}, "id": 0}
INFO:jsonrpcserver.dispatcher.request:{"jsonrpc":"2.0","id":0,"method":"hive.db_head_state","params":{}}
INFO:jsonrpcserver.dispatcher.response:{"jsonrpc": "2.0", "result": {"db_head_block": 102032275, "db_head_time": "2025-12-25 19:14:18", "db_head_age": 11937}, "id": 0}
NOTIFYALERT! hivemindsync quit unexpectedly, restarting hive sync...
INFO:root:loaded configuration:
Command Line Args: sync
Environment Variables:
DATABASE_URL: postgresql://steem:<redacted>@db:5432/hivedb
STEEMD_URL: https://api.steemit.com
REDIS_URL: redis://redis:6379
HTTP_SERVER_PORT: 8080
MAX_WORKERS: 2
MAX_BATCH: 50
LOG_LEVEL: DEBUG
Defaults:
mode: ['sync']
--muted-accounts-url:
--trail-blocks: 2
--sync-to-s3: False
--recommend-communities:hive-108451,hive-172186,hive-187187
--test-disable-sync:False
--test-profile: False
--txid-collector: False
--force-follow-recount:False
--debug-sql: False
INFO:hive.steem.http_client:using node: https://api.steemit.com
INFO:hive.db.db_state:[INIT] Welcome to hive!
WARNING:hive.db.adapter:[SQL-ERR] ProgrammingError in query CREATE INDEX CONCURRENTLY hive_posts_ix4_optimized ON hive_posts (parent_id, id) INCLUDE (author) WHERE is_deleted = '0' ({})
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1911, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.DuplicateTable: relation "hive_posts_ix4_optimized" already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/bin/hive", line 8, in <module>
sys.exit(run())
File "/usr/local/lib/python3.6/dist-packages/hive/cli.py", line 23, in run
launch_mode(mode, conf)
File "/usr/local/lib/python3.6/dist-packages/hive/cli.py", line 34, in launch_mode
Sync(conf=conf).run()
File "/usr/local/lib/python3.6/dist-packages/hive/indexer/sync.py", line 45, in run
DbState.initialize()
File "/usr/local/lib/python3.6/dist-packages/hive/db/db_state.py", line 44, in initialize
cls._check_migrations()
File "/usr/local/lib/python3.6/dist-packages/hive/db/db_state.py", line 341, in _check_migrations
cls.db().query("CREATE INDEX CONCURRENTLY hive_posts_ix4_optimized ON hive_posts (parent_id, id) INCLUDE (author) WHERE is_deleted = '0'")
File "/usr/local/lib/python3.6/dist-packages/hive/db/adapter.py", line 79, in query
return self._query(sql, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/hive/db/adapter.py", line 182, in _query
raise e
File "/usr/local/lib/python3.6/dist-packages/hive/db/adapter.py", line 176, in _query
result = self._exec(query, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1385, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/sql/elements.py", line 335, in _execute_on_connection
self, multiparams, params, execution_options
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1587, in _execute_clauseelement
cache_hit=cache_hit,
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1954, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2135, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1911, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.DuplicateTable) relation "hive_posts_ix4_optimized" already exists
[SQL: CREATE INDEX CONCURRENTLY hive_posts_ix4_optimized ON hive_posts (parent_id, id) INCLUDE (author) WHERE is_deleted = '0']
(Background on this error at: https://sqlalche.me/e/14/f405)
INFO:hive.utils.stats:cumtime 0s (0.7% of 0s). 0.0% idle. peak 39mb.
INFO:jsonrpcserver.dispatcher.request:{"jsonrpc":"2.0","id":0,"method":"hive.db_head_state","params":{}}
INFO:jsonrpcserver.dispatcher.response:{"jsonrpc": "2.0", "result": {"db_head_block": 102032275, "db_head_time": "2025-12-25 19:14:18", "db_head_age": 11943}, "id": 0}
INFO:jsonrpcserver.dispatcher.request:{"jsonrpc":"2.0","id":0,"method":"hive.db_head_state","params":{}}
INFO:jsonrpcserver.dispatcher.response:{"jsonrpc": "2.0", "result": {"db_head_block": 102032275, "db_head_time": "2025-12-25 19:14:18", "db_head_age": 11943}, "id": 0}
Steem to the Moon🚀!
- You can rent Steem Power via rentsp!
- You can swap the TRON:TRX/USDT/USDD to STEEM via tron2steem!
- You can swap the STEEM/SBD to SUI via steem2sui!
- You can swap the STEEM/SBD to SOL Solana via steem2sol!
- You can swap the STEEM/SBD to ETH Ethereum via steem2eth!
- You can swap the STEEM/SBD to Tether USDT (TRC-20) via steem2usdt!
- You can swap the STEEM/SBD to TRX (TRON) via steem2trx!
- You can swap the STEEM/SBD to BTS (BitShares) via steem2bts!
- Register a free STEEM account at SteemYY!
- Steem Block Explorer
- ChatGPT/Steem Integration: You can type !ask command to invoke ChatGPT
- Steem Witness Table and API
- Other Steem Tools
Support me, thank you!
Why you should vote me? My contributions
Please vote me as a witness or set me as a proxy via https://steemitwallet.com/~witnesses
