1 | 2024.11.15 20:19:57.787097 [ 205609 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
2 | 2024.11.15 20:19:57.787161 [ 205609 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
3 | 2024.11.15 20:19:57.837610 [ 205609 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 205609 | ||
4 | 2024.11.15 20:19:57.837648 [ 205609 ] {} <Information> Application: starting up | ||
5 | 2024.11.15 20:19:57.837659 [ 205609 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
6 | 2024.11.15 20:19:57.839845 [ 205609 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
7 | 2024.11.15 20:19:57.844698 [ 205609 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
8 | 2024.11.15 20:19:57.844721 [ 205609 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
9 | 2024.11.15 20:19:57.844761 [ 205609 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
10 | 2024.11.15 20:19:57.844776 [ 205609 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
11 | 2024.11.15 20:19:58.007539 [ 205609 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
12 | 2024.11.15 20:19:58.007587 [ 205609 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
13 | 2024.11.15 20:19:58.013434 [ 205609 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
14 | 2024.11.15 20:19:58.018115 [ 205609 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
15 | 2024.11.15 20:19:58.018133 [ 205609 ] {} <Debug> Application: Initializing DateLUT. | ||
16 | 2024.11.15 20:19:58.018139 [ 205609 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
17 | 2024.11.15 20:19:58.018189 [ 205609 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/datastore/tmp/ to store temporary data in it | ||
18 | 2024.11.15 20:19:58.018502 [ 205609 ] {} <Debug> Application: Initializing interserver credentials. | ||
19 | 2024.11.15 20:19:58.018950 [ 205609 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml' | ||
20 | 2024.11.15 20:19:58.019322 [ 205609 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml', performing update on configuration | ||
21 | 2024.11.15 20:19:58.019770 [ 205609 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
22 | 2024.11.15 20:19:58.019783 [ 205609 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
23 | 2024.11.15 20:19:58.019789 [ 205609 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
24 | 2024.11.15 20:19:58.019825 [ 205609 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
25 | 2024.11.15 20:19:58.020453 [ 205609 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
26 | 2024.11.15 20:19:58.029036 [ 205609 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
27 | 2024.11.15 20:19:58.029974 [ 205609 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
28 | 2024.11.15 20:19:58.030604 [ 205609 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
29 | 2024.11.15 20:19:58.030624 [ 205609 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml', performed update on configuration | ||
30 | 2024.11.15 20:19:58.031175 [ 205609 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml' | ||
31 | 2024.11.15 20:19:58.032271 [ 205609 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml', performing update on configuration | ||
32 | 2024.11.15 20:19:58.082829 [ 205609 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml', performed update on configuration | ||
33 | 2024.11.15 20:19:58.083236 [ 205609 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/config.xml | ||
34 | 2024.11.15 20:19:58.101516 [ 205609 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
35 | 2024.11.15 20:19:58.105153 [ 205609 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
36 | 2024.11.15 20:19:58.108410 [ 205609 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
37 | 2024.11.15 20:19:58.108774 [ 205609 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
38 | 2024.11.15 20:19:58.110758 [ 205609 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
39 | 2024.11.15 20:19:58.113714 [ 205609 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/datastore/ | ||
40 | 2024.11.15 20:19:58.113821 [ 205675 ] {} <Debug> DNSResolver: Updating DNS cache | ||
41 | 2024.11.15 20:19:58.113848 [ 205675 ] {} <Debug> DNSResolver: Updated DNS cache | ||
42 | 2024.11.15 20:19:58.128114 [ 205609 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
43 | 2024.11.15 20:19:58.128137 [ 205609 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.001221651 sec | ||
44 | 2024.11.15 20:19:58.128145 [ 205609 ] {} <Trace> ReferentialDeps: No tables | ||
45 | 2024.11.15 20:19:58.128150 [ 205609 ] {} <Trace> LoadingDeps: No tables | ||
46 | 2024.11.15 20:19:58.128172 [ 205609 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
47 | 2024.11.15 20:19:58.128189 [ 205609 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
48 | 2024.11.15 20:19:58.129168 [ 205609 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
49 | 2024.11.15 20:19:58.129907 [ 205609 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
50 | 2024.11.15 20:19:58.129920 [ 205609 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
51 | 2024.11.15 20:19:58.129928 [ 205609 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
52 | 2024.11.15 20:19:58.129935 [ 205609 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
53 | 2024.11.15 20:19:58.129941 [ 205609 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
54 | 2024.11.15 20:19:58.129948 [ 205609 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
55 | 2024.11.15 20:19:58.129962 [ 205609 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
56 | 2024.11.15 20:19:58.129969 [ 205609 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
57 | 2024.11.15 20:19:58.129977 [ 205609 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
58 | 2024.11.15 20:19:58.129984 [ 205609 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
59 | 2024.11.15 20:19:58.129991 [ 205609 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
60 | 2024.11.15 20:19:58.129997 [ 205609 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
61 | 2024.11.15 20:19:58.130003 [ 205609 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
62 | 2024.11.15 20:19:58.130011 [ 205609 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
63 | 2024.11.15 20:19:58.130017 [ 205609 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
64 | 2024.11.15 20:19:58.166181 [ 205609 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
65 | 2024.11.15 20:19:58.172667 [ 205609 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
66 | 2024.11.15 20:19:58.172689 [ 205609 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.766e-05 sec | ||
67 | 2024.11.15 20:19:58.172696 [ 205609 ] {} <Trace> ReferentialDeps: No tables | ||
68 | 2024.11.15 20:19:58.172702 [ 205609 ] {} <Trace> LoadingDeps: No tables | ||
69 | 2024.11.15 20:19:58.172721 [ 205609 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
70 | 2024.11.15 20:19:58.172839 [ 205609 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_multiple_disks_multiple_snapshots_order_2.205563.1-clickhouse-6dCPGy/datastore/user_defined/ | ||
71 | 2024.11.15 20:19:58.172876 [ 205609 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
72 | 2024.11.15 20:19:58.172884 [ 205609 ] {} <Debug> Application: Loaded metadata. | ||
73 | 2024.11.15 20:19:58.172909 [ 205609 ] {} <Information> Application: Tasks stats provider: procfs | ||
74 | 2024.11.15 20:19:58.172916 [ 205609 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
75 | 2024.11.15 20:19:58.172987 [ 205609 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39415 | ||
76 | 2024.11.15 20:19:58.173039 [ 205609 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41987 | ||
77 | 2024.11.15 20:19:58.173230 [ 205609 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35119 | ||
78 | 2024.11.15 20:19:58.173270 [ 205609 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44119 | ||
79 | 2024.11.15 20:19:58.173292 [ 205609 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
80 | 2024.11.15 20:19:58.173702 [ 205609 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 16.00 MiB, will set to 381.84 MiB (RSS), difference: 361.22 MiB | ||
81 | 2024.11.15 20:19:58.174333 [ 205609 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.8361e-05 sec. | ||
82 | 2024.11.15 20:19:58.180958 [ 205609 ] {} <Information> Application: Listening for http://[::1]:39415 | ||
83 | 2024.11.15 20:19:58.181018 [ 205609 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:41987 | ||
84 | 2024.11.15 20:19:58.181069 [ 205609 ] {} <Information> Application: Listening for http://127.0.0.1:35119 | ||
85 | 2024.11.15 20:19:58.181128 [ 205609 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:44119 | ||
86 | 2024.11.15 20:19:58.181136 [ 205609 ] {} <Information> Application: Ready for connections. | ||
87 | 2024.11.15 20:19:59.105971 [ 205625 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58618 | ||
88 | 2024.11.15 20:19:59.113320 [ 205625 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
89 | 2024.11.15 20:19:59.113378 [ 205625 ] {} <Debug> TCP-Session: 3e59c3d6-8c0b-4b7e-8eee-e82d9918ce31 Authenticating user 'default' from [::1]:58618 | ||
90 | 2024.11.15 20:19:59.113396 [ 205625 ] {} <Debug> TCP-Session: 3e59c3d6-8c0b-4b7e-8eee-e82d9918ce31 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
91 | 2024.11.15 20:19:59.113401 [ 205625 ] {} <Debug> TCP-Session: 3e59c3d6-8c0b-4b7e-8eee-e82d9918ce31 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
92 | 2024.11.15 20:19:59.113477 [ 205625 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
93 | 2024.11.15 20:19:59.113495 [ 205625 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
94 | 2024.11.15 20:19:59.113501 [ 205625 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
95 | 2024.11.15 20:19:59.114051 [ 205626 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58620 | ||
96 | 2024.11.15 20:19:59.114477 [ 205626 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
97 | 2024.11.15 20:19:59.114517 [ 205626 ] {} <Debug> TCP-Session: e1a6a9ba-13cc-4bbf-b987-82c0e507b7dc Authenticating user 'default' from [::1]:58620 | ||
98 | 2024.11.15 20:19:59.114531 [ 205626 ] {} <Debug> TCP-Session: e1a6a9ba-13cc-4bbf-b987-82c0e507b7dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
99 | 2024.11.15 20:19:59.114538 [ 205626 ] {} <Debug> TCP-Session: e1a6a9ba-13cc-4bbf-b987-82c0e507b7dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
100 | 2024.11.15 20:19:59.119551 [ 205995 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58630 | ||
101 | 2024.11.15 20:19:59.125047 [ 205995 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
102 | 2024.11.15 20:19:59.125077 [ 205995 ] {} <Debug> TCP-Session: a382484b-8014-45e5-858f-ae4747c56670 Authenticating user 'default' from [::1]:58630 | ||
103 | 2024.11.15 20:19:59.125092 [ 205995 ] {} <Debug> TCP-Session: a382484b-8014-45e5-858f-ae4747c56670 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
104 | 2024.11.15 20:19:59.125098 [ 205995 ] {} <Debug> TCP-Session: a382484b-8014-45e5-858f-ae4747c56670 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
105 | 2024.11.15 20:19:59.128039 [ 205991 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58622 | ||
106 | 2024.11.15 20:19:59.128142 [ 205991 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
107 | 2024.11.15 20:19:59.128169 [ 205991 ] {} <Debug> TCP-Session: 1c2b43f0-4d43-4963-b061-2566e936617c Authenticating user 'default' from [::1]:58622 | ||
108 | 2024.11.15 20:19:59.128181 [ 205991 ] {} <Debug> TCP-Session: 1c2b43f0-4d43-4963-b061-2566e936617c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
109 | 2024.11.15 20:19:59.128188 [ 205991 ] {} <Debug> TCP-Session: 1c2b43f0-4d43-4963-b061-2566e936617c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
110 | 2024.11.15 20:19:59.128295 [ 205994 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58632 | ||
111 | 2024.11.15 20:19:59.128363 [ 205994 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
112 | 2024.11.15 20:19:59.128384 [ 205994 ] {} <Debug> TCP-Session: 69bc4db9-e4bb-4546-b81b-633dab96925e Authenticating user 'default' from [::1]:58632 | ||
113 | 2024.11.15 20:19:59.128393 [ 205994 ] {} <Debug> TCP-Session: 69bc4db9-e4bb-4546-b81b-633dab96925e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
114 | 2024.11.15 20:19:59.128399 [ 205994 ] {} <Debug> TCP-Session: 69bc4db9-e4bb-4546-b81b-633dab96925e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
115 | 2024.11.15 20:19:59.129610 [ 205993 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58626 | ||
116 | 2024.11.15 20:19:59.129640 [ 205992 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58624 | ||
117 | 2024.11.15 20:19:59.129657 [ 205628 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58628 | ||
118 | 2024.11.15 20:19:59.133644 [ 205628 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
119 | 2024.11.15 20:19:59.133673 [ 205628 ] {} <Debug> TCP-Session: 960d97cd-3c6b-46b2-acf3-b2f8fe08d17b Authenticating user 'default' from [::1]:58628 | ||
120 | 2024.11.15 20:19:59.133685 [ 205628 ] {} <Debug> TCP-Session: 960d97cd-3c6b-46b2-acf3-b2f8fe08d17b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
121 | 2024.11.15 20:19:59.133691 [ 205628 ] {} <Debug> TCP-Session: 960d97cd-3c6b-46b2-acf3-b2f8fe08d17b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
122 | 2024.11.15 20:19:59.133132 [ 205992 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
123 | 2024.11.15 20:19:59.133820 [ 205992 ] {} <Debug> TCP-Session: 17268916-5b0d-4305-a9eb-ebd34fb94a45 Authenticating user 'default' from [::1]:58624 | ||
124 | 2024.11.15 20:19:59.133830 [ 205992 ] {} <Debug> TCP-Session: 17268916-5b0d-4305-a9eb-ebd34fb94a45 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
125 | 2024.11.15 20:19:59.133835 [ 205992 ] {} <Debug> TCP-Session: 17268916-5b0d-4305-a9eb-ebd34fb94a45 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
126 | 2024.11.15 20:19:59.135054 [ 205993 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
127 | 2024.11.15 20:19:59.135617 [ 205993 ] {} <Debug> TCP-Session: d4ce301e-4b99-46bb-9832-f43eec7a1bfc Authenticating user 'default' from [::1]:58626 | ||
128 | 2024.11.15 20:19:59.135633 [ 205993 ] {} <Debug> TCP-Session: d4ce301e-4b99-46bb-9832-f43eec7a1bfc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
129 | 2024.11.15 20:19:59.135639 [ 205993 ] {} <Debug> TCP-Session: d4ce301e-4b99-46bb-9832-f43eec7a1bfc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
130 | 2024.11.15 20:20:07.465883 [ 206940 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58636 | ||
131 | 2024.11.15 20:20:07.761123 [ 206940 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
132 | 2024.11.15 20:20:07.761185 [ 206940 ] {} <Debug> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Authenticating user 'default' from [::1]:58636 | ||
133 | 2024.11.15 20:20:07.761204 [ 206940 ] {} <Debug> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
134 | 2024.11.15 20:20:07.761217 [ 206940 ] {} <Debug> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
135 | 2024.11.15 20:20:07.796779 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
136 | 2024.11.15 20:20:07.797046 [ 206940 ] {ac1e4d96-9101-4b93-b571-0559df8ff233} <Debug> executeQuery: (from [::1]:58636) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
137 | 2024.11.15 20:20:07.797764 [ 206940 ] {ac1e4d96-9101-4b93-b571-0559df8ff233} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:58636) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
138 | |||
139 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
140 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
141 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
142 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
143 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
144 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
145 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
146 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
147 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
148 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
149 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
150 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
151 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 16. ? @ 0x00007f88e7501ac3 in ? | ||
156 | 17. ? @ 0x00007f88e7593850 in ? | ||
157 | |||
158 | 2024.11.15 20:20:07.797885 [ 206940 ] {ac1e4d96-9101-4b93-b571-0559df8ff233} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
159 | |||
160 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
163 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
164 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
165 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
166 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
172 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
173 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
174 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
175 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 16. ? @ 0x00007f88e7501ac3 in ? | ||
177 | 17. ? @ 0x00007f88e7593850 in ? | ||
178 | |||
179 | 2024.11.15 20:20:07.797938 [ 206940 ] {ac1e4d96-9101-4b93-b571-0559df8ff233} <Debug> TCPHandler: Processed in 0.001352051 sec. | ||
180 | 2024.11.15 20:20:07.803751 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
181 | 2024.11.15 20:20:07.803959 [ 206940 ] {88519671-5bda-4a6e-b61b-a5a2255746bf} <Debug> executeQuery: (from [::1]:58636) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
182 | 2024.11.15 20:20:07.804226 [ 206940 ] {88519671-5bda-4a6e-b61b-a5a2255746bf} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:58636) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
183 | |||
184 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
185 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
188 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
189 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
190 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
191 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
198 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
199 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
200 | 16. ? @ 0x00007f88e7501ac3 in ? | ||
201 | 17. ? @ 0x00007f88e7593850 in ? | ||
202 | |||
203 | 2024.11.15 20:20:07.804339 [ 206940 ] {88519671-5bda-4a6e-b61b-a5a2255746bf} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
204 | |||
205 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
206 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
207 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
208 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
209 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
210 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
211 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
212 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
213 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
214 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
215 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
216 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
217 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
218 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
219 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
220 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
221 | 16. ? @ 0x00007f88e7501ac3 in ? | ||
222 | 17. ? @ 0x00007f88e7593850 in ? | ||
223 | |||
224 | 2024.11.15 20:20:07.804385 [ 206940 ] {88519671-5bda-4a6e-b61b-a5a2255746bf} <Debug> TCPHandler: Processed in 0.000794111 sec. | ||
225 | 2024.11.15 20:20:07.813460 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
226 | 2024.11.15 20:20:07.813647 [ 206940 ] {d272735b-4af8-4fbd-802b-69a17aaf90a9} <Debug> executeQuery: (from [::1]:58636) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
227 | 2024.11.15 20:20:07.813754 [ 206940 ] {d272735b-4af8-4fbd-802b-69a17aaf90a9} <Debug> TCPHandler: Processed in 0.000466211 sec. | ||
228 | 2024.11.15 20:20:07.823260 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
229 | 2024.11.15 20:20:07.823432 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Debug> executeQuery: (from [::1]:58636) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
230 | 2024.11.15 20:20:07.823472 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
231 | 2024.11.15 20:20:07.826150 [ 207053 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58650 | ||
232 | 2024.11.15 20:20:07.826309 [ 207053 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
233 | 2024.11.15 20:20:07.826334 [ 207053 ] {} <Debug> TCP-Session: 1ab43f9b-0ec8-420b-9955-d03745d6f5d5 Authenticating user 'default' from [::1]:58650 | ||
234 | 2024.11.15 20:20:07.826348 [ 207053 ] {} <Debug> TCP-Session: 1ab43f9b-0ec8-420b-9955-d03745d6f5d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
235 | 2024.11.15 20:20:07.826355 [ 207053 ] {} <Debug> TCP-Session: 1ab43f9b-0ec8-420b-9955-d03745d6f5d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
236 | 2024.11.15 20:20:07.828508 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
237 | 2024.11.15 20:20:07.828721 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000266221 sec | ||
238 | 2024.11.15 20:20:07.828734 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Trace> ReferentialDeps: No tables | ||
239 | 2024.11.15 20:20:07.828741 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Trace> LoadingDeps: No tables | ||
240 | 2024.11.15 20:20:07.828761 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
241 | 2024.11.15 20:20:07.828843 [ 206940 ] {6b34cb61-fece-4311-b443-4026c95f596b} <Debug> TCPHandler: Processed in 0.005774265 sec. | ||
242 | 2024.11.15 20:20:07.830796 [ 207053 ] {} <Trace> TCP-Session: 1ab43f9b-0ec8-420b-9955-d03745d6f5d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
243 | 2024.11.15 20:20:07.830806 [ 207039 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58638 | ||
244 | 2024.11.15 20:20:07.830905 [ 207039 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
245 | 2024.11.15 20:20:07.832047 [ 207039 ] {} <Debug> TCP-Session: cda813ee-3e7a-4da5-98b2-9910880a7f66 Authenticating user 'default' from [::1]:58638 | ||
246 | 2024.11.15 20:20:07.832067 [ 207039 ] {} <Debug> TCP-Session: cda813ee-3e7a-4da5-98b2-9910880a7f66 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
247 | 2024.11.15 20:20:07.832074 [ 207039 ] {} <Debug> TCP-Session: cda813ee-3e7a-4da5-98b2-9910880a7f66 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
248 | 2024.11.15 20:20:07.832153 [ 207039 ] {} <Debug> TCPHandler: Done processing connection. | ||
249 | 2024.11.15 20:20:07.832172 [ 207039 ] {} <Debug> TCP-Session: cda813ee-3e7a-4da5-98b2-9910880a7f66 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
250 | 2024.11.15 20:20:07.832395 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Debug> executeQuery: (from [::1]:58650) /* The version table contains metadata about the `oximeter` database */ | ||
251 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
252 | 2024.11.15 20:20:07.832454 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
253 | 2024.11.15 20:20:07.833099 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
254 | 2024.11.15 20:20:07.838254 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Debug> oximeter.version (6162af12-eb27-4a0b-973d-db551e80b56a): Loading data parts | ||
255 | 2024.11.15 20:20:07.848631 [ 207043 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58646 | ||
256 | 2024.11.15 20:20:07.848630 [ 207060 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58664 | ||
257 | 2024.11.15 20:20:07.848751 [ 207043 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
258 | 2024.11.15 20:20:07.848765 [ 207060 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
259 | 2024.11.15 20:20:07.848786 [ 207060 ] {} <Debug> TCP-Session: dc573444-b396-4268-b129-99d3b498e556 Authenticating user 'default' from [::1]:58664 | ||
260 | 2024.11.15 20:20:07.848795 [ 207043 ] {} <Debug> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Authenticating user 'default' from [::1]:58646 | ||
261 | 2024.11.15 20:20:07.848807 [ 207060 ] {} <Debug> TCP-Session: dc573444-b396-4268-b129-99d3b498e556 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
262 | 2024.11.15 20:20:07.848814 [ 207060 ] {} <Debug> TCP-Session: dc573444-b396-4268-b129-99d3b498e556 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
263 | 2024.11.15 20:20:07.848855 [ 207055 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58654 | ||
264 | 2024.11.15 20:20:07.848900 [ 207054 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58652 | ||
265 | 2024.11.15 20:20:07.848916 [ 207043 ] {} <Debug> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
266 | 2024.11.15 20:20:07.849973 [ 207043 ] {} <Debug> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
267 | 2024.11.15 20:20:07.850058 [ 207054 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
268 | 2024.11.15 20:20:07.850107 [ 207054 ] {} <Debug> TCP-Session: 4fbf7866-8623-46c2-8fe2-4ee511f9d130 Authenticating user 'default' from [::1]:58652 | ||
269 | 2024.11.15 20:20:07.850122 [ 207054 ] {} <Debug> TCP-Session: 4fbf7866-8623-46c2-8fe2-4ee511f9d130 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
270 | 2024.11.15 20:20:07.850155 [ 207054 ] {} <Debug> TCP-Session: 4fbf7866-8623-46c2-8fe2-4ee511f9d130 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
271 | 2024.11.15 20:20:07.850189 [ 207057 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58656 | ||
272 | 2024.11.15 20:20:07.850231 [ 207042 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58642 | ||
273 | 2024.11.15 20:20:07.850415 [ 207042 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
274 | 2024.11.15 20:20:07.850432 [ 207042 ] {} <Debug> TCP-Session: 154579d7-9168-49a5-847a-6c55fb2c105e Authenticating user 'default' from [::1]:58642 | ||
275 | 2024.11.15 20:20:07.850430 [ 207055 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
276 | 2024.11.15 20:20:07.850410 [ 207059 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58660 | ||
277 | 2024.11.15 20:20:07.850435 [ 207041 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58640 | ||
278 | 2024.11.15 20:20:07.850473 [ 207055 ] {} <Debug> TCP-Session: 65e2faa4-f11e-466a-ae74-d2a4c6c970df Authenticating user 'default' from [::1]:58654 | ||
279 | 2024.11.15 20:20:07.850440 [ 207042 ] {} <Debug> TCP-Session: 154579d7-9168-49a5-847a-6c55fb2c105e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
280 | 2024.11.15 20:20:07.850492 [ 207042 ] {} <Debug> TCP-Session: 154579d7-9168-49a5-847a-6c55fb2c105e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
281 | 2024.11.15 20:20:07.850493 [ 207055 ] {} <Debug> TCP-Session: 65e2faa4-f11e-466a-ae74-d2a4c6c970df Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
282 | 2024.11.15 20:20:07.850523 [ 207055 ] {} <Debug> TCP-Session: 65e2faa4-f11e-466a-ae74-d2a4c6c970df Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
283 | 2024.11.15 20:20:07.850619 [ 207042 ] {} <Debug> TCPHandler: Done processing connection. | ||
284 | 2024.11.15 20:20:07.850640 [ 207042 ] {} <Debug> TCP-Session: 154579d7-9168-49a5-847a-6c55fb2c105e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
285 | 2024.11.15 20:20:07.851047 [ 207059 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
286 | 2024.11.15 20:20:07.851057 [ 207041 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
287 | 2024.11.15 20:20:07.851862 [ 207059 ] {} <Debug> TCP-Session: 5282a785-9793-4ab4-9a1d-6cab779e491e Authenticating user 'default' from [::1]:58660 | ||
288 | 2024.11.15 20:20:07.851870 [ 207041 ] {} <Debug> TCP-Session: 66b18fa6-057e-4c24-8b9c-c9d62d7231c8 Authenticating user 'default' from [::1]:58640 | ||
289 | 2024.11.15 20:20:07.851879 [ 207059 ] {} <Debug> TCP-Session: 5282a785-9793-4ab4-9a1d-6cab779e491e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
290 | 2024.11.15 20:20:07.851883 [ 207041 ] {} <Debug> TCP-Session: 66b18fa6-057e-4c24-8b9c-c9d62d7231c8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
291 | 2024.11.15 20:20:07.851886 [ 207059 ] {} <Debug> TCP-Session: 5282a785-9793-4ab4-9a1d-6cab779e491e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
292 | 2024.11.15 20:20:07.851889 [ 207041 ] {} <Debug> TCP-Session: 66b18fa6-057e-4c24-8b9c-c9d62d7231c8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
293 | 2024.11.15 20:20:07.852076 [ 207041 ] {} <Debug> TCPHandler: Done processing connection. | ||
294 | 2024.11.15 20:20:07.852111 [ 207041 ] {} <Debug> TCP-Session: 66b18fa6-057e-4c24-8b9c-c9d62d7231c8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
295 | 2024.11.15 20:20:07.851108 [ 207058 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58658 | ||
296 | 2024.11.15 20:20:07.852514 [ 207057 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
297 | 2024.11.15 20:20:07.852541 [ 207057 ] {} <Debug> TCP-Session: d0f6dcef-22b0-4dab-a047-6d08f3cd726e Authenticating user 'default' from [::1]:58656 | ||
298 | 2024.11.15 20:20:07.852548 [ 207057 ] {} <Debug> TCP-Session: d0f6dcef-22b0-4dab-a047-6d08f3cd726e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.11.15 20:20:07.852552 [ 207057 ] {} <Debug> TCP-Session: d0f6dcef-22b0-4dab-a047-6d08f3cd726e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.11.15 20:20:07.852768 [ 207058 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
301 | 2024.11.15 20:20:07.854151 [ 207058 ] {} <Debug> TCP-Session: f3753ad7-4ee4-41c5-9749-03bb90ad99b4 Authenticating user 'default' from [::1]:58658 | ||
302 | 2024.11.15 20:20:07.854166 [ 207058 ] {} <Debug> TCP-Session: f3753ad7-4ee4-41c5-9749-03bb90ad99b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
303 | 2024.11.15 20:20:07.854173 [ 207058 ] {} <Debug> TCP-Session: f3753ad7-4ee4-41c5-9749-03bb90ad99b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
304 | 2024.11.15 20:20:07.861648 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Debug> oximeter.version (6162af12-eb27-4a0b-973d-db551e80b56a): There are no data parts | ||
305 | 2024.11.15 20:20:07.873632 [ 207053 ] {63c6b347-46fa-47a5-b91a-0a70eba9e69f} <Debug> TCPHandler: Processed in 0.043096355 sec. | ||
306 | 2024.11.15 20:20:07.878974 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
307 | 2024.11.15 20:20:07.879269 [ 206940 ] {2b8b14b4-a801-449d-af1b-bd397fec60b0} <Debug> executeQuery: (from [::1]:58636) /* The measurement tables contain all individual samples from each timeseries. | ||
308 | * | ||
309 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
310 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
311 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
312 | * by all samples from the same timeseries. | ||
313 | * | ||
314 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
315 | * and then uses that to index quickly into the measurements tables. | ||
316 | */ | ||
317 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
318 | 2024.11.15 20:20:07.880252 [ 206940 ] {2b8b14b4-a801-449d-af1b-bd397fec60b0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
319 | 2024.11.15 20:20:07.884801 [ 206940 ] {2b8b14b4-a801-449d-af1b-bd397fec60b0} <Debug> oximeter.measurements_bool (e9b35100-b576-473f-bd9a-7ca70af36e64): Loading data parts | ||
320 | 2024.11.15 20:20:07.885098 [ 206940 ] {2b8b14b4-a801-449d-af1b-bd397fec60b0} <Debug> oximeter.measurements_bool (e9b35100-b576-473f-bd9a-7ca70af36e64): There are no data parts | ||
321 | 2024.11.15 20:20:07.888880 [ 206940 ] {2b8b14b4-a801-449d-af1b-bd397fec60b0} <Debug> TCPHandler: Processed in 0.010098678 sec. | ||
322 | 2024.11.15 20:20:07.893552 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
323 | 2024.11.15 20:20:07.893869 [ 207043 ] {7de3126b-9f89-43d9-9364-179ab6472ffe} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
324 | 2024.11.15 20:20:07.893932 [ 207043 ] {7de3126b-9f89-43d9-9364-179ab6472ffe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
325 | 2024.11.15 20:20:07.900166 [ 207043 ] {7de3126b-9f89-43d9-9364-179ab6472ffe} <Debug> oximeter.measurements_i8 (3fc51e6e-288a-44f0-9f5d-52d549a4324b): Loading data parts | ||
326 | 2024.11.15 20:20:07.900427 [ 207043 ] {7de3126b-9f89-43d9-9364-179ab6472ffe} <Debug> oximeter.measurements_i8 (3fc51e6e-288a-44f0-9f5d-52d549a4324b): There are no data parts | ||
327 | 2024.11.15 20:20:07.904418 [ 207043 ] {7de3126b-9f89-43d9-9364-179ab6472ffe} <Debug> TCPHandler: Processed in 0.01105872 sec. | ||
328 | 2024.11.15 20:20:07.905292 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
329 | 2024.11.15 20:20:07.905661 [ 206940 ] {38021ae8-880d-4cc8-b4dc-edb17f72fe42} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
330 | 2024.11.15 20:20:07.907337 [ 206940 ] {38021ae8-880d-4cc8-b4dc-edb17f72fe42} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
331 | 2024.11.15 20:20:07.913007 [ 206940 ] {38021ae8-880d-4cc8-b4dc-edb17f72fe42} <Debug> oximeter.measurements_u8 (7c512128-4b08-43bc-8072-e15f9bb6bbd8): Loading data parts | ||
332 | 2024.11.15 20:20:07.913296 [ 206940 ] {38021ae8-880d-4cc8-b4dc-edb17f72fe42} <Debug> oximeter.measurements_u8 (7c512128-4b08-43bc-8072-e15f9bb6bbd8): There are no data parts | ||
333 | 2024.11.15 20:20:07.916998 [ 206940 ] {38021ae8-880d-4cc8-b4dc-edb17f72fe42} <Debug> TCPHandler: Processed in 0.011892359 sec. | ||
334 | 2024.11.15 20:20:07.917914 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
335 | 2024.11.15 20:20:07.918164 [ 207043 ] {844ee69b-d92f-4113-8077-1df3a23a83f7} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
336 | 2024.11.15 20:20:07.918212 [ 207043 ] {844ee69b-d92f-4113-8077-1df3a23a83f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
337 | 2024.11.15 20:20:07.923525 [ 207043 ] {844ee69b-d92f-4113-8077-1df3a23a83f7} <Debug> oximeter.measurements_i16 (96588a1c-1eb9-442c-8857-10bbd4fc4f3d): Loading data parts | ||
338 | 2024.11.15 20:20:07.924011 [ 207043 ] {844ee69b-d92f-4113-8077-1df3a23a83f7} <Debug> oximeter.measurements_i16 (96588a1c-1eb9-442c-8857-10bbd4fc4f3d): There are no data parts | ||
339 | 2024.11.15 20:20:07.927861 [ 207043 ] {844ee69b-d92f-4113-8077-1df3a23a83f7} <Debug> TCPHandler: Processed in 0.010110298 sec. | ||
340 | 2024.11.15 20:20:07.928623 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
341 | 2024.11.15 20:20:07.928915 [ 206940 ] {5a631492-03fe-486a-bf28-9daa108cf62d} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
342 | 2024.11.15 20:20:07.928964 [ 206940 ] {5a631492-03fe-486a-bf28-9daa108cf62d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
343 | 2024.11.15 20:20:07.935602 [ 206940 ] {5a631492-03fe-486a-bf28-9daa108cf62d} <Debug> oximeter.measurements_u16 (8bb89900-7650-4bf3-9bc7-3ffe737f5377): Loading data parts | ||
344 | 2024.11.15 20:20:07.935909 [ 206940 ] {5a631492-03fe-486a-bf28-9daa108cf62d} <Debug> oximeter.measurements_u16 (8bb89900-7650-4bf3-9bc7-3ffe737f5377): There are no data parts | ||
345 | 2024.11.15 20:20:07.940255 [ 206940 ] {5a631492-03fe-486a-bf28-9daa108cf62d} <Debug> TCPHandler: Processed in 0.011801649 sec. | ||
346 | 2024.11.15 20:20:07.940989 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
347 | 2024.11.15 20:20:07.941213 [ 207043 ] {ff4f5d46-9ac3-494d-9540-d5a6c4e93681} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
348 | 2024.11.15 20:20:07.941261 [ 207043 ] {ff4f5d46-9ac3-494d-9540-d5a6c4e93681} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
349 | 2024.11.15 20:20:07.947897 [ 207043 ] {ff4f5d46-9ac3-494d-9540-d5a6c4e93681} <Debug> oximeter.measurements_i32 (73c0b3b3-d01f-4304-8780-e4f9a3e5dc78): Loading data parts | ||
350 | 2024.11.15 20:20:07.948165 [ 207043 ] {ff4f5d46-9ac3-494d-9540-d5a6c4e93681} <Debug> oximeter.measurements_i32 (73c0b3b3-d01f-4304-8780-e4f9a3e5dc78): There are no data parts | ||
351 | 2024.11.15 20:20:07.953800 [ 207043 ] {ff4f5d46-9ac3-494d-9540-d5a6c4e93681} <Debug> TCPHandler: Processed in 0.01293924 sec. | ||
352 | 2024.11.15 20:20:07.954545 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
353 | 2024.11.15 20:20:07.956407 [ 206940 ] {7a374236-56f9-414f-858e-93ce9767a492} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
354 | 2024.11.15 20:20:07.957315 [ 206940 ] {7a374236-56f9-414f-858e-93ce9767a492} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
355 | 2024.11.15 20:20:07.964112 [ 206940 ] {7a374236-56f9-414f-858e-93ce9767a492} <Debug> oximeter.measurements_u32 (45cbebb8-2ec4-4729-95b6-aa4889cd9fc9): Loading data parts | ||
356 | 2024.11.15 20:20:07.964386 [ 206940 ] {7a374236-56f9-414f-858e-93ce9767a492} <Debug> oximeter.measurements_u32 (45cbebb8-2ec4-4729-95b6-aa4889cd9fc9): There are no data parts | ||
357 | 2024.11.15 20:20:07.969494 [ 206940 ] {7a374236-56f9-414f-858e-93ce9767a492} <Debug> TCPHandler: Processed in 0.015111812 sec. | ||
358 | 2024.11.15 20:20:07.970346 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
359 | 2024.11.15 20:20:07.970614 [ 207043 ] {14877b1a-fb38-4a12-88b3-28ce24bdf6c4} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
360 | 2024.11.15 20:20:07.970667 [ 207043 ] {14877b1a-fb38-4a12-88b3-28ce24bdf6c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
361 | 2024.11.15 20:20:07.980580 [ 207043 ] {14877b1a-fb38-4a12-88b3-28ce24bdf6c4} <Debug> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Loading data parts | ||
362 | 2024.11.15 20:20:07.981170 [ 207043 ] {14877b1a-fb38-4a12-88b3-28ce24bdf6c4} <Debug> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): There are no data parts | ||
363 | 2024.11.15 20:20:07.987118 [ 207043 ] {14877b1a-fb38-4a12-88b3-28ce24bdf6c4} <Debug> TCPHandler: Processed in 0.016940474 sec. | ||
364 | 2024.11.15 20:20:07.987891 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
365 | 2024.11.15 20:20:07.988198 [ 206940 ] {84576347-0dd9-43a3-89e0-266e00dc8b04} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
366 | 2024.11.15 20:20:07.988247 [ 206940 ] {84576347-0dd9-43a3-89e0-266e00dc8b04} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
367 | 2024.11.15 20:20:07.996270 [ 206940 ] {84576347-0dd9-43a3-89e0-266e00dc8b04} <Debug> oximeter.measurements_u64 (3f1e2f8c-71b4-4751-b2e6-488b4d5cbd8f): Loading data parts | ||
368 | 2024.11.15 20:20:07.996667 [ 206940 ] {84576347-0dd9-43a3-89e0-266e00dc8b04} <Debug> oximeter.measurements_u64 (3f1e2f8c-71b4-4751-b2e6-488b4d5cbd8f): There are no data parts | ||
369 | 2024.11.15 20:20:08.000233 [ 206940 ] {84576347-0dd9-43a3-89e0-266e00dc8b04} <Debug> TCPHandler: Processed in 0.012498899 sec. | ||
370 | 2024.11.15 20:20:08.000410 [ 205898 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 389.25 MiB, peak 389.25 MiB, free memory in arenas 19.54 MiB, will set to 387.89 MiB (RSS), difference: -1.36 MiB | ||
371 | 2024.11.15 20:20:08.001138 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
372 | 2024.11.15 20:20:08.001445 [ 207043 ] {261feb8b-e284-4c83-a0bb-5912804ab305} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
373 | 2024.11.15 20:20:08.001498 [ 207043 ] {261feb8b-e284-4c83-a0bb-5912804ab305} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
374 | 2024.11.15 20:20:08.007975 [ 207043 ] {261feb8b-e284-4c83-a0bb-5912804ab305} <Debug> oximeter.measurements_f32 (cb746220-0492-4d23-9769-a4d7604d1e8e): Loading data parts | ||
375 | 2024.11.15 20:20:08.008217 [ 207043 ] {261feb8b-e284-4c83-a0bb-5912804ab305} <Debug> oximeter.measurements_f32 (cb746220-0492-4d23-9769-a4d7604d1e8e): There are no data parts | ||
376 | 2024.11.15 20:20:08.012713 [ 207043 ] {261feb8b-e284-4c83-a0bb-5912804ab305} <Debug> TCPHandler: Processed in 0.01166393 sec. | ||
377 | 2024.11.15 20:20:08.013502 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
378 | 2024.11.15 20:20:08.013726 [ 206940 ] {270ad3ff-7667-42cc-8254-39194855af39} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
379 | 2024.11.15 20:20:08.013765 [ 206940 ] {270ad3ff-7667-42cc-8254-39194855af39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
380 | 2024.11.15 20:20:08.019399 [ 206940 ] {270ad3ff-7667-42cc-8254-39194855af39} <Debug> oximeter.measurements_f64 (66a40a89-a1ff-431e-86db-47110a9f0717): Loading data parts | ||
381 | 2024.11.15 20:20:08.019617 [ 206940 ] {270ad3ff-7667-42cc-8254-39194855af39} <Debug> oximeter.measurements_f64 (66a40a89-a1ff-431e-86db-47110a9f0717): There are no data parts | ||
382 | 2024.11.15 20:20:08.023236 [ 206940 ] {270ad3ff-7667-42cc-8254-39194855af39} <Debug> TCPHandler: Processed in 0.009861348 sec. | ||
383 | 2024.11.15 20:20:08.023996 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
384 | 2024.11.15 20:20:08.024241 [ 207043 ] {244b051d-7548-4200-916d-5f4e42a9b7c7} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
385 | 2024.11.15 20:20:08.024289 [ 207043 ] {244b051d-7548-4200-916d-5f4e42a9b7c7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
386 | 2024.11.15 20:20:08.030555 [ 207043 ] {244b051d-7548-4200-916d-5f4e42a9b7c7} <Debug> oximeter.measurements_string (7ebfd69a-75cb-44d3-b6da-f187fac5055a): Loading data parts | ||
387 | 2024.11.15 20:20:08.031817 [ 207043 ] {244b051d-7548-4200-916d-5f4e42a9b7c7} <Debug> oximeter.measurements_string (7ebfd69a-75cb-44d3-b6da-f187fac5055a): There are no data parts | ||
388 | 2024.11.15 20:20:08.036213 [ 207043 ] {244b051d-7548-4200-916d-5f4e42a9b7c7} <Debug> TCPHandler: Processed in 0.01235617 sec. | ||
389 | 2024.11.15 20:20:08.037024 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
390 | 2024.11.15 20:20:08.039015 [ 206940 ] {0d3972e3-c7e2-466d-9621-f399c44e6414} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
391 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
392 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
393 | * a string isn't palatable for a few reasons. | ||
394 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
395 | * details. | ||
396 | */ | ||
397 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
398 | 2024.11.15 20:20:08.039072 [ 206940 ] {0d3972e3-c7e2-466d-9621-f399c44e6414} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
399 | 2024.11.15 20:20:08.045273 [ 206940 ] {0d3972e3-c7e2-466d-9621-f399c44e6414} <Debug> oximeter.measurements_bytes (5367adfc-b2aa-497b-a731-2f295e6c9a3e): Loading data parts | ||
400 | 2024.11.15 20:20:08.045574 [ 206940 ] {0d3972e3-c7e2-466d-9621-f399c44e6414} <Debug> oximeter.measurements_bytes (5367adfc-b2aa-497b-a731-2f295e6c9a3e): There are no data parts | ||
401 | 2024.11.15 20:20:08.048889 [ 206940 ] {0d3972e3-c7e2-466d-9621-f399c44e6414} <Debug> TCPHandler: Processed in 0.01205677 sec. | ||
402 | 2024.11.15 20:20:08.049706 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
403 | 2024.11.15 20:20:08.050017 [ 207043 ] {5c5f58ef-d8d4-4263-865c-73a756635eea} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
404 | 2024.11.15 20:20:08.050074 [ 207043 ] {5c5f58ef-d8d4-4263-865c-73a756635eea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
405 | 2024.11.15 20:20:08.056138 [ 207043 ] {5c5f58ef-d8d4-4263-865c-73a756635eea} <Debug> oximeter.measurements_cumulativei64 (6f09a9db-f785-459b-8c34-d773009cfa90): Loading data parts | ||
406 | 2024.11.15 20:20:08.056412 [ 207043 ] {5c5f58ef-d8d4-4263-865c-73a756635eea} <Debug> oximeter.measurements_cumulativei64 (6f09a9db-f785-459b-8c34-d773009cfa90): There are no data parts | ||
407 | 2024.11.15 20:20:08.061445 [ 207043 ] {5c5f58ef-d8d4-4263-865c-73a756635eea} <Debug> TCPHandler: Processed in 0.01191351 sec. | ||
408 | 2024.11.15 20:20:08.063199 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
409 | 2024.11.15 20:20:08.063463 [ 206940 ] {0fadd7b2-c0f4-49ba-bab8-ad817068eaab} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
410 | 2024.11.15 20:20:08.063507 [ 206940 ] {0fadd7b2-c0f4-49ba-bab8-ad817068eaab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
411 | 2024.11.15 20:20:08.067850 [ 206940 ] {0fadd7b2-c0f4-49ba-bab8-ad817068eaab} <Debug> oximeter.measurements_cumulativeu64 (f7b12fef-7286-4b72-a282-5ead3e54e9be): Loading data parts | ||
412 | 2024.11.15 20:20:08.068091 [ 206940 ] {0fadd7b2-c0f4-49ba-bab8-ad817068eaab} <Debug> oximeter.measurements_cumulativeu64 (f7b12fef-7286-4b72-a282-5ead3e54e9be): There are no data parts | ||
413 | 2024.11.15 20:20:08.072182 [ 206940 ] {0fadd7b2-c0f4-49ba-bab8-ad817068eaab} <Debug> TCPHandler: Processed in 0.009198428 sec. | ||
414 | 2024.11.15 20:20:08.073025 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
415 | 2024.11.15 20:20:08.073338 [ 207043 ] {3979c416-15cb-432c-94c6-90bcfe2b7f71} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
416 | 2024.11.15 20:20:08.073389 [ 207043 ] {3979c416-15cb-432c-94c6-90bcfe2b7f71} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
417 | 2024.11.15 20:20:08.079658 [ 207043 ] {3979c416-15cb-432c-94c6-90bcfe2b7f71} <Debug> oximeter.measurements_cumulativef32 (bed28172-85e3-4a20-81d5-582210c2a023): Loading data parts | ||
418 | 2024.11.15 20:20:08.080789 [ 207043 ] {3979c416-15cb-432c-94c6-90bcfe2b7f71} <Debug> oximeter.measurements_cumulativef32 (bed28172-85e3-4a20-81d5-582210c2a023): There are no data parts | ||
419 | 2024.11.15 20:20:08.087387 [ 207043 ] {3979c416-15cb-432c-94c6-90bcfe2b7f71} <Debug> TCPHandler: Processed in 0.014535862 sec. | ||
420 | 2024.11.15 20:20:08.089281 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
421 | 2024.11.15 20:20:08.089578 [ 206940 ] {6c30cc8e-8bd8-48fa-9117-a496bcb84999} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
422 | 2024.11.15 20:20:08.090367 [ 206940 ] {6c30cc8e-8bd8-48fa-9117-a496bcb84999} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
423 | 2024.11.15 20:20:08.095010 [ 206940 ] {6c30cc8e-8bd8-48fa-9117-a496bcb84999} <Debug> oximeter.measurements_cumulativef64 (f7341d14-2709-4583-b1cc-ee3c55f54328): Loading data parts | ||
424 | 2024.11.15 20:20:08.096205 [ 206940 ] {6c30cc8e-8bd8-48fa-9117-a496bcb84999} <Debug> oximeter.measurements_cumulativef64 (f7341d14-2709-4583-b1cc-ee3c55f54328): There are no data parts | ||
425 | 2024.11.15 20:20:08.101008 [ 206940 ] {6c30cc8e-8bd8-48fa-9117-a496bcb84999} <Debug> TCPHandler: Processed in 0.01192676 sec. | ||
426 | 2024.11.15 20:20:08.103159 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
427 | 2024.11.15 20:20:08.104692 [ 207043 ] {68629269-d468-4809-aead-f8c09a5d1a18} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
428 | * NOTE: Array types cannot be Nullable, see | ||
429 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
430 | * for more details. | ||
431 | * | ||
432 | * This means we need to use empty arrays to indicate a missing value. This | ||
433 | * is unfortunate, and at this point relies on the fact that an | ||
434 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
435 | * to figure out another way to represent missing samples here. | ||
436 | */ | ||
437 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
438 | 2024.11.15 20:20:08.104766 [ 207043 ] {68629269-d468-4809-aead-f8c09a5d1a18} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
439 | 2024.11.15 20:20:08.114010 [ 207043 ] {68629269-d468-4809-aead-f8c09a5d1a18} <Debug> oximeter.measurements_histogrami8 (e4126f33-b19a-42c7-8b4d-ed90ea54e983): Loading data parts | ||
440 | 2024.11.15 20:20:08.115287 [ 207043 ] {68629269-d468-4809-aead-f8c09a5d1a18} <Debug> oximeter.measurements_histogrami8 (e4126f33-b19a-42c7-8b4d-ed90ea54e983): There are no data parts | ||
441 | 2024.11.15 20:20:08.119594 [ 207043 ] {68629269-d468-4809-aead-f8c09a5d1a18} <Debug> TCPHandler: Processed in 0.016615064 sec. | ||
442 | 2024.11.15 20:20:08.120387 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
443 | 2024.11.15 20:20:08.120759 [ 206940 ] {9df5df45-cc11-42a2-84da-60cbe366022f} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
444 | 2024.11.15 20:20:08.120827 [ 206940 ] {9df5df45-cc11-42a2-84da-60cbe366022f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
445 | 2024.11.15 20:20:08.127840 [ 206940 ] {9df5df45-cc11-42a2-84da-60cbe366022f} <Debug> oximeter.measurements_histogramu8 (77b1b0d8-6a9f-4da6-9748-babe512e6f20): Loading data parts | ||
446 | 2024.11.15 20:20:08.128165 [ 206940 ] {9df5df45-cc11-42a2-84da-60cbe366022f} <Debug> oximeter.measurements_histogramu8 (77b1b0d8-6a9f-4da6-9748-babe512e6f20): There are no data parts | ||
447 | 2024.11.15 20:20:08.134024 [ 206940 ] {9df5df45-cc11-42a2-84da-60cbe366022f} <Debug> TCPHandler: Processed in 0.013811101 sec. | ||
448 | 2024.11.15 20:20:08.134791 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
449 | 2024.11.15 20:20:08.135137 [ 207043 ] {62ce590d-b0c2-4ee7-8206-89a29e587aa6} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
450 | 2024.11.15 20:20:08.135200 [ 207043 ] {62ce590d-b0c2-4ee7-8206-89a29e587aa6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
451 | 2024.11.15 20:20:08.141494 [ 207043 ] {62ce590d-b0c2-4ee7-8206-89a29e587aa6} <Debug> oximeter.measurements_histogrami16 (2f25bdce-c65c-4461-a347-fa9491402172): Loading data parts | ||
452 | 2024.11.15 20:20:08.141685 [ 205892 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 46 entries to flush up to offset 46 | ||
453 | 2024.11.15 20:20:08.142271 [ 205892 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
454 | 2024.11.15 20:20:08.142484 [ 207043 ] {62ce590d-b0c2-4ee7-8206-89a29e587aa6} <Debug> oximeter.measurements_histogrami16 (2f25bdce-c65c-4461-a347-fa9491402172): There are no data parts | ||
455 | 2024.11.15 20:20:08.149289 [ 207043 ] {62ce590d-b0c2-4ee7-8206-89a29e587aa6} <Debug> TCPHandler: Processed in 0.014664782 sec. | ||
456 | 2024.11.15 20:20:08.150114 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
457 | 2024.11.15 20:20:08.151983 [ 206940 ] {11a4622a-79fb-4da0-a4a5-bcbe52bc1914} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
458 | 2024.11.15 20:20:08.152177 [ 205892 ] {} <Debug> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): Loading data parts | ||
459 | 2024.11.15 20:20:08.154040 [ 206940 ] {11a4622a-79fb-4da0-a4a5-bcbe52bc1914} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
460 | 2024.11.15 20:20:08.154162 [ 205892 ] {} <Debug> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): There are no data parts | ||
461 | 2024.11.15 20:20:08.159444 [ 206940 ] {11a4622a-79fb-4da0-a4a5-bcbe52bc1914} <Debug> oximeter.measurements_histogramu16 (2c694bdf-3f63-4062-bad6-e6fc12ba5a93): Loading data parts | ||
462 | 2024.11.15 20:20:08.166522 [ 205892 ] {} <Trace> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
463 | 2024.11.15 20:20:08.166560 [ 205892 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.46 GiB. | ||
464 | 2024.11.15 20:20:08.168004 [ 205892 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
465 | 2024.11.15 20:20:08.168263 [ 205892 ] {} <Trace> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
466 | 2024.11.15 20:20:08.169892 [ 206940 ] {11a4622a-79fb-4da0-a4a5-bcbe52bc1914} <Debug> oximeter.measurements_histogramu16 (2c694bdf-3f63-4062-bad6-e6fc12ba5a93): There are no data parts | ||
467 | 2024.11.15 20:20:08.170101 [ 205892 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 46 | ||
468 | 2024.11.15 20:20:08.174292 [ 206940 ] {11a4622a-79fb-4da0-a4a5-bcbe52bc1914} <Debug> TCPHandler: Processed in 0.02435028 sec. | ||
469 | 2024.11.15 20:20:08.175092 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
470 | 2024.11.15 20:20:08.175463 [ 207043 ] {34e4091e-f6a9-4a5a-9558-d129094c636a} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
471 | 2024.11.15 20:20:08.175543 [ 207043 ] {34e4091e-f6a9-4a5a-9558-d129094c636a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
472 | 2024.11.15 20:20:08.180989 [ 207043 ] {34e4091e-f6a9-4a5a-9558-d129094c636a} <Debug> oximeter.measurements_histogrami32 (2670905c-ca5a-4231-98c6-c552444d52c3): Loading data parts | ||
473 | 2024.11.15 20:20:08.181247 [ 207043 ] {34e4091e-f6a9-4a5a-9558-d129094c636a} <Debug> oximeter.measurements_histogrami32 (2670905c-ca5a-4231-98c6-c552444d52c3): There are no data parts | ||
474 | 2024.11.15 20:20:08.184954 [ 207043 ] {34e4091e-f6a9-4a5a-9558-d129094c636a} <Debug> TCPHandler: Processed in 0.010030108 sec. | ||
475 | 2024.11.15 20:20:08.185700 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
476 | 2024.11.15 20:20:08.185999 [ 206940 ] {876ce5f3-53e1-41b0-8dae-426a51060831} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
477 | 2024.11.15 20:20:08.186047 [ 206940 ] {876ce5f3-53e1-41b0-8dae-426a51060831} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
478 | 2024.11.15 20:20:08.192959 [ 206940 ] {876ce5f3-53e1-41b0-8dae-426a51060831} <Debug> oximeter.measurements_histogramu32 (5f0a86e3-64ed-4ff6-b630-811ed02c073c): Loading data parts | ||
479 | 2024.11.15 20:20:08.193317 [ 206940 ] {876ce5f3-53e1-41b0-8dae-426a51060831} <Debug> oximeter.measurements_histogramu32 (5f0a86e3-64ed-4ff6-b630-811ed02c073c): There are no data parts | ||
480 | 2024.11.15 20:20:08.196692 [ 206940 ] {876ce5f3-53e1-41b0-8dae-426a51060831} <Debug> TCPHandler: Processed in 0.011165918 sec. | ||
481 | 2024.11.15 20:20:08.197457 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
482 | 2024.11.15 20:20:08.197778 [ 207043 ] {2e4faf45-e38c-4ad8-ad4d-f34f0257ee80} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
483 | 2024.11.15 20:20:08.197835 [ 207043 ] {2e4faf45-e38c-4ad8-ad4d-f34f0257ee80} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
484 | 2024.11.15 20:20:08.207092 [ 207043 ] {2e4faf45-e38c-4ad8-ad4d-f34f0257ee80} <Debug> oximeter.measurements_histogrami64 (622d660c-51e1-49d3-8216-f8ecf74bb7e4): Loading data parts | ||
485 | 2024.11.15 20:20:08.207382 [ 207043 ] {2e4faf45-e38c-4ad8-ad4d-f34f0257ee80} <Debug> oximeter.measurements_histogrami64 (622d660c-51e1-49d3-8216-f8ecf74bb7e4): There are no data parts | ||
486 | 2024.11.15 20:20:08.213065 [ 207043 ] {2e4faf45-e38c-4ad8-ad4d-f34f0257ee80} <Debug> TCPHandler: Processed in 0.015763353 sec. | ||
487 | 2024.11.15 20:20:08.213888 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
488 | 2024.11.15 20:20:08.214231 [ 206940 ] {b4c5ce25-c396-436e-afc3-ed6c329d20f5} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
489 | 2024.11.15 20:20:08.214290 [ 206940 ] {b4c5ce25-c396-436e-afc3-ed6c329d20f5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
490 | 2024.11.15 20:20:08.219330 [ 206940 ] {b4c5ce25-c396-436e-afc3-ed6c329d20f5} <Debug> oximeter.measurements_histogramu64 (92ef118f-69bd-43a0-92a3-f25e4928e32f): Loading data parts | ||
491 | 2024.11.15 20:20:08.219602 [ 206940 ] {b4c5ce25-c396-436e-afc3-ed6c329d20f5} <Debug> oximeter.measurements_histogramu64 (92ef118f-69bd-43a0-92a3-f25e4928e32f): There are no data parts | ||
492 | 2024.11.15 20:20:08.223196 [ 206940 ] {b4c5ce25-c396-436e-afc3-ed6c329d20f5} <Debug> TCPHandler: Processed in 0.009472348 sec. | ||
493 | 2024.11.15 20:20:08.223960 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
494 | 2024.11.15 20:20:08.224350 [ 207043 ] {08c27e39-6af4-4a3b-8600-c996f66869b5} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
495 | 2024.11.15 20:20:08.224419 [ 207043 ] {08c27e39-6af4-4a3b-8600-c996f66869b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
496 | 2024.11.15 20:20:08.229606 [ 207043 ] {08c27e39-6af4-4a3b-8600-c996f66869b5} <Debug> oximeter.measurements_histogramf32 (7de5145b-02b8-40b0-8252-244cb6a1d84f): Loading data parts | ||
497 | 2024.11.15 20:20:08.231453 [ 207043 ] {08c27e39-6af4-4a3b-8600-c996f66869b5} <Debug> oximeter.measurements_histogramf32 (7de5145b-02b8-40b0-8252-244cb6a1d84f): There are no data parts | ||
498 | 2024.11.15 20:20:08.239460 [ 207043 ] {08c27e39-6af4-4a3b-8600-c996f66869b5} <Debug> TCPHandler: Processed in 0.015654762 sec. | ||
499 | 2024.11.15 20:20:08.246179 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
500 | 2024.11.15 20:20:08.246543 [ 206940 ] {f15ff675-c4fb-451b-9e53-b3a39b5b3134} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
501 | 2024.11.15 20:20:08.246607 [ 206940 ] {f15ff675-c4fb-451b-9e53-b3a39b5b3134} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
502 | 2024.11.15 20:20:08.256424 [ 206940 ] {f15ff675-c4fb-451b-9e53-b3a39b5b3134} <Debug> oximeter.measurements_histogramf64 (8885940a-5f4e-4fbd-8b41-8fedfc9cc363): Loading data parts | ||
503 | 2024.11.15 20:20:08.256685 [ 206940 ] {f15ff675-c4fb-451b-9e53-b3a39b5b3134} <Debug> oximeter.measurements_histogramf64 (8885940a-5f4e-4fbd-8b41-8fedfc9cc363): There are no data parts | ||
504 | 2024.11.15 20:20:08.260266 [ 206940 ] {f15ff675-c4fb-451b-9e53-b3a39b5b3134} <Debug> TCPHandler: Processed in 0.014254522 sec. | ||
505 | 2024.11.15 20:20:08.261277 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
506 | 2024.11.15 20:20:08.262330 [ 207043 ] {15b94bfc-7208-4183-82f6-dd363b692d5c} <Debug> executeQuery: (from [::1]:58646) /* The field tables store named dimensions of each timeseries. | ||
507 | * | ||
508 | * As with the measurement tables, there is one field table for each field data | ||
509 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
510 | * this behavior **must not** be relied upon for query correctness. | ||
511 | * | ||
512 | * The index for the fields differs from the measurements, however. Rows are | ||
513 | * sorted by timeseries name, then field name, field value, and finally | ||
514 | * timeseries key. This reflects the most common pattern for looking them up: | ||
515 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
516 | * usually then used to look up measurements. | ||
517 | * | ||
518 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
519 | * timeseries name and then key, since it would improve lookups where one | ||
520 | * already has the key. Realistically though, these tables are quite small and | ||
521 | * so performance benefits will be low in absolute terms. | ||
522 | * | ||
523 | * TTL: We use a materialized column to expire old field table records. This | ||
524 | * column is generated automatically by the database whenever a new row is | ||
525 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
526 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
527 | * record will remain during a deduplication, which will have the last | ||
528 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
529 | * measurement tables. | ||
530 | */ | ||
531 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
532 | 2024.11.15 20:20:08.262424 [ 207043 ] {15b94bfc-7208-4183-82f6-dd363b692d5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
533 | 2024.11.15 20:20:08.268570 [ 207043 ] {15b94bfc-7208-4183-82f6-dd363b692d5c} <Debug> oximeter.fields_bool (30ad0125-f760-444c-beea-9b8c332451d0): Loading data parts | ||
534 | 2024.11.15 20:20:08.268806 [ 207043 ] {15b94bfc-7208-4183-82f6-dd363b692d5c} <Debug> oximeter.fields_bool (30ad0125-f760-444c-beea-9b8c332451d0): There are no data parts | ||
535 | 2024.11.15 20:20:08.275090 [ 207043 ] {15b94bfc-7208-4183-82f6-dd363b692d5c} <Debug> TCPHandler: Processed in 0.013958492 sec. | ||
536 | 2024.11.15 20:20:08.312955 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
537 | 2024.11.15 20:20:08.313282 [ 206940 ] {f2e78a7f-d38b-4503-b2b0-f7814974bf68} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
538 | 2024.11.15 20:20:08.313352 [ 206940 ] {f2e78a7f-d38b-4503-b2b0-f7814974bf68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
539 | 2024.11.15 20:20:08.317408 [ 206940 ] {f2e78a7f-d38b-4503-b2b0-f7814974bf68} <Debug> oximeter.fields_i8 (93b2cfb3-ef4a-4b6e-9d06-584a133e375e): Loading data parts | ||
540 | 2024.11.15 20:20:08.320337 [ 206940 ] {f2e78a7f-d38b-4503-b2b0-f7814974bf68} <Debug> oximeter.fields_i8 (93b2cfb3-ef4a-4b6e-9d06-584a133e375e): There are no data parts | ||
541 | 2024.11.15 20:20:08.324035 [ 206940 ] {f2e78a7f-d38b-4503-b2b0-f7814974bf68} <Debug> TCPHandler: Processed in 0.011258909 sec. | ||
542 | 2024.11.15 20:20:08.325087 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
543 | 2024.11.15 20:20:08.326039 [ 207043 ] {77df774b-6887-47de-8edd-69aa37d879cd} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
544 | 2024.11.15 20:20:08.326094 [ 207043 ] {77df774b-6887-47de-8edd-69aa37d879cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
545 | 2024.11.15 20:20:08.331510 [ 207043 ] {77df774b-6887-47de-8edd-69aa37d879cd} <Debug> oximeter.fields_u8 (bc34062e-f89c-422e-be5d-ea1686cb419b): Loading data parts | ||
546 | 2024.11.15 20:20:08.331818 [ 207043 ] {77df774b-6887-47de-8edd-69aa37d879cd} <Debug> oximeter.fields_u8 (bc34062e-f89c-422e-be5d-ea1686cb419b): There are no data parts | ||
547 | 2024.11.15 20:20:08.335457 [ 207043 ] {77df774b-6887-47de-8edd-69aa37d879cd} <Debug> TCPHandler: Processed in 0.010517438 sec. | ||
548 | 2024.11.15 20:20:08.344074 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
549 | 2024.11.15 20:20:08.344377 [ 206940 ] {79ba690c-bd3d-4515-a8ac-426b907d1ddc} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
550 | 2024.11.15 20:20:08.344432 [ 206940 ] {79ba690c-bd3d-4515-a8ac-426b907d1ddc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
551 | 2024.11.15 20:20:08.349408 [ 206940 ] {79ba690c-bd3d-4515-a8ac-426b907d1ddc} <Debug> oximeter.fields_i16 (4ba993f7-19ac-4672-9a12-0cc585f7b9d1): Loading data parts | ||
552 | 2024.11.15 20:20:08.355236 [ 206940 ] {79ba690c-bd3d-4515-a8ac-426b907d1ddc} <Debug> oximeter.fields_i16 (4ba993f7-19ac-4672-9a12-0cc585f7b9d1): There are no data parts | ||
553 | 2024.11.15 20:20:08.361314 [ 206940 ] {79ba690c-bd3d-4515-a8ac-426b907d1ddc} <Debug> TCPHandler: Processed in 0.017426484 sec. | ||
554 | 2024.11.15 20:20:08.374167 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
555 | 2024.11.15 20:20:08.374478 [ 207043 ] {295b0b89-c73b-4aef-a117-51bf6ae59839} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
556 | 2024.11.15 20:20:08.374532 [ 207043 ] {295b0b89-c73b-4aef-a117-51bf6ae59839} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
557 | 2024.11.15 20:20:08.379268 [ 207043 ] {295b0b89-c73b-4aef-a117-51bf6ae59839} <Debug> oximeter.fields_u16 (714cb54e-36a1-4b76-8ab5-6c36e843a43e): Loading data parts | ||
558 | 2024.11.15 20:20:08.379478 [ 207043 ] {295b0b89-c73b-4aef-a117-51bf6ae59839} <Debug> oximeter.fields_u16 (714cb54e-36a1-4b76-8ab5-6c36e843a43e): There are no data parts | ||
559 | 2024.11.15 20:20:08.383261 [ 207043 ] {295b0b89-c73b-4aef-a117-51bf6ae59839} <Debug> TCPHandler: Processed in 0.009271428 sec. | ||
560 | 2024.11.15 20:20:08.389144 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
561 | 2024.11.15 20:20:08.389416 [ 206940 ] {8c596213-81c6-4965-8666-71a746eaf727} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
562 | 2024.11.15 20:20:08.389461 [ 206940 ] {8c596213-81c6-4965-8666-71a746eaf727} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
563 | 2024.11.15 20:20:08.393306 [ 206940 ] {8c596213-81c6-4965-8666-71a746eaf727} <Debug> oximeter.fields_i32 (329c5e84-fbeb-4fec-a51b-129755367d42): Loading data parts | ||
564 | 2024.11.15 20:20:08.393535 [ 206940 ] {8c596213-81c6-4965-8666-71a746eaf727} <Debug> oximeter.fields_i32 (329c5e84-fbeb-4fec-a51b-129755367d42): There are no data parts | ||
565 | 2024.11.15 20:20:08.398902 [ 206940 ] {8c596213-81c6-4965-8666-71a746eaf727} <Debug> TCPHandler: Processed in 0.009926258 sec. | ||
566 | 2024.11.15 20:20:08.400342 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
567 | 2024.11.15 20:20:08.400656 [ 207043 ] {6d54baae-8404-4d19-877f-da112d32700a} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
568 | 2024.11.15 20:20:08.400711 [ 207043 ] {6d54baae-8404-4d19-877f-da112d32700a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
569 | 2024.11.15 20:20:08.405400 [ 207043 ] {6d54baae-8404-4d19-877f-da112d32700a} <Debug> oximeter.fields_u32 (e1f1096f-c6ff-4294-97ea-553a29e8f23b): Loading data parts | ||
570 | 2024.11.15 20:20:08.405666 [ 207043 ] {6d54baae-8404-4d19-877f-da112d32700a} <Debug> oximeter.fields_u32 (e1f1096f-c6ff-4294-97ea-553a29e8f23b): There are no data parts | ||
571 | 2024.11.15 20:20:08.410219 [ 207043 ] {6d54baae-8404-4d19-877f-da112d32700a} <Debug> TCPHandler: Processed in 0.010018108 sec. | ||
572 | 2024.11.15 20:20:08.410927 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
573 | 2024.11.15 20:20:08.411171 [ 206940 ] {eb0e27d7-d06e-4873-a7dd-3bc5981f0354} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
574 | 2024.11.15 20:20:08.411213 [ 206940 ] {eb0e27d7-d06e-4873-a7dd-3bc5981f0354} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
575 | 2024.11.15 20:20:08.415282 [ 206940 ] {eb0e27d7-d06e-4873-a7dd-3bc5981f0354} <Debug> oximeter.fields_i64 (9bcd26b9-678e-4b6a-a611-795732ed2fe3): Loading data parts | ||
576 | 2024.11.15 20:20:08.415571 [ 206940 ] {eb0e27d7-d06e-4873-a7dd-3bc5981f0354} <Debug> oximeter.fields_i64 (9bcd26b9-678e-4b6a-a611-795732ed2fe3): There are no data parts | ||
577 | 2024.11.15 20:20:08.419369 [ 206940 ] {eb0e27d7-d06e-4873-a7dd-3bc5981f0354} <Debug> TCPHandler: Processed in 0.008577117 sec. | ||
578 | 2024.11.15 20:20:08.420065 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
579 | 2024.11.15 20:20:08.420296 [ 207043 ] {d0bb476d-ff84-49ab-8146-5926d7d2abde} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
580 | 2024.11.15 20:20:08.420342 [ 207043 ] {d0bb476d-ff84-49ab-8146-5926d7d2abde} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
581 | 2024.11.15 20:20:08.425355 [ 207043 ] {d0bb476d-ff84-49ab-8146-5926d7d2abde} <Debug> oximeter.fields_u64 (71e827d2-1646-4283-a2ea-cade57328cc1): Loading data parts | ||
582 | 2024.11.15 20:20:08.425556 [ 207043 ] {d0bb476d-ff84-49ab-8146-5926d7d2abde} <Debug> oximeter.fields_u64 (71e827d2-1646-4283-a2ea-cade57328cc1): There are no data parts | ||
583 | 2024.11.15 20:20:08.430232 [ 207043 ] {d0bb476d-ff84-49ab-8146-5926d7d2abde} <Debug> TCPHandler: Processed in 0.010338419 sec. | ||
584 | 2024.11.15 20:20:08.431148 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
585 | 2024.11.15 20:20:08.431394 [ 206940 ] {fd5ea3d2-2c17-4d59-b248-87e72666f846} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
586 | 2024.11.15 20:20:08.431441 [ 206940 ] {fd5ea3d2-2c17-4d59-b248-87e72666f846} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
587 | 2024.11.15 20:20:08.436841 [ 206940 ] {fd5ea3d2-2c17-4d59-b248-87e72666f846} <Debug> oximeter.fields_ipaddr (32f0f458-fd48-45a5-9962-2f460692f4aa): Loading data parts | ||
588 | 2024.11.15 20:20:08.437126 [ 206940 ] {fd5ea3d2-2c17-4d59-b248-87e72666f846} <Debug> oximeter.fields_ipaddr (32f0f458-fd48-45a5-9962-2f460692f4aa): There are no data parts | ||
589 | 2024.11.15 20:20:08.441929 [ 206940 ] {fd5ea3d2-2c17-4d59-b248-87e72666f846} <Debug> TCPHandler: Processed in 0.010914289 sec. | ||
590 | 2024.11.15 20:20:08.446500 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
591 | 2024.11.15 20:20:08.446771 [ 207043 ] {6128d816-6b37-4c1b-a020-cccf2a678735} <Debug> executeQuery: (from [::1]:58646) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
592 | 2024.11.15 20:20:08.447801 [ 207043 ] {6128d816-6b37-4c1b-a020-cccf2a678735} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
593 | 2024.11.15 20:20:08.452330 [ 207043 ] {6128d816-6b37-4c1b-a020-cccf2a678735} <Debug> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Loading data parts | ||
594 | 2024.11.15 20:20:08.452581 [ 207043 ] {6128d816-6b37-4c1b-a020-cccf2a678735} <Debug> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): There are no data parts | ||
595 | 2024.11.15 20:20:08.456267 [ 207043 ] {6128d816-6b37-4c1b-a020-cccf2a678735} <Debug> TCPHandler: Processed in 0.009959377 sec. | ||
596 | 2024.11.15 20:20:08.456986 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
597 | 2024.11.15 20:20:08.457220 [ 206940 ] {c23c7297-e6c9-46f7-9f91-4855ba7f8d57} <Debug> executeQuery: (from [::1]:58636) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
598 | 2024.11.15 20:20:08.457267 [ 206940 ] {c23c7297-e6c9-46f7-9f91-4855ba7f8d57} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
599 | 2024.11.15 20:20:08.464676 [ 206940 ] {c23c7297-e6c9-46f7-9f91-4855ba7f8d57} <Debug> oximeter.fields_uuid (b5b1029e-fb52-48f4-8146-5275f2315816): Loading data parts | ||
600 | 2024.11.15 20:20:08.465066 [ 206940 ] {c23c7297-e6c9-46f7-9f91-4855ba7f8d57} <Debug> oximeter.fields_uuid (b5b1029e-fb52-48f4-8146-5275f2315816): There are no data parts | ||
601 | 2024.11.15 20:20:08.469531 [ 206940 ] {c23c7297-e6c9-46f7-9f91-4855ba7f8d57} <Debug> TCPHandler: Processed in 0.01267215 sec. | ||
602 | 2024.11.15 20:20:08.471263 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
603 | 2024.11.15 20:20:08.471596 [ 207043 ] {536b5ad0-a186-4016-b12a-d3a05f20eb30} <Debug> executeQuery: (from [::1]:58646) /* The timeseries schema table stores the extracted schema for the samples | ||
604 | * oximeter collects. | ||
605 | */ | ||
606 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
607 | 2024.11.15 20:20:08.471668 [ 207043 ] {536b5ad0-a186-4016-b12a-d3a05f20eb30} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
608 | 2024.11.15 20:20:08.477860 [ 207043 ] {536b5ad0-a186-4016-b12a-d3a05f20eb30} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): Loading data parts | ||
609 | 2024.11.15 20:20:08.478131 [ 207043 ] {536b5ad0-a186-4016-b12a-d3a05f20eb30} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): There are no data parts | ||
610 | 2024.11.15 20:20:08.481939 [ 207043 ] {536b5ad0-a186-4016-b12a-d3a05f20eb30} <Debug> TCPHandler: Processed in 0.010834659 sec. | ||
611 | 2024.11.15 20:20:08.483626 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
612 | 2024.11.15 20:20:08.483923 [ 206940 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
613 | 2024.11.15 20:20:08.484012 [ 206940 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
614 | 2024.11.15 20:20:08.484822 [ 207061 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Trace> oximeter.version (6162af12-eb27-4a0b-973d-db551e80b56a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
615 | 2024.11.15 20:20:08.484849 [ 207061 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.46 GiB. | ||
616 | 2024.11.15 20:20:08.485197 [ 207061 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
617 | 2024.11.15 20:20:08.516676 [ 207061 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Trace> oximeter.version (6162af12-eb27-4a0b-973d-db551e80b56a): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
618 | 2024.11.15 20:20:08.516925 [ 206940 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.033044 sec., 30.262680062946377 rows/sec., 484.20 B/sec. | ||
619 | 2024.11.15 20:20:08.517097 [ 206940 ] {b3f0f2e0-1d34-4fa5-9fc3-0f36b33d6d79} <Debug> TCPHandler: Processed in 0.033607147 sec. | ||
620 | 2024.11.15 20:20:09.588461 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
621 | 2024.11.15 20:20:09.588685 [ 206940 ] {b86216d4-ff55-415c-be3c-7795f3255562} <Debug> executeQuery: (from [::1]:58636) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
622 | 2024.11.15 20:20:09.590260 [ 206940 ] {b86216d4-ff55-415c-be3c-7795f3255562} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
623 | 2024.11.15 20:20:09.590322 [ 206940 ] {b86216d4-ff55-415c-be3c-7795f3255562} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
624 | 2024.11.15 20:20:09.590856 [ 206940 ] {b86216d4-ff55-415c-be3c-7795f3255562} <Debug> TCPHandler: Processed in 0.002580062 sec. | ||
625 | 2024.11.15 20:20:09.602691 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
626 | 2024.11.15 20:20:09.602873 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
627 | 2024.11.15 20:20:09.602941 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
628 | 2024.11.15 20:20:09.605620 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
629 | 2024.11.15 20:20:09.605654 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
630 | 2024.11.15 20:20:09.608625 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
631 | 2024.11.15 20:20:09.608854 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
632 | 2024.11.15 20:20:09.609046 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.006228 sec., 160.56518946692358 rows/sec., 19.29 KiB/sec. | ||
633 | 2024.11.15 20:20:09.609092 [ 207043 ] {28c673a7-5fd4-4cdd-9d48-75b5aaaf909e} <Debug> TCPHandler: Processed in 0.006474635 sec. | ||
634 | 2024.11.15 20:20:09.629991 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
635 | 2024.11.15 20:20:09.630186 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
636 | 2024.11.15 20:20:09.630244 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
637 | 2024.11.15 20:20:09.636996 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
638 | 2024.11.15 20:20:09.637036 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
639 | 2024.11.15 20:20:09.637442 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
640 | 2024.11.15 20:20:09.642332 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
641 | 2024.11.15 20:20:09.642594 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.012462 sec., 160.48788316482106 rows/sec., 16.61 KiB/sec. | ||
642 | 2024.11.15 20:20:09.642658 [ 206940 ] {b8701bc7-2073-43c7-8763-9a6a648768b8} <Debug> TCPHandler: Processed in 0.01283934 sec. | ||
643 | 2024.11.15 20:20:09.643957 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
644 | 2024.11.15 20:20:09.644117 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
645 | 2024.11.15 20:20:09.644181 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
646 | 2024.11.15 20:20:09.645231 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
647 | 2024.11.15 20:20:09.645693 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
648 | 2024.11.15 20:20:09.646085 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
649 | 2024.11.15 20:20:09.646279 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
650 | 2024.11.15 20:20:09.646552 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002488 sec., 401.92926045016077 rows/sec., 27.87 KiB/sec. | ||
651 | 2024.11.15 20:20:09.646592 [ 207043 ] {644a561c-cc2f-4fc1-9701-e8ed0015b720} <Debug> TCPHandler: Processed in 0.002808332 sec. | ||
652 | 2024.11.15 20:20:10.520003 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
653 | 2024.11.15 20:20:10.520229 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
654 | 2024.11.15 20:20:10.521132 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
655 | 2024.11.15 20:20:10.522170 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
656 | 2024.11.15 20:20:10.523262 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
657 | 2024.11.15 20:20:10.523704 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
658 | 2024.11.15 20:20:10.525138 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
659 | 2024.11.15 20:20:10.525348 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.005176 sec., 386.39876352395675 rows/sec., 40.00 KiB/sec. | ||
660 | 2024.11.15 20:20:10.525393 [ 206940 ] {e0bc9418-0635-4026-a4ef-30336cbcfe2c} <Debug> TCPHandler: Processed in 0.005577554 sec. | ||
661 | 2024.11.15 20:20:10.526250 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
662 | 2024.11.15 20:20:10.527309 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
663 | 2024.11.15 20:20:10.527366 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
664 | 2024.11.15 20:20:10.537518 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
665 | 2024.11.15 20:20:10.537548 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
666 | 2024.11.15 20:20:10.537953 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
667 | 2024.11.15 20:20:10.538159 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
668 | 2024.11.15 20:20:10.538350 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.011085 sec., 90.21199819576005 rows/sec., 6.25 KiB/sec. | ||
669 | 2024.11.15 20:20:10.539151 [ 207043 ] {0dfd8a40-344b-4fa0-92ec-07771f913556} <Debug> TCPHandler: Processed in 0.01302041 sec. | ||
670 | 2024.11.15 20:20:10.911456 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
671 | 2024.11.15 20:20:10.911683 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Debug> executeQuery: (from [::1]:58636) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
672 | 2024.11.15 20:20:10.912005 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
673 | 2024.11.15 20:20:10.912021 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('integration_target:integration_metric')" moved to PREWHERE | ||
674 | 2024.11.15 20:20:10.912205 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
675 | 2024.11.15 20:20:10.912258 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
676 | 2024.11.15 20:20:10.912394 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Key condition: (column 0 notIn 1-element set) | ||
677 | 2024.11.15 20:20:10.914172 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
678 | 2024.11.15 20:20:10.914201 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
679 | 2024.11.15 20:20:10.914735 [ 206940 ] {af57cef6-cf5b-4aff-97d7-6584c40d959f} <Debug> TCPHandler: Processed in 0.003472213 sec. | ||
680 | 2024.11.15 20:20:10.922671 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
681 | 2024.11.15 20:20:10.922893 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Debug> executeQuery: (from [::1]:58646) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
682 | 2024.11.15 20:20:10.923178 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
683 | 2024.11.15 20:20:10.923203 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
684 | 2024.11.15 20:20:10.923393 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
685 | 2024.11.15 20:20:10.923450 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
686 | 2024.11.15 20:20:10.923580 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Key condition: (column 0 notIn 2-element set) | ||
687 | 2024.11.15 20:20:10.923608 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
688 | 2024.11.15 20:20:10.923624 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
689 | 2024.11.15 20:20:10.924331 [ 207043 ] {68ea5ce8-e649-4ccb-bc8f-17857fea81ad} <Debug> TCPHandler: Processed in 0.001828761 sec. | ||
690 | 2024.11.15 20:20:10.928739 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
691 | 2024.11.15 20:20:10.928948 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Debug> executeQuery: (from [::1]:58636) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('collection_target:cpus_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
692 | 2024.11.15 20:20:10.930059 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
693 | 2024.11.15 20:20:10.930084 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('collection_target:cpus_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
694 | 2024.11.15 20:20:10.930246 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
695 | 2024.11.15 20:20:10.930298 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
696 | 2024.11.15 20:20:10.930424 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Key condition: (column 0 notIn 3-element set) | ||
697 | 2024.11.15 20:20:10.930446 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
698 | 2024.11.15 20:20:10.930459 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
699 | 2024.11.15 20:20:10.930937 [ 206940 ] {76a71d4c-7128-498b-8259-2d04e9fc5b1d} <Debug> TCPHandler: Processed in 0.002331452 sec. | ||
700 | 2024.11.15 20:20:10.948755 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
701 | 2024.11.15 20:20:10.948999 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Debug> executeQuery: (from [::1]:58646) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('collection_target:cpus_provisioned', 'collection_target:ram_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
702 | 2024.11.15 20:20:10.949280 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
703 | 2024.11.15 20:20:10.949314 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('collection_target:cpus_provisioned', 'collection_target:ram_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
704 | 2024.11.15 20:20:10.949564 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
705 | 2024.11.15 20:20:10.949631 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
706 | 2024.11.15 20:20:10.949807 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Key condition: (column 0 notIn 4-element set) | ||
707 | 2024.11.15 20:20:10.949839 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
708 | 2024.11.15 20:20:10.951730 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Debug> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
709 | 2024.11.15 20:20:10.952285 [ 207043 ] {1a91ae1a-d09f-49ff-a633-d6b87783a421} <Debug> TCPHandler: Processed in 0.003711413 sec. | ||
710 | 2024.11.15 20:20:10.973694 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
711 | 2024.11.15 20:20:10.973885 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
712 | 2024.11.15 20:20:10.973952 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
713 | 2024.11.15 20:20:10.977227 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
714 | 2024.11.15 20:20:10.977263 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
715 | 2024.11.15 20:20:10.977815 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
716 | 2024.11.15 20:20:10.977998 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Trace> oximeter.timeseries_schema (e12cfb76-ed10-4cd0-9c2f-3dbea1d61d6d): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
717 | 2024.11.15 20:20:10.978200 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Debug> executeQuery: Read 4 rows, 433.00 B in 0.004369 sec., 915.5413138017853 rows/sec., 96.78 KiB/sec. | ||
718 | 2024.11.15 20:20:10.978254 [ 206940 ] {01f23dfe-b65f-4abf-9154-612846e8f49a} <Debug> TCPHandler: Processed in 0.004679944 sec. | ||
719 | 2024.11.15 20:20:10.981060 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
720 | 2024.11.15 20:20:10.982055 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
721 | 2024.11.15 20:20:10.982111 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
722 | 2024.11.15 20:20:10.983139 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
723 | 2024.11.15 20:20:10.983160 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
724 | 2024.11.15 20:20:10.983542 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
725 | 2024.11.15 20:20:10.983782 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
726 | 2024.11.15 20:20:10.983980 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Debug> executeQuery: Read 10 rows, 984.00 B in 0.001976 sec., 5060.728744939272 rows/sec., 486.30 KiB/sec. | ||
727 | 2024.11.15 20:20:10.984019 [ 207043 ] {108f03e4-ff42-4d09-9d56-150a21dfec4e} <Debug> TCPHandler: Processed in 0.003104652 sec. | ||
728 | 2024.11.15 20:20:10.987433 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
729 | 2024.11.15 20:20:10.987576 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_u16 FORMAT Native (stage: Complete) | ||
730 | 2024.11.15 20:20:10.987626 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_u16 | ||
731 | 2024.11.15 20:20:10.988624 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Trace> oximeter.fields_u16 (714cb54e-36a1-4b76-8ab5-6c36e843a43e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
732 | 2024.11.15 20:20:10.988654 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
733 | 2024.11.15 20:20:10.989083 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
734 | 2024.11.15 20:20:10.989278 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Trace> oximeter.fields_u16 (714cb54e-36a1-4b76-8ab5-6c36e843a43e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
735 | 2024.11.15 20:20:10.989432 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Debug> executeQuery: Read 5 rows, 385.00 B in 0.001899 sec., 2632.964718272775 rows/sec., 197.99 KiB/sec. | ||
736 | 2024.11.15 20:20:10.989467 [ 206940 ] {0641dbdd-6043-4104-89f3-c3f34f4e7591} <Debug> TCPHandler: Processed in 0.002120402 sec. | ||
737 | 2024.11.15 20:20:10.990618 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
738 | 2024.11.15 20:20:10.991141 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.fields_uuid FORMAT Native (stage: Complete) | ||
739 | 2024.11.15 20:20:10.991186 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_uuid | ||
740 | 2024.11.15 20:20:10.993512 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Trace> oximeter.fields_uuid (b5b1029e-fb52-48f4-8146-5275f2315816): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
741 | 2024.11.15 20:20:11.009896 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
742 | 2024.11.15 20:20:11.010381 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
743 | 2024.11.15 20:20:11.010619 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Trace> oximeter.fields_uuid (b5b1029e-fb52-48f4-8146-5275f2315816): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
744 | 2024.11.15 20:20:11.010835 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Debug> executeQuery: Read 17 rows, 1.37 KiB in 0.019723 sec., 861.9378390711352 rows/sec., 69.22 KiB/sec. | ||
745 | 2024.11.15 20:20:11.010893 [ 207043 ] {5e16cfb0-affd-4de4-a197-9c287fe89b1c} <Debug> TCPHandler: Processed in 0.020359036 sec. | ||
746 | 2024.11.15 20:20:11.004832 [ 205898 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 393.95 MiB, peak 394.30 MiB, free memory in arenas 23.50 MiB, will set to 387.67 MiB (RSS), difference: -6.28 MiB | ||
747 | 2024.11.15 20:20:11.012461 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
748 | 2024.11.15 20:20:11.012608 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.measurements_histogramu64 FORMAT Native (stage: Complete) | ||
749 | 2024.11.15 20:20:11.012673 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, start_time, timestamp, bins, counts, min, max, sum_of_samples, squared_mean, p50_marker_heights, p50_marker_positions, p50_desired_marker_positions, p90_marker_heights, p90_marker_positions, p90_desired_marker_positions, p99_marker_heights, p99_marker_positions, p99_desired_marker_positions) ON oximeter.measurements_histogramu64 | ||
750 | 2024.11.15 20:20:11.014497 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Trace> oximeter.measurements_histogramu64 (92ef118f-69bd-43a0-92a3-f25e4928e32f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
751 | 2024.11.15 20:20:11.014520 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
752 | 2024.11.15 20:20:11.017617 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
753 | 2024.11.15 20:20:11.017841 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Trace> oximeter.measurements_histogramu64 (92ef118f-69bd-43a0-92a3-f25e4928e32f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
754 | 2024.11.15 20:20:11.018054 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Debug> executeQuery: Read 5 rows, 9.17 KiB in 0.005477 sec., 912.9085265656381 rows/sec., 1.64 MiB/sec. | ||
755 | 2024.11.15 20:20:11.018139 [ 206940 ] {3ac9ea9f-c061-44dc-8568-4fb8225b9811} <Debug> TCPHandler: Processed in 0.005762935 sec. | ||
756 | 2024.11.15 20:20:11.023977 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
757 | 2024.11.15 20:20:11.024188 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
758 | 2024.11.15 20:20:11.024263 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
759 | 2024.11.15 20:20:11.026489 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
760 | 2024.11.15 20:20:11.027037 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
761 | 2024.11.15 20:20:11.027406 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
762 | 2024.11.15 20:20:11.027579 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
763 | 2024.11.15 20:20:11.027772 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Debug> executeQuery: Read 12 rows, 868.00 B in 0.003648 sec., 3289.4736842105262 rows/sec., 232.36 KiB/sec. | ||
764 | 2024.11.15 20:20:11.027811 [ 207043 ] {d5657634-263f-4dc8-ae6e-2793731b77f5} <Debug> TCPHandler: Processed in 0.004021103 sec. | ||
765 | 2024.11.15 20:20:12.524344 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
766 | 2024.11.15 20:20:12.524555 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
767 | 2024.11.15 20:20:12.524619 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
768 | 2024.11.15 20:20:12.533066 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
769 | 2024.11.15 20:20:12.533100 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
770 | 2024.11.15 20:20:12.533525 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
771 | 2024.11.15 20:20:12.533709 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
772 | 2024.11.15 20:20:12.533902 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.009432 sec., 212.04410517387618 rows/sec., 21.95 KiB/sec. | ||
773 | 2024.11.15 20:20:12.533956 [ 206940 ] {06d6742d-1478-45d7-95e4-69f5ef7484b3} <Debug> TCPHandler: Processed in 0.009779977 sec. | ||
774 | 2024.11.15 20:20:12.538024 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
775 | 2024.11.15 20:20:12.538176 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
776 | 2024.11.15 20:20:12.538223 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
777 | 2024.11.15 20:20:12.543406 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
778 | 2024.11.15 20:20:12.543450 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
779 | 2024.11.15 20:20:12.544940 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
780 | 2024.11.15 20:20:12.545168 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
781 | 2024.11.15 20:20:12.545397 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.007261 sec., 137.72207684891887 rows/sec., 9.55 KiB/sec. | ||
782 | 2024.11.15 20:20:12.545465 [ 207043 ] {5244a831-e71a-4c77-b7e3-d2755975afec} <Debug> TCPHandler: Processed in 0.007602747 sec. | ||
783 | 2024.11.15 20:20:13.114672 [ 205810 ] {} <Debug> DNSResolver: Updating DNS cache | ||
784 | 2024.11.15 20:20:13.114703 [ 205810 ] {} <Debug> DNSResolver: Updated DNS cache | ||
785 | 2024.11.15 20:20:14.521030 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
786 | 2024.11.15 20:20:14.521204 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
787 | 2024.11.15 20:20:14.521252 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
788 | 2024.11.15 20:20:14.522122 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
789 | 2024.11.15 20:20:14.522147 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.59 GiB. | ||
790 | 2024.11.15 20:20:14.522455 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
791 | 2024.11.15 20:20:14.522639 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
792 | 2024.11.15 20:20:14.522819 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.00165 sec., 1212.1212121212122 rows/sec., 125.47 KiB/sec. | ||
793 | 2024.11.15 20:20:14.522862 [ 206940 ] {74168931-5ae5-472f-bc52-d69050f51efe} <Debug> TCPHandler: Processed in 0.001925452 sec. | ||
794 | 2024.11.15 20:20:14.523401 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
795 | 2024.11.15 20:20:14.523510 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
796 | 2024.11.15 20:20:14.523544 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
797 | 2024.11.15 20:20:14.524157 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
798 | 2024.11.15 20:20:14.525631 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.59 GiB. | ||
799 | 2024.11.15 20:20:14.525943 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
800 | 2024.11.15 20:20:14.526086 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
801 | 2024.11.15 20:20:14.526252 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002761 sec., 362.18761318362914 rows/sec., 25.11 KiB/sec. | ||
802 | 2024.11.15 20:20:14.526290 [ 207043 ] {b09c2ab7-b661-45ff-81c5-4a8fb3100d81} <Debug> TCPHandler: Processed in 0.002959972 sec. | ||
803 | 2024.11.15 20:20:16.522493 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
804 | 2024.11.15 20:20:16.522684 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
805 | 2024.11.15 20:20:16.522742 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
806 | 2024.11.15 20:20:16.523748 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
807 | 2024.11.15 20:20:16.524053 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
808 | 2024.11.15 20:20:16.524447 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
809 | 2024.11.15 20:20:16.524664 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
810 | 2024.11.15 20:20:16.526106 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003476 sec., 575.3739930955121 rows/sec., 59.56 KiB/sec. | ||
811 | 2024.11.15 20:20:16.526146 [ 206940 ] {80e3bd36-a8ec-4ea6-b7c6-25d8a0542675} <Debug> TCPHandler: Processed in 0.003827354 sec. | ||
812 | 2024.11.15 20:20:16.526250 [ 205792 ] {} <Debug> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6) (MergerMutator): Selected 6 parts from all_1_1_0 to all_6_6_0 | ||
813 | 2024.11.15 20:20:16.527147 [ 205792 ] {} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
814 | 2024.11.15 20:20:16.527169 [ 205792 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
815 | 2024.11.15 20:20:16.527358 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_1_0 to all_6_6_0 into Compact with storage Full | ||
816 | 2024.11.15 20:20:16.527431 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
817 | 2024.11.15 20:20:16.527460 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
818 | 2024.11.15 20:20:16.527536 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
819 | 2024.11.15 20:20:16.527616 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 10 rows starting from the beginning of the part | ||
820 | 2024.11.15 20:20:16.527688 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
821 | 2024.11.15 20:20:16.527764 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
822 | 2024.11.15 20:20:16.527797 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_6_6_0, total 2 rows starting from the beginning of the part | ||
823 | 2024.11.15 20:20:16.530953 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
824 | 2024.11.15 20:20:16.531111 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
825 | 2024.11.15 20:20:16.531170 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
826 | 2024.11.15 20:20:16.531665 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 20 rows, containing 5 columns (5 merged, 0 gathered) in 0.004392313 sec., 4553.409558927153 rows/sec., 472.24 KiB/sec. | ||
827 | 2024.11.15 20:20:16.531855 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Trace> MergedBlockOutputStream: filled checksums all_1_6_1 (state Temporary) | ||
828 | 2024.11.15 20:20:16.532275 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
829 | 2024.11.15 20:20:16.534308 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
830 | 2024.11.15 20:20:16.534615 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
831 | 2024.11.15 20:20:16.534795 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
832 | 2024.11.15 20:20:16.534946 [ 205808 ] {} <Debug> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f) (MergerMutator): Selected 6 parts from all_1_1_0 to all_6_6_0 | ||
833 | 2024.11.15 20:20:16.534973 [ 205808 ] {} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
834 | 2024.11.15 20:20:16.534987 [ 205808 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
835 | 2024.11.15 20:20:16.534999 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003935 sec., 254.12960609911053 rows/sec., 17.62 KiB/sec. | ||
836 | 2024.11.15 20:20:16.535054 [ 207043 ] {e8f1d753-a8a1-4d98-bf51-8413cae74029} <Debug> TCPHandler: Processed in 0.004256744 sec. | ||
837 | 2024.11.15 20:20:16.535180 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_1_0 to all_6_6_0 into Compact with storage Full | ||
838 | 2024.11.15 20:20:16.535262 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
839 | 2024.11.15 20:20:16.535287 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
840 | 2024.11.15 20:20:16.535306 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_merge_all_1_6_1 to all_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
841 | 2024.11.15 20:20:16.535351 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
842 | 2024.11.15 20:20:16.535357 [ 205834 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_6_1} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6) (MergerMutator): Merged 6 parts: [all_1_1_0, all_6_6_0] -> all_1_6_1 | ||
843 | 2024.11.15 20:20:16.535396 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 12 rows starting from the beginning of the part | ||
844 | 2024.11.15 20:20:16.535440 [ 205834 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.35 MiB. | ||
845 | 2024.11.15 20:20:16.535447 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
846 | 2024.11.15 20:20:16.535539 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
847 | 2024.11.15 20:20:16.535608 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_6_6_0, total 1 rows starting from the beginning of the part | ||
848 | 2024.11.15 20:20:16.538236 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 17 rows, containing 4 columns (4 merged, 0 gathered) in 0.003140712 sec., 5412.785381149242 rows/sec., 380.28 KiB/sec. | ||
849 | 2024.11.15 20:20:16.539661 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Trace> MergedBlockOutputStream: filled checksums all_1_6_1 (state Temporary) | ||
850 | 2024.11.15 20:20:16.539888 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_merge_all_1_6_1 to all_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
851 | 2024.11.15 20:20:16.539933 [ 205852 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_6_1} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f) (MergerMutator): Merged 6 parts: [all_1_1_0, all_6_6_0] -> all_1_6_1 | ||
852 | 2024.11.15 20:20:16.539999 [ 205852 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.28 MiB. | ||
853 | 2024.11.15 20:20:17.522613 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
854 | 2024.11.15 20:20:17.522771 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
855 | 2024.11.15 20:20:17.524089 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
856 | 2024.11.15 20:20:17.524940 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
857 | 2024.11.15 20:20:17.525749 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
858 | 2024.11.15 20:20:17.526090 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
859 | 2024.11.15 20:20:17.526318 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
860 | 2024.11.15 20:20:17.526544 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003816 sec., 524.1090146750524 rows/sec., 54.25 KiB/sec. | ||
861 | 2024.11.15 20:20:17.527554 [ 206940 ] {cc34ce90-97b6-4ddf-952d-00ea3d9e2a60} <Debug> TCPHandler: Processed in 0.005043174 sec. | ||
862 | 2024.11.15 20:20:17.528608 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
863 | 2024.11.15 20:20:17.529383 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
864 | 2024.11.15 20:20:17.529424 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
865 | 2024.11.15 20:20:17.529991 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
866 | 2024.11.15 20:20:17.530010 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.32 GiB. | ||
867 | 2024.11.15 20:20:17.531488 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
868 | 2024.11.15 20:20:17.531669 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
869 | 2024.11.15 20:20:17.531861 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002507 sec., 398.8831272437176 rows/sec., 27.66 KiB/sec. | ||
870 | 2024.11.15 20:20:17.531900 [ 207043 ] {e6cfd5e0-1c88-411e-a855-a276470ecead} <Debug> TCPHandler: Processed in 0.003389563 sec. | ||
871 | 2024.11.15 20:20:18.170268 [ 205892 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 92 entries to flush up to offset 138 | ||
872 | 2024.11.15 20:20:18.175027 [ 205892 ] {} <Trace> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
873 | 2024.11.15 20:20:18.175066 [ 205892 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
874 | 2024.11.15 20:20:18.177205 [ 205892 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
875 | 2024.11.15 20:20:18.177515 [ 205892 ] {} <Trace> system.query_log (c736308b-9482-488e-add4-751d8e8fdf1e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
876 | 2024.11.15 20:20:18.177963 [ 205892 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 138 | ||
877 | 2024.11.15 20:20:18.521835 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
878 | 2024.11.15 20:20:18.522015 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
879 | 2024.11.15 20:20:18.523261 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
880 | 2024.11.15 20:20:18.526450 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
881 | 2024.11.15 20:20:18.526476 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
882 | 2024.11.15 20:20:18.526970 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
883 | 2024.11.15 20:20:18.527843 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
884 | 2024.11.15 20:20:18.528088 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.006123 sec., 326.63726931242854 rows/sec., 33.81 KiB/sec. | ||
885 | 2024.11.15 20:20:18.528136 [ 206940 ] {280779f6-1591-4aea-9d28-1264ed7fb14e} <Debug> TCPHandler: Processed in 0.006452175 sec. | ||
886 | 2024.11.15 20:20:18.529924 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
887 | 2024.11.15 20:20:18.530066 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
888 | 2024.11.15 20:20:18.530116 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
889 | 2024.11.15 20:20:18.531136 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
890 | 2024.11.15 20:20:18.531571 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
891 | 2024.11.15 20:20:18.531938 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
892 | 2024.11.15 20:20:18.532137 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
893 | 2024.11.15 20:20:18.532320 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002292 sec., 436.3001745200698 rows/sec., 30.25 KiB/sec. | ||
894 | 2024.11.15 20:20:18.532356 [ 207043 ] {7b238134-7481-4019-af1c-69a75026feaa} <Debug> TCPHandler: Processed in 0.002544462 sec. | ||
895 | 2024.11.15 20:20:19.000800 [ 205898 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 384.92 MiB, peak 394.30 MiB, free memory in arenas 30.82 MiB, will set to 390.06 MiB (RSS), difference: 5.14 MiB | ||
896 | 2024.11.15 20:20:19.534710 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
897 | 2024.11.15 20:20:19.534917 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
898 | 2024.11.15 20:20:19.534999 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
899 | 2024.11.15 20:20:19.562210 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
900 | 2024.11.15 20:20:19.563301 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
901 | 2024.11.15 20:20:19.563745 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Trace> MergedBlockOutputStream: filled checksums all_9_9_0 (state Temporary) | ||
902 | 2024.11.15 20:20:19.563995 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_9_9_0 to all_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
903 | 2024.11.15 20:20:19.564216 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.029355 sec., 68.13149378300119 rows/sec., 7.05 KiB/sec. | ||
904 | 2024.11.15 20:20:19.564281 [ 206940 ] {1ad8e7f5-10ee-4a39-b995-7d72d736aba9} <Debug> TCPHandler: Processed in 0.029763524 sec. | ||
905 | 2024.11.15 20:20:19.605170 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
906 | 2024.11.15 20:20:19.605355 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
907 | 2024.11.15 20:20:19.605415 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
908 | 2024.11.15 20:20:19.608376 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
909 | 2024.11.15 20:20:19.608402 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
910 | 2024.11.15 20:20:19.608847 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Trace> MergedBlockOutputStream: filled checksums all_9_9_0 (state Temporary) | ||
911 | 2024.11.15 20:20:19.609040 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_9_9_0 to all_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
912 | 2024.11.15 20:20:19.609265 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003964 sec., 252.27043390514635 rows/sec., 17.49 KiB/sec. | ||
913 | 2024.11.15 20:20:19.609314 [ 207043 ] {7d66d091-6723-4a72-a0d0-64b28b301208} <Debug> TCPHandler: Processed in 0.004323543 sec. | ||
914 | 2024.11.15 20:20:20.531608 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
915 | 2024.11.15 20:20:20.531830 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
916 | 2024.11.15 20:20:20.531896 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
917 | 2024.11.15 20:20:20.537444 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
918 | 2024.11.15 20:20:20.537485 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
919 | 2024.11.15 20:20:20.537913 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Trace> MergedBlockOutputStream: filled checksums all_10_10_0 (state Temporary) | ||
920 | 2024.11.15 20:20:20.538120 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_10_10_0 to all_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
921 | 2024.11.15 20:20:20.538356 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.006601 sec., 302.98439630359036 rows/sec., 31.36 KiB/sec. | ||
922 | 2024.11.15 20:20:20.538408 [ 206940 ] {490c5f7b-344f-451f-9ed0-f0d16da9e2bc} <Debug> TCPHandler: Processed in 0.006999566 sec. | ||
923 | 2024.11.15 20:20:20.564553 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
924 | 2024.11.15 20:20:20.564759 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
925 | 2024.11.15 20:20:20.564824 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
926 | 2024.11.15 20:20:20.565806 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
927 | 2024.11.15 20:20:20.566318 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.31 GiB. | ||
928 | 2024.11.15 20:20:20.566706 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Trace> MergedBlockOutputStream: filled checksums all_10_10_0 (state Temporary) | ||
929 | 2024.11.15 20:20:20.566869 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_10_10_0 to all_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
930 | 2024.11.15 20:20:20.567069 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002368 sec., 422.2972972972973 rows/sec., 29.28 KiB/sec. | ||
931 | 2024.11.15 20:20:20.567111 [ 207043 ] {49cf3c05-5321-4562-a591-d1d1e2304bb9} <Debug> TCPHandler: Processed in 0.002766282 sec. | ||
932 | 2024.11.15 20:20:22.524026 [ 206940 ] {} <Trace> TCP-Session: 84815b15-181c-4917-84fe-e752ef064a4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
933 | 2024.11.15 20:20:22.524221 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Debug> executeQuery: (from [::1]:58636) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
934 | 2024.11.15 20:20:22.524290 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
935 | 2024.11.15 20:20:22.526467 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
936 | 2024.11.15 20:20:22.526496 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
937 | 2024.11.15 20:20:22.526860 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Trace> MergedBlockOutputStream: filled checksums all_11_11_0 (state Temporary) | ||
938 | 2024.11.15 20:20:22.527474 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_insert_all_11_11_0 to all_11_11_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
939 | 2024.11.15 20:20:22.527615 [ 205672 ] {} <Debug> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6) (MergerMutator): Selected 6 parts from all_1_6_1 to all_11_11_0 | ||
940 | 2024.11.15 20:20:22.527647 [ 205672 ] {} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
941 | 2024.11.15 20:20:22.527658 [ 205672 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
942 | 2024.11.15 20:20:22.527667 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003505 sec., 570.6134094151213 rows/sec., 59.07 KiB/sec. | ||
943 | 2024.11.15 20:20:22.527713 [ 206940 ] {f6c722b6-8a35-44ef-8982-8ad27220ed75} <Debug> TCPHandler: Processed in 0.003886234 sec. | ||
944 | 2024.11.15 20:20:22.527894 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_6_1 to all_11_11_0 into Compact with storage Full | ||
945 | 2024.11.15 20:20:22.527969 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
946 | 2024.11.15 20:20:22.529149 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_6_1, total 12 rows starting from the beginning of the part | ||
947 | 2024.11.15 20:20:22.529186 [ 207043 ] {} <Trace> TCP-Session: 64b21260-af2a-48ab-b8d8-897c49659bff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
948 | 2024.11.15 20:20:22.529232 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_7_7_0, total 2 rows starting from the beginning of the part | ||
949 | 2024.11.15 20:20:22.529274 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_8_8_0, total 2 rows starting from the beginning of the part | ||
950 | 2024.11.15 20:20:22.529320 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_9_9_0, total 2 rows starting from the beginning of the part | ||
951 | 2024.11.15 20:20:22.529351 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Debug> executeQuery: (from [::1]:58646) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
952 | 2024.11.15 20:20:22.529375 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_10_10_0, total 2 rows starting from the beginning of the part | ||
953 | 2024.11.15 20:20:22.529409 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
954 | 2024.11.15 20:20:22.529412 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_11_11_0, total 2 rows starting from the beginning of the part | ||
955 | 2024.11.15 20:20:22.531492 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 22 rows, containing 5 columns (5 merged, 0 gathered) in 0.003675413 sec., 5985.721876697938 rows/sec., 622.80 KiB/sec. | ||
956 | 2024.11.15 20:20:22.531679 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Trace> MergedBlockOutputStream: filled checksums all_1_11_2 (state Temporary) | ||
957 | 2024.11.15 20:20:22.531958 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
958 | 2024.11.15 20:20:22.531981 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
959 | 2024.11.15 20:20:22.533138 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Trace> MergedBlockOutputStream: filled checksums all_11_11_0 (state Temporary) | ||
960 | 2024.11.15 20:20:22.533314 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_insert_all_11_11_0 to all_11_11_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
961 | 2024.11.15 20:20:22.533465 [ 205768 ] {} <Debug> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f) (MergerMutator): Selected 6 parts from all_1_6_1 to all_11_11_0 | ||
962 | 2024.11.15 20:20:22.533492 [ 205768 ] {} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
963 | 2024.11.15 20:20:22.533494 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004179 sec., 239.29169657812872 rows/sec., 16.59 KiB/sec. | ||
964 | 2024.11.15 20:20:22.533505 [ 205768 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.30 GiB. | ||
965 | 2024.11.15 20:20:22.533531 [ 207043 ] {4f55925d-c0e6-4a07-ac5d-61239314f01c} <Debug> TCPHandler: Processed in 0.004480993 sec. | ||
966 | 2024.11.15 20:20:22.533734 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_6_1 to all_11_11_0 into Compact with storage Full | ||
967 | 2024.11.15 20:20:22.534901 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
968 | 2024.11.15 20:20:22.534928 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_6_1, total 17 rows starting from the beginning of the part | ||
969 | 2024.11.15 20:20:22.534980 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6): Renaming temporary part tmp_merge_all_1_11_2 to all_1_11_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
970 | 2024.11.15 20:20:22.534987 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_7_7_0, total 1 rows starting from the beginning of the part | ||
971 | 2024.11.15 20:20:22.535020 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_8_8_0, total 1 rows starting from the beginning of the part | ||
972 | 2024.11.15 20:20:22.535027 [ 205876 ] {b9302afe-7653-47e0-8455-5324e00b6fa6::all_1_11_2} <Trace> oximeter.fields_string (b9302afe-7653-47e0-8455-5324e00b6fa6) (MergerMutator): Merged 6 parts: [all_1_6_1, all_11_11_0] -> all_1_11_2 | ||
973 | 2024.11.15 20:20:22.535048 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_9_9_0, total 1 rows starting from the beginning of the part | ||
974 | 2024.11.15 20:20:22.535099 [ 205876 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.29 MiB. | ||
975 | 2024.11.15 20:20:22.535157 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_10_10_0, total 1 rows starting from the beginning of the part | ||
976 | 2024.11.15 20:20:22.535209 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_11_11_0, total 1 rows starting from the beginning of the part | ||
977 | 2024.11.15 20:20:22.536389 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 22 rows, containing 4 columns (4 merged, 0 gathered) in 0.002737113 sec., 8037.665964101592 rows/sec., 563.01 KiB/sec. | ||
978 | 2024.11.15 20:20:22.537497 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Trace> MergedBlockOutputStream: filled checksums all_1_11_2 (state Temporary) | ||
979 | 2024.11.15 20:20:22.537716 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f): Renaming temporary part tmp_merge_all_1_11_2 to all_1_11_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
980 | 2024.11.15 20:20:22.537760 [ 205846 ] {505a27df-f57d-458a-b4cb-8c82b52bdd4f::all_1_11_2} <Trace> oximeter.measurements_i64 (505a27df-f57d-458a-b4cb-8c82b52bdd4f) (MergerMutator): Merged 6 parts: [all_1_6_1, all_11_11_0] -> all_1_11_2 | ||
981 | 2024.11.15 20:20:22.537832 [ 205846 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.28 MiB. | ||
982 | 2024.11.15 20:20:23.000430 [ 205898 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 390.30 MiB, peak 394.30 MiB, free memory in arenas 20.47 MiB, will set to 388.43 MiB (RSS), difference: -1.87 MiB |