| 1 | 2025.01.25 03:38:24.103258 [ 227057 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.01.25 03:38:24.103329 [ 227057 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.01.25 03:38:24.155366 [ 227057 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 227057 | ||
| 4 | 2025.01.25 03:38:24.155430 [ 227057 ] {} <Information> Application: starting up | ||
| 5 | 2025.01.25 03:38:24.155447 [ 227057 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.01.25 03:38:24.158272 [ 227057 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.01.25 03:38:24.184647 [ 227057 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.01.25 03:38:24.187406 [ 227057 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.01.25 03:38:24.187482 [ 227057 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.01.25 03:38:24.187500 [ 227057 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.01.25 03:38:24.363226 [ 227057 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.01.25 03:38:24.364387 [ 227057 ] {} <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 | 2025.01.25 03:38:24.370687 [ 227057 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.01.25 03:38:24.370703 [ 227057 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.01.25 03:38:24.370712 [ 227057 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.01.25 03:38:24.370717 [ 227057 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.01.25 03:38:24.370740 [ 227057 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.01.25 03:38:24.371030 [ 227057 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.01.25 03:38:24.372365 [ 227057 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml' | ||
| 20 | 2025.01.25 03:38:24.374818 [ 227057 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml', performing update on configuration | ||
| 21 | 2025.01.25 03:38:24.375424 [ 227057 ] {} <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 | 2025.01.25 03:38:24.375436 [ 227057 ] {} <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 | 2025.01.25 03:38:24.375441 [ 227057 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.01.25 03:38:24.375479 [ 227057 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.01.25 03:38:24.376602 [ 227057 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.01.25 03:38:24.426749 [ 227057 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.01.25 03:38:24.459524 [ 227057 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.01.25 03:38:24.464481 [ 227057 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.01.25 03:38:24.464663 [ 227057 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml', performed update on configuration | ||
| 30 | 2025.01.25 03:38:24.480029 [ 227057 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml' | ||
| 31 | 2025.01.25 03:38:24.480608 [ 227057 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml', performing update on configuration | ||
| 32 | 2025.01.25 03:38:24.481461 [ 227057 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml', performed update on configuration | ||
| 33 | 2025.01.25 03:38:24.481796 [ 227057 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/config.xml | ||
| 34 | 2025.01.25 03:38:24.482513 [ 227057 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.01.25 03:38:24.482811 [ 227057 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.01.25 03:38:24.483091 [ 227057 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.01.25 03:38:24.486254 [ 227057 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.01.25 03:38:24.494374 [ 227057 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.01.25 03:38:24.494413 [ 227057 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/datastore/ | ||
| 40 | 2025.01.25 03:38:24.494909 [ 227081 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2025.01.25 03:38:24.496119 [ 227081 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2025.01.25 03:38:24.524056 [ 227057 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.01.25 03:38:24.524080 [ 227057 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00010329 sec | ||
| 44 | 2025.01.25 03:38:24.524087 [ 227057 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.01.25 03:38:24.524093 [ 227057 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.01.25 03:38:24.524123 [ 227057 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.01.25 03:38:24.524141 [ 227057 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.01.25 03:38:24.524980 [ 227057 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.01.25 03:38:24.526333 [ 227057 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.01.25 03:38:24.526347 [ 227057 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.01.25 03:38:24.526354 [ 227057 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.01.25 03:38:24.526361 [ 227057 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.01.25 03:38:24.526370 [ 227057 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.01.25 03:38:24.528327 [ 227057 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.01.25 03:38:24.529458 [ 227057 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.01.25 03:38:24.529481 [ 227057 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.01.25 03:38:24.529653 [ 227057 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.01.25 03:38:24.529668 [ 227057 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.01.25 03:38:24.529676 [ 227057 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.01.25 03:38:24.529684 [ 227057 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.01.25 03:38:24.529691 [ 227057 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.01.25 03:38:24.529698 [ 227057 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.01.25 03:38:24.529706 [ 227057 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.01.25 03:38:24.547467 [ 227057 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.01.25 03:38:24.552137 [ 227057 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.01.25 03:38:24.552160 [ 227057 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.98e-05 sec | ||
| 67 | 2025.01.25 03:38:24.552167 [ 227057 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.01.25 03:38:24.552172 [ 227057 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.01.25 03:38:24.552196 [ 227057 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.01.25 03:38:24.552293 [ 227057 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-5a466d8eaf7f3412-test_omdb_success_cases.227027.1-clickhouse-ufdzrG/datastore/user_defined/ | ||
| 71 | 2025.01.25 03:38:24.552326 [ 227057 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.01.25 03:38:24.552334 [ 227057 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.01.25 03:38:24.552356 [ 227057 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.01.25 03:38:24.552363 [ 227057 ] {} <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 | 2025.01.25 03:38:24.552444 [ 227057 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36195 | ||
| 76 | 2025.01.25 03:38:24.552499 [ 227057 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33979 | ||
| 77 | 2025.01.25 03:38:24.552671 [ 227057 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35109 | ||
| 78 | 2025.01.25 03:38:24.552712 [ 227057 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37161 | ||
| 79 | 2025.01.25 03:38:24.552736 [ 227057 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.01.25 03:38:24.553151 [ 227057 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 22.46 MiB, will set to 387.73 MiB (RSS), difference: 367.12 MiB | ||
| 81 | 2025.01.25 03:38:24.568827 [ 227057 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.316e-05 sec. | ||
| 82 | 2025.01.25 03:38:24.570972 [ 227057 ] {} <Information> Application: Listening for http://[::1]:36195 | ||
| 83 | 2025.01.25 03:38:24.571181 [ 227057 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:33979 | ||
| 84 | 2025.01.25 03:38:24.571255 [ 227057 ] {} <Information> Application: Listening for http://127.0.0.1:35109 | ||
| 85 | 2025.01.25 03:38:24.571324 [ 227057 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:37161 | ||
| 86 | 2025.01.25 03:38:24.571334 [ 227057 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.01.25 03:38:26.017829 [ 227059 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56356 | ||
| 88 | 2025.01.25 03:38:26.019281 [ 227059 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.01.25 03:38:26.019337 [ 227059 ] {} <Debug> TCP-Session: 72d971b3-abaa-43c8-9111-230ca2b3e49e Authenticating user 'default' from [::1]:56356 | ||
| 90 | 2025.01.25 03:38:26.019355 [ 227059 ] {} <Debug> TCP-Session: 72d971b3-abaa-43c8-9111-230ca2b3e49e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.01.25 03:38:26.019362 [ 227059 ] {} <Debug> TCP-Session: 72d971b3-abaa-43c8-9111-230ca2b3e49e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.01.25 03:38:26.019450 [ 227059 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.01.25 03:38:26.019476 [ 227059 ] {} <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 | 2025.01.25 03:38:26.019486 [ 227059 ] {} <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 | 2025.01.25 03:38:26.032414 [ 227060 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56358 | ||
| 96 | 2025.01.25 03:38:26.032510 [ 227061 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56360 | ||
| 97 | 2025.01.25 03:38:26.035610 [ 227060 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 98 | 2025.01.25 03:38:26.035650 [ 227060 ] {} <Debug> TCP-Session: 3544e60b-3a3c-48fc-bd49-a4b97fa3669f Authenticating user 'default' from [::1]:56358 | ||
| 99 | 2025.01.25 03:38:26.035668 [ 227060 ] {} <Debug> TCP-Session: 3544e60b-3a3c-48fc-bd49-a4b97fa3669f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2025.01.25 03:38:26.035674 [ 227060 ] {} <Debug> TCP-Session: 3544e60b-3a3c-48fc-bd49-a4b97fa3669f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 101 | 2025.01.25 03:38:26.036322 [ 227061 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2025.01.25 03:38:26.038799 [ 227061 ] {} <Debug> TCP-Session: 97da16e9-904e-4102-b47f-cc7da532f8ef Authenticating user 'default' from [::1]:56360 | ||
| 103 | 2025.01.25 03:38:26.038815 [ 227061 ] {} <Debug> TCP-Session: 97da16e9-904e-4102-b47f-cc7da532f8ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2025.01.25 03:38:26.038822 [ 227061 ] {} <Debug> TCP-Session: 97da16e9-904e-4102-b47f-cc7da532f8ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.01.25 03:38:26.072862 [ 227415 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56362 | ||
| 106 | 2025.01.25 03:38:26.072995 [ 227419 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56370 | ||
| 107 | 2025.01.25 03:38:26.073011 [ 227415 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 108 | 2025.01.25 03:38:26.073043 [ 227415 ] {} <Debug> TCP-Session: fa5142cf-9434-433f-a602-6fa49f5319fe Authenticating user 'default' from [::1]:56362 | ||
| 109 | 2025.01.25 03:38:26.073072 [ 227415 ] {} <Debug> TCP-Session: fa5142cf-9434-433f-a602-6fa49f5319fe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.01.25 03:38:26.073080 [ 227415 ] {} <Debug> TCP-Session: fa5142cf-9434-433f-a602-6fa49f5319fe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 111 | 2025.01.25 03:38:26.073082 [ 227419 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2025.01.25 03:38:26.073100 [ 227419 ] {} <Debug> TCP-Session: d84e639d-fe1f-4a1f-b67e-8f6284ec597c Authenticating user 'default' from [::1]:56370 | ||
| 113 | 2025.01.25 03:38:26.073108 [ 227419 ] {} <Debug> TCP-Session: d84e639d-fe1f-4a1f-b67e-8f6284ec597c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2025.01.25 03:38:26.073113 [ 227419 ] {} <Debug> TCP-Session: d84e639d-fe1f-4a1f-b67e-8f6284ec597c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2025.01.25 03:38:26.073193 [ 227417 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56366 | ||
| 116 | 2025.01.25 03:38:26.073196 [ 227416 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56364 | ||
| 117 | 2025.01.25 03:38:26.074314 [ 227417 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 118 | 2025.01.25 03:38:26.074327 [ 227416 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 119 | 2025.01.25 03:38:26.074345 [ 227417 ] {} <Debug> TCP-Session: dd430e00-b3f4-4b9a-862a-957360d3914c Authenticating user 'default' from [::1]:56366 | ||
| 120 | 2025.01.25 03:38:26.074353 [ 227416 ] {} <Debug> TCP-Session: 729bd0d0-b8b5-4fb4-ba2c-f27d1601602b Authenticating user 'default' from [::1]:56364 | ||
| 121 | 2025.01.25 03:38:26.074357 [ 227417 ] {} <Debug> TCP-Session: dd430e00-b3f4-4b9a-862a-957360d3914c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2025.01.25 03:38:26.074376 [ 227416 ] {} <Debug> TCP-Session: 729bd0d0-b8b5-4fb4-ba2c-f27d1601602b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 123 | 2025.01.25 03:38:26.074380 [ 227417 ] {} <Debug> TCP-Session: dd430e00-b3f4-4b9a-862a-957360d3914c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2025.01.25 03:38:26.074383 [ 227416 ] {} <Debug> TCP-Session: 729bd0d0-b8b5-4fb4-ba2c-f27d1601602b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2025.01.25 03:38:26.077352 [ 227418 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56368 | ||
| 126 | 2025.01.25 03:38:26.077438 [ 227418 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2025.01.25 03:38:26.077480 [ 227418 ] {} <Debug> TCP-Session: d527679b-b010-4a07-a0d7-4fce5f9681b9 Authenticating user 'default' from [::1]:56368 | ||
| 128 | 2025.01.25 03:38:26.077491 [ 227418 ] {} <Debug> TCP-Session: d527679b-b010-4a07-a0d7-4fce5f9681b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.01.25 03:38:26.077497 [ 227418 ] {} <Debug> TCP-Session: d527679b-b010-4a07-a0d7-4fce5f9681b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.01.25 03:38:32.031621 [ 227308 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 131 | 2025.01.25 03:38:32.031671 [ 227308 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 132 | 2025.01.25 03:38:32.038553 [ 227309 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1960 entries to flush up to offset 1960 | ||
| 133 | 2025.01.25 03:38:32.038611 [ 227309 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 134 | 2025.01.25 03:38:32.039435 [ 227309 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 135 | 2025.01.25 03:38:32.045174 [ 227309 ] {} <Debug> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): Loading data parts | ||
| 136 | 2025.01.25 03:38:32.052197 [ 227308 ] {} <Debug> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): Loading data parts | ||
| 137 | 2025.01.25 03:38:32.053689 [ 227309 ] {} <Debug> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): There are no data parts | ||
| 138 | 2025.01.25 03:38:32.053711 [ 227308 ] {} <Debug> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): There are no data parts | ||
| 139 | 2025.01.25 03:38:32.059361 [ 227309 ] {} <Trace> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 140 | 2025.01.25 03:38:32.059393 [ 227309 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.60 GiB. | ||
| 141 | 2025.01.25 03:38:32.060065 [ 227309 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 142 | 2025.01.25 03:38:32.060270 [ 227309 ] {} <Trace> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 143 | 2025.01.25 03:38:32.060422 [ 227309 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1960 | ||
| 144 | 2025.01.25 03:38:32.090709 [ 227308 ] {} <Trace> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.01.25 03:38:32.090750 [ 227308 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.60 GiB. | ||
| 146 | 2025.01.25 03:38:32.097543 [ 227308 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.01.25 03:38:32.104733 [ 227308 ] {} <Trace> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2025.01.25 03:38:32.109299 [ 227308 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.01.25 03:38:33.002228 [ 227312 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 393.31 MiB, peak 397.31 MiB, free memory in arenas 31.76 MiB, will set to 397.68 MiB (RSS), difference: 4.37 MiB | ||
| 150 | 2025.01.25 03:38:34.751842 [ 227820 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56372 | ||
| 151 | 2025.01.25 03:38:34.751969 [ 227820 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2025.01.25 03:38:34.752001 [ 227820 ] {} <Debug> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Authenticating user 'default' from [::1]:56372 | ||
| 153 | 2025.01.25 03:38:34.752017 [ 227820 ] {} <Debug> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.01.25 03:38:34.752023 [ 227820 ] {} <Debug> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2025.01.25 03:38:34.762297 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 156 | 2025.01.25 03:38:34.762625 [ 227820 ] {f3284fa3-e2ac-4c4c-a589-f2f57d276c61} <Debug> executeQuery: (from [::1]:56372) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 157 | 2025.01.25 03:38:34.763421 [ 227820 ] {f3284fa3-e2ac-4c4c-a589-f2f57d276c61} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56372) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 158 | |||
| 159 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 160 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 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 | ||
| 165 | 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 | ||
| 166 | 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 | ||
| 167 | 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 | ||
| 168 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 16. ? @ 0x00007fc70acabac3 in ? | ||
| 176 | 17. ? @ 0x00007fc70ad3d850 in ? | ||
| 177 | |||
| 178 | 2025.01.25 03:38:34.763554 [ 227820 ] {f3284fa3-e2ac-4c4c-a589-f2f57d276c61} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 179 | |||
| 180 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 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 | ||
| 186 | 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 | ||
| 187 | 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 | ||
| 188 | 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 | ||
| 189 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 16. ? @ 0x00007fc70acabac3 in ? | ||
| 197 | 17. ? @ 0x00007fc70ad3d850 in ? | ||
| 198 | |||
| 199 | 2025.01.25 03:38:34.763607 [ 227820 ] {f3284fa3-e2ac-4c4c-a589-f2f57d276c61} <Debug> TCPHandler: Processed in 0.00155066 sec. | ||
| 200 | 2025.01.25 03:38:34.771085 [ 227823 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56374 | ||
| 201 | 2025.01.25 03:38:34.771212 [ 227823 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 202 | 2025.01.25 03:38:34.771240 [ 227823 ] {} <Debug> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Authenticating user 'default' from [::1]:56374 | ||
| 203 | 2025.01.25 03:38:34.771257 [ 227823 ] {} <Debug> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2025.01.25 03:38:34.771265 [ 227823 ] {} <Debug> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2025.01.25 03:38:34.775281 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 206 | 2025.01.25 03:38:34.775693 [ 227823 ] {8cb75af7-75c6-474e-bb5b-96538a2dd916} <Debug> executeQuery: (from [::1]:56374) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 207 | 2025.01.25 03:38:34.776033 [ 227823 ] {8cb75af7-75c6-474e-bb5b-96538a2dd916} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56374) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 208 | |||
| 209 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 210 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 211 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 212 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 213 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 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 | ||
| 215 | 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 | ||
| 216 | 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 | ||
| 217 | 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 | ||
| 218 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 222 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 223 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 224 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 225 | 16. ? @ 0x00007fc70acabac3 in ? | ||
| 226 | 17. ? @ 0x00007fc70ad3d850 in ? | ||
| 227 | |||
| 228 | 2025.01.25 03:38:34.777377 [ 227823 ] {8cb75af7-75c6-474e-bb5b-96538a2dd916} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 229 | |||
| 230 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 231 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 232 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 233 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 234 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 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 | ||
| 236 | 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 | ||
| 237 | 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 | ||
| 238 | 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 | ||
| 239 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 240 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 241 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 242 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 243 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 244 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 246 | 16. ? @ 0x00007fc70acabac3 in ? | ||
| 247 | 17. ? @ 0x00007fc70ad3d850 in ? | ||
| 248 | |||
| 249 | 2025.01.25 03:38:34.777438 [ 227823 ] {8cb75af7-75c6-474e-bb5b-96538a2dd916} <Debug> TCPHandler: Processed in 0.002367229 sec. | ||
| 250 | 2025.01.25 03:38:34.779544 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 251 | 2025.01.25 03:38:34.779693 [ 227820 ] {3066c978-b956-4f41-8207-bda8d94cca23} <Debug> executeQuery: (from [::1]:56372) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 252 | 2025.01.25 03:38:34.779807 [ 227820 ] {3066c978-b956-4f41-8207-bda8d94cca23} <Debug> TCPHandler: Processed in 0.000376909 sec. | ||
| 253 | 2025.01.25 03:38:34.782148 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 254 | 2025.01.25 03:38:34.782281 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Debug> executeQuery: (from [::1]:56374) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 255 | 2025.01.25 03:38:34.782317 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 256 | 2025.01.25 03:38:34.785078 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 257 | 2025.01.25 03:38:34.785096 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.5509e-05 sec | ||
| 258 | 2025.01.25 03:38:34.785104 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Trace> ReferentialDeps: No tables | ||
| 259 | 2025.01.25 03:38:34.785110 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Trace> LoadingDeps: No tables | ||
| 260 | 2025.01.25 03:38:34.785129 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 261 | 2025.01.25 03:38:34.785204 [ 227823 ] {1d94e05d-5839-4bbc-a5c4-a9fc9cead8d1} <Debug> TCPHandler: Processed in 0.003144569 sec. | ||
| 262 | 2025.01.25 03:38:34.791201 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 263 | 2025.01.25 03:38:34.791539 [ 227820 ] {757dec54-8a63-4122-bedb-1928ffa74e56} <Debug> executeQuery: (from [::1]:56372) /* The version table contains metadata about the `oximeter` database */ | ||
| 264 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 265 | 2025.01.25 03:38:34.792232 [ 227820 ] {757dec54-8a63-4122-bedb-1928ffa74e56} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 266 | 2025.01.25 03:38:34.793478 [ 227824 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56376 | ||
| 267 | 2025.01.25 03:38:34.793585 [ 227824 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 268 | 2025.01.25 03:38:34.793612 [ 227824 ] {} <Debug> TCP-Session: 5ccb2650-8337-4e65-9868-125688577b50 Authenticating user 'default' from [::1]:56376 | ||
| 269 | 2025.01.25 03:38:34.793635 [ 227824 ] {} <Debug> TCP-Session: 5ccb2650-8337-4e65-9868-125688577b50 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2025.01.25 03:38:34.793643 [ 227824 ] {} <Debug> TCP-Session: 5ccb2650-8337-4e65-9868-125688577b50 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2025.01.25 03:38:34.793747 [ 227824 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 272 | 2025.01.25 03:38:34.794934 [ 227824 ] {} <Debug> TCP-Session: 5ccb2650-8337-4e65-9868-125688577b50 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.01.25 03:38:34.797328 [ 227820 ] {757dec54-8a63-4122-bedb-1928ffa74e56} <Debug> oximeter.version (86143271-f609-416e-be91-6875c55e8a19): Loading data parts | ||
| 274 | 2025.01.25 03:38:34.797892 [ 227820 ] {757dec54-8a63-4122-bedb-1928ffa74e56} <Debug> oximeter.version (86143271-f609-416e-be91-6875c55e8a19): There are no data parts | ||
| 275 | 2025.01.25 03:38:34.802593 [ 227820 ] {757dec54-8a63-4122-bedb-1928ffa74e56} <Debug> TCPHandler: Processed in 0.01159772 sec. | ||
| 276 | 2025.01.25 03:38:34.803662 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2025.01.25 03:38:34.803986 [ 227823 ] {f7608d40-a93b-4a45-ac78-f083ed0fa334} <Debug> executeQuery: (from [::1]:56374) /* The measurement tables contain all individual samples from each timeseries. | ||
| 278 | * | ||
| 279 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 280 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 281 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 282 | * by all samples from the same timeseries. | ||
| 283 | * | ||
| 284 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 285 | * and then uses that to index quickly into the measurements tables. | ||
| 286 | */ | ||
| 287 | 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) | ||
| 288 | 2025.01.25 03:38:34.804048 [ 227823 ] {f7608d40-a93b-4a45-ac78-f083ed0fa334} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 289 | 2025.01.25 03:38:34.807610 [ 227823 ] {f7608d40-a93b-4a45-ac78-f083ed0fa334} <Debug> oximeter.measurements_bool (3eaeb3b3-f49b-4045-848e-aea4125dbdb4): Loading data parts | ||
| 290 | 2025.01.25 03:38:34.809108 [ 227823 ] {f7608d40-a93b-4a45-ac78-f083ed0fa334} <Debug> oximeter.measurements_bool (3eaeb3b3-f49b-4045-848e-aea4125dbdb4): There are no data parts | ||
| 291 | 2025.01.25 03:38:34.812150 [ 227823 ] {f7608d40-a93b-4a45-ac78-f083ed0fa334} <Debug> TCPHandler: Processed in 0.00869629 sec. | ||
| 292 | 2025.01.25 03:38:34.818466 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 293 | 2025.01.25 03:38:34.818720 [ 227820 ] {d7f88e87-1f0f-44f3-b94a-3f000cd93abb} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 294 | 2025.01.25 03:38:34.818769 [ 227820 ] {d7f88e87-1f0f-44f3-b94a-3f000cd93abb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 295 | 2025.01.25 03:38:34.824825 [ 227820 ] {d7f88e87-1f0f-44f3-b94a-3f000cd93abb} <Debug> oximeter.measurements_i8 (0a5c47da-6cb3-4dd7-8b41-6b7a168eada5): Loading data parts | ||
| 296 | 2025.01.25 03:38:34.825230 [ 227820 ] {d7f88e87-1f0f-44f3-b94a-3f000cd93abb} <Debug> oximeter.measurements_i8 (0a5c47da-6cb3-4dd7-8b41-6b7a168eada5): There are no data parts | ||
| 297 | 2025.01.25 03:38:34.825242 [ 227824 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56382 | ||
| 298 | 2025.01.25 03:38:34.825296 [ 227824 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 299 | 2025.01.25 03:38:34.825320 [ 227824 ] {} <Debug> TCP-Session: e20a8fb9-ed12-4b48-a8fc-7ccce48d4b15 Authenticating user 'default' from [::1]:56382 | ||
| 300 | 2025.01.25 03:38:34.825340 [ 227824 ] {} <Debug> TCP-Session: e20a8fb9-ed12-4b48-a8fc-7ccce48d4b15 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2025.01.25 03:38:34.825352 [ 227824 ] {} <Debug> TCP-Session: e20a8fb9-ed12-4b48-a8fc-7ccce48d4b15 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 302 | 2025.01.25 03:38:34.825479 [ 227826 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56380 | ||
| 303 | 2025.01.25 03:38:34.825567 [ 227826 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 304 | 2025.01.25 03:38:34.825590 [ 227826 ] {} <Debug> TCP-Session: 30d87873-d739-4df4-b203-d29a525026e5 Authenticating user 'default' from [::1]:56380 | ||
| 305 | 2025.01.25 03:38:34.825601 [ 227826 ] {} <Debug> TCP-Session: 30d87873-d739-4df4-b203-d29a525026e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 306 | 2025.01.25 03:38:34.825608 [ 227826 ] {} <Debug> TCP-Session: 30d87873-d739-4df4-b203-d29a525026e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2025.01.25 03:38:34.827804 [ 227820 ] {d7f88e87-1f0f-44f3-b94a-3f000cd93abb} <Debug> TCPHandler: Processed in 0.00949157 sec. | ||
| 308 | 2025.01.25 03:38:34.828557 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 309 | 2025.01.25 03:38:34.828830 [ 227823 ] {8d14ab9d-b1f3-4f89-8e53-bd07cf012473} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 310 | 2025.01.25 03:38:34.828883 [ 227823 ] {8d14ab9d-b1f3-4f89-8e53-bd07cf012473} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 311 | 2025.01.25 03:38:34.832807 [ 227823 ] {8d14ab9d-b1f3-4f89-8e53-bd07cf012473} <Debug> oximeter.measurements_u8 (f06ed628-cc5c-4f61-ae57-130f68524f15): Loading data parts | ||
| 312 | 2025.01.25 03:38:34.833257 [ 227823 ] {8d14ab9d-b1f3-4f89-8e53-bd07cf012473} <Debug> oximeter.measurements_u8 (f06ed628-cc5c-4f61-ae57-130f68524f15): There are no data parts | ||
| 313 | 2025.01.25 03:38:34.836580 [ 227823 ] {8d14ab9d-b1f3-4f89-8e53-bd07cf012473} <Debug> TCPHandler: Processed in 0.00818446 sec. | ||
| 314 | 2025.01.25 03:38:34.837669 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 315 | 2025.01.25 03:38:34.837961 [ 227820 ] {6075875e-a50b-45c8-a2c6-6aa5699b2c76} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 316 | 2025.01.25 03:38:34.838825 [ 227820 ] {6075875e-a50b-45c8-a2c6-6aa5699b2c76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 317 | 2025.01.25 03:38:34.843981 [ 227820 ] {6075875e-a50b-45c8-a2c6-6aa5699b2c76} <Debug> oximeter.measurements_i16 (b5d02d87-3c64-4fef-a8e0-eb1e7dc71616): Loading data parts | ||
| 318 | 2025.01.25 03:38:34.845502 [ 227837 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56386 | ||
| 319 | 2025.01.25 03:38:34.845720 [ 227839 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56388 | ||
| 320 | 2025.01.25 03:38:34.845872 [ 227827 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56384 | ||
| 321 | 2025.01.25 03:38:34.845914 [ 227841 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56390 | ||
| 322 | 2025.01.25 03:38:34.846953 [ 227839 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 323 | 2025.01.25 03:38:34.846989 [ 227839 ] {} <Debug> TCP-Session: e8463154-afd3-4287-81a7-28e8c17eac56 Authenticating user 'default' from [::1]:56388 | ||
| 324 | 2025.01.25 03:38:34.847008 [ 227839 ] {} <Debug> TCP-Session: e8463154-afd3-4287-81a7-28e8c17eac56 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2025.01.25 03:38:34.847016 [ 227839 ] {} <Debug> TCP-Session: e8463154-afd3-4287-81a7-28e8c17eac56 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 326 | 2025.01.25 03:38:34.847028 [ 227820 ] {6075875e-a50b-45c8-a2c6-6aa5699b2c76} <Debug> oximeter.measurements_i16 (b5d02d87-3c64-4fef-a8e0-eb1e7dc71616): There are no data parts | ||
| 327 | 2025.01.25 03:38:34.845938 [ 227842 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56392 | ||
| 328 | 2025.01.25 03:38:34.848610 [ 227837 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 329 | 2025.01.25 03:38:34.855986 [ 227837 ] {} <Debug> TCP-Session: aecf2a39-0102-4ec3-9eba-17fa0a3537b6 Authenticating user 'default' from [::1]:56386 | ||
| 330 | 2025.01.25 03:38:34.856009 [ 227837 ] {} <Debug> TCP-Session: aecf2a39-0102-4ec3-9eba-17fa0a3537b6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2025.01.25 03:38:34.856017 [ 227837 ] {} <Debug> TCP-Session: aecf2a39-0102-4ec3-9eba-17fa0a3537b6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 332 | 2025.01.25 03:38:34.856018 [ 227842 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 333 | 2025.01.25 03:38:34.856056 [ 227842 ] {} <Debug> TCP-Session: e637faaf-5954-4de6-bec3-5ff171ca6134 Authenticating user 'default' from [::1]:56392 | ||
| 334 | 2025.01.25 03:38:34.856067 [ 227842 ] {} <Debug> TCP-Session: e637faaf-5954-4de6-bec3-5ff171ca6134 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2025.01.25 03:38:34.856073 [ 227842 ] {} <Debug> TCP-Session: e637faaf-5954-4de6-bec3-5ff171ca6134 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2025.01.25 03:38:34.855791 [ 227827 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 337 | 2025.01.25 03:38:34.855858 [ 227841 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 338 | 2025.01.25 03:38:34.856163 [ 227827 ] {} <Debug> TCP-Session: 79f253fb-9962-4911-af11-be7f67072a24 Authenticating user 'default' from [::1]:56384 | ||
| 339 | 2025.01.25 03:38:34.856169 [ 227841 ] {} <Debug> TCP-Session: 421e395d-ac16-4fcd-a5dd-c059a820798a Authenticating user 'default' from [::1]:56390 | ||
| 340 | 2025.01.25 03:38:34.856175 [ 227827 ] {} <Debug> TCP-Session: 79f253fb-9962-4911-af11-be7f67072a24 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 341 | 2025.01.25 03:38:34.856181 [ 227827 ] {} <Debug> TCP-Session: 79f253fb-9962-4911-af11-be7f67072a24 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 342 | 2025.01.25 03:38:34.856181 [ 227841 ] {} <Debug> TCP-Session: 421e395d-ac16-4fcd-a5dd-c059a820798a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2025.01.25 03:38:34.856286 [ 227841 ] {} <Debug> TCP-Session: 421e395d-ac16-4fcd-a5dd-c059a820798a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2025.01.25 03:38:34.856336 [ 227820 ] {6075875e-a50b-45c8-a2c6-6aa5699b2c76} <Debug> TCPHandler: Processed in 0.018842821 sec. | ||
| 345 | 2025.01.25 03:38:34.857734 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 346 | 2025.01.25 03:38:34.858906 [ 227823 ] {990d5afb-f84b-4a19-b921-55afdccc9a94} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 347 | 2025.01.25 03:38:34.858970 [ 227823 ] {990d5afb-f84b-4a19-b921-55afdccc9a94} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 348 | 2025.01.25 03:38:34.863970 [ 227823 ] {990d5afb-f84b-4a19-b921-55afdccc9a94} <Debug> oximeter.measurements_u16 (c0986c57-3dd0-4060-b04b-7713ec1054af): Loading data parts | ||
| 349 | 2025.01.25 03:38:34.867998 [ 227823 ] {990d5afb-f84b-4a19-b921-55afdccc9a94} <Debug> oximeter.measurements_u16 (c0986c57-3dd0-4060-b04b-7713ec1054af): There are no data parts | ||
| 350 | 2025.01.25 03:38:34.871980 [ 227823 ] {990d5afb-f84b-4a19-b921-55afdccc9a94} <Debug> TCPHandler: Processed in 0.01454307 sec. | ||
| 351 | 2025.01.25 03:38:34.872941 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 352 | 2025.01.25 03:38:34.873242 [ 227820 ] {936d21b1-8274-473c-b342-c9849574e2b5} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 353 | 2025.01.25 03:38:34.873295 [ 227820 ] {936d21b1-8274-473c-b342-c9849574e2b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 354 | 2025.01.25 03:38:34.877647 [ 227820 ] {936d21b1-8274-473c-b342-c9849574e2b5} <Debug> oximeter.measurements_i32 (a05e55c5-0094-4b92-9cba-9f958f234f23): Loading data parts | ||
| 355 | 2025.01.25 03:38:34.877892 [ 227820 ] {936d21b1-8274-473c-b342-c9849574e2b5} <Debug> oximeter.measurements_i32 (a05e55c5-0094-4b92-9cba-9f958f234f23): There are no data parts | ||
| 356 | 2025.01.25 03:38:34.880598 [ 227820 ] {936d21b1-8274-473c-b342-c9849574e2b5} <Debug> TCPHandler: Processed in 0.00784181 sec. | ||
| 357 | 2025.01.25 03:38:34.881512 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 358 | 2025.01.25 03:38:34.881813 [ 227823 ] {5e15aa04-8d5a-49a4-8754-5732d0918595} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 359 | 2025.01.25 03:38:34.881870 [ 227823 ] {5e15aa04-8d5a-49a4-8754-5732d0918595} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 360 | 2025.01.25 03:38:34.885410 [ 227823 ] {5e15aa04-8d5a-49a4-8754-5732d0918595} <Debug> oximeter.measurements_u32 (e22281cf-77b5-4bbf-a31a-7011e6c42174): Loading data parts | ||
| 361 | 2025.01.25 03:38:34.886414 [ 227823 ] {5e15aa04-8d5a-49a4-8754-5732d0918595} <Debug> oximeter.measurements_u32 (e22281cf-77b5-4bbf-a31a-7011e6c42174): There are no data parts | ||
| 362 | 2025.01.25 03:38:34.890234 [ 227823 ] {5e15aa04-8d5a-49a4-8754-5732d0918595} <Debug> TCPHandler: Processed in 0.00890687 sec. | ||
| 363 | 2025.01.25 03:38:34.891118 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 364 | 2025.01.25 03:38:34.891430 [ 227820 ] {51ac77ac-0e18-46f8-955e-49726270d379} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 365 | 2025.01.25 03:38:34.891492 [ 227820 ] {51ac77ac-0e18-46f8-955e-49726270d379} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 366 | 2025.01.25 03:38:34.896525 [ 227820 ] {51ac77ac-0e18-46f8-955e-49726270d379} <Debug> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Loading data parts | ||
| 367 | 2025.01.25 03:38:34.896834 [ 227820 ] {51ac77ac-0e18-46f8-955e-49726270d379} <Debug> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): There are no data parts | ||
| 368 | 2025.01.25 03:38:34.900501 [ 227820 ] {51ac77ac-0e18-46f8-955e-49726270d379} <Debug> TCPHandler: Processed in 0.00956059 sec. | ||
| 369 | 2025.01.25 03:38:34.904983 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 370 | 2025.01.25 03:38:34.905314 [ 227823 ] {4add58b6-7855-45eb-b4f1-06206cce2abf} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 371 | 2025.01.25 03:38:34.905376 [ 227823 ] {4add58b6-7855-45eb-b4f1-06206cce2abf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 372 | 2025.01.25 03:38:34.910572 [ 227823 ] {4add58b6-7855-45eb-b4f1-06206cce2abf} <Debug> oximeter.measurements_u64 (a6f34c46-fdce-4cd1-bad8-b96602b18ff8): Loading data parts | ||
| 373 | 2025.01.25 03:38:34.910861 [ 227823 ] {4add58b6-7855-45eb-b4f1-06206cce2abf} <Debug> oximeter.measurements_u64 (a6f34c46-fdce-4cd1-bad8-b96602b18ff8): There are no data parts | ||
| 374 | 2025.01.25 03:38:34.915452 [ 227823 ] {4add58b6-7855-45eb-b4f1-06206cce2abf} <Debug> TCPHandler: Processed in 0.0106798 sec. | ||
| 375 | 2025.01.25 03:38:34.916457 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 376 | 2025.01.25 03:38:34.916749 [ 227820 ] {785d78df-d5e6-4bec-a68d-2ccfc20d3263} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 377 | 2025.01.25 03:38:34.916806 [ 227820 ] {785d78df-d5e6-4bec-a68d-2ccfc20d3263} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 378 | 2025.01.25 03:38:34.920444 [ 227820 ] {785d78df-d5e6-4bec-a68d-2ccfc20d3263} <Debug> oximeter.measurements_f32 (342d544b-4c68-4a3e-a7fc-363fc7319dbd): Loading data parts | ||
| 379 | 2025.01.25 03:38:34.921121 [ 227820 ] {785d78df-d5e6-4bec-a68d-2ccfc20d3263} <Debug> oximeter.measurements_f32 (342d544b-4c68-4a3e-a7fc-363fc7319dbd): There are no data parts | ||
| 380 | 2025.01.25 03:38:34.923996 [ 227820 ] {785d78df-d5e6-4bec-a68d-2ccfc20d3263} <Debug> TCPHandler: Processed in 0.00772896 sec. | ||
| 381 | 2025.01.25 03:38:34.924853 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 382 | 2025.01.25 03:38:34.925889 [ 227823 ] {07924ac5-bfe5-4342-aa4c-c28d8ab8a2ac} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 383 | 2025.01.25 03:38:34.925948 [ 227823 ] {07924ac5-bfe5-4342-aa4c-c28d8ab8a2ac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 384 | 2025.01.25 03:38:34.929593 [ 227823 ] {07924ac5-bfe5-4342-aa4c-c28d8ab8a2ac} <Debug> oximeter.measurements_f64 (3d5ac36d-a0f5-4f1c-bbe5-58b78119d484): Loading data parts | ||
| 385 | 2025.01.25 03:38:34.929881 [ 227823 ] {07924ac5-bfe5-4342-aa4c-c28d8ab8a2ac} <Debug> oximeter.measurements_f64 (3d5ac36d-a0f5-4f1c-bbe5-58b78119d484): There are no data parts | ||
| 386 | 2025.01.25 03:38:34.932384 [ 227823 ] {07924ac5-bfe5-4342-aa4c-c28d8ab8a2ac} <Debug> TCPHandler: Processed in 0.00770673 sec. | ||
| 387 | 2025.01.25 03:38:34.933199 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 388 | 2025.01.25 03:38:34.933536 [ 227820 ] {2af451c2-9b86-43d0-8292-21044bfdf703} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 389 | 2025.01.25 03:38:34.933591 [ 227820 ] {2af451c2-9b86-43d0-8292-21044bfdf703} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 390 | 2025.01.25 03:38:34.939880 [ 227820 ] {2af451c2-9b86-43d0-8292-21044bfdf703} <Debug> oximeter.measurements_string (9118acf0-cdb1-49ac-bc4d-1b9e524b56db): Loading data parts | ||
| 391 | 2025.01.25 03:38:34.940456 [ 227820 ] {2af451c2-9b86-43d0-8292-21044bfdf703} <Debug> oximeter.measurements_string (9118acf0-cdb1-49ac-bc4d-1b9e524b56db): There are no data parts | ||
| 392 | 2025.01.25 03:38:34.946083 [ 227820 ] {2af451c2-9b86-43d0-8292-21044bfdf703} <Debug> TCPHandler: Processed in 0.01307137 sec. | ||
| 393 | 2025.01.25 03:38:34.953380 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 394 | 2025.01.25 03:38:34.955532 [ 227823 ] {49f9ea5e-80c7-4677-af0f-e5579cd3518c} <Debug> executeQuery: (from [::1]:56374) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 395 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 396 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 397 | * a string isn't palatable for a few reasons. | ||
| 398 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 399 | * details. | ||
| 400 | */ | ||
| 401 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 402 | 2025.01.25 03:38:34.955598 [ 227823 ] {49f9ea5e-80c7-4677-af0f-e5579cd3518c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 403 | 2025.01.25 03:38:34.959498 [ 227823 ] {49f9ea5e-80c7-4677-af0f-e5579cd3518c} <Debug> oximeter.measurements_bytes (77259c17-43f5-499a-8ddc-5b615620c08a): Loading data parts | ||
| 404 | 2025.01.25 03:38:34.959827 [ 227823 ] {49f9ea5e-80c7-4677-af0f-e5579cd3518c} <Debug> oximeter.measurements_bytes (77259c17-43f5-499a-8ddc-5b615620c08a): There are no data parts | ||
| 405 | 2025.01.25 03:38:34.965599 [ 227823 ] {49f9ea5e-80c7-4677-af0f-e5579cd3518c} <Debug> TCPHandler: Processed in 0.01241687 sec. | ||
| 406 | 2025.01.25 03:38:34.970545 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 407 | 2025.01.25 03:38:34.972574 [ 227820 ] {eb7fd812-2c56-44e0-89f3-b714a79c41c6} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 408 | 2025.01.25 03:38:34.972645 [ 227820 ] {eb7fd812-2c56-44e0-89f3-b714a79c41c6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 409 | 2025.01.25 03:38:34.976718 [ 227820 ] {eb7fd812-2c56-44e0-89f3-b714a79c41c6} <Debug> oximeter.measurements_cumulativei64 (16c94533-4faf-44a0-af36-0b948ed4306e): Loading data parts | ||
| 410 | 2025.01.25 03:38:34.976997 [ 227820 ] {eb7fd812-2c56-44e0-89f3-b714a79c41c6} <Debug> oximeter.measurements_cumulativei64 (16c94533-4faf-44a0-af36-0b948ed4306e): There are no data parts | ||
| 411 | 2025.01.25 03:38:34.981097 [ 227820 ] {eb7fd812-2c56-44e0-89f3-b714a79c41c6} <Debug> TCPHandler: Processed in 0.010740191 sec. | ||
| 412 | 2025.01.25 03:38:34.984446 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 413 | 2025.01.25 03:38:34.984755 [ 227823 ] {5be8b731-6208-4bf5-b3a0-7138dcd39bd5} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 414 | 2025.01.25 03:38:34.984812 [ 227823 ] {5be8b731-6208-4bf5-b3a0-7138dcd39bd5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 415 | 2025.01.25 03:38:34.992912 [ 227823 ] {5be8b731-6208-4bf5-b3a0-7138dcd39bd5} <Debug> oximeter.measurements_cumulativeu64 (01b4305f-f7c8-433f-b629-52f4f232a673): Loading data parts | ||
| 416 | 2025.01.25 03:38:34.994309 [ 227823 ] {5be8b731-6208-4bf5-b3a0-7138dcd39bd5} <Debug> oximeter.measurements_cumulativeu64 (01b4305f-f7c8-433f-b629-52f4f232a673): There are no data parts | ||
| 417 | 2025.01.25 03:38:34.999671 [ 227823 ] {5be8b731-6208-4bf5-b3a0-7138dcd39bd5} <Debug> TCPHandler: Processed in 0.015347631 sec. | ||
| 418 | 2025.01.25 03:38:35.004356 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 419 | 2025.01.25 03:38:35.004703 [ 227820 ] {c10b8000-4e5d-4edb-b457-babcbb6581be} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 420 | 2025.01.25 03:38:35.004765 [ 227820 ] {c10b8000-4e5d-4edb-b457-babcbb6581be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 421 | 2025.01.25 03:38:35.009973 [ 227820 ] {c10b8000-4e5d-4edb-b457-babcbb6581be} <Debug> oximeter.measurements_cumulativef32 (fe0df5bf-dd63-4e9c-9260-f1731384f24d): Loading data parts | ||
| 422 | 2025.01.25 03:38:35.010378 [ 227820 ] {c10b8000-4e5d-4edb-b457-babcbb6581be} <Debug> oximeter.measurements_cumulativef32 (fe0df5bf-dd63-4e9c-9260-f1731384f24d): There are no data parts | ||
| 423 | 2025.01.25 03:38:35.025634 [ 227820 ] {c10b8000-4e5d-4edb-b457-babcbb6581be} <Debug> TCPHandler: Processed in 0.02148657 sec. | ||
| 424 | 2025.01.25 03:38:35.026580 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 425 | 2025.01.25 03:38:35.028347 [ 227823 ] {4755f602-d11b-47f3-9f7f-9bfb50bb7735} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 426 | 2025.01.25 03:38:35.028418 [ 227823 ] {4755f602-d11b-47f3-9f7f-9bfb50bb7735} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 427 | 2025.01.25 03:38:35.033367 [ 227823 ] {4755f602-d11b-47f3-9f7f-9bfb50bb7735} <Debug> oximeter.measurements_cumulativef64 (c90f0e0f-eead-46dc-b875-29027af946bc): Loading data parts | ||
| 428 | 2025.01.25 03:38:35.033660 [ 227823 ] {4755f602-d11b-47f3-9f7f-9bfb50bb7735} <Debug> oximeter.measurements_cumulativef64 (c90f0e0f-eead-46dc-b875-29027af946bc): There are no data parts | ||
| 429 | 2025.01.25 03:38:35.038831 [ 227823 ] {4755f602-d11b-47f3-9f7f-9bfb50bb7735} <Debug> TCPHandler: Processed in 0.01240632 sec. | ||
| 430 | 2025.01.25 03:38:35.039891 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 431 | 2025.01.25 03:38:35.041515 [ 227820 ] {a741ded6-5345-498c-b30a-97ebaf416e2f} <Debug> executeQuery: (from [::1]:56372) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 432 | * NOTE: Array types cannot be Nullable, see | ||
| 433 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 434 | * for more details. | ||
| 435 | * | ||
| 436 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 437 | * is unfortunate, and at this point relies on the fact that an | ||
| 438 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 439 | * to figure out another way to represent missing samples here. | ||
| 440 | */ | ||
| 441 | 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) | ||
| 442 | 2025.01.25 03:38:35.041599 [ 227820 ] {a741ded6-5345-498c-b30a-97ebaf416e2f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 443 | 2025.01.25 03:38:35.046613 [ 227820 ] {a741ded6-5345-498c-b30a-97ebaf416e2f} <Debug> oximeter.measurements_histogrami8 (1f02916d-339e-4826-8315-ee807cced00f): Loading data parts | ||
| 444 | 2025.01.25 03:38:35.047084 [ 227820 ] {a741ded6-5345-498c-b30a-97ebaf416e2f} <Debug> oximeter.measurements_histogrami8 (1f02916d-339e-4826-8315-ee807cced00f): There are no data parts | ||
| 445 | 2025.01.25 03:38:35.050738 [ 227820 ] {a741ded6-5345-498c-b30a-97ebaf416e2f} <Debug> TCPHandler: Processed in 0.011056821 sec. | ||
| 446 | 2025.01.25 03:38:35.051749 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2025.01.25 03:38:35.052141 [ 227823 ] {a1888132-d26c-4db2-8ba7-cd8bf5f5357f} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 448 | 2025.01.25 03:38:35.052215 [ 227823 ] {a1888132-d26c-4db2-8ba7-cd8bf5f5357f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 449 | 2025.01.25 03:38:35.058746 [ 227823 ] {a1888132-d26c-4db2-8ba7-cd8bf5f5357f} <Debug> oximeter.measurements_histogramu8 (f0c3ba0f-8b14-431a-a95b-d3d3bf7ec7c4): Loading data parts | ||
| 450 | 2025.01.25 03:38:35.059065 [ 227823 ] {a1888132-d26c-4db2-8ba7-cd8bf5f5357f} <Debug> oximeter.measurements_histogramu8 (f0c3ba0f-8b14-431a-a95b-d3d3bf7ec7c4): There are no data parts | ||
| 451 | 2025.01.25 03:38:35.066541 [ 227823 ] {a1888132-d26c-4db2-8ba7-cd8bf5f5357f} <Debug> TCPHandler: Processed in 0.014997811 sec. | ||
| 452 | 2025.01.25 03:38:35.092307 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2025.01.25 03:38:35.092720 [ 227820 ] {e01d3fc4-02fa-4797-87e6-a112077e0870} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 454 | 2025.01.25 03:38:35.092797 [ 227820 ] {e01d3fc4-02fa-4797-87e6-a112077e0870} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 455 | 2025.01.25 03:38:35.099412 [ 227820 ] {e01d3fc4-02fa-4797-87e6-a112077e0870} <Debug> oximeter.measurements_histogrami16 (5288de42-804e-4e96-baa8-7f60ae6d9511): Loading data parts | ||
| 456 | 2025.01.25 03:38:35.100591 [ 227820 ] {e01d3fc4-02fa-4797-87e6-a112077e0870} <Debug> oximeter.measurements_histogrami16 (5288de42-804e-4e96-baa8-7f60ae6d9511): There are no data parts | ||
| 457 | 2025.01.25 03:38:35.105704 [ 227820 ] {e01d3fc4-02fa-4797-87e6-a112077e0870} <Debug> TCPHandler: Processed in 0.013597 sec. | ||
| 458 | 2025.01.25 03:38:35.106587 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 459 | 2025.01.25 03:38:35.106998 [ 227823 ] {ee042555-229d-4429-ab23-585136da15ba} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 460 | 2025.01.25 03:38:35.107070 [ 227823 ] {ee042555-229d-4429-ab23-585136da15ba} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 461 | 2025.01.25 03:38:35.114542 [ 227823 ] {ee042555-229d-4429-ab23-585136da15ba} <Debug> oximeter.measurements_histogramu16 (2ad2f959-f021-4883-910b-a867b6f2c816): Loading data parts | ||
| 462 | 2025.01.25 03:38:35.115770 [ 227823 ] {ee042555-229d-4429-ab23-585136da15ba} <Debug> oximeter.measurements_histogramu16 (2ad2f959-f021-4883-910b-a867b6f2c816): There are no data parts | ||
| 463 | 2025.01.25 03:38:35.120723 [ 227823 ] {ee042555-229d-4429-ab23-585136da15ba} <Debug> TCPHandler: Processed in 0.01431866 sec. | ||
| 464 | 2025.01.25 03:38:35.123348 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2025.01.25 03:38:35.125533 [ 227820 ] {06265a5b-5ab4-41f8-a69a-d258d5067b9e} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 466 | 2025.01.25 03:38:35.125593 [ 227820 ] {06265a5b-5ab4-41f8-a69a-d258d5067b9e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 467 | 2025.01.25 03:38:35.131449 [ 227820 ] {06265a5b-5ab4-41f8-a69a-d258d5067b9e} <Debug> oximeter.measurements_histogrami32 (64ea644c-1904-4812-bb5d-fa201604908f): Loading data parts | ||
| 468 | 2025.01.25 03:38:35.131828 [ 227820 ] {06265a5b-5ab4-41f8-a69a-d258d5067b9e} <Debug> oximeter.measurements_histogrami32 (64ea644c-1904-4812-bb5d-fa201604908f): There are no data parts | ||
| 469 | 2025.01.25 03:38:35.137807 [ 227820 ] {06265a5b-5ab4-41f8-a69a-d258d5067b9e} <Debug> TCPHandler: Processed in 0.0146615 sec. | ||
| 470 | 2025.01.25 03:38:35.138737 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2025.01.25 03:38:35.140908 [ 227823 ] {3a238b0d-3a5e-46b6-b1fe-6bb106bdd004} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 472 | 2025.01.25 03:38:35.140982 [ 227823 ] {3a238b0d-3a5e-46b6-b1fe-6bb106bdd004} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 473 | 2025.01.25 03:38:35.145352 [ 227823 ] {3a238b0d-3a5e-46b6-b1fe-6bb106bdd004} <Debug> oximeter.measurements_histogramu32 (d676c249-558c-40be-a737-8bfe500c4eca): Loading data parts | ||
| 474 | 2025.01.25 03:38:35.145598 [ 227823 ] {3a238b0d-3a5e-46b6-b1fe-6bb106bdd004} <Debug> oximeter.measurements_histogramu32 (d676c249-558c-40be-a737-8bfe500c4eca): There are no data parts | ||
| 475 | 2025.01.25 03:38:35.149561 [ 227823 ] {3a238b0d-3a5e-46b6-b1fe-6bb106bdd004} <Debug> TCPHandler: Processed in 0.01099926 sec. | ||
| 476 | 2025.01.25 03:38:35.150440 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2025.01.25 03:38:35.150832 [ 227820 ] {869d72a0-9ca2-42b3-a333-9f90f5f40e0f} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 478 | 2025.01.25 03:38:35.150920 [ 227820 ] {869d72a0-9ca2-42b3-a333-9f90f5f40e0f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 479 | 2025.01.25 03:38:35.169810 [ 227820 ] {869d72a0-9ca2-42b3-a333-9f90f5f40e0f} <Debug> oximeter.measurements_histogrami64 (1d6fb51f-02b6-409c-9c4f-e113082b0a8e): Loading data parts | ||
| 480 | 2025.01.25 03:38:35.170166 [ 227820 ] {869d72a0-9ca2-42b3-a333-9f90f5f40e0f} <Debug> oximeter.measurements_histogrami64 (1d6fb51f-02b6-409c-9c4f-e113082b0a8e): There are no data parts | ||
| 481 | 2025.01.25 03:38:35.175934 [ 227820 ] {869d72a0-9ca2-42b3-a333-9f90f5f40e0f} <Debug> TCPHandler: Processed in 0.02567734 sec. | ||
| 482 | 2025.01.25 03:38:35.176843 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2025.01.25 03:38:35.177209 [ 227823 ] {d97682ab-d576-4a19-8d5a-5752a97a21cb} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 484 | 2025.01.25 03:38:35.178705 [ 227823 ] {d97682ab-d576-4a19-8d5a-5752a97a21cb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 485 | 2025.01.25 03:38:35.183770 [ 227823 ] {d97682ab-d576-4a19-8d5a-5752a97a21cb} <Debug> oximeter.measurements_histogramu64 (870c279a-79b3-4d9f-bcc5-8d3bf5e46504): Loading data parts | ||
| 486 | 2025.01.25 03:38:35.184046 [ 227823 ] {d97682ab-d576-4a19-8d5a-5752a97a21cb} <Debug> oximeter.measurements_histogramu64 (870c279a-79b3-4d9f-bcc5-8d3bf5e46504): There are no data parts | ||
| 487 | 2025.01.25 03:38:35.188013 [ 227823 ] {d97682ab-d576-4a19-8d5a-5752a97a21cb} <Debug> TCPHandler: Processed in 0.011361589 sec. | ||
| 488 | 2025.01.25 03:38:35.189295 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2025.01.25 03:38:35.189627 [ 227820 ] {95a0a7a8-e6e5-4166-9590-27fc3ff98a17} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 490 | 2025.01.25 03:38:35.189680 [ 227820 ] {95a0a7a8-e6e5-4166-9590-27fc3ff98a17} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 491 | 2025.01.25 03:38:35.197682 [ 227820 ] {95a0a7a8-e6e5-4166-9590-27fc3ff98a17} <Debug> oximeter.measurements_histogramf32 (202d744b-eb57-4190-97e9-a4dd2f40ccff): Loading data parts | ||
| 492 | 2025.01.25 03:38:35.198346 [ 227820 ] {95a0a7a8-e6e5-4166-9590-27fc3ff98a17} <Debug> oximeter.measurements_histogramf32 (202d744b-eb57-4190-97e9-a4dd2f40ccff): There are no data parts | ||
| 493 | 2025.01.25 03:38:35.203438 [ 227820 ] {95a0a7a8-e6e5-4166-9590-27fc3ff98a17} <Debug> TCPHandler: Processed in 0.01432104 sec. | ||
| 494 | 2025.01.25 03:38:35.204543 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2025.01.25 03:38:35.204915 [ 227823 ] {56a99d16-01b5-472c-b893-42f3c0bb8108} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 496 | 2025.01.25 03:38:35.204969 [ 227823 ] {56a99d16-01b5-472c-b893-42f3c0bb8108} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 497 | 2025.01.25 03:38:35.209940 [ 227823 ] {56a99d16-01b5-472c-b893-42f3c0bb8108} <Debug> oximeter.measurements_histogramf64 (41949613-2750-4462-a572-caf8c13daa8d): Loading data parts | ||
| 498 | 2025.01.25 03:38:35.210286 [ 227823 ] {56a99d16-01b5-472c-b893-42f3c0bb8108} <Debug> oximeter.measurements_histogramf64 (41949613-2750-4462-a572-caf8c13daa8d): There are no data parts | ||
| 499 | 2025.01.25 03:38:35.215741 [ 227823 ] {56a99d16-01b5-472c-b893-42f3c0bb8108} <Debug> TCPHandler: Processed in 0.01133221 sec. | ||
| 500 | 2025.01.25 03:38:35.217249 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 501 | 2025.01.25 03:38:35.217518 [ 227820 ] {45738696-4ae4-4059-b77d-57f456794b1c} <Debug> executeQuery: (from [::1]:56372) /* The field tables store named dimensions of each timeseries. | ||
| 502 | * | ||
| 503 | * As with the measurement tables, there is one field table for each field data | ||
| 504 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 505 | * this behavior **must not** be relied upon for query correctness. | ||
| 506 | * | ||
| 507 | * The index for the fields differs from the measurements, however. Rows are | ||
| 508 | * sorted by timeseries name, then field name, field value, and finally | ||
| 509 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 510 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 511 | * usually then used to look up measurements. | ||
| 512 | * | ||
| 513 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 514 | * timeseries name and then key, since it would improve lookups where one | ||
| 515 | * already has the key. Realistically though, these tables are quite small and | ||
| 516 | * so performance benefits will be low in absolute terms. | ||
| 517 | * | ||
| 518 | * TTL: We use a materialized column to expire old field table records. This | ||
| 519 | * column is generated automatically by the database whenever a new row is | ||
| 520 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 521 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 522 | * record will remain during a deduplication, which will have the last | ||
| 523 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 524 | * measurement tables. | ||
| 525 | */ | ||
| 526 | 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) | ||
| 527 | 2025.01.25 03:38:35.217584 [ 227820 ] {45738696-4ae4-4059-b77d-57f456794b1c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 528 | 2025.01.25 03:38:35.222127 [ 227820 ] {45738696-4ae4-4059-b77d-57f456794b1c} <Debug> oximeter.fields_bool (40a28ebc-c937-4201-8d60-8850662f73ea): Loading data parts | ||
| 529 | 2025.01.25 03:38:35.222353 [ 227820 ] {45738696-4ae4-4059-b77d-57f456794b1c} <Debug> oximeter.fields_bool (40a28ebc-c937-4201-8d60-8850662f73ea): There are no data parts | ||
| 530 | 2025.01.25 03:38:35.227605 [ 227820 ] {45738696-4ae4-4059-b77d-57f456794b1c} <Debug> TCPHandler: Processed in 0.01052693 sec. | ||
| 531 | 2025.01.25 03:38:35.228574 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 532 | 2025.01.25 03:38:35.228861 [ 227823 ] {765c6583-dfc3-4815-99c6-d032b7743eec} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 533 | 2025.01.25 03:38:35.228919 [ 227823 ] {765c6583-dfc3-4815-99c6-d032b7743eec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 534 | 2025.01.25 03:38:35.234963 [ 227823 ] {765c6583-dfc3-4815-99c6-d032b7743eec} <Debug> oximeter.fields_i8 (f004269f-e94f-421a-b6d5-a1659762fa9e): Loading data parts | ||
| 535 | 2025.01.25 03:38:35.235285 [ 227823 ] {765c6583-dfc3-4815-99c6-d032b7743eec} <Debug> oximeter.fields_i8 (f004269f-e94f-421a-b6d5-a1659762fa9e): There are no data parts | ||
| 536 | 2025.01.25 03:38:35.239214 [ 227823 ] {765c6583-dfc3-4815-99c6-d032b7743eec} <Debug> TCPHandler: Processed in 0.01080792 sec. | ||
| 537 | 2025.01.25 03:38:35.240028 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 538 | 2025.01.25 03:38:35.240300 [ 227820 ] {57f655bb-5dc2-4d2c-b94c-3cf422d4b85a} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 539 | 2025.01.25 03:38:35.240360 [ 227820 ] {57f655bb-5dc2-4d2c-b94c-3cf422d4b85a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 540 | 2025.01.25 03:38:35.244716 [ 227820 ] {57f655bb-5dc2-4d2c-b94c-3cf422d4b85a} <Debug> oximeter.fields_u8 (66e129b6-7023-4fc6-af30-0ffdabdea8a4): Loading data parts | ||
| 541 | 2025.01.25 03:38:35.245005 [ 227820 ] {57f655bb-5dc2-4d2c-b94c-3cf422d4b85a} <Debug> oximeter.fields_u8 (66e129b6-7023-4fc6-af30-0ffdabdea8a4): There are no data parts | ||
| 542 | 2025.01.25 03:38:35.249812 [ 227820 ] {57f655bb-5dc2-4d2c-b94c-3cf422d4b85a} <Debug> TCPHandler: Processed in 0.009909701 sec. | ||
| 543 | 2025.01.25 03:38:35.250670 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2025.01.25 03:38:35.250915 [ 227823 ] {409c6e4f-de1a-4202-8f8b-2b5d1a1e0420} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 545 | 2025.01.25 03:38:35.250981 [ 227823 ] {409c6e4f-de1a-4202-8f8b-2b5d1a1e0420} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 546 | 2025.01.25 03:38:35.256350 [ 227823 ] {409c6e4f-de1a-4202-8f8b-2b5d1a1e0420} <Debug> oximeter.fields_i16 (9c9ed512-84e8-460c-abfb-246442cfecee): Loading data parts | ||
| 547 | 2025.01.25 03:38:35.256645 [ 227823 ] {409c6e4f-de1a-4202-8f8b-2b5d1a1e0420} <Debug> oximeter.fields_i16 (9c9ed512-84e8-460c-abfb-246442cfecee): There are no data parts | ||
| 548 | 2025.01.25 03:38:35.262157 [ 227823 ] {409c6e4f-de1a-4202-8f8b-2b5d1a1e0420} <Debug> TCPHandler: Processed in 0.011635131 sec. | ||
| 549 | 2025.01.25 03:38:35.262984 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2025.01.25 03:38:35.263219 [ 227820 ] {04332986-ca9b-472f-9309-275d6ee5cbc5} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 551 | 2025.01.25 03:38:35.263263 [ 227820 ] {04332986-ca9b-472f-9309-275d6ee5cbc5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 552 | 2025.01.25 03:38:35.269522 [ 227820 ] {04332986-ca9b-472f-9309-275d6ee5cbc5} <Debug> oximeter.fields_u16 (c0843a68-6644-41be-bbf3-d2c872d7f188): Loading data parts | ||
| 553 | 2025.01.25 03:38:35.269844 [ 227820 ] {04332986-ca9b-472f-9309-275d6ee5cbc5} <Debug> oximeter.fields_u16 (c0843a68-6644-41be-bbf3-d2c872d7f188): There are no data parts | ||
| 554 | 2025.01.25 03:38:35.273478 [ 227820 ] {04332986-ca9b-472f-9309-275d6ee5cbc5} <Debug> TCPHandler: Processed in 0.01066824 sec. | ||
| 555 | 2025.01.25 03:38:35.274307 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2025.01.25 03:38:35.275919 [ 227823 ] {bfbd0534-11a5-4c26-b0e3-ae760016070d} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 557 | 2025.01.25 03:38:35.275984 [ 227823 ] {bfbd0534-11a5-4c26-b0e3-ae760016070d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 558 | 2025.01.25 03:38:35.282723 [ 227823 ] {bfbd0534-11a5-4c26-b0e3-ae760016070d} <Debug> oximeter.fields_i32 (e635c8f2-0634-4882-8fb6-2a5d0594f52f): Loading data parts | ||
| 559 | 2025.01.25 03:38:35.283057 [ 227823 ] {bfbd0534-11a5-4c26-b0e3-ae760016070d} <Debug> oximeter.fields_i32 (e635c8f2-0634-4882-8fb6-2a5d0594f52f): There are no data parts | ||
| 560 | 2025.01.25 03:38:35.287476 [ 227823 ] {bfbd0534-11a5-4c26-b0e3-ae760016070d} <Debug> TCPHandler: Processed in 0.01333401 sec. | ||
| 561 | 2025.01.25 03:38:35.288492 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2025.01.25 03:38:35.288796 [ 227820 ] {3e356a80-446b-468e-a0eb-14e72174397e} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 563 | 2025.01.25 03:38:35.288863 [ 227820 ] {3e356a80-446b-468e-a0eb-14e72174397e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 564 | 2025.01.25 03:38:35.294844 [ 227820 ] {3e356a80-446b-468e-a0eb-14e72174397e} <Debug> oximeter.fields_u32 (02b465bd-e03a-4af4-9452-96bc4d55db16): Loading data parts | ||
| 565 | 2025.01.25 03:38:35.295972 [ 227820 ] {3e356a80-446b-468e-a0eb-14e72174397e} <Debug> oximeter.fields_u32 (02b465bd-e03a-4af4-9452-96bc4d55db16): There are no data parts | ||
| 566 | 2025.01.25 03:38:35.299841 [ 227820 ] {3e356a80-446b-468e-a0eb-14e72174397e} <Debug> TCPHandler: Processed in 0.01152818 sec. | ||
| 567 | 2025.01.25 03:38:35.300723 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2025.01.25 03:38:35.300980 [ 227823 ] {ea9890f6-0614-4ce0-b883-8a8956b24b1e} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 569 | 2025.01.25 03:38:35.301030 [ 227823 ] {ea9890f6-0614-4ce0-b883-8a8956b24b1e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 570 | 2025.01.25 03:38:35.306795 [ 227823 ] {ea9890f6-0614-4ce0-b883-8a8956b24b1e} <Debug> oximeter.fields_i64 (46b09757-4b8b-402e-8b31-df8db08e541c): Loading data parts | ||
| 571 | 2025.01.25 03:38:35.307075 [ 227823 ] {ea9890f6-0614-4ce0-b883-8a8956b24b1e} <Debug> oximeter.fields_i64 (46b09757-4b8b-402e-8b31-df8db08e541c): There are no data parts | ||
| 572 | 2025.01.25 03:38:35.312033 [ 227823 ] {ea9890f6-0614-4ce0-b883-8a8956b24b1e} <Debug> TCPHandler: Processed in 0.011491391 sec. | ||
| 573 | 2025.01.25 03:38:35.312930 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2025.01.25 03:38:35.313166 [ 227820 ] {ad4466fc-6e1a-48b3-963f-41bd19b22b0e} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 575 | 2025.01.25 03:38:35.313213 [ 227820 ] {ad4466fc-6e1a-48b3-963f-41bd19b22b0e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 576 | 2025.01.25 03:38:35.320195 [ 227820 ] {ad4466fc-6e1a-48b3-963f-41bd19b22b0e} <Debug> oximeter.fields_u64 (dbfe80f0-4660-44ac-a013-7d722d80413e): Loading data parts | ||
| 577 | 2025.01.25 03:38:35.320510 [ 227820 ] {ad4466fc-6e1a-48b3-963f-41bd19b22b0e} <Debug> oximeter.fields_u64 (dbfe80f0-4660-44ac-a013-7d722d80413e): There are no data parts | ||
| 578 | 2025.01.25 03:38:35.325225 [ 227820 ] {ad4466fc-6e1a-48b3-963f-41bd19b22b0e} <Debug> TCPHandler: Processed in 0.012454171 sec. | ||
| 579 | 2025.01.25 03:38:35.326301 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2025.01.25 03:38:35.326621 [ 227823 ] {c6dfab8c-4b89-4a92-9375-13c4e2decc7d} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 581 | 2025.01.25 03:38:35.326678 [ 227823 ] {c6dfab8c-4b89-4a92-9375-13c4e2decc7d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 582 | 2025.01.25 03:38:35.332429 [ 227823 ] {c6dfab8c-4b89-4a92-9375-13c4e2decc7d} <Debug> oximeter.fields_ipaddr (73d221a4-b3b4-413b-a140-f28a3816f438): Loading data parts | ||
| 583 | 2025.01.25 03:38:35.334721 [ 227823 ] {c6dfab8c-4b89-4a92-9375-13c4e2decc7d} <Debug> oximeter.fields_ipaddr (73d221a4-b3b4-413b-a140-f28a3816f438): There are no data parts | ||
| 584 | 2025.01.25 03:38:35.340229 [ 227823 ] {c6dfab8c-4b89-4a92-9375-13c4e2decc7d} <Debug> TCPHandler: Processed in 0.0141037 sec. | ||
| 585 | 2025.01.25 03:38:35.341228 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2025.01.25 03:38:35.341471 [ 227820 ] {7e19d052-e907-47cb-9bc7-011196e708cc} <Debug> executeQuery: (from [::1]:56372) 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) | ||
| 587 | 2025.01.25 03:38:35.341519 [ 227820 ] {7e19d052-e907-47cb-9bc7-011196e708cc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 588 | 2025.01.25 03:38:35.345805 [ 227820 ] {7e19d052-e907-47cb-9bc7-011196e708cc} <Debug> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Loading data parts | ||
| 589 | 2025.01.25 03:38:35.348031 [ 227820 ] {7e19d052-e907-47cb-9bc7-011196e708cc} <Debug> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): There are no data parts | ||
| 590 | 2025.01.25 03:38:35.351397 [ 227820 ] {7e19d052-e907-47cb-9bc7-011196e708cc} <Debug> TCPHandler: Processed in 0.01040637 sec. | ||
| 591 | 2025.01.25 03:38:35.352267 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2025.01.25 03:38:35.353009 [ 227823 ] {21fd1f04-abd5-4b35-94ad-2488b217c712} <Debug> executeQuery: (from [::1]:56374) 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) | ||
| 593 | 2025.01.25 03:38:35.353071 [ 227823 ] {21fd1f04-abd5-4b35-94ad-2488b217c712} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 594 | 2025.01.25 03:38:35.357896 [ 227823 ] {21fd1f04-abd5-4b35-94ad-2488b217c712} <Debug> oximeter.fields_uuid (f6ae3882-b4cd-4363-949e-7edf8cbb1f27): Loading data parts | ||
| 595 | 2025.01.25 03:38:35.358161 [ 227823 ] {21fd1f04-abd5-4b35-94ad-2488b217c712} <Debug> oximeter.fields_uuid (f6ae3882-b4cd-4363-949e-7edf8cbb1f27): There are no data parts | ||
| 596 | 2025.01.25 03:38:35.364442 [ 227823 ] {21fd1f04-abd5-4b35-94ad-2488b217c712} <Debug> TCPHandler: Processed in 0.01233067 sec. | ||
| 597 | 2025.01.25 03:38:35.365424 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 598 | 2025.01.25 03:38:35.367067 [ 227820 ] {4dd3302c-4e8a-4c81-96bd-e0a4ffb19c94} <Debug> executeQuery: (from [::1]:56372) /* The timeseries schema table stores the extracted schema for the samples | ||
| 599 | * oximeter collects. | ||
| 600 | */ | ||
| 601 | 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) | ||
| 602 | 2025.01.25 03:38:35.367141 [ 227820 ] {4dd3302c-4e8a-4c81-96bd-e0a4ffb19c94} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 603 | 2025.01.25 03:38:35.371527 [ 227820 ] {4dd3302c-4e8a-4c81-96bd-e0a4ffb19c94} <Debug> oximeter.timeseries_schema (a2a8572f-46c0-4e71-8ba2-4bef2574e3a4): Loading data parts | ||
| 604 | 2025.01.25 03:38:35.371800 [ 227820 ] {4dd3302c-4e8a-4c81-96bd-e0a4ffb19c94} <Debug> oximeter.timeseries_schema (a2a8572f-46c0-4e71-8ba2-4bef2574e3a4): There are no data parts | ||
| 605 | 2025.01.25 03:38:35.376082 [ 227820 ] {4dd3302c-4e8a-4c81-96bd-e0a4ffb19c94} <Debug> TCPHandler: Processed in 0.01086035 sec. | ||
| 606 | 2025.01.25 03:38:35.376919 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 607 | 2025.01.25 03:38:35.377063 [ 227823 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 608 | 2025.01.25 03:38:35.377141 [ 227823 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 609 | 2025.01.25 03:38:35.377811 [ 227672 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Trace> oximeter.version (86143271-f609-416e-be91-6875c55e8a19): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 610 | 2025.01.25 03:38:35.377832 [ 227672 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.74 GiB. | ||
| 611 | 2025.01.25 03:38:35.378072 [ 227672 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 612 | 2025.01.25 03:38:35.378197 [ 227672 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Trace> oximeter.version (86143271-f609-416e-be91-6875c55e8a19): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 613 | 2025.01.25 03:38:35.378370 [ 227823 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.001348 sec., 741.839762611276 rows/sec., 11.59 KiB/sec. | ||
| 614 | 2025.01.25 03:38:35.378505 [ 227823 ] {ccce41d5-7142-4677-918e-ec4361c29096} <Debug> TCPHandler: Processed in 0.001764911 sec. | ||
| 615 | 2025.01.25 03:38:37.382928 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 616 | 2025.01.25 03:38:37.383145 [ 227820 ] {ea96bc9c-5ed2-4e55-9dbc-a3bfce4cb824} <Debug> executeQuery: (from [::1]:56372) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 617 | 2025.01.25 03:38:37.383428 [ 227820 ] {ea96bc9c-5ed2-4e55-9dbc-a3bfce4cb824} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 618 | 2025.01.25 03:38:37.383480 [ 227820 ] {ea96bc9c-5ed2-4e55-9dbc-a3bfce4cb824} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 619 | 2025.01.25 03:38:37.384235 [ 227820 ] {ea96bc9c-5ed2-4e55-9dbc-a3bfce4cb824} <Debug> TCPHandler: Processed in 0.00152038 sec. | ||
| 620 | 2025.01.25 03:38:37.385241 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 621 | 2025.01.25 03:38:37.385371 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 622 | 2025.01.25 03:38:37.385411 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 623 | 2025.01.25 03:38:37.386875 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Trace> oximeter.timeseries_schema (a2a8572f-46c0-4e71-8ba2-4bef2574e3a4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 624 | 2025.01.25 03:38:37.386910 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.03 GiB. | ||
| 625 | 2025.01.25 03:38:37.387405 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 626 | 2025.01.25 03:38:37.387582 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Trace> oximeter.timeseries_schema (a2a8572f-46c0-4e71-8ba2-4bef2574e3a4): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 627 | 2025.01.25 03:38:37.387807 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002472 sec., 404.5307443365696 rows/sec., 48.59 KiB/sec. | ||
| 628 | 2025.01.25 03:38:37.387875 [ 227823 ] {25dcd878-58d3-4bb4-9e75-0cd7119aecd3} <Debug> TCPHandler: Processed in 0.00271624 sec. | ||
| 629 | 2025.01.25 03:38:37.388375 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 630 | 2025.01.25 03:38:37.388499 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 631 | 2025.01.25 03:38:37.388538 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 632 | 2025.01.25 03:38:37.389264 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 633 | 2025.01.25 03:38:37.389286 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.03 GiB. | ||
| 634 | 2025.01.25 03:38:37.389598 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 635 | 2025.01.25 03:38:37.389784 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 636 | 2025.01.25 03:38:37.389939 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.001476 sec., 1355.0135501355012 rows/sec., 140.27 KiB/sec. | ||
| 637 | 2025.01.25 03:38:37.389972 [ 227820 ] {801a6d66-845e-4652-87e9-fd4f6e2a696e} <Debug> TCPHandler: Processed in 0.00167583 sec. | ||
| 638 | 2025.01.25 03:38:37.390598 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 639 | 2025.01.25 03:38:37.390724 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 640 | 2025.01.25 03:38:37.390760 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 641 | 2025.01.25 03:38:37.391376 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 642 | 2025.01.25 03:38:37.391397 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.03 GiB. | ||
| 643 | 2025.01.25 03:38:37.391687 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 644 | 2025.01.25 03:38:37.392002 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 645 | 2025.01.25 03:38:37.392168 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001489 sec., 671.591672263264 rows/sec., 46.57 KiB/sec. | ||
| 646 | 2025.01.25 03:38:37.392204 [ 227823 ] {bc86af72-e10e-44be-bd80-5c0e98674a0b} <Debug> TCPHandler: Processed in 0.001670911 sec. | ||
| 647 | 2025.01.25 03:38:38.382690 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 648 | 2025.01.25 03:38:38.382904 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 649 | 2025.01.25 03:38:38.382972 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 650 | 2025.01.25 03:38:38.383998 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 651 | 2025.01.25 03:38:38.384035 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.17 GiB. | ||
| 652 | 2025.01.25 03:38:38.384511 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 653 | 2025.01.25 03:38:38.384738 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 654 | 2025.01.25 03:38:38.384950 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.00211 sec., 947.8672985781991 rows/sec., 98.12 KiB/sec. | ||
| 655 | 2025.01.25 03:38:38.384990 [ 227820 ] {2a5036d6-ece3-445a-9e29-874ff34985e2} <Debug> TCPHandler: Processed in 0.00250872 sec. | ||
| 656 | 2025.01.25 03:38:38.385546 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 657 | 2025.01.25 03:38:38.385686 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 658 | 2025.01.25 03:38:38.385733 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 659 | 2025.01.25 03:38:38.386415 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 660 | 2025.01.25 03:38:38.386443 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.17 GiB. | ||
| 661 | 2025.01.25 03:38:38.386794 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 662 | 2025.01.25 03:38:38.386968 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 663 | 2025.01.25 03:38:38.387175 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001518 sec., 658.7615283267457 rows/sec., 45.68 KiB/sec. | ||
| 664 | 2025.01.25 03:38:38.387216 [ 227823 ] {fa882dfa-aa96-461f-b1d8-efc487decceb} <Debug> TCPHandler: Processed in 0.00176438 sec. | ||
| 665 | 2025.01.25 03:38:39.382858 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 666 | 2025.01.25 03:38:39.383071 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 667 | 2025.01.25 03:38:39.383141 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 668 | 2025.01.25 03:38:39.384107 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 669 | 2025.01.25 03:38:39.385359 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.76 GiB. | ||
| 670 | 2025.01.25 03:38:39.385742 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 671 | 2025.01.25 03:38:39.385949 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 672 | 2025.01.25 03:38:39.386164 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003146 sec., 635.7279084551813 rows/sec., 65.81 KiB/sec. | ||
| 673 | 2025.01.25 03:38:39.386215 [ 227820 ] {f5dad1af-250c-4df5-9953-3dee5c3c4876} <Debug> TCPHandler: Processed in 0.00358552 sec. | ||
| 674 | 2025.01.25 03:38:39.387572 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2025.01.25 03:38:39.387756 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 676 | 2025.01.25 03:38:39.387826 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 677 | 2025.01.25 03:38:39.388629 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 678 | 2025.01.25 03:38:39.389805 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.69 GiB. | ||
| 679 | 2025.01.25 03:38:39.390227 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 680 | 2025.01.25 03:38:39.390439 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 681 | 2025.01.25 03:38:39.390648 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002959 sec., 337.95201081446436 rows/sec., 23.43 KiB/sec. | ||
| 682 | 2025.01.25 03:38:39.390692 [ 227823 ] {4bf7883a-f6e9-423c-9aa5-e6a0c24bd248} <Debug> TCPHandler: Processed in 0.00326479 sec. | ||
| 683 | 2025.01.25 03:38:39.496219 [ 227082 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 684 | 2025.01.25 03:38:39.496264 [ 227082 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 685 | 2025.01.25 03:38:39.561426 [ 227309 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1622 entries to flush up to offset 3582 | ||
| 686 | 2025.01.25 03:38:39.562408 [ 227309 ] {} <Trace> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 687 | 2025.01.25 03:38:39.562433 [ 227309 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.69 GiB. | ||
| 688 | 2025.01.25 03:38:39.564366 [ 227309 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 689 | 2025.01.25 03:38:39.564558 [ 227309 ] {} <Trace> system.asynchronous_metric_log (b11c0d22-9731-4c0e-9e11-cb0dc02dcc04): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 690 | 2025.01.25 03:38:39.564694 [ 227309 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3582 | ||
| 691 | 2025.01.25 03:38:39.609413 [ 227308 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
| 692 | 2025.01.25 03:38:39.628223 [ 227308 ] {} <Trace> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 693 | 2025.01.25 03:38:39.628266 [ 227308 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.62 GiB. | ||
| 694 | 2025.01.25 03:38:39.634708 [ 227308 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 695 | 2025.01.25 03:38:39.635423 [ 227308 ] {} <Trace> system.metric_log (7dc742bb-7b17-41a7-a675-83397763f062): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 696 | 2025.01.25 03:38:39.637549 [ 227308 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
| 697 | 2025.01.25 03:38:40.000428 [ 227312 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 402.57 MiB, peak 410.57 MiB, free memory in arenas 30.45 MiB, will set to 412.25 MiB (RSS), difference: 9.68 MiB | ||
| 698 | 2025.01.25 03:38:40.383642 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2025.01.25 03:38:40.383897 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 700 | 2025.01.25 03:38:40.383972 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 701 | 2025.01.25 03:38:40.385019 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 702 | 2025.01.25 03:38:40.385372 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.96 GiB. | ||
| 703 | 2025.01.25 03:38:40.385767 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 704 | 2025.01.25 03:38:40.385979 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 705 | 2025.01.25 03:38:40.386193 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002374 sec., 842.4599831508004 rows/sec., 87.21 KiB/sec. | ||
| 706 | 2025.01.25 03:38:40.386241 [ 227820 ] {5819ce7d-ad3a-4e07-802f-60ca4da04f31} <Debug> TCPHandler: Processed in 0.00280984 sec. | ||
| 707 | 2025.01.25 03:38:40.386858 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 708 | 2025.01.25 03:38:40.386997 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 709 | 2025.01.25 03:38:40.387048 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 710 | 2025.01.25 03:38:40.387756 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 711 | 2025.01.25 03:38:40.387789 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.96 GiB. | ||
| 712 | 2025.01.25 03:38:40.388103 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 713 | 2025.01.25 03:38:40.388296 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 714 | 2025.01.25 03:38:40.388478 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001519 sec., 658.3278472679394 rows/sec., 45.65 KiB/sec. | ||
| 715 | 2025.01.25 03:38:40.388523 [ 227823 ] {2b576c0f-979d-4b6f-9c24-55abff9738ed} <Debug> TCPHandler: Processed in 0.00176601 sec. | ||
| 716 | 2025.01.25 03:38:41.483964 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 717 | 2025.01.25 03:38:41.484676 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 718 | 2025.01.25 03:38:41.484749 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 719 | 2025.01.25 03:38:41.486777 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 720 | 2025.01.25 03:38:41.486805 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.89 GiB. | ||
| 721 | 2025.01.25 03:38:41.487187 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 722 | 2025.01.25 03:38:41.487388 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 723 | 2025.01.25 03:38:41.487540 [ 227167 ] {} <Debug> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 724 | 2025.01.25 03:38:41.487571 [ 227167 ] {} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 725 | 2025.01.25 03:38:41.487584 [ 227167 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.89 GiB. | ||
| 726 | 2025.01.25 03:38:41.487622 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003008 sec., 664.8936170212767 rows/sec., 68.83 KiB/sec. | ||
| 727 | 2025.01.25 03:38:41.487684 [ 227820 ] {c6c92a63-8ec5-431b-857d-81d182cccbd9} <Debug> TCPHandler: Processed in 0.003900371 sec. | ||
| 728 | 2025.01.25 03:38:41.487863 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 729 | 2025.01.25 03:38:41.487953 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 730 | 2025.01.25 03:38:41.487976 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
| 731 | 2025.01.25 03:38:41.488075 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
| 732 | 2025.01.25 03:38:41.488120 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
| 733 | 2025.01.25 03:38:41.488168 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
| 734 | 2025.01.25 03:38:41.488298 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
| 735 | 2025.01.25 03:38:41.488539 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 736 | 2025.01.25 03:38:41.488671 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 737 | 2025.01.25 03:38:41.488719 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 738 | 2025.01.25 03:38:41.528343 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.040601251 sec., 246.29782959150694 rows/sec., 26.46 KiB/sec. | ||
| 739 | 2025.01.25 03:38:41.528529 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 740 | 2025.01.25 03:38:41.528816 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 741 | 2025.01.25 03:38:41.528861 [ 227271 ] {f2fe6f85-f37c-4daa-84b6-095e6aaafe37::all_1_5_1} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 742 | 2025.01.25 03:38:41.528933 [ 227271 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.34 MiB. | ||
| 743 | 2025.01.25 03:38:41.532166 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 744 | 2025.01.25 03:38:41.532379 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.89 GiB. | ||
| 745 | 2025.01.25 03:38:41.532725 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 746 | 2025.01.25 03:38:41.532944 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 747 | 2025.01.25 03:38:41.533092 [ 227135 ] {} <Debug> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 748 | 2025.01.25 03:38:41.533129 [ 227135 ] {} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 749 | 2025.01.25 03:38:41.533145 [ 227135 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.89 GiB. | ||
| 750 | 2025.01.25 03:38:41.533177 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.04454 sec., 22.451728783116298 rows/sec., 1.56 KiB/sec. | ||
| 751 | 2025.01.25 03:38:41.533233 [ 227823 ] {97e751c6-bfe3-429c-9859-3b627024a489} <Debug> TCPHandler: Processed in 0.044778201 sec. | ||
| 752 | 2025.01.25 03:38:41.535373 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 753 | 2025.01.25 03:38:41.535895 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 754 | 2025.01.25 03:38:41.535929 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
| 755 | 2025.01.25 03:38:41.536008 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
| 756 | 2025.01.25 03:38:41.536063 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
| 757 | 2025.01.25 03:38:41.536120 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
| 758 | 2025.01.25 03:38:41.536200 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
| 759 | 2025.01.25 03:38:41.537112 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.00181705 sec., 2751.712941305963 rows/sec., 190.79 KiB/sec. | ||
| 760 | 2025.01.25 03:38:41.537272 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 761 | 2025.01.25 03:38:41.537492 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 762 | 2025.01.25 03:38:41.537566 [ 227276 ] {3339fe48-edaa-4df9-b1db-f98629eddaac::all_1_5_1} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 763 | 2025.01.25 03:38:41.537628 [ 227276 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB. | ||
| 764 | 2025.01.25 03:38:42.000447 [ 227312 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 412.49 MiB, peak 415.72 MiB, free memory in arenas 38.02 MiB, will set to 401.64 MiB (RSS), difference: -10.85 MiB | ||
| 765 | 2025.01.25 03:38:42.383370 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 766 | 2025.01.25 03:38:42.383547 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 767 | 2025.01.25 03:38:42.383604 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 768 | 2025.01.25 03:38:42.384545 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 769 | 2025.01.25 03:38:42.384575 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.82 GiB. | ||
| 770 | 2025.01.25 03:38:42.384856 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 771 | 2025.01.25 03:38:42.386476 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 772 | 2025.01.25 03:38:42.386676 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003181 sec., 628.7331027978623 rows/sec., 65.08 KiB/sec. | ||
| 773 | 2025.01.25 03:38:42.386725 [ 227820 ] {be81f014-d21b-4fc8-b827-afd680a36f9c} <Debug> TCPHandler: Processed in 0.00345905 sec. | ||
| 774 | 2025.01.25 03:38:42.387898 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 775 | 2025.01.25 03:38:42.389419 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 776 | 2025.01.25 03:38:42.389472 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 777 | 2025.01.25 03:38:42.391160 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 778 | 2025.01.25 03:38:42.391264 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.82 GiB. | ||
| 779 | 2025.01.25 03:38:42.391592 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 780 | 2025.01.25 03:38:42.391774 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 781 | 2025.01.25 03:38:42.391964 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002594 sec., 385.50501156515037 rows/sec., 26.73 KiB/sec. | ||
| 782 | 2025.01.25 03:38:42.392004 [ 227823 ] {55647008-3c4b-4a36-94e4-b982c52560a3} <Debug> TCPHandler: Processed in 0.00422017 sec. | ||
| 783 | 2025.01.25 03:38:43.382690 [ 227820 ] {} <Trace> TCP-Session: faf1df4a-381b-4cf5-9593-c2a134bcb17c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 784 | 2025.01.25 03:38:43.382877 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Debug> executeQuery: (from [::1]:56372) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 785 | 2025.01.25 03:38:43.382941 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 786 | 2025.01.25 03:38:43.383860 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 787 | 2025.01.25 03:38:43.383889 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.75 GiB. | ||
| 788 | 2025.01.25 03:38:43.384170 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 789 | 2025.01.25 03:38:43.384322 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Trace> oximeter.fields_string (f2fe6f85-f37c-4daa-84b6-095e6aaafe37): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 790 | 2025.01.25 03:38:43.384504 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.001691 sec., 1182.7321111768185 rows/sec., 122.43 KiB/sec. | ||
| 791 | 2025.01.25 03:38:43.384544 [ 227820 ] {d1dee0b1-0e12-4d9e-ac62-f52e99e341f9} <Debug> TCPHandler: Processed in 0.00202887 sec. | ||
| 792 | 2025.01.25 03:38:43.385096 [ 227823 ] {} <Trace> TCP-Session: cb9230ee-761d-484e-91aa-b6d5388ab4e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 793 | 2025.01.25 03:38:43.385221 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Debug> executeQuery: (from [::1]:56374) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 794 | 2025.01.25 03:38:43.385266 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 795 | 2025.01.25 03:38:43.386071 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 796 | 2025.01.25 03:38:43.387271 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.75 GiB. | ||
| 797 | 2025.01.25 03:38:43.387590 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 798 | 2025.01.25 03:38:43.387770 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Trace> oximeter.measurements_i64 (3339fe48-edaa-4df9-b1db-f98629eddaac): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 799 | 2025.01.25 03:38:43.387962 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002774 sec., 360.49026676279743 rows/sec., 24.99 KiB/sec. | ||
| 800 | 2025.01.25 03:38:43.387999 [ 227823 ] {95d3ac98-6d52-49c8-b56d-e5c9e05154ed} <Debug> TCPHandler: Processed in 0.00298023 sec. | ||