| 1 | 2024-11-08T02:16:43.127Z | DEBG | test_cluster (clickhouse-client): registered USDT probes
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 2 | 2024-11-08T02:16:43.189Z | DEBG | test_cluster (clickhouse-client): registered USDT probes
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
|
| 3 | 2024-11-08T02:16:43.193Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 4 | 2024-11-08T02:16:43.194Z | TRAC | test_cluster (clickhouse-client): successful ping of ClickHouse server
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 5 | 2024-11-08T02:16:43.194Z | INFO | test_cluster: Clickhouse server ready: http://[::1]:19301
|
| 6 | 2024-11-08T02:16:43.196Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
|
| 7 | 2024-11-08T02:16:43.196Z | TRAC | test_cluster (clickhouse-client): successful ping of ClickHouse server
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
|
| 8 | 2024-11-08T02:16:43.197Z | INFO | test_cluster: Clickhouse server ready: http://[::1]:19302
|
| 9 | 2024-11-08T02:16:43.359Z | DEBG | test_cluster: Keeper connection error: query error: query = get /keeper/config, error = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
addr = [::1]:19001
|
| 10 | 2024-11-08T02:16:43.493Z | DEBG | test_cluster: Keeper connection error: query error: query = get /keeper/config, error = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
addr = [::1]:19001
|
| 11 | 2024-11-08T02:16:43.637Z | DEBG | test_cluster: Keeper connection error: query error: query = get /keeper/config, error = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
addr = [::1]:19001
|
| 12 | 2024-11-08T02:16:44.195Z | DEBG | test_cluster: Keeper connection error: query error: query = get /keeper/config, error = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
addr = [::1]:19001
|
| 13 | 2024-11-08T02:16:44.333Z | DEBG | test_cluster: Keeper connection error: query error: query = get /keeper/config, error = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
Poco::Exception. Code: 1000, e.code() = 146, Connection refused: [::1]:19001 (version 23.8.7.1), [::1]:19001
addr = [::1]:19001
|
| 14 | 2024-11-08T02:16:44.603Z | INFO | test_cluster: Keepers ready: [KeeperId(1), KeeperId(2), KeeperId(3)]
|
| 15 | 2024-11-08T02:16:44.603Z | INFO | test_cluster: deploy setup time = 1.981507121s
|
| 16 | 2024-11-08T02:16:44.603Z | DEBG | test_cluster (clickhouse-client): initializing ClickHouse database
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 17 | 2024-11-08T02:16:44.603Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = /* We purposefully split our DB schema into two *disjoint* files:\n * `db-init-1.sql` and `db-init-2.sql`. The purpose of this split is to shorten\n * the duration of our replicated tests. These tests only use a subset of the\n * tables defined in the full schema. We put the tables used by the replicated\n * tests in `db-init-1.sql`, and the remainder of the tables in `db-init-2.sql`.\n * This minimizes test time by reducing the cost to load a schema. In\n * production, we load `db-init-1.sql` followed by `db-init-2.sql` so we have\n * the full schema. If we end up needing to use more tables in replicated tests\n * we can go ahead and move them into `db-init-1.sql`, removing them from\n * `db-init-2.sql`. Conversely, if we stop using given tables in our tests we\n * can move them from `db-init-1.sql` into `db-init-2.sql` and keep our test\n * times minimal.\n\n * The reason to keep the two files disjoint is so that we don't have to\n * maintain consistency between table definitions. All tables are defined\n * once. However, in order to write a test that ensures the tables are in fact\n * disjoint, we must create the `oximeter` database in both files so we can load\n * them in isolation.\n */\n\nCREATE DATABASE IF NOT EXISTS oximeter ON CLUSTER oximeter_cluster
|
| 18 | 2024-11-08T02:16:48.484Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\n/* The version table contains metadata about the `oximeter` database */\nCREATE TABLE IF NOT EXISTS oximeter.version ON CLUSTER oximeter_cluster\n(\n value UInt64,\n timestamp DateTime64(9, 'UTC')\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/version', '{replica}')\nORDER BY (value, timestamp)
|
| 19 | 2024-11-08T02:16:48.599Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\n/* The measurement tables contain all individual samples from each timeseries.\n *\n * Each table stores a single datum type, and otherwise contains nearly the same\n * structure. The primary sorting key is on the timeseries name, key, and then\n * timestamp, so that all timeseries from the same schema are grouped, followed\n * by all samples from the same timeseries.\n *\n * This reflects that one usually looks up the _key_ in one or more field table,\n * and then uses that to index quickly into the measurements tables.\n */\n\nCREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n start_time DateTime64(9, 'UTC'),\n timestamp DateTime64(9, 'UTC'),\n datum Nullable(Float64)\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/measurements_cumulativef64_local', '{replica}')\nORDER BY (timeseries_name, timeseries_key, start_time, timestamp)\nTTL toDateTime(timestamp) + INTERVAL 30 DAY
|
| 20 | 2024-11-08T02:16:48.710Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ON CLUSTER oximeter_cluster\nAS oximeter.measurements_cumulativef64_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'measurements_cumulativef64_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 21 | 2024-11-08T02:16:48.821Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\n/* The field tables store named dimensions of each timeseries.\n *\n * As with the measurement tables, there is one field table for each field data\n * type. Fields are deduplicated by using the "replacing merge tree", though\n * this behavior **must not** be relied upon for query correctness.\n *\n * The index for the fields differs from the measurements, however. Rows are\n * sorted by timeseries name, then field name, field value, and finally\n * timeseries key. This reflects the most common pattern for looking them up:\n * by field name and possibly value, within a timeseries. The resulting keys are\n * usually then used to look up measurements.\n *\n * NOTE: We may want to consider a secondary index on these tables, sorting by\n * timeseries name and then key, since it would improve lookups where one\n * already has the key. Realistically though, these tables are quite small and\n * so performance benefits will be low in absolute terms.\n */\nCREATE TABLE IF NOT EXISTS oximeter.fields_i64_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n field_name String,\n field_value Int64,\n last_updated_at DateTime MATERIALIZED now()\n)\nENGINE = ReplicatedReplacingMergeTree('/clickhouse/tables/{shard}/fields_i64_local', '{replica}')\nORDER BY (timeseries_name, field_name, field_value, timeseries_key)\nTTL last_updated_at + INTERVAL 30 DAY
|
| 22 | 2024-11-08T02:16:48.932Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.fields_i64 ON CLUSTER oximeter_cluster\nAS oximeter.fields_i64_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'fields_i64_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 23 | 2024-11-08T02:16:49.044Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\n\nCREATE TABLE IF NOT EXISTS oximeter.fields_uuid_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n field_name String,\n field_value UUID,\n last_updated_at DateTime MATERIALIZED now()\n)\nENGINE = ReplicatedReplacingMergeTree('/clickhouse/tables/{shard}/fields_uuid_local', '{replica}')\nORDER BY (timeseries_name, field_name, field_value, timeseries_key)\nTTL last_updated_at + INTERVAL 30 DAY
|
| 24 | 2024-11-08T02:16:49.315Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.fields_uuid ON CLUSTER oximeter_cluster\nAS oximeter.fields_uuid_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'fields_uuid_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 25 | 2024-11-08T02:16:49.428Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\n/* The timeseries schema table stores the extracted schema for the samples\n * oximeter collects.\n */\nCREATE TABLE IF NOT EXISTS oximeter.timeseries_schema_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n fields Nested(\n name String,\n type Enum(\n 'Bool' = 1,\n 'I64' = 2,\n 'IpAddr' = 3,\n 'String' = 4,\n 'Uuid' = 6,\n 'I8' = 7,\n 'U8' = 8,\n 'I16' = 9,\n 'U16' = 10,\n 'I32' = 11,\n 'U32' = 12,\n 'U64' = 13\n ),\n source Enum(\n 'Target' = 1,\n 'Metric' = 2\n )\n ),\n datum_type Enum(\n 'Bool' = 1,\n 'I64' = 2,\n 'F64' = 3,\n 'String' = 4,\n 'Bytes' = 5,\n 'CumulativeI64' = 6,\n 'CumulativeF64' = 7,\n 'HistogramI64' = 8,\n 'HistogramF64' = 9,\n 'I8' = 10,\n 'U8' = 11,\n 'I16' = 12,\n 'U16' = 13,\n 'I32' = 14,\n 'U32' = 15,\n 'U64' = 16,\n 'F32' = 17,\n 'CumulativeU64' = 18,\n 'CumulativeF32' = 19,\n 'HistogramI8' = 20,\n 'HistogramU8' = 21,\n 'HistogramI16' = 22,\n 'HistogramU16' = 23,\n 'HistogramI32' = 24,\n 'HistogramU32' = 25,\n 'HistogramU64' = 26,\n 'HistogramF32' = 27\n ),\n created DateTime64(9, 'UTC')\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/timeseries_schema_local', '{replica}')\nORDER BY (timeseries_name, fields.name)
|
| 26 | 2024-11-08T02:16:49.594Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ON CLUSTER oximeter_cluster\nAS oximeter.timeseries_schema_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'timeseries_schema_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 27 | 2024-11-08T02:16:49.711Z | INFO | test_cluster: init replicated db time = 5.108305171s
|
| 28 | 2024-11-08T02:16:49.711Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT name FROM system.tables WHERE database = 'oximeter' AND engine = 'ReplicatedMergeTree'
|
| 29 | 2024-11-08T02:16:49.717Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT name FROM system.tables WHERE database = 'oximeter' AND engine = 'ReplicatedMergeTree'
|
| 30 | 2024-11-08T02:16:49.722Z | INFO | test_cluster: list tables time = 11.651997ms
|
| 31 | 2024-11-08T02:16:50.029Z | INFO | test_cluster: generate samples time = 306.564066ms
|
| 32 | 2024-11-08T02:16:50.029Z | DEBG | test_cluster (clickhouse-client): unrolling 400 total samples
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 33 | 2024-11-08T02:16:50.030Z | DEBG | test_cluster (clickhouse-client): retrieving timeseries schema from database
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 34 | 2024-11-08T02:16:50.030Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT * FROM oximeter.timeseries_schema FORMAT Native;
|
| 35 | 2024-11-08T02:16:50.034Z | TRAC | test_cluster (clickhouse-client): no new timeseries schema in database
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 36 | 2024-11-08T02:16:50.034Z | DEBG | test_cluster (clickhouse-client): new timeseries schema
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
schema = TimeseriesSchema { timeseries_name: TimeseriesName("virtual_machine:cpu_busy"), description: TimeseriesDescription { target: "", metric: "" }, field_schema: {FieldSchema { name: "cpu_id", field_type: I64, source: Metric, description: "" }, FieldSchema { name: "instance_id", field_type: Uuid, source: Target, description: "" }, FieldSchema { name: "project_id", field_type: Uuid, source: Target, description: "" }}, datum_type: CumulativeF64, version: 1, authz_scope: Fleet, units: Count, created: 2024-11-08T02:16:50.030808143Z }
timeseries_name = virtual_machine:cpu_busy
|
| 37 | 2024-11-08T02:16:50.323Z | DEBG | test_cluster (clickhouse-client): inserting 1 new timeseries schema
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 38 | 2024-11-08T02:16:50.323Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = INSERT INTO oximeter.timeseries_schema FORMAT Native
|
| 39 | 2024-11-08T02:16:50.339Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = INSERT INTO oximeter.fields_i64 FORMAT Native
|
| 40 | 2024-11-08T02:16:50.357Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_rows = 8
table_name = fields_i64
|
| 41 | 2024-11-08T02:16:50.357Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = INSERT INTO oximeter.fields_uuid FORMAT Native
|
| 42 | 2024-11-08T02:16:50.383Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_rows = 16
table_name = fields_uuid
|
| 43 | 2024-11-08T02:16:50.383Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = INSERT INTO oximeter.measurements_cumulativef64 FORMAT Native
|
| 44 | 2024-11-08T02:16:50.401Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_rows = 400
table_name = measurements_cumulativef64
|
| 45 | 2024-11-08T02:16:50.401Z | INFO | test_cluster: insert samples time = 371.808394ms
|
| 46 | 2024-11-08T02:16:50.407Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:50.407249472Z }
query = get virtual_machine:cpu_busy
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 47 | 2024-11-08T02:16:50.407Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:50.407249472Z }
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
timeseries_name = virtual_machine:cpu_busy
|
| 48 | 2024-11-08T02:16:50.407Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_predicates = None
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 49 | 2024-11-08T02:16:50.407Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_limit = None
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 50 | 2024-11-08T02:16:50.407Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
predicate = none
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 51 | 2024-11-08T02:16:50.407Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 52 | 2024-11-08T02:16:50.438Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 8
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 53 | 2024-11-08T02:16:50.439Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (9086034282846337169,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14987834724041522457,16304705339519466401,17356848348641513518)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 54 | 2024-11-08T02:16:50.458Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 8
n_measurements = 400
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 55 | 2024-11-08T02:16:50.458Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
limit = 1000000
n_new_measurements = 400
n_total = 400
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 56 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 57 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 58 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 59 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 60 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 61 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 62 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 63 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 64 | 2024-11-08T02:16:50.459Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_timeseries = 8
n_transformations = 0
query_id = 972dcf7c-fcc9-4d9e-b3d7-a101fe9ccf7b
|
| 65 | 2024-11-08T02:16:50.459Z | INFO | test_cluster: query samples from client1 time = 58.514798ms
|
| 66 | 2024-11-08T02:16:50.462Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:50.461956803Z }
query = get virtual_machine:cpu_busy
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 67 | 2024-11-08T02:16:50.462Z | DEBG | test_cluster (clickhouse-client): retrieving timeseries schema from database
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
|
| 68 | 2024-11-08T02:16:50.462Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT * FROM oximeter.timeseries_schema FORMAT Native;
|
| 69 | 2024-11-08T02:16:50.468Z | TRAC | test_cluster (clickhouse-client): retrieved new timeseries schema
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_schema = 1
|
| 70 | 2024-11-08T02:16:50.469Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:50.461956803Z }
query_id = f34fc682-1122-48e2-a513-b94e00202be2
timeseries_name = virtual_machine:cpu_busy
|
| 71 | 2024-11-08T02:16:50.469Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_predicates = None
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 72 | 2024-11-08T02:16:50.469Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_limit = None
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 73 | 2024-11-08T02:16:50.469Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
predicate = none
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 74 | 2024-11-08T02:16:50.469Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 75 | 2024-11-08T02:16:50.494Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 8
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 76 | 2024-11-08T02:16:50.494Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (9086034282846337169,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14987834724041522457,16304705339519466401,17356848348641513518)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 77 | 2024-11-08T02:16:50.509Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 8
n_measurements = 400
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 78 | 2024-11-08T02:16:50.509Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
limit = 1000000
n_new_measurements = 400
n_total = 400
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 79 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 80 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 81 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 82 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 83 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 84 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 85 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 86 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 87 | 2024-11-08T02:16:50.510Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_timeseries = 8
n_transformations = 0
query_id = f34fc682-1122-48e2-a513-b94e00202be2
|
| 88 | 2024-11-08T02:16:50.510Z | INFO | test_cluster: query samples from client2 time = 49.203718ms
|
| 89 | 2024-11-08T02:16:50.586Z | DEBG | test_cluster (clickhouse-client): registered USDT probes
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 90 | 2024-11-08T02:16:50.977Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 91 | 2024-11-08T02:16:50.977Z | TRAC | test_cluster (clickhouse-client): successful ping of ClickHouse server
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 92 | 2024-11-08T02:16:50.977Z | INFO | test_cluster: Clickhouse server ready: http://[::1]:19303
|
| 93 | 2024-11-08T02:16:50.977Z | INFO | test_cluster: successfully pinged client server 3
|
| 94 | 2024-11-08T02:16:50.977Z | DEBG | test_cluster (clickhouse-client): initializing ClickHouse database
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 95 | 2024-11-08T02:16:50.977Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = /* We purposefully split our DB schema into two *disjoint* files:\n * `db-init-1.sql` and `db-init-2.sql`. The purpose of this split is to shorten\n * the duration of our replicated tests. These tests only use a subset of the\n * tables defined in the full schema. We put the tables used by the replicated\n * tests in `db-init-1.sql`, and the remainder of the tables in `db-init-2.sql`.\n * This minimizes test time by reducing the cost to load a schema. In\n * production, we load `db-init-1.sql` followed by `db-init-2.sql` so we have\n * the full schema. If we end up needing to use more tables in replicated tests\n * we can go ahead and move them into `db-init-1.sql`, removing them from\n * `db-init-2.sql`. Conversely, if we stop using given tables in our tests we\n * can move them from `db-init-1.sql` into `db-init-2.sql` and keep our test\n * times minimal.\n\n * The reason to keep the two files disjoint is so that we don't have to\n * maintain consistency between table definitions. All tables are defined\n * once. However, in order to write a test that ensures the tables are in fact\n * disjoint, we must create the `oximeter` database in both files so we can load\n * them in isolation.\n */\n\nCREATE DATABASE IF NOT EXISTS oximeter ON CLUSTER oximeter_cluster
|
| 96 | 2024-11-08T02:16:51.092Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\n/* The version table contains metadata about the `oximeter` database */\nCREATE TABLE IF NOT EXISTS oximeter.version ON CLUSTER oximeter_cluster\n(\n value UInt64,\n timestamp DateTime64(9, 'UTC')\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/version', '{replica}')\nORDER BY (value, timestamp)
|
| 97 | 2024-11-08T02:16:51.209Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\n/* The measurement tables contain all individual samples from each timeseries.\n *\n * Each table stores a single datum type, and otherwise contains nearly the same\n * structure. The primary sorting key is on the timeseries name, key, and then\n * timestamp, so that all timeseries from the same schema are grouped, followed\n * by all samples from the same timeseries.\n *\n * This reflects that one usually looks up the _key_ in one or more field table,\n * and then uses that to index quickly into the measurements tables.\n */\n\nCREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n start_time DateTime64(9, 'UTC'),\n timestamp DateTime64(9, 'UTC'),\n datum Nullable(Float64)\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/measurements_cumulativef64_local', '{replica}')\nORDER BY (timeseries_name, timeseries_key, start_time, timestamp)\nTTL toDateTime(timestamp) + INTERVAL 30 DAY
|
| 98 | 2024-11-08T02:16:51.326Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ON CLUSTER oximeter_cluster\nAS oximeter.measurements_cumulativef64_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'measurements_cumulativef64_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 99 | 2024-11-08T02:16:51.439Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\n/* The field tables store named dimensions of each timeseries.\n *\n * As with the measurement tables, there is one field table for each field data\n * type. Fields are deduplicated by using the "replacing merge tree", though\n * this behavior **must not** be relied upon for query correctness.\n *\n * The index for the fields differs from the measurements, however. Rows are\n * sorted by timeseries name, then field name, field value, and finally\n * timeseries key. This reflects the most common pattern for looking them up:\n * by field name and possibly value, within a timeseries. The resulting keys are\n * usually then used to look up measurements.\n *\n * NOTE: We may want to consider a secondary index on these tables, sorting by\n * timeseries name and then key, since it would improve lookups where one\n * already has the key. Realistically though, these tables are quite small and\n * so performance benefits will be low in absolute terms.\n */\nCREATE TABLE IF NOT EXISTS oximeter.fields_i64_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n field_name String,\n field_value Int64,\n last_updated_at DateTime MATERIALIZED now()\n)\nENGINE = ReplicatedReplacingMergeTree('/clickhouse/tables/{shard}/fields_i64_local', '{replica}')\nORDER BY (timeseries_name, field_name, field_value, timeseries_key)\nTTL last_updated_at + INTERVAL 30 DAY
|
| 100 | 2024-11-08T02:16:51.558Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.fields_i64 ON CLUSTER oximeter_cluster\nAS oximeter.fields_i64_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'fields_i64_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 101 | 2024-11-08T02:16:51.672Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\n\nCREATE TABLE IF NOT EXISTS oximeter.fields_uuid_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n timeseries_key UInt64,\n field_name String,\n field_value UUID,\n last_updated_at DateTime MATERIALIZED now()\n)\nENGINE = ReplicatedReplacingMergeTree('/clickhouse/tables/{shard}/fields_uuid_local', '{replica}')\nORDER BY (timeseries_name, field_name, field_value, timeseries_key)\nTTL last_updated_at + INTERVAL 30 DAY
|
| 102 | 2024-11-08T02:16:51.785Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.fields_uuid ON CLUSTER oximeter_cluster\nAS oximeter.fields_uuid_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'fields_uuid_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 103 | 2024-11-08T02:16:51.903Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\n/* The timeseries schema table stores the extracted schema for the samples\n * oximeter collects.\n */\nCREATE TABLE IF NOT EXISTS oximeter.timeseries_schema_local ON CLUSTER oximeter_cluster\n(\n timeseries_name String,\n fields Nested(\n name String,\n type Enum(\n 'Bool' = 1,\n 'I64' = 2,\n 'IpAddr' = 3,\n 'String' = 4,\n 'Uuid' = 6,\n 'I8' = 7,\n 'U8' = 8,\n 'I16' = 9,\n 'U16' = 10,\n 'I32' = 11,\n 'U32' = 12,\n 'U64' = 13\n ),\n source Enum(\n 'Target' = 1,\n 'Metric' = 2\n )\n ),\n datum_type Enum(\n 'Bool' = 1,\n 'I64' = 2,\n 'F64' = 3,\n 'String' = 4,\n 'Bytes' = 5,\n 'CumulativeI64' = 6,\n 'CumulativeF64' = 7,\n 'HistogramI64' = 8,\n 'HistogramF64' = 9,\n 'I8' = 10,\n 'U8' = 11,\n 'I16' = 12,\n 'U16' = 13,\n 'I32' = 14,\n 'U32' = 15,\n 'U64' = 16,\n 'F32' = 17,\n 'CumulativeU64' = 18,\n 'CumulativeF32' = 19,\n 'HistogramI8' = 20,\n 'HistogramU8' = 21,\n 'HistogramI16' = 22,\n 'HistogramU16' = 23,\n 'HistogramI32' = 24,\n 'HistogramU32' = 25,\n 'HistogramU64' = 26,\n 'HistogramF32' = 27\n ),\n created DateTime64(9, 'UTC')\n)\nENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/timeseries_schema_local', '{replica}')\nORDER BY (timeseries_name, fields.name)
|
| 104 | 2024-11-08T02:16:52.017Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = \n\nCREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ON CLUSTER oximeter_cluster\nAS oximeter.timeseries_schema_local\nENGINE = Distributed('oximeter_cluster', 'oximeter', 'timeseries_schema_local', xxHash64(splitByChar(':', timeseries_name)[1]))
|
| 105 | 2024-11-08T02:16:52.135Z | INFO | test_cluster: successfully pinged client server 3
|
| 106 | 2024-11-08T02:16:52.136Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.136621745Z }
query = get virtual_machine:cpu_busy
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 107 | 2024-11-08T02:16:52.136Z | DEBG | test_cluster (clickhouse-client): retrieving timeseries schema from database
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 108 | 2024-11-08T02:16:52.136Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT * FROM oximeter.timeseries_schema FORMAT Native;
|
| 109 | 2024-11-08T02:16:52.141Z | TRAC | test_cluster (clickhouse-client): retrieved new timeseries schema
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_schema = 1
|
| 110 | 2024-11-08T02:16:52.142Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.136621745Z }
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
timeseries_name = virtual_machine:cpu_busy
|
| 111 | 2024-11-08T02:16:52.142Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_predicates = None
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 112 | 2024-11-08T02:16:52.142Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_limit = None
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 113 | 2024-11-08T02:16:52.142Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
predicate = none
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 114 | 2024-11-08T02:16:52.142Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 115 | 2024-11-08T02:16:52.162Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 8
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 116 | 2024-11-08T02:16:52.162Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (9086034282846337169,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14987834724041522457,16304705339519466401,17356848348641513518)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 117 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 8
n_measurements = 400
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 118 | 2024-11-08T02:16:52.174Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
limit = 1000000
n_new_measurements = 400
n_total = 400
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 119 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 120 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 121 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 122 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 123 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 124 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 125 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 126 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 127 | 2024-11-08T02:16:52.174Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_timeseries = 8
n_transformations = 0
query_id = e3f8452e-a1e6-4038-adf5-b60c8d4da29d
|
| 128 | 2024-11-08T02:16:52.174Z | INFO | test_cluster: query samples from client3 time = 39.190177ms
|
| 129 | 2024-11-08T02:16:52.190Z | INFO | test_cluster: successfully stopped server 1
|
| 130 | 2024-11-08T02:16:52.445Z | DEBG | test_cluster (clickhouse-client): unrolling 400 total samples
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 131 | 2024-11-08T02:16:52.745Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.fields_i64 FORMAT Native
|
| 132 | 2024-11-08T02:16:52.756Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 8
table_name = fields_i64
|
| 133 | 2024-11-08T02:16:52.756Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.fields_uuid FORMAT Native
|
| 134 | 2024-11-08T02:16:52.775Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 16
table_name = fields_uuid
|
| 135 | 2024-11-08T02:16:52.776Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.measurements_cumulativef64 FORMAT Native
|
| 136 | 2024-11-08T02:16:52.797Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 400
table_name = measurements_cumulativef64
|
| 137 | 2024-11-08T02:16:52.798Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.798124078Z }
query = get virtual_machine:cpu_busy
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 138 | 2024-11-08T02:16:52.798Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.798124078Z }
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
timeseries_name = virtual_machine:cpu_busy
|
| 139 | 2024-11-08T02:16:52.798Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_predicates = None
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 140 | 2024-11-08T02:16:52.798Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_limit = None
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 141 | 2024-11-08T02:16:52.798Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
predicate = none
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 142 | 2024-11-08T02:16:52.798Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 143 | 2024-11-08T02:16:52.832Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 16
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 144 | 2024-11-08T02:16:52.832Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,9086034282846337169,10469210161859473187,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 145 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 16
n_measurements = 800
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 146 | 2024-11-08T02:16:52.860Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
limit = 1000000
n_new_measurements = 800
n_total = 800
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 147 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 148 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 149 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 150 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 151 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 152 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 153 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 154 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 155 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 156 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 157 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 158 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 159 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 160 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 161 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 162 | 2024-11-08T02:16:52.860Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 163 | 2024-11-08T02:16:52.861Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_timeseries = 16
n_transformations = 0
query_id = badc72d1-3516-4e3b-b594-bbd9508fac8f
|
| 164 | 2024-11-08T02:16:52.862Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.862058561Z }
query = get virtual_machine:cpu_busy
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 165 | 2024-11-08T02:16:52.862Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:52.862058561Z }
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
timeseries_name = virtual_machine:cpu_busy
|
| 166 | 2024-11-08T02:16:52.862Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_predicates = None
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 167 | 2024-11-08T02:16:52.862Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_limit = None
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 168 | 2024-11-08T02:16:52.862Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
predicate = none
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 169 | 2024-11-08T02:16:52.862Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 170 | 2024-11-08T02:16:52.889Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 16
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 171 | 2024-11-08T02:16:52.889Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,9086034282846337169,10469210161859473187,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 172 | 2024-11-08T02:16:52.922Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 16
n_measurements = 800
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 173 | 2024-11-08T02:16:52.922Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
limit = 1000000
n_new_measurements = 800
n_total = 800
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 174 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 175 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 176 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 177 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 178 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 179 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 180 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 181 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 182 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 183 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 184 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 185 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 186 | 2024-11-08T02:16:52.923Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 187 | 2024-11-08T02:16:52.924Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 188 | 2024-11-08T02:16:52.924Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 189 | 2024-11-08T02:16:52.924Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 190 | 2024-11-08T02:16:52.924Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_timeseries = 16
n_transformations = 0
query_id = 0be07b84-f00c-4705-bdf6-ffc19489e77b
|
| 191 | 2024-11-08T02:16:52.933Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 192 | 2024-11-08T02:16:53.034Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 193 | 2024-11-08T02:16:53.135Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 194 | 2024-11-08T02:16:53.237Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 195 | 2024-11-08T02:16:53.338Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 196 | 2024-11-08T02:16:53.439Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 197 | 2024-11-08T02:16:53.540Z | TRAC | test_cluster (clickhouse-client): acquired native pool claim
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 198 | 2024-11-08T02:16:53.544Z | TRAC | test_cluster (clickhouse-client): successful ping of ClickHouse server
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
|
| 199 | 2024-11-08T02:16:53.544Z | INFO | test_cluster: Clickhouse server ready: http://[::1]:19301
|
| 200 | 2024-11-08T02:16:53.546Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:53.545975753Z }
query = get virtual_machine:cpu_busy
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 201 | 2024-11-08T02:16:53.546Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:53.545975753Z }
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
timeseries_name = virtual_machine:cpu_busy
|
| 202 | 2024-11-08T02:16:53.546Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_predicates = None
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 203 | 2024-11-08T02:16:53.546Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_limit = None
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 204 | 2024-11-08T02:16:53.546Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
predicate = none
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 205 | 2024-11-08T02:16:53.546Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 206 | 2024-11-08T02:16:53.585Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 16
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 207 | 2024-11-08T02:16:53.585Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,9086034282846337169,10469210161859473187,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 208 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 16
n_measurements = 800
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 209 | 2024-11-08T02:16:53.615Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
limit = 1000000
n_new_measurements = 800
n_total = 800
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 210 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 211 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 212 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 213 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 214 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 215 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 216 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 217 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 218 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 219 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 220 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 221 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 222 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 223 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 224 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 225 | 2024-11-08T02:16:53.615Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 226 | 2024-11-08T02:16:53.616Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_timeseries = 16
n_transformations = 0
query_id = 6444adad-fb1b-4abb-8582-54846a04a025
|
| 227 | 2024-11-08T02:16:53.623Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:53.623728305Z }
query = get virtual_machine:cpu_busy
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 228 | 2024-11-08T02:16:53.624Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:53.623728305Z }
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
timeseries_name = virtual_machine:cpu_busy
|
| 229 | 2024-11-08T02:16:53.624Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_predicates = None
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 230 | 2024-11-08T02:16:53.624Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
outer_limit = None
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 231 | 2024-11-08T02:16:53.624Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
predicate = none
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 232 | 2024-11-08T02:16:53.624Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 233 | 2024-11-08T02:16:53.653Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 16
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 234 | 2024-11-08T02:16:53.653Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,9086034282846337169,10469210161859473187,11153000122486487041,11941584955560446211,12237444503174949912,12602581409702662812,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 235 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_keys = 16
n_measurements = 800
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 236 | 2024-11-08T02:16:53.678Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
limit = 1000000
n_new_measurements = 800
n_total = 800
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 237 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 238 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 239 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 240 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 241 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 242 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 243 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 244 | 2024-11-08T02:16:53.678Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 245 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 246 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 247 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 248 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 249 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 250 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 251 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 252 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 253 | 2024-11-08T02:16:53.679Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 489f8e4c-0aab-4fa9-9490-5358dae52913
n_timeseries = 16
n_transformations = 0
query_id = f7fdebbb-c716-4883-9818-02b48acfc503
|
| 254 | 2024-11-08T02:16:53.905Z | DEBG | test_cluster (clickhouse-client): unrolling 400 total samples
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
|
| 255 | 2024-11-08T02:16:54.271Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.fields_i64 FORMAT Native
|
| 256 | 2024-11-08T02:16:54.284Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 8
table_name = fields_i64
|
| 257 | 2024-11-08T02:16:54.284Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.fields_uuid FORMAT Native
|
| 258 | 2024-11-08T02:16:54.306Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 16
table_name = fields_uuid
|
| 259 | 2024-11-08T02:16:54.306Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = INSERT INTO oximeter.measurements_cumulativef64 FORMAT Native
|
| 260 | 2024-11-08T02:16:54.330Z | DEBG | test_cluster (clickhouse-client): inserted rows into table
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_rows = 400
table_name = measurements_cumulativef64
|
| 261 | 2024-11-08T02:16:54.330Z | INFO | test_cluster: inserted samples at clickhouse server: http://[::1]:19303
|
| 262 | 2024-11-08T02:16:54.332Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:54.332812020Z }
query = get virtual_machine:cpu_busy
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 263 | 2024-11-08T02:16:54.333Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:54.332812020Z }
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
timeseries_name = virtual_machine:cpu_busy
|
| 264 | 2024-11-08T02:16:54.333Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_predicates = None
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 265 | 2024-11-08T02:16:54.333Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
outer_limit = None
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 266 | 2024-11-08T02:16:54.333Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
predicate = none
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 267 | 2024-11-08T02:16:54.333Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 268 | 2024-11-08T02:16:54.365Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 24
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 269 | 2024-11-08T02:16:54.365Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,3039230695689809900,4218439645153873073,9086034282846337169,10469210161859473187,10547565764404206919,11153000122486487041,11941584955560446211,12189235776782632072,12237444503174949912,12602581409702662812,12854143305372262791,13833721948511634193,14455398054906438758,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17414859521901141978,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 270 | 2024-11-08T02:16:54.405Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_keys = 24
n_measurements = 1200
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 271 | 2024-11-08T02:16:54.405Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
limit = 1000000
n_new_measurements = 1200
n_total = 1200
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 272 | 2024-11-08T02:16:54.405Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 273 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 274 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 3039230695689809900
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 275 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 4218439645153873073
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 276 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 277 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 278 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 10547565764404206919
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 279 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 280 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 281 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12189235776782632072
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 282 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 283 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 284 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 12854143305372262791
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 285 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 13833721948511634193
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 286 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14455398054906438758
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 287 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 288 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 289 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 290 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 291 | 2024-11-08T02:16:54.406Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 292 | 2024-11-08T02:16:54.407Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 293 | 2024-11-08T02:16:54.407Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17414859521901141978
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 294 | 2024-11-08T02:16:54.407Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 295 | 2024-11-08T02:16:54.407Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 296 | 2024-11-08T02:16:54.407Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 421ea33f-0483-4725-81e0-e9209bfd5c05
n_timeseries = 24
n_transformations = 0
query_id = d2ee4057-72d8-4506-bb71-42d3a3bc9b2d
|
| 297 | 2024-11-08T02:16:54.419Z | DEBG | test_cluster (clickhouse-client): parsed OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
parsed_query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:54.418949226Z }
query = get virtual_machine:cpu_busy
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 298 | 2024-11-08T02:16:54.419Z | DEBG | test_cluster (clickhouse-client): running flat OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
query = Query { parsed: Query { ops: [Basic(Get(TimeseriesName("virtual_machine:cpu_busy")))] }, end_time: 2024-11-08T02:16:54.418949226Z }
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
timeseries_name = virtual_machine:cpu_busy
|
| 299 | 2024-11-08T02:16:54.419Z | DEBG | test_cluster (clickhouse-client): coalesced predicates from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_predicates = None
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 300 | 2024-11-08T02:16:54.419Z | DEBG | test_cluster (clickhouse-client): coalesced limit operations from flat query
coalesced = None
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
outer_limit = None
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 301 | 2024-11-08T02:16:54.419Z | DEBG | test_cluster (clickhouse-client): running disjoint query predicate
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
predicate = none
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 302 | 2024-11-08T02:16:54.420Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT filter_on_cpu_id.timeseries_key AS timeseries_key, filter_on_cpu_id.field_value AS cpu_id, filter_on_instance_id.field_value AS instance_id, filter_on_project_id.field_value AS project_id FROM (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_i64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'cpu_id' ) AS filter_on_cpu_id INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'instance_id' ) AS filter_on_instance_id ON filter_on_instance_id.timeseries_key = filter_on_cpu_id.timeseries_key INNER JOIN (SELECT DISTINCT timeseries_key, field_value FROM oximeter.fields_uuid WHERE timeseries_name = 'virtual_machine:cpu_busy' AND field_name = 'project_id' ) AS filter_on_project_id ON filter_on_project_id.timeseries_key = filter_on_instance_id.timeseries_key FORMAT JSONEachRow
|
| 303 | 2024-11-08T02:16:54.446Z | DEBG | test_cluster (clickhouse-client): fetched information for matching timeseries keys
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 24
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 304 | 2024-11-08T02:16:54.446Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
sql = SELECT timeseries_key, start_time, timestamp, datum FROM oximeter.measurements_cumulativef64 WHERE timeseries_name = 'virtual_machine:cpu_busy' AND (timeseries_key IN (214088992907546607,2080827326163450996,3039230695689809900,4218439645153873073,9086034282846337169,10469210161859473187,10547565764404206919,11153000122486487041,11941584955560446211,12189235776782632072,12237444503174949912,12602581409702662812,12854143305372262791,13833721948511634193,14455398054906438758,14720896737132335167,14987834724041522457,15574631974278219175,15623265778943350777,16304705339519466401,17356848348641513518,17414859521901141978,17508213766897240224,17596349148300307473)) ORDER BY timeseries_key, start_time, timestamp LIMIT 1000001 FORMAT JSONEachRow
|
| 305 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): fetched measurements for OxQL query
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_keys = 24
n_measurements = 1200
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 306 | 2024-11-08T02:16:54.488Z | TRAC | test_cluster (clickhouse-client): verified OxQL measurement query returns few enough results
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
limit = 1000000
n_new_measurements = 1200
n_total = 1200
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 307 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 214088992907546607
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 308 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 2080827326163450996
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 309 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 3039230695689809900
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 310 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 4218439645153873073
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 311 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 9086034282846337169
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 312 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 10469210161859473187
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 313 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 10547565764404206919
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 314 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11153000122486487041
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 315 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 11941584955560446211
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 316 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12189235776782632072
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 317 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12237444503174949912
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 318 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12602581409702662812
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 319 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 12854143305372262791
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 320 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 13833721948511634193
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 321 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14455398054906438758
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 322 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14720896737132335167
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 323 | 2024-11-08T02:16:54.488Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 14987834724041522457
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 324 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 15574631974278219175
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 325 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 15623265778943350777
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 326 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 16304705339519466401
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 327 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17356848348641513518
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 328 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17414859521901141978
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 329 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17508213766897240224
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 330 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): inserted new OxQL timeseries
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
key = 17596349148300307473
metric_type = Some(Delta)
n_points = 50
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 331 | 2024-11-08T02:16:54.489Z | DEBG | test_cluster (clickhouse-client): constructed OxQL table, starting transformation pipeline
id = 34a82979-40c0-4eed-b53b-00b68cb485bf
n_timeseries = 24
n_transformations = 0
query_id = 2859df7b-c7aa-4087-bf37-672840da2ece
|
| 332 | 2024-11-08T02:16:54.490Z | INFO | test_cluster: Attempting to insert samples without keeper quorum
|
| 333 | 2024-11-08T02:16:54.778Z | DEBG | test_cluster (clickhouse-client): registered USDT probes
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
|
| 334 | 2024-11-08T02:16:54.778Z | DEBG | test_cluster (clickhouse-client): unrolling 400 total samples
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
|
| 335 | 2024-11-08T02:16:54.779Z | DEBG | test_cluster (clickhouse-client): retrieving timeseries schema from database
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
|
| 336 | 2024-11-08T02:16:54.779Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
sql = SELECT * FROM oximeter.timeseries_schema FORMAT Native;
|
| 337 | 2024-11-08T02:16:54.785Z | TRAC | test_cluster (clickhouse-client): retrieved new timeseries schema
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
n_schema = 1
|
| 338 | 2024-11-08T02:16:55.037Z | TRAC | test_cluster (clickhouse-client): executing SQL query
id = 61bec45d-f7e8-48b7-9cc9-61964d970ba8
sql = INSERT INTO oximeter.fields_i64 FORMAT Native
|