Skip to content

Instantly share code, notes, and snippets.

@ondratra
Created February 13, 2023 10:49
Show Gist options
  • Save ondratra/9d09466276fa21744f9ea7fb72d1f8cd to your computer and use it in GitHub Desktop.
Save ondratra/9d09466276fa21744f9ea7fb72d1f8cd to your computer and use it in GitHub Desktop.
Blockscout - docker log
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
2023-02-13T10:40:31.992 application=db_connection [error] Postgrex.Protocol (#PID<0.184.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
2023-02-13T10:40:31.992 application=db_connection [error] Postgrex.Protocol (#PID<0.185.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
2023-02-13T10:40:31.992 application=db_connection [error] Postgrex.Protocol (#PID<0.190.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
2023-02-13T10:40:31.992 application=db_connection [error] Postgrex.Protocol (#PID<0.189.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
2023-02-13T10:40:31.991 [error] GenServer #PID<0.197.0> terminating
** (DBConnection.ConnectionError) tcp recv (idle): closed
(db_connection 2.4.3) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
(connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol
Create Explorer.Repo.Account database if it doesn't exist
2023-02-13T10:40:32.000 [error] GenServer #PID<0.202.0> terminating
** (DBConnection.ConnectionError) tcp recv (idle): closed
(db_connection 2.4.3) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
(connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol
2023-02-13T10:40:32.000 [error] GenServer #PID<0.206.0> terminating
** (DBConnection.ConnectionError) tcp recv (idle): closed
(db_connection 2.4.3) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
(connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol
2023-02-13T10:40:32.001 [error] GenServer #PID<0.210.0> terminating
** (DBConnection.ConnectionError) tcp recv (idle): closed
(db_connection 2.4.3) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
(connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol
Running migrations for explorer
2023-02-13T10:40:33.037 application=db_connection [error] Postgrex.Protocol (#PID<0.189.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:33.468 application=db_connection [error] Postgrex.Protocol (#PID<0.190.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:34.109 application=db_connection [error] Postgrex.Protocol (#PID<0.184.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:34.446 application=db_connection [error] Postgrex.Protocol (#PID<0.185.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:34.979 application=ecto_sql [error] Could not create schema migrations table. This error usually happens due to the following:
** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2973ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:
1. Ensuring your database is available and that you can connect to it
2. Tracking down slow queries and making sure they are running fast enough
3. Increasing the pool_size (although this increases resource consumption)
4. Allowing requests to wait longer by increasing :queue_target and :queue_interval
See DBConnection.start_link/2 for more information
(ecto_sql 3.9.2) lib/ecto/adapters/sql.ex:913: Ecto.Adapters.SQL.raise_sql_call_error/1
(elixir 1.13.1) lib/enum.ex:1593: Enum."-map/2-lists^map/1-0-"/2
(ecto_sql 3.9.2) lib/ecto/adapters/sql.ex:1005: Ecto.Adapters.SQL.execute_ddl/4
(ecto_sql 3.9.2) lib/ecto/migrator.ex:677: Ecto.Migrator.verbose_schema_migration/3
(ecto_sql 3.9.2) lib/ecto/migrator.ex:491: Ecto.Migrator.lock_for_migrations/4
(ecto_sql 3.9.2) lib/ecto/migrator.ex:403: Ecto.Migrator.run/4
(elixir 1.13.1) lib/enum.ex:937: Enum."-each/2-lists^foreach/1-0-"/2
lib/release_tasks.ex:23: Explorer.ReleaseTasks.create_and_migrate/0
* The database does not exist
* The "schema_migrations" table, which Ecto uses for managing
migrations, was defined by another library
* There is a deadlock while migrating (such as using concurrent
indexes with a migration_lock)
To fix the first issue, run "mix ecto.create".
To address the second, you can run "mix ecto.drop" followed by
"mix ecto.create". Alternatively you may configure Ecto to use
another table and/or repository for managing migrations:
config :explorer, Explorer.Repo,
migration_source: "some_other_table_for_schema_migrations",
migration_repo: AnotherRepoForSchemaMigrations
The full error report is shown below.
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
2023-02-13T10:40:36.033 application=db_connection [error] Postgrex.Protocol (#PID<0.185.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:36.033 application=db_connection [error] Postgrex.Protocol (#PID<0.184.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:36.033 application=db_connection [error] Postgrex.Protocol (#PID<0.189.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
2023-02-13T10:40:36.033 application=db_connection [error] Postgrex.Protocol (#PID<0.190.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "blockscout" does not exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:40:38.940 application=ecto_sql [info] == Running 20180117221921 Explorer.Repo.Migrations.CreateAddress.change/0 forward
2023-02-13T10:40:38.940 application=ecto_sql [info] create table addresses
2023-02-13T10:40:38.950 application=ecto_sql [info] == Migrated 20180117221921 in 0.0s
2023-02-13T10:40:38.966 application=ecto_sql [info] == Running 20180117221922 Explorer.Repo.Migrations.CreateBlocks.change/0 forward
2023-02-13T10:40:38.966 application=ecto_sql [info] create table blocks
2023-02-13T10:40:38.974 application=ecto_sql [info] create index blocks_timestamp_index
2023-02-13T10:40:38.975 application=ecto_sql [info] create index one_consensus_child_per_parent
2023-02-13T10:40:38.976 application=ecto_sql [info] create index one_consensus_block_at_height
2023-02-13T10:40:38.977 application=ecto_sql [info] == Migrated 20180117221922 in 0.0s
2023-02-13T10:40:38.978 application=ecto_sql [info] == Running 20180117221923 Explorer.Repo.Migrations.CreateTransactions.change/0 forward
2023-02-13T10:40:38.978 application=ecto_sql [info] create table transactions
2023-02-13T10:40:38.981 application=ecto_sql [info] create check constraint collated_block_number on table transactions
2023-02-13T10:40:38.982 application=ecto_sql [info] create check constraint collated_cumalative_gas_used on table transactions
2023-02-13T10:40:38.982 application=ecto_sql [info] create check constraint collated_gas_used on table transactions
2023-02-13T10:40:38.982 application=ecto_sql [info] create check constraint collated_index on table transactions
2023-02-13T10:40:38.982 application=ecto_sql [info] create check constraint status on table transactions
2023-02-13T10:40:38.983 application=ecto_sql [info] create check constraint error on table transactions
2023-02-13T10:40:38.983 application=ecto_sql [info] create check constraint pending_block_number on table transactions
2023-02-13T10:40:38.983 application=ecto_sql [info] create check constraint pending_cumalative_gas_used on table transactions
2023-02-13T10:40:38.984 application=ecto_sql [info] create check constraint pending_gas_used on table transactions
2023-02-13T10:40:38.984 application=ecto_sql [info] create check constraint pending_index on table transactions
2023-02-13T10:40:38.984 application=ecto_sql [info] create index transactions_block_hash_index
2023-02-13T10:40:38.985 application=ecto_sql [info] create index transactions_inserted_at_index
2023-02-13T10:40:38.987 application=ecto_sql [info] create index transactions_updated_at_index
2023-02-13T10:40:38.988 application=ecto_sql [info] create index transactions_status_index
2023-02-13T10:40:38.989 application=ecto_sql [info] create index transactions_recent_collated_index
2023-02-13T10:40:38.990 application=ecto_sql [info] create index transactions_from_address_hash_recent_collated_index
2023-02-13T10:40:38.991 application=ecto_sql [info] create index transactions_to_address_hash_recent_collated_index
2023-02-13T10:40:38.992 application=ecto_sql [info] create index transactions_created_contract_address_hash_recent_collated_index
2023-02-13T10:40:38.994 application=ecto_sql [info] create index transactions_block_hash_index_index
2023-02-13T10:40:38.995 application=ecto_sql [info] == Migrated 20180117221923 in 0.0s
2023-02-13T10:40:38.996 application=ecto_sql [info] == Running 20180212222309 Explorer.Repo.Migrations.CreateLogs.change/0 forward
2023-02-13T10:40:38.996 application=ecto_sql [info] create table logs
2023-02-13T10:40:38.999 application=ecto_sql [info] create index logs_address_hash_index
2023-02-13T10:40:39.000 application=ecto_sql [info] create index logs_transaction_hash_index
2023-02-13T10:40:39.002 application=ecto_sql [info] create index logs_index_index
2023-02-13T10:40:39.003 application=ecto_sql [info] create index logs_type_index
2023-02-13T10:40:39.004 application=ecto_sql [info] create index logs_first_topic_index
2023-02-13T10:40:39.005 application=ecto_sql [info] create index logs_second_topic_index
2023-02-13T10:40:39.006 application=ecto_sql [info] create index logs_third_topic_index
2023-02-13T10:40:39.007 application=ecto_sql [info] create index logs_fourth_topic_index
2023-02-13T10:40:39.008 application=ecto_sql [info] create index logs_transaction_hash_index_index
2023-02-13T10:40:39.009 application=ecto_sql [info] == Migrated 20180212222309 in 0.0s
2023-02-13T10:40:39.010 application=ecto_sql [info] == Running 20180221001948 Explorer.Repo.Migrations.CreateInternalTransactions.change/0 forward
2023-02-13T10:40:39.011 application=ecto_sql [info] create table internal_transactions
2023-02-13T10:40:39.014 application=ecto_sql [info] create check constraint call_has_error_or_result on table internal_transactions
2023-02-13T10:40:39.014 application=ecto_sql [info] create check constraint create_has_error_or_result on table internal_transactions
2023-02-13T10:40:39.015 application=ecto_sql [info] create check constraint suicide_has_from_and_to_address_hashes on table internal_transactions
2023-02-13T10:40:39.015 application=ecto_sql [info] create index internal_transactions_created_contract_address_hash_index
2023-02-13T10:40:39.016 application=ecto_sql [info] create index internal_transactions_from_address_hash_index
2023-02-13T10:40:39.017 application=ecto_sql [info] create index internal_transactions_to_address_hash_index
2023-02-13T10:40:39.019 application=ecto_sql [info] create index internal_transactions_transaction_hash_index
2023-02-13T10:40:39.020 application=ecto_sql [info] create index internal_transactions_transaction_hash_index_index
2023-02-13T10:40:39.021 application=ecto_sql [info] == Migrated 20180221001948 in 0.0s
2023-02-13T10:40:39.022 application=ecto_sql [info] == Running 20180424203101 Explorer.Repo.Migrations.CreateMarketHistory.change/0 forward
2023-02-13T10:40:39.022 application=ecto_sql [info] create table market_history
2023-02-13T10:40:39.024 application=ecto_sql [info] create index market_history_date_index
2023-02-13T10:40:39.026 application=ecto_sql [info] == Migrated 20180424203101 in 0.0s
2023-02-13T10:40:39.027 application=ecto_sql [info] == Running 20180508183700 Explorer.Repo.Migrations.CreateUsers.change/0 forward
2023-02-13T10:40:39.027 application=ecto_sql [info] create table users
2023-02-13T10:40:39.029 application=ecto_sql [info] create index unique_username
2023-02-13T10:40:39.030 application=ecto_sql [info] == Migrated 20180508183700 in 0.0s
2023-02-13T10:40:39.031 application=ecto_sql [info] == Running 20180508191045 Explorer.Repo.Migrations.CreateUserContacts.change/0 forward
2023-02-13T10:40:39.031 application=ecto_sql [info] create table user_contacts
2023-02-13T10:40:39.033 application=ecto_sql [info] create index user_contacts_user_id_index
2023-02-13T10:40:39.034 application=ecto_sql [info] create index email_unique_for_user
2023-02-13T10:40:39.035 application=ecto_sql [info] create index one_primary_per_user
2023-02-13T10:40:39.037 application=ecto_sql [info] == Migrated 20180508191045 in 0.0s
2023-02-13T10:40:39.037 application=ecto_sql [info] == Running 20180518221256 Explorer.Repo.Migrations.CreateSmartContractVerified.change/0 forward
2023-02-13T10:40:39.038 application=ecto_sql [info] create table smart_contracts
2023-02-13T10:40:39.040 application=ecto_sql [info] create index smart_contracts_address_hash_index
2023-02-13T10:40:39.041 application=ecto_sql [info] == Migrated 20180518221256 in 0.0s
2023-02-13T10:40:39.043 application=ecto_sql [info] == Running 20180522154252 Explorer.Repo.Migrations.CreateBtreeGistExtension.change/0 forward
2023-02-13T10:40:39.043 application=ecto_sql [info] execute "CREATE EXTENSION IF NOT EXISTS btree_gist"
2023-02-13T10:40:39.062 application=ecto_sql [info] == Migrated 20180522154252 in 0.0s
2023-02-13T10:40:39.064 application=ecto_sql [info] == Running 20180522154253 Explorer.Repo.Migrations.CreateBlockRewards.change/0 forward
2023-02-13T10:40:39.064 application=ecto_sql [info] create table block_rewards
2023-02-13T10:40:39.065 application=ecto_sql [info] create exclude constraint no_overlapping_ranges on table block_rewards
2023-02-13T10:40:39.066 application=ecto_sql [info] == Migrated 20180522154253 in 0.0s
2023-02-13T10:40:39.067 application=ecto_sql [info] == Running 20180606135149 Explorer.Repo.Migrations.CreateTokens.change/0 forward
2023-02-13T10:40:39.067 application=ecto_sql [info] create table tokens
2023-02-13T10:40:39.068 application=ecto_sql [info] create index tokens_contract_address_hash_index
2023-02-13T10:40:39.070 application=ecto_sql [info] == Migrated 20180606135149 in 0.0s
2023-02-13T10:40:39.071 application=ecto_sql [info] == Running 20180606135150 Explorer.Repo.Migrations.CreateTokenTransfers.change/0 forward
2023-02-13T10:40:39.071 application=ecto_sql [info] create table token_transfers
2023-02-13T10:40:39.074 application=ecto_sql [info] create index token_transfers_transaction_hash_index
2023-02-13T10:40:39.075 application=ecto_sql [info] create index token_transfers_to_address_hash_transaction_hash_index
2023-02-13T10:40:39.076 application=ecto_sql [info] create index token_transfers_from_address_hash_transaction_hash_index
2023-02-13T10:40:39.077 application=ecto_sql [info] create index token_transfers_token_contract_address_hash_transaction_hash_index
2023-02-13T10:40:39.078 application=ecto_sql [info] create index token_transfers_transaction_hash_log_index_index
2023-02-13T10:40:39.079 application=ecto_sql [info] == Migrated 20180606135150 in 0.0s
2023-02-13T10:40:39.080 application=ecto_sql [info] == Running 20180626143840 Explorer.Repo.Migrations.AddInsertedAtIndexToBlocks.change/0 forward
2023-02-13T10:40:39.080 application=ecto_sql [info] create index blocks_inserted_at_index
2023-02-13T10:40:39.082 application=ecto_sql [info] == Migrated 20180626143840 in 0.0s
2023-02-13T10:40:39.083 application=ecto_sql [info] == Running 20180717204948 Explorer.Repo.Migrations.CreateCoinBalances.change/0 forward
2023-02-13T10:40:39.083 application=ecto_sql [info] create table address_coin_balances
2023-02-13T10:40:39.084 application=ecto_sql [info] create index address_coin_balances_address_hash_block_number_index
2023-02-13T10:40:39.085 application=ecto_sql [info] create index unfetched_balances
2023-02-13T10:40:39.087 application=ecto_sql [info] == Migrated 20180717204948 in 0.0s
2023-02-13T10:40:39.087 application=ecto_sql [info] == Running 20180817021704 Explorer.Repo.Migrations.CreateAddressTokenBalances.change/0 forward
2023-02-13T10:40:39.088 application=ecto_sql [info] create table address_token_balances
2023-02-13T10:40:39.090 application=ecto_sql [info] create index address_token_balances_address_hash_token_contract_address_hash_block_number_index
2023-02-13T10:40:39.092 application=ecto_sql [info] create index unfetched_token_balances
2023-02-13T10:40:39.093 application=ecto_sql [info] == Migrated 20180817021704 in 0.0s
2023-02-13T10:40:39.094 application=ecto_sql [info] == Running 20180821142139 Explorer.Repo.Migrations.CreateAddressNames.change/0 forward
2023-02-13T10:40:39.094 application=ecto_sql [info] create table address_names
2023-02-13T10:40:39.095 application=ecto_sql [info] create index address_names_address_hash_index
2023-02-13T10:40:39.097 application=ecto_sql [info] create index unique_address_names
2023-02-13T10:40:39.098 application=ecto_sql [info] execute "INSERT INTO address_names (address_hash, name, \"primary\", inserted_at, updated_at)\n (\n SELECT address_hash, name, true, NOW(), NOW()\n FROM smart_contracts WHERE name IS NOT NULL\n\n UNION\n\n SELECT contract_address_hash, name, false, NOW(), NOW()\n FROM tokens WHERE name IS NOT NULL\n );\n"
2023-02-13T10:40:39.098 application=ecto_sql [info] == Migrated 20180821142139 in 0.0s
2023-02-13T10:40:39.099 application=ecto_sql [info] == Running 20180917182319 Explorer.Repo.Migrations.CreateBlockSecondDegreeRelations.change/0 forward
2023-02-13T10:40:39.099 application=ecto_sql [info] create table block_second_degree_relations
2023-02-13T10:40:39.101 application=ecto_sql [info] create index nephew_hash_to_uncle_hash
2023-02-13T10:40:39.102 application=ecto_sql [info] create index unfetched_uncles
2023-02-13T10:40:39.103 application=ecto_sql [info] create index uncle_hash_to_nephew_hash
2023-02-13T10:40:39.105 application=ecto_sql [info] == Migrated 20180917182319 in 0.0s
2023-02-13T10:40:39.106 application=ecto_sql [info] == Running 20180918200001 Explorer.Repo.Migrations.CreateTransactionBlockUncles.change/0 forward
2023-02-13T10:40:39.106 application=ecto_sql [info] create table transaction_forks
2023-02-13T10:40:39.107 application=ecto_sql [info] create index transaction_forks_uncle_hash_index
2023-02-13T10:40:39.109 application=ecto_sql [info] create index transaction_forks_uncle_hash_index_index
2023-02-13T10:40:39.110 application=ecto_sql [info] == Migrated 20180918200001 in 0.0s
2023-02-13T10:40:39.111 application=ecto_sql [info] == Running 20180919175123 Explorer.Repo.Migrations.AlterTokenDecimalsToBigint.up/0 forward
2023-02-13T10:40:39.111 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.114 application=ecto_sql [info] == Migrated 20180919175123 in 0.0s
2023-02-13T10:40:39.115 application=ecto_sql [info] == Running 20181008195723 Explorer.Repo.Migrations.CreateAdministrators.change/0 forward
2023-02-13T10:40:39.115 application=ecto_sql [info] create table administrators
2023-02-13T10:40:39.117 application=ecto_sql [info] create index owner_role_limit
2023-02-13T10:40:39.118 application=ecto_sql [info] create index administrators_user_id_index
2023-02-13T10:40:39.119 application=ecto_sql [info] == Migrated 20181008195723 in 0.0s
2023-02-13T10:40:39.121 application=ecto_sql [info] == Running 20181011193212 Explorer.Repo.Migrations.AddFieldsToInternalTransactions.up/0 forward
2023-02-13T10:40:39.121 application=ecto_sql [info] alter table internal_transactions
2023-02-13T10:40:39.121 application=ecto_sql [info] == Migrated 20181011193212 in 0.0s
2023-02-13T10:40:39.122 application=ecto_sql [info] == Running 20181015173318 Explorer.Repo.Migrations.AddCaseInsensitiveExtension.change/0 forward
2023-02-13T10:40:39.122 application=ecto_sql [info] execute "CREATE EXTENSION IF NOT EXISTS citext"
2023-02-13T10:40:39.127 application=ecto_sql [info] == Migrated 20181015173318 in 0.0s
2023-02-13T10:40:39.128 application=ecto_sql [info] == Running 20181015173319 Explorer.Repo.Migrations.ModifyUsersUsername.up/0 forward
2023-02-13T10:40:39.128 application=ecto_sql [info] drop index unique_username
2023-02-13T10:40:39.129 application=ecto_sql [info] alter table users
2023-02-13T10:40:39.129 application=ecto_sql [info] create index unique_username
2023-02-13T10:40:39.130 application=ecto_sql [info] == Migrated 20181015173319 in 0.0s
2023-02-13T10:40:39.131 application=ecto_sql [info] == Running 20181016163236 Explorer.Repo.Migrations.ModifyUserContactsEmail.up/0 forward
2023-02-13T10:40:39.131 application=ecto_sql [info] drop index email_unique_for_user
2023-02-13T10:40:39.132 application=ecto_sql [info] alter table user_contacts
2023-02-13T10:40:39.133 application=ecto_sql [info] create index email_unique_for_user
2023-02-13T10:40:39.134 application=ecto_sql [info] == Migrated 20181016163236 in 0.0s
2023-02-13T10:40:39.135 application=ecto_sql [info] == Running 20181017141409 Explorer.Repo.Migrations.AddIndexToInternalTransactionTable.change/0 forward
2023-02-13T10:40:39.135 application=ecto_sql [info] create index internal_transactions_to_address_hash_from_address_hash_created_contract_address_hash_type_index_index
2023-02-13T10:40:39.137 application=ecto_sql [info] create index internal_transactions_block_number_DESC__transaction_index_DESC__index_DESC_index
2023-02-13T10:40:39.138 application=ecto_sql [info] == Migrated 20181017141409 in 0.0s
2023-02-13T10:40:39.139 application=ecto_sql [info] == Running 20181024141113 Explorer.Repo.Migrations.InternalTransactionsCompositePrimaryKey.up/0 forward
2023-02-13T10:40:39.139 application=ecto_sql [info] alter table internal_transactions
2023-02-13T10:40:39.140 application=ecto_sql [info] execute "ALTER TABLE internal_transactions ADD PRIMARY KEY (transaction_hash, index)"
2023-02-13T10:40:39.141 application=ecto_sql [info] == Migrated 20181024141113 in 0.0s
2023-02-13T10:40:39.142 application=ecto_sql [info] == Running 20181024164623 Explorer.Repo.Migrations.LogsCompositePrimaryKey.up/0 forward
2023-02-13T10:40:39.142 application=ecto_sql [info] alter table logs
2023-02-13T10:40:39.142 application=ecto_sql [info] execute "ALTER TABLE logs ADD PRIMARY KEY (transaction_hash, index)"
2023-02-13T10:40:39.144 application=ecto_sql [info] == Migrated 20181024164623 in 0.0s
2023-02-13T10:40:39.145 application=ecto_sql [info] == Running 20181024172010 Explorer.Repo.Migrations.TokenTransfersCompositePrimaryKey.up/0 forward
2023-02-13T10:40:39.145 application=ecto_sql [info] alter table token_transfers
2023-02-13T10:40:39.145 application=ecto_sql [info] execute "ALTER TABLE token_transfers ADD PRIMARY KEY (transaction_hash, log_index)"
2023-02-13T10:40:39.147 application=ecto_sql [info] == Migrated 20181024172010 in 0.0s
2023-02-13T10:40:39.148 application=ecto_sql [info] == Running 20181026180921 Explorer.Repo.Migrations.CreateAddressCurrentTokenBalances.change/0 forward
2023-02-13T10:40:39.148 application=ecto_sql [info] create table address_current_token_balances
2023-02-13T10:40:39.151 application=ecto_sql [info] create index address_current_token_balances_address_hash_token_contract_address_hash_index
2023-02-13T10:40:39.152 application=ecto_sql [info] create index address_current_token_balances_value
2023-02-13T10:40:39.154 application=ecto_sql [info] == Migrated 20181026180921 in 0.0s
2023-02-13T10:40:39.155 application=ecto_sql [info] == Running 20181029174420 Explorer.Repo.Migrations.UpdateTokensTableDecimalsFromBigintToNumeric.up/0 forward
2023-02-13T10:40:39.155 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.158 application=ecto_sql [info] == Migrated 20181029174420 in 0.0s
2023-02-13T10:40:39.159 application=ecto_sql [info] == Running 20181106152300 Explorer.Repo.Migrations.AddNonceToAddresses.up/0 forward
2023-02-13T10:40:39.159 application=ecto_sql [info] alter table addresses
2023-02-13T10:40:39.159 application=ecto_sql [info] == Migrated 20181106152300 in 0.0s
2023-02-13T10:40:39.160 application=ecto_sql [info] == Running 20181107164103 Explorer.Repo.Migrations.EIP6.up/0 forward
2023-02-13T10:40:39.160 application=ecto_sql [info] execute "ALTER TABLE internal_transactions DROP CONSTRAINT suicide_has_from_and_to_address_hashes"
2023-02-13T10:40:39.161 application=ecto_sql [info] execute "ALTER TABLE internal_transactions\nADD CONSTRAINT selfdestruct_has_from_and_to_address\nCHECK (type != 'selfdestruct' OR (from_address_hash IS NOT NULL AND gas IS NULL AND to_address_hash IS NOT NULL))\nNOT VALID\n"
2023-02-13T10:40:39.161 application=ecto_sql [info] == Migrated 20181107164103 in 0.0s
2023-02-13T10:40:39.162 application=ecto_sql [info] == Running 20181108205650 Explorer.Repo.Migrations.AdditionalInternalTransactionConstraints.up/0 forward
2023-02-13T10:40:39.162 application=ecto_sql [info] execute "ALTER TABLE internal_transactions\nADD CONSTRAINT call_has_call_type\nCHECK (type != 'call' OR call_type IS NOT NULL)\nNOT VALID\n"
2023-02-13T10:40:39.163 application=ecto_sql [info] execute "ALTER TABLE internal_transactions\nADD CONSTRAINT call_has_input\nCHECK (type != 'call' OR input IS NOT NULL)\nNOT VALID\n"
2023-02-13T10:40:39.163 application=ecto_sql [info] execute "ALTER TABLE internal_transactions\nADD CONSTRAINT create_has_init\nCHECK (type != 'create' OR init IS NOT NULL)\nNOT VALID\n"
2023-02-13T10:40:39.163 application=ecto_sql [info] == Migrated 20181108205650 in 0.0s
2023-02-13T10:40:39.164 application=ecto_sql [info] == Running 20181121170616 Explorer.Repo.Migrations.AddBlockNumberToTokenTransfers.change/0 forward
2023-02-13T10:40:39.164 application=ecto_sql [info] alter table token_transfers
2023-02-13T10:40:39.164 application=ecto_sql [info] == Migrated 20181121170616 in 0.0s
2023-02-13T10:40:39.165 application=ecto_sql [info] == Running 20181126203826 Explorer.Repo.Migrations.AddIndexToAddresses.up/0 forward
2023-02-13T10:40:39.165 application=ecto_sql [info] execute "CREATE INDEX addresses_fetched_coin_balance_hash_index ON addresses (fetched_coin_balance DESC, hash ASC) WHERE fetched_coin_balance > 0"
2023-02-13T10:40:39.167 application=ecto_sql [info] == Migrated 20181126203826 in 0.0s
2023-02-13T10:40:39.168 application=ecto_sql [info] == Running 20181206200140 Explorer.Repo.Migrations.RenameBlockRewardsToEmissionRewards.change/0 forward
2023-02-13T10:40:39.168 application=ecto_sql [info] rename table block_rewards to emission_rewards
2023-02-13T10:40:39.168 application=ecto_sql [info] == Migrated 20181206200140 in 0.0s
2023-02-13T10:40:39.169 application=ecto_sql [info] == Running 20181206200312 Explorer.Repo.Migrations.CreateNewBlockRewards.change/0 forward
2023-02-13T10:40:39.170 application=ecto_sql [info] create table block_rewards
2023-02-13T10:40:39.171 application=ecto_sql [info] create index block_rewards_address_hash_address_type_block_hash_index
2023-02-13T10:40:39.173 application=ecto_sql [info] == Migrated 20181206200312 in 0.0s
2023-02-13T10:40:39.174 application=ecto_sql [info] == Running 20181212115448 Explorer.Repo.Migrations.AddIndexesToTokenTransfers.change/0 forward
2023-02-13T10:40:39.174 application=ecto_sql [info] create index token_transfers_from_address_hash_index
2023-02-13T10:40:39.175 application=ecto_sql [info] create index token_transfers_to_address_hash_index
2023-02-13T10:40:39.176 application=ecto_sql [info] == Migrated 20181212115448 in 0.0s
2023-02-13T10:40:39.178 application=ecto_sql [info] == Running 20181213111656 Explorer.Repo.Migrations.AddMetadataFieldToAddressNames.change/0 forward
2023-02-13T10:40:39.178 application=ecto_sql [info] alter table address_names
2023-02-13T10:40:39.178 application=ecto_sql [info] == Migrated 20181213111656 in 0.0s
2023-02-13T10:40:39.179 application=ecto_sql [info] == Running 20181221143000 Explorer.Repo.Migrations.CreateBlocksMinerHashIndex.change/0 forward
2023-02-13T10:40:39.179 application=ecto_sql [info] create index blocks_miner_hash_index
2023-02-13T10:40:39.181 application=ecto_sql [info] == Migrated 20181221143000 in 0.0s
2023-02-13T10:40:39.182 application=ecto_sql [info] == Running 20181221145054 Explorer.Repo.Migrations.AddContractMethods.change/0 forward
2023-02-13T10:40:39.182 application=ecto_sql [info] create table contract_methods
2023-02-13T10:40:39.185 application=ecto_sql [info] create index contract_methods_identifier_abi_index
2023-02-13T10:40:39.186 application=ecto_sql [info] == Migrated 20181221145054 in 0.0s
2023-02-13T10:40:39.187 application=ecto_sql [info] == Running 20190102141900 Explorer.Repo.Migrations.IndexCurrentTokenHolders.change/0 forward
2023-02-13T10:40:39.187 application=ecto_sql [info] create index address_current_token_balances_token_contract_address_hash_index
2023-02-13T10:40:39.189 application=ecto_sql [info] == Migrated 20190102141900 in 0.0s
2023-02-13T10:40:39.190 application=ecto_sql [info] == Running 20190114204640 Explorer.Repo.Migrations.AddTokensHolderCount.change/0 forward
2023-02-13T10:40:39.190 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.190 application=ecto_sql [info] == Migrated 20190114204640 in 0.0s
2023-02-13T10:40:39.191 application=ecto_sql [info] == Running 20190116082843 Explorer.Repo.Migrations.AddCreatedContractIndexedAtToTransactions.change/0 forward
2023-02-13T10:40:39.191 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.191 application=ecto_sql [info] create index transactions_created_contract_code_indexed_at_index
2023-02-13T10:40:39.192 application=ecto_sql [info] == Migrated 20190116082843 in 0.0s
2023-02-13T10:40:39.193 application=ecto_sql [info] == Running 20190118040301 Explorer.Repo.Migrations.CreateTokensPrimaryKey.up/0 forward
2023-02-13T10:40:39.194 application=ecto_sql [info] execute "ALTER TABLE tokens ADD PRIMARY KEY (contract_address_hash)"
2023-02-13T10:40:39.195 application=ecto_sql [info] == Migrated 20190118040301 in 0.0s
2023-02-13T10:40:39.196 application=ecto_sql [info] == Running 20190118152240 Explorer.Repo.Migrations.BlockSecondDegreeRelationsCompositePrimaryKey.up/0 forward
2023-02-13T10:40:39.196 application=ecto_sql [info] execute "ALTER TABLE block_second_degree_relations ADD PRIMARY KEY (nephew_hash, uncle_hash)"
2023-02-13T10:40:39.197 application=ecto_sql [info] == Migrated 20190118152240 in 0.0s
2023-02-13T10:40:39.198 application=ecto_sql [info] == Running 20190122125815 Explorer.Repo.Migrations.ChangeTransactionErrorConstraint.change/0 forward
2023-02-13T10:40:39.198 application=ecto_sql [info] drop constraint status from table transactions
2023-02-13T10:40:39.199 application=ecto_sql [info] create check constraint status on table transactions
2023-02-13T10:40:39.199 application=ecto_sql [info] drop constraint error from table transactions
2023-02-13T10:40:39.199 application=ecto_sql [info] create check constraint error on table transactions
2023-02-13T10:40:39.199 application=ecto_sql [info] == Migrated 20190122125815 in 0.0s
2023-02-13T10:40:39.201 application=ecto_sql [info] == Running 20190124082812 Explorer.Repo.Migrations.AddIndexOnTransactionNonceAndFromAddressHash.change/0 forward
2023-02-13T10:40:39.201 application=ecto_sql [info] create index transactions_nonce_from_address_hash_block_hash_index
2023-02-13T10:40:39.202 application=ecto_sql [info] create index transactions_block_hash_error_index
2023-02-13T10:40:39.203 application=ecto_sql [info] == Migrated 20190124082812 in 0.0s
2023-02-13T10:40:39.204 application=ecto_sql [info] == Running 20190208113202 Explorer.Repo.Migrations.AddUniqueIndexToRewards.change/0 forward
2023-02-13T10:40:39.204 application=ecto_sql [info] create index block_rewards_address_hash_block_hash_address_type_index
2023-02-13T10:40:39.206 application=ecto_sql [info] == Migrated 20190208113202 in 0.0s
2023-02-13T10:40:39.207 application=ecto_sql [info] == Running 20190208143201 Explorer.Repo.Migrations.AddIndexOnAddressHashBlockNumberAndTokenContractAddressHashForCurrentTokenBalance.change/0 forward
2023-02-13T10:40:39.207 application=ecto_sql [info] create index address_current_token_balances_address_hash_block_number_token_contract_address_hash_index
2023-02-13T10:40:39.208 application=ecto_sql [info] == Migrated 20190208143201 in 0.0s
2023-02-13T10:40:39.209 application=ecto_sql [info] == Running 20190213180502 Explorer.Repo.Migrations.AddEarliestProcessingStartToTransactions.change/0 forward
2023-02-13T10:40:39.209 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.210 application=ecto_sql [info] == Migrated 20190213180502 in 0.0s
2023-02-13T10:40:39.211 application=ecto_sql [info] == Running 20190214135850 Explorer.Repo.Migrations.AddIndexOnBlockNumberToAddressTokenBalances.change/0 forward
2023-02-13T10:40:39.211 application=ecto_sql [info] create index address_token_balances_block_number_index
2023-02-13T10:40:39.212 application=ecto_sql [info] == Migrated 20190214135850 in 0.0s
2023-02-13T10:40:39.213 application=ecto_sql [info] == Running 20190215080049 Explorer.Repo.Migrations.AddIndexOnFetchedCoinBalanceToAddresses.change/0 forward
2023-02-13T10:40:39.213 application=ecto_sql [info] create index addresses_fetched_coin_balance_index
2023-02-13T10:40:39.214 application=ecto_sql [info] == Migrated 20190215080049 in 0.0s
2023-02-13T10:40:39.215 application=ecto_sql [info] == Running 20190215093358 Explorer.Repo.Migrations.AddCompoundIndexAddressTokenBalances.change/0 forward
2023-02-13T10:40:39.215 application=ecto_sql [info] create index address_cur_token_balances_index
2023-02-13T10:40:39.217 application=ecto_sql [info] == Migrated 20190215093358 in 0.0s
2023-02-13T10:40:39.218 application=ecto_sql [info] == Running 20190215105501 Explorer.Repo.Migrations.AddConstructorArgumentsToSmartContracts.change/0 forward
2023-02-13T10:40:39.218 application=ecto_sql [info] execute "ALTER TABLE smart_contracts DROP COLUMN IF EXISTS constructor_arguments"
2023-02-13T10:40:39.218 application=ecto_sql [info] column "constructor_arguments" of relation "smart_contracts" does not exist, skipping
2023-02-13T10:40:39.218 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.218 application=ecto_sql [info] == Migrated 20190215105501 in 0.0s
2023-02-13T10:40:39.219 application=ecto_sql [info] == Running 20190219082636 Explorer.Repo.Migrations.AddIndexesForBlockRewardQuery.change/0 forward
2023-02-13T10:40:39.219 application=ecto_sql [info] create index blocks_number_index
2023-02-13T10:40:39.221 application=ecto_sql [info] create index emission_rewards_block_range_index
2023-02-13T10:40:39.222 application=ecto_sql [info] == Migrated 20190219082636 in 0.0s
2023-02-13T10:40:39.223 application=ecto_sql [info] == Running 20190228102650 Explorer.Repo.Migrations.AddIndexCreatedContractAddressHas.change/0 forward
2023-02-13T10:40:39.223 application=ecto_sql [info] create index transactions_created_contract_address_hash_index
2023-02-13T10:40:39.225 application=ecto_sql [info] == Migrated 20190228102650 in 0.0s
2023-02-13T10:40:39.226 application=ecto_sql [info] == Running 20190228152333 Explorer.Repo.Migrations.ChangeConstructorArgumentsToText.up/0 forward
2023-02-13T10:40:39.226 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.226 application=ecto_sql [info] == Migrated 20190228152333 in 0.0s
2023-02-13T10:40:39.227 application=ecto_sql [info] == Running 20190228220746 Explorer.Repo.Migrations.AddInternalTransactionsIndexedAtToBlocks.change/0 forward
2023-02-13T10:40:39.227 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.227 application=ecto_sql [info] == Migrated 20190228220746 in 0.0s
2023-02-13T10:40:39.228 application=ecto_sql [info] == Running 20190301095620 Explorer.Repo.Migrations.RemoveDuplicatedIndexes.change/0 forward
2023-02-13T10:40:39.228 application=ecto_sql [info] drop index if exists address_current_token_balances_block_number_index
2023-02-13T10:40:39.229 application=ecto_sql [info] index "address_current_token_balances_block_number_index" does not exist, skipping
2023-02-13T10:40:39.229 application=ecto_sql [info] drop index if exists internal_transactions_to_address_hash_index
2023-02-13T10:40:39.229 application=ecto_sql [info] drop index if exists internal_transactions_transaction_hash_index
2023-02-13T10:40:39.229 application=ecto_sql [info] drop index if exists logs_transaction_hash_index
2023-02-13T10:40:39.229 application=ecto_sql [info] drop index if exists token_transfers_from_address_hash_index
2023-02-13T10:40:39.229 application=ecto_sql [info] drop index if exists token_transfers_to_address_hash_index
2023-02-13T10:40:39.230 application=ecto_sql [info] drop index if exists token_transfers_transaction_hash_index
2023-02-13T10:40:39.230 application=ecto_sql [info] drop index if exists transaction_forks_uncle_hash_index
2023-02-13T10:40:39.230 application=ecto_sql [info] drop index if exists transactions_block_hash_index
2023-02-13T10:40:39.230 application=ecto_sql [info] drop index if exists transactions_created_contract_address_hash_index
2023-02-13T10:40:39.230 application=ecto_sql [info] drop index if exists user_contacts_user_id_index
2023-02-13T10:40:39.231 application=ecto_sql [info] == Migrated 20190301095620 in 0.0s
2023-02-13T10:40:39.232 application=ecto_sql [info] == Running 20190301120328 Explorer.Repo.Migrations.AddIndexToConsensus.change/0 forward
2023-02-13T10:40:39.232 application=ecto_sql [info] create index blocks_consensus_index
2023-02-13T10:40:39.233 application=ecto_sql [info] == Migrated 20190301120328 in 0.0s
2023-02-13T10:40:39.234 application=ecto_sql [info] == Running 20190305095926 Explorer.Repo.Migrations.AddIndexToValueFetchedAt.change/0 forward
2023-02-13T10:40:39.235 application=ecto_sql [info] create index address_coin_balances_value_fetched_at_index
2023-02-13T10:40:39.236 application=ecto_sql [info] == Migrated 20190305095926 in 0.0s
2023-02-13T10:40:39.237 application=ecto_sql [info] == Running 20190313085740 Explorer.Repo.Migrations.AddIndexSymoblInTokens.change/0 forward
2023-02-13T10:40:39.237 application=ecto_sql [info] create index tokens_symbol_index
2023-02-13T10:40:39.238 application=ecto_sql [info] == Migrated 20190313085740 in 0.0s
2023-02-13T10:40:39.239 application=ecto_sql [info] == Running 20190313103912 Explorer.Repo.Migrations.ChangeTransactionsVColumnType.up/0 forward
2023-02-13T10:40:39.240 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.254 application=ecto_sql [info] == Migrated 20190313103912 in 0.0s
2023-02-13T10:40:39.256 application=ecto_sql [info] == Running 20190314084907 Explorer.Repo.Migrations.AddIndexToToAddressHash.change/0 forward
2023-02-13T10:40:39.256 application=ecto_sql [info] create index transactions_to_address_hash_index
2023-02-13T10:40:39.257 application=ecto_sql [info] == Migrated 20190314084907 in 0.0s
2023-02-13T10:40:39.258 application=ecto_sql [info] == Running 20190318151809 Explorer.Repo.Migrations.AddInsertedAtIndexToAccounts.change/0 forward
2023-02-13T10:40:39.258 application=ecto_sql [info] create index addresses_inserted_at_index
2023-02-13T10:40:39.259 application=ecto_sql [info] == Migrated 20190318151809 in 0.0s
2023-02-13T10:40:39.260 application=ecto_sql [info] == Running 20190319081821 Explorer.Repo.Migrations.CreateDecompiledSmartContracts.change/0 forward
2023-02-13T10:40:39.260 application=ecto_sql [info] create table decompiled_smart_contracts
2023-02-13T10:40:39.263 application=ecto_sql [info] create index decompiled_smart_contracts_address_hash_index
2023-02-13T10:40:39.264 application=ecto_sql [info] == Migrated 20190319081821 in 0.0s
2023-02-13T10:40:39.265 application=ecto_sql [info] == Running 20190321185644 Explorer.Repo.Migrations.AddOldValueForCurrentTokenBalances.change/0 forward
2023-02-13T10:40:39.265 application=ecto_sql [info] alter table address_current_token_balances
2023-02-13T10:40:39.266 application=ecto_sql [info] == Migrated 20190321185644 in 0.0s
2023-02-13T10:40:39.267 application=ecto_sql [info] == Running 20190325081658 Explorer.Repo.Migrations.RemoveUniqueAddressHashDecompiledContracts.change/0 forward
2023-02-13T10:40:39.267 application=ecto_sql [info] drop index decompiled_smart_contracts_address_hash_index
2023-02-13T10:40:39.267 application=ecto_sql [info] create index address_decompiler_version
2023-02-13T10:40:39.268 application=ecto_sql [info] == Migrated 20190325081658 in 0.0s
2023-02-13T10:40:39.269 application=ecto_sql [info] == Running 20190403080447 Explorer.Repo.Migrations.AddFullTextSearchTokens.up/0 forward
2023-02-13T10:40:39.269 application=ecto_sql [info] execute "CREATE EXTENSION pg_trgm"
2023-02-13T10:40:39.274 application=ecto_sql [info] execute "CREATE INDEX tokens_trgm_idx ON tokens USING GIN (to_tsvector('english', symbol || ' ' || name))\n"
2023-02-13T10:40:39.275 application=ecto_sql [info] == Migrated 20190403080447 in 0.0s
2023-02-13T10:40:39.276 application=ecto_sql [info] == Running 20190421143300 Explorer.Repo.Migrations.AddIndexToBsdr.change/0 forward
2023-02-13T10:40:39.276 application=ecto_sql [info] alter table block_second_degree_relations
2023-02-13T10:40:39.276 application=ecto_sql [info] == Migrated 20190421143300 in 0.0s
2023-02-13T10:40:39.277 application=ecto_sql [info] == Running 20190424170833 Explorer.Repo.Migrations.ChangeBlockSizeToNullable.up/0 forward
2023-02-13T10:40:39.277 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.277 application=ecto_sql [info] == Migrated 20190424170833 in 0.0s
2023-02-13T10:40:39.278 application=ecto_sql [info] == Running 20190508152922 Explorer.Repo.Migrations.AddOldBlockHashForTransactions.change/0 forward
2023-02-13T10:40:39.278 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.279 application=ecto_sql [info] == Migrated 20190508152922 in 0.0s
2023-02-13T10:40:39.280 application=ecto_sql [info] == Running 20190513134025 Explorer.Repo.Migrations.AddRefetchNeededToBlock.change/0 forward
2023-02-13T10:40:39.280 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.280 application=ecto_sql [info] execute "UPDATE blocks SET refetch_needed = TRUE WHERE consensus"
2023-02-13T10:40:39.280 application=ecto_sql [info] == Migrated 20190513134025 in 0.0s
2023-02-13T10:40:39.281 application=ecto_sql [info] == Running 20190516140202 Explorer.Repo.Migrations.AddAddressHashIndexToDecompiledSmartContracts.change/0 forward
2023-02-13T10:40:39.281 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS decompiled_smart_contracts_address_hash_index ON decompiled_smart_contracts(address_hash);\n"
2023-02-13T10:40:39.283 application=ecto_sql [info] == Migrated 20190516140202 in 0.0s
2023-02-13T10:40:39.283 application=ecto_sql [info] == Running 20190516160535 Explorer.Repo.Migrations.AddDecompiledAndVerifiedFlagToAddresses.change/0 forward
2023-02-13T10:40:39.284 application=ecto_sql [info] execute "ALTER TABLE addresses\nADD COLUMN IF NOT EXISTS decompiled BOOLEAN,\nADD COLUMN IF NOT EXISTS verified BOOLEAN;\n"
2023-02-13T10:40:39.284 application=ecto_sql [info] == Migrated 20190516160535 in 0.0s
2023-02-13T10:40:39.285 application=ecto_sql [info] == Running 20190521104412 Explorer.Repo.Migrations.CreateStakingPools.change/0 forward
2023-02-13T10:40:39.285 application=ecto_sql [info] create table staking_pools
2023-02-13T10:40:39.288 application=ecto_sql [info] create index staking_pools_staking_address_hash_index
2023-02-13T10:40:39.289 application=ecto_sql [info] create index staking_pools_mining_address_hash_index
2023-02-13T10:40:39.290 application=ecto_sql [info] == Migrated 20190521104412 in 0.0s
2023-02-13T10:40:39.291 application=ecto_sql [info] == Running 20190523112839 Explorer.Repo.Migrations.CreateStakingPoolsDelegator.change/0 forward
2023-02-13T10:40:39.291 application=ecto_sql [info] create table staking_pools_delegators
2023-02-13T10:40:39.294 application=ecto_sql [info] create index staking_pools_delegators_delegator_address_hash_index
2023-02-13T10:40:39.295 application=ecto_sql [info] create index pools_delegator_index
2023-02-13T10:40:39.296 application=ecto_sql [info] == Migrated 20190523112839 in 0.0s
2023-02-13T10:40:39.297 application=ecto_sql [info] == Running 20190613065856 Explorer.Repo.Migrations.AddTxHashInsertedAtIndex.change/0 forward
2023-02-13T10:40:39.297 application=ecto_sql [info] create index transactions_hash_inserted_at_index
2023-02-13T10:40:39.299 application=ecto_sql [info] == Migrated 20190613065856 in 0.0s
2023-02-13T10:40:39.300 application=ecto_sql [info] == Running 20190619154943 Explorer.Repo.Migrations.ReduceTransactionStatusConstraint.up/0 forward
2023-02-13T10:40:39.300 application=ecto_sql [info] drop constraint status from table transactions
2023-02-13T10:40:39.300 application=ecto_sql [info] create check constraint status on table transactions
2023-02-13T10:40:39.300 application=ecto_sql [info] drop constraint error from table transactions
2023-02-13T10:40:39.300 application=ecto_sql [info] create check constraint error on table transactions
2023-02-13T10:40:39.301 application=ecto_sql [info] == Migrated 20190619154943 in 0.0s
2023-02-13T10:40:39.302 application=ecto_sql [info] == Running 20190625085852 Explorer.Repo.Migrations.AddAdditionalContractFields.change/0 forward
2023-02-13T10:40:39.302 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.302 application=ecto_sql [info] == Migrated 20190625085852 in 0.0s
2023-02-13T10:40:39.303 application=ecto_sql [info] == Running 20190709043832 Explorer.Repo.Migrations.CreateTransactionStats.change/0 forward
2023-02-13T10:40:39.303 application=ecto_sql [info] create table transaction_stats
2023-02-13T10:40:39.304 application=ecto_sql [info] create index transaction_stats_date_index
2023-02-13T10:40:39.306 application=ecto_sql [info] == Migrated 20190709043832 in 0.0s
2023-02-13T10:40:39.307 application=ecto_sql [info] == Running 20190709103104 Explorer.Repo.Migrations.AddExternalLibrariesToSmartContracts.change/0 forward
2023-02-13T10:40:39.307 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.307 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.307 application=ecto_sql [info] == Migrated 20190709103104 in 0.0s
2023-02-13T10:40:39.308 application=ecto_sql [info] == Running 20190807111216 Explorer.Repo.Migrations.RemoveDuplicateIndexes.change/0 forward
2023-02-13T10:40:39.308 application=ecto_sql [info] drop index if exists decompiled_smart_contracts_address_hash_index
2023-02-13T10:40:39.308 application=ecto_sql [info] drop index if exists staking_pools_delegators_delegator_address_hash_index
2023-02-13T10:40:39.308 application=ecto_sql [info] drop index if exists transactions_to_address_hash_index
2023-02-13T10:40:39.309 application=ecto_sql [info] == Migrated 20190807111216 in 0.0s
2023-02-13T10:40:39.310 application=ecto_sql [info] == Running 20190807113117 Explorer.Repo.Migrations.CreateSuggestedIndexes.change/0 forward
2023-02-13T10:40:39.310 application=ecto_sql [info] create index if not exists address_token_balances_block_number_address_hash_index
2023-02-13T10:40:39.311 application=ecto_sql [info] create index if not exists block_rewards_block_hash_index
2023-02-13T10:40:39.312 application=ecto_sql [info] == Migrated 20190807113117 in 0.0s
2023-02-13T10:40:39.313 application=ecto_sql [info] == Running 20190827120224 Explorer.Repo.Migrations.AddIndexOnTokenTransferTokenId.change/0 forward
2023-02-13T10:40:39.313 application=ecto_sql [info] create index if not exists token_transfers_token_id_index
2023-02-13T10:40:39.314 application=ecto_sql [info] == Migrated 20190827120224 in 0.0s
2023-02-13T10:40:39.315 application=ecto_sql [info] == Running 20190905083522 Explorer.Repo.Migrations.CreateTokenInstances.change/0 forward
2023-02-13T10:40:39.315 application=ecto_sql [info] create table token_instances
2023-02-13T10:40:39.318 application=ecto_sql [info] create index if not exists token_instances_token_id_index
2023-02-13T10:40:39.319 application=ecto_sql [info] == Migrated 20190905083522 in 0.0s
2023-02-13T10:40:39.320 application=ecto_sql [info] == Running 20190910170703 Explorer.Repo.Migrations.CreateIndexesForBlockNumberInTokenTransfersAndTransactions.change/0 forward
2023-02-13T10:40:39.320 application=ecto_sql [info] create index if not exists token_transfers_block_number_index
2023-02-13T10:40:39.321 application=ecto_sql [info] == Migrated 20190910170703 in 0.0s
2023-02-13T10:40:39.322 application=ecto_sql [info] == Running 20191007082500 Explorer.Repo.Migrations.AddIndexesForTokenInstrancesQuery.change/0 forward
2023-02-13T10:40:39.322 application=ecto_sql [info] create index if not exists token_instances_token_id_index
2023-02-13T10:40:39.323 application=ecto_sql [info] relation "token_instances_token_id_index" already exists, skipping
2023-02-13T10:40:39.323 application=ecto_sql [info] create index if not exists tokens_type_index
2023-02-13T10:40:39.324 application=ecto_sql [info] == Migrated 20191007082500 in 0.0s
2023-02-13T10:40:39.325 application=ecto_sql [info] == Running 20191009121635 Explorer.Repo.Migrations.AddTokenTransferSortingIndexes.change/0 forward
2023-02-13T10:40:39.325 application=ecto_sql [info] create index token_transfers_block_number_DESC_log_index_DESC_index
2023-02-13T10:40:39.326 application=ecto_sql [info] == Migrated 20191009121635 in 0.0s
2023-02-13T10:40:39.327 application=ecto_sql [info] == Running 20191010075740 Explorer.Repo.Migrations.AddErrorToTokenInstances.change/0 forward
2023-02-13T10:40:39.327 application=ecto_sql [info] alter table token_instances
2023-02-13T10:40:39.327 application=ecto_sql [info] create index token_instances_error_index
2023-02-13T10:40:39.329 application=ecto_sql [info] == Migrated 20191010075740 in 0.0s
2023-02-13T10:40:39.330 application=ecto_sql [info] == Running 20191018120546 Explorer.Repo.Migrations.CreatePendingBlockOperations.change/0 forward
2023-02-13T10:40:39.330 application=ecto_sql [info] create table pending_block_operations
2023-02-13T10:40:39.333 application=ecto_sql [info] == Migrated 20191018120546 in 0.0s
2023-02-13T10:40:39.334 application=ecto_sql [info] == Running 20191018140054 Explorer.Repo.Migrations.AddPendingInternalTxsOperation.change/0 forward
2023-02-13T10:40:39.334 application=ecto_sql [info] alter table pending_block_operations
2023-02-13T10:40:39.334 application=ecto_sql [info] execute "INSERT INTO pending_block_operations\n(block_hash, inserted_at, updated_at, fetch_internal_transactions)\nSELECT b.hash, now(), now(), TRUE FROM blocks b\nWHERE b.internal_transactions_indexed_at IS NULL\nAND EXISTS (\n SELECT 1\n FROM transactions t\n WHERE b.hash = t.block_hash\n AND t.internal_transactions_indexed_at IS NULL\n);\n"
2023-02-13T10:40:39.335 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.335 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.335 application=ecto_sql [info] alter table internal_transactions
2023-02-13T10:40:39.335 application=ecto_sql [info] execute "UPDATE internal_transactions itx\nSET block_hash = with_block.block_hash, block_index = with_block.block_index\nFROM (\n SELECT i.transaction_hash,\n i.index,\n t.block_hash,\n row_number() OVER(\n PARTITION BY t.block_hash\n ORDER BY i.transaction_hash, i.index\n ) - 1 AS block_index\n FROM internal_transactions i\n JOIN transactions t\n ON t.hash = i.transaction_hash\n) AS with_block\nWHERE itx.transaction_hash = with_block.transaction_hash\nAND itx.index = with_block.index;\n"
2023-02-13T10:40:39.336 application=ecto_sql [info] execute "DELETE FROM internal_transactions WHERE block_hash IS NULL;\n"
2023-02-13T10:40:39.336 application=ecto_sql [info] execute "ALTER table internal_transactions\nDROP CONSTRAINT internal_transactions_pkey,\nADD PRIMARY KEY (block_hash, block_index);\n"
2023-02-13T10:40:39.337 application=ecto_sql [info] alter table internal_transactions
2023-02-13T10:40:39.338 application=ecto_sql [info] drop index internal_transactions_transaction_hash_index_index
2023-02-13T10:40:39.339 application=ecto_sql [info] create index if not exists internal_transactions_transaction_hash_index_index
2023-02-13T10:40:39.340 application=ecto_sql [info] == Migrated 20191018140054 in 0.0s
2023-02-13T10:40:39.341 application=ecto_sql [info] == Running 20191121064805 Explorer.Repo.Migrations.AddBlockHashAndBlockIndexToLogs.change/0 forward
2023-02-13T10:40:39.341 application=ecto_sql [info] alter table logs
2023-02-13T10:40:39.341 application=ecto_sql [info] execute "UPDATE logs log\nSET block_hash = with_block.block_hash,\nblock_number = with_block.block_number\nFROM (\n SELECT l.transaction_hash,\n t.block_hash,\n t.block_number\n FROM logs l\n JOIN transactions t\n ON t.hash = l.transaction_hash\n) AS with_block\nWHERE log.transaction_hash = with_block.transaction_hash;\n"
2023-02-13T10:40:39.342 application=ecto_sql [info] execute "DELETE FROM logs WHERE block_hash IS NULL;\n"
2023-02-13T10:40:39.342 application=ecto_sql [info] alter table logs
2023-02-13T10:40:39.342 application=ecto_sql [info] execute "ALTER table logs\nDROP CONSTRAINT logs_pkey,\nADD PRIMARY KEY (transaction_hash, block_hash, index);\n"
2023-02-13T10:40:39.344 application=ecto_sql [info] drop index logs_transaction_hash_index_index
2023-02-13T10:40:39.344 application=ecto_sql [info] create index if not exists logs_transaction_hash_index_index
2023-02-13T10:40:39.345 application=ecto_sql [info] == Migrated 20191121064805 in 0.0s
2023-02-13T10:40:39.346 application=ecto_sql [info] == Running 20191122062035 Explorer.Repo.Migrations.AddBlockHashToTokenTransfers.change/0 forward
2023-02-13T10:40:39.347 application=ecto_sql [info] alter table token_transfers
2023-02-13T10:40:39.347 application=ecto_sql [info] execute "UPDATE token_transfers token_transfer\nSET block_hash = with_block.block_hash\nFROM (\n SELECT transfer.transaction_hash,\n t.block_hash\n FROM token_transfers transfer\n JOIN transactions t\n ON t.hash = transfer.transaction_hash\n) AS with_block\nWHERE token_transfer.transaction_hash = with_block.transaction_hash;\n"
2023-02-13T10:40:39.347 application=ecto_sql [info] execute "DELETE FROM token_transfers WHERE block_hash IS NULL;\n"
2023-02-13T10:40:39.347 application=ecto_sql [info] alter table token_transfers
2023-02-13T10:40:39.348 application=ecto_sql [info] execute "ALTER table token_transfers\nDROP CONSTRAINT token_transfers_pkey,\nADD PRIMARY KEY (transaction_hash, block_hash, log_index);\n"
2023-02-13T10:40:39.349 application=ecto_sql [info] drop index token_transfers_transaction_hash_log_index_index
2023-02-13T10:40:39.349 application=ecto_sql [info] create index if not exists token_transfers_transaction_hash_log_index_index
2023-02-13T10:40:39.351 application=ecto_sql [info] == Migrated 20191122062035 in 0.0s
2023-02-13T10:40:39.352 application=ecto_sql [info] == Running 20191128124415 Explorer.Repo.Migrations.RemoveDuplicateIndexesTokenEntities.change/0 forward
2023-02-13T10:40:39.352 application=ecto_sql [info] drop index if exists address_token_balances_block_number_index
2023-02-13T10:40:39.352 application=ecto_sql [info] drop index if exists token_instances_token_id_index
2023-02-13T10:40:39.352 application=ecto_sql [info] == Migrated 20191128124415 in 0.0s
2023-02-13T10:40:39.353 application=ecto_sql [info] == Running 20191203112646 Explorer.Repo.Migrations.InternalTransactionsAddToAddressHashIndex.change/0 forward
2023-02-13T10:40:39.353 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS internal_transactions_from_address_hash_partial_index on public.internal_transactions(from_address_hash, block_number DESC, transaction_index DESC, index DESC) WHERE (((type = 'call') AND (index > 0)) OR (type != 'call'));"
2023-02-13T10:40:39.355 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS internal_transactions_to_address_hash_partial_index on public.internal_transactions(to_address_hash, block_number DESC, transaction_index DESC, index DESC) WHERE (((type = 'call') AND (index > 0)) OR (type != 'call'));"
2023-02-13T10:40:39.356 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS internal_transactions_created_contract_address_hash_partial_index on public.internal_transactions(created_contract_address_hash, block_number DESC, transaction_index DESC, index DESC) WHERE (((type = 'call') AND (index > 0)) OR (type != 'call'));"
2023-02-13T10:40:39.357 application=ecto_sql [info] drop index if exists internal_transactions_to_address_hash_from_address_hash_created
2023-02-13T10:40:39.357 application=ecto_sql [info] == Migrated 20191203112646 in 0.0s
2023-02-13T10:40:39.358 application=ecto_sql [info] == Running 20191208135613 Explorer.Repo.Migrations.BlockRewardsBlockHashPartialIndex.change/0 forward
2023-02-13T10:40:39.359 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS block_rewards_block_hash_partial_index on block_rewards(block_hash) WHERE address_type='validator';"
2023-02-13T10:40:39.360 application=ecto_sql [info] == Migrated 20191208135613 in 0.0s
2023-02-13T10:40:39.361 application=ecto_sql [info] == Running 20191218120138 Explorer.Repo.Migrations.LogsBlockNumberIndexIndex.change/0 forward
2023-02-13T10:40:39.361 application=ecto_sql [info] create index if not exists logs_block_number_DESC__index_DESC_index
2023-02-13T10:40:39.362 application=ecto_sql [info] == Migrated 20191218120138 in 0.0s
2023-02-13T10:40:39.363 application=ecto_sql [info] == Running 20191220113006 Explorer.Repo.Migrations.PendingBlockOperationsBlockHashPartialIndex.change/0 forward
2023-02-13T10:40:39.363 application=ecto_sql [info] execute "CREATE INDEX pending_block_operations_block_hash_index_partial ON pending_block_operations(block_hash) WHERE fetch_internal_transactions=true;"
2023-02-13T10:40:39.364 application=ecto_sql [info] == Migrated 20191220113006 in 0.0s
2023-02-13T10:40:39.365 application=ecto_sql [info] == Running 20200214152058 Explorer.Repo.Migrations.AddTokenIdToTokenBalances.change/0 forward
2023-02-13T10:40:39.365 application=ecto_sql [info] alter table address_token_balances
2023-02-13T10:40:39.366 application=ecto_sql [info] create index address_token_balances_token_id_index
2023-02-13T10:40:39.367 application=ecto_sql [info] == Migrated 20200214152058 in 0.0s
2023-02-13T10:40:39.368 application=ecto_sql [info] == Running 20200410115841 Explorer.Repo.Migrations.CreateIndexAddressCurrentTokenBalancesTokenContractAddressHashValue.change/0 forward
2023-02-13T10:40:39.368 application=ecto_sql [info] create index if not exists address_current_token_balances_token_contract_address_hash_value_index
2023-02-13T10:40:39.369 application=ecto_sql [info] == Migrated 20200410115841 in 0.0s
2023-02-13T10:40:39.370 application=ecto_sql [info] == Running 20200410141202 Explorer.Repo.Migrations.CreateIndexTokenTransfersTokenContractAddressHashBlockNumber.change/0 forward
2023-02-13T10:40:39.370 application=ecto_sql [info] create index if not exists token_transfers_token_contract_address_hash_block_number_index
2023-02-13T10:40:39.372 application=ecto_sql [info] == Migrated 20200410141202 in 0.0s
2023-02-13T10:40:39.373 application=ecto_sql [info] == Running 20200421102450 Explorer.Repo.Migrations.PendingTxs.up/0 forward
2023-02-13T10:40:39.373 application=ecto_sql [info] execute "CREATE INDEX IF NOT EXISTS pending_txs_index ON transactions(inserted_at, hash) WHERE (block_hash IS NULL AND (error IS NULL OR (error != 'dropped/replaced')))"
2023-02-13T10:40:39.374 application=ecto_sql [info] drop index if exists transactions_hash_inserted_at_index
2023-02-13T10:40:39.374 application=ecto_sql [info] == Migrated 20200421102450 in 0.0s
2023-02-13T10:40:39.375 application=ecto_sql [info] == Running 20200424070607 Explorer.Repo.Migrations.DropBlockRewardsAddressHashAddressTypeBlockHashIndex.change/0 forward
2023-02-13T10:40:39.375 application=ecto_sql [info] drop index if exists block_rewards_address_hash_address_type_block_hash_index
2023-02-13T10:40:39.376 application=ecto_sql [info] == Migrated 20200424070607 in 0.0s
2023-02-13T10:40:39.377 application=ecto_sql [info] == Running 20200518075748 Explorer.Repo.Migrations.CreateIndexBlocksMinerHashNumberIndex.change/0 forward
2023-02-13T10:40:39.377 application=ecto_sql [info] create index if not exists blocks_miner_hash_number_index
2023-02-13T10:40:39.378 application=ecto_sql [info] == Migrated 20200518075748 in 0.0s
2023-02-13T10:40:39.379 application=ecto_sql [info] == Running 20200521090250 Explorer.Repo.Migrations.RecreateStakingTables.change/0 forward
2023-02-13T10:40:39.379 application=ecto_sql [info] drop table if exists staking_pools
2023-02-13T10:40:39.380 application=ecto_sql [info] drop table if exists staking_pools_delegators
2023-02-13T10:40:39.380 application=ecto_sql [info] create table staking_pools
2023-02-13T10:40:39.384 application=ecto_sql [info] create index staking_pools_staking_address_hash_index
2023-02-13T10:40:39.385 application=ecto_sql [info] create index staking_pools_mining_address_hash_index
2023-02-13T10:40:39.386 application=ecto_sql [info] create table staking_pools_delegators
2023-02-13T10:40:39.389 application=ecto_sql [info] create index pools_delegator_index
2023-02-13T10:40:39.391 application=ecto_sql [info] create index snapshotted_stake_amount_index
2023-02-13T10:40:39.392 application=ecto_sql [info] == Migrated 20200521090250 in 0.0s
2023-02-13T10:40:39.394 application=ecto_sql [info] == Running 20200521170002 Explorer.Repo.Migrations.CreateTokenTransfersTokenContractAddressHashTokenIdBlockNumberIndex.change/0 forward
2023-02-13T10:40:39.394 application=ecto_sql [info] create index if not exists token_transfers_token_contract_address_hash_token_id_DESC_block_number_DESC_index
2023-02-13T10:40:39.395 application=ecto_sql [info] == Migrated 20200521170002 in 0.0s
2023-02-13T10:40:39.396 application=ecto_sql [info] == Running 20200525115811 Explorer.Repo.Migrations.AddressCoinBalancesDaily.change/0 forward
2023-02-13T10:40:39.396 application=ecto_sql [info] create table address_coin_balances_daily
2023-02-13T10:40:39.398 application=ecto_sql [info] create index address_coin_balances_daily_address_hash_day_index
2023-02-13T10:40:39.399 application=ecto_sql [info] == Migrated 20200525115811 in 0.0s
2023-02-13T10:40:39.400 application=ecto_sql [info] == Running 20200527144742 Explorer.Repo.Migrations.AddCountersTable.change/0 forward
2023-02-13T10:40:39.400 application=ecto_sql [info] create table last_fetched_counters
2023-02-13T10:40:39.401 application=ecto_sql [info] == Migrated 20200527144742 in 0.0s
2023-02-13T10:40:39.402 application=ecto_sql [info] == Running 20200608075122 Explorer.Repo.Migrations.AlterTransactionsAddErrorReason.change/0 forward
2023-02-13T10:40:39.403 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.403 application=ecto_sql [info] == Migrated 20200608075122 in 0.0s
2023-02-13T10:40:39.404 application=ecto_sql [info] == Running 20200806125649 Explorer.Repo.Migrations.TokenAddBridgedColumn.change/0 forward
2023-02-13T10:40:39.404 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.404 application=ecto_sql [info] == Migrated 20200806125649 in 0.0s
2023-02-13T10:40:39.405 application=ecto_sql [info] == Running 20200807064700 Explorer.Repo.Migrations.BridgedTokensTable.change/0 forward
2023-02-13T10:40:39.405 application=ecto_sql [info] create table bridged_tokens
2023-02-13T10:40:39.407 application=ecto_sql [info] create index bridged_tokens_home_token_contract_address_hash_index
2023-02-13T10:40:39.408 application=ecto_sql [info] == Migrated 20200807064700 in 0.0s
2023-02-13T10:40:39.409 application=ecto_sql [info] == Running 20200812143050 Explorer.Repo.Migrations.AddAddressesContractCodeIndex.change/0 forward
2023-02-13T10:40:39.409 application=ecto_sql [info] execute "CREATE INDEX addresses_contract_code_index ON addresses (md5(contract_code::text));"
2023-02-13T10:40:39.410 application=ecto_sql [info] == Migrated 20200812143050 in 0.0s
2023-02-13T10:40:39.411 application=ecto_sql [info] == Running 20200904075501 Explorer.Repo.Migrations.AddBridgedTokenCustomMetadata.change/0 forward
2023-02-13T10:40:39.411 application=ecto_sql [info] alter table bridged_tokens
2023-02-13T10:40:39.412 application=ecto_sql [info] == Migrated 20200904075501 in 0.0s
2023-02-13T10:40:39.413 application=ecto_sql [info] == Running 20200929075625 Explorer.Repo.Migrations.AddBridgedTokenType.change/0 forward
2023-02-13T10:40:39.413 application=ecto_sql [info] alter table bridged_tokens
2023-02-13T10:40:39.413 application=ecto_sql [info] == Migrated 20200929075625 in 0.0s
2023-02-13T10:40:39.414 application=ecto_sql [info] == Running 20201026093652 Explorer.Repo.Migrations.TransactionsStatAddGasUsageColumn.change/0 forward
2023-02-13T10:40:39.414 application=ecto_sql [info] alter table transaction_stats
2023-02-13T10:40:39.414 application=ecto_sql [info] == Migrated 20201026093652 in 0.0s
2023-02-13T10:40:39.415 application=ecto_sql [info] == Running 20201214203532 Explorer.Repo.Migrations.SupportSourcify.change/0 forward
2023-02-13T10:40:39.415 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.415 application=ecto_sql [info] create table smart_contracts_additional_sources
2023-02-13T10:40:39.418 application=ecto_sql [info] create index smart_contracts_additional_sources_address_hash_index
2023-02-13T10:40:39.420 application=ecto_sql [info] == Migrated 20201214203532 in 0.0s
2023-02-13T10:40:39.421 application=ecto_sql [info] == Running 20210219080523 Explorer.Repo.Migrations.AddTags.change/0 forward
2023-02-13T10:40:39.421 application=ecto_sql [info] create table address_tags
2023-02-13T10:40:39.421 application=ecto_sql [info] create index address_tags_id_index
2023-02-13T10:40:39.422 application=ecto_sql [info] create index address_tags_label_index
2023-02-13T10:40:39.423 application=ecto_sql [info] create table address_to_tags
2023-02-13T10:40:39.426 application=ecto_sql [info] create index address_to_tags_address_hash_tag_id_index
2023-02-13T10:40:39.427 application=ecto_sql [info] == Migrated 20210219080523 in 0.0s
2023-02-13T10:40:39.428 application=ecto_sql [info] == Running 20210226154732 Explorer.Repo.Migrations.AddExchangeRateColumnToBridgedTokens.change/0 forward
2023-02-13T10:40:39.429 application=ecto_sql [info] alter table bridged_tokens
2023-02-13T10:40:39.429 application=ecto_sql [info] == Migrated 20210226154732 in 0.0s
2023-02-13T10:40:39.430 application=ecto_sql [info] == Running 20210309104122 Explorer.Repo.Migrations.AddBridgedTokenCustomCap.change/0 forward
2023-02-13T10:40:39.430 application=ecto_sql [info] alter table bridged_tokens
2023-02-13T10:40:39.430 application=ecto_sql [info] == Migrated 20210309104122 in 0.0s
2023-02-13T10:40:39.431 application=ecto_sql [info] == Running 20210331074008 Explorer.Repo.Migrations.AddPoolNameDescription.change/0 forward
2023-02-13T10:40:39.431 application=ecto_sql [info] alter table staking_pools
2023-02-13T10:40:39.431 application=ecto_sql [info] == Migrated 20210331074008 in 0.0s
2023-02-13T10:40:39.432 application=ecto_sql [info] == Running 20210422115740 Explorer.Repo.Migrations.AddTokenIdToCurrentTokenBalances.change/0 forward
2023-02-13T10:40:39.432 application=ecto_sql [info] alter table address_current_token_balances
2023-02-13T10:40:39.432 application=ecto_sql [info] create index address_current_token_balances_token_id_index
2023-02-13T10:40:39.434 application=ecto_sql [info] == Migrated 20210422115740 in 0.0s
2023-02-13T10:40:39.435 application=ecto_sql [info] == Running 20210423084253 Explorer.Repo.Migrations.AddressCurrentTokenBalancesAddTokenIdToUniqueIndex.change/0 forward
2023-02-13T10:40:39.435 application=ecto_sql [info] drop index address_current_token_balances_address_hash_token_contract_address_hash_index
2023-02-13T10:40:39.435 application=ecto_sql [info] create index fetched_current_token_balances_with_token_id
2023-02-13T10:40:39.436 application=ecto_sql [info] create index fetched_current_token_balances
2023-02-13T10:40:39.437 application=ecto_sql [info] == Migrated 20210423084253 in 0.0s
2023-02-13T10:40:39.438 application=ecto_sql [info] == Running 20210423091652 Explorer.Repo.Migrations.AddressTokenBalancesAddTokenIdToUniqueIndex.change/0 forward
2023-02-13T10:40:39.439 application=ecto_sql [info] drop index address_token_balances_address_hash_token_contract_address_hash_block_number_index
2023-02-13T10:40:39.439 application=ecto_sql [info] create index fetched_token_balances_with_token_id
2023-02-13T10:40:39.440 application=ecto_sql [info] create index fetched_token_balances
2023-02-13T10:40:39.441 application=ecto_sql [info] == Migrated 20210423091652 in 0.0s
2023-02-13T10:40:39.442 application=ecto_sql [info] == Running 20210423094801 Explorer.Repo.Migrations.AddressTokenBalancesChangeUnfetchedTokenBalancesUniqueIndex.change/0 forward
2023-02-13T10:40:39.442 application=ecto_sql [info] drop index unfetched_token_balances
2023-02-13T10:40:39.442 application=ecto_sql [info] create index unfetched_token_balances
2023-02-13T10:40:39.444 application=ecto_sql [info] create index unfetched_token_balances_with_token_id
2023-02-13T10:40:39.445 application=ecto_sql [info] == Migrated 20210423094801 in 0.0s
2023-02-13T10:40:39.446 application=ecto_sql [info] == Running 20210423115108 Explorer.Repo.Migrations.ExtendTokenTransfersForErc1155.change/0 forward
2023-02-13T10:40:39.446 application=ecto_sql [info] alter table token_transfers
2023-02-13T10:40:39.447 application=ecto_sql [info] == Migrated 20210423115108 in 0.0s
2023-02-13T10:40:39.448 application=ecto_sql [info] == Running 20210524165427 Explorer.Repo.Migrations.MinMissingBlockNumber.change/0 forward
2023-02-13T10:40:39.448 application=ecto_sql [info] execute "INSERT INTO last_fetched_counters (counter_type, value, inserted_at, updated_at)\n VALUES ('min_missing_block_number', 0, NOW(), NOW());\n"
2023-02-13T10:40:39.448 application=ecto_sql [info] == Migrated 20210524165427 in 0.0s
2023-02-13T10:40:39.449 application=ecto_sql [info] == Running 20210527093756 Explorer.Repo.Migrations.TransactionStatsAddTotalFeeColumn.change/0 forward
2023-02-13T10:40:39.449 application=ecto_sql [info] alter table transaction_stats
2023-02-13T10:40:39.449 application=ecto_sql [info] == Migrated 20210527093756 in 0.0s
2023-02-13T10:40:39.450 application=ecto_sql [info] == Running 20210616120552 Explorer.Repo.Migrations.SmartContractsAddIsVyperFlag.change/0 forward
2023-02-13T10:40:39.450 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.450 application=ecto_sql [info] == Migrated 20210616120552 in 0.0s
2023-02-13T10:40:39.451 application=ecto_sql [info] == Running 20210701084814 Explorer.Repo.Migrations.SupportPartialMatch.change/0 forward
2023-02-13T10:40:39.451 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.452 application=ecto_sql [info] == Migrated 20210701084814 in 0.0s
2023-02-13T10:40:39.452 application=ecto_sql [info] == Running 20210811140837 Explorer.Repo.Migrations.Add1559Support.change/0 forward
2023-02-13T10:40:39.453 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.453 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.453 application=ecto_sql [info] == Migrated 20210811140837 in 0.0s
2023-02-13T10:40:39.454 application=ecto_sql [info] == Running 20210823144531 Explorer.Repo.Migrations.TokensAddMetadataFetchFlag.change/0 forward
2023-02-13T10:40:39.454 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.454 application=ecto_sql [info] == Migrated 20210823144531 in 0.0s
2023-02-13T10:40:39.455 application=ecto_sql [info] == Running 20210916194004 Explorer.Repo.Migrations.AddFilePathForSourcifyContracts.change/0 forward
2023-02-13T10:40:39.455 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.455 application=ecto_sql [info] == Migrated 20210916194004 in 0.0s
2023-02-13T10:40:39.456 application=ecto_sql [info] == Running 20211006121008 Explorer.Repo.Migrations.AddBlockIsEmptyFlag.change/0 forward
2023-02-13T10:40:39.456 application=ecto_sql [info] alter table blocks
2023-02-13T10:40:39.457 application=ecto_sql [info] create index blocks_is_empty_index
2023-02-13T10:40:39.458 application=ecto_sql [info] == Migrated 20211006121008 in 0.0s
2023-02-13T10:40:39.459 application=ecto_sql [info] == Running 20211013190346 Explorer.Repo.Migrations.RemoveDuplicatesOfCurrentTokenBalances.change/0 forward
2023-02-13T10:40:39.459 application=ecto_sql [info] execute "DELETE FROM address_current_token_balances\nWHERE id in (\n SELECT a.id FROM (SELECT actb.*\n FROM address_current_token_balances actb\n INNER JOIN tokens t\n ON actb.token_contract_address_hash = t.contract_address_hash\n WHERE t.type='ERC-721') AS a\nLEFT JOIN\n (SELECT actb.address_hash, actb.token_contract_address_hash, MAX(actb.value_fetched_at) AS max_value_fetched_at\n FROM address_current_token_balances actb\n INNER JOIN tokens t\n ON actb.token_contract_address_hash = t.contract_address_hash\n WHERE t.type='ERC-721'\n GROUP BY token_contract_address_hash, address_hash) c\nON a.address_hash=c.address_hash AND a.token_contract_address_hash = c.token_contract_address_hash AND a.value_fetched_at = c.max_value_fetched_at\nWHERE c.address_hash IS NULL\n);\n"
2023-02-13T10:40:39.460 application=ecto_sql [info] execute "UPDATE address_current_token_balances\nSET token_id = NULL\nWHERE id in (\n SELECT a.id FROM (SELECT actb.*\n FROM address_current_token_balances actb\n INNER JOIN tokens t\n ON actb.token_contract_address_hash = t.contract_address_hash\n WHERE t.type='ERC-721'\n AND actb.token_id IS NOT NULL\n ) a\n);\n"
2023-02-13T10:40:39.460 application=ecto_sql [info] execute "UPDATE address_current_token_balances\nSET token_type = t.type\nFROM tokens t\nWHERE address_current_token_balances.token_type IS NULL\nAND t.contract_address_hash = address_current_token_balances.token_contract_address_hash;\n"
2023-02-13T10:40:39.461 application=ecto_sql [info] execute "UPDATE address_token_balances\nSET token_type = t.type\nFROM tokens t\nWHERE address_token_balances.token_type IS NULL\nAND t.contract_address_hash = address_token_balances.token_contract_address_hash;\n"
2023-02-13T10:40:39.461 application=ecto_sql [info] == Migrated 20211013190346 in 0.0s
2023-02-13T10:40:39.462 application=ecto_sql [info] == Running 20211017135545 Explorer.Repo.Migrations.MigrateOptimizationRunsToInt8.up/0 forward
2023-02-13T10:40:39.462 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.466 application=ecto_sql [info] == Migrated 20211017135545 in 0.0s
2023-02-13T10:40:39.467 application=ecto_sql [info] == Running 20211018072347 Explorer.Repo.Migrations.AddIsEmptyIndex.change/0 forward
2023-02-13T10:40:39.468 application=ecto_sql [info] create index empty_consensus_blocks
2023-02-13T10:40:39.470 application=ecto_sql [info] == Migrated 20211018072347 in 0.0s
2023-02-13T10:40:39.471 application=ecto_sql [info] == Running 20211018073652 Explorer.Repo.Migrations.AddTokenBalancesContractAddressHashIndex.change/0 forward
2023-02-13T10:40:39.471 application=ecto_sql [info] create index address_token_balances_token_contract_address_hash_index
2023-02-13T10:40:39.473 application=ecto_sql [info] == Migrated 20211018073652 in 0.0s
2023-02-13T10:40:39.474 application=ecto_sql [info] == Running 20211018164843 Explorer.Repo.Migrations.TransactionsBlockNumberIndex.change/0 forward
2023-02-13T10:40:39.474 application=ecto_sql [info] create index transactions_block_number_index
2023-02-13T10:40:39.475 application=ecto_sql [info] == Migrated 20211018164843 in 0.0s
2023-02-13T10:40:39.477 application=ecto_sql [info] == Running 20211018170533 Explorer.Repo.Migrations.AddAddressTokenBalancesAddressHashTokenContractAddressHashBlockNumberIndex.change/0 forward
2023-02-13T10:40:39.477 application=ecto_sql [info] create index address_token_balances_address_hash_token_contract_address_hash_block_number_index
2023-02-13T10:40:39.478 application=ecto_sql [info] == Migrated 20211018170533 in 0.0s
2023-02-13T10:40:39.479 application=ecto_sql [info] == Running 20211018170638 Explorer.Repo.Migrations.AddLogsAddressHashTransactionHashIndex.change/0 forward
2023-02-13T10:40:39.479 application=ecto_sql [info] create index logs_address_hash_transaction_hash_index
2023-02-13T10:40:39.481 application=ecto_sql [info] == Migrated 20211018170638 in 0.0s
2023-02-13T10:40:39.482 application=ecto_sql [info] == Running 20211029085117 Explorer.Repo.Migrations.DropBlockRewardsBlockHashPartialIndex.change/0 forward
2023-02-13T10:40:39.482 application=ecto_sql [info] drop index if exists block_rewards_block_hash_partial_index
2023-02-13T10:40:39.482 application=ecto_sql [info] == Migrated 20211029085117 in 0.0s
2023-02-13T10:40:39.484 application=ecto_sql [info] == Running 20211115164817 Explorer.Repo.Migrations.AddCheckForBytecodeActuality.change/0 forward
2023-02-13T10:40:39.484 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.485 application=ecto_sql [info] == Migrated 20211115164817 in 0.0s
2023-02-13T10:40:39.486 application=ecto_sql [info] == Running 20211203115010 Explorer.Repo.Migrations.AddContractVerificationStatusTable.change/0 forward
2023-02-13T10:40:39.486 application=ecto_sql [info] create table contract_verification_status
2023-02-13T10:40:39.489 application=ecto_sql [info] == Migrated 20211203115010 in 0.0s
2023-02-13T10:40:39.490 application=ecto_sql [info] == Running 20211204184037 Explorer.Repo.Migrations.AddressAddGasUsed.change/0 forward
2023-02-13T10:40:39.490 application=ecto_sql [info] alter table addresses
2023-02-13T10:40:39.490 application=ecto_sql [info] == Migrated 20211204184037 in 0.0s
2023-02-13T10:40:39.492 application=ecto_sql [info] == Running 20211206071033 Explorer.Repo.Migrations.ModifyAddressGasUsedBigint.up/0 forward
2023-02-13T10:40:39.492 application=ecto_sql [info] alter table addresses
2023-02-13T10:40:39.499 application=ecto_sql [info] == Migrated 20211206071033 in 0.0s
2023-02-13T10:40:39.501 application=ecto_sql [info] == Running 20211210184136 Explorer.Repo.Migrations.AddDisplayNameToAddressTag.up/0 forward
2023-02-13T10:40:39.501 application=ecto_sql [info] alter table address_tags
2023-02-13T10:40:39.502 application=ecto_sql [info] == Migrated 20211210184136 in 0.0s
2023-02-13T10:40:39.504 application=ecto_sql [info] == Running 20211217201759 Explorer.Repo.Migrations.AddHasErrorInInternalTxsFieldToTransaction.change/0 forward
2023-02-13T10:40:39.504 application=ecto_sql [info] alter table transactions
2023-02-13T10:40:39.504 application=ecto_sql [info] == Migrated 20211217201759 in 0.0s
2023-02-13T10:40:39.505 application=ecto_sql [info] == Running 20220111085751 Explorer.Repo.Migrations.AddressAddCounters.change/0 forward
2023-02-13T10:40:39.505 application=ecto_sql [info] alter table addresses
2023-02-13T10:40:39.506 application=ecto_sql [info] == Migrated 20220111085751 in 0.0s
2023-02-13T10:40:39.507 application=ecto_sql [info] == Running 20220303083252 Explorer.Repo.Migrations.SmartContractsContractCodeMd5.change/0 forward
2023-02-13T10:40:39.507 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.508 application=ecto_sql [info] execute " UPDATE smart_contracts\n SET contract_code_md5 = md5(a.contract_code)\n FROM addresses a\n WHERE smart_contracts.address_hash = a.hash;\n"
2023-02-13T10:40:39.508 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.508 application=ecto_sql [info] drop index if exists addresses_contract_code_index
2023-02-13T10:40:39.509 application=ecto_sql [info] create index smart_contracts_contract_code_md5_index
2023-02-13T10:40:39.510 application=ecto_sql [info] == Migrated 20220303083252 in 0.0s
2023-02-13T10:40:39.511 application=ecto_sql [info] == Running 20220306091504 Explorer.Repo.Migrations.AddImplementationName.change/0 forward
2023-02-13T10:40:39.511 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.512 application=ecto_sql [info] == Migrated 20220306091504 in 0.0s
2023-02-13T10:40:39.513 application=ecto_sql [info] == Running 20220527131249 Explorer.Repo.Migrations.AddImplementationFields.change/0 forward
2023-02-13T10:40:39.513 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.513 application=ecto_sql [info] == Migrated 20220527131249 in 0.0s
2023-02-13T10:40:39.515 application=ecto_sql [info] == Running 20220622114402 Explorer.Repo.Migrations.RemoveStakingTables.change/0 forward
2023-02-13T10:40:39.515 application=ecto_sql [info] execute "DROP TABLE staking_pools_delegators CASCADE;\n"
2023-02-13T10:40:39.515 application=ecto_sql [info] execute "DROP TABLE staking_pools CASCADE;\n"
2023-02-13T10:40:39.516 application=ecto_sql [info] == Migrated 20220622114402 in 0.0s
2023-02-13T10:40:39.518 application=ecto_sql [info] == Running 20220622140604 Explorer.Repo.Migrations.RemoveBridgedTokens.change/0 forward
2023-02-13T10:40:39.518 application=ecto_sql [info] drop table if exists bridged_tokens
2023-02-13T10:40:39.518 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.519 application=ecto_sql [info] == Migrated 20220622140604 in 0.0s
2023-02-13T10:40:39.520 application=ecto_sql [info] == Running 20220706101103 Explorer.Repo.Migrations.AddressCoinBalancesDailyAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.520 application=ecto_sql [info] drop index address_coin_balances_daily_address_hash_day_index
2023-02-13T10:40:39.520 application=ecto_sql [info] alter table address_coin_balances_daily
2023-02-13T10:40:39.523 application=ecto_sql [info] == Migrated 20220706101103 in 0.0s
2023-02-13T10:40:39.524 application=ecto_sql [info] == Running 20220706102257 Explorer.Repo.Migrations.AddressCoinBalancesAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.524 application=ecto_sql [info] drop index address_coin_balances_address_hash_block_number_index
2023-02-13T10:40:39.524 application=ecto_sql [info] alter table address_coin_balances
2023-02-13T10:40:39.527 application=ecto_sql [info] == Migrated 20220706102257 in 0.0s
2023-02-13T10:40:39.529 application=ecto_sql [info] == Running 20220706102504 Explorer.Repo.Migrations.TransactionsForksAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.529 application=ecto_sql [info] drop index transaction_forks_uncle_hash_index_index
2023-02-13T10:40:39.529 application=ecto_sql [info] alter table transaction_forks
2023-02-13T10:40:39.531 application=ecto_sql [info] == Migrated 20220706102504 in 0.0s
2023-02-13T10:40:39.532 application=ecto_sql [info] == Running 20220706102746 Explorer.Repo.Migrations.BlockRewardsAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.533 application=ecto_sql [info] drop index block_rewards_address_hash_block_hash_address_type_index
2023-02-13T10:40:39.533 application=ecto_sql [info] alter table block_rewards
2023-02-13T10:40:39.535 application=ecto_sql [info] == Migrated 20220706102746 in 0.0s
2023-02-13T10:40:39.537 application=ecto_sql [info] == Running 20220706105925 Explorer.Repo.Migrations.EmissionRewardsAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.537 application=ecto_sql [info] drop index emission_rewards_block_range_index
2023-02-13T10:40:39.537 application=ecto_sql [info] alter table emission_rewards
2023-02-13T10:40:39.539 application=ecto_sql [info] == Migrated 20220706105925 in 0.0s
2023-02-13T10:40:39.540 application=ecto_sql [info] == Running 20220706111510 Explorer.Repo.Migrations.AddressNamesAddPrimaryKey.change/0 forward
2023-02-13T10:40:39.540 application=ecto_sql [info] alter table address_names
2023-02-13T10:40:39.546 application=ecto_sql [info] == Migrated 20220706111510 in 0.0s
2023-02-13T10:40:39.548 application=ecto_sql [info] == Running 20220804114005 Explorer.Repo.Migrations.CreateEventNotifications.change/0 forward
2023-02-13T10:40:39.548 application=ecto_sql [info] create table event_notifications
2023-02-13T10:40:39.551 application=ecto_sql [info] == Migrated 20220804114005 in 0.0s
2023-02-13T10:40:39.552 application=ecto_sql [info] == Running 20220902083436 Explorer.Repo.Migrations.ExtendTokenNameType.change/0 forward
2023-02-13T10:40:39.553 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.553 application=ecto_sql [info] == Migrated 20220902083436 in 0.0s
2023-02-13T10:40:39.555 application=ecto_sql [info] == Running 20220902103213 Explorer.Repo.Migrations.CreateIndexTokenTransfersTokenIds.up/0 forward
2023-02-13T10:40:39.555 application=ecto_sql [info] execute "CREATE INDEX token_transfers_token_ids_index on token_transfers USING GIN (\"token_ids\")\n"
2023-02-13T10:40:39.556 application=ecto_sql [info] == Migrated 20220902103213 in 0.0s
2023-02-13T10:40:39.557 application=ecto_sql [info] == Running 20220902103527 Explorer.Repo.Migrations.CreateIndexesTokenInstancesTokenContractAddressHashTokenId.change/0 forward
2023-02-13T10:40:39.557 application=ecto_sql [info] create index if not exists token_instances_token_contract_address_hash_token_id_index
2023-02-13T10:40:39.558 application=ecto_sql [info] create index if not exists token_instances_token_id_index
2023-02-13T10:40:39.559 application=ecto_sql [info] == Migrated 20220902103527 in 0.0s
2023-02-13T10:40:39.561 application=ecto_sql [info] == Running 20220919105140 Explorer.Repo.Migrations.AddMethodIdIndex.up/0 forward
2023-02-13T10:40:39.561 application=ecto_sql [info] execute " CREATE INDEX CONCURRENTLY IF NOT EXISTS method_id ON public.transactions USING btree (substring(input for 4));\n"
2023-02-13T10:40:39.564 application=ecto_sql [info] == Migrated 20220919105140 in 0.0s
2023-02-13T10:40:39.565 application=ecto_sql [info] == Running 20220926122620 Explorer.Repo.Migrations.ExtendTokenSymbolType.change/0 forward
2023-02-13T10:40:39.565 application=ecto_sql [info] alter table tokens
2023-02-13T10:40:39.566 application=ecto_sql [info] == Migrated 20220926122620 in 0.0s
2023-02-13T10:40:39.567 application=ecto_sql [info] == Running 20221104091552 Explorer.Repo.Migrations.AddTransactionActionsTable.change/0 forward
2023-02-13T10:40:39.567 application=ecto_sql [info] execute "CREATE TYPE transaction_actions_protocol AS ENUM ('uniswap_v3', 'opensea_v1_1', 'wrapping', 'approval', 'zkbob')"
2023-02-13T10:40:39.568 application=ecto_sql [info] execute "CREATE TYPE transaction_actions_type AS ENUM ('mint_nft', 'mint', 'burn', 'collect', 'swap', 'sale', 'cancel', 'transfer', 'wrap', 'unwrap', 'approve', 'revoke', 'withdraw', 'deposit')"
2023-02-13T10:40:39.568 application=ecto_sql [info] create table transaction_actions
2023-02-13T10:40:39.575 application=ecto_sql [info] create index transaction_actions_protocol_type_index
2023-02-13T10:40:39.581 application=ecto_sql [info] == Migrated 20221104091552 in 0.0s
2023-02-13T10:40:39.582 application=ecto_sql [info] == Running 20221104104635 Explorer.Repo.Migrations.CreateTokenTransferTokenIdMigratorProgress.change/0 forward
2023-02-13T10:40:39.582 application=ecto_sql [info] create table token_transfer_token_id_migrator_progress
2023-02-13T10:40:39.584 application=ecto_sql [info] == Migrated 20221104104635 in 0.0s
2023-02-13T10:40:39.585 application=ecto_sql [info] == Running 20221114113853 Explorer.Repo.Migrations.RemoveNotNullConstraintFromAbi.change/0 forward
2023-02-13T10:40:39.585 application=ecto_sql [info] execute "ALTER TABLE smart_contracts ALTER COLUMN abi DROP NOT NULL;"
2023-02-13T10:40:39.585 application=ecto_sql [info] == Migrated 20221114113853 in 0.0s
2023-02-13T10:40:39.586 application=ecto_sql [info] == Running 20221114121811 Explorer.Repo.Migrations.DropInternalTransactionsOrderIndex.change/0 forward
2023-02-13T10:40:39.586 application=ecto_sql [info] drop index if exists internal_transactions_block_number_DESC__transaction_index_DESC__index_DESC_index
2023-02-13T10:40:39.587 application=ecto_sql [info] == Migrated 20221114121811 in 0.0s
2023-02-13T10:40:39.588 application=ecto_sql [info] == Running 20221117075456 Explorer.Repo.Migrations.ModifyAddressTokenBalancesIndexes.change/0 forward
2023-02-13T10:40:39.588 application=ecto_sql [info] drop index if exists fetched_token_balances
2023-02-13T10:40:39.588 application=ecto_sql [info] drop index if exists fetched_token_balances_with_token_id
2023-02-13T10:40:39.588 application=ecto_sql [info] create index if not exists fetched_token_balances
2023-02-13T10:40:39.589 application=ecto_sql [info] drop index if exists unfetched_token_balances
2023-02-13T10:40:39.590 application=ecto_sql [info] drop index if exists unfetched_token_balances_with_token_id
2023-02-13T10:40:39.590 application=ecto_sql [info] create index if not exists unfetched_token_balances
2023-02-13T10:40:39.591 application=ecto_sql [info] == Migrated 20221117075456 in 0.0s
2023-02-13T10:40:39.592 application=ecto_sql [info] == Running 20221117080657 Explorer.Repo.Migrations.ModifyAddressCurrentTokenBalancesIndexes.change/0 forward
2023-02-13T10:40:39.592 application=ecto_sql [info] drop index if exists fetched_current_token_balances
2023-02-13T10:40:39.593 application=ecto_sql [info] drop index if exists fetched_current_token_balances_with_token_id
2023-02-13T10:40:39.593 application=ecto_sql [info] create index if not exists fetched_current_token_balances
2023-02-13T10:40:39.594 application=ecto_sql [info] == Migrated 20221117080657 in 0.0s
2023-02-13T10:40:39.595 application=ecto_sql [info] == Running 20221120184715 Explorer.Repo.Migrations.AddJsonCompilerSettings.change/0 forward
2023-02-13T10:40:39.595 application=ecto_sql [info] alter table smart_contracts
2023-02-13T10:40:39.596 application=ecto_sql [info] == Migrated 20221120184715 in 0.0s
2023-02-13T10:40:39.597 application=ecto_sql [info] == Running 20221125074820 Explorer.Repo.Migrations.DropRequiredOutputConstraint.change/0 forward
2023-02-13T10:40:39.597 application=ecto_sql [info] drop constraint call_has_error_or_result from table internal_transactions
2023-02-13T10:40:39.597 application=ecto_sql [info] create check constraint call_has_error_or_result on table internal_transactions
2023-02-13T10:40:39.598 application=ecto_sql [info] == Migrated 20221125074820 in 0.0s
2023-02-13T10:40:39.598 application=ecto_sql [info] == Running 20221126103223 Explorer.Repo.Migrations.AddTxsIndexes.change/0 forward
2023-02-13T10:40:39.599 application=ecto_sql [info] drop index if exists transactions_from_address_hash_recent_collated_index
2023-02-13T10:40:39.600 application=ecto_sql [info] drop index if exists transactions_to_address_hash_recent_collated_index
2023-02-13T10:40:39.602 application=ecto_sql [info] drop index if exists transactions_created_contract_address_hash_recent_collated_index
2023-02-13T10:40:39.603 application=ecto_sql [info] create index if not exists transactions_from_address_hash_with_pending_index
2023-02-13T10:40:39.606 application=ecto_sql [info] create index if not exists transactions_to_address_hash_with_pending_index
2023-02-13T10:40:39.609 application=ecto_sql [info] create index if not exists transactions_created_contract_address_hash_with_pending_index
2023-02-13T10:40:39.612 application=ecto_sql [info] == Migrated 20221126103223 in 0.0s
2023-02-13T10:40:39.613 application=ecto_sql [info] == Running 20221209123459 Explorer.Repo.Migrations.DropUnfetchedTokenBalancesIndex.change/0 forward
2023-02-13T10:40:39.613 application=ecto_sql [info] drop index if exists unfetched_token_balances
2023-02-13T10:40:39.613 application=ecto_sql [info] == Migrated 20221209123459 in 0.0s
2023-02-13T10:40:39.615 application=ecto_sql [info] == Running 20221212093406 Explorer.Repo.Migrations.ChangeIndexForPendingBlockOperations.change/0 forward
2023-02-13T10:40:39.615 application=ecto_sql [info] drop index if exists pending_block_operations_block_hash_index_partial
2023-02-13T10:40:39.615 application=ecto_sql [info] alter table pending_block_operations
2023-02-13T10:40:39.615 application=ecto_sql [info] == Migrated 20221212093406 in 0.0s
2023-02-13T10:40:39.616 application=ecto_sql [info] == Running 20221219151744 Explorer.Repo.Migrations.CreateMissingBlockRanges.change/0 forward
2023-02-13T10:40:39.616 application=ecto_sql [info] create table missing_block_ranges
2023-02-13T10:40:39.618 application=ecto_sql [info] create index missing_block_ranges_from_number_DESC_index
2023-02-13T10:40:39.619 application=ecto_sql [info] create index missing_block_ranges_from_number_to_number_index
2023-02-13T10:40:39.620 application=ecto_sql [info] == Migrated 20221219151744 in 0.0s
2023-02-13T10:40:39.621 application=ecto_sql [info] == Running 20221223151234 Explorer.Repo.Migrations.AddBlockNumberToPendingBlockOperations.change/0 forward
2023-02-13T10:40:39.622 application=ecto_sql [info] alter table pending_block_operations
2023-02-13T10:40:39.622 application=ecto_sql [info] == Migrated 20221223151234 in 0.0s
Running migrations for explorer
2023-02-13T10:40:39.850 application=ecto_sql [info] == Running 20211031164954 Explorer.Repo.Account.Migrations.CreateAccountIdentities.change/0 forward
2023-02-13T10:40:39.850 application=ecto_sql [info] create table account_identities
2023-02-13T10:40:39.858 application=ecto_sql [info] create index account_identities_uid_index
2023-02-13T10:40:39.859 application=ecto_sql [info] == Migrated 20211031164954 in 0.0s
2023-02-13T10:40:39.862 application=ecto_sql [info] == Running 20211105114502 Explorer.Repo.Account.Migrations.CreateAccountWatchlists.change/0 forward
2023-02-13T10:40:39.862 application=ecto_sql [info] create table account_watchlists
2023-02-13T10:40:39.866 application=ecto_sql [info] create index account_watchlists_identity_id_index
2023-02-13T10:40:39.867 application=ecto_sql [info] == Migrated 20211105114502 in 0.0s
2023-02-13T10:40:39.869 application=ecto_sql [info] == Running 20211105130907 Explorer.Repo.Account.Migrations.CreateAccountWatchlistAddresses.change/0 forward
2023-02-13T10:40:39.869 application=ecto_sql [info] create table account_watchlist_addresses
2023-02-13T10:40:39.873 application=ecto_sql [info] create index account_watchlist_addresses_watchlist_id_index
2023-02-13T10:40:39.875 application=ecto_sql [info] create index account_watchlist_addresses_address_hash_index
2023-02-13T10:40:39.877 application=ecto_sql [info] == Migrated 20211105130907 in 0.0s
2023-02-13T10:40:39.878 application=ecto_sql [info] == Running 20211127212336 Explorer.Repo.Account.Migrations.CreateAccountWatchlistNotifications.change/0 forward
2023-02-13T10:40:39.879 application=ecto_sql [info] create table account_watchlist_notifications
2023-02-13T10:40:39.882 application=ecto_sql [info] create index account_watchlist_notifications_watchlist_address_id_index
2023-02-13T10:40:39.883 application=ecto_sql [info] create index account_watchlist_notifications_transaction_hash_index
2023-02-13T10:40:39.885 application=ecto_sql [info] create index account_watchlist_notifications_from_address_hash_index
2023-02-13T10:40:39.886 application=ecto_sql [info] create index account_watchlist_notifications_to_address_hash_index
2023-02-13T10:40:39.887 application=ecto_sql [info] == Migrated 20211127212336 in 0.0s
2023-02-13T10:40:39.889 application=ecto_sql [info] == Running 20211205220414 Explorer.Repo.Account.Migrations.AddEmailToAccountIdentity.change/0 forward
2023-02-13T10:40:39.889 application=ecto_sql [info] alter table account_identities
2023-02-13T10:40:39.891 application=ecto_sql [info] == Migrated 20211205220414 in 0.0s
2023-02-13T10:40:39.893 application=ecto_sql [info] == Running 20220212222222 Explorer.Repo.Account.Migrations.CreateAccountTagAddresses.change/0 forward
2023-02-13T10:40:39.893 application=ecto_sql [info] create table account_tag_addresses
2023-02-13T10:40:39.896 application=ecto_sql [info] create index account_tag_addresses_identity_id_index
2023-02-13T10:40:39.897 application=ecto_sql [info] create index account_tag_addresses_address_hash_index
2023-02-13T10:40:39.899 application=ecto_sql [info] == Migrated 20220212222222 in 0.0s
2023-02-13T10:40:39.900 application=ecto_sql [info] == Running 20220313133333 Explorer.Repo.Account.Migrations.CreateAccountTagTransactions.change/0 forward
2023-02-13T10:40:39.900 application=ecto_sql [info] create table account_tag_transactions
2023-02-13T10:40:39.904 application=ecto_sql [info] create index account_tag_transactions_identity_id_index
2023-02-13T10:40:39.905 application=ecto_sql [info] create index account_tag_transactions_tx_hash_index
2023-02-13T10:40:39.906 application=ecto_sql [info] == Migrated 20220313133333 in 0.0s
2023-02-13T10:40:39.908 application=ecto_sql [info] == Running 20220324213333 Explorer.Repo.Account.Migrations.AddSubjectToWatchlistNotifications.change/0 forward
2023-02-13T10:40:39.908 application=ecto_sql [info] alter table account_watchlist_notifications
2023-02-13T10:40:39.908 application=ecto_sql [info] == Migrated 20220324213333 in 0.0s
2023-02-13T10:40:39.909 application=ecto_sql [info] == Running 20220407134152 Explorer.Repo.Account.Migrations.AddApiKeysAndPlansTables.change/0 forward
2023-02-13T10:40:39.909 application=ecto_sql [info] create table account_api_plans
2023-02-13T10:40:39.911 application=ecto_sql [info] create index account_api_plans_id_max_req_per_second_name_index
2023-02-13T10:40:39.913 application=ecto_sql [info] execute "INSERT INTO account_api_plans (id, max_req_per_second, name, inserted_at, updated_at) VALUES (1, 10, 'Free Plan', NOW(), NOW());"
2023-02-13T10:40:39.913 application=ecto_sql [info] create table account_api_keys
2023-02-13T10:40:39.915 application=ecto_sql [info] alter table account_identities
2023-02-13T10:40:39.916 application=ecto_sql [info] create index account_api_keys_identity_id_index
2023-02-13T10:40:39.917 application=ecto_sql [info] == Migrated 20220407134152 in 0.0s
2023-02-13T10:40:39.919 application=ecto_sql [info] == Running 20220510094118 Explorer.Repo.Account.Migrations.AddCustomAbisTable.change/0 forward
2023-02-13T10:40:39.919 application=ecto_sql [info] create table account_custom_abis
2023-02-13T10:40:39.922 application=ecto_sql [info] create index account_custom_abis_identity_id_address_hash_index
2023-02-13T10:40:39.923 application=ecto_sql [info] create index account_custom_abis_identity_id_index
2023-02-13T10:40:39.924 application=ecto_sql [info] == Migrated 20220510094118 in 0.0s
2023-02-13T10:40:39.926 application=ecto_sql [info] == Running 20220606194836 Explorer.Repo.Account.Migrations.AddAccountPublicTagsRequests.change/0 forward
2023-02-13T10:40:39.926 application=ecto_sql [info] create table account_public_tags_requests
2023-02-13T10:40:39.929 application=ecto_sql [info] == Migrated 20220606194836 in 0.0s
2023-02-13T10:40:39.931 application=ecto_sql [info] == Running 20220620182600 Explorer.Repo.Account.Migrations.AddAccountIdentityFields.change/0 forward
2023-02-13T10:40:39.931 application=ecto_sql [info] alter table account_identities
2023-02-13T10:40:39.931 application=ecto_sql [info] == Migrated 20220620182600 in 0.0s
2023-02-13T10:40:39.932 application=ecto_sql [info] == Running 20220624142547 Explorer.Repo.Account.Migrations.AddUniqueConstraints.change/0 forward
2023-02-13T10:40:39.932 application=ecto_sql [info] create index account_tag_addresses_identity_id_address_hash_index
2023-02-13T10:40:39.934 application=ecto_sql [info] create index account_tag_transactions_identity_id_tx_hash_index
2023-02-13T10:40:39.935 application=ecto_sql [info] create index account_watchlist_addresses_watchlist_id_address_hash_index
2023-02-13T10:40:39.936 application=ecto_sql [info] == Migrated 20220624142547 in 0.0s
2023-02-13T10:40:39.938 application=ecto_sql [info] == Running 20220705195240 Explorer.Repo.Account.Migrations.MigratePublicTagsAddressesToArray.change/0 forward
2023-02-13T10:40:39.938 application=ecto_sql [info] alter table account_public_tags_requests
2023-02-13T10:40:39.938 application=ecto_sql [info] execute " CREATE OR REPLACE FUNCTION convert(text[]) RETURNS bytea[] AS $$\n DECLARE\n s bytea[] := ARRAY[]::bytea[];\n x text;\n BEGIN\n FOREACH x IN ARRAY $1\n LOOP\n s := array_append(s, decode(replace(x, '0x', ''), 'hex'));\n END LOOP;\n RETURN s;\n END;\n $$ LANGUAGE plpgsql;\n"
2023-02-13T10:40:39.939 application=ecto_sql [info] execute " UPDATE account_public_tags_requests set addresses_duplicate = convert(string_to_array(addresses, ';'))\n"
2023-02-13T10:40:39.940 application=ecto_sql [info] alter table account_public_tags_requests
2023-02-13T10:40:39.940 application=ecto_sql [info] rename column addresses_duplicate to addresses on table account_public_tags_requests
2023-02-13T10:40:39.940 application=ecto_sql [info] == Migrated 20220705195240 in 0.0s
2023-02-13T10:40:39.941 application=ecto_sql [info] == Running 20220706114430 Explorer.Repo.Account.Migrations.EncryptAccountData.change/0 forward
2023-02-13T10:40:39.942 application=ecto_sql [info] alter table account_identities
2023-02-13T10:40:39.942 application=ecto_sql [info] alter table account_custom_abis
2023-02-13T10:40:39.942 application=ecto_sql [info] alter table account_tag_addresses
2023-02-13T10:40:39.942 application=ecto_sql [info] alter table account_tag_transactions
2023-02-13T10:40:39.943 application=ecto_sql [info] alter table account_watchlist_addresses
2023-02-13T10:40:39.943 application=ecto_sql [info] alter table account_watchlist_notifications
2023-02-13T10:40:39.943 application=ecto_sql [info] alter table account_public_tags_requests
2023-02-13T10:40:39.944 application=ecto_sql [info] == Migrated 20220706114430 in 0.0s
2023-02-13T10:40:39.945 application=ecto_sql [info] == Running 20220706153506 Explorer.Repo.Account.Migrations.RemoveUnencryptedFields.change/0 forward
2023-02-13T10:40:39.945 application=ecto_sql [info] alter table account_identities
2023-02-13T10:40:39.946 application=ecto_sql [info] rename column encrypted_uid to uid on table account_identities
2023-02-13T10:40:39.946 application=ecto_sql [info] rename column encrypted_email to email on table account_identities
2023-02-13T10:40:39.946 application=ecto_sql [info] rename column encrypted_name to name on table account_identities
2023-02-13T10:40:39.946 application=ecto_sql [info] rename column encrypted_nickname to nickname on table account_identities
2023-02-13T10:40:39.946 application=ecto_sql [info] rename column encrypted_avatar to avatar on table account_identities
2023-02-13T10:40:39.947 application=ecto_sql [info] alter table account_custom_abis
2023-02-13T10:40:39.947 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_custom_abis
2023-02-13T10:40:39.947 application=ecto_sql [info] rename column encrypted_name to name on table account_custom_abis
2023-02-13T10:40:39.947 application=ecto_sql [info] alter table account_tag_addresses
2023-02-13T10:40:39.947 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_tag_addresses
2023-02-13T10:40:39.948 application=ecto_sql [info] rename column encrypted_name to name on table account_tag_addresses
2023-02-13T10:40:39.948 application=ecto_sql [info] alter table account_tag_transactions
2023-02-13T10:40:39.948 application=ecto_sql [info] rename column encrypted_tx_hash to tx_hash on table account_tag_transactions
2023-02-13T10:40:39.948 application=ecto_sql [info] rename column encrypted_name to name on table account_tag_transactions
2023-02-13T10:40:39.948 application=ecto_sql [info] alter table account_watchlist_addresses
2023-02-13T10:40:39.949 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_watchlist_addresses
2023-02-13T10:40:39.949 application=ecto_sql [info] rename column encrypted_name to name on table account_watchlist_addresses
2023-02-13T10:40:39.949 application=ecto_sql [info] alter table account_watchlist_notifications
2023-02-13T10:40:39.950 application=ecto_sql [info] rename column encrypted_name to name on table account_watchlist_notifications
2023-02-13T10:40:39.950 application=ecto_sql [info] rename column encrypted_subject to subject on table account_watchlist_notifications
2023-02-13T10:40:39.950 application=ecto_sql [info] rename column encrypted_from_address_hash to from_address_hash on table account_watchlist_notifications
2023-02-13T10:40:39.950 application=ecto_sql [info] rename column encrypted_to_address_hash to to_address_hash on table account_watchlist_notifications
2023-02-13T10:40:39.950 application=ecto_sql [info] rename column encrypted_transaction_hash to transaction_hash on table account_watchlist_notifications
2023-02-13T10:40:39.951 application=ecto_sql [info] alter table account_public_tags_requests
2023-02-13T10:40:39.951 application=ecto_sql [info] rename column encrypted_full_name to full_name on table account_public_tags_requests
2023-02-13T10:40:39.951 application=ecto_sql [info] rename column encrypted_email to email on table account_public_tags_requests
2023-02-13T10:40:39.951 application=ecto_sql [info] == Migrated 20220706153506 in 0.0s
2023-02-13T10:40:39.953 application=ecto_sql [info] == Running 20220706211444 Explorer.Repo.Account.Migrations.SetNewIndexes.change/0 forward
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_tag_addresses_identity_id_address_hash_index
2023-02-13T10:40:39.954 application=ecto_sql [info] index "account_tag_addresses_identity_id_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_tag_transactions_identity_id_tx_hash_index
2023-02-13T10:40:39.954 application=ecto_sql [info] index "account_tag_transactions_identity_id_tx_hash_index" does not exist, skipping
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_watchlist_addresses_watchlist_id_address_hash_index
2023-02-13T10:40:39.954 application=ecto_sql [info] index "account_watchlist_addresses_watchlist_id_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_custom_abis_identity_id_address_hash_index
2023-02-13T10:40:39.954 application=ecto_sql [info] index "account_custom_abis_identity_id_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_watchlist_notifications_transaction_hash_index
2023-02-13T10:40:39.954 application=ecto_sql [info] index "account_watchlist_notifications_transaction_hash_index" does not exist, skipping
2023-02-13T10:40:39.954 application=ecto_sql [info] drop index if exists account_watchlist_notifications_from_address_hash_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_watchlist_notifications_from_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] drop index if exists account_watchlist_notifications_to_address_hash_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_watchlist_notifications_to_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] drop index if exists account_identities_uid_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_identities_uid_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] drop index if exists account_tag_addresses_address_hash_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_tag_addresses_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] drop index if exists account_tag_transactions_tx_hash_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_tag_transactions_tx_hash_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] drop index if exists account_watchlist_addresses_address_hash_index
2023-02-13T10:40:39.955 application=ecto_sql [info] index "account_watchlist_addresses_address_hash_index" does not exist, skipping
2023-02-13T10:40:39.955 application=ecto_sql [info] create index account_tag_addresses_identity_id_address_hash_hash_index
2023-02-13T10:40:39.957 application=ecto_sql [info] create index account_tag_transactions_identity_id_tx_hash_hash_index
2023-02-13T10:40:39.958 application=ecto_sql [info] create index unique_watchlist_id_address_hash_hash_index
2023-02-13T10:40:39.959 application=ecto_sql [info] create index account_custom_abis_identity_id_address_hash_hash_index
2023-02-13T10:40:39.961 application=ecto_sql [info] create index account_watchlist_notifications_transaction_hash_hash_index
2023-02-13T10:40:39.962 application=ecto_sql [info] create index account_watchlist_notifications_from_address_hash_hash_index
2023-02-13T10:40:39.963 application=ecto_sql [info] create index account_watchlist_notifications_to_address_hash_hash_index
2023-02-13T10:40:39.965 application=ecto_sql [info] create index account_identities_uid_hash_index
2023-02-13T10:40:39.966 application=ecto_sql [info] create index account_tag_addresses_address_hash_hash_index
2023-02-13T10:40:39.968 application=ecto_sql [info] create index account_tag_transactions_tx_hash_hash_index
2023-02-13T10:40:39.969 application=ecto_sql [info] create index account_watchlist_addresses_address_hash_hash_index
2023-02-13T10:40:39.970 application=ecto_sql [info] == Migrated 20220706211444 in 0.0s
2023-02-13T10:40:39.972 application=ecto_sql [info] == Running 20220905195203 Explorer.Repo.Account.Migrations.RemoveGuardianTokens.change/0 forward
2023-02-13T10:40:39.972 application=ecto_sql [info] drop table if exists guardian_tokens
2023-02-13T10:40:39.972 application=ecto_sql [info] table "guardian_tokens" does not exist, skipping
2023-02-13T10:40:39.972 application=ecto_sql [info] == Migrated 20220905195203 in 0.0s
Success!
2023-02-13T10:40:41.239 application=que [info] [Que] Booting Que
2023-02-13T10:40:41.239 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:40:41.286 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.286 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:40:41.286 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:40:41.302 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.302 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:40:41.302 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:40:41.305 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.305 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:40:41.305 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:40:41.344 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.344 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:40:41.344 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:40:41.345 application=db_connection [error] Postgrex.Protocol (#PID<0.4143.0>) failed to connect: ** (Postgrex.Error) FATAL 53300 (too_many_connections) sorry, too many clients already
2023-02-13T10:40:41.348 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.348 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z
2023-02-13T10:40:41.348 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z
2023-02-13T10:40:41.351 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.351 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z
2023-02-13T10:40:41.351 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z
2023-02-13T10:40:41.353 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.353 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z
2023-02-13T10:40:41.353 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z
2023-02-13T10:40:41.355 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http)
2023-02-13T10:40:41.355 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.355 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z
2023-02-13T10:40:41.355 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z
2023-02-13T10:40:41.357 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000
2023-02-13T10:40:41.358 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.358 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z
2023-02-13T10:40:41.358 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z
2023-02-13T10:40:41.360 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:41.360 application=explorer [info] tx/per day chart: records collected [%{date: ~D[2023-02-12], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-11], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-10], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-09], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-08], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-07], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-06], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-05], gas_used: 0, number_of_transactions: 0, total_fee: 0}, %{date: ~D[2023-02-04], gas_used: 0, number_of_transactions: 0, total_fee: 0}]
2023-02-13T10:40:41.360 application=explorer [info] tx/per day chart: save records
2023-02-13T10:40:41.360 [notice] Application indexer exited: Indexer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Indexer.Supervisor
** (EXIT) shutdown: failed to start child: Indexer.Block.Catchup.Supervisor
** (EXIT) shutdown: failed to start child: Indexer.Block.Catchup.MissingRangesCollector
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, :econnrefused}
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:196: Indexer.Block.Catchup.MissingRangesCollector.fetch_max_block_number/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:113: Indexer.Block.Catchup.MissingRangesCollector.get_initial_min_max/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:42: Indexer.Block.Catchup.MissingRangesCollector.default_init/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:24: Indexer.Block.Catchup.MissingRangesCollector.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
2023-02-13T10:40:41.361 application=explorer [info] tx/per day chart: number of inserted 10
{"Kernel pid terminated",application_controller,"{application_start_failure,indexer,{{shutdown,{failed_to_start_child,'Elixir.Indexer.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.MissingRangesCollector',{{badmatch,{error,econnrefused}},[{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',fetch_max_block_number,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,196}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',get_initial_min_max,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,113}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',default_init,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,42}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',init,1,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,24}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}}}}}},{'Elixir.Indexer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,indexer,{{shutdown,{failed_to_start_child,'Elixir.Indexer.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.MissingRangesCollector',{{badmatch,{error,econnrefused}},[{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',fetch_max_block_number,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,196}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',get_initial_min_max,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,113}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',default_init,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,42}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',init,1,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,24}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{fil
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:40:44.128 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:40:44.131 application=ecto_sql [info] Migrations already up
2023-02-13T10:40:45.358 application=que [info] [Que] Booting Que
2023-02-13T10:40:45.358 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:40:45.400 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:45.400 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:40:45.400 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:40:45.405 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:45.405 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:40:45.405 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:40:45.409 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:45.409 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:40:45.409 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:40:45.410 application=db_connection [info] Postgrex.Protocol (#PID<0.4111.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:40:45.411 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:40:48.218 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:40:48.220 application=ecto_sql [info] Migrations already up
2023-02-13T10:40:49.443 application=que [info] [Que] Booting Que
2023-02-13T10:40:49.443 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:40:49.497 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:49.497 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:40:49.497 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:40:49.501 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:49.501 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:40:49.501 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:40:49.504 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:49.504 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:40:49.504 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:40:49.507 application=db_connection [info] Postgrex.Protocol (#PID<0.4118.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:40:49.507 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:40:52.731 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:40:52.734 application=ecto_sql [info] Migrations already up
2023-02-13T10:40:54.005 application=que [info] [Que] Booting Que
2023-02-13T10:40:54.005 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:40:54.046 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:54.046 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:40:54.046 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:40:54.051 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:54.051 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:40:54.051 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:40:54.054 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:54.054 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:40:54.054 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:40:54.057 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:54.057 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:40:54.057 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:40:54.060 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:54.060 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z
2023-02-13T10:40:54.060 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z
2023-02-13T10:40:54.061 application=db_connection [info] Postgrex.Protocol (#PID<0.4082.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:40:54.061 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:40:58.077 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:40:58.080 application=ecto_sql [info] Migrations already up
2023-02-13T10:40:59.327 application=que [info] [Que] Booting Que
2023-02-13T10:40:59.327 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:40:59.369 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:59.369 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:40:59.369 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:40:59.372 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:59.372 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:40:59.372 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:40:59.375 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:59.376 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:40:59.376 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:40:59.379 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:40:59.379 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:40:59.379 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:40:59.380 application=db_connection [info] Postgrex.Protocol (#PID<0.4121.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:40:59.380 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:41:05.018 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:41:05.021 application=ecto_sql [info] Migrations already up
2023-02-13T10:41:06.256 application=que [info] [Que] Booting Que
2023-02-13T10:41:06.256 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:41:06.304 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:06.304 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:41:06.304 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:41:06.309 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:06.309 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:41:06.309 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:41:06.312 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:06.312 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:41:06.312 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:41:06.316 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:06.316 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:41:06.316 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:41:06.317 application=db_connection [info] Postgrex.Protocol (#PID<0.4104.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:41:06.318 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:41:15.114 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:41:15.117 application=ecto_sql [info] Migrations already up
2023-02-13T10:41:16.351 application=que [info] [Que] Booting Que
2023-02-13T10:41:16.351 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:41:16.411 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:16.411 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:41:16.411 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:41:16.415 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:16.415 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:41:16.415 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:41:16.418 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:16.418 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:41:16.418 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:41:16.421 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:16.421 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:41:16.421 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:41:16.423 application=db_connection [info] Postgrex.Protocol (#PID<0.4099.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:41:16.423 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:41:31.639 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:41:31.642 application=ecto_sql [info] Migrations already up
2023-02-13T10:41:32.883 application=que [info] [Que] Booting Que
2023-02-13T10:41:32.884 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:41:32.947 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:32.947 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:41:32.947 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:41:32.950 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:32.950 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:41:32.950 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:41:32.954 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:32.954 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:41:32.954 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:41:32.957 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:41:32.957 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:41:32.957 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:41:32.959 application=db_connection [info] Postgrex.Protocol (#PID<0.4101.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:41:32.959 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:42:00.966 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:42:00.969 application=ecto_sql [info] Migrations already up
2023-02-13T10:42:02.212 application=que [info] [Que] Booting Que
2023-02-13T10:42:02.213 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:42:02.261 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:02.261 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:42:02.261 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:42:02.264 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:02.264 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:42:02.264 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:42:02.268 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:02.268 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:42:02.268 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:42:02.271 application=db_connection [info] Postgrex.Protocol (#PID<0.4102.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:42:02.272 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:42:55.866 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:42:55.869 application=ecto_sql [info] Migrations already up
2023-02-13T10:42:57.554 application=que [info] [Que] Booting Que
2023-02-13T10:42:57.554 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:42:57.614 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:57.614 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:42:57.614 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:42:57.618 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:57.619 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:42:57.619 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:42:57.624 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:57.624 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:42:57.624 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:42:57.628 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:42:57.628 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:42:57.628 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:42:57.629 application=db_connection [info] Postgrex.Protocol (#PID<0.4122.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:42:57.631 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:44:00.133 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:44:00.136 application=ecto_sql [info] Migrations already up
2023-02-13T10:44:01.391 application=que [info] [Que] Booting Que
2023-02-13T10:44:01.391 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:44:01.439 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.439 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:44:01.439 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:44:01.452 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.452 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:44:01.452 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:44:01.460 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.460 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:44:01.460 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:44:01.462 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http)
2023-02-13T10:44:01.465 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000
2023-02-13T10:44:01.466 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.466 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:44:01.466 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:44:01.466 application=db_connection [error] Postgrex.Protocol (#PID<0.4148.0>) failed to connect: ** (Postgrex.Error) FATAL 53300 (too_many_connections) sorry, too many clients already
2023-02-13T10:44:01.469 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.470 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z
2023-02-13T10:44:01.470 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z
2023-02-13T10:44:01.469 [notice] Application indexer exited: Indexer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Indexer.Supervisor
** (EXIT) shutdown: failed to start child: Indexer.Block.Catchup.Supervisor
** (EXIT) shutdown: failed to start child: Indexer.Block.Catchup.MissingRangesCollector
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, :econnrefused}
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:196: Indexer.Block.Catchup.MissingRangesCollector.fetch_max_block_number/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:113: Indexer.Block.Catchup.MissingRangesCollector.get_initial_min_max/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:42: Indexer.Block.Catchup.MissingRangesCollector.default_init/0
(indexer 5.0.0) lib/indexer/block/catchup/missing_ranges_collector.ex:24: Indexer.Block.Catchup.MissingRangesCollector.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
2023-02-13T10:44:01.472 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.472 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z
2023-02-13T10:44:01.472 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z
2023-02-13T10:44:01.476 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:44:01.476 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z
2023-02-13T10:44:01.476 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z
2023-02-13T10:44:01.477 application=db_connection [info] Postgrex.Protocol (#PID<0.4083.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
{"Kernel pid terminated",application_controller,"{application_start_failure,indexer,{{shutdown,{failed_to_start_child,'Elixir.Indexer.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.MissingRangesCollector',{{badmatch,{error,econnrefused}},[{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',fetch_max_block_number,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,196}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',get_initial_min_max,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,113}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',default_init,0,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,42}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',init,1,[{file,\"lib/indexer/block/catchup/missing_ranges_collector.ex\"},{line,24}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}}}}}},{'Elixir.Indexer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,indexer,{{shutdown,{failed_to_start_child,'Elixir.Indexer.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.Supervisor',{shutdown,{failed_to_start_child,'Elixir.Indexer.Block.Catchup.MissingRangesCollector',{{badmatch,{error,econnrefused}},[{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',fetch_max_block_number,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,196}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',get_initial_min_max,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,113}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',default_init,0,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,42}]},{'Elixir.Indexer.Block.Catchup.MissingRangesCollector',init,1,[{file,"lib/indexer/block/catchup/missing_ranges_collector.ex"},{line,24}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{fil
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:45:03.876 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:45:03.879 application=ecto_sql [info] Migrations already up
2023-02-13T10:45:05.113 application=que [info] [Que] Booting Que
2023-02-13T10:45:05.114 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:45:05.140 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:45:05.140 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:45:05.140 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:45:05.144 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:45:05.144 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:45:05.144 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:45:05.147 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:45:05.147 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:45:05.147 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:45:05.150 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:45:05.150 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:45:05.150 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:45:05.152 application=db_connection [info] Postgrex.Protocol (#PID<0.4119.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:45:05.152 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:46:07.629 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:46:07.632 application=ecto_sql [info] Migrations already up
2023-02-13T10:46:08.872 application=que [info] [Que] Booting Que
2023-02-13T10:46:08.873 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:46:08.905 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:46:08.905 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:46:08.905 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:46:08.908 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:46:08.908 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:46:08.908 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:46:08.911 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:46:08.911 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:46:08.911 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:46:08.915 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:46:08.915 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:46:08.915 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:46:08.916 application=db_connection [info] Postgrex.Protocol (#PID<0.4115.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:46:08.916 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:47:11.404 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:47:11.407 application=ecto_sql [info] Migrations already up
2023-02-13T10:47:12.685 application=que [info] [Que] Booting Que
2023-02-13T10:47:12.685 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:47:12.743 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:47:12.743 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:47:12.743 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:47:12.747 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:47:12.747 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:47:12.747 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:47:12.751 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:47:12.751 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:47:12.751 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:47:12.754 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:47:12.754 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:47:12.754 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:47:12.756 application=db_connection [info] Postgrex.Protocol (#PID<0.4117.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:47:12.757 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
{"Kernel pid terminated",application_controller,"{application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<\"proc.c\">>,line => <<\"359\">>,message => <<\"sorry, too many clients already\">>,pg_code => <<\"53300\">>,routine => <<\"InitProcess\">>,severity => <<\"FATAL\">>,unknown => <<\"FATAL\">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,\"lib/explorer/chain/events/listener.ex\"},{line,17}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,423}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,explorer,{{shutdown,{failed_to_start_child,'Elixir.Explorer.Chain.Events.Listener',{{badmatch,{error,#{'__exception__' => true,'__struct__' => 'Elixir.Postgrex.Error',connection_id => nil,message => nil,postgres => #{code => too_many_connections,file => <<"proc.c">>,line => <<"359">>,message => <<"sorry, too many clients already">>,pg_code => <<"53300">>,routine => <<"InitProcess">>,severity => <<"FATAL">>,unknown => <<"FATAL">>},query => nil}}},[{'Elixir.Explorer.Chain.Events.Listener',init,1,[{file,"lib/explorer/chain/events/listener.ex"},{line,17}]},{gen_server,init_it,2,[{file,"gen_server.erl"},{line,423}]},{gen_server,init_it,6,[{file,"gen_server.erl"},{line,390}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}}},{'Elixir.Explorer.Application',start,[normal,[]]}}})
Crash dump is being written to: erl_crash.dump...done
Starting dependencies..
Starting repos..
Create Explorer.Repo database if it doesn't exist
Create Explorer.Repo.Account database if it doesn't exist
Running migrations for explorer
2023-02-13T10:48:15.184 application=ecto_sql [info] Migrations already up
Running migrations for explorer
Success!
2023-02-13T10:48:15.187 application=ecto_sql [info] Migrations already up
2023-02-13T10:48:16.441 application=que [info] [Que] Booting Que
2023-02-13T10:48:16.441 application=que [info] [Que] Booting Server Supervisor for Workers
2023-02-13T10:48:16.488 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:48:16.488 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z
2023-02-13T10:48:16.488 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z
2023-02-13T10:48:16.492 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:48:16.492 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z
2023-02-13T10:48:16.492 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z
2023-02-13T10:48:16.496 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:48:16.496 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z
2023-02-13T10:48:16.496 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z
2023-02-13T10:48:16.498 application=explorer [info] tx/per day chart: collect records for txs per day stats
2023-02-13T10:48:16.499 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z
2023-02-13T10:48:16.499 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z
2023-02-13T10:48:16.499 application=db_connection [info] Postgrex.Protocol (#PID<0.4082.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4504.0> exited
2023-02-13T10:48:16.500 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
** (EXIT) an exception was raised:
** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: nil, postgres: %{code: :too_many_connections, file: "proc.c", line: "359", message: "sorry, too many clients already", pg_code: "53300", routine: "InitProcess", severity: "FATAL", unknown: "FATAL"}, query: nil}}
(explorer 5.0.0) lib/explorer/chain/events/listener.ex:17: Explorer.Chain.Events.Listener.init/1
(stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
(stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
(stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment