haf-block-explorer-install stalled during re-execution
- docker compose with hafbe profile
- docker compose down block-explorer-block-processing
- docker compose up -d block-explorer-block-processing
haf-world-block-explorer-install-1 got stuck on:
DROP SCHEMA IF EXISTS hafbe_views CASCADE;
syncad@shed14:~$ docker logs -f haf-world-block-explorer-install-1
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:10: NOTICE: role "hafbe_owner" already exists, skipping
DO
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:12: NOTICE: role "hafbe_owner" is already a member of role "btracker_owner"
GRANT ROLE
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:13: NOTICE: role "hafbe_owner" is already a member of role "btracker_user"
GRANT ROLE
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:14: NOTICE: role "hafbe_owner" is already a member of role "hafbe_user"
GRANT ROLE
GRANT
SET
psql:/haf_block_explorer/scripts/../database/database_schema.sql:208: NOTICE: s chema "hafbe_app" already exists, skipping
DO
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE PROCEDURE
CREATE PROCEDURE
CREATE PROCEDURE
RESET
psql:/haf_block_explorer/scripts/../database/hafbe_app_indexes.sql:1: NOTICE: d rop cascades to 3 other objects
DETAIL: drop cascades to function hafbe_indexes.create_hafbe_indexes()
drop cascades to function hafbe_indexes.create_btracker_indexes()
drop cascades to function hafbe_indexes.do_haf_indexes_exist()
DROP SCHEMA
CREATE SCHEMA
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE PROCEDURE
RESET
SET
CREATE PROCEDURE
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
app_state_provider_import
---------------------------
(1 row)
GRANT
SET
psql:/haf_block_explorer/scripts/../backend/backend_schema.sql:32: NOTICE: sche ma "hafbe_backend" already exists, skipping
DO
RESET
psql:/haf_block_explorer/scripts/../backend/hafbe_exceptions.sql:1: NOTICE: sch ema "hafbe_exceptions" already exists, skipping
CREATE SCHEMA
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:3: NOTICE: schema "hafbe_types" already exists, skipping
CREATE SCHEMA
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:5: NOTICE: drop cascades to 6 other objects
DETAIL: drop cascades to function hafbe_backend.get_block_by_single_op(integer, text,hafbe_types.order_is,integer,integer,integer,text[],json)
drop cascades to function hafbe_backend.get_block_by_ops_group_by_block_num(inte ger[],text,hafbe_types.order_is,integer,integer,integer)
drop cascades to function hafbe_endpoints.get_block_by_op(integer[],text,hafbe_t ypes.order_is,integer,integer,timestamp without time zone,timestamp without time zone,integer,text[],json)
drop cascades to function hafbe_endpoints.get_witness_voters(text,hafbe_types.or der_by_votes,hafbe_types.order_is,integer)
drop cascades to function hafbe_endpoints.get_witness_votes_history(text,hafbe_t ypes.order_by_votes,hafbe_types.order_is,integer,timestamp without time zone,tim estamp without time zone)
drop cascades to function hafbe_endpoints.get_witnesses(integer,integer,hafbe_ty pes.order_by_witness,hafbe_types.order_is)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:43: NOTICE: drop cascades to function hafbe_backend.get_last_post_vote_time(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:52: NOTICE: drop cascades to function hafbe_backend.get_account_parameters(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:62: NOTICE: drop cascades to function hafbe_backend.get_account_votes(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:70: NOTICE: drop cascades to function hafbe_backend.get_json_metadata(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:77: NOTICE: drop cascades to function hafbe_backend.operation_body_filter(jsonb,bigint,inte ger)
DROP TYPE
CREATE TYPE
RESET
SET
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:3: NOTICE: drop cascades to 4 other objects
DETAIL: drop cascades to function hafbe_endpoints.get_matching_operation_types( text)
drop cascades to function hafbe_endpoints.get_op_types()
drop cascades to function hafbe_endpoints.get_acc_op_types(text)
drop cascades to function hafbe_endpoints.get_block_op_types(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:10: NOTICE: drop cascades to function hafbe_endpoints.get_account(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:55: NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to function hafbe_backend.get_ops_by_account(text,integer ,integer,integer[],timestamp without time zone,timestamp without time zone,integ er)
drop cascades to function hafbe_endpoints.get_ops_by_block(integer,bigint,intege r,smallint[],integer)
drop cascades to function hafbe_endpoints.get_operation(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:70: NOTICE: drop cascades to function hafbe_endpoints.get_block(integer)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:117: NOTICE : drop cascades to function hafbe_endpoints.get_witness(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:136: NOTICE : drop cascades to function hafbe_endpoints.get_transaction(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:143: NOTICE : drop cascades to function hafbe_endpoints.get_latest_blocks(integer)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:156: NOTICE : drop cascades to function hafbe_backend.get_comment_operations(text,text,inte ger,integer,integer[],integer,integer,integer)
DROP TYPE
CREATE TYPE
RESET
psql:/haf_block_explorer/scripts/../backend/hafbe_views.sql:4: NOTICE: drop cas cades to 18 other objects
DETAIL: drop cascades to view hafbe_views.witness_prop_op_view
drop cascades to view hafbe_views.recursive_account_proxies_view
drop cascades to view hafbe_views.recursive_account_proxies_stats_view
drop cascades to view hafbe_views.witness_voters_vests_view
drop cascades to view hafbe_views.current_witness_votes_view
drop cascades to view hafbe_views.voters_proxied_vests_view
drop cascades to view hafbe_views.voters_proxied_vests_sum_view
drop cascades to view hafbe_views.voters_stats_view
drop cascades to view hafbe_views.voters_approve_vests_change_view
drop cascades to view hafbe_views.voters_proxy_vests_change_view
drop cascades to view hafbe_views.comments_view
drop cascades to view hafbe_views.votes_view
drop cascades to view hafbe_views.pow_view
drop cascades to view hafbe_views.pow_two_view
drop cascades to view hafbe_views.deleted_comments_view
drop cascades to view hafbe_views.voters_stats_change_view
drop cascades to view hafbe_views.time_logs_view
drop cascades to view hafbe_views.votes_history_view
DROP SCHEMA
SET
CREATE SCHEMA
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
CREATE VIEW
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
CREATE FUNCTION
CREATE FUNCTION
SET
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
psql:/haf_block_explorer/scripts/../account_dump/account_stats_hafbe.sql:28: NOT ICE: drop cascades to 2 other objects
DETAIL: drop cascades to function hafbe_backend.get_account_setof(text)
drop cascades to function hafbe_backend.compare_differing_account(text)
DROP TYPE
CREATE TYPE
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
psql:/haf_block_explorer/scripts/../endpoints/get_account.sql:3: NOTICE: schema "hafbe_endpoints" already exists, skipping
CREATE SCHEMA
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
psql:/haf_block_explorer/scripts/../backend/hafbe_roles.sql:36: NOTICE: role "h afbe_owner" is already a member of role "hafbe_user"
GRANT ROLE
TRUNCATE TABLE
INSERT 0 1
HAF indexes already exist, skipping creation
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:10: NOTICE: role "hafbe_owner" already exists, skipping
DO
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:12: NOTICE: role "hafbe_owner" is already a member of role "btracker_owner"
GRANT ROLE
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:13: NOTICE: role "hafbe_owner" is already a member of role "btracker_user"
GRANT ROLE
psql:/haf_block_explorer/scripts/../database/builtin_roles.sql:14: NOTICE: role "hafbe_owner" is already a member of role "hafbe_user"
GRANT ROLE
GRANT
SET
psql:/haf_block_explorer/scripts/../database/database_schema.sql:208: NOTICE: s chema "hafbe_app" already exists, skipping
DO
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE PROCEDURE
CREATE PROCEDURE
CREATE PROCEDURE
RESET
psql:/haf_block_explorer/scripts/../database/hafbe_app_indexes.sql:1: NOTICE: d rop cascades to 3 other objects
DETAIL: drop cascades to function hafbe_indexes.create_hafbe_indexes()
drop cascades to function hafbe_indexes.create_btracker_indexes()
drop cascades to function hafbe_indexes.do_haf_indexes_exist()
DROP SCHEMA
CREATE SCHEMA
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE PROCEDURE
RESET
SET
CREATE PROCEDURE
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
app_state_provider_import
---------------------------
(1 row)
GRANT
SET
psql:/haf_block_explorer/scripts/../backend/backend_schema.sql:32: NOTICE: sche ma "hafbe_backend" already exists, skipping
DO
RESET
psql:/haf_block_explorer/scripts/../backend/hafbe_exceptions.sql:1: NOTICE: sch ema "hafbe_exceptions" already exists, skipping
CREATE SCHEMA
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
RESET
SET
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:3: NOTICE: schema "hafbe_types" already exists, skipping
CREATE SCHEMA
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:5: NOTICE: drop cascades to 6 other objects
DETAIL: drop cascades to function hafbe_backend.get_block_by_single_op(integer, text,hafbe_types.order_is,integer,integer,integer,text[],json)
drop cascades to function hafbe_backend.get_block_by_ops_group_by_block_num(inte ger[],text,hafbe_types.order_is,integer,integer,integer)
drop cascades to function hafbe_endpoints.get_block_by_op(integer[],text,hafbe_t ypes.order_is,integer,integer,timestamp without time zone,timestamp without time zone,integer,text[],json)
drop cascades to function hafbe_endpoints.get_witness_voters(text,hafbe_types.or der_by_votes,hafbe_types.order_is,integer)
drop cascades to function hafbe_endpoints.get_witness_votes_history(text,hafbe_t ypes.order_by_votes,hafbe_types.order_is,integer,timestamp without time zone,tim estamp without time zone)
drop cascades to function hafbe_endpoints.get_witnesses(integer,integer,hafbe_ty pes.order_by_witness,hafbe_types.order_is)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:43: NOTICE: drop cascades to function hafbe_backend.get_last_post_vote_time(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:52: NOTICE: drop cascades to function hafbe_backend.get_account_parameters(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:62: NOTICE: drop cascades to function hafbe_backend.get_account_votes(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:70: NOTICE: drop cascades to function hafbe_backend.get_json_metadata(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_backend_types.sql:77: NOTICE: drop cascades to function hafbe_backend.operation_body_filter(jsonb,bigint,inte ger)
DROP TYPE
CREATE TYPE
RESET
SET
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:3: NOTICE: drop cascades to 4 other objects
DETAIL: drop cascades to function hafbe_endpoints.get_matching_operation_types( text)
drop cascades to function hafbe_endpoints.get_op_types()
drop cascades to function hafbe_endpoints.get_acc_op_types(text)
drop cascades to function hafbe_endpoints.get_block_op_types(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:10: NOTICE: drop cascades to function hafbe_endpoints.get_account(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:55: NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to function hafbe_backend.get_ops_by_account(text,integer ,integer,integer[],timestamp without time zone,timestamp without time zone,integ er)
drop cascades to function hafbe_endpoints.get_ops_by_block(integer,bigint,intege r,smallint[],integer)
drop cascades to function hafbe_endpoints.get_operation(integer)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:70: NOTICE: drop cascades to function hafbe_endpoints.get_block(integer)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:117: NOTICE : drop cascades to function hafbe_endpoints.get_witness(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:136: NOTICE : drop cascades to function hafbe_endpoints.get_transaction(text)
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:143: NOTICE : drop cascades to function hafbe_endpoints.get_latest_blocks(integer)
DROP TYPE
CREATE TYPE
DROP TYPE
CREATE TYPE
psql:/haf_block_explorer/scripts/../backend/hafbe_endpoint_types.sql:156: NOTICE : drop cascades to function hafbe_backend.get_comment_operations(text,text,inte ger,integer,integer[],integer,integer,integer)
DROP TYPE
CREATE TYPE
RESET
^C