Created
February 13, 2023 13:22
-
-
Save ondratra/a22a362b7f6ac6c8b890d1be570130ae to your computer and use it in GitHub Desktop.
Blockscout - docker log 2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Starting dependencies.. | |
| Starting repos.. | |
| Create Explorer.Repo database if it doesn't exist | |
| 2023-02-13T13:20:04.951 application=db_connection [error] Postgrex.Protocol (#PID<0.185.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed | |
| 2023-02-13T13:20:04.951 application=db_connection [error] Postgrex.Protocol (#PID<0.189.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed | |
| 2023-02-13T13:20:04.951 application=db_connection [error] Postgrex.Protocol (#PID<0.190.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed | |
| 2023-02-13T13:20:04.951 application=db_connection [error] Postgrex.Protocol (#PID<0.184.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed | |
| 2023-02-13T13:20:04.951 [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-13T13:20:04.958 [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-13T13:20:04.959 [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-13T13:20:04.961 [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-13T13:20:05.980 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-13T13:20:06.358 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-13T13:20:06.387 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-13T13:20:07.320 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-13T13:20:07.698 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-13T13:20:07.937 application=ecto_sql [error] Could not create schema migrations table. This error usually happens due to the following: | |
| * 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. | |
| ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2969ms. 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 | |
| Starting dependencies.. | |
| Starting repos.. | |
| Create Explorer.Repo database if it doesn't exist | |
| 2023-02-13T13:20:08.959 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-13T13:20:08.959 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-13T13:20:08.959 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-13T13:20:08.959 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 | |
| Create Explorer.Repo.Account database if it doesn't exist | |
| Running migrations for explorer | |
| 2023-02-13T13:20:11.754 application=ecto_sql [info] == Running 20180117221921 Explorer.Repo.Migrations.CreateAddress.change/0 forward | |
| 2023-02-13T13:20:11.754 application=ecto_sql [info] create table addresses | |
| 2023-02-13T13:20:11.768 application=ecto_sql [info] == Migrated 20180117221921 in 0.0s | |
| 2023-02-13T13:20:11.793 application=ecto_sql [info] == Running 20180117221922 Explorer.Repo.Migrations.CreateBlocks.change/0 forward | |
| 2023-02-13T13:20:11.793 application=ecto_sql [info] create table blocks | |
| 2023-02-13T13:20:11.798 application=ecto_sql [info] create index blocks_timestamp_index | |
| 2023-02-13T13:20:11.799 application=ecto_sql [info] create index one_consensus_child_per_parent | |
| 2023-02-13T13:20:11.800 application=ecto_sql [info] create index one_consensus_block_at_height | |
| 2023-02-13T13:20:11.802 application=ecto_sql [info] == Migrated 20180117221922 in 0.0s | |
| 2023-02-13T13:20:11.803 application=ecto_sql [info] == Running 20180117221923 Explorer.Repo.Migrations.CreateTransactions.change/0 forward | |
| 2023-02-13T13:20:11.803 application=ecto_sql [info] create table transactions | |
| 2023-02-13T13:20:11.808 application=ecto_sql [info] create check constraint collated_block_number on table transactions | |
| 2023-02-13T13:20:11.808 application=ecto_sql [info] create check constraint collated_cumalative_gas_used on table transactions | |
| 2023-02-13T13:20:11.808 application=ecto_sql [info] create check constraint collated_gas_used on table transactions | |
| 2023-02-13T13:20:11.808 application=ecto_sql [info] create check constraint collated_index on table transactions | |
| 2023-02-13T13:20:11.809 application=ecto_sql [info] create check constraint status on table transactions | |
| 2023-02-13T13:20:11.809 application=ecto_sql [info] create check constraint error on table transactions | |
| 2023-02-13T13:20:11.809 application=ecto_sql [info] create check constraint pending_block_number on table transactions | |
| 2023-02-13T13:20:11.809 application=ecto_sql [info] create check constraint pending_cumalative_gas_used on table transactions | |
| 2023-02-13T13:20:11.810 application=ecto_sql [info] create check constraint pending_gas_used on table transactions | |
| 2023-02-13T13:20:11.810 application=ecto_sql [info] create check constraint pending_index on table transactions | |
| 2023-02-13T13:20:11.810 application=ecto_sql [info] create index transactions_block_hash_index | |
| 2023-02-13T13:20:11.811 application=ecto_sql [info] create index transactions_inserted_at_index | |
| 2023-02-13T13:20:11.812 application=ecto_sql [info] create index transactions_updated_at_index | |
| 2023-02-13T13:20:11.814 application=ecto_sql [info] create index transactions_status_index | |
| 2023-02-13T13:20:11.815 application=ecto_sql [info] create index transactions_recent_collated_index | |
| 2023-02-13T13:20:11.816 application=ecto_sql [info] create index transactions_from_address_hash_recent_collated_index | |
| 2023-02-13T13:20:11.818 application=ecto_sql [info] create index transactions_to_address_hash_recent_collated_index | |
| 2023-02-13T13:20:11.819 application=ecto_sql [info] create index transactions_created_contract_address_hash_recent_collated_index | |
| 2023-02-13T13:20:11.820 application=ecto_sql [info] create index transactions_block_hash_index_index | |
| 2023-02-13T13:20:11.823 application=ecto_sql [info] == Migrated 20180117221923 in 0.0s | |
| 2023-02-13T13:20:11.824 application=ecto_sql [info] == Running 20180212222309 Explorer.Repo.Migrations.CreateLogs.change/0 forward | |
| 2023-02-13T13:20:11.824 application=ecto_sql [info] create table logs | |
| 2023-02-13T13:20:11.828 application=ecto_sql [info] create index logs_address_hash_index | |
| 2023-02-13T13:20:11.829 application=ecto_sql [info] create index logs_transaction_hash_index | |
| 2023-02-13T13:20:11.830 application=ecto_sql [info] create index logs_index_index | |
| 2023-02-13T13:20:11.831 application=ecto_sql [info] create index logs_type_index | |
| 2023-02-13T13:20:11.833 application=ecto_sql [info] create index logs_first_topic_index | |
| 2023-02-13T13:20:11.834 application=ecto_sql [info] create index logs_second_topic_index | |
| 2023-02-13T13:20:11.835 application=ecto_sql [info] create index logs_third_topic_index | |
| 2023-02-13T13:20:11.836 application=ecto_sql [info] create index logs_fourth_topic_index | |
| 2023-02-13T13:20:11.839 application=ecto_sql [info] create index logs_transaction_hash_index_index | |
| 2023-02-13T13:20:11.841 application=ecto_sql [info] == Migrated 20180212222309 in 0.0s | |
| 2023-02-13T13:20:11.842 application=ecto_sql [info] == Running 20180221001948 Explorer.Repo.Migrations.CreateInternalTransactions.change/0 forward | |
| 2023-02-13T13:20:11.842 application=ecto_sql [info] create table internal_transactions | |
| 2023-02-13T13:20:11.846 application=ecto_sql [info] create check constraint call_has_error_or_result on table internal_transactions | |
| 2023-02-13T13:20:11.847 application=ecto_sql [info] create check constraint create_has_error_or_result on table internal_transactions | |
| 2023-02-13T13:20:11.847 application=ecto_sql [info] create check constraint suicide_has_from_and_to_address_hashes on table internal_transactions | |
| 2023-02-13T13:20:11.847 application=ecto_sql [info] create index internal_transactions_created_contract_address_hash_index | |
| 2023-02-13T13:20:11.849 application=ecto_sql [info] create index internal_transactions_from_address_hash_index | |
| 2023-02-13T13:20:11.850 application=ecto_sql [info] create index internal_transactions_to_address_hash_index | |
| 2023-02-13T13:20:11.851 application=ecto_sql [info] create index internal_transactions_transaction_hash_index | |
| 2023-02-13T13:20:11.852 application=ecto_sql [info] create index internal_transactions_transaction_hash_index_index | |
| 2023-02-13T13:20:11.853 application=ecto_sql [info] == Migrated 20180221001948 in 0.0s | |
| 2023-02-13T13:20:11.856 application=ecto_sql [info] == Running 20180424203101 Explorer.Repo.Migrations.CreateMarketHistory.change/0 forward | |
| 2023-02-13T13:20:11.857 application=ecto_sql [info] create table market_history | |
| 2023-02-13T13:20:11.859 application=ecto_sql [info] create index market_history_date_index | |
| 2023-02-13T13:20:11.861 application=ecto_sql [info] == Migrated 20180424203101 in 0.0s | |
| 2023-02-13T13:20:11.862 application=ecto_sql [info] == Running 20180508183700 Explorer.Repo.Migrations.CreateUsers.change/0 forward | |
| 2023-02-13T13:20:11.862 application=ecto_sql [info] create table users | |
| 2023-02-13T13:20:11.865 application=ecto_sql [info] create index unique_username | |
| 2023-02-13T13:20:11.866 application=ecto_sql [info] == Migrated 20180508183700 in 0.0s | |
| 2023-02-13T13:20:11.868 application=ecto_sql [info] == Running 20180508191045 Explorer.Repo.Migrations.CreateUserContacts.change/0 forward | |
| 2023-02-13T13:20:11.868 application=ecto_sql [info] create table user_contacts | |
| 2023-02-13T13:20:11.870 application=ecto_sql [info] create index user_contacts_user_id_index | |
| 2023-02-13T13:20:11.872 application=ecto_sql [info] create index email_unique_for_user | |
| 2023-02-13T13:20:11.873 application=ecto_sql [info] create index one_primary_per_user | |
| 2023-02-13T13:20:11.874 application=ecto_sql [info] == Migrated 20180508191045 in 0.0s | |
| 2023-02-13T13:20:11.875 application=ecto_sql [info] == Running 20180518221256 Explorer.Repo.Migrations.CreateSmartContractVerified.change/0 forward | |
| 2023-02-13T13:20:11.875 application=ecto_sql [info] create table smart_contracts | |
| 2023-02-13T13:20:11.878 application=ecto_sql [info] create index smart_contracts_address_hash_index | |
| 2023-02-13T13:20:11.880 application=ecto_sql [info] == Migrated 20180518221256 in 0.0s | |
| 2023-02-13T13:20:11.881 application=ecto_sql [info] == Running 20180522154252 Explorer.Repo.Migrations.CreateBtreeGistExtension.change/0 forward | |
| 2023-02-13T13:20:11.882 application=ecto_sql [info] execute "CREATE EXTENSION IF NOT EXISTS btree_gist" | |
| 2023-02-13T13:20:11.907 application=ecto_sql [info] == Migrated 20180522154252 in 0.0s | |
| 2023-02-13T13:20:11.911 application=ecto_sql [info] == Running 20180522154253 Explorer.Repo.Migrations.CreateBlockRewards.change/0 forward | |
| 2023-02-13T13:20:11.911 application=ecto_sql [info] create table block_rewards | |
| 2023-02-13T13:20:11.912 application=ecto_sql [info] create exclude constraint no_overlapping_ranges on table block_rewards | |
| 2023-02-13T13:20:11.913 application=ecto_sql [info] == Migrated 20180522154253 in 0.0s | |
| 2023-02-13T13:20:11.914 application=ecto_sql [info] == Running 20180606135149 Explorer.Repo.Migrations.CreateTokens.change/0 forward | |
| 2023-02-13T13:20:11.914 application=ecto_sql [info] create table tokens | |
| 2023-02-13T13:20:11.916 application=ecto_sql [info] create index tokens_contract_address_hash_index | |
| 2023-02-13T13:20:11.918 application=ecto_sql [info] == Migrated 20180606135149 in 0.0s | |
| 2023-02-13T13:20:11.919 application=ecto_sql [info] == Running 20180606135150 Explorer.Repo.Migrations.CreateTokenTransfers.change/0 forward | |
| 2023-02-13T13:20:11.919 application=ecto_sql [info] create table token_transfers | |
| 2023-02-13T13:20:11.923 application=ecto_sql [info] create index token_transfers_transaction_hash_index | |
| 2023-02-13T13:20:11.926 application=ecto_sql [info] create index token_transfers_to_address_hash_transaction_hash_index | |
| 2023-02-13T13:20:11.927 application=ecto_sql [info] create index token_transfers_from_address_hash_transaction_hash_index | |
| 2023-02-13T13:20:11.928 application=ecto_sql [info] create index token_transfers_token_contract_address_hash_transaction_hash_index | |
| 2023-02-13T13:20:11.930 application=ecto_sql [info] create index token_transfers_transaction_hash_log_index_index | |
| 2023-02-13T13:20:11.931 application=ecto_sql [info] == Migrated 20180606135150 in 0.0s | |
| 2023-02-13T13:20:11.932 application=ecto_sql [info] == Running 20180626143840 Explorer.Repo.Migrations.AddInsertedAtIndexToBlocks.change/0 forward | |
| 2023-02-13T13:20:11.932 application=ecto_sql [info] create index blocks_inserted_at_index | |
| 2023-02-13T13:20:11.934 application=ecto_sql [info] == Migrated 20180626143840 in 0.0s | |
| 2023-02-13T13:20:11.935 application=ecto_sql [info] == Running 20180717204948 Explorer.Repo.Migrations.CreateCoinBalances.change/0 forward | |
| 2023-02-13T13:20:11.935 application=ecto_sql [info] create table address_coin_balances | |
| 2023-02-13T13:20:11.937 application=ecto_sql [info] create index address_coin_balances_address_hash_block_number_index | |
| 2023-02-13T13:20:11.939 application=ecto_sql [info] create index unfetched_balances | |
| 2023-02-13T13:20:11.941 application=ecto_sql [info] == Migrated 20180717204948 in 0.0s | |
| 2023-02-13T13:20:11.942 application=ecto_sql [info] == Running 20180817021704 Explorer.Repo.Migrations.CreateAddressTokenBalances.change/0 forward | |
| 2023-02-13T13:20:11.942 application=ecto_sql [info] create table address_token_balances | |
| 2023-02-13T13:20:11.945 application=ecto_sql [info] create index address_token_balances_address_hash_token_contract_address_hash_block_number_index | |
| 2023-02-13T13:20:11.946 application=ecto_sql [info] create index unfetched_token_balances | |
| 2023-02-13T13:20:11.948 application=ecto_sql [info] == Migrated 20180817021704 in 0.0s | |
| 2023-02-13T13:20:11.949 application=ecto_sql [info] == Running 20180821142139 Explorer.Repo.Migrations.CreateAddressNames.change/0 forward | |
| 2023-02-13T13:20:11.949 application=ecto_sql [info] create table address_names | |
| 2023-02-13T13:20:11.951 application=ecto_sql [info] create index address_names_address_hash_index | |
| 2023-02-13T13:20:11.953 application=ecto_sql [info] create index unique_address_names | |
| 2023-02-13T13:20:11.954 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-13T13:20:11.955 application=ecto_sql [info] == Migrated 20180821142139 in 0.0s | |
| 2023-02-13T13:20:11.956 application=ecto_sql [info] == Running 20180917182319 Explorer.Repo.Migrations.CreateBlockSecondDegreeRelations.change/0 forward | |
| 2023-02-13T13:20:11.957 application=ecto_sql [info] create table block_second_degree_relations | |
| 2023-02-13T13:20:11.958 application=ecto_sql [info] create index nephew_hash_to_uncle_hash | |
| 2023-02-13T13:20:11.960 application=ecto_sql [info] create index unfetched_uncles | |
| 2023-02-13T13:20:11.961 application=ecto_sql [info] create index uncle_hash_to_nephew_hash | |
| 2023-02-13T13:20:11.962 application=ecto_sql [info] == Migrated 20180917182319 in 0.0s | |
| 2023-02-13T13:20:11.964 application=ecto_sql [info] == Running 20180918200001 Explorer.Repo.Migrations.CreateTransactionBlockUncles.change/0 forward | |
| 2023-02-13T13:20:11.964 application=ecto_sql [info] create table transaction_forks | |
| 2023-02-13T13:20:11.967 application=ecto_sql [info] create index transaction_forks_uncle_hash_index | |
| 2023-02-13T13:20:11.968 application=ecto_sql [info] create index transaction_forks_uncle_hash_index_index | |
| 2023-02-13T13:20:11.969 application=ecto_sql [info] == Migrated 20180918200001 in 0.0s | |
| 2023-02-13T13:20:11.970 application=ecto_sql [info] == Running 20180919175123 Explorer.Repo.Migrations.AlterTokenDecimalsToBigint.up/0 forward | |
| 2023-02-13T13:20:11.970 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:11.974 application=ecto_sql [info] == Migrated 20180919175123 in 0.0s | |
| 2023-02-13T13:20:11.975 application=ecto_sql [info] == Running 20181008195723 Explorer.Repo.Migrations.CreateAdministrators.change/0 forward | |
| 2023-02-13T13:20:11.975 application=ecto_sql [info] create table administrators | |
| 2023-02-13T13:20:11.977 application=ecto_sql [info] create index owner_role_limit | |
| 2023-02-13T13:20:11.978 application=ecto_sql [info] create index administrators_user_id_index | |
| 2023-02-13T13:20:11.979 application=ecto_sql [info] == Migrated 20181008195723 in 0.0s | |
| 2023-02-13T13:20:11.980 application=ecto_sql [info] == Running 20181011193212 Explorer.Repo.Migrations.AddFieldsToInternalTransactions.up/0 forward | |
| 2023-02-13T13:20:11.980 application=ecto_sql [info] alter table internal_transactions | |
| 2023-02-13T13:20:11.981 application=ecto_sql [info] == Migrated 20181011193212 in 0.0s | |
| 2023-02-13T13:20:11.982 application=ecto_sql [info] == Running 20181015173318 Explorer.Repo.Migrations.AddCaseInsensitiveExtension.change/0 forward | |
| 2023-02-13T13:20:11.982 application=ecto_sql [info] execute "CREATE EXTENSION IF NOT EXISTS citext" | |
| 2023-02-13T13:20:11.989 application=ecto_sql [info] == Migrated 20181015173318 in 0.0s | |
| 2023-02-13T13:20:11.992 application=ecto_sql [info] == Running 20181015173319 Explorer.Repo.Migrations.ModifyUsersUsername.up/0 forward | |
| 2023-02-13T13:20:11.992 application=ecto_sql [info] drop index unique_username | |
| 2023-02-13T13:20:11.992 application=ecto_sql [info] alter table users | |
| 2023-02-13T13:20:11.993 application=ecto_sql [info] create index unique_username | |
| 2023-02-13T13:20:11.994 application=ecto_sql [info] == Migrated 20181015173319 in 0.0s | |
| 2023-02-13T13:20:11.995 application=ecto_sql [info] == Running 20181016163236 Explorer.Repo.Migrations.ModifyUserContactsEmail.up/0 forward | |
| 2023-02-13T13:20:11.995 application=ecto_sql [info] drop index email_unique_for_user | |
| 2023-02-13T13:20:11.996 application=ecto_sql [info] alter table user_contacts | |
| 2023-02-13T13:20:11.997 application=ecto_sql [info] create index email_unique_for_user | |
| 2023-02-13T13:20:11.999 application=ecto_sql [info] == Migrated 20181016163236 in 0.0s | |
| 2023-02-13T13:20:12.001 application=ecto_sql [info] == Running 20181017141409 Explorer.Repo.Migrations.AddIndexToInternalTransactionTable.change/0 forward | |
| 2023-02-13T13:20:12.001 application=ecto_sql [info] create index internal_transactions_to_address_hash_from_address_hash_created_contract_address_hash_type_index_index | |
| 2023-02-13T13:20:12.003 application=ecto_sql [info] create index internal_transactions_block_number_DESC__transaction_index_DESC__index_DESC_index | |
| 2023-02-13T13:20:12.004 application=ecto_sql [info] == Migrated 20181017141409 in 0.0s | |
| 2023-02-13T13:20:12.006 application=ecto_sql [info] == Running 20181024141113 Explorer.Repo.Migrations.InternalTransactionsCompositePrimaryKey.up/0 forward | |
| 2023-02-13T13:20:12.006 application=ecto_sql [info] alter table internal_transactions | |
| 2023-02-13T13:20:12.007 application=ecto_sql [info] execute "ALTER TABLE internal_transactions ADD PRIMARY KEY (transaction_hash, index)" | |
| 2023-02-13T13:20:12.008 application=ecto_sql [info] == Migrated 20181024141113 in 0.0s | |
| 2023-02-13T13:20:12.010 application=ecto_sql [info] == Running 20181024164623 Explorer.Repo.Migrations.LogsCompositePrimaryKey.up/0 forward | |
| 2023-02-13T13:20:12.010 application=ecto_sql [info] alter table logs | |
| 2023-02-13T13:20:12.010 application=ecto_sql [info] execute "ALTER TABLE logs ADD PRIMARY KEY (transaction_hash, index)" | |
| 2023-02-13T13:20:12.012 application=ecto_sql [info] == Migrated 20181024164623 in 0.0s | |
| 2023-02-13T13:20:12.014 application=ecto_sql [info] == Running 20181024172010 Explorer.Repo.Migrations.TokenTransfersCompositePrimaryKey.up/0 forward | |
| 2023-02-13T13:20:12.014 application=ecto_sql [info] alter table token_transfers | |
| 2023-02-13T13:20:12.014 application=ecto_sql [info] execute "ALTER TABLE token_transfers ADD PRIMARY KEY (transaction_hash, log_index)" | |
| 2023-02-13T13:20:12.016 application=ecto_sql [info] == Migrated 20181024172010 in 0.0s | |
| 2023-02-13T13:20:12.017 application=ecto_sql [info] == Running 20181026180921 Explorer.Repo.Migrations.CreateAddressCurrentTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.018 application=ecto_sql [info] create table address_current_token_balances | |
| 2023-02-13T13:20:12.022 application=ecto_sql [info] create index address_current_token_balances_address_hash_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.024 application=ecto_sql [info] create index address_current_token_balances_value | |
| 2023-02-13T13:20:12.025 application=ecto_sql [info] == Migrated 20181026180921 in 0.0s | |
| 2023-02-13T13:20:12.026 application=ecto_sql [info] == Running 20181029174420 Explorer.Repo.Migrations.UpdateTokensTableDecimalsFromBigintToNumeric.up/0 forward | |
| 2023-02-13T13:20:12.026 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.029 application=ecto_sql [info] == Migrated 20181029174420 in 0.0s | |
| 2023-02-13T13:20:12.031 application=ecto_sql [info] == Running 20181106152300 Explorer.Repo.Migrations.AddNonceToAddresses.up/0 forward | |
| 2023-02-13T13:20:12.031 application=ecto_sql [info] alter table addresses | |
| 2023-02-13T13:20:12.032 application=ecto_sql [info] == Migrated 20181106152300 in 0.0s | |
| 2023-02-13T13:20:12.033 application=ecto_sql [info] == Running 20181107164103 Explorer.Repo.Migrations.EIP6.up/0 forward | |
| 2023-02-13T13:20:12.033 application=ecto_sql [info] execute "ALTER TABLE internal_transactions DROP CONSTRAINT suicide_has_from_and_to_address_hashes" | |
| 2023-02-13T13:20:12.033 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-13T13:20:12.034 application=ecto_sql [info] == Migrated 20181107164103 in 0.0s | |
| 2023-02-13T13:20:12.035 application=ecto_sql [info] == Running 20181108205650 Explorer.Repo.Migrations.AdditionalInternalTransactionConstraints.up/0 forward | |
| 2023-02-13T13:20:12.035 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-13T13:20:12.036 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-13T13:20:12.036 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-13T13:20:12.036 application=ecto_sql [info] == Migrated 20181108205650 in 0.0s | |
| 2023-02-13T13:20:12.038 application=ecto_sql [info] == Running 20181121170616 Explorer.Repo.Migrations.AddBlockNumberToTokenTransfers.change/0 forward | |
| 2023-02-13T13:20:12.038 application=ecto_sql [info] alter table token_transfers | |
| 2023-02-13T13:20:12.039 application=ecto_sql [info] == Migrated 20181121170616 in 0.0s | |
| 2023-02-13T13:20:12.040 application=ecto_sql [info] == Running 20181126203826 Explorer.Repo.Migrations.AddIndexToAddresses.up/0 forward | |
| 2023-02-13T13:20:12.040 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-13T13:20:12.041 application=ecto_sql [info] == Migrated 20181126203826 in 0.0s | |
| 2023-02-13T13:20:12.043 application=ecto_sql [info] == Running 20181206200140 Explorer.Repo.Migrations.RenameBlockRewardsToEmissionRewards.change/0 forward | |
| 2023-02-13T13:20:12.043 application=ecto_sql [info] rename table block_rewards to emission_rewards | |
| 2023-02-13T13:20:12.043 application=ecto_sql [info] == Migrated 20181206200140 in 0.0s | |
| 2023-02-13T13:20:12.044 application=ecto_sql [info] == Running 20181206200312 Explorer.Repo.Migrations.CreateNewBlockRewards.change/0 forward | |
| 2023-02-13T13:20:12.044 application=ecto_sql [info] create table block_rewards | |
| 2023-02-13T13:20:12.046 application=ecto_sql [info] create index block_rewards_address_hash_address_type_block_hash_index | |
| 2023-02-13T13:20:12.047 application=ecto_sql [info] == Migrated 20181206200312 in 0.0s | |
| 2023-02-13T13:20:12.048 application=ecto_sql [info] == Running 20181212115448 Explorer.Repo.Migrations.AddIndexesToTokenTransfers.change/0 forward | |
| 2023-02-13T13:20:12.049 application=ecto_sql [info] create index token_transfers_from_address_hash_index | |
| 2023-02-13T13:20:12.050 application=ecto_sql [info] create index token_transfers_to_address_hash_index | |
| 2023-02-13T13:20:12.051 application=ecto_sql [info] == Migrated 20181212115448 in 0.0s | |
| 2023-02-13T13:20:12.052 application=ecto_sql [info] == Running 20181213111656 Explorer.Repo.Migrations.AddMetadataFieldToAddressNames.change/0 forward | |
| 2023-02-13T13:20:12.052 application=ecto_sql [info] alter table address_names | |
| 2023-02-13T13:20:12.053 application=ecto_sql [info] == Migrated 20181213111656 in 0.0s | |
| 2023-02-13T13:20:12.054 application=ecto_sql [info] == Running 20181221143000 Explorer.Repo.Migrations.CreateBlocksMinerHashIndex.change/0 forward | |
| 2023-02-13T13:20:12.054 application=ecto_sql [info] create index blocks_miner_hash_index | |
| 2023-02-13T13:20:12.055 application=ecto_sql [info] == Migrated 20181221143000 in 0.0s | |
| 2023-02-13T13:20:12.056 application=ecto_sql [info] == Running 20181221145054 Explorer.Repo.Migrations.AddContractMethods.change/0 forward | |
| 2023-02-13T13:20:12.056 application=ecto_sql [info] create table contract_methods | |
| 2023-02-13T13:20:12.059 application=ecto_sql [info] create index contract_methods_identifier_abi_index | |
| 2023-02-13T13:20:12.061 application=ecto_sql [info] == Migrated 20181221145054 in 0.0s | |
| 2023-02-13T13:20:12.062 application=ecto_sql [info] == Running 20190102141900 Explorer.Repo.Migrations.IndexCurrentTokenHolders.change/0 forward | |
| 2023-02-13T13:20:12.062 application=ecto_sql [info] create index address_current_token_balances_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.063 application=ecto_sql [info] == Migrated 20190102141900 in 0.0s | |
| 2023-02-13T13:20:12.064 application=ecto_sql [info] == Running 20190114204640 Explorer.Repo.Migrations.AddTokensHolderCount.change/0 forward | |
| 2023-02-13T13:20:12.064 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.064 application=ecto_sql [info] == Migrated 20190114204640 in 0.0s | |
| 2023-02-13T13:20:12.065 application=ecto_sql [info] == Running 20190116082843 Explorer.Repo.Migrations.AddCreatedContractIndexedAtToTransactions.change/0 forward | |
| 2023-02-13T13:20:12.065 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.066 application=ecto_sql [info] create index transactions_created_contract_code_indexed_at_index | |
| 2023-02-13T13:20:12.067 application=ecto_sql [info] == Migrated 20190116082843 in 0.0s | |
| 2023-02-13T13:20:12.068 application=ecto_sql [info] == Running 20190118040301 Explorer.Repo.Migrations.CreateTokensPrimaryKey.up/0 forward | |
| 2023-02-13T13:20:12.068 application=ecto_sql [info] execute "ALTER TABLE tokens ADD PRIMARY KEY (contract_address_hash)" | |
| 2023-02-13T13:20:12.070 application=ecto_sql [info] == Migrated 20190118040301 in 0.0s | |
| 2023-02-13T13:20:12.071 application=ecto_sql [info] == Running 20190118152240 Explorer.Repo.Migrations.BlockSecondDegreeRelationsCompositePrimaryKey.up/0 forward | |
| 2023-02-13T13:20:12.071 application=ecto_sql [info] execute "ALTER TABLE block_second_degree_relations ADD PRIMARY KEY (nephew_hash, uncle_hash)" | |
| 2023-02-13T13:20:12.072 application=ecto_sql [info] == Migrated 20190118152240 in 0.0s | |
| 2023-02-13T13:20:12.073 application=ecto_sql [info] == Running 20190122125815 Explorer.Repo.Migrations.ChangeTransactionErrorConstraint.change/0 forward | |
| 2023-02-13T13:20:12.074 application=ecto_sql [info] drop constraint status from table transactions | |
| 2023-02-13T13:20:12.074 application=ecto_sql [info] create check constraint status on table transactions | |
| 2023-02-13T13:20:12.074 application=ecto_sql [info] drop constraint error from table transactions | |
| 2023-02-13T13:20:12.075 application=ecto_sql [info] create check constraint error on table transactions | |
| 2023-02-13T13:20:12.075 application=ecto_sql [info] == Migrated 20190122125815 in 0.0s | |
| 2023-02-13T13:20:12.076 application=ecto_sql [info] == Running 20190124082812 Explorer.Repo.Migrations.AddIndexOnTransactionNonceAndFromAddressHash.change/0 forward | |
| 2023-02-13T13:20:12.076 application=ecto_sql [info] create index transactions_nonce_from_address_hash_block_hash_index | |
| 2023-02-13T13:20:12.078 application=ecto_sql [info] create index transactions_block_hash_error_index | |
| 2023-02-13T13:20:12.079 application=ecto_sql [info] == Migrated 20190124082812 in 0.0s | |
| 2023-02-13T13:20:12.080 application=ecto_sql [info] == Running 20190208113202 Explorer.Repo.Migrations.AddUniqueIndexToRewards.change/0 forward | |
| 2023-02-13T13:20:12.080 application=ecto_sql [info] create index block_rewards_address_hash_block_hash_address_type_index | |
| 2023-02-13T13:20:12.082 application=ecto_sql [info] == Migrated 20190208113202 in 0.0s | |
| 2023-02-13T13:20:12.083 application=ecto_sql [info] == Running 20190208143201 Explorer.Repo.Migrations.AddIndexOnAddressHashBlockNumberAndTokenContractAddressHashForCurrentTokenBalance.change/0 forward | |
| 2023-02-13T13:20:12.083 application=ecto_sql [info] create index address_current_token_balances_address_hash_block_number_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.084 application=ecto_sql [info] == Migrated 20190208143201 in 0.0s | |
| 2023-02-13T13:20:12.085 application=ecto_sql [info] == Running 20190213180502 Explorer.Repo.Migrations.AddEarliestProcessingStartToTransactions.change/0 forward | |
| 2023-02-13T13:20:12.085 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.085 application=ecto_sql [info] == Migrated 20190213180502 in 0.0s | |
| 2023-02-13T13:20:12.086 application=ecto_sql [info] == Running 20190214135850 Explorer.Repo.Migrations.AddIndexOnBlockNumberToAddressTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.086 application=ecto_sql [info] create index address_token_balances_block_number_index | |
| 2023-02-13T13:20:12.087 application=ecto_sql [info] == Migrated 20190214135850 in 0.0s | |
| 2023-02-13T13:20:12.088 application=ecto_sql [info] == Running 20190215080049 Explorer.Repo.Migrations.AddIndexOnFetchedCoinBalanceToAddresses.change/0 forward | |
| 2023-02-13T13:20:12.088 application=ecto_sql [info] create index addresses_fetched_coin_balance_index | |
| 2023-02-13T13:20:12.090 application=ecto_sql [info] == Migrated 20190215080049 in 0.0s | |
| 2023-02-13T13:20:12.091 application=ecto_sql [info] == Running 20190215093358 Explorer.Repo.Migrations.AddCompoundIndexAddressTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.091 application=ecto_sql [info] create index address_cur_token_balances_index | |
| 2023-02-13T13:20:12.092 application=ecto_sql [info] == Migrated 20190215093358 in 0.0s | |
| 2023-02-13T13:20:12.093 application=ecto_sql [info] == Running 20190215105501 Explorer.Repo.Migrations.AddConstructorArgumentsToSmartContracts.change/0 forward | |
| 2023-02-13T13:20:12.093 application=ecto_sql [info] execute "ALTER TABLE smart_contracts DROP COLUMN IF EXISTS constructor_arguments" | |
| 2023-02-13T13:20:12.093 application=ecto_sql [info] column "constructor_arguments" of relation "smart_contracts" does not exist, skipping | |
| 2023-02-13T13:20:12.093 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.093 application=ecto_sql [info] == Migrated 20190215105501 in 0.0s | |
| 2023-02-13T13:20:12.094 application=ecto_sql [info] == Running 20190219082636 Explorer.Repo.Migrations.AddIndexesForBlockRewardQuery.change/0 forward | |
| 2023-02-13T13:20:12.094 application=ecto_sql [info] create index blocks_number_index | |
| 2023-02-13T13:20:12.095 application=ecto_sql [info] create index emission_rewards_block_range_index | |
| 2023-02-13T13:20:12.097 application=ecto_sql [info] == Migrated 20190219082636 in 0.0s | |
| 2023-02-13T13:20:12.098 application=ecto_sql [info] == Running 20190228102650 Explorer.Repo.Migrations.AddIndexCreatedContractAddressHas.change/0 forward | |
| 2023-02-13T13:20:12.098 application=ecto_sql [info] create index transactions_created_contract_address_hash_index | |
| 2023-02-13T13:20:12.099 application=ecto_sql [info] == Migrated 20190228102650 in 0.0s | |
| 2023-02-13T13:20:12.100 application=ecto_sql [info] == Running 20190228152333 Explorer.Repo.Migrations.ChangeConstructorArgumentsToText.up/0 forward | |
| 2023-02-13T13:20:12.100 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.100 application=ecto_sql [info] == Migrated 20190228152333 in 0.0s | |
| 2023-02-13T13:20:12.101 application=ecto_sql [info] == Running 20190228220746 Explorer.Repo.Migrations.AddInternalTransactionsIndexedAtToBlocks.change/0 forward | |
| 2023-02-13T13:20:12.101 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.101 application=ecto_sql [info] == Migrated 20190228220746 in 0.0s | |
| 2023-02-13T13:20:12.102 application=ecto_sql [info] == Running 20190301095620 Explorer.Repo.Migrations.RemoveDuplicatedIndexes.change/0 forward | |
| 2023-02-13T13:20:12.103 application=ecto_sql [info] drop index if exists address_current_token_balances_block_number_index | |
| 2023-02-13T13:20:12.103 application=ecto_sql [info] index "address_current_token_balances_block_number_index" does not exist, skipping | |
| 2023-02-13T13:20:12.103 application=ecto_sql [info] drop index if exists internal_transactions_to_address_hash_index | |
| 2023-02-13T13:20:12.103 application=ecto_sql [info] drop index if exists internal_transactions_transaction_hash_index | |
| 2023-02-13T13:20:12.103 application=ecto_sql [info] drop index if exists logs_transaction_hash_index | |
| 2023-02-13T13:20:12.104 application=ecto_sql [info] drop index if exists token_transfers_from_address_hash_index | |
| 2023-02-13T13:20:12.104 application=ecto_sql [info] drop index if exists token_transfers_to_address_hash_index | |
| 2023-02-13T13:20:12.104 application=ecto_sql [info] drop index if exists token_transfers_transaction_hash_index | |
| 2023-02-13T13:20:12.104 application=ecto_sql [info] drop index if exists transaction_forks_uncle_hash_index | |
| 2023-02-13T13:20:12.105 application=ecto_sql [info] drop index if exists transactions_block_hash_index | |
| 2023-02-13T13:20:12.105 application=ecto_sql [info] drop index if exists transactions_created_contract_address_hash_index | |
| 2023-02-13T13:20:12.105 application=ecto_sql [info] drop index if exists user_contacts_user_id_index | |
| 2023-02-13T13:20:12.105 application=ecto_sql [info] == Migrated 20190301095620 in 0.0s | |
| 2023-02-13T13:20:12.107 application=ecto_sql [info] == Running 20190301120328 Explorer.Repo.Migrations.AddIndexToConsensus.change/0 forward | |
| 2023-02-13T13:20:12.107 application=ecto_sql [info] create index blocks_consensus_index | |
| 2023-02-13T13:20:12.108 application=ecto_sql [info] == Migrated 20190301120328 in 0.0s | |
| 2023-02-13T13:20:12.109 application=ecto_sql [info] == Running 20190305095926 Explorer.Repo.Migrations.AddIndexToValueFetchedAt.change/0 forward | |
| 2023-02-13T13:20:12.109 application=ecto_sql [info] create index address_coin_balances_value_fetched_at_index | |
| 2023-02-13T13:20:12.110 application=ecto_sql [info] == Migrated 20190305095926 in 0.0s | |
| 2023-02-13T13:20:12.112 application=ecto_sql [info] == Running 20190313085740 Explorer.Repo.Migrations.AddIndexSymoblInTokens.change/0 forward | |
| 2023-02-13T13:20:12.112 application=ecto_sql [info] create index tokens_symbol_index | |
| 2023-02-13T13:20:12.113 application=ecto_sql [info] == Migrated 20190313085740 in 0.0s | |
| 2023-02-13T13:20:12.114 application=ecto_sql [info] == Running 20190313103912 Explorer.Repo.Migrations.ChangeTransactionsVColumnType.up/0 forward | |
| 2023-02-13T13:20:12.114 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.130 application=ecto_sql [info] == Migrated 20190313103912 in 0.0s | |
| 2023-02-13T13:20:12.133 application=ecto_sql [info] == Running 20190314084907 Explorer.Repo.Migrations.AddIndexToToAddressHash.change/0 forward | |
| 2023-02-13T13:20:12.133 application=ecto_sql [info] create index transactions_to_address_hash_index | |
| 2023-02-13T13:20:12.134 application=ecto_sql [info] == Migrated 20190314084907 in 0.0s | |
| 2023-02-13T13:20:12.136 application=ecto_sql [info] == Running 20190318151809 Explorer.Repo.Migrations.AddInsertedAtIndexToAccounts.change/0 forward | |
| 2023-02-13T13:20:12.136 application=ecto_sql [info] create index addresses_inserted_at_index | |
| 2023-02-13T13:20:12.137 application=ecto_sql [info] == Migrated 20190318151809 in 0.0s | |
| 2023-02-13T13:20:12.139 application=ecto_sql [info] == Running 20190319081821 Explorer.Repo.Migrations.CreateDecompiledSmartContracts.change/0 forward | |
| 2023-02-13T13:20:12.139 application=ecto_sql [info] create table decompiled_smart_contracts | |
| 2023-02-13T13:20:12.143 application=ecto_sql [info] create index decompiled_smart_contracts_address_hash_index | |
| 2023-02-13T13:20:12.144 application=ecto_sql [info] == Migrated 20190319081821 in 0.0s | |
| 2023-02-13T13:20:12.146 application=ecto_sql [info] == Running 20190321185644 Explorer.Repo.Migrations.AddOldValueForCurrentTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.146 application=ecto_sql [info] alter table address_current_token_balances | |
| 2023-02-13T13:20:12.146 application=ecto_sql [info] == Migrated 20190321185644 in 0.0s | |
| 2023-02-13T13:20:12.148 application=ecto_sql [info] == Running 20190325081658 Explorer.Repo.Migrations.RemoveUniqueAddressHashDecompiledContracts.change/0 forward | |
| 2023-02-13T13:20:12.148 application=ecto_sql [info] drop index decompiled_smart_contracts_address_hash_index | |
| 2023-02-13T13:20:12.148 application=ecto_sql [info] create index address_decompiler_version | |
| 2023-02-13T13:20:12.150 application=ecto_sql [info] == Migrated 20190325081658 in 0.0s | |
| 2023-02-13T13:20:12.151 application=ecto_sql [info] == Running 20190403080447 Explorer.Repo.Migrations.AddFullTextSearchTokens.up/0 forward | |
| 2023-02-13T13:20:12.151 application=ecto_sql [info] execute "CREATE EXTENSION pg_trgm" | |
| 2023-02-13T13:20:12.155 application=ecto_sql [info] execute "CREATE INDEX tokens_trgm_idx ON tokens USING GIN (to_tsvector('english', symbol || ' ' || name))\n" | |
| 2023-02-13T13:20:12.156 application=ecto_sql [info] == Migrated 20190403080447 in 0.0s | |
| 2023-02-13T13:20:12.157 application=ecto_sql [info] == Running 20190421143300 Explorer.Repo.Migrations.AddIndexToBsdr.change/0 forward | |
| 2023-02-13T13:20:12.157 application=ecto_sql [info] alter table block_second_degree_relations | |
| 2023-02-13T13:20:12.157 application=ecto_sql [info] == Migrated 20190421143300 in 0.0s | |
| 2023-02-13T13:20:12.158 application=ecto_sql [info] == Running 20190424170833 Explorer.Repo.Migrations.ChangeBlockSizeToNullable.up/0 forward | |
| 2023-02-13T13:20:12.158 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.159 application=ecto_sql [info] == Migrated 20190424170833 in 0.0s | |
| 2023-02-13T13:20:12.160 application=ecto_sql [info] == Running 20190508152922 Explorer.Repo.Migrations.AddOldBlockHashForTransactions.change/0 forward | |
| 2023-02-13T13:20:12.160 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.160 application=ecto_sql [info] == Migrated 20190508152922 in 0.0s | |
| 2023-02-13T13:20:12.161 application=ecto_sql [info] == Running 20190513134025 Explorer.Repo.Migrations.AddRefetchNeededToBlock.change/0 forward | |
| 2023-02-13T13:20:12.161 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.161 application=ecto_sql [info] execute "UPDATE blocks SET refetch_needed = TRUE WHERE consensus" | |
| 2023-02-13T13:20:12.162 application=ecto_sql [info] == Migrated 20190513134025 in 0.0s | |
| 2023-02-13T13:20:12.163 application=ecto_sql [info] == Running 20190516140202 Explorer.Repo.Migrations.AddAddressHashIndexToDecompiledSmartContracts.change/0 forward | |
| 2023-02-13T13:20:12.163 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-13T13:20:12.164 application=ecto_sql [info] == Migrated 20190516140202 in 0.0s | |
| 2023-02-13T13:20:12.165 application=ecto_sql [info] == Running 20190516160535 Explorer.Repo.Migrations.AddDecompiledAndVerifiedFlagToAddresses.change/0 forward | |
| 2023-02-13T13:20:12.165 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-13T13:20:12.165 application=ecto_sql [info] == Migrated 20190516160535 in 0.0s | |
| 2023-02-13T13:20:12.166 application=ecto_sql [info] == Running 20190521104412 Explorer.Repo.Migrations.CreateStakingPools.change/0 forward | |
| 2023-02-13T13:20:12.166 application=ecto_sql [info] create table staking_pools | |
| 2023-02-13T13:20:12.170 application=ecto_sql [info] create index staking_pools_staking_address_hash_index | |
| 2023-02-13T13:20:12.171 application=ecto_sql [info] create index staking_pools_mining_address_hash_index | |
| 2023-02-13T13:20:12.172 application=ecto_sql [info] == Migrated 20190521104412 in 0.0s | |
| 2023-02-13T13:20:12.173 application=ecto_sql [info] == Running 20190523112839 Explorer.Repo.Migrations.CreateStakingPoolsDelegator.change/0 forward | |
| 2023-02-13T13:20:12.173 application=ecto_sql [info] create table staking_pools_delegators | |
| 2023-02-13T13:20:12.176 application=ecto_sql [info] create index staking_pools_delegators_delegator_address_hash_index | |
| 2023-02-13T13:20:12.177 application=ecto_sql [info] create index pools_delegator_index | |
| 2023-02-13T13:20:12.179 application=ecto_sql [info] == Migrated 20190523112839 in 0.0s | |
| 2023-02-13T13:20:12.180 application=ecto_sql [info] == Running 20190613065856 Explorer.Repo.Migrations.AddTxHashInsertedAtIndex.change/0 forward | |
| 2023-02-13T13:20:12.180 application=ecto_sql [info] create index transactions_hash_inserted_at_index | |
| 2023-02-13T13:20:12.181 application=ecto_sql [info] == Migrated 20190613065856 in 0.0s | |
| 2023-02-13T13:20:12.182 application=ecto_sql [info] == Running 20190619154943 Explorer.Repo.Migrations.ReduceTransactionStatusConstraint.up/0 forward | |
| 2023-02-13T13:20:12.182 application=ecto_sql [info] drop constraint status from table transactions | |
| 2023-02-13T13:20:12.182 application=ecto_sql [info] create check constraint status on table transactions | |
| 2023-02-13T13:20:12.183 application=ecto_sql [info] drop constraint error from table transactions | |
| 2023-02-13T13:20:12.183 application=ecto_sql [info] create check constraint error on table transactions | |
| 2023-02-13T13:20:12.183 application=ecto_sql [info] == Migrated 20190619154943 in 0.0s | |
| 2023-02-13T13:20:12.184 application=ecto_sql [info] == Running 20190625085852 Explorer.Repo.Migrations.AddAdditionalContractFields.change/0 forward | |
| 2023-02-13T13:20:12.184 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.185 application=ecto_sql [info] == Migrated 20190625085852 in 0.0s | |
| 2023-02-13T13:20:12.186 application=ecto_sql [info] == Running 20190709043832 Explorer.Repo.Migrations.CreateTransactionStats.change/0 forward | |
| 2023-02-13T13:20:12.186 application=ecto_sql [info] create table transaction_stats | |
| 2023-02-13T13:20:12.187 application=ecto_sql [info] create index transaction_stats_date_index | |
| 2023-02-13T13:20:12.188 application=ecto_sql [info] == Migrated 20190709043832 in 0.0s | |
| 2023-02-13T13:20:12.189 application=ecto_sql [info] == Running 20190709103104 Explorer.Repo.Migrations.AddExternalLibrariesToSmartContracts.change/0 forward | |
| 2023-02-13T13:20:12.189 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.190 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.190 application=ecto_sql [info] == Migrated 20190709103104 in 0.0s | |
| 2023-02-13T13:20:12.191 application=ecto_sql [info] == Running 20190807111216 Explorer.Repo.Migrations.RemoveDuplicateIndexes.change/0 forward | |
| 2023-02-13T13:20:12.191 application=ecto_sql [info] drop index if exists decompiled_smart_contracts_address_hash_index | |
| 2023-02-13T13:20:12.191 application=ecto_sql [info] drop index if exists staking_pools_delegators_delegator_address_hash_index | |
| 2023-02-13T13:20:12.192 application=ecto_sql [info] drop index if exists transactions_to_address_hash_index | |
| 2023-02-13T13:20:12.192 application=ecto_sql [info] == Migrated 20190807111216 in 0.0s | |
| 2023-02-13T13:20:12.193 application=ecto_sql [info] == Running 20190807113117 Explorer.Repo.Migrations.CreateSuggestedIndexes.change/0 forward | |
| 2023-02-13T13:20:12.193 application=ecto_sql [info] create index if not exists address_token_balances_block_number_address_hash_index | |
| 2023-02-13T13:20:12.195 application=ecto_sql [info] create index if not exists block_rewards_block_hash_index | |
| 2023-02-13T13:20:12.196 application=ecto_sql [info] == Migrated 20190807113117 in 0.0s | |
| 2023-02-13T13:20:12.197 application=ecto_sql [info] == Running 20190827120224 Explorer.Repo.Migrations.AddIndexOnTokenTransferTokenId.change/0 forward | |
| 2023-02-13T13:20:12.197 application=ecto_sql [info] create index if not exists token_transfers_token_id_index | |
| 2023-02-13T13:20:12.198 application=ecto_sql [info] == Migrated 20190827120224 in 0.0s | |
| 2023-02-13T13:20:12.199 application=ecto_sql [info] == Running 20190905083522 Explorer.Repo.Migrations.CreateTokenInstances.change/0 forward | |
| 2023-02-13T13:20:12.200 application=ecto_sql [info] create table token_instances | |
| 2023-02-13T13:20:12.203 application=ecto_sql [info] create index if not exists token_instances_token_id_index | |
| 2023-02-13T13:20:12.204 application=ecto_sql [info] == Migrated 20190905083522 in 0.0s | |
| 2023-02-13T13:20:12.205 application=ecto_sql [info] == Running 20190910170703 Explorer.Repo.Migrations.CreateIndexesForBlockNumberInTokenTransfersAndTransactions.change/0 forward | |
| 2023-02-13T13:20:12.205 application=ecto_sql [info] create index if not exists token_transfers_block_number_index | |
| 2023-02-13T13:20:12.206 application=ecto_sql [info] == Migrated 20190910170703 in 0.0s | |
| 2023-02-13T13:20:12.207 application=ecto_sql [info] == Running 20191007082500 Explorer.Repo.Migrations.AddIndexesForTokenInstrancesQuery.change/0 forward | |
| 2023-02-13T13:20:12.207 application=ecto_sql [info] create index if not exists token_instances_token_id_index | |
| 2023-02-13T13:20:12.208 application=ecto_sql [info] relation "token_instances_token_id_index" already exists, skipping | |
| 2023-02-13T13:20:12.208 application=ecto_sql [info] create index if not exists tokens_type_index | |
| 2023-02-13T13:20:12.209 application=ecto_sql [info] == Migrated 20191007082500 in 0.0s | |
| 2023-02-13T13:20:12.210 application=ecto_sql [info] == Running 20191009121635 Explorer.Repo.Migrations.AddTokenTransferSortingIndexes.change/0 forward | |
| 2023-02-13T13:20:12.210 application=ecto_sql [info] create index token_transfers_block_number_DESC_log_index_DESC_index | |
| 2023-02-13T13:20:12.211 application=ecto_sql [info] == Migrated 20191009121635 in 0.0s | |
| 2023-02-13T13:20:12.212 application=ecto_sql [info] == Running 20191010075740 Explorer.Repo.Migrations.AddErrorToTokenInstances.change/0 forward | |
| 2023-02-13T13:20:12.212 application=ecto_sql [info] alter table token_instances | |
| 2023-02-13T13:20:12.213 application=ecto_sql [info] create index token_instances_error_index | |
| 2023-02-13T13:20:12.214 application=ecto_sql [info] == Migrated 20191010075740 in 0.0s | |
| 2023-02-13T13:20:12.215 application=ecto_sql [info] == Running 20191018120546 Explorer.Repo.Migrations.CreatePendingBlockOperations.change/0 forward | |
| 2023-02-13T13:20:12.215 application=ecto_sql [info] create table pending_block_operations | |
| 2023-02-13T13:20:12.218 application=ecto_sql [info] == Migrated 20191018120546 in 0.0s | |
| 2023-02-13T13:20:12.219 application=ecto_sql [info] == Running 20191018140054 Explorer.Repo.Migrations.AddPendingInternalTxsOperation.change/0 forward | |
| 2023-02-13T13:20:12.219 application=ecto_sql [info] alter table pending_block_operations | |
| 2023-02-13T13:20:12.219 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-13T13:20:12.220 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.220 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.221 application=ecto_sql [info] alter table internal_transactions | |
| 2023-02-13T13:20:12.221 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-13T13:20:12.222 application=ecto_sql [info] execute "DELETE FROM internal_transactions WHERE block_hash IS NULL;\n" | |
| 2023-02-13T13:20:12.222 application=ecto_sql [info] execute "ALTER table internal_transactions\nDROP CONSTRAINT internal_transactions_pkey,\nADD PRIMARY KEY (block_hash, block_index);\n" | |
| 2023-02-13T13:20:12.223 application=ecto_sql [info] alter table internal_transactions | |
| 2023-02-13T13:20:12.224 application=ecto_sql [info] drop index internal_transactions_transaction_hash_index_index | |
| 2023-02-13T13:20:12.224 application=ecto_sql [info] create index if not exists internal_transactions_transaction_hash_index_index | |
| 2023-02-13T13:20:12.226 application=ecto_sql [info] == Migrated 20191018140054 in 0.0s | |
| 2023-02-13T13:20:12.227 application=ecto_sql [info] == Running 20191121064805 Explorer.Repo.Migrations.AddBlockHashAndBlockIndexToLogs.change/0 forward | |
| 2023-02-13T13:20:12.227 application=ecto_sql [info] alter table logs | |
| 2023-02-13T13:20:12.227 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-13T13:20:12.228 application=ecto_sql [info] execute "DELETE FROM logs WHERE block_hash IS NULL;\n" | |
| 2023-02-13T13:20:12.228 application=ecto_sql [info] alter table logs | |
| 2023-02-13T13:20:12.229 application=ecto_sql [info] execute "ALTER table logs\nDROP CONSTRAINT logs_pkey,\nADD PRIMARY KEY (transaction_hash, block_hash, index);\n" | |
| 2023-02-13T13:20:12.230 application=ecto_sql [info] drop index logs_transaction_hash_index_index | |
| 2023-02-13T13:20:12.230 application=ecto_sql [info] create index if not exists logs_transaction_hash_index_index | |
| 2023-02-13T13:20:12.231 application=ecto_sql [info] == Migrated 20191121064805 in 0.0s | |
| 2023-02-13T13:20:12.233 application=ecto_sql [info] == Running 20191122062035 Explorer.Repo.Migrations.AddBlockHashToTokenTransfers.change/0 forward | |
| 2023-02-13T13:20:12.233 application=ecto_sql [info] alter table token_transfers | |
| 2023-02-13T13:20:12.233 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-13T13:20:12.233 application=ecto_sql [info] execute "DELETE FROM token_transfers WHERE block_hash IS NULL;\n" | |
| 2023-02-13T13:20:12.233 application=ecto_sql [info] alter table token_transfers | |
| 2023-02-13T13:20:12.234 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-13T13:20:12.235 application=ecto_sql [info] drop index token_transfers_transaction_hash_log_index_index | |
| 2023-02-13T13:20:12.235 application=ecto_sql [info] create index if not exists token_transfers_transaction_hash_log_index_index | |
| 2023-02-13T13:20:12.237 application=ecto_sql [info] == Migrated 20191122062035 in 0.0s | |
| 2023-02-13T13:20:12.238 application=ecto_sql [info] == Running 20191128124415 Explorer.Repo.Migrations.RemoveDuplicateIndexesTokenEntities.change/0 forward | |
| 2023-02-13T13:20:12.238 application=ecto_sql [info] drop index if exists address_token_balances_block_number_index | |
| 2023-02-13T13:20:12.238 application=ecto_sql [info] drop index if exists token_instances_token_id_index | |
| 2023-02-13T13:20:12.238 application=ecto_sql [info] == Migrated 20191128124415 in 0.0s | |
| 2023-02-13T13:20:12.239 application=ecto_sql [info] == Running 20191203112646 Explorer.Repo.Migrations.InternalTransactionsAddToAddressHashIndex.change/0 forward | |
| 2023-02-13T13:20:12.239 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-13T13:20:12.241 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-13T13:20:12.242 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-13T13:20:12.243 application=ecto_sql [info] drop index if exists internal_transactions_to_address_hash_from_address_hash_created | |
| 2023-02-13T13:20:12.244 application=ecto_sql [info] == Migrated 20191203112646 in 0.0s | |
| 2023-02-13T13:20:12.245 application=ecto_sql [info] == Running 20191208135613 Explorer.Repo.Migrations.BlockRewardsBlockHashPartialIndex.change/0 forward | |
| 2023-02-13T13:20:12.245 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-13T13:20:12.246 application=ecto_sql [info] == Migrated 20191208135613 in 0.0s | |
| 2023-02-13T13:20:12.247 application=ecto_sql [info] == Running 20191218120138 Explorer.Repo.Migrations.LogsBlockNumberIndexIndex.change/0 forward | |
| 2023-02-13T13:20:12.247 application=ecto_sql [info] create index if not exists logs_block_number_DESC__index_DESC_index | |
| 2023-02-13T13:20:12.248 application=ecto_sql [info] == Migrated 20191218120138 in 0.0s | |
| 2023-02-13T13:20:12.249 application=ecto_sql [info] == Running 20191220113006 Explorer.Repo.Migrations.PendingBlockOperationsBlockHashPartialIndex.change/0 forward | |
| 2023-02-13T13:20:12.249 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-13T13:20:12.251 application=ecto_sql [info] == Migrated 20191220113006 in 0.0s | |
| 2023-02-13T13:20:12.252 application=ecto_sql [info] == Running 20200214152058 Explorer.Repo.Migrations.AddTokenIdToTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.252 application=ecto_sql [info] alter table address_token_balances | |
| 2023-02-13T13:20:12.252 application=ecto_sql [info] create index address_token_balances_token_id_index | |
| 2023-02-13T13:20:12.253 application=ecto_sql [info] == Migrated 20200214152058 in 0.0s | |
| 2023-02-13T13:20:12.254 application=ecto_sql [info] == Running 20200410115841 Explorer.Repo.Migrations.CreateIndexAddressCurrentTokenBalancesTokenContractAddressHashValue.change/0 forward | |
| 2023-02-13T13:20:12.254 application=ecto_sql [info] create index if not exists address_current_token_balances_token_contract_address_hash_value_index | |
| 2023-02-13T13:20:12.255 application=ecto_sql [info] == Migrated 20200410115841 in 0.0s | |
| 2023-02-13T13:20:12.256 application=ecto_sql [info] == Running 20200410141202 Explorer.Repo.Migrations.CreateIndexTokenTransfersTokenContractAddressHashBlockNumber.change/0 forward | |
| 2023-02-13T13:20:12.257 application=ecto_sql [info] create index if not exists token_transfers_token_contract_address_hash_block_number_index | |
| 2023-02-13T13:20:12.258 application=ecto_sql [info] == Migrated 20200410141202 in 0.0s | |
| 2023-02-13T13:20:12.259 application=ecto_sql [info] == Running 20200421102450 Explorer.Repo.Migrations.PendingTxs.up/0 forward | |
| 2023-02-13T13:20:12.259 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-13T13:20:12.260 application=ecto_sql [info] drop index if exists transactions_hash_inserted_at_index | |
| 2023-02-13T13:20:12.260 application=ecto_sql [info] == Migrated 20200421102450 in 0.0s | |
| 2023-02-13T13:20:12.262 application=ecto_sql [info] == Running 20200424070607 Explorer.Repo.Migrations.DropBlockRewardsAddressHashAddressTypeBlockHashIndex.change/0 forward | |
| 2023-02-13T13:20:12.262 application=ecto_sql [info] drop index if exists block_rewards_address_hash_address_type_block_hash_index | |
| 2023-02-13T13:20:12.262 application=ecto_sql [info] == Migrated 20200424070607 in 0.0s | |
| 2023-02-13T13:20:12.263 application=ecto_sql [info] == Running 20200518075748 Explorer.Repo.Migrations.CreateIndexBlocksMinerHashNumberIndex.change/0 forward | |
| 2023-02-13T13:20:12.263 application=ecto_sql [info] create index if not exists blocks_miner_hash_number_index | |
| 2023-02-13T13:20:12.264 application=ecto_sql [info] == Migrated 20200518075748 in 0.0s | |
| 2023-02-13T13:20:12.265 application=ecto_sql [info] == Running 20200521090250 Explorer.Repo.Migrations.RecreateStakingTables.change/0 forward | |
| 2023-02-13T13:20:12.266 application=ecto_sql [info] drop table if exists staking_pools | |
| 2023-02-13T13:20:12.266 application=ecto_sql [info] drop table if exists staking_pools_delegators | |
| 2023-02-13T13:20:12.267 application=ecto_sql [info] create table staking_pools | |
| 2023-02-13T13:20:12.270 application=ecto_sql [info] create index staking_pools_staking_address_hash_index | |
| 2023-02-13T13:20:12.271 application=ecto_sql [info] create index staking_pools_mining_address_hash_index | |
| 2023-02-13T13:20:12.273 application=ecto_sql [info] create table staking_pools_delegators | |
| 2023-02-13T13:20:12.276 application=ecto_sql [info] create index pools_delegator_index | |
| 2023-02-13T13:20:12.278 application=ecto_sql [info] create index snapshotted_stake_amount_index | |
| 2023-02-13T13:20:12.279 application=ecto_sql [info] == Migrated 20200521090250 in 0.0s | |
| 2023-02-13T13:20:12.280 application=ecto_sql [info] == Running 20200521170002 Explorer.Repo.Migrations.CreateTokenTransfersTokenContractAddressHashTokenIdBlockNumberIndex.change/0 forward | |
| 2023-02-13T13:20:12.280 application=ecto_sql [info] create index if not exists token_transfers_token_contract_address_hash_token_id_DESC_block_number_DESC_index | |
| 2023-02-13T13:20:12.282 application=ecto_sql [info] == Migrated 20200521170002 in 0.0s | |
| 2023-02-13T13:20:12.283 application=ecto_sql [info] == Running 20200525115811 Explorer.Repo.Migrations.AddressCoinBalancesDaily.change/0 forward | |
| 2023-02-13T13:20:12.283 application=ecto_sql [info] create table address_coin_balances_daily | |
| 2023-02-13T13:20:12.285 application=ecto_sql [info] create index address_coin_balances_daily_address_hash_day_index | |
| 2023-02-13T13:20:12.286 application=ecto_sql [info] == Migrated 20200525115811 in 0.0s | |
| 2023-02-13T13:20:12.287 application=ecto_sql [info] == Running 20200527144742 Explorer.Repo.Migrations.AddCountersTable.change/0 forward | |
| 2023-02-13T13:20:12.287 application=ecto_sql [info] create table last_fetched_counters | |
| 2023-02-13T13:20:12.289 application=ecto_sql [info] == Migrated 20200527144742 in 0.0s | |
| 2023-02-13T13:20:12.290 application=ecto_sql [info] == Running 20200608075122 Explorer.Repo.Migrations.AlterTransactionsAddErrorReason.change/0 forward | |
| 2023-02-13T13:20:12.290 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.290 application=ecto_sql [info] == Migrated 20200608075122 in 0.0s | |
| 2023-02-13T13:20:12.291 application=ecto_sql [info] == Running 20200806125649 Explorer.Repo.Migrations.TokenAddBridgedColumn.change/0 forward | |
| 2023-02-13T13:20:12.291 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.292 application=ecto_sql [info] == Migrated 20200806125649 in 0.0s | |
| 2023-02-13T13:20:12.293 application=ecto_sql [info] == Running 20200807064700 Explorer.Repo.Migrations.BridgedTokensTable.change/0 forward | |
| 2023-02-13T13:20:12.293 application=ecto_sql [info] create table bridged_tokens | |
| 2023-02-13T13:20:12.295 application=ecto_sql [info] create index bridged_tokens_home_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.296 application=ecto_sql [info] == Migrated 20200807064700 in 0.0s | |
| 2023-02-13T13:20:12.297 application=ecto_sql [info] == Running 20200812143050 Explorer.Repo.Migrations.AddAddressesContractCodeIndex.change/0 forward | |
| 2023-02-13T13:20:12.297 application=ecto_sql [info] execute "CREATE INDEX addresses_contract_code_index ON addresses (md5(contract_code::text));" | |
| 2023-02-13T13:20:12.299 application=ecto_sql [info] == Migrated 20200812143050 in 0.0s | |
| 2023-02-13T13:20:12.300 application=ecto_sql [info] == Running 20200904075501 Explorer.Repo.Migrations.AddBridgedTokenCustomMetadata.change/0 forward | |
| 2023-02-13T13:20:12.300 application=ecto_sql [info] alter table bridged_tokens | |
| 2023-02-13T13:20:12.300 application=ecto_sql [info] == Migrated 20200904075501 in 0.0s | |
| 2023-02-13T13:20:12.301 application=ecto_sql [info] == Running 20200929075625 Explorer.Repo.Migrations.AddBridgedTokenType.change/0 forward | |
| 2023-02-13T13:20:12.301 application=ecto_sql [info] alter table bridged_tokens | |
| 2023-02-13T13:20:12.301 application=ecto_sql [info] == Migrated 20200929075625 in 0.0s | |
| 2023-02-13T13:20:12.302 application=ecto_sql [info] == Running 20201026093652 Explorer.Repo.Migrations.TransactionsStatAddGasUsageColumn.change/0 forward | |
| 2023-02-13T13:20:12.302 application=ecto_sql [info] alter table transaction_stats | |
| 2023-02-13T13:20:12.303 application=ecto_sql [info] == Migrated 20201026093652 in 0.0s | |
| 2023-02-13T13:20:12.304 application=ecto_sql [info] == Running 20201214203532 Explorer.Repo.Migrations.SupportSourcify.change/0 forward | |
| 2023-02-13T13:20:12.304 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.304 application=ecto_sql [info] create table smart_contracts_additional_sources | |
| 2023-02-13T13:20:12.308 application=ecto_sql [info] create index smart_contracts_additional_sources_address_hash_index | |
| 2023-02-13T13:20:12.309 application=ecto_sql [info] == Migrated 20201214203532 in 0.0s | |
| 2023-02-13T13:20:12.310 application=ecto_sql [info] == Running 20210219080523 Explorer.Repo.Migrations.AddTags.change/0 forward | |
| 2023-02-13T13:20:12.311 application=ecto_sql [info] create table address_tags | |
| 2023-02-13T13:20:12.311 application=ecto_sql [info] create index address_tags_id_index | |
| 2023-02-13T13:20:12.312 application=ecto_sql [info] create index address_tags_label_index | |
| 2023-02-13T13:20:12.314 application=ecto_sql [info] create table address_to_tags | |
| 2023-02-13T13:20:12.317 application=ecto_sql [info] create index address_to_tags_address_hash_tag_id_index | |
| 2023-02-13T13:20:12.318 application=ecto_sql [info] == Migrated 20210219080523 in 0.0s | |
| 2023-02-13T13:20:12.319 application=ecto_sql [info] == Running 20210226154732 Explorer.Repo.Migrations.AddExchangeRateColumnToBridgedTokens.change/0 forward | |
| 2023-02-13T13:20:12.319 application=ecto_sql [info] alter table bridged_tokens | |
| 2023-02-13T13:20:12.320 application=ecto_sql [info] == Migrated 20210226154732 in 0.0s | |
| 2023-02-13T13:20:12.321 application=ecto_sql [info] == Running 20210309104122 Explorer.Repo.Migrations.AddBridgedTokenCustomCap.change/0 forward | |
| 2023-02-13T13:20:12.321 application=ecto_sql [info] alter table bridged_tokens | |
| 2023-02-13T13:20:12.321 application=ecto_sql [info] == Migrated 20210309104122 in 0.0s | |
| 2023-02-13T13:20:12.322 application=ecto_sql [info] == Running 20210331074008 Explorer.Repo.Migrations.AddPoolNameDescription.change/0 forward | |
| 2023-02-13T13:20:12.322 application=ecto_sql [info] alter table staking_pools | |
| 2023-02-13T13:20:12.323 application=ecto_sql [info] == Migrated 20210331074008 in 0.0s | |
| 2023-02-13T13:20:12.324 application=ecto_sql [info] == Running 20210422115740 Explorer.Repo.Migrations.AddTokenIdToCurrentTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.324 application=ecto_sql [info] alter table address_current_token_balances | |
| 2023-02-13T13:20:12.324 application=ecto_sql [info] create index address_current_token_balances_token_id_index | |
| 2023-02-13T13:20:12.325 application=ecto_sql [info] == Migrated 20210422115740 in 0.0s | |
| 2023-02-13T13:20:12.326 application=ecto_sql [info] == Running 20210423084253 Explorer.Repo.Migrations.AddressCurrentTokenBalancesAddTokenIdToUniqueIndex.change/0 forward | |
| 2023-02-13T13:20:12.327 application=ecto_sql [info] drop index address_current_token_balances_address_hash_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.327 application=ecto_sql [info] create index fetched_current_token_balances_with_token_id | |
| 2023-02-13T13:20:12.328 application=ecto_sql [info] create index fetched_current_token_balances | |
| 2023-02-13T13:20:12.330 application=ecto_sql [info] == Migrated 20210423084253 in 0.0s | |
| 2023-02-13T13:20:12.331 application=ecto_sql [info] == Running 20210423091652 Explorer.Repo.Migrations.AddressTokenBalancesAddTokenIdToUniqueIndex.change/0 forward | |
| 2023-02-13T13:20:12.331 application=ecto_sql [info] drop index address_token_balances_address_hash_token_contract_address_hash_block_number_index | |
| 2023-02-13T13:20:12.331 application=ecto_sql [info] create index fetched_token_balances_with_token_id | |
| 2023-02-13T13:20:12.333 application=ecto_sql [info] create index fetched_token_balances | |
| 2023-02-13T13:20:12.334 application=ecto_sql [info] == Migrated 20210423091652 in 0.0s | |
| 2023-02-13T13:20:12.335 application=ecto_sql [info] == Running 20210423094801 Explorer.Repo.Migrations.AddressTokenBalancesChangeUnfetchedTokenBalancesUniqueIndex.change/0 forward | |
| 2023-02-13T13:20:12.335 application=ecto_sql [info] drop index unfetched_token_balances | |
| 2023-02-13T13:20:12.335 application=ecto_sql [info] create index unfetched_token_balances | |
| 2023-02-13T13:20:12.337 application=ecto_sql [info] create index unfetched_token_balances_with_token_id | |
| 2023-02-13T13:20:12.338 application=ecto_sql [info] == Migrated 20210423094801 in 0.0s | |
| 2023-02-13T13:20:12.339 application=ecto_sql [info] == Running 20210423115108 Explorer.Repo.Migrations.ExtendTokenTransfersForErc1155.change/0 forward | |
| 2023-02-13T13:20:12.339 application=ecto_sql [info] alter table token_transfers | |
| 2023-02-13T13:20:12.340 application=ecto_sql [info] == Migrated 20210423115108 in 0.0s | |
| 2023-02-13T13:20:12.341 application=ecto_sql [info] == Running 20210524165427 Explorer.Repo.Migrations.MinMissingBlockNumber.change/0 forward | |
| 2023-02-13T13:20:12.341 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-13T13:20:12.341 application=ecto_sql [info] == Migrated 20210524165427 in 0.0s | |
| 2023-02-13T13:20:12.342 application=ecto_sql [info] == Running 20210527093756 Explorer.Repo.Migrations.TransactionStatsAddTotalFeeColumn.change/0 forward | |
| 2023-02-13T13:20:12.342 application=ecto_sql [info] alter table transaction_stats | |
| 2023-02-13T13:20:12.342 application=ecto_sql [info] == Migrated 20210527093756 in 0.0s | |
| 2023-02-13T13:20:12.344 application=ecto_sql [info] == Running 20210616120552 Explorer.Repo.Migrations.SmartContractsAddIsVyperFlag.change/0 forward | |
| 2023-02-13T13:20:12.344 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.344 application=ecto_sql [info] == Migrated 20210616120552 in 0.0s | |
| 2023-02-13T13:20:12.345 application=ecto_sql [info] == Running 20210701084814 Explorer.Repo.Migrations.SupportPartialMatch.change/0 forward | |
| 2023-02-13T13:20:12.345 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.345 application=ecto_sql [info] == Migrated 20210701084814 in 0.0s | |
| 2023-02-13T13:20:12.346 application=ecto_sql [info] == Running 20210811140837 Explorer.Repo.Migrations.Add1559Support.change/0 forward | |
| 2023-02-13T13:20:12.346 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.347 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.347 application=ecto_sql [info] == Migrated 20210811140837 in 0.0s | |
| 2023-02-13T13:20:12.348 application=ecto_sql [info] == Running 20210823144531 Explorer.Repo.Migrations.TokensAddMetadataFetchFlag.change/0 forward | |
| 2023-02-13T13:20:12.348 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.348 application=ecto_sql [info] == Migrated 20210823144531 in 0.0s | |
| 2023-02-13T13:20:12.349 application=ecto_sql [info] == Running 20210916194004 Explorer.Repo.Migrations.AddFilePathForSourcifyContracts.change/0 forward | |
| 2023-02-13T13:20:12.349 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.350 application=ecto_sql [info] == Migrated 20210916194004 in 0.0s | |
| 2023-02-13T13:20:12.351 application=ecto_sql [info] == Running 20211006121008 Explorer.Repo.Migrations.AddBlockIsEmptyFlag.change/0 forward | |
| 2023-02-13T13:20:12.351 application=ecto_sql [info] alter table blocks | |
| 2023-02-13T13:20:12.351 application=ecto_sql [info] create index blocks_is_empty_index | |
| 2023-02-13T13:20:12.352 application=ecto_sql [info] == Migrated 20211006121008 in 0.0s | |
| 2023-02-13T13:20:12.353 application=ecto_sql [info] == Running 20211013190346 Explorer.Repo.Migrations.RemoveDuplicatesOfCurrentTokenBalances.change/0 forward | |
| 2023-02-13T13:20:12.354 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-13T13:20:12.355 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-13T13:20:12.355 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-13T13:20:12.355 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-13T13:20:12.356 application=ecto_sql [info] == Migrated 20211013190346 in 0.0s | |
| 2023-02-13T13:20:12.361 application=ecto_sql [info] == Running 20211017135545 Explorer.Repo.Migrations.MigrateOptimizationRunsToInt8.up/0 forward | |
| 2023-02-13T13:20:12.362 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.365 application=ecto_sql [info] == Migrated 20211017135545 in 0.0s | |
| 2023-02-13T13:20:12.367 application=ecto_sql [info] == Running 20211018072347 Explorer.Repo.Migrations.AddIsEmptyIndex.change/0 forward | |
| 2023-02-13T13:20:12.367 application=ecto_sql [info] create index empty_consensus_blocks | |
| 2023-02-13T13:20:12.369 application=ecto_sql [info] == Migrated 20211018072347 in 0.0s | |
| 2023-02-13T13:20:12.370 application=ecto_sql [info] == Running 20211018073652 Explorer.Repo.Migrations.AddTokenBalancesContractAddressHashIndex.change/0 forward | |
| 2023-02-13T13:20:12.370 application=ecto_sql [info] create index address_token_balances_token_contract_address_hash_index | |
| 2023-02-13T13:20:12.372 application=ecto_sql [info] == Migrated 20211018073652 in 0.0s | |
| 2023-02-13T13:20:12.373 application=ecto_sql [info] == Running 20211018164843 Explorer.Repo.Migrations.TransactionsBlockNumberIndex.change/0 forward | |
| 2023-02-13T13:20:12.373 application=ecto_sql [info] create index transactions_block_number_index | |
| 2023-02-13T13:20:12.374 application=ecto_sql [info] == Migrated 20211018164843 in 0.0s | |
| 2023-02-13T13:20:12.376 application=ecto_sql [info] == Running 20211018170533 Explorer.Repo.Migrations.AddAddressTokenBalancesAddressHashTokenContractAddressHashBlockNumberIndex.change/0 forward | |
| 2023-02-13T13:20:12.376 application=ecto_sql [info] create index address_token_balances_address_hash_token_contract_address_hash_block_number_index | |
| 2023-02-13T13:20:12.377 application=ecto_sql [info] == Migrated 20211018170533 in 0.0s | |
| 2023-02-13T13:20:12.378 application=ecto_sql [info] == Running 20211018170638 Explorer.Repo.Migrations.AddLogsAddressHashTransactionHashIndex.change/0 forward | |
| 2023-02-13T13:20:12.378 application=ecto_sql [info] create index logs_address_hash_transaction_hash_index | |
| 2023-02-13T13:20:12.379 application=ecto_sql [info] == Migrated 20211018170638 in 0.0s | |
| 2023-02-13T13:20:12.380 application=ecto_sql [info] == Running 20211029085117 Explorer.Repo.Migrations.DropBlockRewardsBlockHashPartialIndex.change/0 forward | |
| 2023-02-13T13:20:12.380 application=ecto_sql [info] drop index if exists block_rewards_block_hash_partial_index | |
| 2023-02-13T13:20:12.381 application=ecto_sql [info] == Migrated 20211029085117 in 0.0s | |
| 2023-02-13T13:20:12.382 application=ecto_sql [info] == Running 20211115164817 Explorer.Repo.Migrations.AddCheckForBytecodeActuality.change/0 forward | |
| 2023-02-13T13:20:12.382 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.383 application=ecto_sql [info] == Migrated 20211115164817 in 0.0s | |
| 2023-02-13T13:20:12.384 application=ecto_sql [info] == Running 20211203115010 Explorer.Repo.Migrations.AddContractVerificationStatusTable.change/0 forward | |
| 2023-02-13T13:20:12.384 application=ecto_sql [info] create table contract_verification_status | |
| 2023-02-13T13:20:12.386 application=ecto_sql [info] == Migrated 20211203115010 in 0.0s | |
| 2023-02-13T13:20:12.388 application=ecto_sql [info] == Running 20211204184037 Explorer.Repo.Migrations.AddressAddGasUsed.change/0 forward | |
| 2023-02-13T13:20:12.388 application=ecto_sql [info] alter table addresses | |
| 2023-02-13T13:20:12.388 application=ecto_sql [info] == Migrated 20211204184037 in 0.0s | |
| 2023-02-13T13:20:12.389 application=ecto_sql [info] == Running 20211206071033 Explorer.Repo.Migrations.ModifyAddressGasUsedBigint.up/0 forward | |
| 2023-02-13T13:20:12.389 application=ecto_sql [info] alter table addresses | |
| 2023-02-13T13:20:12.396 application=ecto_sql [info] == Migrated 20211206071033 in 0.0s | |
| 2023-02-13T13:20:12.398 application=ecto_sql [info] == Running 20211210184136 Explorer.Repo.Migrations.AddDisplayNameToAddressTag.up/0 forward | |
| 2023-02-13T13:20:12.398 application=ecto_sql [info] alter table address_tags | |
| 2023-02-13T13:20:12.399 application=ecto_sql [info] == Migrated 20211210184136 in 0.0s | |
| 2023-02-13T13:20:12.400 application=ecto_sql [info] == Running 20211217201759 Explorer.Repo.Migrations.AddHasErrorInInternalTxsFieldToTransaction.change/0 forward | |
| 2023-02-13T13:20:12.401 application=ecto_sql [info] alter table transactions | |
| 2023-02-13T13:20:12.401 application=ecto_sql [info] == Migrated 20211217201759 in 0.0s | |
| 2023-02-13T13:20:12.402 application=ecto_sql [info] == Running 20220111085751 Explorer.Repo.Migrations.AddressAddCounters.change/0 forward | |
| 2023-02-13T13:20:12.402 application=ecto_sql [info] alter table addresses | |
| 2023-02-13T13:20:12.402 application=ecto_sql [info] == Migrated 20220111085751 in 0.0s | |
| 2023-02-13T13:20:12.403 application=ecto_sql [info] == Running 20220303083252 Explorer.Repo.Migrations.SmartContractsContractCodeMd5.change/0 forward | |
| 2023-02-13T13:20:12.403 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.404 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-13T13:20:12.404 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.404 application=ecto_sql [info] drop index if exists addresses_contract_code_index | |
| 2023-02-13T13:20:12.405 application=ecto_sql [info] create index smart_contracts_contract_code_md5_index | |
| 2023-02-13T13:20:12.406 application=ecto_sql [info] == Migrated 20220303083252 in 0.0s | |
| 2023-02-13T13:20:12.407 application=ecto_sql [info] == Running 20220306091504 Explorer.Repo.Migrations.AddImplementationName.change/0 forward | |
| 2023-02-13T13:20:12.407 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.407 application=ecto_sql [info] == Migrated 20220306091504 in 0.0s | |
| 2023-02-13T13:20:12.408 application=ecto_sql [info] == Running 20220527131249 Explorer.Repo.Migrations.AddImplementationFields.change/0 forward | |
| 2023-02-13T13:20:12.408 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.409 application=ecto_sql [info] == Migrated 20220527131249 in 0.0s | |
| 2023-02-13T13:20:12.410 application=ecto_sql [info] == Running 20220622114402 Explorer.Repo.Migrations.RemoveStakingTables.change/0 forward | |
| 2023-02-13T13:20:12.410 application=ecto_sql [info] execute "DROP TABLE staking_pools_delegators CASCADE;\n" | |
| 2023-02-13T13:20:12.410 application=ecto_sql [info] execute "DROP TABLE staking_pools CASCADE;\n" | |
| 2023-02-13T13:20:12.411 application=ecto_sql [info] == Migrated 20220622114402 in 0.0s | |
| 2023-02-13T13:20:12.413 application=ecto_sql [info] == Running 20220622140604 Explorer.Repo.Migrations.RemoveBridgedTokens.change/0 forward | |
| 2023-02-13T13:20:12.413 application=ecto_sql [info] drop table if exists bridged_tokens | |
| 2023-02-13T13:20:12.413 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.413 application=ecto_sql [info] == Migrated 20220622140604 in 0.0s | |
| 2023-02-13T13:20:12.415 application=ecto_sql [info] == Running 20220706101103 Explorer.Repo.Migrations.AddressCoinBalancesDailyAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.415 application=ecto_sql [info] drop index address_coin_balances_daily_address_hash_day_index | |
| 2023-02-13T13:20:12.415 application=ecto_sql [info] alter table address_coin_balances_daily | |
| 2023-02-13T13:20:12.417 application=ecto_sql [info] == Migrated 20220706101103 in 0.0s | |
| 2023-02-13T13:20:12.418 application=ecto_sql [info] == Running 20220706102257 Explorer.Repo.Migrations.AddressCoinBalancesAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.418 application=ecto_sql [info] drop index address_coin_balances_address_hash_block_number_index | |
| 2023-02-13T13:20:12.418 application=ecto_sql [info] alter table address_coin_balances | |
| 2023-02-13T13:20:12.421 application=ecto_sql [info] == Migrated 20220706102257 in 0.0s | |
| 2023-02-13T13:20:12.423 application=ecto_sql [info] == Running 20220706102504 Explorer.Repo.Migrations.TransactionsForksAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.423 application=ecto_sql [info] drop index transaction_forks_uncle_hash_index_index | |
| 2023-02-13T13:20:12.423 application=ecto_sql [info] alter table transaction_forks | |
| 2023-02-13T13:20:12.424 application=ecto_sql [info] == Migrated 20220706102504 in 0.0s | |
| 2023-02-13T13:20:12.426 application=ecto_sql [info] == Running 20220706102746 Explorer.Repo.Migrations.BlockRewardsAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.426 application=ecto_sql [info] drop index block_rewards_address_hash_block_hash_address_type_index | |
| 2023-02-13T13:20:12.426 application=ecto_sql [info] alter table block_rewards | |
| 2023-02-13T13:20:12.428 application=ecto_sql [info] == Migrated 20220706102746 in 0.0s | |
| 2023-02-13T13:20:12.430 application=ecto_sql [info] == Running 20220706105925 Explorer.Repo.Migrations.EmissionRewardsAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.430 application=ecto_sql [info] drop index emission_rewards_block_range_index | |
| 2023-02-13T13:20:12.430 application=ecto_sql [info] alter table emission_rewards | |
| 2023-02-13T13:20:12.432 application=ecto_sql [info] == Migrated 20220706105925 in 0.0s | |
| 2023-02-13T13:20:12.433 application=ecto_sql [info] == Running 20220706111510 Explorer.Repo.Migrations.AddressNamesAddPrimaryKey.change/0 forward | |
| 2023-02-13T13:20:12.433 application=ecto_sql [info] alter table address_names | |
| 2023-02-13T13:20:12.438 application=ecto_sql [info] == Migrated 20220706111510 in 0.0s | |
| 2023-02-13T13:20:12.440 application=ecto_sql [info] == Running 20220804114005 Explorer.Repo.Migrations.CreateEventNotifications.change/0 forward | |
| 2023-02-13T13:20:12.440 application=ecto_sql [info] create table event_notifications | |
| 2023-02-13T13:20:12.443 application=ecto_sql [info] == Migrated 20220804114005 in 0.0s | |
| 2023-02-13T13:20:12.444 application=ecto_sql [info] == Running 20220902083436 Explorer.Repo.Migrations.ExtendTokenNameType.change/0 forward | |
| 2023-02-13T13:20:12.444 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.445 application=ecto_sql [info] == Migrated 20220902083436 in 0.0s | |
| 2023-02-13T13:20:12.446 application=ecto_sql [info] == Running 20220902103213 Explorer.Repo.Migrations.CreateIndexTokenTransfersTokenIds.up/0 forward | |
| 2023-02-13T13:20:12.446 application=ecto_sql [info] execute "CREATE INDEX token_transfers_token_ids_index on token_transfers USING GIN (\"token_ids\")\n" | |
| 2023-02-13T13:20:12.446 application=ecto_sql [info] == Migrated 20220902103213 in 0.0s | |
| 2023-02-13T13:20:12.447 application=ecto_sql [info] == Running 20220902103527 Explorer.Repo.Migrations.CreateIndexesTokenInstancesTokenContractAddressHashTokenId.change/0 forward | |
| 2023-02-13T13:20:12.447 application=ecto_sql [info] create index if not exists token_instances_token_contract_address_hash_token_id_index | |
| 2023-02-13T13:20:12.448 application=ecto_sql [info] create index if not exists token_instances_token_id_index | |
| 2023-02-13T13:20:12.450 application=ecto_sql [info] == Migrated 20220902103527 in 0.0s | |
| 2023-02-13T13:20:12.451 application=ecto_sql [info] == Running 20220919105140 Explorer.Repo.Migrations.AddMethodIdIndex.up/0 forward | |
| 2023-02-13T13:20:12.451 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-13T13:20:12.454 application=ecto_sql [info] == Migrated 20220919105140 in 0.0s | |
| 2023-02-13T13:20:12.455 application=ecto_sql [info] == Running 20220926122620 Explorer.Repo.Migrations.ExtendTokenSymbolType.change/0 forward | |
| 2023-02-13T13:20:12.455 application=ecto_sql [info] alter table tokens | |
| 2023-02-13T13:20:12.456 application=ecto_sql [info] == Migrated 20220926122620 in 0.0s | |
| 2023-02-13T13:20:12.457 application=ecto_sql [info] == Running 20221104091552 Explorer.Repo.Migrations.AddTransactionActionsTable.change/0 forward | |
| 2023-02-13T13:20:12.457 application=ecto_sql [info] execute "CREATE TYPE transaction_actions_protocol AS ENUM ('uniswap_v3', 'opensea_v1_1', 'wrapping', 'approval', 'zkbob')" | |
| 2023-02-13T13:20:12.457 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-13T13:20:12.458 application=ecto_sql [info] create table transaction_actions | |
| 2023-02-13T13:20:12.464 application=ecto_sql [info] create index transaction_actions_protocol_type_index | |
| 2023-02-13T13:20:12.466 application=ecto_sql [info] == Migrated 20221104091552 in 0.0s | |
| 2023-02-13T13:20:12.467 application=ecto_sql [info] == Running 20221104104635 Explorer.Repo.Migrations.CreateTokenTransferTokenIdMigratorProgress.change/0 forward | |
| 2023-02-13T13:20:12.467 application=ecto_sql [info] create table token_transfer_token_id_migrator_progress | |
| 2023-02-13T13:20:12.468 application=ecto_sql [info] == Migrated 20221104104635 in 0.0s | |
| 2023-02-13T13:20:12.469 application=ecto_sql [info] == Running 20221114113853 Explorer.Repo.Migrations.RemoveNotNullConstraintFromAbi.change/0 forward | |
| 2023-02-13T13:20:12.470 application=ecto_sql [info] execute "ALTER TABLE smart_contracts ALTER COLUMN abi DROP NOT NULL;" | |
| 2023-02-13T13:20:12.470 application=ecto_sql [info] == Migrated 20221114113853 in 0.0s | |
| 2023-02-13T13:20:12.471 application=ecto_sql [info] == Running 20221114121811 Explorer.Repo.Migrations.DropInternalTransactionsOrderIndex.change/0 forward | |
| 2023-02-13T13:20:12.471 application=ecto_sql [info] drop index if exists internal_transactions_block_number_DESC__transaction_index_DESC__index_DESC_index | |
| 2023-02-13T13:20:12.471 application=ecto_sql [info] == Migrated 20221114121811 in 0.0s | |
| 2023-02-13T13:20:12.472 application=ecto_sql [info] == Running 20221117075456 Explorer.Repo.Migrations.ModifyAddressTokenBalancesIndexes.change/0 forward | |
| 2023-02-13T13:20:12.472 application=ecto_sql [info] drop index if exists fetched_token_balances | |
| 2023-02-13T13:20:12.473 application=ecto_sql [info] drop index if exists fetched_token_balances_with_token_id | |
| 2023-02-13T13:20:12.473 application=ecto_sql [info] create index if not exists fetched_token_balances | |
| 2023-02-13T13:20:12.474 application=ecto_sql [info] drop index if exists unfetched_token_balances | |
| 2023-02-13T13:20:12.474 application=ecto_sql [info] drop index if exists unfetched_token_balances_with_token_id | |
| 2023-02-13T13:20:12.475 application=ecto_sql [info] create index if not exists unfetched_token_balances | |
| 2023-02-13T13:20:12.476 application=ecto_sql [info] == Migrated 20221117075456 in 0.0s | |
| 2023-02-13T13:20:12.477 application=ecto_sql [info] == Running 20221117080657 Explorer.Repo.Migrations.ModifyAddressCurrentTokenBalancesIndexes.change/0 forward | |
| 2023-02-13T13:20:12.477 application=ecto_sql [info] drop index if exists fetched_current_token_balances | |
| 2023-02-13T13:20:12.477 application=ecto_sql [info] drop index if exists fetched_current_token_balances_with_token_id | |
| 2023-02-13T13:20:12.478 application=ecto_sql [info] create index if not exists fetched_current_token_balances | |
| 2023-02-13T13:20:12.479 application=ecto_sql [info] == Migrated 20221117080657 in 0.0s | |
| 2023-02-13T13:20:12.480 application=ecto_sql [info] == Running 20221120184715 Explorer.Repo.Migrations.AddJsonCompilerSettings.change/0 forward | |
| 2023-02-13T13:20:12.480 application=ecto_sql [info] alter table smart_contracts | |
| 2023-02-13T13:20:12.480 application=ecto_sql [info] == Migrated 20221120184715 in 0.0s | |
| 2023-02-13T13:20:12.481 application=ecto_sql [info] == Running 20221125074820 Explorer.Repo.Migrations.DropRequiredOutputConstraint.change/0 forward | |
| 2023-02-13T13:20:12.481 application=ecto_sql [info] drop constraint call_has_error_or_result from table internal_transactions | |
| 2023-02-13T13:20:12.482 application=ecto_sql [info] create check constraint call_has_error_or_result on table internal_transactions | |
| 2023-02-13T13:20:12.482 application=ecto_sql [info] == Migrated 20221125074820 in 0.0s | |
| 2023-02-13T13:20:12.483 application=ecto_sql [info] == Running 20221126103223 Explorer.Repo.Migrations.AddTxsIndexes.change/0 forward | |
| 2023-02-13T13:20:12.483 application=ecto_sql [info] drop index if exists transactions_from_address_hash_recent_collated_index | |
| 2023-02-13T13:20:12.485 application=ecto_sql [info] drop index if exists transactions_to_address_hash_recent_collated_index | |
| 2023-02-13T13:20:12.487 application=ecto_sql [info] drop index if exists transactions_created_contract_address_hash_recent_collated_index | |
| 2023-02-13T13:20:12.488 application=ecto_sql [info] create index if not exists transactions_from_address_hash_with_pending_index | |
| 2023-02-13T13:20:12.491 application=ecto_sql [info] create index if not exists transactions_to_address_hash_with_pending_index | |
| 2023-02-13T13:20:12.494 application=ecto_sql [info] create index if not exists transactions_created_contract_address_hash_with_pending_index | |
| 2023-02-13T13:20:12.497 application=ecto_sql [info] == Migrated 20221126103223 in 0.0s | |
| 2023-02-13T13:20:12.498 application=ecto_sql [info] == Running 20221209123459 Explorer.Repo.Migrations.DropUnfetchedTokenBalancesIndex.change/0 forward | |
| 2023-02-13T13:20:12.498 application=ecto_sql [info] drop index if exists unfetched_token_balances | |
| 2023-02-13T13:20:12.499 application=ecto_sql [info] == Migrated 20221209123459 in 0.0s | |
| 2023-02-13T13:20:12.500 application=ecto_sql [info] == Running 20221212093406 Explorer.Repo.Migrations.ChangeIndexForPendingBlockOperations.change/0 forward | |
| 2023-02-13T13:20:12.500 application=ecto_sql [info] drop index if exists pending_block_operations_block_hash_index_partial | |
| 2023-02-13T13:20:12.500 application=ecto_sql [info] alter table pending_block_operations | |
| 2023-02-13T13:20:12.500 application=ecto_sql [info] == Migrated 20221212093406 in 0.0s | |
| 2023-02-13T13:20:12.501 application=ecto_sql [info] == Running 20221219151744 Explorer.Repo.Migrations.CreateMissingBlockRanges.change/0 forward | |
| 2023-02-13T13:20:12.501 application=ecto_sql [info] create table missing_block_ranges | |
| 2023-02-13T13:20:12.503 application=ecto_sql [info] create index missing_block_ranges_from_number_DESC_index | |
| 2023-02-13T13:20:12.504 application=ecto_sql [info] create index missing_block_ranges_from_number_to_number_index | |
| 2023-02-13T13:20:12.506 application=ecto_sql [info] == Migrated 20221219151744 in 0.0s | |
| 2023-02-13T13:20:12.507 application=ecto_sql [info] == Running 20221223151234 Explorer.Repo.Migrations.AddBlockNumberToPendingBlockOperations.change/0 forward | |
| 2023-02-13T13:20:12.507 application=ecto_sql [info] alter table pending_block_operations | |
| 2023-02-13T13:20:12.507 application=ecto_sql [info] == Migrated 20221223151234 in 0.0s | |
| Running migrations for explorer | |
| 2023-02-13T13:20:12.701 application=ecto_sql [info] == Running 20211031164954 Explorer.Repo.Account.Migrations.CreateAccountIdentities.change/0 forward | |
| 2023-02-13T13:20:12.701 application=ecto_sql [info] create table account_identities | |
| 2023-02-13T13:20:12.707 application=ecto_sql [info] create index account_identities_uid_index | |
| 2023-02-13T13:20:12.709 application=ecto_sql [info] == Migrated 20211031164954 in 0.0s | |
| 2023-02-13T13:20:12.710 application=ecto_sql [info] == Running 20211105114502 Explorer.Repo.Account.Migrations.CreateAccountWatchlists.change/0 forward | |
| 2023-02-13T13:20:12.711 application=ecto_sql [info] create table account_watchlists | |
| 2023-02-13T13:20:12.713 application=ecto_sql [info] create index account_watchlists_identity_id_index | |
| 2023-02-13T13:20:12.715 application=ecto_sql [info] == Migrated 20211105114502 in 0.0s | |
| 2023-02-13T13:20:12.716 application=ecto_sql [info] == Running 20211105130907 Explorer.Repo.Account.Migrations.CreateAccountWatchlistAddresses.change/0 forward | |
| 2023-02-13T13:20:12.716 application=ecto_sql [info] create table account_watchlist_addresses | |
| 2023-02-13T13:20:12.720 application=ecto_sql [info] create index account_watchlist_addresses_watchlist_id_index | |
| 2023-02-13T13:20:12.722 application=ecto_sql [info] create index account_watchlist_addresses_address_hash_index | |
| 2023-02-13T13:20:12.723 application=ecto_sql [info] == Migrated 20211105130907 in 0.0s | |
| 2023-02-13T13:20:12.725 application=ecto_sql [info] == Running 20211127212336 Explorer.Repo.Account.Migrations.CreateAccountWatchlistNotifications.change/0 forward | |
| 2023-02-13T13:20:12.725 application=ecto_sql [info] create table account_watchlist_notifications | |
| 2023-02-13T13:20:12.729 application=ecto_sql [info] create index account_watchlist_notifications_watchlist_address_id_index | |
| 2023-02-13T13:20:12.730 application=ecto_sql [info] create index account_watchlist_notifications_transaction_hash_index | |
| 2023-02-13T13:20:12.732 application=ecto_sql [info] create index account_watchlist_notifications_from_address_hash_index | |
| 2023-02-13T13:20:12.733 application=ecto_sql [info] create index account_watchlist_notifications_to_address_hash_index | |
| 2023-02-13T13:20:12.735 application=ecto_sql [info] == Migrated 20211127212336 in 0.0s | |
| 2023-02-13T13:20:12.736 application=ecto_sql [info] == Running 20211205220414 Explorer.Repo.Account.Migrations.AddEmailToAccountIdentity.change/0 forward | |
| 2023-02-13T13:20:12.737 application=ecto_sql [info] alter table account_identities | |
| 2023-02-13T13:20:12.738 application=ecto_sql [info] == Migrated 20211205220414 in 0.0s | |
| 2023-02-13T13:20:12.740 application=ecto_sql [info] == Running 20220212222222 Explorer.Repo.Account.Migrations.CreateAccountTagAddresses.change/0 forward | |
| 2023-02-13T13:20:12.740 application=ecto_sql [info] create table account_tag_addresses | |
| 2023-02-13T13:20:12.744 application=ecto_sql [info] create index account_tag_addresses_identity_id_index | |
| 2023-02-13T13:20:12.745 application=ecto_sql [info] create index account_tag_addresses_address_hash_index | |
| 2023-02-13T13:20:12.747 application=ecto_sql [info] == Migrated 20220212222222 in 0.0s | |
| 2023-02-13T13:20:12.748 application=ecto_sql [info] == Running 20220313133333 Explorer.Repo.Account.Migrations.CreateAccountTagTransactions.change/0 forward | |
| 2023-02-13T13:20:12.748 application=ecto_sql [info] create table account_tag_transactions | |
| 2023-02-13T13:20:12.752 application=ecto_sql [info] create index account_tag_transactions_identity_id_index | |
| 2023-02-13T13:20:12.753 application=ecto_sql [info] create index account_tag_transactions_tx_hash_index | |
| 2023-02-13T13:20:12.755 application=ecto_sql [info] == Migrated 20220313133333 in 0.0s | |
| 2023-02-13T13:20:12.757 application=ecto_sql [info] == Running 20220324213333 Explorer.Repo.Account.Migrations.AddSubjectToWatchlistNotifications.change/0 forward | |
| 2023-02-13T13:20:12.757 application=ecto_sql [info] alter table account_watchlist_notifications | |
| 2023-02-13T13:20:12.758 application=ecto_sql [info] == Migrated 20220324213333 in 0.0s | |
| 2023-02-13T13:20:12.760 application=ecto_sql [info] == Running 20220407134152 Explorer.Repo.Account.Migrations.AddApiKeysAndPlansTables.change/0 forward | |
| 2023-02-13T13:20:12.760 application=ecto_sql [info] create table account_api_plans | |
| 2023-02-13T13:20:12.762 application=ecto_sql [info] create index account_api_plans_id_max_req_per_second_name_index | |
| 2023-02-13T13:20:12.764 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-13T13:20:12.764 application=ecto_sql [info] create table account_api_keys | |
| 2023-02-13T13:20:12.767 application=ecto_sql [info] alter table account_identities | |
| 2023-02-13T13:20:12.768 application=ecto_sql [info] create index account_api_keys_identity_id_index | |
| 2023-02-13T13:20:12.769 application=ecto_sql [info] == Migrated 20220407134152 in 0.0s | |
| 2023-02-13T13:20:12.772 application=ecto_sql [info] == Running 20220510094118 Explorer.Repo.Account.Migrations.AddCustomAbisTable.change/0 forward | |
| 2023-02-13T13:20:12.772 application=ecto_sql [info] create table account_custom_abis | |
| 2023-02-13T13:20:12.776 application=ecto_sql [info] create index account_custom_abis_identity_id_address_hash_index | |
| 2023-02-13T13:20:12.778 application=ecto_sql [info] create index account_custom_abis_identity_id_index | |
| 2023-02-13T13:20:12.779 application=ecto_sql [info] == Migrated 20220510094118 in 0.0s | |
| 2023-02-13T13:20:12.782 application=ecto_sql [info] == Running 20220606194836 Explorer.Repo.Account.Migrations.AddAccountPublicTagsRequests.change/0 forward | |
| 2023-02-13T13:20:12.782 application=ecto_sql [info] create table account_public_tags_requests | |
| 2023-02-13T13:20:12.786 application=ecto_sql [info] == Migrated 20220606194836 in 0.0s | |
| 2023-02-13T13:20:12.788 application=ecto_sql [info] == Running 20220620182600 Explorer.Repo.Account.Migrations.AddAccountIdentityFields.change/0 forward | |
| 2023-02-13T13:20:12.788 application=ecto_sql [info] alter table account_identities | |
| 2023-02-13T13:20:12.788 application=ecto_sql [info] == Migrated 20220620182600 in 0.0s | |
| 2023-02-13T13:20:12.791 application=ecto_sql [info] == Running 20220624142547 Explorer.Repo.Account.Migrations.AddUniqueConstraints.change/0 forward | |
| 2023-02-13T13:20:12.791 application=ecto_sql [info] create index account_tag_addresses_identity_id_address_hash_index | |
| 2023-02-13T13:20:12.793 application=ecto_sql [info] create index account_tag_transactions_identity_id_tx_hash_index | |
| 2023-02-13T13:20:12.794 application=ecto_sql [info] create index account_watchlist_addresses_watchlist_id_address_hash_index | |
| 2023-02-13T13:20:12.796 application=ecto_sql [info] == Migrated 20220624142547 in 0.0s | |
| 2023-02-13T13:20:12.798 application=ecto_sql [info] == Running 20220705195240 Explorer.Repo.Account.Migrations.MigratePublicTagsAddressesToArray.change/0 forward | |
| 2023-02-13T13:20:12.798 application=ecto_sql [info] alter table account_public_tags_requests | |
| 2023-02-13T13:20:12.799 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-13T13:20:12.800 application=ecto_sql [info] execute " UPDATE account_public_tags_requests set addresses_duplicate = convert(string_to_array(addresses, ';'))\n" | |
| 2023-02-13T13:20:12.800 application=ecto_sql [info] alter table account_public_tags_requests | |
| 2023-02-13T13:20:12.801 application=ecto_sql [info] rename column addresses_duplicate to addresses on table account_public_tags_requests | |
| 2023-02-13T13:20:12.801 application=ecto_sql [info] == Migrated 20220705195240 in 0.0s | |
| 2023-02-13T13:20:12.803 application=ecto_sql [info] == Running 20220706114430 Explorer.Repo.Account.Migrations.EncryptAccountData.change/0 forward | |
| 2023-02-13T13:20:12.804 application=ecto_sql [info] alter table account_identities | |
| 2023-02-13T13:20:12.805 application=ecto_sql [info] alter table account_custom_abis | |
| 2023-02-13T13:20:12.805 application=ecto_sql [info] alter table account_tag_addresses | |
| 2023-02-13T13:20:12.806 application=ecto_sql [info] alter table account_tag_transactions | |
| 2023-02-13T13:20:12.806 application=ecto_sql [info] alter table account_watchlist_addresses | |
| 2023-02-13T13:20:12.806 application=ecto_sql [info] alter table account_watchlist_notifications | |
| 2023-02-13T13:20:12.807 application=ecto_sql [info] alter table account_public_tags_requests | |
| 2023-02-13T13:20:12.807 application=ecto_sql [info] == Migrated 20220706114430 in 0.0s | |
| 2023-02-13T13:20:12.809 application=ecto_sql [info] == Running 20220706153506 Explorer.Repo.Account.Migrations.RemoveUnencryptedFields.change/0 forward | |
| 2023-02-13T13:20:12.809 application=ecto_sql [info] alter table account_identities | |
| 2023-02-13T13:20:12.810 application=ecto_sql [info] rename column encrypted_uid to uid on table account_identities | |
| 2023-02-13T13:20:12.810 application=ecto_sql [info] rename column encrypted_email to email on table account_identities | |
| 2023-02-13T13:20:12.810 application=ecto_sql [info] rename column encrypted_name to name on table account_identities | |
| 2023-02-13T13:20:12.811 application=ecto_sql [info] rename column encrypted_nickname to nickname on table account_identities | |
| 2023-02-13T13:20:12.811 application=ecto_sql [info] rename column encrypted_avatar to avatar on table account_identities | |
| 2023-02-13T13:20:12.811 application=ecto_sql [info] alter table account_custom_abis | |
| 2023-02-13T13:20:12.812 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_custom_abis | |
| 2023-02-13T13:20:12.812 application=ecto_sql [info] rename column encrypted_name to name on table account_custom_abis | |
| 2023-02-13T13:20:12.812 application=ecto_sql [info] alter table account_tag_addresses | |
| 2023-02-13T13:20:12.813 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_tag_addresses | |
| 2023-02-13T13:20:12.813 application=ecto_sql [info] rename column encrypted_name to name on table account_tag_addresses | |
| 2023-02-13T13:20:12.813 application=ecto_sql [info] alter table account_tag_transactions | |
| 2023-02-13T13:20:12.814 application=ecto_sql [info] rename column encrypted_tx_hash to tx_hash on table account_tag_transactions | |
| 2023-02-13T13:20:12.814 application=ecto_sql [info] rename column encrypted_name to name on table account_tag_transactions | |
| 2023-02-13T13:20:12.814 application=ecto_sql [info] alter table account_watchlist_addresses | |
| 2023-02-13T13:20:12.815 application=ecto_sql [info] rename column encrypted_address_hash to address_hash on table account_watchlist_addresses | |
| 2023-02-13T13:20:12.815 application=ecto_sql [info] rename column encrypted_name to name on table account_watchlist_addresses | |
| 2023-02-13T13:20:12.815 application=ecto_sql [info] alter table account_watchlist_notifications | |
| 2023-02-13T13:20:12.816 application=ecto_sql [info] rename column encrypted_name to name on table account_watchlist_notifications | |
| 2023-02-13T13:20:12.816 application=ecto_sql [info] rename column encrypted_subject to subject on table account_watchlist_notifications | |
| 2023-02-13T13:20:12.816 application=ecto_sql [info] rename column encrypted_from_address_hash to from_address_hash on table account_watchlist_notifications | |
| 2023-02-13T13:20:12.817 application=ecto_sql [info] rename column encrypted_to_address_hash to to_address_hash on table account_watchlist_notifications | |
| 2023-02-13T13:20:12.817 application=ecto_sql [info] rename column encrypted_transaction_hash to transaction_hash on table account_watchlist_notifications | |
| 2023-02-13T13:20:12.817 application=ecto_sql [info] alter table account_public_tags_requests | |
| 2023-02-13T13:20:12.818 application=ecto_sql [info] rename column encrypted_full_name to full_name on table account_public_tags_requests | |
| 2023-02-13T13:20:12.818 application=ecto_sql [info] rename column encrypted_email to email on table account_public_tags_requests | |
| 2023-02-13T13:20:12.818 application=ecto_sql [info] == Migrated 20220706153506 in 0.0s | |
| 2023-02-13T13:20:12.820 application=ecto_sql [info] == Running 20220706211444 Explorer.Repo.Account.Migrations.SetNewIndexes.change/0 forward | |
| 2023-02-13T13:20:12.821 application=ecto_sql [info] drop index if exists account_tag_addresses_identity_id_address_hash_index | |
| 2023-02-13T13:20:12.821 application=ecto_sql [info] index "account_tag_addresses_identity_id_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.821 application=ecto_sql [info] drop index if exists account_tag_transactions_identity_id_tx_hash_index | |
| 2023-02-13T13:20:12.821 application=ecto_sql [info] index "account_tag_transactions_identity_id_tx_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] drop index if exists account_watchlist_addresses_watchlist_id_address_hash_index | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] index "account_watchlist_addresses_watchlist_id_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] drop index if exists account_custom_abis_identity_id_address_hash_index | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] index "account_custom_abis_identity_id_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] drop index if exists account_watchlist_notifications_transaction_hash_index | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] index "account_watchlist_notifications_transaction_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] drop index if exists account_watchlist_notifications_from_address_hash_index | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] index "account_watchlist_notifications_from_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] drop index if exists account_watchlist_notifications_to_address_hash_index | |
| 2023-02-13T13:20:12.822 application=ecto_sql [info] index "account_watchlist_notifications_to_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] drop index if exists account_identities_uid_index | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] index "account_identities_uid_index" does not exist, skipping | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] drop index if exists account_tag_addresses_address_hash_index | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] index "account_tag_addresses_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] drop index if exists account_tag_transactions_tx_hash_index | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] index "account_tag_transactions_tx_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] drop index if exists account_watchlist_addresses_address_hash_index | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] index "account_watchlist_addresses_address_hash_index" does not exist, skipping | |
| 2023-02-13T13:20:12.823 application=ecto_sql [info] create index account_tag_addresses_identity_id_address_hash_hash_index | |
| 2023-02-13T13:20:12.825 application=ecto_sql [info] create index account_tag_transactions_identity_id_tx_hash_hash_index | |
| 2023-02-13T13:20:12.826 application=ecto_sql [info] create index unique_watchlist_id_address_hash_hash_index | |
| 2023-02-13T13:20:12.828 application=ecto_sql [info] create index account_custom_abis_identity_id_address_hash_hash_index | |
| 2023-02-13T13:20:12.829 application=ecto_sql [info] create index account_watchlist_notifications_transaction_hash_hash_index | |
| 2023-02-13T13:20:12.831 application=ecto_sql [info] create index account_watchlist_notifications_from_address_hash_hash_index | |
| 2023-02-13T13:20:12.832 application=ecto_sql [info] create index account_watchlist_notifications_to_address_hash_hash_index | |
| 2023-02-13T13:20:12.833 application=ecto_sql [info] create index account_identities_uid_hash_index | |
| 2023-02-13T13:20:12.839 application=ecto_sql [info] create index account_tag_addresses_address_hash_hash_index | |
| 2023-02-13T13:20:12.840 application=ecto_sql [info] create index account_tag_transactions_tx_hash_hash_index | |
| 2023-02-13T13:20:12.842 application=ecto_sql [info] create index account_watchlist_addresses_address_hash_hash_index | |
| 2023-02-13T13:20:12.843 application=ecto_sql [info] == Migrated 20220706211444 in 0.0s | |
| 2023-02-13T13:20:12.844 application=ecto_sql [info] == Running 20220905195203 Explorer.Repo.Account.Migrations.RemoveGuardianTokens.change/0 forward | |
| 2023-02-13T13:20:12.845 application=ecto_sql [info] drop table if exists guardian_tokens | |
| 2023-02-13T13:20:12.845 application=ecto_sql [info] table "guardian_tokens" does not exist, skipping | |
| 2023-02-13T13:20:12.845 application=ecto_sql [info] == Migrated 20220905195203 in 0.0s | |
| Success! | |
| 2023-02-13T13:20:14.086 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:14.087 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:14.186 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.186 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:14.186 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:14.189 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.189 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:14.189 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:14.191 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.191 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:14.191 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:14.193 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.193 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:14.193 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:14.196 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.196 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:14.196 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:14.198 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.198 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:14.198 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:14.200 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.200 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:14.200 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:14.202 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.203 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:14.203 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:14.205 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.205 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:14.205 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:14.207 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:14.207 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-13T13:20:14.207 application=explorer [info] tx/per day chart: save records | |
| 2023-02-13T13:20:14.208 application=explorer [info] tx/per day chart: number of inserted 10 | |
| 2023-02-13T13:20:14.237 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:14.239 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:14.242 [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-13T13:20:14.246 application=db_connection [info] Postgrex.Protocol (#PID<0.4174.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4570.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-13T13:20:17.017 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:17.019 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:18.721 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:18.721 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:18.825 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.825 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:18.825 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:18.830 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.830 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:18.830 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:18.835 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.835 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:18.835 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:18.838 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.838 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:18.838 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:18.843 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.843 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:18.843 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:18.849 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.849 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:18.849 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:18.853 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.853 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:18.853 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:18.853 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:18.856 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:18.856 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.856 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:18.856 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:18.860 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.860 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:18.860 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:18.864 [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-13T13:20:18.866 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:18.866 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-13T13:20:18.866 application=explorer [info] tx/per day chart: save records | |
| 2023-02-13T13:20:18.868 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-13T13:20:21.870 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:21.874 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:23.326 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:23.326 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:23.417 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.417 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:23.417 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:23.421 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.421 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:23.421 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:23.424 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.424 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:23.424 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:23.427 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.427 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:23.427 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:23.430 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.430 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:23.430 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:23.432 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:23.433 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.433 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:23.433 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:23.434 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:23.436 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.436 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:23.436 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:23.439 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.439 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:23.439 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:23.439 [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-13T13:20:23.441 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.441 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:23.441 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:23.444 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:23.444 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-13T13:20:23.444 application=explorer [info] tx/per day chart: save records | |
| 2023-02-13T13:20:23.445 application=db_connection [info] Postgrex.Protocol (#PID<0.4142.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4551.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-13T13:20:26.679 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:26.682 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:28.045 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:28.045 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:28.127 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.128 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:28.128 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:28.133 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.133 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:28.133 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:28.137 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.137 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:28.137 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:28.142 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.142 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:28.142 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:28.145 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.145 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:28.145 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:28.145 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:28.147 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:28.148 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.148 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:28.148 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:28.152 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.152 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:28.152 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:28.152 [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-13T13:20:28.154 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.154 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:28.154 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:28.159 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:28.159 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:28.159 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:28.161 application=db_connection [info] Postgrex.Protocol (#PID<0.4126.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4554.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-13T13:20:32.357 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:32.360 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:33.774 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:33.774 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:33.852 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.852 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:33.852 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:33.856 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.856 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:33.856 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:33.859 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.859 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:33.859 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:33.861 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.861 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:33.861 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:33.864 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.864 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:33.864 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:33.867 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.867 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:33.867 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:33.868 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:33.869 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.869 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:33.869 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:33.869 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:33.872 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.872 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:33.872 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:33.874 [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-13T13:20:33.876 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.876 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:33.876 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:33.878 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:33.878 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-13T13:20:33.878 application=explorer [info] tx/per day chart: save records | |
| 2023-02-13T13:20:33.880 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-13T13:20:39.506 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:39.509 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:40.825 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:40.826 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:40.905 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.905 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:40.905 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:40.909 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.909 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:40.909 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:40.913 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.913 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:40.913 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:40.916 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.916 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:40.916 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:40.919 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.919 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:40.919 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:40.921 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:40.922 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.922 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:40.922 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:40.923 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:40.925 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.925 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:40.925 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:40.927 [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-13T13:20:40.928 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.928 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:40.928 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:40.931 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:40.931 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:40.931 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:40.935 application=db_connection [info] Postgrex.Protocol (#PID<0.4141.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4554.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-13T13:20:49.765 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:20:49.770 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:20:51.495 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:20:51.495 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:20:51.607 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.607 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:20:51.607 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:20:51.612 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.612 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:20:51.612 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:20:51.616 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.616 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:20:51.616 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:20:51.619 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.619 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:20:51.619 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:20:51.622 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.622 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:20:51.622 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:20:51.623 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:20:51.624 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:20:51.625 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.625 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:20:51.625 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:20:51.628 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.628 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:20:51.628 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:20:51.629 [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-13T13:20:51.631 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.631 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:20:51.631 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:20:51.634 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:20:51.634 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:20:51.634 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:20:51.637 application=db_connection [info] Postgrex.Protocol (#PID<0.4082.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4554.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-13T13:21:06.852 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:21:06.854 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:21:08.141 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:21:08.141 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:21:08.221 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.221 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:21:08.221 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:21:08.227 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.227 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:21:08.227 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:21:08.230 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.230 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:21:08.230 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:21:08.234 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.234 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:21:08.234 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:21:08.238 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.238 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:21:08.238 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:21:08.242 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.242 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:21:08.242 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:21:08.244 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:21:08.246 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:21:08.247 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.247 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:21:08.247 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:21:08.250 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.250 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:21:08.250 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:21:08.250 [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-13T13:21:08.254 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.254 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:21:08.254 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:21:08.259 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:08.259 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}] | |
| {"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-13T13:21:36.251 application=ecto_sql [info] Migrations already up | |
| Running migrations for explorer | |
| Success! | |
| 2023-02-13T13:21:36.254 application=ecto_sql [info] Migrations already up | |
| 2023-02-13T13:21:37.523 application=que [info] [Que] Booting Que | |
| 2023-02-13T13:21:37.524 application=que [info] [Que] Booting Server Supervisor for Workers | |
| 2023-02-13T13:21:37.608 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.608 application=explorer [info] tx/per day chart: earliest date 2023-02-04 00:00:00Z | |
| 2023-02-13T13:21:37.608 application=explorer [info] tx/per day chart: latest date 2023-02-04 23:59:59Z | |
| 2023-02-13T13:21:37.612 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.612 application=explorer [info] tx/per day chart: earliest date 2023-02-05 00:00:00Z | |
| 2023-02-13T13:21:37.612 application=explorer [info] tx/per day chart: latest date 2023-02-05 23:59:59Z | |
| 2023-02-13T13:21:37.616 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.616 application=explorer [info] tx/per day chart: earliest date 2023-02-06 00:00:00Z | |
| 2023-02-13T13:21:37.616 application=explorer [info] tx/per day chart: latest date 2023-02-06 23:59:59Z | |
| 2023-02-13T13:21:37.619 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.619 application=explorer [info] tx/per day chart: earliest date 2023-02-07 00:00:00Z | |
| 2023-02-13T13:21:37.619 application=explorer [info] tx/per day chart: latest date 2023-02-07 23:59:59Z | |
| 2023-02-13T13:21:37.622 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.622 application=explorer [info] tx/per day chart: earliest date 2023-02-08 00:00:00Z | |
| 2023-02-13T13:21:37.622 application=explorer [info] tx/per day chart: latest date 2023-02-08 23:59:59Z | |
| 2023-02-13T13:21:37.624 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:4000 (http) | |
| 2023-02-13T13:21:37.624 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.624 application=explorer [info] tx/per day chart: earliest date 2023-02-09 00:00:00Z | |
| 2023-02-13T13:21:37.624 application=explorer [info] tx/per day chart: latest date 2023-02-09 23:59:59Z | |
| 2023-02-13T13:21:37.626 application=phoenix [info] Access BlockScoutWeb.Endpoint at ://:4000 | |
| 2023-02-13T13:21:37.627 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.627 application=explorer [info] tx/per day chart: earliest date 2023-02-10 00:00:00Z | |
| 2023-02-13T13:21:37.627 application=explorer [info] tx/per day chart: latest date 2023-02-10 23:59:59Z | |
| 2023-02-13T13:21:37.630 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.630 application=explorer [info] tx/per day chart: earliest date 2023-02-11 00:00:00Z | |
| 2023-02-13T13:21:37.630 application=explorer [info] tx/per day chart: latest date 2023-02-11 23:59:59Z | |
| 2023-02-13T13:21:37.631 [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-13T13:21:37.633 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.633 application=explorer [info] tx/per day chart: earliest date 2023-02-12 00:00:00Z | |
| 2023-02-13T13:21:37.633 application=explorer [info] tx/per day chart: latest date 2023-02-12 23:59:59Z | |
| 2023-02-13T13:21:37.635 application=explorer [info] tx/per day chart: collect records for txs per day stats | |
| 2023-02-13T13:21:37.635 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-13T13:21:37.636 application=explorer [info] tx/per day chart: save records | |
| 2023-02-13T13:21:37.637 application=db_connection [info] Postgrex.Protocol (#PID<0.4112.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4551.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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment