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