Continue to sync hivemind (while in massive sync) is "Dropping foreign keys" for significant amount of time
To reproduce: Hivemind sync (latest develop) while in massive sync was interrupted due to haf instance being down FATAL: the database system is shutting down
then resuming sync stops at Dropping foreign keys
(for more than half hour, exact time unknown):
INFO - hive.db.db_state:44 - [MASSIVE] Welcome to hive!
INFO - hive.db.db_state:55 - [MASSIVE] Continue with massive sync...
INFO - hive.indexer.sync:67 - hivemind_version : 2.0.0dev1
INFO - hive.indexer.sync:68 - hivemind_git_rev : c4e482f18053a47faa679592f9f8ba89e79e7581
INFO - hive.indexer.sync:69 - hivemind_git_date : 2023-10-13 11:47:42
INFO - hive.indexer.sync:71 - database_schema_version : 34
INFO - hive.indexer.sync:72 - database_patch_date : 2023-10-21 10:59:27.066849
INFO - hive.indexer.sync:73 - database_patched_to_revision : 9d2cc15bea71a39139abdf49569e0eac6dd0b970
INFO - hive.indexer.sync:75 - last_block_from_view : 0
INFO - hive.indexer.sync:76 - last_imported_block : 37525000
INFO - hive.indexer.sync:77 - last_completed_block : 1
INFO - hive.indexer.hive_db.haf_functions:37 - Trying to attach app context with block number: 37525000
INFO - hive.indexer.hive_db.haf_functions:39 - App context attaching done.
INFO - hive.indexer.sync:89 - Using HAF database as block data provider, pointed by url: 'postgresql://haf_app_admin@172.17.0.8:5432/haf_block_log'
INFO - hive.indexer.sync:99 - Last imported block is: 37525000
INFO - hive.indexer.sync:186 - Querying for next block for app context...
INFO - hive.indexer.sync:188 - Next block range from hive.app_next_block is: <None:None>
INFO - hive.indexer.sync:99 - Last imported block is: 37525000
INFO - hive.indexer.sync:186 - Querying for next block for app context...
INFO - hive.indexer.sync:188 - Next block range from hive.app_next_block is: <37525001:79520069>
INFO - hive.indexer.sync:117 - target_head_block: 79520069
INFO - hive.indexer.sync:118 - test_max_block: None
INFO - hive.indexer.sync:122 - [MASSIVE] *** MASSIVE blocks processing ***
INFO - hive.db.db_state:274 - Dropping foreign keys