| 1 | 2025.01.29 00:55:28.525344 [ 227486 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.01.29 00:55:28.525418 [ 227486 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.01.29 00:55:28.579422 [ 227486 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 227486 | ||
| 4 | 2025.01.29 00:55:28.579485 [ 227486 ] {} <Information> Application: starting up | ||
| 5 | 2025.01.29 00:55:28.579504 [ 227486 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.01.29 00:55:28.582548 [ 227486 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.01.29 00:55:28.585490 [ 227486 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.01.29 00:55:28.586496 [ 227486 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.01.29 00:55:28.586586 [ 227486 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.01.29 00:55:28.586653 [ 227486 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.01.29 00:55:28.835901 [ 227486 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.01.29 00:55:28.837872 [ 227486 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 13 | 2025.01.29 00:55:28.844952 [ 227486 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.01.29 00:55:28.844984 [ 227486 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.01.29 00:55:28.844992 [ 227486 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.01.29 00:55:28.844997 [ 227486 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.01.29 00:55:28.845452 [ 227486 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.01.29 00:55:28.845797 [ 227486 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.01.29 00:55:28.849623 [ 227486 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml' | ||
| 20 | 2025.01.29 00:55:28.854413 [ 227486 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml', performing update on configuration | ||
| 21 | 2025.01.29 00:55:28.855065 [ 227486 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 22 | 2025.01.29 00:55:28.855106 [ 227486 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 23 | 2025.01.29 00:55:28.855115 [ 227486 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.01.29 00:55:28.855195 [ 227486 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.01.29 00:55:28.856668 [ 227486 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.01.29 00:55:28.862056 [ 227486 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.01.29 00:55:28.862950 [ 227486 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.01.29 00:55:28.863549 [ 227486 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.01.29 00:55:28.863577 [ 227486 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml', performed update on configuration | ||
| 30 | 2025.01.29 00:55:28.912235 [ 227486 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml' | ||
| 31 | 2025.01.29 00:55:28.919877 [ 227486 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml', performing update on configuration | ||
| 32 | 2025.01.29 00:55:28.920779 [ 227486 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml', performed update on configuration | ||
| 33 | 2025.01.29 00:55:28.921197 [ 227486 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/config.xml | ||
| 34 | 2025.01.29 00:55:28.924385 [ 227486 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.01.29 00:55:28.926935 [ 227486 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.01.29 00:55:28.929244 [ 227486 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.01.29 00:55:28.931280 [ 227486 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.01.29 00:55:28.947961 [ 227486 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.01.29 00:55:28.948128 [ 227554 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 40 | 2025.01.29 00:55:28.948153 [ 227554 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 41 | 2025.01.29 00:55:28.948194 [ 227486 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/datastore/ | ||
| 42 | 2025.01.29 00:55:28.972190 [ 227486 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.01.29 00:55:28.972223 [ 227486 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00011611 sec | ||
| 44 | 2025.01.29 00:55:28.972230 [ 227486 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.01.29 00:55:28.972235 [ 227486 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.01.29 00:55:28.972274 [ 227486 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.01.29 00:55:28.972290 [ 227486 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.01.29 00:55:28.973077 [ 227486 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.01.29 00:55:28.973092 [ 227486 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.01.29 00:55:28.973098 [ 227486 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.01.29 00:55:28.973104 [ 227486 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.01.29 00:55:28.973110 [ 227486 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.01.29 00:55:28.973118 [ 227486 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.01.29 00:55:28.974894 [ 227486 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.01.29 00:55:28.974912 [ 227486 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.01.29 00:55:28.974930 [ 227486 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.01.29 00:55:28.975066 [ 227486 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.01.29 00:55:28.975077 [ 227486 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.01.29 00:55:28.975083 [ 227486 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.01.29 00:55:28.975089 [ 227486 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.01.29 00:55:28.975095 [ 227486 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.01.29 00:55:28.975101 [ 227486 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.01.29 00:55:28.975108 [ 227486 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.01.29 00:55:28.993988 [ 227486 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.01.29 00:55:28.998241 [ 227486 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.01.29 00:55:28.998272 [ 227486 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.873e-05 sec | ||
| 67 | 2025.01.29 00:55:28.998279 [ 227486 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.01.29 00:55:28.998283 [ 227486 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.01.29 00:55:28.998312 [ 227486 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.01.29 00:55:28.998429 [ 227486 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-b8a8aa007808b70d-test_omdb_success_cases.227134.1-clickhouse-6NYstd/datastore/user_defined/ | ||
| 71 | 2025.01.29 00:55:28.998462 [ 227486 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.01.29 00:55:28.998469 [ 227486 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.01.29 00:55:28.998490 [ 227486 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.01.29 00:55:28.998497 [ 227486 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 75 | 2025.01.29 00:55:28.998586 [ 227486 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33643 | ||
| 76 | 2025.01.29 00:55:28.998636 [ 227486 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 45751 | ||
| 77 | 2025.01.29 00:55:28.998811 [ 227486 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37699 | ||
| 78 | 2025.01.29 00:55:28.998853 [ 227486 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36211 | ||
| 79 | 2025.01.29 00:55:28.998877 [ 227486 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.01.29 00:55:28.999322 [ 227486 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 20.21 MiB, will set to 387.46 MiB (RSS), difference: 366.82 MiB | ||
| 81 | 2025.01.29 00:55:28.999964 [ 227486 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.772e-05 sec. | ||
| 82 | 2025.01.29 00:55:29.002551 [ 227486 ] {} <Information> Application: Listening for http://[::1]:33643 | ||
| 83 | 2025.01.29 00:55:29.007239 [ 227486 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:45751 | ||
| 84 | 2025.01.29 00:55:29.015905 [ 227486 ] {} <Information> Application: Listening for http://127.0.0.1:37699 | ||
| 85 | 2025.01.29 00:55:29.016329 [ 227486 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:36211 | ||
| 86 | 2025.01.29 00:55:29.016346 [ 227486 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.01.29 00:55:30.010448 [ 227518 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45598 | ||
| 88 | 2025.01.29 00:55:30.011959 [ 227518 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.01.29 00:55:30.012703 [ 227518 ] {} <Debug> TCP-Session: 85124595-cea8-46f1-8ccd-a75c4fcbae12 Authenticating user 'default' from [::1]:45598 | ||
| 90 | 2025.01.29 00:55:30.012726 [ 227518 ] {} <Debug> TCP-Session: 85124595-cea8-46f1-8ccd-a75c4fcbae12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.01.29 00:55:30.012733 [ 227518 ] {} <Debug> TCP-Session: 85124595-cea8-46f1-8ccd-a75c4fcbae12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.01.29 00:55:30.012818 [ 227518 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.01.29 00:55:30.012843 [ 227518 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2025.01.29 00:55:30.012854 [ 227518 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2025.01.29 00:55:30.015370 [ 227519 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45600 | ||
| 96 | 2025.01.29 00:55:30.015712 [ 227520 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45602 | ||
| 97 | 2025.01.29 00:55:30.016618 [ 227519 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 98 | 2025.01.29 00:55:30.016627 [ 227520 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 99 | 2025.01.29 00:55:30.016654 [ 227519 ] {} <Debug> TCP-Session: 1b06e9c7-4b14-4b01-b29d-ab227fb17178 Authenticating user 'default' from [::1]:45600 | ||
| 100 | 2025.01.29 00:55:30.016660 [ 227520 ] {} <Debug> TCP-Session: 7e0f02b7-7a79-45a6-8c23-00e7b209d932 Authenticating user 'default' from [::1]:45602 | ||
| 101 | 2025.01.29 00:55:30.016674 [ 227519 ] {} <Debug> TCP-Session: 1b06e9c7-4b14-4b01-b29d-ab227fb17178 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 102 | 2025.01.29 00:55:30.016681 [ 227519 ] {} <Debug> TCP-Session: 1b06e9c7-4b14-4b01-b29d-ab227fb17178 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 103 | 2025.01.29 00:55:30.016773 [ 227520 ] {} <Debug> TCP-Session: 7e0f02b7-7a79-45a6-8c23-00e7b209d932 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2025.01.29 00:55:30.016783 [ 227520 ] {} <Debug> TCP-Session: 7e0f02b7-7a79-45a6-8c23-00e7b209d932 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.01.29 00:55:30.033312 [ 227898 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45604 | ||
| 106 | 2025.01.29 00:55:30.033482 [ 227898 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.01.29 00:55:30.033512 [ 227898 ] {} <Debug> TCP-Session: b9c35fac-6c62-4865-a01d-1655c72da375 Authenticating user 'default' from [::1]:45604 | ||
| 108 | 2025.01.29 00:55:30.033535 [ 227898 ] {} <Debug> TCP-Session: b9c35fac-6c62-4865-a01d-1655c72da375 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.01.29 00:55:30.033542 [ 227898 ] {} <Debug> TCP-Session: b9c35fac-6c62-4865-a01d-1655c72da375 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.01.29 00:55:30.044725 [ 227900 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45608 | ||
| 111 | 2025.01.29 00:55:30.044862 [ 227900 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2025.01.29 00:55:30.046180 [ 227900 ] {} <Debug> TCP-Session: b0065c49-6ff2-4d12-b09a-3a26ad8988da Authenticating user 'default' from [::1]:45608 | ||
| 113 | 2025.01.29 00:55:30.046207 [ 227900 ] {} <Debug> TCP-Session: b0065c49-6ff2-4d12-b09a-3a26ad8988da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2025.01.29 00:55:30.046214 [ 227900 ] {} <Debug> TCP-Session: b0065c49-6ff2-4d12-b09a-3a26ad8988da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2025.01.29 00:55:30.056423 [ 227899 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45606 | ||
| 116 | 2025.01.29 00:55:30.056567 [ 227899 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 117 | 2025.01.29 00:55:30.056611 [ 227899 ] {} <Debug> TCP-Session: 3a992e7a-47ef-4367-bee7-36f4c035b17f Authenticating user 'default' from [::1]:45606 | ||
| 118 | 2025.01.29 00:55:30.056629 [ 227899 ] {} <Debug> TCP-Session: 3a992e7a-47ef-4367-bee7-36f4c035b17f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 119 | 2025.01.29 00:55:30.056637 [ 227899 ] {} <Debug> TCP-Session: 3a992e7a-47ef-4367-bee7-36f4c035b17f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2025.01.29 00:55:30.056838 [ 227901 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45610 | ||
| 121 | 2025.01.29 00:55:30.057077 [ 227902 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45612 | ||
| 122 | 2025.01.29 00:55:30.058721 [ 227901 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 123 | 2025.01.29 00:55:30.058753 [ 227902 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 124 | 2025.01.29 00:55:30.058766 [ 227901 ] {} <Debug> TCP-Session: a899b324-017e-46a9-96ba-e2e309324b12 Authenticating user 'default' from [::1]:45610 | ||
| 125 | 2025.01.29 00:55:30.058778 [ 227901 ] {} <Debug> TCP-Session: a899b324-017e-46a9-96ba-e2e309324b12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2025.01.29 00:55:30.058781 [ 227902 ] {} <Debug> TCP-Session: 6140c115-54eb-4385-9072-5136e048ab5f Authenticating user 'default' from [::1]:45612 | ||
| 127 | 2025.01.29 00:55:30.058782 [ 227901 ] {} <Debug> TCP-Session: a899b324-017e-46a9-96ba-e2e309324b12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 128 | 2025.01.29 00:55:30.058800 [ 227902 ] {} <Debug> TCP-Session: 6140c115-54eb-4385-9072-5136e048ab5f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.01.29 00:55:30.058810 [ 227902 ] {} <Debug> TCP-Session: 6140c115-54eb-4385-9072-5136e048ab5f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.01.29 00:55:36.479626 [ 227808 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1724 entries to flush up to offset 1724 | ||
| 131 | 2025.01.29 00:55:36.479705 [ 227808 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 132 | 2025.01.29 00:55:36.480923 [ 227808 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 133 | 2025.01.29 00:55:36.485601 [ 227805 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 134 | 2025.01.29 00:55:36.485679 [ 227805 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 135 | 2025.01.29 00:55:36.486061 [ 227808 ] {} <Debug> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): Loading data parts | ||
| 136 | 2025.01.29 00:55:36.499621 [ 227808 ] {} <Debug> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): There are no data parts | ||
| 137 | 2025.01.29 00:55:36.502759 [ 227805 ] {} <Debug> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): Loading data parts | ||
| 138 | 2025.01.29 00:55:36.505855 [ 227808 ] {} <Trace> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 139 | 2025.01.29 00:55:36.505892 [ 227808 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.56 GiB. | ||
| 140 | 2025.01.29 00:55:36.506556 [ 227808 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 141 | 2025.01.29 00:55:36.506775 [ 227808 ] {} <Trace> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 142 | 2025.01.29 00:55:36.506953 [ 227808 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1724 | ||
| 143 | 2025.01.29 00:55:36.507399 [ 227805 ] {} <Debug> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): There are no data parts | ||
| 144 | 2025.01.29 00:55:36.544012 [ 227805 ] {} <Trace> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.01.29 00:55:36.544067 [ 227805 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.56 GiB. | ||
| 146 | 2025.01.29 00:55:36.554897 [ 227805 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.01.29 00:55:36.560494 [ 227805 ] {} <Trace> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2025.01.29 00:55:36.563483 [ 227805 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.01.29 00:55:37.000544 [ 227811 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 393.27 MiB, peak 397.27 MiB, free memory in arenas 29.51 MiB, will set to 397.48 MiB (RSS), difference: 4.21 MiB | ||
| 150 | 2025.01.29 00:55:40.173646 [ 228258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45616 | ||
| 151 | 2025.01.29 00:55:40.173798 [ 228258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2025.01.29 00:55:40.173831 [ 228258 ] {} <Debug> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Authenticating user 'default' from [::1]:45616 | ||
| 153 | 2025.01.29 00:55:40.173846 [ 228258 ] {} <Debug> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.01.29 00:55:40.173855 [ 228258 ] {} <Debug> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2025.01.29 00:55:40.211780 [ 228260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45620 | ||
| 156 | 2025.01.29 00:55:40.211956 [ 228261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45622 | ||
| 157 | 2025.01.29 00:55:40.227311 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 158 | 2025.01.29 00:55:40.227666 [ 228260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 159 | 2025.01.29 00:55:40.227701 [ 228258 ] {31c8927d-cee1-4bfd-bf90-8b966769dcb3} <Debug> executeQuery: (from [::1]:45616) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 160 | 2025.01.29 00:55:40.227719 [ 228260 ] {} <Debug> TCP-Session: e58997d4-9157-4be3-a99d-6ef849ba924d Authenticating user 'default' from [::1]:45620 | ||
| 161 | 2025.01.29 00:55:40.227740 [ 228260 ] {} <Debug> TCP-Session: e58997d4-9157-4be3-a99d-6ef849ba924d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 162 | 2025.01.29 00:55:40.227755 [ 228260 ] {} <Debug> TCP-Session: e58997d4-9157-4be3-a99d-6ef849ba924d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 163 | 2025.01.29 00:55:40.228697 [ 228258 ] {31c8927d-cee1-4bfd-bf90-8b966769dcb3} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:45616) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 164 | |||
| 165 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 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 | ||
| 171 | 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 | ||
| 172 | 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 | ||
| 173 | 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 | ||
| 174 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 177 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 178 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 179 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 180 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 16. ? @ 0x00007f8b752f4ac3 in ? | ||
| 182 | 17. ? @ 0x00007f8b75386850 in ? | ||
| 183 | |||
| 184 | 2025.01.29 00:55:40.228842 [ 228258 ] {31c8927d-cee1-4bfd-bf90-8b966769dcb3} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 185 | |||
| 186 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 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 | ||
| 192 | 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 | ||
| 193 | 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 | ||
| 194 | 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 | ||
| 195 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 16. ? @ 0x00007f8b752f4ac3 in ? | ||
| 203 | 17. ? @ 0x00007f8b75386850 in ? | ||
| 204 | |||
| 205 | 2025.01.29 00:55:40.228923 [ 228258 ] {31c8927d-cee1-4bfd-bf90-8b966769dcb3} <Debug> TCPHandler: Processed in 0.00190802 sec. | ||
| 206 | 2025.01.29 00:55:40.229410 [ 228261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 207 | 2025.01.29 00:55:40.229451 [ 228261 ] {} <Debug> TCP-Session: 8eb729db-e75f-4059-bced-6c6626f5056e Authenticating user 'default' from [::1]:45622 | ||
| 208 | 2025.01.29 00:55:40.229481 [ 228261 ] {} <Debug> TCP-Session: 8eb729db-e75f-4059-bced-6c6626f5056e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2025.01.29 00:55:40.229488 [ 228261 ] {} <Debug> TCP-Session: 8eb729db-e75f-4059-bced-6c6626f5056e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2025.01.29 00:55:40.242663 [ 228260 ] {} <Trace> TCP-Session: e58997d4-9157-4be3-a99d-6ef849ba924d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2025.01.29 00:55:40.243032 [ 228260 ] {57534889-4a30-4641-bc53-7458adbf8984} <Debug> executeQuery: (from [::1]:45620) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 212 | 2025.01.29 00:55:40.243759 [ 228263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45626 | ||
| 213 | 2025.01.29 00:55:40.244351 [ 228263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 214 | 2025.01.29 00:55:40.244382 [ 228263 ] {} <Debug> TCP-Session: d40ff06d-4c24-41b5-9be4-7b6047ac7f7e Authenticating user 'default' from [::1]:45626 | ||
| 215 | 2025.01.29 00:55:40.244402 [ 228263 ] {} <Debug> TCP-Session: d40ff06d-4c24-41b5-9be4-7b6047ac7f7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 216 | 2025.01.29 00:55:40.243488 [ 228260 ] {57534889-4a30-4641-bc53-7458adbf8984} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:45620) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 217 | |||
| 218 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 222 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 223 | 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 | ||
| 224 | 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 | ||
| 225 | 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 | ||
| 226 | 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 | ||
| 227 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 228 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 230 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 231 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 232 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 233 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 234 | 16. ? @ 0x00007f8b752f4ac3 in ? | ||
| 235 | 17. ? @ 0x00007f8b75386850 in ? | ||
| 236 | |||
| 237 | 2025.01.29 00:55:40.244424 [ 228263 ] {} <Debug> TCP-Session: d40ff06d-4c24-41b5-9be4-7b6047ac7f7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 238 | 2025.01.29 00:55:40.244580 [ 228260 ] {57534889-4a30-4641-bc53-7458adbf8984} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 239 | |||
| 240 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 241 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 242 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 243 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 244 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 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 | ||
| 246 | 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 | ||
| 247 | 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 | ||
| 248 | 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 | ||
| 249 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 250 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 251 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 252 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 253 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 254 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 255 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 256 | 16. ? @ 0x00007f8b752f4ac3 in ? | ||
| 257 | 17. ? @ 0x00007f8b75386850 in ? | ||
| 258 | |||
| 259 | 2025.01.29 00:55:40.244652 [ 228260 ] {57534889-4a30-4641-bc53-7458adbf8984} <Debug> TCPHandler: Processed in 0.0023089 sec. | ||
| 260 | 2025.01.29 00:55:40.257433 [ 228264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45628 | ||
| 261 | 2025.01.29 00:55:40.257563 [ 228264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 262 | 2025.01.29 00:55:40.257599 [ 228264 ] {} <Debug> TCP-Session: 16ce7780-4162-41a4-8091-131c55dd2786 Authenticating user 'default' from [::1]:45628 | ||
| 263 | 2025.01.29 00:55:40.257619 [ 228264 ] {} <Debug> TCP-Session: 16ce7780-4162-41a4-8091-131c55dd2786 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2025.01.29 00:55:40.257626 [ 228264 ] {} <Debug> TCP-Session: 16ce7780-4162-41a4-8091-131c55dd2786 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2025.01.29 00:55:40.280229 [ 228265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45630 | ||
| 266 | 2025.01.29 00:55:40.280357 [ 228265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 267 | 2025.01.29 00:55:40.280386 [ 228265 ] {} <Debug> TCP-Session: 0412b88a-8481-445e-8353-5fb41d314282 Authenticating user 'default' from [::1]:45630 | ||
| 268 | 2025.01.29 00:55:40.280404 [ 228265 ] {} <Debug> TCP-Session: 0412b88a-8481-445e-8353-5fb41d314282 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2025.01.29 00:55:40.280412 [ 228265 ] {} <Debug> TCP-Session: 0412b88a-8481-445e-8353-5fb41d314282 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2025.01.29 00:55:40.288273 [ 228262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45624 | ||
| 271 | 2025.01.29 00:55:40.288386 [ 228262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 272 | 2025.01.29 00:55:40.288412 [ 228262 ] {} <Debug> TCP-Session: 7dbfcd2c-cd4a-486a-92e5-25bc39b2f5bb Authenticating user 'default' from [::1]:45624 | ||
| 273 | 2025.01.29 00:55:40.288430 [ 228262 ] {} <Debug> TCP-Session: 7dbfcd2c-cd4a-486a-92e5-25bc39b2f5bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2025.01.29 00:55:40.288437 [ 228262 ] {} <Debug> TCP-Session: 7dbfcd2c-cd4a-486a-92e5-25bc39b2f5bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2025.01.29 00:55:40.288548 [ 228259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45618 | ||
| 276 | 2025.01.29 00:55:40.288602 [ 228259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 277 | 2025.01.29 00:55:40.288621 [ 228259 ] {} <Debug> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Authenticating user 'default' from [::1]:45618 | ||
| 278 | 2025.01.29 00:55:40.288628 [ 228259 ] {} <Debug> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.01.29 00:55:40.288633 [ 228259 ] {} <Debug> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2025.01.29 00:55:40.297629 [ 228266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45632 | ||
| 281 | 2025.01.29 00:55:40.297813 [ 228266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 282 | 2025.01.29 00:55:40.297842 [ 228266 ] {} <Debug> TCP-Session: 30f04ad1-8ae4-4e47-bc5d-5394ffffdfaa Authenticating user 'default' from [::1]:45632 | ||
| 283 | 2025.01.29 00:55:40.297875 [ 228266 ] {} <Debug> TCP-Session: 30f04ad1-8ae4-4e47-bc5d-5394ffffdfaa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 284 | 2025.01.29 00:55:40.297881 [ 228266 ] {} <Debug> TCP-Session: 30f04ad1-8ae4-4e47-bc5d-5394ffffdfaa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 285 | 2025.01.29 00:55:40.570959 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 286 | 2025.01.29 00:55:40.571169 [ 228258 ] {7f533398-597a-4111-94f5-5e774087af9b} <Debug> executeQuery: (from [::1]:45616) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 287 | 2025.01.29 00:55:40.571288 [ 228258 ] {7f533398-597a-4111-94f5-5e774087af9b} <Debug> TCPHandler: Processed in 0.00057932 sec. | ||
| 288 | 2025.01.29 00:55:40.584538 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 289 | 2025.01.29 00:55:40.584785 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Debug> executeQuery: (from [::1]:45618) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 290 | 2025.01.29 00:55:40.584840 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 291 | 2025.01.29 00:55:40.589676 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 292 | 2025.01.29 00:55:40.589709 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00010019 sec | ||
| 293 | 2025.01.29 00:55:40.589717 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Trace> ReferentialDeps: No tables | ||
| 294 | 2025.01.29 00:55:40.589741 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Trace> LoadingDeps: No tables | ||
| 295 | 2025.01.29 00:55:40.589774 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 296 | 2025.01.29 00:55:40.589875 [ 228259 ] {5ff220f9-7e2c-4850-9bd0-3277a02676b4} <Debug> TCPHandler: Processed in 0.00556756 sec. | ||
| 297 | 2025.01.29 00:55:40.598163 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 298 | 2025.01.29 00:55:40.598451 [ 228258 ] {9e165d06-a059-46c5-bc75-d61224ed45ab} <Debug> executeQuery: (from [::1]:45616) /* The version table contains metadata about the `oximeter` database */ | ||
| 299 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 300 | 2025.01.29 00:55:40.598505 [ 228258 ] {9e165d06-a059-46c5-bc75-d61224ed45ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 301 | 2025.01.29 00:55:40.602846 [ 228258 ] {9e165d06-a059-46c5-bc75-d61224ed45ab} <Debug> oximeter.version (c0176242-19c0-4504-9bbc-6bf805deaf4c): Loading data parts | ||
| 302 | 2025.01.29 00:55:40.603992 [ 228258 ] {9e165d06-a059-46c5-bc75-d61224ed45ab} <Debug> oximeter.version (c0176242-19c0-4504-9bbc-6bf805deaf4c): There are no data parts | ||
| 303 | 2025.01.29 00:55:40.610042 [ 228258 ] {9e165d06-a059-46c5-bc75-d61224ed45ab} <Debug> TCPHandler: Processed in 0.01207479 sec. | ||
| 304 | 2025.01.29 00:55:40.624719 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 305 | 2025.01.29 00:55:40.625067 [ 228259 ] {d7dd61df-7dd9-45a6-8be9-a496dd0de8cf} <Debug> executeQuery: (from [::1]:45618) /* The measurement tables contain all individual samples from each timeseries. | ||
| 306 | * | ||
| 307 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 308 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 309 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 310 | * by all samples from the same timeseries. | ||
| 311 | * | ||
| 312 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 313 | * and then uses that to index quickly into the measurements tables. | ||
| 314 | */ | ||
| 315 | 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) | ||
| 316 | 2025.01.29 00:55:40.625127 [ 228259 ] {d7dd61df-7dd9-45a6-8be9-a496dd0de8cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 317 | 2025.01.29 00:55:40.630897 [ 228259 ] {d7dd61df-7dd9-45a6-8be9-a496dd0de8cf} <Debug> oximeter.measurements_bool (4b19af29-c7ce-4b4b-ab0c-c1c6b479cee1): Loading data parts | ||
| 318 | 2025.01.29 00:55:40.631198 [ 228259 ] {d7dd61df-7dd9-45a6-8be9-a496dd0de8cf} <Debug> oximeter.measurements_bool (4b19af29-c7ce-4b4b-ab0c-c1c6b479cee1): There are no data parts | ||
| 319 | 2025.01.29 00:55:40.636928 [ 228259 ] {d7dd61df-7dd9-45a6-8be9-a496dd0de8cf} <Debug> TCPHandler: Processed in 0.01244052 sec. | ||
| 320 | 2025.01.29 00:55:40.648707 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 321 | 2025.01.29 00:55:40.649035 [ 228258 ] {bbb1cff8-bb35-478a-8f4b-ce0a8dd50af5} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 322 | 2025.01.29 00:55:40.649095 [ 228258 ] {bbb1cff8-bb35-478a-8f4b-ce0a8dd50af5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 323 | 2025.01.29 00:55:40.654020 [ 228258 ] {bbb1cff8-bb35-478a-8f4b-ce0a8dd50af5} <Debug> oximeter.measurements_i8 (2041508b-aaf5-4de5-8555-b7c95f24c2d4): Loading data parts | ||
| 324 | 2025.01.29 00:55:40.654543 [ 228258 ] {bbb1cff8-bb35-478a-8f4b-ce0a8dd50af5} <Debug> oximeter.measurements_i8 (2041508b-aaf5-4de5-8555-b7c95f24c2d4): There are no data parts | ||
| 325 | 2025.01.29 00:55:40.664548 [ 228258 ] {bbb1cff8-bb35-478a-8f4b-ce0a8dd50af5} <Debug> TCPHandler: Processed in 0.01605176 sec. | ||
| 326 | 2025.01.29 00:55:40.666159 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 327 | 2025.01.29 00:55:40.667955 [ 228259 ] {4d51b64d-8fac-440b-b205-4eb8456b7231} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 328 | 2025.01.29 00:55:40.668037 [ 228259 ] {4d51b64d-8fac-440b-b205-4eb8456b7231} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 329 | 2025.01.29 00:55:40.673266 [ 228259 ] {4d51b64d-8fac-440b-b205-4eb8456b7231} <Debug> oximeter.measurements_u8 (a639a88d-cd51-4751-90ea-b5e5fcc1106f): Loading data parts | ||
| 330 | 2025.01.29 00:55:40.673578 [ 228259 ] {4d51b64d-8fac-440b-b205-4eb8456b7231} <Debug> oximeter.measurements_u8 (a639a88d-cd51-4751-90ea-b5e5fcc1106f): There are no data parts | ||
| 331 | 2025.01.29 00:55:40.677801 [ 228259 ] {4d51b64d-8fac-440b-b205-4eb8456b7231} <Debug> TCPHandler: Processed in 0.01186647 sec. | ||
| 332 | 2025.01.29 00:55:40.679093 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 333 | 2025.01.29 00:55:40.679396 [ 228258 ] {a293f89a-142a-4bd7-9dbc-b78f88949b4f} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 334 | 2025.01.29 00:55:40.680915 [ 228258 ] {a293f89a-142a-4bd7-9dbc-b78f88949b4f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 335 | 2025.01.29 00:55:40.686615 [ 228258 ] {a293f89a-142a-4bd7-9dbc-b78f88949b4f} <Debug> oximeter.measurements_i16 (fec7cd33-8ccf-4d09-9b0b-fd7acb94717e): Loading data parts | ||
| 336 | 2025.01.29 00:55:40.686996 [ 228258 ] {a293f89a-142a-4bd7-9dbc-b78f88949b4f} <Debug> oximeter.measurements_i16 (fec7cd33-8ccf-4d09-9b0b-fd7acb94717e): There are no data parts | ||
| 337 | 2025.01.29 00:55:40.690836 [ 228258 ] {a293f89a-142a-4bd7-9dbc-b78f88949b4f} <Debug> TCPHandler: Processed in 0.0119428 sec. | ||
| 338 | 2025.01.29 00:55:40.692106 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 339 | 2025.01.29 00:55:40.692415 [ 228259 ] {5cfa708e-bcb0-4423-9097-9ea91b400293} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 340 | 2025.01.29 00:55:40.692477 [ 228259 ] {5cfa708e-bcb0-4423-9097-9ea91b400293} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 341 | 2025.01.29 00:55:40.698701 [ 228259 ] {5cfa708e-bcb0-4423-9097-9ea91b400293} <Debug> oximeter.measurements_u16 (3af5807a-b874-41a3-9cca-cfeb5d639214): Loading data parts | ||
| 342 | 2025.01.29 00:55:40.699079 [ 228259 ] {5cfa708e-bcb0-4423-9097-9ea91b400293} <Debug> oximeter.measurements_u16 (3af5807a-b874-41a3-9cca-cfeb5d639214): There are no data parts | ||
| 343 | 2025.01.29 00:55:40.705706 [ 228259 ] {5cfa708e-bcb0-4423-9097-9ea91b400293} <Debug> TCPHandler: Processed in 0.01380374 sec. | ||
| 344 | 2025.01.29 00:55:40.706591 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2025.01.29 00:55:40.707868 [ 228258 ] {3c20043f-a0fa-4bb4-b09b-b65252b8791c} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 346 | 2025.01.29 00:55:40.707935 [ 228258 ] {3c20043f-a0fa-4bb4-b09b-b65252b8791c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 347 | 2025.01.29 00:55:40.712872 [ 228258 ] {3c20043f-a0fa-4bb4-b09b-b65252b8791c} <Debug> oximeter.measurements_i32 (716b5230-793c-4a0c-9d41-319ccbdddbe6): Loading data parts | ||
| 348 | 2025.01.29 00:55:40.713193 [ 228258 ] {3c20043f-a0fa-4bb4-b09b-b65252b8791c} <Debug> oximeter.measurements_i32 (716b5230-793c-4a0c-9d41-319ccbdddbe6): There are no data parts | ||
| 349 | 2025.01.29 00:55:40.717477 [ 228258 ] {3c20043f-a0fa-4bb4-b09b-b65252b8791c} <Debug> TCPHandler: Processed in 0.011069731 sec. | ||
| 350 | 2025.01.29 00:55:40.719831 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 351 | 2025.01.29 00:55:40.720262 [ 228259 ] {9ea2e96b-6584-4dfd-bc2e-e6348d729986} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 352 | 2025.01.29 00:55:40.720344 [ 228259 ] {9ea2e96b-6584-4dfd-bc2e-e6348d729986} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 353 | 2025.01.29 00:55:40.727375 [ 228259 ] {9ea2e96b-6584-4dfd-bc2e-e6348d729986} <Debug> oximeter.measurements_u32 (722a69fc-df54-4238-a0e5-ff23322006ec): Loading data parts | ||
| 354 | 2025.01.29 00:55:40.727768 [ 228259 ] {9ea2e96b-6584-4dfd-bc2e-e6348d729986} <Debug> oximeter.measurements_u32 (722a69fc-df54-4238-a0e5-ff23322006ec): There are no data parts | ||
| 355 | 2025.01.29 00:55:40.731998 [ 228259 ] {9ea2e96b-6584-4dfd-bc2e-e6348d729986} <Debug> TCPHandler: Processed in 0.01242601 sec. | ||
| 356 | 2025.01.29 00:55:40.733039 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2025.01.29 00:55:40.733335 [ 228258 ] {f0241e3a-a5ba-4205-b825-a8fc70eb727a} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 358 | 2025.01.29 00:55:40.733386 [ 228258 ] {f0241e3a-a5ba-4205-b825-a8fc70eb727a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 359 | 2025.01.29 00:55:40.740471 [ 228258 ] {f0241e3a-a5ba-4205-b825-a8fc70eb727a} <Debug> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Loading data parts | ||
| 360 | 2025.01.29 00:55:40.740838 [ 228258 ] {f0241e3a-a5ba-4205-b825-a8fc70eb727a} <Debug> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): There are no data parts | ||
| 361 | 2025.01.29 00:55:40.745632 [ 228258 ] {f0241e3a-a5ba-4205-b825-a8fc70eb727a} <Debug> TCPHandler: Processed in 0.01275502 sec. | ||
| 362 | 2025.01.29 00:55:40.746544 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 363 | 2025.01.29 00:55:40.746869 [ 228259 ] {1efd5021-22c8-45f4-87fa-886223474157} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 364 | 2025.01.29 00:55:40.746931 [ 228259 ] {1efd5021-22c8-45f4-87fa-886223474157} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 365 | 2025.01.29 00:55:40.752681 [ 228259 ] {1efd5021-22c8-45f4-87fa-886223474157} <Debug> oximeter.measurements_u64 (288bf66f-8077-4ad6-a91d-ef857879f41f): Loading data parts | ||
| 366 | 2025.01.29 00:55:40.753006 [ 228259 ] {1efd5021-22c8-45f4-87fa-886223474157} <Debug> oximeter.measurements_u64 (288bf66f-8077-4ad6-a91d-ef857879f41f): There are no data parts | ||
| 367 | 2025.01.29 00:55:40.758320 [ 228259 ] {1efd5021-22c8-45f4-87fa-886223474157} <Debug> TCPHandler: Processed in 0.01195109 sec. | ||
| 368 | 2025.01.29 00:55:40.759625 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2025.01.29 00:55:40.759952 [ 228258 ] {3259f5df-c3a8-45f4-b594-1ef119e0e72c} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 370 | 2025.01.29 00:55:40.761652 [ 228258 ] {3259f5df-c3a8-45f4-b594-1ef119e0e72c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 371 | 2025.01.29 00:55:40.767448 [ 228258 ] {3259f5df-c3a8-45f4-b594-1ef119e0e72c} <Debug> oximeter.measurements_f32 (0ac03e51-2cfc-429d-8aae-19905946da02): Loading data parts | ||
| 372 | 2025.01.29 00:55:40.767791 [ 228258 ] {3259f5df-c3a8-45f4-b594-1ef119e0e72c} <Debug> oximeter.measurements_f32 (0ac03e51-2cfc-429d-8aae-19905946da02): There are no data parts | ||
| 373 | 2025.01.29 00:55:40.774738 [ 228258 ] {3259f5df-c3a8-45f4-b594-1ef119e0e72c} <Debug> TCPHandler: Processed in 0.015337571 sec. | ||
| 374 | 2025.01.29 00:55:40.775750 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 375 | 2025.01.29 00:55:40.776073 [ 228259 ] {981fee8e-0248-49f6-9dba-b966e9c2b45b} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 376 | 2025.01.29 00:55:40.777273 [ 228259 ] {981fee8e-0248-49f6-9dba-b966e9c2b45b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 377 | 2025.01.29 00:55:40.782243 [ 228259 ] {981fee8e-0248-49f6-9dba-b966e9c2b45b} <Debug> oximeter.measurements_f64 (bc5c684b-8be5-4397-b228-4d54b7b516b0): Loading data parts | ||
| 378 | 2025.01.29 00:55:40.782523 [ 228259 ] {981fee8e-0248-49f6-9dba-b966e9c2b45b} <Debug> oximeter.measurements_f64 (bc5c684b-8be5-4397-b228-4d54b7b516b0): There are no data parts | ||
| 379 | 2025.01.29 00:55:40.786376 [ 228259 ] {981fee8e-0248-49f6-9dba-b966e9c2b45b} <Debug> TCPHandler: Processed in 0.01084155 sec. | ||
| 380 | 2025.01.29 00:55:40.787330 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2025.01.29 00:55:40.787743 [ 228258 ] {a6f939ef-e0bd-438f-b2d0-571a7cabaa5a} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 382 | 2025.01.29 00:55:40.787817 [ 228258 ] {a6f939ef-e0bd-438f-b2d0-571a7cabaa5a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 383 | 2025.01.29 00:55:40.794660 [ 228258 ] {a6f939ef-e0bd-438f-b2d0-571a7cabaa5a} <Debug> oximeter.measurements_string (cb6aa9be-f25e-4c6c-bba4-31079d158465): Loading data parts | ||
| 384 | 2025.01.29 00:55:40.795104 [ 228258 ] {a6f939ef-e0bd-438f-b2d0-571a7cabaa5a} <Debug> oximeter.measurements_string (cb6aa9be-f25e-4c6c-bba4-31079d158465): There are no data parts | ||
| 385 | 2025.01.29 00:55:40.799993 [ 228258 ] {a6f939ef-e0bd-438f-b2d0-571a7cabaa5a} <Debug> TCPHandler: Processed in 0.01287952 sec. | ||
| 386 | 2025.01.29 00:55:40.801375 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 387 | 2025.01.29 00:55:40.802598 [ 228259 ] {60458141-4b54-429e-bf8c-e77b35f357b3} <Debug> executeQuery: (from [::1]:45618) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 388 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 389 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 390 | * a string isn't palatable for a few reasons. | ||
| 391 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 392 | * details. | ||
| 393 | */ | ||
| 394 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 395 | 2025.01.29 00:55:40.802663 [ 228259 ] {60458141-4b54-429e-bf8c-e77b35f357b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 396 | 2025.01.29 00:55:40.808649 [ 228259 ] {60458141-4b54-429e-bf8c-e77b35f357b3} <Debug> oximeter.measurements_bytes (b3442eaf-aaf3-4893-be41-ee99f5ff34f2): Loading data parts | ||
| 397 | 2025.01.29 00:55:40.809001 [ 228259 ] {60458141-4b54-429e-bf8c-e77b35f357b3} <Debug> oximeter.measurements_bytes (b3442eaf-aaf3-4893-be41-ee99f5ff34f2): There are no data parts | ||
| 398 | 2025.01.29 00:55:40.814181 [ 228259 ] {60458141-4b54-429e-bf8c-e77b35f357b3} <Debug> TCPHandler: Processed in 0.01303742 sec. | ||
| 399 | 2025.01.29 00:55:40.815124 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 400 | 2025.01.29 00:55:40.816515 [ 228258 ] {f5c31686-7873-4bb1-9c06-4d8f97d49877} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 401 | 2025.01.29 00:55:40.816578 [ 228258 ] {f5c31686-7873-4bb1-9c06-4d8f97d49877} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 402 | 2025.01.29 00:55:40.823070 [ 228258 ] {f5c31686-7873-4bb1-9c06-4d8f97d49877} <Debug> oximeter.measurements_cumulativei64 (1e46fd65-b2d9-4365-bcb6-36ab9f4f9447): Loading data parts | ||
| 403 | 2025.01.29 00:55:40.823393 [ 228258 ] {f5c31686-7873-4bb1-9c06-4d8f97d49877} <Debug> oximeter.measurements_cumulativei64 (1e46fd65-b2d9-4365-bcb6-36ab9f4f9447): There are no data parts | ||
| 404 | 2025.01.29 00:55:40.830565 [ 228258 ] {f5c31686-7873-4bb1-9c06-4d8f97d49877} <Debug> TCPHandler: Processed in 0.01560261 sec. | ||
| 405 | 2025.01.29 00:55:40.831525 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 406 | 2025.01.29 00:55:40.833092 [ 228259 ] {21bc0bc1-0d3d-44be-8710-b08a3e93ca59} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 407 | 2025.01.29 00:55:40.833171 [ 228259 ] {21bc0bc1-0d3d-44be-8710-b08a3e93ca59} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 408 | 2025.01.29 00:55:40.839300 [ 228259 ] {21bc0bc1-0d3d-44be-8710-b08a3e93ca59} <Debug> oximeter.measurements_cumulativeu64 (1d1de4ee-66aa-4bb2-bb18-b097cf11149c): Loading data parts | ||
| 409 | 2025.01.29 00:55:40.841954 [ 228259 ] {21bc0bc1-0d3d-44be-8710-b08a3e93ca59} <Debug> oximeter.measurements_cumulativeu64 (1d1de4ee-66aa-4bb2-bb18-b097cf11149c): There are no data parts | ||
| 410 | 2025.01.29 00:55:40.846208 [ 228259 ] {21bc0bc1-0d3d-44be-8710-b08a3e93ca59} <Debug> TCPHandler: Processed in 0.01487765 sec. | ||
| 411 | 2025.01.29 00:55:40.847253 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 412 | 2025.01.29 00:55:40.847641 [ 228258 ] {1ca04400-f0d2-4abf-9a2a-ad397628f3b6} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 413 | 2025.01.29 00:55:40.847708 [ 228258 ] {1ca04400-f0d2-4abf-9a2a-ad397628f3b6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 414 | 2025.01.29 00:55:40.856227 [ 228258 ] {1ca04400-f0d2-4abf-9a2a-ad397628f3b6} <Debug> oximeter.measurements_cumulativef32 (746288ee-94c5-4ed7-bbe9-e269cd7fe2c5): Loading data parts | ||
| 415 | 2025.01.29 00:55:40.856560 [ 228258 ] {1ca04400-f0d2-4abf-9a2a-ad397628f3b6} <Debug> oximeter.measurements_cumulativef32 (746288ee-94c5-4ed7-bbe9-e269cd7fe2c5): There are no data parts | ||
| 416 | 2025.01.29 00:55:40.860731 [ 228258 ] {1ca04400-f0d2-4abf-9a2a-ad397628f3b6} <Debug> TCPHandler: Processed in 0.01370303 sec. | ||
| 417 | 2025.01.29 00:55:40.861636 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 418 | 2025.01.29 00:55:40.862000 [ 228259 ] {a241f977-03a7-4a5c-965d-0cf79ace0116} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 419 | 2025.01.29 00:55:40.862059 [ 228259 ] {a241f977-03a7-4a5c-965d-0cf79ace0116} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 420 | 2025.01.29 00:55:40.868052 [ 228259 ] {a241f977-03a7-4a5c-965d-0cf79ace0116} <Debug> oximeter.measurements_cumulativef64 (0fcbd36b-3fe9-4256-8c97-a03ba7b4e3ec): Loading data parts | ||
| 421 | 2025.01.29 00:55:40.868326 [ 228259 ] {a241f977-03a7-4a5c-965d-0cf79ace0116} <Debug> oximeter.measurements_cumulativef64 (0fcbd36b-3fe9-4256-8c97-a03ba7b4e3ec): There are no data parts | ||
| 422 | 2025.01.29 00:55:40.872657 [ 228259 ] {a241f977-03a7-4a5c-965d-0cf79ace0116} <Debug> TCPHandler: Processed in 0.01121317 sec. | ||
| 423 | 2025.01.29 00:55:40.873695 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 424 | 2025.01.29 00:55:40.874160 [ 228258 ] {452b7738-9f04-4422-8a88-3b2109120a84} <Debug> executeQuery: (from [::1]:45616) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 425 | * NOTE: Array types cannot be Nullable, see | ||
| 426 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 427 | * for more details. | ||
| 428 | * | ||
| 429 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 430 | * is unfortunate, and at this point relies on the fact that an | ||
| 431 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 432 | * to figure out another way to represent missing samples here. | ||
| 433 | */ | ||
| 434 | 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) | ||
| 435 | 2025.01.29 00:55:40.874246 [ 228258 ] {452b7738-9f04-4422-8a88-3b2109120a84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 436 | 2025.01.29 00:55:40.881269 [ 228258 ] {452b7738-9f04-4422-8a88-3b2109120a84} <Debug> oximeter.measurements_histogrami8 (bfe4526e-2cdb-462e-b8a8-11d72fd877d8): Loading data parts | ||
| 437 | 2025.01.29 00:55:40.881629 [ 228258 ] {452b7738-9f04-4422-8a88-3b2109120a84} <Debug> oximeter.measurements_histogrami8 (bfe4526e-2cdb-462e-b8a8-11d72fd877d8): There are no data parts | ||
| 438 | 2025.01.29 00:55:40.885620 [ 228258 ] {452b7738-9f04-4422-8a88-3b2109120a84} <Debug> TCPHandler: Processed in 0.01215303 sec. | ||
| 439 | 2025.01.29 00:55:40.886671 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2025.01.29 00:55:40.886999 [ 228259 ] {1c40eb1b-9193-4e51-ae69-82fa4a8f2e6c} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 441 | 2025.01.29 00:55:40.887073 [ 228259 ] {1c40eb1b-9193-4e51-ae69-82fa4a8f2e6c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 442 | 2025.01.29 00:55:40.892685 [ 228259 ] {1c40eb1b-9193-4e51-ae69-82fa4a8f2e6c} <Debug> oximeter.measurements_histogramu8 (9b1488a4-2ee6-4a37-a13a-6abf95a66111): Loading data parts | ||
| 443 | 2025.01.29 00:55:40.893172 [ 228259 ] {1c40eb1b-9193-4e51-ae69-82fa4a8f2e6c} <Debug> oximeter.measurements_histogramu8 (9b1488a4-2ee6-4a37-a13a-6abf95a66111): There are no data parts | ||
| 444 | 2025.01.29 00:55:40.897328 [ 228259 ] {1c40eb1b-9193-4e51-ae69-82fa4a8f2e6c} <Debug> TCPHandler: Processed in 0.01084948 sec. | ||
| 445 | 2025.01.29 00:55:40.898396 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 446 | 2025.01.29 00:55:40.900002 [ 228258 ] {8aa9942a-5b21-4884-af4e-f0cb55a74d42} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 447 | 2025.01.29 00:55:40.900102 [ 228258 ] {8aa9942a-5b21-4884-af4e-f0cb55a74d42} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 448 | 2025.01.29 00:55:40.904801 [ 228258 ] {8aa9942a-5b21-4884-af4e-f0cb55a74d42} <Debug> oximeter.measurements_histogrami16 (65d607d4-f306-4e4a-babb-69028eecfa39): Loading data parts | ||
| 449 | 2025.01.29 00:55:40.905163 [ 228258 ] {8aa9942a-5b21-4884-af4e-f0cb55a74d42} <Debug> oximeter.measurements_histogrami16 (65d607d4-f306-4e4a-babb-69028eecfa39): There are no data parts | ||
| 450 | 2025.01.29 00:55:40.910026 [ 228258 ] {8aa9942a-5b21-4884-af4e-f0cb55a74d42} <Debug> TCPHandler: Processed in 0.0118161 sec. | ||
| 451 | 2025.01.29 00:55:40.937594 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 452 | 2025.01.29 00:55:40.937995 [ 228259 ] {158382fd-23da-4caf-8312-d665fde09851} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 453 | 2025.01.29 00:55:40.938063 [ 228259 ] {158382fd-23da-4caf-8312-d665fde09851} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 454 | 2025.01.29 00:55:40.944266 [ 228259 ] {158382fd-23da-4caf-8312-d665fde09851} <Debug> oximeter.measurements_histogramu16 (28dd0053-a5f3-4f82-b12c-539b9c5bd5d2): Loading data parts | ||
| 455 | 2025.01.29 00:55:40.944616 [ 228259 ] {158382fd-23da-4caf-8312-d665fde09851} <Debug> oximeter.measurements_histogramu16 (28dd0053-a5f3-4f82-b12c-539b9c5bd5d2): There are no data parts | ||
| 456 | 2025.01.29 00:55:40.950982 [ 228259 ] {158382fd-23da-4caf-8312-d665fde09851} <Debug> TCPHandler: Processed in 0.01355348 sec. | ||
| 457 | 2025.01.29 00:55:40.951842 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 458 | 2025.01.29 00:55:40.952261 [ 228258 ] {cf6c494d-599b-4a23-834f-80bcdea63b91} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 459 | 2025.01.29 00:55:40.952354 [ 228258 ] {cf6c494d-599b-4a23-834f-80bcdea63b91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 460 | 2025.01.29 00:55:40.957683 [ 228258 ] {cf6c494d-599b-4a23-834f-80bcdea63b91} <Debug> oximeter.measurements_histogrami32 (9854fcfc-f745-4b3e-9be4-627a7018bebe): Loading data parts | ||
| 461 | 2025.01.29 00:55:40.959747 [ 228258 ] {cf6c494d-599b-4a23-834f-80bcdea63b91} <Debug> oximeter.measurements_histogrami32 (9854fcfc-f745-4b3e-9be4-627a7018bebe): There are no data parts | ||
| 462 | 2025.01.29 00:55:40.968311 [ 228258 ] {cf6c494d-599b-4a23-834f-80bcdea63b91} <Debug> TCPHandler: Processed in 0.01667218 sec. | ||
| 463 | 2025.01.29 00:55:40.969860 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2025.01.29 00:55:40.971870 [ 228259 ] {77003f80-1538-4735-8348-0441cedd8ef8} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 465 | 2025.01.29 00:55:40.971938 [ 228259 ] {77003f80-1538-4735-8348-0441cedd8ef8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 466 | 2025.01.29 00:55:40.976773 [ 228259 ] {77003f80-1538-4735-8348-0441cedd8ef8} <Debug> oximeter.measurements_histogramu32 (1fc016c7-37c8-488e-b9fe-bfd88999cadc): Loading data parts | ||
| 467 | 2025.01.29 00:55:40.977457 [ 228259 ] {77003f80-1538-4735-8348-0441cedd8ef8} <Debug> oximeter.measurements_histogramu32 (1fc016c7-37c8-488e-b9fe-bfd88999cadc): There are no data parts | ||
| 468 | 2025.01.29 00:55:40.984311 [ 228259 ] {77003f80-1538-4735-8348-0441cedd8ef8} <Debug> TCPHandler: Processed in 0.014667091 sec. | ||
| 469 | 2025.01.29 00:55:40.985417 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 470 | 2025.01.29 00:55:40.987290 [ 228258 ] {fc196b30-44a2-4f33-8065-06ce39305555} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 471 | 2025.01.29 00:55:40.987391 [ 228258 ] {fc196b30-44a2-4f33-8065-06ce39305555} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 472 | 2025.01.29 00:55:40.994745 [ 228258 ] {fc196b30-44a2-4f33-8065-06ce39305555} <Debug> oximeter.measurements_histogrami64 (069822d2-7010-4360-8929-89dadfdfea65): Loading data parts | ||
| 473 | 2025.01.29 00:55:40.996245 [ 228258 ] {fc196b30-44a2-4f33-8065-06ce39305555} <Debug> oximeter.measurements_histogrami64 (069822d2-7010-4360-8929-89dadfdfea65): There are no data parts | ||
| 474 | 2025.01.29 00:55:41.000465 [ 227811 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 405.64 MiB, peak 405.65 MiB, free memory in arenas 13.04 MiB, will set to 404.63 MiB (RSS), difference: -1.02 MiB | ||
| 475 | 2025.01.29 00:55:41.001714 [ 228258 ] {fc196b30-44a2-4f33-8065-06ce39305555} <Debug> TCPHandler: Processed in 0.01652841 sec. | ||
| 476 | 2025.01.29 00:55:41.002883 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2025.01.29 00:55:41.003437 [ 228259 ] {b8c23d4d-b836-4c6c-a7e9-104a565afd63} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 478 | 2025.01.29 00:55:41.005081 [ 228259 ] {b8c23d4d-b836-4c6c-a7e9-104a565afd63} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 479 | 2025.01.29 00:55:41.010194 [ 228259 ] {b8c23d4d-b836-4c6c-a7e9-104a565afd63} <Debug> oximeter.measurements_histogramu64 (2dbb2702-bd03-4fa0-a50c-bcc289ca471d): Loading data parts | ||
| 480 | 2025.01.29 00:55:41.010538 [ 228259 ] {b8c23d4d-b836-4c6c-a7e9-104a565afd63} <Debug> oximeter.measurements_histogramu64 (2dbb2702-bd03-4fa0-a50c-bcc289ca471d): There are no data parts | ||
| 481 | 2025.01.29 00:55:41.016881 [ 228259 ] {b8c23d4d-b836-4c6c-a7e9-104a565afd63} <Debug> TCPHandler: Processed in 0.01418708 sec. | ||
| 482 | 2025.01.29 00:55:41.017836 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2025.01.29 00:55:41.020057 [ 228258 ] {fa475ea8-421e-4d86-be8a-e5a8c6387c73} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 484 | 2025.01.29 00:55:41.020129 [ 228258 ] {fa475ea8-421e-4d86-be8a-e5a8c6387c73} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 485 | 2025.01.29 00:55:41.027853 [ 228258 ] {fa475ea8-421e-4d86-be8a-e5a8c6387c73} <Debug> oximeter.measurements_histogramf32 (8fdcf54f-abf2-4836-aafa-b4b0fad3e0de): Loading data parts | ||
| 486 | 2025.01.29 00:55:41.028253 [ 228258 ] {fa475ea8-421e-4d86-be8a-e5a8c6387c73} <Debug> oximeter.measurements_histogramf32 (8fdcf54f-abf2-4836-aafa-b4b0fad3e0de): There are no data parts | ||
| 487 | 2025.01.29 00:55:41.032414 [ 228258 ] {fa475ea8-421e-4d86-be8a-e5a8c6387c73} <Debug> TCPHandler: Processed in 0.01478407 sec. | ||
| 488 | 2025.01.29 00:55:41.033590 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2025.01.29 00:55:41.033995 [ 228259 ] {3f147256-abd2-4ec6-b1ef-db8722d66989} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 490 | 2025.01.29 00:55:41.034054 [ 228259 ] {3f147256-abd2-4ec6-b1ef-db8722d66989} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 491 | 2025.01.29 00:55:41.039761 [ 228259 ] {3f147256-abd2-4ec6-b1ef-db8722d66989} <Debug> oximeter.measurements_histogramf64 (52a8f128-d4c3-4348-932b-b795617a92cd): Loading data parts | ||
| 492 | 2025.01.29 00:55:41.040054 [ 228259 ] {3f147256-abd2-4ec6-b1ef-db8722d66989} <Debug> oximeter.measurements_histogramf64 (52a8f128-d4c3-4348-932b-b795617a92cd): There are no data parts | ||
| 493 | 2025.01.29 00:55:41.045680 [ 228259 ] {3f147256-abd2-4ec6-b1ef-db8722d66989} <Debug> TCPHandler: Processed in 0.012330341 sec. | ||
| 494 | 2025.01.29 00:55:41.047379 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2025.01.29 00:55:41.047675 [ 228258 ] {57ea3017-1c2d-4600-a978-c02534daeda8} <Debug> executeQuery: (from [::1]:45616) /* The field tables store named dimensions of each timeseries. | ||
| 496 | * | ||
| 497 | * As with the measurement tables, there is one field table for each field data | ||
| 498 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 499 | * this behavior **must not** be relied upon for query correctness. | ||
| 500 | * | ||
| 501 | * The index for the fields differs from the measurements, however. Rows are | ||
| 502 | * sorted by timeseries name, then field name, field value, and finally | ||
| 503 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 504 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 505 | * usually then used to look up measurements. | ||
| 506 | * | ||
| 507 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 508 | * timeseries name and then key, since it would improve lookups where one | ||
| 509 | * already has the key. Realistically though, these tables are quite small and | ||
| 510 | * so performance benefits will be low in absolute terms. | ||
| 511 | * | ||
| 512 | * TTL: We use a materialized column to expire old field table records. This | ||
| 513 | * column is generated automatically by the database whenever a new row is | ||
| 514 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 515 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 516 | * record will remain during a deduplication, which will have the last | ||
| 517 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 518 | * measurement tables. | ||
| 519 | */ | ||
| 520 | 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) | ||
| 521 | 2025.01.29 00:55:41.047739 [ 228258 ] {57ea3017-1c2d-4600-a978-c02534daeda8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 522 | 2025.01.29 00:55:41.054771 [ 228258 ] {57ea3017-1c2d-4600-a978-c02534daeda8} <Debug> oximeter.fields_bool (5e437da8-ed4d-4cf5-aad6-fff9c92fb07d): Loading data parts | ||
| 523 | 2025.01.29 00:55:41.055479 [ 228258 ] {57ea3017-1c2d-4600-a978-c02534daeda8} <Debug> oximeter.fields_bool (5e437da8-ed4d-4cf5-aad6-fff9c92fb07d): There are no data parts | ||
| 524 | 2025.01.29 00:55:41.059482 [ 228258 ] {57ea3017-1c2d-4600-a978-c02534daeda8} <Debug> TCPHandler: Processed in 0.01225182 sec. | ||
| 525 | 2025.01.29 00:55:41.060400 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 526 | 2025.01.29 00:55:41.060715 [ 228259 ] {63ad4b13-4144-4362-89bd-f3572571f0cc} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 527 | 2025.01.29 00:55:41.060773 [ 228259 ] {63ad4b13-4144-4362-89bd-f3572571f0cc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 528 | 2025.01.29 00:55:41.068125 [ 228259 ] {63ad4b13-4144-4362-89bd-f3572571f0cc} <Debug> oximeter.fields_i8 (d5469bb5-0f06-475a-8659-9e3fc2a5d442): Loading data parts | ||
| 529 | 2025.01.29 00:55:41.068410 [ 228259 ] {63ad4b13-4144-4362-89bd-f3572571f0cc} <Debug> oximeter.fields_i8 (d5469bb5-0f06-475a-8659-9e3fc2a5d442): There are no data parts | ||
| 530 | 2025.01.29 00:55:41.072942 [ 228259 ] {63ad4b13-4144-4362-89bd-f3572571f0cc} <Debug> TCPHandler: Processed in 0.01274433 sec. | ||
| 531 | 2025.01.29 00:55:41.074029 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 532 | 2025.01.29 00:55:41.074323 [ 228258 ] {435f332f-ef8c-45f0-b39d-4d1165f41b6f} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 533 | 2025.01.29 00:55:41.074381 [ 228258 ] {435f332f-ef8c-45f0-b39d-4d1165f41b6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 534 | 2025.01.29 00:55:41.079629 [ 228258 ] {435f332f-ef8c-45f0-b39d-4d1165f41b6f} <Debug> oximeter.fields_u8 (232f01de-a2f4-49e5-9cb0-7e472e66255b): Loading data parts | ||
| 535 | 2025.01.29 00:55:41.079969 [ 228258 ] {435f332f-ef8c-45f0-b39d-4d1165f41b6f} <Debug> oximeter.fields_u8 (232f01de-a2f4-49e5-9cb0-7e472e66255b): There are no data parts | ||
| 536 | 2025.01.29 00:55:41.084680 [ 228258 ] {435f332f-ef8c-45f0-b39d-4d1165f41b6f} <Debug> TCPHandler: Processed in 0.01084481 sec. | ||
| 537 | 2025.01.29 00:55:41.085770 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 538 | 2025.01.29 00:55:41.086105 [ 228259 ] {2532e0d5-8b26-46c4-903f-8af76a6f8ec8} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 539 | 2025.01.29 00:55:41.087371 [ 228259 ] {2532e0d5-8b26-46c4-903f-8af76a6f8ec8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 540 | 2025.01.29 00:55:41.092186 [ 228259 ] {2532e0d5-8b26-46c4-903f-8af76a6f8ec8} <Debug> oximeter.fields_i16 (84ab1a09-4b09-4936-9f31-7078cd995dd9): Loading data parts | ||
| 541 | 2025.01.29 00:55:41.093908 [ 228259 ] {2532e0d5-8b26-46c4-903f-8af76a6f8ec8} <Debug> oximeter.fields_i16 (84ab1a09-4b09-4936-9f31-7078cd995dd9): There are no data parts | ||
| 542 | 2025.01.29 00:55:41.098248 [ 228259 ] {2532e0d5-8b26-46c4-903f-8af76a6f8ec8} <Debug> TCPHandler: Processed in 0.01272064 sec. | ||
| 543 | 2025.01.29 00:55:41.099414 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2025.01.29 00:55:41.099767 [ 228258 ] {a00b4443-eeb0-430c-9f43-901854de3d4c} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 545 | 2025.01.29 00:55:41.101268 [ 228258 ] {a00b4443-eeb0-430c-9f43-901854de3d4c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 546 | 2025.01.29 00:55:41.107364 [ 228258 ] {a00b4443-eeb0-430c-9f43-901854de3d4c} <Debug> oximeter.fields_u16 (85a25aba-dc85-4586-a003-e5c4743fc2d0): Loading data parts | ||
| 547 | 2025.01.29 00:55:41.107862 [ 228258 ] {a00b4443-eeb0-430c-9f43-901854de3d4c} <Debug> oximeter.fields_u16 (85a25aba-dc85-4586-a003-e5c4743fc2d0): There are no data parts | ||
| 548 | 2025.01.29 00:55:41.114427 [ 228258 ] {a00b4443-eeb0-430c-9f43-901854de3d4c} <Debug> TCPHandler: Processed in 0.015209101 sec. | ||
| 549 | 2025.01.29 00:55:41.115454 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2025.01.29 00:55:41.115765 [ 228259 ] {55fe622f-98f4-4bf6-a333-24233a9dcadb} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 551 | 2025.01.29 00:55:41.115826 [ 228259 ] {55fe622f-98f4-4bf6-a333-24233a9dcadb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 552 | 2025.01.29 00:55:41.123441 [ 228259 ] {55fe622f-98f4-4bf6-a333-24233a9dcadb} <Debug> oximeter.fields_i32 (9de08421-d499-4de4-a246-0cb9e4db9de3): Loading data parts | ||
| 553 | 2025.01.29 00:55:41.123805 [ 228259 ] {55fe622f-98f4-4bf6-a333-24233a9dcadb} <Debug> oximeter.fields_i32 (9de08421-d499-4de4-a246-0cb9e4db9de3): There are no data parts | ||
| 554 | 2025.01.29 00:55:41.128312 [ 228259 ] {55fe622f-98f4-4bf6-a333-24233a9dcadb} <Debug> TCPHandler: Processed in 0.01305201 sec. | ||
| 555 | 2025.01.29 00:55:41.133779 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2025.01.29 00:55:41.134140 [ 228258 ] {1c38a9aa-c51d-4629-a726-6f2f0579b9cd} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 557 | 2025.01.29 00:55:41.134201 [ 228258 ] {1c38a9aa-c51d-4629-a726-6f2f0579b9cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 558 | 2025.01.29 00:55:41.139830 [ 228258 ] {1c38a9aa-c51d-4629-a726-6f2f0579b9cd} <Debug> oximeter.fields_u32 (a9cb857e-a61a-48a4-bc58-8416e20be80f): Loading data parts | ||
| 559 | 2025.01.29 00:55:41.140691 [ 228258 ] {1c38a9aa-c51d-4629-a726-6f2f0579b9cd} <Debug> oximeter.fields_u32 (a9cb857e-a61a-48a4-bc58-8416e20be80f): There are no data parts | ||
| 560 | 2025.01.29 00:55:41.144728 [ 228258 ] {1c38a9aa-c51d-4629-a726-6f2f0579b9cd} <Debug> TCPHandler: Processed in 0.01118229 sec. | ||
| 561 | 2025.01.29 00:55:41.148451 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2025.01.29 00:55:41.148846 [ 228259 ] {5e101f83-af22-4c8f-ad71-a5c2a66f4f7b} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 563 | 2025.01.29 00:55:41.148919 [ 228259 ] {5e101f83-af22-4c8f-ad71-a5c2a66f4f7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 564 | 2025.01.29 00:55:41.154827 [ 228259 ] {5e101f83-af22-4c8f-ad71-a5c2a66f4f7b} <Debug> oximeter.fields_i64 (256f230c-4869-40c9-820a-b6a6881ca013): Loading data parts | ||
| 565 | 2025.01.29 00:55:41.155187 [ 228259 ] {5e101f83-af22-4c8f-ad71-a5c2a66f4f7b} <Debug> oximeter.fields_i64 (256f230c-4869-40c9-820a-b6a6881ca013): There are no data parts | ||
| 566 | 2025.01.29 00:55:41.162236 [ 228259 ] {5e101f83-af22-4c8f-ad71-a5c2a66f4f7b} <Debug> TCPHandler: Processed in 0.01403528 sec. | ||
| 567 | 2025.01.29 00:55:41.163821 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2025.01.29 00:55:41.164089 [ 228258 ] {8bda4bdc-a85c-4672-9a9e-7ff1f14ee969} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 569 | 2025.01.29 00:55:41.164147 [ 228258 ] {8bda4bdc-a85c-4672-9a9e-7ff1f14ee969} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 570 | 2025.01.29 00:55:41.169424 [ 228258 ] {8bda4bdc-a85c-4672-9a9e-7ff1f14ee969} <Debug> oximeter.fields_u64 (cefa0ba3-3f2a-470e-828e-f5f6c0bf2755): Loading data parts | ||
| 571 | 2025.01.29 00:55:41.169704 [ 228258 ] {8bda4bdc-a85c-4672-9a9e-7ff1f14ee969} <Debug> oximeter.fields_u64 (cefa0ba3-3f2a-470e-828e-f5f6c0bf2755): There are no data parts | ||
| 572 | 2025.01.29 00:55:41.175687 [ 228258 ] {8bda4bdc-a85c-4672-9a9e-7ff1f14ee969} <Debug> TCPHandler: Processed in 0.012096951 sec. | ||
| 573 | 2025.01.29 00:55:41.176758 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2025.01.29 00:55:41.178057 [ 228259 ] {52dad15d-9023-44a5-8511-6877a49af276} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 575 | 2025.01.29 00:55:41.178116 [ 228259 ] {52dad15d-9023-44a5-8511-6877a49af276} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 576 | 2025.01.29 00:55:41.184741 [ 228259 ] {52dad15d-9023-44a5-8511-6877a49af276} <Debug> oximeter.fields_ipaddr (7a2a580c-8a0e-4bc3-838b-ccbac25e9fcb): Loading data parts | ||
| 577 | 2025.01.29 00:55:41.185100 [ 228259 ] {52dad15d-9023-44a5-8511-6877a49af276} <Debug> oximeter.fields_ipaddr (7a2a580c-8a0e-4bc3-838b-ccbac25e9fcb): There are no data parts | ||
| 578 | 2025.01.29 00:55:41.189575 [ 228259 ] {52dad15d-9023-44a5-8511-6877a49af276} <Debug> TCPHandler: Processed in 0.01302525 sec. | ||
| 579 | 2025.01.29 00:55:41.190522 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2025.01.29 00:55:41.190762 [ 228258 ] {faaef4fb-2a86-480f-9808-e0b3e6d3a1fc} <Debug> executeQuery: (from [::1]:45616) 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) | ||
| 581 | 2025.01.29 00:55:41.190842 [ 228258 ] {faaef4fb-2a86-480f-9808-e0b3e6d3a1fc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 582 | 2025.01.29 00:55:41.196789 [ 228258 ] {faaef4fb-2a86-480f-9808-e0b3e6d3a1fc} <Debug> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Loading data parts | ||
| 583 | 2025.01.29 00:55:41.197202 [ 228258 ] {faaef4fb-2a86-480f-9808-e0b3e6d3a1fc} <Debug> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): There are no data parts | ||
| 584 | 2025.01.29 00:55:41.201219 [ 228258 ] {faaef4fb-2a86-480f-9808-e0b3e6d3a1fc} <Debug> TCPHandler: Processed in 0.01086252 sec. | ||
| 585 | 2025.01.29 00:55:41.202969 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2025.01.29 00:55:41.204760 [ 228259 ] {23c8a48c-9f74-4d23-9261-2a9fad1efdf0} <Debug> executeQuery: (from [::1]:45618) 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) | ||
| 587 | 2025.01.29 00:55:41.204860 [ 228259 ] {23c8a48c-9f74-4d23-9261-2a9fad1efdf0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 588 | 2025.01.29 00:55:41.209978 [ 228259 ] {23c8a48c-9f74-4d23-9261-2a9fad1efdf0} <Debug> oximeter.fields_uuid (c79cdaf8-39b1-494e-96e5-ba45820900cb): Loading data parts | ||
| 589 | 2025.01.29 00:55:41.211294 [ 228259 ] {23c8a48c-9f74-4d23-9261-2a9fad1efdf0} <Debug> oximeter.fields_uuid (c79cdaf8-39b1-494e-96e5-ba45820900cb): There are no data parts | ||
| 590 | 2025.01.29 00:55:41.216862 [ 228259 ] {23c8a48c-9f74-4d23-9261-2a9fad1efdf0} <Debug> TCPHandler: Processed in 0.01413435 sec. | ||
| 591 | 2025.01.29 00:55:41.218017 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2025.01.29 00:55:41.218441 [ 228258 ] {85b729fc-4b3c-4110-867e-bbaee4b9c533} <Debug> executeQuery: (from [::1]:45616) /* The timeseries schema table stores the extracted schema for the samples | ||
| 593 | * oximeter collects. | ||
| 594 | */ | ||
| 595 | 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) | ||
| 596 | 2025.01.29 00:55:41.218523 [ 228258 ] {85b729fc-4b3c-4110-867e-bbaee4b9c533} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 597 | 2025.01.29 00:55:41.224835 [ 228258 ] {85b729fc-4b3c-4110-867e-bbaee4b9c533} <Debug> oximeter.timeseries_schema (46a17f50-0d84-4b97-88c9-04bbdcdca649): Loading data parts | ||
| 598 | 2025.01.29 00:55:41.225227 [ 228258 ] {85b729fc-4b3c-4110-867e-bbaee4b9c533} <Debug> oximeter.timeseries_schema (46a17f50-0d84-4b97-88c9-04bbdcdca649): There are no data parts | ||
| 599 | 2025.01.29 00:55:41.229398 [ 228258 ] {85b729fc-4b3c-4110-867e-bbaee4b9c533} <Debug> TCPHandler: Processed in 0.01161266 sec. | ||
| 600 | 2025.01.29 00:55:41.254923 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2025.01.29 00:55:41.255173 [ 228259 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 602 | 2025.01.29 00:55:41.255314 [ 228259 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 603 | 2025.01.29 00:55:41.256333 [ 228123 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Trace> oximeter.version (c0176242-19c0-4504-9bbc-6bf805deaf4c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 604 | 2025.01.29 00:55:41.256368 [ 228123 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.70 GiB. | ||
| 605 | 2025.01.29 00:55:41.256740 [ 228123 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 606 | 2025.01.29 00:55:41.279837 [ 228123 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Trace> oximeter.version (c0176242-19c0-4504-9bbc-6bf805deaf4c): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 607 | 2025.01.29 00:55:41.280149 [ 228259 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.025043 sec., 39.93131813281156 rows/sec., 638.90 B/sec. | ||
| 608 | 2025.01.29 00:55:41.280418 [ 228259 ] {45401d75-d1ec-4bd0-907d-b88ed50688a1} <Debug> TCPHandler: Processed in 0.02572861 sec. | ||
| 609 | 2025.01.29 00:55:43.284569 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 610 | 2025.01.29 00:55:43.284778 [ 228258 ] {1a657caf-3b92-4b6c-9a89-91401538c4de} <Debug> executeQuery: (from [::1]:45616) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 611 | 2025.01.29 00:55:43.285071 [ 228258 ] {1a657caf-3b92-4b6c-9a89-91401538c4de} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 612 | 2025.01.29 00:55:43.285123 [ 228258 ] {1a657caf-3b92-4b6c-9a89-91401538c4de} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 613 | 2025.01.29 00:55:43.285756 [ 228258 ] {1a657caf-3b92-4b6c-9a89-91401538c4de} <Debug> TCPHandler: Processed in 0.00137943 sec. | ||
| 614 | 2025.01.29 00:55:43.287401 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 615 | 2025.01.29 00:55:43.287569 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 616 | 2025.01.29 00:55:43.287645 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 617 | 2025.01.29 00:55:43.289342 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Trace> oximeter.timeseries_schema (46a17f50-0d84-4b97-88c9-04bbdcdca649): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 618 | 2025.01.29 00:55:43.289375 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 619 | 2025.01.29 00:55:43.289944 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 620 | 2025.01.29 00:55:43.290161 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Trace> oximeter.timeseries_schema (46a17f50-0d84-4b97-88c9-04bbdcdca649): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 621 | 2025.01.29 00:55:43.290367 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002848 sec., 351.12359550561797 rows/sec., 42.18 KiB/sec. | ||
| 622 | 2025.01.29 00:55:43.290421 [ 228259 ] {795119c1-cd74-44e5-991b-2fd467c841b6} <Debug> TCPHandler: Processed in 0.00315029 sec. | ||
| 623 | 2025.01.29 00:55:43.291395 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 624 | 2025.01.29 00:55:43.291561 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 625 | 2025.01.29 00:55:43.291634 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 626 | 2025.01.29 00:55:43.295224 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 627 | 2025.01.29 00:55:43.296514 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 628 | 2025.01.29 00:55:43.297044 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 629 | 2025.01.29 00:55:43.297268 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 630 | 2025.01.29 00:55:43.297500 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.005988 sec., 334.001336005344 rows/sec., 34.57 KiB/sec. | ||
| 631 | 2025.01.29 00:55:43.297563 [ 228258 ] {f286e7b6-b9b9-491c-89b3-217543959b64} <Debug> TCPHandler: Processed in 0.00634598 sec. | ||
| 632 | 2025.01.29 00:55:43.298897 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 633 | 2025.01.29 00:55:43.300187 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 634 | 2025.01.29 00:55:43.300263 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 635 | 2025.01.29 00:55:43.301254 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 636 | 2025.01.29 00:55:43.301290 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 637 | 2025.01.29 00:55:43.301674 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 638 | 2025.01.29 00:55:43.303302 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 639 | 2025.01.29 00:55:43.303541 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003418 sec., 292.5687536571094 rows/sec., 20.29 KiB/sec. | ||
| 640 | 2025.01.29 00:55:43.303621 [ 228259 ] {a2c6014d-40f7-470f-bb3a-721b298565a6} <Debug> TCPHandler: Processed in 0.00495487 sec. | ||
| 641 | 2025.01.29 00:55:43.948277 [ 227726 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 642 | 2025.01.29 00:55:43.948331 [ 227726 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 643 | 2025.01.29 00:55:44.007087 [ 227808 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1852 entries to flush up to offset 3576 | ||
| 644 | 2025.01.29 00:55:44.008516 [ 227808 ] {} <Trace> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 645 | 2025.01.29 00:55:44.008553 [ 227808 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 646 | 2025.01.29 00:55:44.009398 [ 227808 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 647 | 2025.01.29 00:55:44.009602 [ 227808 ] {} <Trace> system.asynchronous_metric_log (34169fa8-42a9-454c-8904-76a1935e5cee): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 648 | 2025.01.29 00:55:44.009780 [ 227808 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3576 | ||
| 649 | 2025.01.29 00:55:44.063640 [ 227805 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
| 650 | 2025.01.29 00:55:44.085089 [ 227805 ] {} <Trace> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 651 | 2025.01.29 00:55:44.085146 [ 227805 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 652 | 2025.01.29 00:55:44.091105 [ 227805 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 653 | 2025.01.29 00:55:44.091905 [ 227805 ] {} <Trace> system.metric_log (a3ae6ebc-6a08-408a-a805-fc79573b2ac3): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 654 | 2025.01.29 00:55:44.094215 [ 227805 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
| 655 | 2025.01.29 00:55:44.284652 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2025.01.29 00:55:44.284860 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 657 | 2025.01.29 00:55:44.284917 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 658 | 2025.01.29 00:55:44.285760 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 659 | 2025.01.29 00:55:44.285793 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 660 | 2025.01.29 00:55:44.286169 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 661 | 2025.01.29 00:55:44.286352 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 662 | 2025.01.29 00:55:44.286528 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.001717 sec., 1164.8223645894002 rows/sec., 120.58 KiB/sec. | ||
| 663 | 2025.01.29 00:55:44.286569 [ 228258 ] {e3639ac8-2393-4ad2-982a-241a02f0b2c9} <Debug> TCPHandler: Processed in 0.00207315 sec. | ||
| 664 | 2025.01.29 00:55:44.287176 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 665 | 2025.01.29 00:55:44.287304 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 666 | 2025.01.29 00:55:44.287370 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 667 | 2025.01.29 00:55:44.288127 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 668 | 2025.01.29 00:55:44.288154 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.84 GiB. | ||
| 669 | 2025.01.29 00:55:44.288544 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 670 | 2025.01.29 00:55:44.288748 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 671 | 2025.01.29 00:55:44.288938 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001668 sec., 599.5203836930456 rows/sec., 41.57 KiB/sec. | ||
| 672 | 2025.01.29 00:55:44.288978 [ 228259 ] {1faafa11-4c26-4c11-bc8d-137ca1766740} <Debug> TCPHandler: Processed in 0.00190752 sec. | ||
| 673 | 2025.01.29 00:55:45.000451 [ 227811 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 402.80 MiB, peak 410.72 MiB, free memory in arenas 34.05 MiB, will set to 414.83 MiB (RSS), difference: 12.03 MiB | ||
| 674 | 2025.01.29 00:55:45.456342 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2025.01.29 00:55:45.456632 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 676 | 2025.01.29 00:55:45.456716 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 677 | 2025.01.29 00:55:45.458390 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 678 | 2025.01.29 00:55:45.458638 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.92 GiB. | ||
| 679 | 2025.01.29 00:55:45.459165 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 680 | 2025.01.29 00:55:45.459418 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 681 | 2025.01.29 00:55:45.461104 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004598 sec., 434.97172683775557 rows/sec., 45.03 KiB/sec. | ||
| 682 | 2025.01.29 00:55:45.461183 [ 228258 ] {2ede7c53-af30-4fe9-9596-d0570cfc21b1} <Debug> TCPHandler: Processed in 0.00505015 sec. | ||
| 683 | 2025.01.29 00:55:45.465768 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 684 | 2025.01.29 00:55:45.466004 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 685 | 2025.01.29 00:55:45.466088 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 686 | 2025.01.29 00:55:45.471743 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 687 | 2025.01.29 00:55:45.471809 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.92 GiB. | ||
| 688 | 2025.01.29 00:55:45.472310 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 689 | 2025.01.29 00:55:45.472505 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 690 | 2025.01.29 00:55:45.474103 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.008167 sec., 122.44398187829067 rows/sec., 8.49 KiB/sec. | ||
| 691 | 2025.01.29 00:55:45.474177 [ 228259 ] {325e6026-2d47-40dd-b082-3c2d34cb4f44} <Debug> TCPHandler: Processed in 0.008719169 sec. | ||
| 692 | 2025.01.29 00:55:46.383660 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 693 | 2025.01.29 00:55:46.383907 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 694 | 2025.01.29 00:55:46.383976 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 695 | 2025.01.29 00:55:46.385089 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 696 | 2025.01.29 00:55:46.385123 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.37 GiB. | ||
| 697 | 2025.01.29 00:55:46.387057 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 698 | 2025.01.29 00:55:46.387326 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 699 | 2025.01.29 00:55:46.387581 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003732 sec., 535.9056806002144 rows/sec., 55.47 KiB/sec. | ||
| 700 | 2025.01.29 00:55:46.387659 [ 228258 ] {b0e2303b-2e3f-48d8-903e-4fc7ae2540dd} <Debug> TCPHandler: Processed in 0.00423811 sec. | ||
| 701 | 2025.01.29 00:55:46.389284 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 702 | 2025.01.29 00:55:46.389582 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 703 | 2025.01.29 00:55:46.389659 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 704 | 2025.01.29 00:55:46.394695 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 705 | 2025.01.29 00:55:46.394753 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.37 GiB. | ||
| 706 | 2025.01.29 00:55:46.395216 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 707 | 2025.01.29 00:55:46.395463 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 708 | 2025.01.29 00:55:46.395720 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.006199 sec., 161.3163413453783 rows/sec., 11.19 KiB/sec. | ||
| 709 | 2025.01.29 00:55:46.395795 [ 228259 ] {1234bd31-2833-491b-b00f-7fa853cb1c82} <Debug> TCPHandler: Processed in 0.00674722 sec. | ||
| 710 | 2025.01.29 00:55:47.284565 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 711 | 2025.01.29 00:55:47.284784 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 712 | 2025.01.29 00:55:47.284853 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 713 | 2025.01.29 00:55:47.285997 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 714 | 2025.01.29 00:55:47.286434 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 715 | 2025.01.29 00:55:47.286846 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 716 | 2025.01.29 00:55:47.287036 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 717 | 2025.01.29 00:55:47.287192 [ 227713 ] {} <Debug> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 718 | 2025.01.29 00:55:47.287228 [ 227713 ] {} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 719 | 2025.01.29 00:55:47.287243 [ 227713 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 720 | 2025.01.29 00:55:47.287261 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002548 sec., 784.9293563579278 rows/sec., 81.25 KiB/sec. | ||
| 721 | 2025.01.29 00:55:47.287320 [ 228258 ] {71892c5e-5ff1-4bc6-9517-668d6878adee} <Debug> TCPHandler: Processed in 0.002955311 sec. | ||
| 722 | 2025.01.29 00:55:47.287485 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 723 | 2025.01.29 00:55:47.287573 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 724 | 2025.01.29 00:55:47.287616 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
| 725 | 2025.01.29 00:55:47.287717 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
| 726 | 2025.01.29 00:55:47.287766 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
| 727 | 2025.01.29 00:55:47.287893 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
| 728 | 2025.01.29 00:55:47.287973 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
| 729 | 2025.01.29 00:55:47.288288 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 730 | 2025.01.29 00:55:47.288456 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 731 | 2025.01.29 00:55:47.288523 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 732 | 2025.01.29 00:55:47.288822 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.001433211 sec., 6977.339693876198 rows/sec., 749.52 KiB/sec. | ||
| 733 | 2025.01.29 00:55:47.289614 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 734 | 2025.01.29 00:55:47.290417 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 735 | 2025.01.29 00:55:47.290586 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 736 | 2025.01.29 00:55:47.290839 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 737 | 2025.01.29 00:55:47.290863 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 738 | 2025.01.29 00:55:47.290901 [ 227758 ] {3dc59a48-1821-4981-961f-275ae71cf07d::all_1_5_1} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 739 | 2025.01.29 00:55:47.291000 [ 227758 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.34 MiB. | ||
| 740 | 2025.01.29 00:55:47.291106 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 741 | 2025.01.29 00:55:47.291266 [ 227564 ] {} <Debug> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 742 | 2025.01.29 00:55:47.291296 [ 227564 ] {} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 743 | 2025.01.29 00:55:47.291309 [ 227564 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 744 | 2025.01.29 00:55:47.291335 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002928 sec., 341.53005464480873 rows/sec., 23.68 KiB/sec. | ||
| 745 | 2025.01.29 00:55:47.291403 [ 228259 ] {c524cef9-a1be-4a46-892a-a43fd6790f66} <Debug> TCPHandler: Processed in 0.00329583 sec. | ||
| 746 | 2025.01.29 00:55:47.291529 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 747 | 2025.01.29 00:55:47.291635 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 748 | 2025.01.29 00:55:47.291664 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
| 749 | 2025.01.29 00:55:47.291741 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
| 750 | 2025.01.29 00:55:47.291778 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
| 751 | 2025.01.29 00:55:47.291820 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
| 752 | 2025.01.29 00:55:47.291976 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
| 753 | 2025.01.29 00:55:47.296536 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.00509831 sec., 980.717139601162 rows/sec., 68.00 KiB/sec. | ||
| 754 | 2025.01.29 00:55:47.297624 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 755 | 2025.01.29 00:55:47.297968 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 756 | 2025.01.29 00:55:47.298033 [ 227762 ] {91d8eb76-c734-4027-b3b1-955292d10f22::all_1_5_1} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 757 | 2025.01.29 00:55:47.298136 [ 227762 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB. | ||
| 758 | 2025.01.29 00:55:48.297826 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 759 | 2025.01.29 00:55:48.298049 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 760 | 2025.01.29 00:55:48.298120 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 761 | 2025.01.29 00:55:48.299151 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 762 | 2025.01.29 00:55:48.299177 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 763 | 2025.01.29 00:55:48.299520 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 764 | 2025.01.29 00:55:48.299945 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 765 | 2025.01.29 00:55:48.300127 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002151 sec., 929.8000929800093 rows/sec., 96.25 KiB/sec. | ||
| 766 | 2025.01.29 00:55:48.300181 [ 228258 ] {dc3f9eaa-64d7-4ce7-8016-9cdf50a3d20d} <Debug> TCPHandler: Processed in 0.00258646 sec. | ||
| 767 | 2025.01.29 00:55:48.300814 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 768 | 2025.01.29 00:55:48.300955 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 769 | 2025.01.29 00:55:48.303054 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 770 | 2025.01.29 00:55:48.304260 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 771 | 2025.01.29 00:55:48.305540 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.85 GiB. | ||
| 772 | 2025.01.29 00:55:48.306072 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 773 | 2025.01.29 00:55:48.306289 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 774 | 2025.01.29 00:55:48.306576 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005656 sec., 176.80339462517682 rows/sec., 12.26 KiB/sec. | ||
| 775 | 2025.01.29 00:55:48.307879 [ 228259 ] {a00b8010-90d9-4014-a5f6-14c75bf86a16} <Debug> TCPHandler: Processed in 0.0071495 sec. | ||
| 776 | 2025.01.29 00:55:48.975553 [ 227804 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 118 entries to flush up to offset 118 | ||
| 777 | 2025.01.29 00:55:48.975631 [ 227804 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 778 | 2025.01.29 00:55:48.982207 [ 227804 ] {} <Debug> system.query_log (1fb73bf0-ec7f-4247-90fe-e6567fb1381c): Loading data parts | ||
| 779 | 2025.01.29 00:55:48.982489 [ 227804 ] {} <Debug> system.query_log (1fb73bf0-ec7f-4247-90fe-e6567fb1381c): There are no data parts | ||
| 780 | 2025.01.29 00:55:48.993266 [ 227804 ] {} <Trace> system.query_log (1fb73bf0-ec7f-4247-90fe-e6567fb1381c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 781 | 2025.01.29 00:55:48.993306 [ 227804 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.93 GiB. | ||
| 782 | 2025.01.29 00:55:48.996343 [ 227804 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 783 | 2025.01.29 00:55:48.996615 [ 227804 ] {} <Trace> system.query_log (1fb73bf0-ec7f-4247-90fe-e6567fb1381c): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 784 | 2025.01.29 00:55:48.998734 [ 227804 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 118 | ||
| 785 | 2025.01.29 00:55:49.001093 [ 227811 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 419.65 MiB, peak 419.65 MiB, free memory in arenas 39.52 MiB, will set to 415.63 MiB (RSS), difference: -4.01 MiB | ||
| 786 | 2025.01.29 00:55:49.318089 [ 228258 ] {} <Trace> TCP-Session: d64f41d7-1418-490b-bb30-af1084c36af6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 787 | 2025.01.29 00:55:49.318292 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Debug> executeQuery: (from [::1]:45616) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 788 | 2025.01.29 00:55:49.318366 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 789 | 2025.01.29 00:55:49.325450 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 790 | 2025.01.29 00:55:49.325500 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.93 GiB. | ||
| 791 | 2025.01.29 00:55:49.326826 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 792 | 2025.01.29 00:55:49.327037 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Trace> oximeter.fields_string (3dc59a48-1821-4981-961f-275ae71cf07d): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 793 | 2025.01.29 00:55:49.327279 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.009056 sec., 220.84805653710248 rows/sec., 22.86 KiB/sec. | ||
| 794 | 2025.01.29 00:55:49.327339 [ 228258 ] {11b15237-f933-4b2f-a17e-f4584d21e797} <Debug> TCPHandler: Processed in 0.00941776 sec. | ||
| 795 | 2025.01.29 00:55:49.371922 [ 228259 ] {} <Trace> TCP-Session: af7a1904-dde2-49b8-b0b9-9011187c62f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 796 | 2025.01.29 00:55:49.372155 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Debug> executeQuery: (from [::1]:45618) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 797 | 2025.01.29 00:55:49.372228 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 798 | 2025.01.29 00:55:49.375089 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 799 | 2025.01.29 00:55:49.375684 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.93 GiB. | ||
| 800 | 2025.01.29 00:55:49.376074 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 801 | 2025.01.29 00:55:49.376206 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Trace> oximeter.measurements_i64 (91d8eb76-c734-4027-b3b1-955292d10f22): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 802 | 2025.01.29 00:55:49.376411 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004327 sec., 231.107002542177 rows/sec., 16.02 KiB/sec. | ||
| 803 | 2025.01.29 00:55:49.376501 [ 228259 ] {47538f0f-ef74-4329-80c0-4f176d2075b8} <Debug> TCPHandler: Processed in 0.00475845 sec. | ||