Skip to content

Instantly share code, notes, and snippets.

@Harkishen-Singh

Harkishen-Singh/normal-ci-timescaledb-1.log

Created September 7, 2021 07:52
Show Gist options
  • Save Harkishen-Singh/cad36a79341a07b8684093ea2604a063 to your computer and use it in GitHub Desktop.
Save Harkishen-Singh/cad36a79341a07b8684093ea2604a063 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
normal-ci-timescaledb-1.log
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
2021-09-07 07:44:16.796 UTC [30] WARNING: no usable system locales were found
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start
waiting for server to start....AN 2021-09-07 07:44:17.326 UTC []LOG: starting PostgreSQL 13.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
AN 2021-09-07 07:44:17.329 UTC []LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
AN 2021-09-07 07:44:17.336 UTC []LOG: database system was shut down at 2021-09-07 07:44:17 UTC
AN 2021-09-07 07:44:17.343 UTC []LOG: database system is ready to accept connections
AN 2021-09-07 07:44:17.346 UTC []LOG: TimescaleDB background worker is set to 0
AN 2021-09-07 07:44:17.346 UTC []HINT: TimescaleDB background worker launcher shutting down.
done
server started
/usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/000_install_timescaledb.sh
psql:/tmp/tmp.pKljHG:1: WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:17.799 UTC [postgres]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:17.799 UTC [postgres]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
CREATE EXTENSION
AN 2021-09-07 07:44:18.135 UTC [template1]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:18.135 UTC [template1]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
psql:/tmp/tmp.pKljHG:1: WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
CREATE EXTENSION
/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/001_timescaledb_tune.sh
Using postgresql.conf at this path:
/var/lib/postgresql/data/postgresql.conf
shared_buffers = 4961MB
effective_cache_size = 14884MB
maintenance_work_mem = 2047MB
work_mem = 6350kB
timescaledb.max_background_workers = 8
max_worker_processes = 19
max_parallel_workers_per_gather = 4
max_parallel_workers = 8
wal_buffers = 16MB
min_wal_size = 512MB
default_statistics_target = 500
random_page_cost = 1.1
checkpoint_completion_target = 0.9
max_locks_per_transaction = 256
autovacuum_max_workers = 10
autovacuum_naptime = 10
effective_io_concurrency = 256
timescaledb.last_tuned = '2021-09-07T07:44:18Z'
timescaledb.last_tuned_version = '0.11.0'
Writing backup to:
/tmp/timescaledb_tune.backup202109070744
Recommendations based on 19.38 GB of available memory and 8 CPUs for PostgreSQL 13
Saving changes to: /var/lib/postgresql/data/postgresql.conf
waiting for server to shut down....AN 2021-09-07 07:44:18.152 UTC []LOG: received fast shutdown request
AN 2021-09-07 07:44:18.154 UTC []LOG: aborting any active transactions
AN 2021-09-07 07:44:18.154 UTC []FATAL: terminating autovacuum process due to administrator command
AN 2021-09-07 07:44:18.155 UTC []LOG: background worker "logical replication launcher" (PID 43) exited with exit code 1
AN 2021-09-07 07:44:18.155 UTC []LOG: shutting down
AN 2021-09-07 07:44:18.213 UTC []LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
AN 2021-09-07 07:44:18.315 UTC []LOG: starting PostgreSQL 13.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
AN 2021-09-07 07:44:18.315 UTC []LOG: listening on IPv4 address "0.0.0.0", port 5432
AN 2021-09-07 07:44:18.315 UTC []LOG: listening on IPv6 address "::", port 5432
AN 2021-09-07 07:44:18.319 UTC []LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
AN 2021-09-07 07:44:18.325 UTC []LOG: database system was shut down at 2021-09-07 07:44:18 UTC
AN 2021-09-07 07:44:18.332 UTC []LOG: database system is ready to accept connections
AN 2021-09-07 07:44:18.333 UTC []LOG: TimescaleDB background worker is set to 0
AN 2021-09-07 07:44:18.333 UTC []HINT: TimescaleDB background worker launcher shutting down.
AN 2021-09-07 07:44:20.100 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:20.100 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:44:20.381 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:20.381 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:20.381 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:20.381 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:22.441 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 17546 will be stopped
AN 2021-09-07 07:44:22.441 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:44:23.190 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:23.190 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:44:23.526 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:23.526 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:23.526 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:23.526 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:26.760 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 19884 will be stopped
AN 2021-09-07 07:44:26.760 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:44:27.603 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.4.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
AN 2021-09-07 07:44:27.603 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:44:28.099 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:28.099 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:28.099 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:44:28.099 UTC [tmp_db_timescale_migrate_test]STATEMENT: INSERT INTO _timescaledb_catalog.metadata(key, value, include_in_telemetry) VALUES ('promscale_' || $1, $2, $3) ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, include_in_telemetry = EXCLUDED.include_in_telemetry
AN 2021-09-07 07:44:28.840 UTC [tmp_db_timescale_migrate_test]ERROR: column "nonexistant" does not exist at character 240
AN 2021-09-07 07:44:28.840 UTC [tmp_db_timescale_migrate_test]STATEMENT: SELECT series.labels, result.time_array, result.value_array
FROM "prom_data_series"."metric_2" series
INNER JOIN (
SELECT series_id, array_agg(time) as time_array, array_agg(value) as value_array
FROM
(
SELECT series_id, time, "nonexistant" as value
FROM "cagg_schema"."cagg" metric
WHERE
time >= '2019-12-31T23:55:00Z'
AND time <= '2020-01-01T13:53:20Z'
ORDER BY series_id, time
) as time_ordered_rows
GROUP BY series_id
) as result ON (result.value_array is not null AND result.series_id = series.id)
AN 2021-09-07 07:44:28.978 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 22481 will be stopped
AN 2021-09-07 07:44:28.978 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment