Forked from isSerge/gist:cf6580052be3bd6e999ccd2b4357f98e
Created
October 13, 2022 14:15
-
-
Save eldargab/a883089507367fdd3cef0e13d413fe2f to your computer and use it in GitHub Desktop.
Subsquid Archive logs
This file contains hidden or 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
| Attaching to subsquid-subspace_ingest_1, subsquid-subspace_gateway_1, subsquid-subspace_explorer_1, subsquid-subspace_db_1 | |
| db_1 | The files belonging to this database system will be owned by user "postgres". | |
| db_1 | This user must also own the server process. | |
| db_1 | | |
| db_1 | The database cluster will be initialized with locale "en_US.utf8". | |
| db_1 | The default database encoding has accordingly been set to "UTF8". | |
| db_1 | The default text search configuration will be set to "english". | |
| db_1 | | |
| db_1 | Data page checksums are disabled. | |
| db_1 | | |
| db_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok | |
| db_1 | creating subdirectories ... ok | |
| db_1 | selecting dynamic shared memory implementation ... posix | |
| db_1 | selecting default max_connections ... 100 | |
| db_1 | selecting default shared_buffers ... 128MB | |
| db_1 | selecting default time zone ... Etc/UTC | |
| db_1 | creating configuration files ... ok | |
| db_1 | running bootstrap script ... ok | |
| db_1 | performing post-bootstrap initialization ... ok | |
| db_1 | syncing data to disk ... ok | |
| db_1 | | |
| db_1 | | |
| db_1 | Success. You can now start the database server using: | |
| db_1 | | |
| db_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start | |
| db_1 | | |
| db_1 | initdb: warning: enabling "trust" authentication for local connections | |
| db_1 | You can change this by editing pg_hba.conf or using the option -A, or | |
| db_1 | --auth-local and --auth-host, the next time you run initdb. | |
| db_1 | waiting for server to start....2022-10-13 13:18:21.653 UTC [47] LOG: starting PostgreSQL 12.12 (Debian 12.12-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit | |
| db_1 | 2022-10-13 13:18:21.658 UTC [47] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" | |
| db_1 | 2022-10-13 13:18:21.693 UTC [48] LOG: database system was shut down at 2022-10-13 13:18:21 UTC | |
| db_1 | 2022-10-13 13:18:21.702 UTC [47] LOG: database system is ready to accept connections | |
| db_1 | done | |
| db_1 | server started | |
| db_1 | CREATE DATABASE | |
| db_1 | | |
| db_1 | | |
| db_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* | |
| db_1 | | |
| db_1 | 2022-10-13 13:18:22.130 UTC [47] LOG: received fast shutdown request | |
| db_1 | waiting for server to shut down....2022-10-13 13:18:22.135 UTC [47] LOG: aborting any active transactions | |
| db_1 | 2022-10-13 13:18:22.147 UTC [47] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1 | |
| db_1 | 2022-10-13 13:18:22.148 UTC [49] LOG: shutting down | |
| db_1 | 2022-10-13 13:18:22.181 UTC [47] LOG: database system is shut down | |
| db_1 | done | |
| db_1 | server stopped | |
| db_1 | | |
| db_1 | PostgreSQL init process complete; ready for start up. | |
| db_1 | | |
| db_1 | 2022-10-13 13:18:22.262 UTC [1] LOG: starting PostgreSQL 12.12 (Debian 12.12-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit | |
| db_1 | 2022-10-13 13:18:22.262 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 | |
| db_1 | 2022-10-13 13:18:22.262 UTC [1] LOG: listening on IPv6 address "::", port 5432 | |
| db_1 | 2022-10-13 13:18:22.277 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" | |
| db_1 | 2022-10-13 13:18:22.315 UTC [75] LOG: database system was shut down at 2022-10-13 13:18:22 UTC | |
| db_1 | 2022-10-13 13:18:22.324 UTC [1] LOG: database system is ready to accept connections | |
| explorer_1 | {"level":3,"time":1665667102172,"ns":"sqd:substrate-explorer","msg":"failed to connect to postgres://postgres@db:5432/squid-archive","err":{"errno":-111,"code":"ECONNREFUSED","syscall":"connect","address":"172.19.0.3","port":5432,"stack":"Error: connect ECONNREFUSED 172.19.0.3:5432\n at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1247:16)"}} | |
| explorer_1 | {"level":2,"time":1665667102588,"ns":"sqd:substrate-explorer","msg":"listening on port 3000"} | |
| gateway_1 | {"timestamp":"2022-10-13T13:18:21.049395Z","level":"INFO","message":"Starting 2 workers","log.target":"actix_server::builder","log.module_path":"actix_server::builder","log.file":"/usr/local/cargo/registry/src/github.com-1ecc6299db9ec823/actix-server-2.0.0/src/builder.rs","log.line":200} | |
| gateway_1 | {"timestamp":"2022-10-13T13:18:21.049450Z","level":"INFO","message":"Actix runtime found; starting in Actix runtime","log.target":"actix_server::server","log.module_path":"actix_server::server","log.file":"/usr/local/cargo/registry/src/github.com-1ecc6299db9ec823/actix-server-2.0.0/src/server.rs","log.line":194} | |
| ingest_1 | {"level":2,"time":1665667102578,"ns":"sqd:substrate-ingest","msg":"connected to postgres://db:5432/squid-archive"} | |
| ingest_1 | {"level":2,"time":1665667102579,"ns":"sqd:substrate-ingest","msg":"Loading migrations from: /squid/substrate-ingest/migrations"} | |
| ingest_1 | {"level":2,"time":1665667102583,"ns":"sqd:substrate-ingest","msg":"Found migration files: 001-initial.sql,002-ethereum-transaction.sql,003-add-evm-log.sql"} | |
| ingest_1 | {"level":2,"time":1665667102588,"ns":"sqd:substrate-ingest","msg":"Acquiring advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667102593,"ns":"sqd:substrate-ingest","msg":"... acquired advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667102593,"ns":"sqd:substrate-ingest","msg":"Starting migrations"} | |
| ingest_1 | {"level":2,"time":1665667102599,"ns":"sqd:substrate-ingest","msg":"Migrations table with name 'migrations' hasn't been created,\nso the database is new and we need to run all migrations."} | |
| ingest_1 | {"level":2,"time":1665667102600,"ns":"sqd:substrate-ingest","msg":"Starting migration: 0 create-migrations-table"} | |
| ingest_1 | {"level":2,"time":1665667102601,"ns":"sqd:substrate-ingest","msg":"Running migration in transaction: true"} | |
| ingest_1 | {"level":2,"time":1665667102625,"ns":"sqd:substrate-ingest","msg":"Saving migration to 'migrations': 0 | create-migrations-table | e18db593bcde2aca2a408c4d1100f6abba2195df"} | |
| ingest_1 | {"level":2,"time":1665667102631,"ns":"sqd:substrate-ingest","msg":"Finished migration: 0 create-migrations-table"} | |
| ingest_1 | {"level":2,"time":1665667102632,"ns":"sqd:substrate-ingest","msg":"Starting migration: 1 initial"} | |
| ingest_1 | {"level":2,"time":1665667102632,"ns":"sqd:substrate-ingest","msg":"Running migration in transaction: true"} | |
| ingest_1 | {"level":2,"time":1665667102841,"ns":"sqd:substrate-ingest","msg":"Saving migration to 'migrations': 1 | initial | 8183a6f86c998ef902deb5e57573659dad782d13"} | |
| ingest_1 | {"level":2,"time":1665667102847,"ns":"sqd:substrate-ingest","msg":"Finished migration: 1 initial"} | |
| ingest_1 | {"level":2,"time":1665667102847,"ns":"sqd:substrate-ingest","msg":"Starting migration: 2 ethereum-transaction"} | |
| ingest_1 | {"level":2,"time":1665667102847,"ns":"sqd:substrate-ingest","msg":"Running migration in transaction: true"} | |
| ingest_1 | {"level":2,"time":1665667102869,"ns":"sqd:substrate-ingest","msg":"Saving migration to 'migrations': 2 | ethereum-transaction | 98e656009752fba18ddc2d2f97e4ee3089ce24d7"} | |
| ingest_1 | {"level":2,"time":1665667102873,"ns":"sqd:substrate-ingest","msg":"Finished migration: 2 ethereum-transaction"} | |
| ingest_1 | {"level":2,"time":1665667102873,"ns":"sqd:substrate-ingest","msg":"Starting migration: 3 add-evm-log"} | |
| ingest_1 | {"level":2,"time":1665667102873,"ns":"sqd:substrate-ingest","msg":"Running migration in transaction: true"} | |
| ingest_1 | {"level":2,"time":1665667102979,"ns":"sqd:substrate-ingest","msg":"Saving migration to 'migrations': 3 | add-evm-log | a28b86d7ba2ab8fce98195dc565c7c17e2f0d563"} | |
| ingest_1 | {"level":2,"time":1665667102982,"ns":"sqd:substrate-ingest","msg":"Finished migration: 3 add-evm-log"} | |
| ingest_1 | {"level":2,"time":1665667102983,"ns":"sqd:substrate-ingest","msg":"Successfully applied migrations: create-migrations-table,initial,ethereum-transaction,add-evm-log"} | |
| ingest_1 | {"level":2,"time":1665667102983,"ns":"sqd:substrate-ingest","msg":"Finished migrations"} | |
| ingest_1 | {"level":2,"time":1665667102983,"ns":"sqd:substrate-ingest","msg":"Releasing advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667102984,"ns":"sqd:substrate-ingest","msg":"... released advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667102985,"ns":"sqd:substrate-ingest","msg":"starting from block 0"} | |
| ingest_1 | {"level":2,"time":1665667103035,"ns":"sqd:substrate-ingest","msg":"prometheus server is listening on port 9090"} | |
| ingest_1 | {"level":2,"time":1665667103163,"ns":"sqd:substrate-ingest","msg":"chain height is 530863"} | |
| ingest_1 | {"level":2,"time":1665667130562,"ns":"sqd:substrate-ingest","msg":"last block: 19, progress: 1 blocks/sec, write: 2 blocks/sec"} | |
| ingest_1 | {"level":2,"time":1665667157459,"ns":"sqd:substrate-ingest","msg":"last block: 39, progress: 1 blocks/sec, write: 1 blocks/sec"} | |
| ingest_1 | {"level":2,"time":1665667167201,"ns":"sqd:substrate-ingest","msg":"connected to postgres://db:5432/squid-archive"} | |
| ingest_1 | {"level":2,"time":1665667167217,"ns":"sqd:substrate-ingest","msg":"Loading migrations from: /squid/substrate-ingest/migrations"} | |
| ingest_1 | {"level":2,"time":1665667167246,"ns":"sqd:substrate-ingest","msg":"Found migration files: 001-initial.sql,002-ethereum-transaction.sql,003-add-evm-log.sql"} | |
| ingest_1 | {"level":2,"time":1665667167264,"ns":"sqd:substrate-ingest","msg":"Acquiring advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667167282,"ns":"sqd:substrate-ingest","msg":"... acquired advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667167283,"ns":"sqd:substrate-ingest","msg":"Starting migrations"} | |
| ingest_1 | {"level":2,"time":1665667167317,"ns":"sqd:substrate-ingest","msg":"Migrations table with name 'migrations' exists, filtering not applied migrations."} | |
| ingest_1 | {"level":2,"time":1665667167338,"ns":"sqd:substrate-ingest","msg":"No migrations applied"} | |
| ingest_1 | {"level":2,"time":1665667167338,"ns":"sqd:substrate-ingest","msg":"Finished migrations"} | |
| ingest_1 | {"level":2,"time":1665667167339,"ns":"sqd:substrate-ingest","msg":"Releasing advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667167355,"ns":"sqd:substrate-ingest","msg":"... released advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667167374,"ns":"sqd:substrate-ingest","msg":"continuing from block 40"} | |
| ingest_1 | {"level":2,"time":1665667167441,"ns":"sqd:substrate-ingest","msg":"prometheus server is listening on port 9090"} | |
| ingest_1 | {"level":2,"time":1665667167616,"ns":"sqd:substrate-ingest","msg":"chain height is 530874"} | |
| db_1 | 2022-10-13 13:19:37.257 UTC [82] LOG: could not send data to client: Broken pipe | |
| db_1 | 2022-10-13 13:19:37.273 UTC [82] FATAL: connection to client lost | |
| subsquid-subspace_ingest_1 exited with code 137 | |
| ingest_1 | {"level":2,"time":1665667196257,"ns":"sqd:substrate-ingest","msg":"connected to postgres://db:5432/squid-archive"} | |
| ingest_1 | {"level":2,"time":1665667196259,"ns":"sqd:substrate-ingest","msg":"Loading migrations from: /squid/substrate-ingest/migrations"} | |
| ingest_1 | {"level":2,"time":1665667196262,"ns":"sqd:substrate-ingest","msg":"Found migration files: 001-initial.sql,002-ethereum-transaction.sql,003-add-evm-log.sql"} | |
| ingest_1 | {"level":2,"time":1665667196268,"ns":"sqd:substrate-ingest","msg":"Acquiring advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667196284,"ns":"sqd:substrate-ingest","msg":"... acquired advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667196285,"ns":"sqd:substrate-ingest","msg":"Starting migrations"} | |
| ingest_1 | {"level":2,"time":1665667196327,"ns":"sqd:substrate-ingest","msg":"Migrations table with name 'migrations' exists, filtering not applied migrations."} | |
| ingest_1 | {"level":2,"time":1665667196348,"ns":"sqd:substrate-ingest","msg":"No migrations applied"} | |
| ingest_1 | {"level":2,"time":1665667196349,"ns":"sqd:substrate-ingest","msg":"Finished migrations"} | |
| ingest_1 | {"level":2,"time":1665667196350,"ns":"sqd:substrate-ingest","msg":"Releasing advisory lock..."} | |
| ingest_1 | {"level":2,"time":1665667196353,"ns":"sqd:substrate-ingest","msg":"... released advisory lock"} | |
| ingest_1 | {"level":2,"time":1665667196363,"ns":"sqd:substrate-ingest","msg":"continuing from block 40"} | |
| ingest_1 | {"level":2,"time":1665667196428,"ns":"sqd:substrate-ingest","msg":"prometheus server is listening on port 9090"} | |
| ingest_1 | {"level":2,"time":1665667196568,"ns":"sqd:substrate-ingest","msg":"chain height is 530879"} | |
| db_1 | 2022-10-13 13:20:06.257 UTC [85] LOG: could not send data to client: Broken pipe | |
| db_1 | 2022-10-13 13:20:06.259 UTC [85] FATAL: connection to client lost | |
| ingest_1 | {"level":2,"time":1665667243161,"ns":"sqd:substrate-ingest","msg":"last block: 59, progress: 0 blocks/sec, write: 1 blocks/sec"} | |
| subsquid-subspace_ingest_1 exited with code 137 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment