| 1 | 2024.11.15 20:11:20.608685 [ 155515 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2024.11.15 20:11:20.608755 [ 155515 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2024.11.15 20:11:20.734556 [ 155515 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 155515 | ||
| 4 | 2024.11.15 20:11:20.734620 [ 155515 ] {} <Information> Application: starting up | ||
| 5 | 2024.11.15 20:11:20.749847 [ 155515 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2024.11.15 20:11:20.755483 [ 155515 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2024.11.15 20:11:20.810469 [ 155515 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2024.11.15 20:11:20.810508 [ 155515 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2024.11.15 20:11:20.810565 [ 155515 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2024.11.15 20:11:20.810580 [ 155515 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2024.11.15 20:11:21.334628 [ 155515 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2024.11.15 20:11:21.335143 [ 155515 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 13 | 2024.11.15 20:11:21.339476 [ 155515 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2024.11.15 20:11:21.340402 [ 155515 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2024.11.15 20:11:21.340416 [ 155515 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2024.11.15 20:11:21.340422 [ 155515 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2024.11.15 20:11:21.340449 [ 155515 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/tmp/ to store temporary data in it | ||
| 18 | 2024.11.15 20:11:21.340864 [ 155515 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2024.11.15 20:11:21.341386 [ 155515 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml' | ||
| 20 | 2024.11.15 20:11:21.342999 [ 155515 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performing update on configuration | ||
| 21 | 2024.11.15 20:11:21.343405 [ 155515 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 22 | 2024.11.15 20:11:21.343418 [ 155515 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 23 | 2024.11.15 20:11:21.343423 [ 155515 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2024.11.15 20:11:21.343459 [ 155515 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2024.11.15 20:11:21.345286 [ 155515 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2024.11.15 20:11:21.355895 [ 155515 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2024.11.15 20:11:21.356447 [ 155515 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2024.11.15 20:11:21.359105 [ 155515 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2024.11.15 20:11:21.359598 [ 155515 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performed update on configuration | ||
| 30 | 2024.11.15 20:11:21.360226 [ 155515 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml' | ||
| 31 | 2024.11.15 20:11:21.361670 [ 155515 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performing update on configuration | ||
| 32 | 2024.11.15 20:11:21.362522 [ 155515 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performed update on configuration | ||
| 33 | 2024.11.15 20:11:21.363876 [ 155515 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml | ||
| 34 | 2024.11.15 20:11:21.364438 [ 155515 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2024.11.15 20:11:21.364776 [ 155515 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2024.11.15 20:11:21.365909 [ 155515 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2024.11.15 20:11:21.366175 [ 155515 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2024.11.15 20:11:21.366883 [ 155515 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2024.11.15 20:11:21.367607 [ 155543 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 40 | 2024.11.15 20:11:21.367636 [ 155543 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 41 | 2024.11.15 20:11:21.367581 [ 155515 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/ | ||
| 42 | 2024.11.15 20:11:21.381027 [ 155515 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2024.11.15 20:11:21.382823 [ 155515 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.001868291 sec | ||
| 44 | 2024.11.15 20:11:21.382837 [ 155515 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2024.11.15 20:11:21.382843 [ 155515 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2024.11.15 20:11:21.382870 [ 155515 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2024.11.15 20:11:21.382901 [ 155515 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2024.11.15 20:11:21.383661 [ 155515 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2024.11.15 20:11:21.383675 [ 155515 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2024.11.15 20:11:21.383683 [ 155515 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2024.11.15 20:11:21.383689 [ 155515 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2024.11.15 20:11:21.383696 [ 155515 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2024.11.15 20:11:21.383702 [ 155515 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 54 | 2024.11.15 20:11:21.383709 [ 155515 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2024.11.15 20:11:21.383715 [ 155515 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2024.11.15 20:11:21.383722 [ 155515 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 57 | 2024.11.15 20:11:21.383733 [ 155515 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2024.11.15 20:11:21.383740 [ 155515 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2024.11.15 20:11:21.383746 [ 155515 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2024.11.15 20:11:21.383752 [ 155515 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2024.11.15 20:11:21.383758 [ 155515 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2024.11.15 20:11:21.383764 [ 155515 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2024.11.15 20:11:21.383771 [ 155515 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2024.11.15 20:11:21.452581 [ 155515 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2024.11.15 20:11:21.464203 [ 155515 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2024.11.15 20:11:21.464690 [ 155515 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.004699714 sec | ||
| 67 | 2024.11.15 20:11:21.464703 [ 155515 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2024.11.15 20:11:21.464708 [ 155515 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2024.11.15 20:11:21.464734 [ 155515 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2024.11.15 20:11:21.465073 [ 155515 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/user_defined/ | ||
| 71 | 2024.11.15 20:11:21.465473 [ 155515 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2024.11.15 20:11:21.465485 [ 155515 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2024.11.15 20:11:21.465511 [ 155515 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2024.11.15 20:11:21.465522 [ 155515 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 75 | 2024.11.15 20:11:21.465627 [ 155515 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 46135 | ||
| 76 | 2024.11.15 20:11:21.465701 [ 155515 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 38159 | ||
| 77 | 2024.11.15 20:11:21.466029 [ 155515 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41049 | ||
| 78 | 2024.11.15 20:11:21.466300 [ 155515 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 43127 | ||
| 79 | 2024.11.15 20:11:21.466328 [ 155515 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2024.11.15 20:11:21.466768 [ 155515 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 3.09 MiB, will set to 380.07 MiB (RSS), difference: 359.45 MiB | ||
| 81 | 2024.11.15 20:11:21.467157 [ 155515 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.103e-05 sec. | ||
| 82 | 2024.11.15 20:11:21.467646 [ 155515 ] {} <Information> Application: Listening for http://[::1]:46135 | ||
| 83 | 2024.11.15 20:11:21.468193 [ 155515 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:38159 | ||
| 84 | 2024.11.15 20:11:21.468234 [ 155515 ] {} <Information> Application: Listening for http://127.0.0.1:41049 | ||
| 85 | 2024.11.15 20:11:21.468270 [ 155515 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:43127 | ||
| 86 | 2024.11.15 20:11:21.468278 [ 155515 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2024.11.15 20:11:22.674129 [ 155521 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57338 | ||
| 88 | 2024.11.15 20:11:22.674609 [ 155521 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2024.11.15 20:11:22.675310 [ 155521 ] {} <Debug> TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Authenticating user 'default' from [::1]:57338 | ||
| 90 | 2024.11.15 20:11:22.675333 [ 155521 ] {} <Debug> TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.11.15 20:11:22.675343 [ 155521 ] {} <Debug> TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2024.11.15 20:11:22.675446 [ 155521 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2024.11.15 20:11:22.675480 [ 155521 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2024.11.15 20:11:22.675492 [ 155521 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2024.11.15 20:11:22.679075 [ 155524 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57340 | ||
| 96 | 2024.11.15 20:11:22.687745 [ 155524 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 97 | 2024.11.15 20:11:22.687807 [ 155524 ] {} <Debug> TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Authenticating user 'default' from [::1]:57340 | ||
| 98 | 2024.11.15 20:11:22.687827 [ 155524 ] {} <Debug> TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 99 | 2024.11.15 20:11:22.687835 [ 155524 ] {} <Debug> TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2024.11.15 20:11:22.694404 [ 156196 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57346 | ||
| 101 | 2024.11.15 20:11:22.694522 [ 156196 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2024.11.15 20:11:22.694554 [ 156196 ] {} <Debug> TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Authenticating user 'default' from [::1]:57346 | ||
| 103 | 2024.11.15 20:11:22.696273 [ 156196 ] {} <Debug> TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2024.11.15 20:11:22.698251 [ 156196 ] {} <Debug> TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2024.11.15 20:11:22.704779 [ 155523 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57342 | ||
| 106 | 2024.11.15 20:11:22.705751 [ 155523 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2024.11.15 20:11:22.705804 [ 155523 ] {} <Debug> TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Authenticating user 'default' from [::1]:57342 | ||
| 108 | 2024.11.15 20:11:22.705757 [ 156197 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57348 | ||
| 109 | 2024.11.15 20:11:22.705834 [ 155523 ] {} <Debug> TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.11.15 20:11:22.705793 [ 156194 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57350 | ||
| 111 | 2024.11.15 20:11:22.704849 [ 156195 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57344 | ||
| 112 | 2024.11.15 20:11:22.704890 [ 156198 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57352 | ||
| 113 | 2024.11.15 20:11:22.705843 [ 155523 ] {} <Debug> TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2024.11.15 20:11:22.705989 [ 156197 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 115 | 2024.11.15 20:11:22.706033 [ 156197 ] {} <Debug> TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Authenticating user 'default' from [::1]:57348 | ||
| 116 | 2024.11.15 20:11:22.706043 [ 156197 ] {} <Debug> TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2024.11.15 20:11:22.706049 [ 156197 ] {} <Debug> TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 118 | 2024.11.15 20:11:22.706092 [ 156195 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 119 | 2024.11.15 20:11:22.706124 [ 156195 ] {} <Debug> TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Authenticating user 'default' from [::1]:57344 | ||
| 120 | 2024.11.15 20:11:22.706134 [ 156195 ] {} <Debug> TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2024.11.15 20:11:22.706141 [ 156195 ] {} <Debug> TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2024.11.15 20:11:22.706162 [ 156194 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 123 | 2024.11.15 20:11:22.706193 [ 156194 ] {} <Debug> TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Authenticating user 'default' from [::1]:57350 | ||
| 124 | 2024.11.15 20:11:22.706204 [ 156194 ] {} <Debug> TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2024.11.15 20:11:22.706211 [ 156194 ] {} <Debug> TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2024.11.15 20:11:22.706290 [ 156198 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2024.11.15 20:11:22.706316 [ 156198 ] {} <Debug> TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Authenticating user 'default' from [::1]:57352 | ||
| 128 | 2024.11.15 20:11:22.706324 [ 156198 ] {} <Debug> TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2024.11.15 20:11:22.706505 [ 156198 ] {} <Debug> TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2024.11.15 20:11:32.162603 [ 156349 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57354 | ||
| 131 | 2024.11.15 20:11:32.414176 [ 156349 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 132 | 2024.11.15 20:11:32.414231 [ 156349 ] {} <Debug> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Authenticating user 'default' from [::1]:57354 | ||
| 133 | 2024.11.15 20:11:32.415127 [ 156349 ] {} <Debug> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 134 | 2024.11.15 20:11:32.415142 [ 156349 ] {} <Debug> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 135 | 2024.11.15 20:11:32.452674 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 136 | 2024.11.15 20:11:32.452951 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} <Debug> executeQuery: (from [::1]:57354) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 137 | 2024.11.15 20:11:32.453870 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:57354) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 138 | |||
| 139 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 140 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 141 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 142 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 143 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 144 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 145 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 146 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 147 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 148 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 149 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 150 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 151 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 152 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 153 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 154 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 155 | 16. ? @ 0x00007f2740232ac3 in ? | ||
| 156 | 17. ? @ 0x00007f27402c4850 in ? | ||
| 157 | |||
| 158 | 2024.11.15 20:11:32.454843 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 159 | |||
| 160 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 165 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 16. ? @ 0x00007f2740232ac3 in ? | ||
| 177 | 17. ? @ 0x00007f27402c4850 in ? | ||
| 178 | |||
| 179 | 2024.11.15 20:11:32.454903 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} <Debug> TCPHandler: Processed in 0.002453092 sec. | ||
| 180 | 2024.11.15 20:11:32.456297 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 181 | 2024.11.15 20:11:32.456439 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} <Debug> executeQuery: (from [::1]:57354) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 182 | 2024.11.15 20:11:32.456667 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:57354) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 183 | |||
| 184 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 186 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 16. ? @ 0x00007f2740232ac3 in ? | ||
| 201 | 17. ? @ 0x00007f27402c4850 in ? | ||
| 202 | |||
| 203 | 2024.11.15 20:11:32.456760 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 204 | |||
| 205 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 206 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 207 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 208 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 209 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 210 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 211 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 212 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 213 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 16. ? @ 0x00007f2740232ac3 in ? | ||
| 222 | 17. ? @ 0x00007f27402c4850 in ? | ||
| 223 | |||
| 224 | 2024.11.15 20:11:32.456797 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} <Debug> TCPHandler: Processed in 0.000595631 sec. | ||
| 225 | 2024.11.15 20:11:32.458262 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 226 | 2024.11.15 20:11:32.458361 [ 156349 ] {032d8eb8-eb72-4379-b97b-d8bd84ec7a47} <Debug> executeQuery: (from [::1]:57354) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 227 | 2024.11.15 20:11:32.458437 [ 156349 ] {032d8eb8-eb72-4379-b97b-d8bd84ec7a47} <Debug> TCPHandler: Processed in 0.000687871 sec. | ||
| 228 | 2024.11.15 20:11:32.459862 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.11.15 20:11:32.460970 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Debug> executeQuery: (from [::1]:57354) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 230 | 2024.11.15 20:11:32.461006 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 231 | 2024.11.15 20:11:32.469086 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 232 | 2024.11.15 20:11:32.469125 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.4009e-05 sec | ||
| 233 | 2024.11.15 20:11:32.469134 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Trace> ReferentialDeps: No tables | ||
| 234 | 2024.11.15 20:11:32.469139 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Trace> LoadingDeps: No tables | ||
| 235 | 2024.11.15 20:11:32.469160 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 236 | 2024.11.15 20:11:32.469235 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} <Debug> TCPHandler: Processed in 0.009451828 sec. | ||
| 237 | 2024.11.15 20:11:32.472120 [ 156380 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57356 | ||
| 238 | 2024.11.15 20:11:32.472234 [ 156380 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 239 | 2024.11.15 20:11:32.472279 [ 156380 ] {} <Debug> TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Authenticating user 'default' from [::1]:57356 | ||
| 240 | 2024.11.15 20:11:32.472297 [ 156380 ] {} <Debug> TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 241 | 2024.11.15 20:11:32.472305 [ 156380 ] {} <Debug> TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 242 | 2024.11.15 20:11:32.472408 [ 156380 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 243 | 2024.11.15 20:11:32.472437 [ 156380 ] {} <Debug> TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 244 | 2024.11.15 20:11:32.474535 [ 156384 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57364 | ||
| 245 | 2024.11.15 20:11:32.474844 [ 156384 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 246 | 2024.11.15 20:11:32.474870 [ 156384 ] {} <Debug> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Authenticating user 'default' from [::1]:57364 | ||
| 247 | 2024.11.15 20:11:32.474883 [ 156384 ] {} <Debug> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.11.15 20:11:32.474889 [ 156384 ] {} <Debug> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 249 | 2024.11.15 20:11:32.483873 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 250 | 2024.11.15 20:11:32.484176 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Debug> executeQuery: (from [::1]:57364) /* The version table contains metadata about the `oximeter` database */ | ||
| 251 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 252 | 2024.11.15 20:11:32.484238 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 253 | 2024.11.15 20:11:32.484937 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 254 | 2024.11.15 20:11:32.490219 [ 156386 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57368 | ||
| 255 | 2024.11.15 20:11:32.490228 [ 156391 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57376 | ||
| 256 | 2024.11.15 20:11:32.490342 [ 156386 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 257 | 2024.11.15 20:11:32.490373 [ 156386 ] {} <Debug> TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Authenticating user 'default' from [::1]:57368 | ||
| 258 | 2024.11.15 20:11:32.490390 [ 156386 ] {} <Debug> TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.11.15 20:11:32.490398 [ 156386 ] {} <Debug> TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.11.15 20:11:32.490523 [ 156381 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57358 | ||
| 261 | 2024.11.15 20:11:32.490616 [ 156381 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 262 | 2024.11.15 20:11:32.490644 [ 156381 ] {} <Debug> TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Authenticating user 'default' from [::1]:57358 | ||
| 263 | 2024.11.15 20:11:32.490654 [ 156381 ] {} <Debug> TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.11.15 20:11:32.490660 [ 156381 ] {} <Debug> TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.11.15 20:11:32.490738 [ 156381 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 266 | 2024.11.15 20:11:32.490767 [ 156381 ] {} <Debug> TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2024.11.15 20:11:32.490763 [ 156387 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57370 | ||
| 268 | 2024.11.15 20:11:32.490794 [ 156381 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57378 | ||
| 269 | 2024.11.15 20:11:32.490813 [ 156381 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 270 | 2024.11.15 20:11:32.490827 [ 156381 ] {} <Debug> TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Authenticating user 'default' from [::1]:57378 | ||
| 271 | 2024.11.15 20:11:32.490840 [ 156381 ] {} <Debug> TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2024.11.15 20:11:32.490847 [ 156381 ] {} <Debug> TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2024.11.15 20:11:32.490858 [ 156387 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 274 | 2024.11.15 20:11:32.490881 [ 156387 ] {} <Debug> TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Authenticating user 'default' from [::1]:57370 | ||
| 275 | 2024.11.15 20:11:32.490891 [ 156387 ] {} <Debug> TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.11.15 20:11:32.490898 [ 156387 ] {} <Debug> TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.11.15 20:11:32.490990 [ 156382 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57360 | ||
| 278 | 2024.11.15 20:11:32.491061 [ 156382 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 279 | 2024.11.15 20:11:32.491071 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Debug> oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): Loading data parts | ||
| 280 | 2024.11.15 20:11:32.491083 [ 156382 ] {} <Debug> TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Authenticating user 'default' from [::1]:57360 | ||
| 281 | 2024.11.15 20:11:32.491094 [ 156382 ] {} <Debug> TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.11.15 20:11:32.491101 [ 156382 ] {} <Debug> TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.11.15 20:11:32.491208 [ 156389 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57374 | ||
| 284 | 2024.11.15 20:11:32.491294 [ 156382 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 285 | 2024.11.15 20:11:32.491313 [ 156382 ] {} <Debug> TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 286 | 2024.11.15 20:11:32.491273 [ 156388 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57372 | ||
| 287 | 2024.11.15 20:11:32.492966 [ 156388 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 288 | 2024.11.15 20:11:32.492997 [ 156388 ] {} <Debug> TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Authenticating user 'default' from [::1]:57372 | ||
| 289 | 2024.11.15 20:11:32.493009 [ 156388 ] {} <Debug> TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 290 | 2024.11.15 20:11:32.493016 [ 156388 ] {} <Debug> TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 291 | 2024.11.15 20:11:32.491493 [ 156389 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 292 | 2024.11.15 20:11:32.493127 [ 156389 ] {} <Debug> TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Authenticating user 'default' from [::1]:57374 | ||
| 293 | 2024.11.15 20:11:32.493140 [ 156389 ] {} <Debug> TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.11.15 20:11:32.493148 [ 156389 ] {} <Debug> TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.11.15 20:11:32.491627 [ 156385 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57366 | ||
| 296 | 2024.11.15 20:11:32.491730 [ 156391 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 297 | 2024.11.15 20:11:32.493517 [ 156385 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 298 | 2024.11.15 20:11:32.493489 [ 156391 ] {} <Debug> TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Authenticating user 'default' from [::1]:57376 | ||
| 299 | 2024.11.15 20:11:32.493581 [ 156391 ] {} <Debug> TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.11.15 20:11:32.493589 [ 156391 ] {} <Debug> TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.11.15 20:11:32.493826 [ 156385 ] {} <Debug> TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Authenticating user 'default' from [::1]:57366 | ||
| 302 | 2024.11.15 20:11:32.493844 [ 156385 ] {} <Debug> TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 303 | 2024.11.15 20:11:32.493852 [ 156385 ] {} <Debug> TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 304 | 2024.11.15 20:11:32.503179 [ 156383 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57362 | ||
| 305 | 2024.11.15 20:11:32.503292 [ 156383 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 306 | 2024.11.15 20:11:32.503321 [ 156383 ] {} <Debug> TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Authenticating user 'default' from [::1]:57362 | ||
| 307 | 2024.11.15 20:11:32.503337 [ 156383 ] {} <Debug> TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2024.11.15 20:11:32.503344 [ 156383 ] {} <Debug> TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 309 | 2024.11.15 20:11:32.503424 [ 156383 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 310 | 2024.11.15 20:11:32.503441 [ 156383 ] {} <Debug> TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.11.15 20:11:32.508101 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Debug> oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): There are no data parts | ||
| 312 | 2024.11.15 20:11:32.511259 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} <Debug> TCPHandler: Processed in 0.027701952 sec. | ||
| 313 | 2024.11.15 20:11:32.512822 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 314 | 2024.11.15 20:11:32.513050 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} <Debug> executeQuery: (from [::1]:57354) /* The measurement tables contain all individual samples from each timeseries. | ||
| 315 | * | ||
| 316 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 317 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 318 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 319 | * by all samples from the same timeseries. | ||
| 320 | * | ||
| 321 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 322 | * and then uses that to index quickly into the measurements tables. | ||
| 323 | */ | ||
| 324 | 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) | ||
| 325 | 2024.11.15 20:11:32.514480 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 326 | 2024.11.15 20:11:32.520398 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} <Debug> oximeter.measurements_bool (73d9d576-f80f-4984-b6bd-be09df14bd35): Loading data parts | ||
| 327 | 2024.11.15 20:11:32.520756 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} <Debug> oximeter.measurements_bool (73d9d576-f80f-4984-b6bd-be09df14bd35): There are no data parts | ||
| 328 | 2024.11.15 20:11:32.525173 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} <Debug> TCPHandler: Processed in 0.01243857 sec. | ||
| 329 | 2024.11.15 20:11:32.526306 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 330 | 2024.11.15 20:11:32.526548 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 331 | 2024.11.15 20:11:32.526593 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 332 | 2024.11.15 20:11:32.531785 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} <Debug> oximeter.measurements_i8 (f2f138da-f296-477f-87cc-06a12b8db2ad): Loading data parts | ||
| 333 | 2024.11.15 20:11:32.533999 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} <Debug> oximeter.measurements_i8 (f2f138da-f296-477f-87cc-06a12b8db2ad): There are no data parts | ||
| 334 | 2024.11.15 20:11:32.540253 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} <Debug> TCPHandler: Processed in 0.014069371 sec. | ||
| 335 | 2024.11.15 20:11:32.541848 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 336 | 2024.11.15 20:11:32.543397 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 337 | 2024.11.15 20:11:32.543448 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 338 | 2024.11.15 20:11:32.554265 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} <Debug> oximeter.measurements_u8 (875feb6d-bd48-4f06-af38-7d7dbf68e976): Loading data parts | ||
| 339 | 2024.11.15 20:11:32.558710 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} <Debug> oximeter.measurements_u8 (875feb6d-bd48-4f06-af38-7d7dbf68e976): There are no data parts | ||
| 340 | 2024.11.15 20:11:32.563926 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} <Debug> TCPHandler: Processed in 0.022218148 sec. | ||
| 341 | 2024.11.15 20:11:32.565138 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 342 | 2024.11.15 20:11:32.565381 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 343 | 2024.11.15 20:11:32.567101 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 344 | 2024.11.15 20:11:32.572710 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} <Debug> oximeter.measurements_i16 (d5646f8f-7a28-49ba-942a-78554ea7dcfa): Loading data parts | ||
| 345 | 2024.11.15 20:11:32.574623 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} <Debug> oximeter.measurements_i16 (d5646f8f-7a28-49ba-942a-78554ea7dcfa): There are no data parts | ||
| 346 | 2024.11.15 20:11:32.579788 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} <Debug> TCPHandler: Processed in 0.014808501 sec. | ||
| 347 | 2024.11.15 20:11:32.580377 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 348 | 2024.11.15 20:11:32.580634 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 349 | 2024.11.15 20:11:32.582000 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 350 | 2024.11.15 20:11:32.587087 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} <Debug> oximeter.measurements_u16 (f8459f0c-e467-49d9-a7f9-896c167bcfe4): Loading data parts | ||
| 351 | 2024.11.15 20:11:32.587362 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} <Debug> oximeter.measurements_u16 (f8459f0c-e467-49d9-a7f9-896c167bcfe4): There are no data parts | ||
| 352 | 2024.11.15 20:11:32.592296 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} <Debug> TCPHandler: Processed in 0.0119903 sec. | ||
| 353 | 2024.11.15 20:11:32.592965 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 354 | 2024.11.15 20:11:32.593215 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 355 | 2024.11.15 20:11:32.593259 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 356 | 2024.11.15 20:11:32.600565 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} <Debug> oximeter.measurements_i32 (354d9ef4-220a-404c-b589-2666df727601): Loading data parts | ||
| 357 | 2024.11.15 20:11:32.602100 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} <Debug> oximeter.measurements_i32 (354d9ef4-220a-404c-b589-2666df727601): There are no data parts | ||
| 358 | 2024.11.15 20:11:32.608808 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} <Debug> TCPHandler: Processed in 0.015940033 sec. | ||
| 359 | 2024.11.15 20:11:32.609426 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 360 | 2024.11.15 20:11:32.609691 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 361 | 2024.11.15 20:11:32.609731 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 362 | 2024.11.15 20:11:32.615971 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} <Debug> oximeter.measurements_u32 (5e211cf7-0901-4ab8-a686-3663876cbac6): Loading data parts | ||
| 363 | 2024.11.15 20:11:32.616345 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} <Debug> oximeter.measurements_u32 (5e211cf7-0901-4ab8-a686-3663876cbac6): There are no data parts | ||
| 364 | 2024.11.15 20:11:32.620878 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} <Debug> TCPHandler: Processed in 0.01152732 sec. | ||
| 365 | 2024.11.15 20:11:32.622401 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 366 | 2024.11.15 20:11:32.622646 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 367 | 2024.11.15 20:11:32.623867 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 368 | 2024.11.15 20:11:32.628654 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} <Debug> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Loading data parts | ||
| 369 | 2024.11.15 20:11:32.630798 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} <Debug> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): There are no data parts | ||
| 370 | 2024.11.15 20:11:32.635154 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} <Debug> TCPHandler: Processed in 0.01282914 sec. | ||
| 371 | 2024.11.15 20:11:32.636363 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 372 | 2024.11.15 20:11:32.638024 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 373 | 2024.11.15 20:11:32.638070 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 374 | 2024.11.15 20:11:32.644069 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} <Debug> oximeter.measurements_u64 (1788dfbb-993a-427d-8953-171a23bb5918): Loading data parts | ||
| 375 | 2024.11.15 20:11:32.645208 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} <Debug> oximeter.measurements_u64 (1788dfbb-993a-427d-8953-171a23bb5918): There are no data parts | ||
| 376 | 2024.11.15 20:11:32.650965 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} <Debug> TCPHandler: Processed in 0.014675032 sec. | ||
| 377 | 2024.11.15 20:11:32.658068 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 378 | 2024.11.15 20:11:32.658468 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 379 | 2024.11.15 20:11:32.658518 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 380 | 2024.11.15 20:11:32.665524 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} <Debug> oximeter.measurements_f32 (76505047-c6eb-414b-acb6-f8157783f4ee): Loading data parts | ||
| 381 | 2024.11.15 20:11:32.665855 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} <Debug> oximeter.measurements_f32 (76505047-c6eb-414b-acb6-f8157783f4ee): There are no data parts | ||
| 382 | 2024.11.15 20:11:32.685983 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} <Debug> TCPHandler: Processed in 0.028075502 sec. | ||
| 383 | 2024.11.15 20:11:32.687132 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 384 | 2024.11.15 20:11:32.688149 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 385 | 2024.11.15 20:11:32.688195 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 386 | 2024.11.15 20:11:32.694007 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} <Debug> oximeter.measurements_f64 (a42ec2a0-226d-417e-ab15-af3dbe4b7078): Loading data parts | ||
| 387 | 2024.11.15 20:11:32.694256 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} <Debug> oximeter.measurements_f64 (a42ec2a0-226d-417e-ab15-af3dbe4b7078): There are no data parts | ||
| 388 | 2024.11.15 20:11:32.697443 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} <Debug> TCPHandler: Processed in 0.010422458 sec. | ||
| 389 | 2024.11.15 20:11:32.755771 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 390 | 2024.11.15 20:11:32.756067 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 391 | 2024.11.15 20:11:32.756120 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 392 | 2024.11.15 20:11:32.760189 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} <Debug> oximeter.measurements_string (ecf9728f-a19b-4557-abdd-0608b7ce0ef9): Loading data parts | ||
| 393 | 2024.11.15 20:11:32.760408 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} <Debug> oximeter.measurements_string (ecf9728f-a19b-4557-abdd-0608b7ce0ef9): There are no data parts | ||
| 394 | 2024.11.15 20:11:32.766510 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} <Debug> TCPHandler: Processed in 0.010950339 sec. | ||
| 395 | 2024.11.15 20:11:33.000441 [ 155784 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 385.70 MiB, peak 385.70 MiB, free memory in arenas 7.39 MiB, will set to 386.77 MiB (RSS), difference: 1.08 MiB | ||
| 396 | 2024.11.15 20:11:33.122360 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 397 | 2024.11.15 20:11:33.122667 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} <Debug> executeQuery: (from [::1]:57354) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 398 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 399 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 400 | * a string isn't palatable for a few reasons. | ||
| 401 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 402 | * details. | ||
| 403 | */ | ||
| 404 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 405 | 2024.11.15 20:11:33.122719 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 406 | 2024.11.15 20:11:33.130967 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} <Debug> oximeter.measurements_bytes (b6190f1b-badb-423c-8f04-ab671c4c1cef): Loading data parts | ||
| 407 | 2024.11.15 20:11:33.131236 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} <Debug> oximeter.measurements_bytes (b6190f1b-badb-423c-8f04-ab671c4c1cef): There are no data parts | ||
| 408 | 2024.11.15 20:11:33.140411 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} <Debug> TCPHandler: Processed in 0.018220115 sec. | ||
| 409 | 2024.11.15 20:11:33.150996 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 410 | 2024.11.15 20:11:33.151241 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 411 | 2024.11.15 20:11:33.151321 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 412 | 2024.11.15 20:11:33.158687 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} <Debug> oximeter.measurements_cumulativei64 (971c4021-f7f5-4ae3-93b7-dd3642803b3a): Loading data parts | ||
| 413 | 2024.11.15 20:11:33.158946 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} <Debug> oximeter.measurements_cumulativei64 (971c4021-f7f5-4ae3-93b7-dd3642803b3a): There are no data parts | ||
| 414 | 2024.11.15 20:11:33.163197 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} <Debug> TCPHandler: Processed in 0.01229142 sec. | ||
| 415 | 2024.11.15 20:11:33.164014 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 416 | 2024.11.15 20:11:33.164251 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 417 | 2024.11.15 20:11:33.164300 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 418 | 2024.11.15 20:11:33.168855 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} <Debug> oximeter.measurements_cumulativeu64 (a589a9c8-b9d3-45f0-808f-1a54b8467f2e): Loading data parts | ||
| 419 | 2024.11.15 20:11:33.170579 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} <Debug> oximeter.measurements_cumulativeu64 (a589a9c8-b9d3-45f0-808f-1a54b8467f2e): There are no data parts | ||
| 420 | 2024.11.15 20:11:33.175906 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} <Debug> TCPHandler: Processed in 0.01203305 sec. | ||
| 421 | 2024.11.15 20:11:33.208142 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 422 | 2024.11.15 20:11:33.208435 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 423 | 2024.11.15 20:11:33.209563 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 424 | 2024.11.15 20:11:33.217273 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} <Debug> oximeter.measurements_cumulativef32 (91d0fa85-16dd-40eb-a6f7-55adc54b02ca): Loading data parts | ||
| 425 | 2024.11.15 20:11:33.217754 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} <Debug> oximeter.measurements_cumulativef32 (91d0fa85-16dd-40eb-a6f7-55adc54b02ca): There are no data parts | ||
| 426 | 2024.11.15 20:11:33.226680 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} <Debug> TCPHandler: Processed in 0.018664715 sec. | ||
| 427 | 2024.11.15 20:11:33.227777 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2024.11.15 20:11:33.228062 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 429 | 2024.11.15 20:11:33.228106 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 430 | 2024.11.15 20:11:33.233420 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} <Debug> oximeter.measurements_cumulativef64 (bfd9c141-e190-406f-a6cc-d65c425df316): Loading data parts | ||
| 431 | 2024.11.15 20:11:33.233695 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} <Debug> oximeter.measurements_cumulativef64 (bfd9c141-e190-406f-a6cc-d65c425df316): There are no data parts | ||
| 432 | 2024.11.15 20:11:33.237283 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} <Debug> TCPHandler: Processed in 0.009586128 sec. | ||
| 433 | 2024.11.15 20:11:33.247622 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 434 | 2024.11.15 20:11:33.248002 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} <Debug> executeQuery: (from [::1]:57364) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 435 | * NOTE: Array types cannot be Nullable, see | ||
| 436 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 437 | * for more details. | ||
| 438 | * | ||
| 439 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 440 | * is unfortunate, and at this point relies on the fact that an | ||
| 441 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 442 | * to figure out another way to represent missing samples here. | ||
| 443 | */ | ||
| 444 | 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) | ||
| 445 | 2024.11.15 20:11:33.248064 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 446 | 2024.11.15 20:11:33.255466 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} <Debug> oximeter.measurements_histogrami8 (0a1bc4a7-ba73-40f9-9449-c654f58cb4a9): Loading data parts | ||
| 447 | 2024.11.15 20:11:33.256456 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} <Debug> oximeter.measurements_histogrami8 (0a1bc4a7-ba73-40f9-9449-c654f58cb4a9): There are no data parts | ||
| 448 | 2024.11.15 20:11:33.261878 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} <Debug> TCPHandler: Processed in 0.014357121 sec. | ||
| 449 | 2024.11.15 20:11:33.262548 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 450 | 2024.11.15 20:11:33.262948 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 451 | 2024.11.15 20:11:33.263006 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 452 | 2024.11.15 20:11:33.269675 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} <Debug> oximeter.measurements_histogramu8 (42196a6d-3761-4c96-ab44-802a69c004f5): Loading data parts | ||
| 453 | 2024.11.15 20:11:33.272628 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} <Debug> oximeter.measurements_histogramu8 (42196a6d-3761-4c96-ab44-802a69c004f5): There are no data parts | ||
| 454 | 2024.11.15 20:11:33.278312 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} <Debug> TCPHandler: Processed in 0.015855053 sec. | ||
| 455 | 2024.11.15 20:11:33.278875 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 456 | 2024.11.15 20:11:33.280050 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 457 | 2024.11.15 20:11:33.280110 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 458 | 2024.11.15 20:11:33.290730 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} <Debug> oximeter.measurements_histogrami16 (216dfbb7-6a93-4090-8e4a-1e856d4c1674): Loading data parts | ||
| 459 | 2024.11.15 20:11:33.292610 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} <Debug> oximeter.measurements_histogrami16 (216dfbb7-6a93-4090-8e4a-1e856d4c1674): There are no data parts | ||
| 460 | 2024.11.15 20:11:33.304945 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} <Debug> TCPHandler: Processed in 0.026144561 sec. | ||
| 461 | 2024.11.15 20:11:33.305782 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 462 | 2024.11.15 20:11:33.306096 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 463 | 2024.11.15 20:11:33.306150 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 464 | 2024.11.15 20:11:33.313417 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} <Debug> oximeter.measurements_histogramu16 (a3a3f5e8-9bff-4656-ae2e-41672f3dcb3f): Loading data parts | ||
| 465 | 2024.11.15 20:11:33.314608 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} <Debug> oximeter.measurements_histogramu16 (a3a3f5e8-9bff-4656-ae2e-41672f3dcb3f): There are no data parts | ||
| 466 | 2024.11.15 20:11:33.318571 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} <Debug> TCPHandler: Processed in 0.01292144 sec. | ||
| 467 | 2024.11.15 20:11:33.319194 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 468 | 2024.11.15 20:11:33.319514 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 469 | 2024.11.15 20:11:33.319568 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 470 | 2024.11.15 20:11:33.326936 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} <Debug> oximeter.measurements_histogrami32 (2391a543-573a-4be0-a29b-a11d4456234b): Loading data parts | ||
| 471 | 2024.11.15 20:11:33.327215 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} <Debug> oximeter.measurements_histogrami32 (2391a543-573a-4be0-a29b-a11d4456234b): There are no data parts | ||
| 472 | 2024.11.15 20:11:33.331547 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} <Debug> TCPHandler: Processed in 0.01242983 sec. | ||
| 473 | 2024.11.15 20:11:33.332356 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 474 | 2024.11.15 20:11:33.332710 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 475 | 2024.11.15 20:11:33.332770 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 476 | 2024.11.15 20:11:33.337629 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} <Debug> oximeter.measurements_histogramu32 (c8edfb4b-abbb-45b6-a042-c2d200993285): Loading data parts | ||
| 477 | 2024.11.15 20:11:33.342847 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} <Debug> oximeter.measurements_histogramu32 (c8edfb4b-abbb-45b6-a042-c2d200993285): There are no data parts | ||
| 478 | 2024.11.15 20:11:33.348009 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} <Debug> TCPHandler: Processed in 0.015807303 sec. | ||
| 479 | 2024.11.15 20:11:33.348834 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 480 | 2024.11.15 20:11:33.349176 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 481 | 2024.11.15 20:11:33.349240 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 482 | 2024.11.15 20:11:33.355958 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} <Debug> oximeter.measurements_histogrami64 (3805a6d2-b707-48f2-8040-8a74dfc6879d): Loading data parts | ||
| 483 | 2024.11.15 20:11:33.356202 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} <Debug> oximeter.measurements_histogrami64 (3805a6d2-b707-48f2-8040-8a74dfc6879d): There are no data parts | ||
| 484 | 2024.11.15 20:11:33.360456 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} <Debug> TCPHandler: Processed in 0.01178966 sec. | ||
| 485 | 2024.11.15 20:11:33.361201 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 486 | 2024.11.15 20:11:33.361534 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 487 | 2024.11.15 20:11:33.361590 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 488 | 2024.11.15 20:11:33.367247 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} <Debug> oximeter.measurements_histogramu64 (d4d6b31e-5887-46ba-852c-83de0d4ec1aa): Loading data parts | ||
| 489 | 2024.11.15 20:11:33.367509 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} <Debug> oximeter.measurements_histogramu64 (d4d6b31e-5887-46ba-852c-83de0d4ec1aa): There are no data parts | ||
| 490 | 2024.11.15 20:11:33.371304 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} <Debug> TCPHandler: Processed in 0.010249878 sec. | ||
| 491 | 2024.11.15 20:11:33.372162 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 492 | 2024.11.15 20:11:33.373403 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 493 | 2024.11.15 20:11:33.373469 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 494 | 2024.11.15 20:11:33.378967 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} <Debug> oximeter.measurements_histogramf32 (9eb2a5da-7409-4b89-9a7f-b01cb146264f): Loading data parts | ||
| 495 | 2024.11.15 20:11:33.379218 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} <Debug> oximeter.measurements_histogramf32 (9eb2a5da-7409-4b89-9a7f-b01cb146264f): There are no data parts | ||
| 496 | 2024.11.15 20:11:33.383858 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} <Debug> TCPHandler: Processed in 0.011825059 sec. | ||
| 497 | 2024.11.15 20:11:33.384712 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 498 | 2024.11.15 20:11:33.385026 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 499 | 2024.11.15 20:11:33.385081 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 500 | 2024.11.15 20:11:33.392102 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} <Debug> oximeter.measurements_histogramf64 (3c5f9729-8e7e-497b-abc0-41b54f32bfb9): Loading data parts | ||
| 501 | 2024.11.15 20:11:33.392419 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} <Debug> oximeter.measurements_histogramf64 (3c5f9729-8e7e-497b-abc0-41b54f32bfb9): There are no data parts | ||
| 502 | 2024.11.15 20:11:33.396296 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} <Debug> TCPHandler: Processed in 0.011714889 sec. | ||
| 503 | 2024.11.15 20:11:33.397087 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 504 | 2024.11.15 20:11:33.397379 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} <Debug> executeQuery: (from [::1]:57364) /* The field tables store named dimensions of each timeseries. | ||
| 505 | * | ||
| 506 | * As with the measurement tables, there is one field table for each field data | ||
| 507 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 508 | * this behavior **must not** be relied upon for query correctness. | ||
| 509 | * | ||
| 510 | * The index for the fields differs from the measurements, however. Rows are | ||
| 511 | * sorted by timeseries name, then field name, field value, and finally | ||
| 512 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 513 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 514 | * usually then used to look up measurements. | ||
| 515 | * | ||
| 516 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 517 | * timeseries name and then key, since it would improve lookups where one | ||
| 518 | * already has the key. Realistically though, these tables are quite small and | ||
| 519 | * so performance benefits will be low in absolute terms. | ||
| 520 | * | ||
| 521 | * TTL: We use a materialized column to expire old field table records. This | ||
| 522 | * column is generated automatically by the database whenever a new row is | ||
| 523 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 524 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 525 | * record will remain during a deduplication, which will have the last | ||
| 526 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 527 | * measurement tables. | ||
| 528 | */ | ||
| 529 | 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) | ||
| 530 | 2024.11.15 20:11:33.397445 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 531 | 2024.11.15 20:11:33.403569 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} <Debug> oximeter.fields_bool (001a21df-4333-45a6-b52d-2366a98e6bd6): Loading data parts | ||
| 532 | 2024.11.15 20:11:33.403807 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} <Debug> oximeter.fields_bool (001a21df-4333-45a6-b52d-2366a98e6bd6): There are no data parts | ||
| 533 | 2024.11.15 20:11:33.408772 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} <Debug> TCPHandler: Processed in 0.01183002 sec. | ||
| 534 | 2024.11.15 20:11:33.409612 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 535 | 2024.11.15 20:11:33.409911 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 536 | 2024.11.15 20:11:33.409964 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 537 | 2024.11.15 20:11:33.415799 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} <Debug> oximeter.fields_i8 (55b4d09c-2526-465c-9a23-3b041311c1a5): Loading data parts | ||
| 538 | 2024.11.15 20:11:33.416150 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} <Debug> oximeter.fields_i8 (55b4d09c-2526-465c-9a23-3b041311c1a5): There are no data parts | ||
| 539 | 2024.11.15 20:11:33.427704 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} <Debug> TCPHandler: Processed in 0.018341335 sec. | ||
| 540 | 2024.11.15 20:11:33.428477 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 541 | 2024.11.15 20:11:33.431821 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 542 | 2024.11.15 20:11:33.431872 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 543 | 2024.11.15 20:11:33.436981 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} <Debug> oximeter.fields_u8 (a8ab95b2-d872-4bd4-8f0c-665a55716125): Loading data parts | ||
| 544 | 2024.11.15 20:11:33.437260 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} <Debug> oximeter.fields_u8 (a8ab95b2-d872-4bd4-8f0c-665a55716125): There are no data parts | ||
| 545 | 2024.11.15 20:11:33.442309 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} <Debug> TCPHandler: Processed in 0.014009642 sec. | ||
| 546 | 2024.11.15 20:11:33.443231 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2024.11.15 20:11:33.443488 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 548 | 2024.11.15 20:11:33.443536 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 549 | 2024.11.15 20:11:33.453284 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} <Debug> oximeter.fields_i16 (2e807c20-d604-4bcf-9799-756594a429fa): Loading data parts | ||
| 550 | 2024.11.15 20:11:33.453614 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} <Debug> oximeter.fields_i16 (2e807c20-d604-4bcf-9799-756594a429fa): There are no data parts | ||
| 551 | 2024.11.15 20:11:33.463497 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} <Debug> TCPHandler: Processed in 0.020452437 sec. | ||
| 552 | 2024.11.15 20:11:33.464260 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 553 | 2024.11.15 20:11:33.467327 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 554 | 2024.11.15 20:11:33.467391 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 555 | 2024.11.15 20:11:33.472250 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} <Debug> oximeter.fields_u16 (a1511d18-6e66-4a22-990f-c299c44f2ca9): Loading data parts | ||
| 556 | 2024.11.15 20:11:33.472700 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} <Debug> oximeter.fields_u16 (a1511d18-6e66-4a22-990f-c299c44f2ca9): There are no data parts | ||
| 557 | 2024.11.15 20:11:33.477990 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} <Debug> TCPHandler: Processed in 0.013909221 sec. | ||
| 558 | 2024.11.15 20:11:33.478873 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.11.15 20:11:33.490447 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 560 | 2024.11.15 20:11:33.494252 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 561 | 2024.11.15 20:11:33.523836 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} <Debug> oximeter.fields_i32 (d1b7bd00-a9a0-441d-8d30-ce5318dd0978): Loading data parts | ||
| 562 | 2024.11.15 20:11:33.527576 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} <Debug> oximeter.fields_i32 (d1b7bd00-a9a0-441d-8d30-ce5318dd0978): There are no data parts | ||
| 563 | 2024.11.15 20:11:33.533016 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} <Debug> TCPHandler: Processed in 0.054340494 sec. | ||
| 564 | 2024.11.15 20:11:33.533854 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 565 | 2024.11.15 20:11:33.534122 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 566 | 2024.11.15 20:11:33.536397 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 567 | 2024.11.15 20:11:33.543431 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} <Debug> oximeter.fields_u32 (d2a20529-3f93-4289-8706-93b7ba7f03a8): Loading data parts | ||
| 568 | 2024.11.15 20:11:33.543759 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} <Debug> oximeter.fields_u32 (d2a20529-3f93-4289-8706-93b7ba7f03a8): There are no data parts | ||
| 569 | 2024.11.15 20:11:33.546955 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} <Debug> TCPHandler: Processed in 0.013279431 sec. | ||
| 570 | 2024.11.15 20:11:33.547988 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.11.15 20:11:33.548277 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 572 | 2024.11.15 20:11:33.548333 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 573 | 2024.11.15 20:11:33.554901 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} <Debug> oximeter.fields_i64 (6be13903-2991-4ad3-bd0e-c7f134f8d7f8): Loading data parts | ||
| 574 | 2024.11.15 20:11:33.556988 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} <Debug> oximeter.fields_i64 (6be13903-2991-4ad3-bd0e-c7f134f8d7f8): There are no data parts | ||
| 575 | 2024.11.15 20:11:33.560558 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} <Debug> TCPHandler: Processed in 0.01275001 sec. | ||
| 576 | 2024.11.15 20:11:33.561410 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 577 | 2024.11.15 20:11:33.562422 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 578 | 2024.11.15 20:11:33.562474 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 579 | 2024.11.15 20:11:33.567816 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} <Debug> oximeter.fields_u64 (5d43c54b-ecdc-4859-a6fd-955abe1a9941): Loading data parts | ||
| 580 | 2024.11.15 20:11:33.569933 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} <Debug> oximeter.fields_u64 (5d43c54b-ecdc-4859-a6fd-955abe1a9941): There are no data parts | ||
| 581 | 2024.11.15 20:11:33.576465 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} <Debug> TCPHandler: Processed in 0.015182012 sec. | ||
| 582 | 2024.11.15 20:11:33.577197 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.11.15 20:11:33.586958 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 584 | 2024.11.15 20:11:33.587027 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 585 | 2024.11.15 20:11:33.593839 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} <Debug> oximeter.fields_ipaddr (fa53718b-5c24-466b-94f4-099ffe08c6c9): Loading data parts | ||
| 586 | 2024.11.15 20:11:33.600748 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} <Debug> oximeter.fields_ipaddr (fa53718b-5c24-466b-94f4-099ffe08c6c9): There are no data parts | ||
| 587 | 2024.11.15 20:11:33.607118 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} <Debug> TCPHandler: Processed in 0.030048654 sec. | ||
| 588 | 2024.11.15 20:11:33.607933 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 589 | 2024.11.15 20:11:33.608151 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} <Debug> executeQuery: (from [::1]:57364) 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) | ||
| 590 | 2024.11.15 20:11:33.608206 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 591 | 2024.11.15 20:11:33.613405 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} <Debug> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Loading data parts | ||
| 592 | 2024.11.15 20:11:33.614691 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} <Debug> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): There are no data parts | ||
| 593 | 2024.11.15 20:11:33.620035 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} <Debug> TCPHandler: Processed in 0.012269339 sec. | ||
| 594 | 2024.11.15 20:11:33.623764 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.11.15 20:11:33.624059 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} <Debug> executeQuery: (from [::1]:57354) 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) | ||
| 596 | 2024.11.15 20:11:33.624113 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 597 | 2024.11.15 20:11:33.628963 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} <Debug> oximeter.fields_uuid (8584400f-a65b-4d10-a860-0187a55fdc47): Loading data parts | ||
| 598 | 2024.11.15 20:11:33.629448 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} <Debug> oximeter.fields_uuid (8584400f-a65b-4d10-a860-0187a55fdc47): There are no data parts | ||
| 599 | 2024.11.15 20:11:33.632892 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} <Debug> TCPHandler: Processed in 0.009299107 sec. | ||
| 600 | 2024.11.15 20:11:33.633737 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2024.11.15 20:11:33.636176 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} <Debug> executeQuery: (from [::1]:57364) /* The timeseries schema table stores the extracted schema for the samples | ||
| 602 | * oximeter collects. | ||
| 603 | */ | ||
| 604 | 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) | ||
| 605 | 2024.11.15 20:11:33.636253 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 606 | 2024.11.15 20:11:33.640316 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} <Debug> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): Loading data parts | ||
| 607 | 2024.11.15 20:11:33.640590 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} <Debug> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): There are no data parts | ||
| 608 | 2024.11.15 20:11:33.646811 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} <Debug> TCPHandler: Processed in 0.01323151 sec. | ||
| 609 | 2024.11.15 20:11:33.652344 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 610 | 2024.11.15 20:11:33.655959 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Debug> executeQuery: (from [::1]:57354) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 611 | 2024.11.15 20:11:33.656062 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 612 | 2024.11.15 20:11:33.657230 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Trace> oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 613 | 2024.11.15 20:11:33.657259 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.69 GiB. | ||
| 614 | 2024.11.15 20:11:33.657710 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 615 | 2024.11.15 20:11:33.657898 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Trace> oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 616 | 2024.11.15 20:11:33.658230 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.002332 sec., 428.81646655231566 rows/sec., 6.70 KiB/sec. | ||
| 617 | 2024.11.15 20:11:33.658371 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} <Debug> TCPHandler: Processed in 0.006217585 sec. | ||
| 618 | 2024.11.15 20:11:34.000394 [ 155784 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 388.93 MiB, peak 388.93 MiB, free memory in arenas 16.67 MiB, will set to 390.19 MiB (RSS), difference: 1.26 MiB | ||
| 619 | 2024.11.15 20:11:34.345367 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 620 | 2024.11.15 20:11:34.345569 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} <Debug> executeQuery: (from [::1]:57354) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 621 | 2024.11.15 20:11:34.346695 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 622 | 2024.11.15 20:11:34.346756 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 623 | 2024.11.15 20:11:34.347335 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} <Debug> TCPHandler: Processed in 0.002147562 sec. | ||
| 624 | 2024.11.15 20:11:34.349333 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 625 | 2024.11.15 20:11:34.351257 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Debug> executeQuery: (from [::1]:57364) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 626 | 2024.11.15 20:11:34.351314 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 627 | 2024.11.15 20:11:34.353031 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Trace> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 628 | 2024.11.15 20:11:34.353056 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 629 | 2024.11.15 20:11:34.353520 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 630 | 2024.11.15 20:11:34.353698 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Trace> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 631 | 2024.11.15 20:11:34.353913 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002709 sec., 369.1399040236249 rows/sec., 44.34 KiB/sec. | ||
| 632 | 2024.11.15 20:11:34.355416 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} <Debug> TCPHandler: Processed in 0.006208805 sec. | ||
| 633 | 2024.11.15 20:11:34.356195 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 634 | 2024.11.15 20:11:34.356358 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Debug> executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 635 | 2024.11.15 20:11:34.356410 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 636 | 2024.11.15 20:11:34.357246 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 637 | 2024.11.15 20:11:34.358492 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 638 | 2024.11.15 20:11:34.359989 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 639 | 2024.11.15 20:11:34.360186 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 640 | 2024.11.15 20:11:34.360354 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004043 sec., 494.6821667078902 rows/sec., 51.21 KiB/sec. | ||
| 641 | 2024.11.15 20:11:34.360479 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} <Debug> TCPHandler: Processed in 0.004418983 sec. | ||
| 642 | 2024.11.15 20:11:34.363328 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 643 | 2024.11.15 20:11:34.364283 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Debug> executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 644 | 2024.11.15 20:11:34.364345 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 645 | 2024.11.15 20:11:34.365190 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 646 | 2024.11.15 20:11:34.366160 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 647 | 2024.11.15 20:11:34.366502 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 648 | 2024.11.15 20:11:34.366668 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 649 | 2024.11.15 20:11:34.366842 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002611 sec., 382.99502106472613 rows/sec., 26.56 KiB/sec. | ||
| 650 | 2024.11.15 20:11:34.366882 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} <Debug> TCPHandler: Processed in 0.003716023 sec. | ||
| 651 | 2024.11.15 20:11:34.372857 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 652 | 2024.11.15 20:11:34.373038 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Debug> executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 653 | 2024.11.15 20:11:34.373098 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 654 | 2024.11.15 20:11:34.374146 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 655 | 2024.11.15 20:11:34.375025 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 656 | 2024.11.15 20:11:34.377424 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 657 | 2024.11.15 20:11:34.377597 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 658 | 2024.11.15 20:11:34.377813 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004827 sec., 414.33602651750573 rows/sec., 42.89 KiB/sec. | ||
| 659 | 2024.11.15 20:11:34.377866 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} <Debug> TCPHandler: Processed in 0.005234044 sec. | ||
| 660 | 2024.11.15 20:11:34.379280 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 661 | 2024.11.15 20:11:34.380456 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Debug> executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 662 | 2024.11.15 20:11:34.380530 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 663 | 2024.11.15 20:11:34.381649 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 664 | 2024.11.15 20:11:34.382341 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 665 | 2024.11.15 20:11:34.382727 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 666 | 2024.11.15 20:11:34.382943 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 667 | 2024.11.15 20:11:34.384906 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004494 sec., 222.51891410769917 rows/sec., 15.43 KiB/sec. | ||
| 668 | 2024.11.15 20:11:34.384960 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} <Debug> TCPHandler: Processed in 0.005826255 sec. | ||
| 669 | 2024.11.15 20:11:34.392357 [ 156349 ] {} <Trace> TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 670 | 2024.11.15 20:11:34.392570 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Debug> executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 671 | 2024.11.15 20:11:34.392652 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 672 | 2024.11.15 20:11:34.394042 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 673 | 2024.11.15 20:11:34.397070 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 674 | 2024.11.15 20:11:34.397473 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 675 | 2024.11.15 20:11:34.399978 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Trace> oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 676 | 2024.11.15 20:11:34.400194 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.007714 sec., 259.26886180969666 rows/sec., 26.84 KiB/sec. | ||
| 677 | 2024.11.15 20:11:34.400247 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} <Debug> TCPHandler: Processed in 0.008064716 sec. | ||
| 678 | 2024.11.15 20:11:34.410157 [ 156384 ] {} <Trace> TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 679 | 2024.11.15 20:11:34.412447 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Debug> executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 680 | 2024.11.15 20:11:34.412530 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 681 | 2024.11.15 20:11:34.413471 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 682 | 2024.11.15 20:11:34.413499 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. | ||
| 683 | 2024.11.15 20:11:34.417294 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 684 | 2024.11.15 20:11:34.417467 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Trace> oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 685 | 2024.11.15 20:11:34.417712 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.00532 sec., 187.9699248120301 rows/sec., 13.03 KiB/sec. | ||
| 686 | 2024.11.15 20:11:34.418825 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} <Debug> TCPHandler: Processed in 0.008870787 sec. | ||
| 687 | 2024.11.15 20:11:34.476366 [ 155521 ] {} <Trace> TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 688 | 2024.11.15 20:11:34.476605 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Debug> executeQuery: (from [::1]:57338) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 689 | 2024.11.15 20:11:34.476878 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 690 | 2024.11.15 20:11:34.476946 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 691 | 2024.11.15 20:11:34.477912 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Debug> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Key condition: unknown | ||
| 692 | 2024.11.15 20:11:34.477937 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Debug> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Selected 1/1 parts by partition key, 1 parts by primary key, 1/1 marks by primary key, 1 marks to read from 1 ranges | ||
| 693 | 2024.11.15 20:11:34.477944 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Trace> oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Spreading mark ranges among streams (default reading) | ||
| 694 | 2024.11.15 20:11:34.477972 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Trace> MergeTreeInOrderSelectProcessor: Reading 1 ranges in order from part all_1_1_0, approx. 1 rows starting from 0 | ||
| 695 | 2024.11.15 20:11:34.478866 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002317 sec., 431.59257660768236 rows/sec., 51.84 KiB/sec. | ||
| 696 | 2024.11.15 20:11:34.479609 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} <Debug> TCPHandler: Processed in 0.003434823 sec. | ||