Skip to content

Instantly share code, notes, and snippets.

@Harkishen-Singh

Harkishen-Singh/log-nighty-timescaledb.log

Created September 7, 2021 07:54
Show Gist options
  • Save Harkishen-Singh/d083a6cd0a63090028c1520cffe513bd to your computer and use it in GitHub Desktop.
Save Harkishen-Singh/d083a6cd0a63090028c1520cffe513bd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
log-nighty-timescaledb.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:45:50.822 UTC [30] WARNING: no usable system locales were found
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start
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.
waiting for server to start....AN 2021-09-07 07:45:51.376 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:45:51.378 UTC []LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
AN 2021-09-07 07:45:51.385 UTC []LOG: database system was shut down at 2021-09-07 07:45:51 UTC
AN 2021-09-07 07:45:51.393 UTC []LOG: database system is ready to accept connections
AN 2021-09-07 07:45:51.393 UTC []LOG: TimescaleDB background worker is set to 0
AN 2021-09-07 07:45:51.393 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
AN 2021-09-07 07:45:51.787 UTC [postgres]WARNING:
WELCOME TO
psql:/tmp/tmp.bAgLOC:1: WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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.
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:45:51.787 UTC [postgres]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
CREATE EXTENSION
AN 2021-09-07 07:45:52.232 UTC [template1]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:45:52.232 UTC [template1]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
psql:/tmp/tmp.bAgLOC:1: WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:45:52Z'
timescaledb.last_tuned_version = '0.11.0'
Writing backup to:
/tmp/timescaledb_tune.backup202109070745
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:45:52.256 UTC []LOG: received fast shutdown request
AN 2021-09-07 07:45:52.258 UTC []LOG: aborting any active transactions
AN 2021-09-07 07:45:52.258 UTC []FATAL: terminating autovacuum process due to administrator command
AN 2021-09-07 07:45:52.259 UTC []LOG: background worker "logical replication launcher" (PID 43) exited with exit code 1
AN 2021-09-07 07:45:52.260 UTC []LOG: shutting down
AN 2021-09-07 07:45:52.310 UTC []LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
AN 2021-09-07 07:45:52.509 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:45:52.509 UTC []LOG: listening on IPv4 address "0.0.0.0", port 5432
AN 2021-09-07 07:45:52.509 UTC []LOG: listening on IPv6 address "::", port 5432
AN 2021-09-07 07:45:52.514 UTC []LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
AN 2021-09-07 07:45:52.518 UTC []LOG: database system was shut down at 2021-09-07 07:45:52 UTC
AN 2021-09-07 07:45:52.519 UTC [postgres]FATAL: the database system is starting up
AN 2021-09-07 07:45:52.525 UTC []LOG: database system is ready to accept connections
AN 2021-09-07 07:45:52.526 UTC []LOG: TimescaleDB background worker is set to 0
AN 2021-09-07 07:45:52.526 UTC []HINT: TimescaleDB background worker launcher shutting down.
AN 2021-09-07 07:45:54.409 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:45:54.409 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:45:54.668 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:45:54.668 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:45:54.669 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:45:54.669 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:45:56.530 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 17546 will be stopped
AN 2021-09-07 07:45:56.530 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:45:57.120 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:45:57.120 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:45:57.367 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:45:57.367 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:45:57.367 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:45:57.367 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:46:00.287 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 19884 will be stopped
AN 2021-09-07 07:46:00.287 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:46:00.891 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:46:00.891 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:46:01.174 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:01.174 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:46:01.174 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:01.174 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:46:01.717 UTC [tmp_db_timescale_migrate_test]ERROR: column "nonexistant" does not exist at character 240
AN 2021-09-07 07:46:01.717 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:46:01.806 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 22481 will be stopped
AN 2021-09-07 07:46:01.806 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:46:02.385 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:46:02.385 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:46:02.697 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:02.697 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:46:02.698 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:02.698 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:46:03.029 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: starting
AN 2021-09-07 07:46:03.029 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 7 at RAISE
AN 2021-09-07 07:46:03.029 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.057 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: starting
AN 2021-09-07 07:46:03.057 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 26 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.057 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.074 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done marking unused series in 00:00:00.008918
AN 2021-09-07 07:46:03.074 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 75 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.074 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.084 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done dropping chunks in 00:00:00.008204
AN 2021-09-07 07:46:03.084 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 84 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.084 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done deleting expired series in 00:00:00.00286
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 96 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: finished in 00:00:00.036424
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 97 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.093 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.095 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric test: starting
AN 2021-09-07 07:46:03.095 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 26 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.095 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.099 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric test: done marking unused series in 00:00:00.002973
AN 2021-09-07 07:46:03.099 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 75 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.099 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.102 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric test: done dropping chunks in 00:00:00.002436
AN 2021-09-07 07:46:03.102 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 84 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.102 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric test: done deleting expired series in 00:00:00.000167
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 96 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric test: finished in 00:00:00.012701
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 97 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: starting
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 15 at RAISE
AN 2021-09-07 07:46:03.108 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.112 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: metric test: starting, without lock wait
AN 2021-09-07 07:46:03.112 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_compression_policy(boolean) line 23 at RAISE
SQL statement "CALL _prom_catalog.execute_compression_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 19 at CALL
AN 2021-09-07 07:46:03.112 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: metric test: finished in 00:00:00.005895
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_compression_policy(boolean) line 28 at RAISE
SQL statement "CALL _prom_catalog.execute_compression_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 19 at CALL
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: finished in 00:00:00.089504
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 23 at RAISE
AN 2021-09-07 07:46:03.118 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.126 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: starting
AN 2021-09-07 07:46:03.126 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 7 at RAISE
AN 2021-09-07 07:46:03.126 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.138 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: starting
AN 2021-09-07 07:46:03.138 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 26 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.138 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.143 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done marking unused series in 00:00:00.003537
AN 2021-09-07 07:46:03.143 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 75 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.143 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.150 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done dropping chunks in 00:00:00.006191
AN 2021-09-07 07:46:03.150 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 84 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.150 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: done deleting expired series in 00:00:00.000141
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 96 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: data retention: metric cagg: finished in 00:00:00.017915
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function drop_metric_chunks(text,text,timestamp with time zone,timestamp with time zone,boolean) line 97 at RAISE
SQL statement "CALL _prom_catalog.drop_metric_chunks(r.table_schema, r.metric_name, NOW() - _prom_catalog.get_metric_retention_period(r.table_schema, r.metric_name), log_verbose=>log_verbose)"
PL/pgSQL function execute_data_retention_policy(boolean) line 19 at CALL
SQL statement "CALL _prom_catalog.execute_data_retention_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 11 at CALL
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: starting
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 15 at RAISE
AN 2021-09-07 07:46:03.156 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.158 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: metric test: starting, without lock wait
AN 2021-09-07 07:46:03.158 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_compression_policy(boolean) line 23 at RAISE
SQL statement "CALL _prom_catalog.execute_compression_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 19 at CALL
AN 2021-09-07 07:46:03.158 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.161 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: compression: metric test: finished in 00:00:00.003842
AN 2021-09-07 07:46:03.161 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_compression_policy(boolean) line 28 at RAISE
SQL statement "CALL _prom_catalog.execute_compression_policy(log_verbose=>log_verbose)"
PL/pgSQL function execute_maintenance(boolean) line 19 at CALL
AN 2021-09-07 07:46:03.161 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.162 UTC [tmp_db_timescale_migrate_test]LOG: promscale maintenance: finished in 00:00:00.035807
AN 2021-09-07 07:46:03.162 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function execute_maintenance(boolean) line 23 at RAISE
AN 2021-09-07 07:46:03.162 UTC [tmp_db_timescale_migrate_test]STATEMENT: CALL prom_api.execute_maintenance(log_verbose=>true)
AN 2021-09-07 07:46:03.173 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 23626 will be stopped
AN 2021-09-07 07:46:03.173 UTC [postgres]STATEMENT: DROP DATABASE IF EXISTS tmp_db_timescale_migrate_test
AN 2021-09-07 07:46:04.153 UTC [tmp_db_timescale_migrate_test]WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.0-dev
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:46:04.153 UTC [tmp_db_timescale_migrate_test]CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
AN 2021-09-07 07:46:04.673 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:04.673 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:46:04.673 UTC [tmp_db_timescale_migrate_test]ERROR: permission denied for table metadata
AN 2021-09-07 07:46:04.673 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:46:04.974 UTC [postgres]LOG: TimescaleDB background worker scheduler for database 24664 will be stopped
AN 2021-09-07 07:46:04.974 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