1 | [ Dec 6 21:14:36 Enabled. ] | ||
2 | [ Dec 6 21:14:36 Rereading configuration. ] | ||
3 | [ Dec 6 21:14:39 Rereading configuration. ] | ||
4 | [ Dec 6 21:14:48 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
5 | + set -o errexit | ||
6 | + set -o pipefail | ||
7 | + . /lib/svc/share/smf_include.sh | ||
8 | ++ SMF_EXIT_OK=0 | ||
9 | ++ SMF_EXIT_NODAEMON=94 | ||
10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
15 | ++ SMF_EXIT_ERR_PERM=100 | ||
16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
19 | + LISTEN_PORT=8123 | ||
20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
21 | + DATASTORE=/data | ||
22 | + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
23 | + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
24 | [ Dec 6 21:14:49 Method "start" exited with status 0. ] | ||
25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
26 | Logging trace to /var/tmp/clickhouse-server.log | ||
27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
28 | 2024.12.06 21:14:49.804704 [ 1 ] {} <Information> Application: Will watch for the process with pid 23677 | ||
29 | 2024.12.06 21:14:49.805318 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
30 | 2024.12.06 21:14:50.063106 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23677 | ||
31 | 2024.12.06 21:14:50.063844 [ 1 ] {} <Information> Application: starting up | ||
32 | 2024.12.06 21:14:50.064577 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
33 | 2024.12.06 21:14:50.152180 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
34 | 2024.12.06 21:14:50.185636 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
35 | 2024.12.06 21:14:50.185711 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
36 | 2024.12.06 21:14:50.185728 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
37 | 2024.12.06 21:14:50.185803 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
38 | 2024.12.06 21:14:50.186203 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
39 | 2024.12.06 21:14:50.187877 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
42 | 2024.12.06 21:14:50.188660 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
43 | 2024.12.06 21:14:50.189535 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
44 | 2024.12.06 21:14:50.189558 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
45 | 2024.12.06 21:14:50.189573 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
46 | 2024.12.06 21:14:50.189763 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
47 | 2024.12.06 21:14:50.190689 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
48 | 2024.12.06 21:14:50.197061 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
49 | 2024.12.06 21:14:50.197944 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
50 | 2024.12.06 21:14:50.199393 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
51 | 2024.12.06 21:14:50.199464 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
52 | 2024.12.06 21:14:50.201129 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
55 | 2024.12.06 21:14:50.201633 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
56 | 2024.12.06 21:14:50.206183 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
57 | 2024.12.06 21:14:50.206929 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
58 | 2024.12.06 21:14:50.208653 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
59 | 2024.12.06 21:14:50.209099 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
60 | 2024.12.06 21:14:50.209531 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
61 | 2024.12.06 21:14:50.209918 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
62 | 2024.12.06 21:14:50.211392 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
63 | 2024.12.06 21:14:50.211420 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
64 | 2024.12.06 21:14:50.211496 [ 127 ] {} <Debug> DNSResolver: Updating DNS cache | ||
65 | 2024.12.06 21:14:50.211682 [ 127 ] {} <Debug> DNSResolver: Updated DNS cache | ||
66 | 2024.12.06 21:14:50.227370 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
67 | 2024.12.06 21:14:50.227398 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000154943 sec | ||
68 | 2024.12.06 21:14:50.227443 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
69 | 2024.12.06 21:14:50.227458 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
70 | 2024.12.06 21:14:50.228645 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
71 | 2024.12.06 21:14:50.229703 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
72 | 2024.12.06 21:14:50.241573 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
73 | 2024.12.06 21:14:50.241622 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
74 | 2024.12.06 21:14:50.241645 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
75 | 2024.12.06 21:14:50.241658 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
76 | 2024.12.06 21:14:50.241689 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
77 | 2024.12.06 21:14:50.241710 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
78 | 2024.12.06 21:14:50.244410 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
79 | 2024.12.06 21:14:50.244461 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
80 | 2024.12.06 21:14:50.244484 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
81 | 2024.12.06 21:14:50.244673 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
82 | 2024.12.06 21:14:50.244692 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
83 | 2024.12.06 21:14:50.244732 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
84 | 2024.12.06 21:14:50.244753 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
85 | 2024.12.06 21:14:50.244765 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
86 | 2024.12.06 21:14:50.244795 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
87 | 2024.12.06 21:14:50.244812 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
88 | 2024.12.06 21:14:50.272146 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
89 | 2024.12.06 21:14:50.277684 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
90 | 2024.12.06 21:14:50.277718 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.3041e-05 sec | ||
91 | 2024.12.06 21:14:50.277732 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
92 | 2024.12.06 21:14:50.277743 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
93 | 2024.12.06 21:14:50.277768 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
94 | 2024.12.06 21:14:50.277987 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
95 | 2024.12.06 21:14:50.278032 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
96 | 2024.12.06 21:14:50.278046 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
97 | 2024.12.06 21:14:50.278057 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
98 | 2024.12.06 21:14:50.278069 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
99 | 2024.12.06 21:14:50.287966 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
100 | 2024.12.06 21:14:50.288200 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.35 MiB | ||
101 | 2024.12.06 21:14:50.289235 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.8951e-05 sec. | ||
102 | 2024.12.06 21:14:50.290309 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
103 | 2024.12.06 21:14:50.290407 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
104 | 2024.12.06 21:14:50.290425 [ 1 ] {} <Information> Application: Ready for connections. | ||
105 | 2024.12.06 21:14:50.342430 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36697 | ||
106 | 2024.12.06 21:14:50.342942 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
107 | 2024.12.06 21:14:50.343001 [ 3 ] {} <Debug> TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Authenticating user 'default' from [fd00:1122:3344:101::b]:36697 | ||
108 | 2024.12.06 21:14:50.343034 [ 3 ] {} <Debug> TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
109 | 2024.12.06 21:14:50.343056 [ 3 ] {} <Debug> TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
110 | 2024.12.06 21:14:50.343144 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
111 | 2024.12.06 21:14:50.343171 [ 3 ] {} <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 | ||
112 | 2024.12.06 21:14:50.343195 [ 3 ] {} <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 | ||
113 | 2024.12.06 21:14:50.343609 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:40500 | ||
114 | 2024.12.06 21:14:50.343738 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
115 | 2024.12.06 21:14:50.343766 [ 4 ] {} <Debug> TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Authenticating user 'default' from [fd00:1122:3344:101::b]:40500 | ||
116 | 2024.12.06 21:14:50.343790 [ 4 ] {} <Debug> TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
117 | 2024.12.06 21:14:50.343817 [ 4 ] {} <Debug> TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
118 | 2024.12.06 21:14:50.344425 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:63950 | ||
119 | 2024.12.06 21:14:50.344431 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55857 | ||
120 | 2024.12.06 21:14:50.344511 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:46412 | ||
121 | 2024.12.06 21:14:50.344544 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
122 | 2024.12.06 21:14:50.344752 [ 5 ] {} <Debug> TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Authenticating user 'default' from [fd00:1122:3344:101::b]:63950 | ||
123 | 2024.12.06 21:14:50.344809 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:43168 | ||
124 | 2024.12.06 21:14:50.344892 [ 5 ] {} <Debug> TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
125 | 2024.12.06 21:14:50.344899 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
126 | 2024.12.06 21:14:50.344928 [ 5 ] {} <Debug> TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
127 | 2024.12.06 21:14:50.344877 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
128 | 2024.12.06 21:14:50.345078 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
129 | 2024.12.06 21:14:50.345111 [ 254 ] {} <Debug> TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Authenticating user 'default' from [fd00:1122:3344:101::b]:46412 | ||
130 | 2024.12.06 21:14:50.345153 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:57349 | ||
131 | 2024.12.06 21:14:50.345183 [ 253 ] {} <Debug> TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Authenticating user 'default' from [fd00:1122:3344:101::b]:55857 | ||
132 | 2024.12.06 21:14:50.345208 [ 255 ] {} <Debug> TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Authenticating user 'default' from [fd00:1122:3344:101::b]:43168 | ||
133 | 2024.12.06 21:14:50.345236 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:40306 | ||
134 | 2024.12.06 21:14:50.345324 [ 255 ] {} <Debug> TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
135 | 2024.12.06 21:14:50.345374 [ 254 ] {} <Debug> TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
136 | 2024.12.06 21:14:50.345368 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
137 | 2024.12.06 21:14:50.345458 [ 253 ] {} <Debug> TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
138 | 2024.12.06 21:14:50.345389 [ 255 ] {} <Debug> TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
139 | 2024.12.06 21:14:50.345530 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
140 | 2024.12.06 21:14:50.345559 [ 253 ] {} <Debug> TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.12.06 21:14:50.345577 [ 256 ] {} <Debug> TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Authenticating user 'default' from [fd00:1122:3344:101::b]:57349 | ||
142 | 2024.12.06 21:14:50.345684 [ 254 ] {} <Debug> TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
143 | 2024.12.06 21:14:50.345735 [ 256 ] {} <Debug> TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
144 | 2024.12.06 21:14:50.345760 [ 257 ] {} <Debug> TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Authenticating user 'default' from [fd00:1122:3344:101::b]:40306 | ||
145 | 2024.12.06 21:14:50.345853 [ 257 ] {} <Debug> TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.12.06 21:14:50.345884 [ 256 ] {} <Debug> TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2024.12.06 21:14:50.345911 [ 257 ] {} <Debug> TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
148 | 2024.12.06 21:14:50.673211 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:53772 | ||
149 | 2024.12.06 21:14:50.673365 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
150 | 2024.12.06 21:14:50.673415 [ 258 ] {} <Debug> TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Authenticating user 'default' from [fd00:1122:3344:101::e]:53772 | ||
151 | 2024.12.06 21:14:50.673438 [ 258 ] {} <Debug> TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
152 | 2024.12.06 21:14:50.673453 [ 258 ] {} <Debug> TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
153 | 2024.12.06 21:14:50.673525 [ 258 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
154 | 2024.12.06 21:14:50.673552 [ 258 ] {} <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 | ||
155 | 2024.12.06 21:14:50.673586 [ 258 ] {} <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 | ||
156 | 2024.12.06 21:14:50.674042 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:41270 | ||
157 | 2024.12.06 21:14:50.674106 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:63624 | ||
158 | 2024.12.06 21:14:50.674312 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:43133 | ||
159 | 2024.12.06 21:14:50.674340 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
160 | 2024.12.06 21:14:50.674437 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
161 | 2024.12.06 21:14:50.674475 [ 259 ] {} <Debug> TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Authenticating user 'default' from [fd00:1122:3344:101::e]:41270 | ||
162 | 2024.12.06 21:14:50.674617 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
163 | 2024.12.06 21:14:50.674616 [ 260 ] {} <Debug> TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Authenticating user 'default' from [fd00:1122:3344:101::e]:63624 | ||
164 | 2024.12.06 21:14:50.674636 [ 259 ] {} <Debug> TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
165 | 2024.12.06 21:14:50.674656 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:61757 | ||
166 | 2024.12.06 21:14:50.674682 [ 261 ] {} <Debug> TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Authenticating user 'default' from [fd00:1122:3344:101::e]:43133 | ||
167 | 2024.12.06 21:14:50.674633 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:65333 | ||
168 | 2024.12.06 21:14:50.674726 [ 260 ] {} <Debug> TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
169 | 2024.12.06 21:14:50.674727 [ 259 ] {} <Debug> TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
170 | 2024.12.06 21:14:50.674769 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:61989 | ||
171 | 2024.12.06 21:14:50.674806 [ 261 ] {} <Debug> TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
172 | 2024.12.06 21:14:50.674837 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:59368 | ||
173 | 2024.12.06 21:14:50.674842 [ 260 ] {} <Debug> TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
174 | 2024.12.06 21:14:50.675264 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
175 | 2024.12.06 21:14:50.675274 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
176 | 2024.12.06 21:14:50.675336 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
177 | 2024.12.06 21:14:50.675145 [ 261 ] {} <Debug> TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
178 | 2024.12.06 21:14:50.675387 [ 265 ] {} <Debug> TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Authenticating user 'default' from [fd00:1122:3344:101::e]:59368 | ||
179 | 2024.12.06 21:14:50.675430 [ 264 ] {} <Debug> TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Authenticating user 'default' from [fd00:1122:3344:101::e]:61989 | ||
180 | 2024.12.06 21:14:50.675429 [ 263 ] {} <Debug> TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Authenticating user 'default' from [fd00:1122:3344:101::e]:65333 | ||
181 | 2024.12.06 21:14:50.675536 [ 265 ] {} <Debug> TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
182 | 2024.12.06 21:14:50.675647 [ 264 ] {} <Debug> TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
183 | 2024.12.06 21:14:50.675684 [ 265 ] {} <Debug> TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
184 | 2024.12.06 21:14:50.675742 [ 264 ] {} <Debug> TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
185 | 2024.12.06 21:14:50.675790 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
186 | 2024.12.06 21:14:50.675810 [ 263 ] {} <Debug> TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
187 | 2024.12.06 21:14:50.675884 [ 263 ] {} <Debug> TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
188 | 2024.12.06 21:14:50.675889 [ 262 ] {} <Debug> TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Authenticating user 'default' from [fd00:1122:3344:101::e]:61757 | ||
189 | 2024.12.06 21:14:50.676000 [ 262 ] {} <Debug> TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
190 | 2024.12.06 21:14:50.676042 [ 262 ] {} <Debug> TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
191 | 2024.12.06 21:14:50.882311 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:58439 | ||
192 | 2024.12.06 21:14:50.882487 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
193 | 2024.12.06 21:14:50.882518 [ 266 ] {} <Debug> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Authenticating user 'default' from [fd00:1122:3344:101::d]:58439 | ||
194 | 2024.12.06 21:14:50.882563 [ 266 ] {} <Debug> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
195 | 2024.12.06 21:14:50.882579 [ 266 ] {} <Debug> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
196 | 2024.12.06 21:14:50.882653 [ 266 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
197 | 2024.12.06 21:14:50.882692 [ 266 ] {} <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 | ||
198 | 2024.12.06 21:14:50.882710 [ 266 ] {} <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 | ||
199 | 2024.12.06 21:14:50.883181 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51322 | ||
200 | 2024.12.06 21:14:50.883257 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:44123 | ||
201 | 2024.12.06 21:14:50.883693 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
202 | 2024.12.06 21:14:50.883683 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:33117 | ||
203 | 2024.12.06 21:14:50.883709 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:45437 | ||
204 | 2024.12.06 21:14:50.883739 [ 267 ] {} <Debug> TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Authenticating user 'default' from [fd00:1122:3344:101::d]:51322 | ||
205 | 2024.12.06 21:14:50.883706 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
206 | 2024.12.06 21:14:50.884518 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:59419 | ||
207 | 2024.12.06 21:14:50.884595 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:53171 | ||
208 | 2024.12.06 21:14:50.884635 [ 268 ] {} <Debug> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Authenticating user 'default' from [fd00:1122:3344:101::d]:44123 | ||
209 | 2024.12.06 21:14:50.884632 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
210 | 2024.12.06 21:14:50.885592 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
211 | 2024.12.06 21:14:50.885588 [ 270 ] {} <Debug> TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Authenticating user 'default' from [fd00:1122:3344:101::d]:33117 | ||
212 | 2024.12.06 21:14:50.885566 [ 268 ] {} <Debug> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.12.06 21:14:50.885849 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
214 | 2024.12.06 21:14:50.885866 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
215 | 2024.12.06 21:14:50.885909 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:61749 | ||
216 | 2024.12.06 21:14:50.885927 [ 268 ] {} <Debug> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
217 | 2024.12.06 21:14:50.885998 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
218 | 2024.12.06 21:14:50.886108 [ 269 ] {} <Debug> TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Authenticating user 'default' from [fd00:1122:3344:101::d]:45437 | ||
219 | 2024.12.06 21:14:50.886218 [ 272 ] {} <Debug> TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Authenticating user 'default' from [fd00:1122:3344:101::d]:53171 | ||
220 | 2024.12.06 21:14:50.886316 [ 267 ] {} <Debug> TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
221 | 2024.12.06 21:14:50.886349 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:43682 | ||
222 | 2024.12.06 21:14:50.886355 [ 270 ] {} <Debug> TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
223 | 2024.12.06 21:14:50.886322 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
224 | 2024.12.06 21:14:50.886401 [ 272 ] {} <Debug> TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
225 | 2024.12.06 21:14:50.886434 [ 271 ] {} <Debug> TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59419 | ||
226 | 2024.12.06 21:14:50.886455 [ 269 ] {} <Debug> TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
227 | 2024.12.06 21:14:50.886522 [ 272 ] {} <Debug> TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.12.06 21:14:50.886531 [ 267 ] {} <Debug> TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
229 | 2024.12.06 21:14:50.886667 [ 273 ] {} <Debug> TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Authenticating user 'default' from [fd00:1122:3344:101::d]:61749 | ||
230 | 2024.12.06 21:14:50.886688 [ 269 ] {} <Debug> TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
231 | 2024.12.06 21:14:50.886599 [ 271 ] {} <Debug> TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
232 | 2024.12.06 21:14:50.887320 [ 273 ] {} <Debug> TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
233 | 2024.12.06 21:14:50.888584 [ 271 ] {} <Debug> TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
234 | 2024.12.06 21:14:50.888595 [ 273 ] {} <Debug> TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
235 | 2024.12.06 21:14:50.888667 [ 270 ] {} <Debug> TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
236 | 2024.12.06 21:14:50.888678 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
237 | 2024.12.06 21:14:50.888759 [ 274 ] {} <Debug> TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Authenticating user 'default' from [fd00:1122:3344:101::d]:43682 | ||
238 | 2024.12.06 21:14:50.888803 [ 274 ] {} <Debug> TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
239 | 2024.12.06 21:14:50.888900 [ 274 ] {} <Debug> TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
240 | 2024.12.06 21:14:50.890544 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
241 | 2024.12.06 21:14:50.947807 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:58439) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
242 | |||
243 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
244 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
245 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
246 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
247 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
248 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
249 | 6. 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<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
250 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
251 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
252 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
253 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
254 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
255 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
256 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
257 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
258 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
259 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
260 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
261 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
262 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
263 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
264 | |||
265 | 2024.12.06 21:14:50.949133 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
266 | |||
267 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
268 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
269 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
270 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
271 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
272 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
273 | 6. 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<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
274 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
275 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
276 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
277 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
278 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
279 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
280 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
281 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
282 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
283 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
284 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
285 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
286 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
287 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
288 | |||
289 | 2024.12.06 21:14:50.949243 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} <Debug> TCPHandler: Processed in 0.06584104 sec. | ||
290 | 2024.12.06 21:14:50.949913 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
291 | 2024.12.06 21:14:50.950079 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
292 | 2024.12.06 21:14:50.950367 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:58439) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
293 | |||
294 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
295 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
296 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
297 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
298 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
299 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
300 | 6. 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<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
301 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
302 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
303 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
304 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
305 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
306 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
307 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
308 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
309 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
310 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
311 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
312 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
313 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
314 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
315 | |||
316 | 2024.12.06 21:14:50.950483 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
317 | |||
318 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
319 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
320 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
321 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
322 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
323 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
324 | 6. 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<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
325 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
326 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
327 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
328 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
329 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
330 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
331 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
332 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
333 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
334 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
335 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
336 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
337 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
338 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
339 | |||
340 | 2024.12.06 21:14:50.950563 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} <Debug> TCPHandler: Processed in 0.000769732 sec. | ||
341 | 2024.12.06 21:14:50.950792 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
342 | 2024.12.06 21:14:50.952026 [ 266 ] {36a4eb83-42b6-4bd8-a98d-4cc15cfaa5a6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
343 | 2024.12.06 21:14:50.952671 [ 266 ] {36a4eb83-42b6-4bd8-a98d-4cc15cfaa5a6} <Debug> TCPHandler: Processed in 0.001927672 sec. | ||
344 | 2024.12.06 21:14:50.952897 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
345 | 2024.12.06 21:14:50.953026 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
346 | 2024.12.06 21:14:50.953153 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
347 | 2024.12.06 21:14:50.963585 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
348 | 2024.12.06 21:14:50.963644 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.6702e-05 sec | ||
349 | 2024.12.06 21:14:50.963660 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Trace> ReferentialDeps: No tables | ||
350 | 2024.12.06 21:14:50.963673 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Trace> LoadingDeps: No tables | ||
351 | 2024.12.06 21:14:50.963697 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
352 | 2024.12.06 21:14:50.963763 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} <Debug> TCPHandler: Processed in 0.01095133 sec. | ||
353 | 2024.12.06 21:14:50.963965 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
354 | 2024.12.06 21:14:50.964163 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The version table contains metadata about the `oximeter` database */ | ||
355 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
356 | 2024.12.06 21:14:50.964236 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
357 | 2024.12.06 21:14:50.972910 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
358 | 2024.12.06 21:14:50.978985 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Debug> oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Loading data parts | ||
359 | 2024.12.06 21:14:50.979669 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Debug> oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): There are no data parts | ||
360 | 2024.12.06 21:14:50.986106 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} <Debug> TCPHandler: Processed in 0.022208864 sec. | ||
361 | 2024.12.06 21:14:50.986486 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
362 | 2024.12.06 21:14:50.986816 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) /* The measurement tables contain all individual samples from each timeseries. | ||
363 | * | ||
364 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
365 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
366 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
367 | * by all samples from the same timeseries. | ||
368 | * | ||
369 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
370 | * and then uses that to index quickly into the measurements tables. | ||
371 | */ | ||
372 | 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) | ||
373 | 2024.12.06 21:14:50.986914 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
374 | 2024.12.06 21:14:50.999814 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} <Debug> oximeter.measurements_bool (5eadeaa4-10a4-4060-8869-584671cc1c31): Loading data parts | ||
375 | 2024.12.06 21:14:51.000252 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 121.47 MiB, peak 121.47 MiB, free memory in arenas 0.00 B, will set to 133.48 MiB (RSS), difference: 12.02 MiB | ||
376 | 2024.12.06 21:14:51.000353 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} <Debug> oximeter.measurements_bool (5eadeaa4-10a4-4060-8869-584671cc1c31): There are no data parts | ||
377 | 2024.12.06 21:14:51.002498 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} <Debug> TCPHandler: Processed in 0.016163255 sec. | ||
378 | 2024.12.06 21:14:51.002777 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
379 | 2024.12.06 21:14:51.003026 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
380 | 2024.12.06 21:14:51.003092 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
381 | 2024.12.06 21:14:51.006628 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} <Debug> oximeter.measurements_i8 (f8b21880-a024-4894-877e-792d7f6338cf): Loading data parts | ||
382 | 2024.12.06 21:14:51.006895 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} <Debug> oximeter.measurements_i8 (f8b21880-a024-4894-877e-792d7f6338cf): There are no data parts | ||
383 | 2024.12.06 21:14:51.009318 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} <Debug> TCPHandler: Processed in 0.006629929 sec. | ||
384 | 2024.12.06 21:14:51.009525 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
385 | 2024.12.06 21:14:51.009735 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
386 | 2024.12.06 21:14:51.009808 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
387 | 2024.12.06 21:14:51.013405 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} <Debug> oximeter.measurements_u8 (da0f2a9f-852c-4ab0-b837-e1e5a3851f18): Loading data parts | ||
388 | 2024.12.06 21:14:51.013635 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} <Debug> oximeter.measurements_u8 (da0f2a9f-852c-4ab0-b837-e1e5a3851f18): There are no data parts | ||
389 | 2024.12.06 21:14:51.016394 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} <Debug> TCPHandler: Processed in 0.006928133 sec. | ||
390 | 2024.12.06 21:14:51.016597 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
391 | 2024.12.06 21:14:51.016812 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
392 | 2024.12.06 21:14:51.016884 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
393 | 2024.12.06 21:14:51.020203 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} <Debug> oximeter.measurements_i16 (3611ba76-02bc-4a55-aa33-6237b44c3c0c): Loading data parts | ||
394 | 2024.12.06 21:14:51.020400 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} <Debug> oximeter.measurements_i16 (3611ba76-02bc-4a55-aa33-6237b44c3c0c): There are no data parts | ||
395 | 2024.12.06 21:14:51.022901 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} <Debug> TCPHandler: Processed in 0.006355625 sec. | ||
396 | 2024.12.06 21:14:51.023117 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
397 | 2024.12.06 21:14:51.023310 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
398 | 2024.12.06 21:14:51.023377 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
399 | 2024.12.06 21:14:51.027054 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} <Debug> oximeter.measurements_u16 (7f31df56-121b-4641-93bc-5d98b473d8a9): Loading data parts | ||
400 | 2024.12.06 21:14:51.027375 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} <Debug> oximeter.measurements_u16 (7f31df56-121b-4641-93bc-5d98b473d8a9): There are no data parts | ||
401 | 2024.12.06 21:14:51.029653 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} <Debug> TCPHandler: Processed in 0.006589179 sec. | ||
402 | 2024.12.06 21:14:51.029861 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
403 | 2024.12.06 21:14:51.030388 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
404 | 2024.12.06 21:14:51.030450 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
405 | 2024.12.06 21:14:51.033754 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} <Debug> oximeter.measurements_i32 (75e487b5-fec3-45d6-803e-32f627b88b33): Loading data parts | ||
406 | 2024.12.06 21:14:51.033960 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} <Debug> oximeter.measurements_i32 (75e487b5-fec3-45d6-803e-32f627b88b33): There are no data parts | ||
407 | 2024.12.06 21:14:51.036344 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} <Debug> TCPHandler: Processed in 0.006549117 sec. | ||
408 | 2024.12.06 21:14:51.036567 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
409 | 2024.12.06 21:14:51.036803 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
410 | 2024.12.06 21:14:51.036886 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
411 | 2024.12.06 21:14:51.040563 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} <Debug> oximeter.measurements_u32 (a5d5e565-43c8-4135-be55-b40e6f4b4c1e): Loading data parts | ||
412 | 2024.12.06 21:14:51.040789 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} <Debug> oximeter.measurements_u32 (a5d5e565-43c8-4135-be55-b40e6f4b4c1e): There are no data parts | ||
413 | 2024.12.06 21:14:51.043212 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} <Debug> TCPHandler: Processed in 0.00670791 sec. | ||
414 | 2024.12.06 21:14:51.043426 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
415 | 2024.12.06 21:14:51.043650 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
416 | 2024.12.06 21:14:51.043714 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
417 | 2024.12.06 21:14:51.049354 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} <Debug> oximeter.measurements_i64 (ad0cb5b4-815c-43d9-9981-2803ac396f43): Loading data parts | ||
418 | 2024.12.06 21:14:51.049556 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} <Debug> oximeter.measurements_i64 (ad0cb5b4-815c-43d9-9981-2803ac396f43): There are no data parts | ||
419 | 2024.12.06 21:14:51.053900 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} <Debug> TCPHandler: Processed in 0.010538483 sec. | ||
420 | 2024.12.06 21:14:51.054118 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
421 | 2024.12.06 21:14:51.054317 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
422 | 2024.12.06 21:14:51.054383 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
423 | 2024.12.06 21:14:51.056343 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} <Debug> oximeter.measurements_u64 (52d0dc58-fe48-49e5-a79b-29e4382b7021): Loading data parts | ||
424 | 2024.12.06 21:14:51.056560 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} <Debug> oximeter.measurements_u64 (52d0dc58-fe48-49e5-a79b-29e4382b7021): There are no data parts | ||
425 | 2024.12.06 21:14:51.060916 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} <Debug> TCPHandler: Processed in 0.006859112 sec. | ||
426 | 2024.12.06 21:14:51.061126 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
427 | 2024.12.06 21:14:51.061403 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
428 | 2024.12.06 21:14:51.061481 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
429 | 2024.12.06 21:14:51.068425 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} <Debug> oximeter.measurements_f32 (8635d9cc-99e1-40e4-9d9a-731a40a72e29): Loading data parts | ||
430 | 2024.12.06 21:14:51.068620 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} <Debug> oximeter.measurements_f32 (8635d9cc-99e1-40e4-9d9a-731a40a72e29): There are no data parts | ||
431 | 2024.12.06 21:14:51.071159 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} <Debug> TCPHandler: Processed in 0.010096255 sec. | ||
432 | 2024.12.06 21:14:51.071390 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
433 | 2024.12.06 21:14:51.071582 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
434 | 2024.12.06 21:14:51.071648 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
435 | 2024.12.06 21:14:51.075324 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} <Debug> oximeter.measurements_f64 (d71c17d4-58f9-4b4c-a503-e16c262b229b): Loading data parts | ||
436 | 2024.12.06 21:14:51.075532 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} <Debug> oximeter.measurements_f64 (d71c17d4-58f9-4b4c-a503-e16c262b229b): There are no data parts | ||
437 | 2024.12.06 21:14:51.078186 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} <Debug> TCPHandler: Processed in 0.006853622 sec. | ||
438 | 2024.12.06 21:14:51.078381 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
439 | 2024.12.06 21:14:51.078597 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
440 | 2024.12.06 21:14:51.078661 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
441 | 2024.12.06 21:14:51.082178 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} <Debug> oximeter.measurements_string (1cbceb75-1ab9-4002-a527-473200e03196): Loading data parts | ||
442 | 2024.12.06 21:14:51.082344 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} <Debug> oximeter.measurements_string (1cbceb75-1ab9-4002-a527-473200e03196): There are no data parts | ||
443 | 2024.12.06 21:14:51.084947 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} <Debug> TCPHandler: Processed in 0.006619099 sec. | ||
444 | 2024.12.06 21:14:51.085168 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
445 | 2024.12.06 21:14:51.085395 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
446 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
447 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
448 | * a string isn't palatable for a few reasons. | ||
449 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
450 | * details. | ||
451 | */ | ||
452 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
453 | 2024.12.06 21:14:51.085478 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
454 | 2024.12.06 21:14:51.091028 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} <Debug> oximeter.measurements_bytes (f6d8b107-5217-48eb-8757-94b1b80e8536): Loading data parts | ||
455 | 2024.12.06 21:14:51.091305 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} <Debug> oximeter.measurements_bytes (f6d8b107-5217-48eb-8757-94b1b80e8536): There are no data parts | ||
456 | 2024.12.06 21:14:51.095596 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} <Debug> TCPHandler: Processed in 0.010494162 sec. | ||
457 | 2024.12.06 21:14:51.095812 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
458 | 2024.12.06 21:14:51.096110 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
459 | 2024.12.06 21:14:51.096201 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
460 | 2024.12.06 21:14:51.098235 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} <Debug> oximeter.measurements_cumulativei64 (8c245486-e834-4604-807b-8d91f2f7257d): Loading data parts | ||
461 | 2024.12.06 21:14:51.098417 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} <Debug> oximeter.measurements_cumulativei64 (8c245486-e834-4604-807b-8d91f2f7257d): There are no data parts | ||
462 | 2024.12.06 21:14:51.102433 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} <Debug> TCPHandler: Processed in 0.006686139 sec. | ||
463 | 2024.12.06 21:14:51.102661 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
464 | 2024.12.06 21:14:51.102909 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
465 | 2024.12.06 21:14:51.102997 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
466 | 2024.12.06 21:14:51.105060 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} <Debug> oximeter.measurements_cumulativeu64 (d2f9fa43-3117-441f-8917-87b0b2b04d9e): Loading data parts | ||
467 | 2024.12.06 21:14:51.105254 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} <Debug> oximeter.measurements_cumulativeu64 (d2f9fa43-3117-441f-8917-87b0b2b04d9e): There are no data parts | ||
468 | 2024.12.06 21:14:51.109269 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} <Debug> TCPHandler: Processed in 0.006672539 sec. | ||
469 | 2024.12.06 21:14:51.109477 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
470 | 2024.12.06 21:14:51.109700 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
471 | 2024.12.06 21:14:51.109764 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
472 | 2024.12.06 21:14:51.111888 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} <Debug> oximeter.measurements_cumulativef32 (e1a7b06f-795b-4796-8610-11530e9b7f73): Loading data parts | ||
473 | 2024.12.06 21:14:51.112072 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} <Debug> oximeter.measurements_cumulativef32 (e1a7b06f-795b-4796-8610-11530e9b7f73): There are no data parts | ||
474 | 2024.12.06 21:14:51.116139 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} <Debug> TCPHandler: Processed in 0.00671265 sec. | ||
475 | 2024.12.06 21:14:51.116366 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
476 | 2024.12.06 21:14:51.116569 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
477 | 2024.12.06 21:14:51.116639 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
478 | 2024.12.06 21:14:51.118704 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} <Debug> oximeter.measurements_cumulativef64 (9b5f01fa-f4e7-4d65-834c-5ee704f74654): Loading data parts | ||
479 | 2024.12.06 21:14:51.118869 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} <Debug> oximeter.measurements_cumulativef64 (9b5f01fa-f4e7-4d65-834c-5ee704f74654): There are no data parts | ||
480 | 2024.12.06 21:14:51.123048 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} <Debug> TCPHandler: Processed in 0.00673656 sec. | ||
481 | 2024.12.06 21:14:51.123287 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
482 | 2024.12.06 21:14:51.123715 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
483 | * NOTE: Array types cannot be Nullable, see | ||
484 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
485 | * for more details. | ||
486 | * | ||
487 | * This means we need to use empty arrays to indicate a missing value. This | ||
488 | * is unfortunate, and at this point relies on the fact that an | ||
489 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
490 | * to figure out another way to represent missing samples here. | ||
491 | */ | ||
492 | 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) | ||
493 | 2024.12.06 21:14:51.123843 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
494 | 2024.12.06 21:14:51.129189 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} <Debug> oximeter.measurements_histogrami8 (10e72da4-b107-420a-b315-a680399cf817): Loading data parts | ||
495 | 2024.12.06 21:14:51.129399 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} <Debug> oximeter.measurements_histogrami8 (10e72da4-b107-420a-b315-a680399cf817): There are no data parts | ||
496 | 2024.12.06 21:14:51.135565 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} <Debug> TCPHandler: Processed in 0.012331563 sec. | ||
497 | 2024.12.06 21:14:51.135804 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
498 | 2024.12.06 21:14:51.136132 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
499 | 2024.12.06 21:14:51.136231 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
500 | 2024.12.06 21:14:51.142375 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} <Debug> oximeter.measurements_histogramu8 (c050f00e-a651-45fa-84c5-1ee6165872d4): Loading data parts | ||
501 | 2024.12.06 21:14:51.142584 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} <Debug> oximeter.measurements_histogramu8 (c050f00e-a651-45fa-84c5-1ee6165872d4): There are no data parts | ||
502 | 2024.12.06 21:14:51.148989 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} <Debug> TCPHandler: Processed in 0.013255807 sec. | ||
503 | 2024.12.06 21:14:51.149204 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
504 | 2024.12.06 21:14:51.149619 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
505 | 2024.12.06 21:14:51.149719 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
506 | 2024.12.06 21:14:51.156267 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} <Debug> oximeter.measurements_histogrami16 (f726a387-9580-44b2-8f3d-037db6d0e642): Loading data parts | ||
507 | 2024.12.06 21:14:51.156473 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} <Debug> oximeter.measurements_histogrami16 (f726a387-9580-44b2-8f3d-037db6d0e642): There are no data parts | ||
508 | 2024.12.06 21:14:51.162421 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} <Debug> TCPHandler: Processed in 0.013283058 sec. | ||
509 | 2024.12.06 21:14:51.162642 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
510 | 2024.12.06 21:14:51.162965 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
511 | 2024.12.06 21:14:51.163061 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
512 | 2024.12.06 21:14:51.168587 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} <Debug> oximeter.measurements_histogramu16 (527be356-2aec-44c4-b942-056c29c0a48b): Loading data parts | ||
513 | 2024.12.06 21:14:51.168818 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} <Debug> oximeter.measurements_histogramu16 (527be356-2aec-44c4-b942-056c29c0a48b): There are no data parts | ||
514 | 2024.12.06 21:14:51.171333 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} <Debug> TCPHandler: Processed in 0.008757793 sec. | ||
515 | 2024.12.06 21:14:51.171547 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
516 | 2024.12.06 21:14:51.171901 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
517 | 2024.12.06 21:14:51.171993 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
518 | 2024.12.06 21:14:51.177043 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} <Debug> oximeter.measurements_histogrami32 (e6a57afe-64f4-4362-8539-824725f392cf): Loading data parts | ||
519 | 2024.12.06 21:14:51.177220 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} <Debug> oximeter.measurements_histogrami32 (e6a57afe-64f4-4362-8539-824725f392cf): There are no data parts | ||
520 | 2024.12.06 21:14:51.181500 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} <Debug> TCPHandler: Processed in 0.010018714 sec. | ||
521 | 2024.12.06 21:14:51.181699 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
522 | 2024.12.06 21:14:51.181968 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
523 | 2024.12.06 21:14:51.182053 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
524 | 2024.12.06 21:14:51.184436 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} <Debug> oximeter.measurements_histogramu32 (b5124c25-a425-4cdf-bebe-933d996d9592): Loading data parts | ||
525 | 2024.12.06 21:14:51.184650 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} <Debug> oximeter.measurements_histogramu32 (b5124c25-a425-4cdf-bebe-933d996d9592): There are no data parts | ||
526 | 2024.12.06 21:14:51.188908 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} <Debug> TCPHandler: Processed in 0.007262949 sec. | ||
527 | 2024.12.06 21:14:51.189105 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
528 | 2024.12.06 21:14:51.189396 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
529 | 2024.12.06 21:14:51.189471 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
530 | 2024.12.06 21:14:51.191667 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} <Debug> oximeter.measurements_histogrami64 (557cd8b7-e420-4958-aa62-8b726679181c): Loading data parts | ||
531 | 2024.12.06 21:14:51.191851 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} <Debug> oximeter.measurements_histogrami64 (557cd8b7-e420-4958-aa62-8b726679181c): There are no data parts | ||
532 | 2024.12.06 21:14:51.195825 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} <Debug> TCPHandler: Processed in 0.006772061 sec. | ||
533 | 2024.12.06 21:14:51.196049 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
534 | 2024.12.06 21:14:51.196319 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
535 | 2024.12.06 21:14:51.196401 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
536 | 2024.12.06 21:14:51.198587 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} <Debug> oximeter.measurements_histogramu64 (5fcb42a8-362e-48b3-944e-5f72ad7166c8): Loading data parts | ||
537 | 2024.12.06 21:14:51.198759 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} <Debug> oximeter.measurements_histogramu64 (5fcb42a8-362e-48b3-944e-5f72ad7166c8): There are no data parts | ||
538 | 2024.12.06 21:14:51.202725 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} <Debug> TCPHandler: Processed in 0.00673026 sec. | ||
539 | 2024.12.06 21:14:51.202929 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
540 | 2024.12.06 21:14:51.203274 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
541 | 2024.12.06 21:14:51.203351 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
542 | 2024.12.06 21:14:51.205652 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} <Debug> oximeter.measurements_histogramf32 (7e92fb42-47a8-416e-9854-c0ab0d8f83b3): Loading data parts | ||
543 | 2024.12.06 21:14:51.205817 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} <Debug> oximeter.measurements_histogramf32 (7e92fb42-47a8-416e-9854-c0ab0d8f83b3): There are no data parts | ||
544 | 2024.12.06 21:14:51.209630 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} <Debug> TCPHandler: Processed in 0.006766202 sec. | ||
545 | 2024.12.06 21:14:51.209846 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
546 | 2024.12.06 21:14:51.210117 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
547 | 2024.12.06 21:14:51.210202 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
548 | 2024.12.06 21:14:51.212473 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} <Debug> oximeter.measurements_histogramf64 (42a4ae53-e2dc-4c16-a219-c5ea748fb4dd): Loading data parts | ||
549 | 2024.12.06 21:14:51.212669 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} <Debug> oximeter.measurements_histogramf64 (42a4ae53-e2dc-4c16-a219-c5ea748fb4dd): There are no data parts | ||
550 | 2024.12.06 21:14:51.216412 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} <Debug> TCPHandler: Processed in 0.006619529 sec. | ||
551 | 2024.12.06 21:14:51.216606 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
552 | 2024.12.06 21:14:51.216902 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The field tables store named dimensions of each timeseries. | ||
553 | * | ||
554 | * As with the measurement tables, there is one field table for each field data | ||
555 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
556 | * this behavior **must not** be relied upon for query correctness. | ||
557 | * | ||
558 | * The index for the fields differs from the measurements, however. Rows are | ||
559 | * sorted by timeseries name, then field name, field value, and finally | ||
560 | * timeseries key. This reflects the most common pattern for looking them up: | ||
561 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
562 | * usually then used to look up measurements. | ||
563 | * | ||
564 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
565 | * timeseries name and then key, since it would improve lookups where one | ||
566 | * already has the key. Realistically though, these tables are quite small and | ||
567 | * so performance benefits will be low in absolute terms. | ||
568 | * | ||
569 | * TTL: We use a materialized column to expire old field table records. This | ||
570 | * column is generated automatically by the database whenever a new row is | ||
571 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
572 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
573 | * record will remain during a deduplication, which will have the last | ||
574 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
575 | * measurement tables. | ||
576 | */ | ||
577 | 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) | ||
578 | 2024.12.06 21:14:51.216997 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
579 | 2024.12.06 21:14:51.219534 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} <Debug> oximeter.fields_bool (f7b1eb06-a847-4af5-8224-3f980af8aff2): Loading data parts | ||
580 | 2024.12.06 21:14:51.219694 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} <Debug> oximeter.fields_bool (f7b1eb06-a847-4af5-8224-3f980af8aff2): There are no data parts | ||
581 | 2024.12.06 21:14:51.223267 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} <Debug> TCPHandler: Processed in 0.00672526 sec. | ||
582 | 2024.12.06 21:14:51.223529 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2024.12.06 21:14:51.223766 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
584 | 2024.12.06 21:14:51.223849 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
585 | 2024.12.06 21:14:51.225896 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} <Debug> oximeter.fields_i8 (3de05a82-b2dc-4671-bd9f-632544df5bd5): Loading data parts | ||
586 | 2024.12.06 21:14:51.226093 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} <Debug> oximeter.fields_i8 (3de05a82-b2dc-4671-bd9f-632544df5bd5): There are no data parts | ||
587 | 2024.12.06 21:14:51.230069 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} <Debug> TCPHandler: Processed in 0.006604068 sec. | ||
588 | 2024.12.06 21:14:51.230284 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
589 | 2024.12.06 21:14:51.230506 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
590 | 2024.12.06 21:14:51.230566 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
591 | 2024.12.06 21:14:51.232590 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} <Debug> oximeter.fields_u8 (d48af4ee-5a07-45f2-a6b4-a4d5057deecb): Loading data parts | ||
592 | 2024.12.06 21:14:51.232757 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} <Debug> oximeter.fields_u8 (d48af4ee-5a07-45f2-a6b4-a4d5057deecb): There are no data parts | ||
593 | 2024.12.06 21:14:51.236807 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} <Debug> TCPHandler: Processed in 0.006579318 sec. | ||
594 | 2024.12.06 21:14:51.237038 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.12.06 21:14:51.237230 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
596 | 2024.12.06 21:14:51.237300 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
597 | 2024.12.06 21:14:51.239322 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} <Debug> oximeter.fields_i16 (a44b4af4-6219-459d-93f0-64c7c03b9fbf): Loading data parts | ||
598 | 2024.12.06 21:14:51.239553 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} <Debug> oximeter.fields_i16 (a44b4af4-6219-459d-93f0-64c7c03b9fbf): There are no data parts | ||
599 | 2024.12.06 21:14:51.243605 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} <Debug> TCPHandler: Processed in 0.006620309 sec. | ||
600 | 2024.12.06 21:14:51.243796 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
601 | 2024.12.06 21:14:51.244013 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
602 | 2024.12.06 21:14:51.244087 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
603 | 2024.12.06 21:14:51.246095 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} <Debug> oximeter.fields_u16 (58cabf91-3a29-4a77-b4ae-7d520d87d5bf): Loading data parts | ||
604 | 2024.12.06 21:14:51.246287 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} <Debug> oximeter.fields_u16 (58cabf91-3a29-4a77-b4ae-7d520d87d5bf): There are no data parts | ||
605 | 2024.12.06 21:14:51.248264 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:60424 | ||
606 | 2024.12.06 21:14:51.249264 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
607 | 2024.12.06 21:14:51.249299 [ 277 ] {} <Debug> TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Authenticating user 'default' from [fd00:1122:3344:101::c]:60424 | ||
608 | 2024.12.06 21:14:51.249329 [ 277 ] {} <Debug> TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
609 | 2024.12.06 21:14:51.249378 [ 277 ] {} <Debug> TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
610 | 2024.12.06 21:14:51.249446 [ 277 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
611 | 2024.12.06 21:14:51.249474 [ 277 ] {} <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 | ||
612 | 2024.12.06 21:14:51.249521 [ 277 ] {} <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 | ||
613 | 2024.12.06 21:14:51.249904 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:58640 | ||
614 | 2024.12.06 21:14:51.250081 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
615 | 2024.12.06 21:14:51.250079 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:40927 | ||
616 | 2024.12.06 21:14:51.250114 [ 278 ] {} <Debug> TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Authenticating user 'default' from [fd00:1122:3344:101::c]:58640 | ||
617 | 2024.12.06 21:14:51.250216 [ 280 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61006 | ||
618 | 2024.12.06 21:14:51.250376 [ 278 ] {} <Debug> TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
619 | 2024.12.06 21:14:51.250380 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
620 | 2024.12.06 21:14:51.250447 [ 278 ] {} <Debug> TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
621 | 2024.12.06 21:14:51.250378 [ 281 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49257 | ||
622 | 2024.12.06 21:14:51.250595 [ 282 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:50000 | ||
623 | 2024.12.06 21:14:51.250672 [ 279 ] {} <Debug> TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Authenticating user 'default' from [fd00:1122:3344:101::c]:40927 | ||
624 | 2024.12.06 21:14:51.250698 [ 280 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
625 | 2024.12.06 21:14:51.251057 [ 279 ] {} <Debug> TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
626 | 2024.12.06 21:14:51.251155 [ 283 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61857 | ||
627 | 2024.12.06 21:14:51.251200 [ 279 ] {} <Debug> TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
628 | 2024.12.06 21:14:51.251243 [ 284 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:65104 | ||
629 | 2024.12.06 21:14:51.251087 [ 281 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
630 | 2024.12.06 21:14:51.251305 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} <Debug> TCPHandler: Processed in 0.007549484 sec. | ||
631 | 2024.12.06 21:14:51.251470 [ 280 ] {} <Debug> TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Authenticating user 'default' from [fd00:1122:3344:101::c]:61006 | ||
632 | 2024.12.06 21:14:51.251473 [ 281 ] {} <Debug> TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Authenticating user 'default' from [fd00:1122:3344:101::c]:49257 | ||
633 | 2024.12.06 21:14:51.251637 [ 280 ] {} <Debug> TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
634 | 2024.12.06 21:14:51.251681 [ 281 ] {} <Debug> TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
635 | 2024.12.06 21:14:51.251729 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
636 | 2024.12.06 21:14:51.251749 [ 280 ] {} <Debug> TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
637 | 2024.12.06 21:14:51.251757 [ 281 ] {} <Debug> TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.12.06 21:14:51.252032 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
639 | 2024.12.06 21:14:51.252135 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
640 | 2024.12.06 21:14:51.256011 [ 283 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
641 | 2024.12.06 21:14:51.256098 [ 283 ] {} <Debug> TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Authenticating user 'default' from [fd00:1122:3344:101::c]:61857 | ||
642 | 2024.12.06 21:14:51.256117 [ 283 ] {} <Debug> TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.12.06 21:14:51.256131 [ 283 ] {} <Debug> TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
644 | 2024.12.06 21:14:51.256139 [ 284 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
645 | 2024.12.06 21:14:51.256212 [ 284 ] {} <Debug> TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Authenticating user 'default' from [fd00:1122:3344:101::c]:65104 | ||
646 | 2024.12.06 21:14:51.256238 [ 284 ] {} <Debug> TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
647 | 2024.12.06 21:14:51.256306 [ 284 ] {} <Debug> TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
648 | 2024.12.06 21:14:51.256782 [ 282 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
649 | 2024.12.06 21:14:51.256826 [ 282 ] {} <Debug> TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Authenticating user 'default' from [fd00:1122:3344:101::c]:50000 | ||
650 | 2024.12.06 21:14:51.256874 [ 282 ] {} <Debug> TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
651 | 2024.12.06 21:14:51.256908 [ 282 ] {} <Debug> TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
652 | 2024.12.06 21:14:51.256937 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} <Debug> oximeter.fields_i32 (a2fe09c4-6511-4fab-bdd9-8558e3e3bac7): Loading data parts | ||
653 | 2024.12.06 21:14:51.257241 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} <Debug> oximeter.fields_i32 (a2fe09c4-6511-4fab-bdd9-8558e3e3bac7): There are no data parts | ||
654 | 2024.12.06 21:14:51.259729 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} <Debug> TCPHandler: Processed in 0.008119043 sec. | ||
655 | 2024.12.06 21:14:51.259958 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
656 | 2024.12.06 21:14:51.260186 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
657 | 2024.12.06 21:14:51.260252 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
658 | 2024.12.06 21:14:51.263788 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} <Debug> oximeter.fields_u32 (c6851621-d47c-4851-96c4-4b60094043dd): Loading data parts | ||
659 | 2024.12.06 21:14:51.264011 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} <Debug> oximeter.fields_u32 (c6851621-d47c-4851-96c4-4b60094043dd): There are no data parts | ||
660 | 2024.12.06 21:14:51.266523 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} <Debug> TCPHandler: Processed in 0.006639879 sec. | ||
661 | 2024.12.06 21:14:51.266777 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
662 | 2024.12.06 21:14:51.267026 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
663 | 2024.12.06 21:14:51.267143 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
664 | 2024.12.06 21:14:51.270608 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} <Debug> oximeter.fields_i64 (c3601aee-2048-4326-a789-e1c21a43eba9): Loading data parts | ||
665 | 2024.12.06 21:14:51.270842 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} <Debug> oximeter.fields_i64 (c3601aee-2048-4326-a789-e1c21a43eba9): There are no data parts | ||
666 | 2024.12.06 21:14:51.273301 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} <Debug> TCPHandler: Processed in 0.006584058 sec. | ||
667 | 2024.12.06 21:14:51.273553 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
668 | 2024.12.06 21:14:51.273797 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
669 | 2024.12.06 21:14:51.273849 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
670 | 2024.12.06 21:14:51.277513 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} <Debug> oximeter.fields_u64 (22a56fe4-0225-4925-a9bd-b77d8f68f520): Loading data parts | ||
671 | 2024.12.06 21:14:51.277710 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} <Debug> oximeter.fields_u64 (22a56fe4-0225-4925-a9bd-b77d8f68f520): There are no data parts | ||
672 | 2024.12.06 21:14:51.280334 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} <Debug> TCPHandler: Processed in 0.006857472 sec. | ||
673 | 2024.12.06 21:14:51.280589 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
674 | 2024.12.06 21:14:51.280826 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
675 | 2024.12.06 21:14:51.280924 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
676 | 2024.12.06 21:14:51.284639 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} <Debug> oximeter.fields_ipaddr (d35e1587-c56d-41ab-b0ba-a91f733cdaa9): Loading data parts | ||
677 | 2024.12.06 21:14:51.284889 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} <Debug> oximeter.fields_ipaddr (d35e1587-c56d-41ab-b0ba-a91f733cdaa9): There are no data parts | ||
678 | 2024.12.06 21:14:51.287901 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} <Debug> TCPHandler: Processed in 0.007376721 sec. | ||
679 | 2024.12.06 21:14:51.288097 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
680 | 2024.12.06 21:14:51.288340 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) | ||
681 | 2024.12.06 21:14:51.288423 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
682 | 2024.12.06 21:14:51.294465 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} <Debug> oximeter.fields_string (343984b9-b893-4af4-9045-9f912231ba92): Loading data parts | ||
683 | 2024.12.06 21:14:51.294665 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} <Debug> oximeter.fields_string (343984b9-b893-4af4-9045-9f912231ba92): There are no data parts | ||
684 | 2024.12.06 21:14:51.299364 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} <Debug> TCPHandler: Processed in 0.011322465 sec. | ||
685 | 2024.12.06 21:14:51.299626 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
686 | 2024.12.06 21:14:51.299871 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) | ||
687 | 2024.12.06 21:14:51.299959 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
688 | 2024.12.06 21:14:51.306630 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} <Debug> oximeter.fields_uuid (956c3398-09af-4831-9dc5-03d47a327612): Loading data parts | ||
689 | 2024.12.06 21:14:51.306841 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} <Debug> oximeter.fields_uuid (956c3398-09af-4831-9dc5-03d47a327612): There are no data parts | ||
690 | 2024.12.06 21:14:51.310936 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} <Debug> TCPHandler: Processed in 0.011384386 sec. | ||
691 | 2024.12.06 21:14:51.311182 [ 266 ] {} <Trace> TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
692 | 2024.12.06 21:14:51.311491 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The timeseries schema table stores the extracted schema for the samples | ||
693 | * oximeter collects. | ||
694 | */ | ||
695 | 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) | ||
696 | 2024.12.06 21:14:51.311576 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
697 | 2024.12.06 21:14:51.314256 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} <Debug> oximeter.timeseries_schema (170f830b-7c5a-4889-8861-cee262533a56): Loading data parts | ||
698 | 2024.12.06 21:14:51.314475 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} <Debug> oximeter.timeseries_schema (170f830b-7c5a-4889-8861-cee262533a56): There are no data parts | ||
699 | 2024.12.06 21:14:51.319940 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} <Debug> TCPHandler: Processed in 0.008828345 sec. | ||
700 | 2024.12.06 21:14:51.320134 [ 268 ] {} <Trace> TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
701 | 2024.12.06 21:14:51.320385 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44123) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
702 | 2024.12.06 21:14:51.321616 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
703 | 2024.12.06 21:14:51.329972 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Trace> oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
704 | 2024.12.06 21:14:51.330082 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. | ||
705 | 2024.12.06 21:14:51.334967 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
706 | 2024.12.06 21:14:51.335458 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Trace> oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
707 | 2024.12.06 21:14:51.335843 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.015559 sec., 64.27148274310689 rows/sec., 1.00 KiB/sec. | ||
708 | 2024.12.06 21:14:51.336134 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} <Debug> TCPHandler: Processed in 0.016055933 sec. | ||
709 | 2024.12.06 21:14:51.337116 [ 285 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:39673 | ||
710 | 2024.12.06 21:14:51.338419 [ 285 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
711 | 2024.12.06 21:14:51.338456 [ 285 ] {} <Debug> TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Authenticating user 'default' from [fd00:1122:3344:101::a]:39673 | ||
712 | 2024.12.06 21:14:51.338480 [ 285 ] {} <Debug> TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
713 | 2024.12.06 21:14:51.338529 [ 285 ] {} <Debug> TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.12.06 21:14:51.338580 [ 285 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
715 | 2024.12.06 21:14:51.338605 [ 285 ] {} <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 | ||
716 | 2024.12.06 21:14:51.338652 [ 285 ] {} <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 | ||
717 | 2024.12.06 21:14:51.339188 [ 286 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38739 | ||
718 | 2024.12.06 21:14:51.339258 [ 287 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:43174 | ||
719 | 2024.12.06 21:14:51.339537 [ 286 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
720 | 2024.12.06 21:14:51.339550 [ 287 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
721 | 2024.12.06 21:14:51.339596 [ 286 ] {} <Debug> TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Authenticating user 'default' from [fd00:1122:3344:101::a]:38739 | ||
722 | 2024.12.06 21:14:51.339570 [ 288 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:49255 | ||
723 | 2024.12.06 21:14:51.339654 [ 289 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:35720 | ||
724 | 2024.12.06 21:14:51.339687 [ 287 ] {} <Debug> TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Authenticating user 'default' from [fd00:1122:3344:101::a]:43174 | ||
725 | 2024.12.06 21:14:51.339702 [ 286 ] {} <Debug> TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.12.06 21:14:51.339749 [ 290 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:49498 | ||
727 | 2024.12.06 21:14:51.340032 [ 286 ] {} <Debug> TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
728 | 2024.12.06 21:14:51.340113 [ 287 ] {} <Debug> TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
729 | 2024.12.06 21:14:51.340267 [ 290 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
730 | 2024.12.06 21:14:51.340283 [ 287 ] {} <Debug> TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
731 | 2024.12.06 21:14:51.340329 [ 290 ] {} <Debug> TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Authenticating user 'default' from [fd00:1122:3344:101::a]:49498 | ||
732 | 2024.12.06 21:14:51.340368 [ 292 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62493 | ||
733 | 2024.12.06 21:14:51.340377 [ 291 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:40949 | ||
734 | 2024.12.06 21:14:51.340400 [ 290 ] {} <Debug> TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
735 | 2024.12.06 21:14:51.340558 [ 290 ] {} <Debug> TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
736 | 2024.12.06 21:14:51.345194 [ 288 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
737 | 2024.12.06 21:14:51.345249 [ 288 ] {} <Debug> TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Authenticating user 'default' from [fd00:1122:3344:101::a]:49255 | ||
738 | 2024.12.06 21:14:51.345261 [ 292 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
739 | 2024.12.06 21:14:51.345348 [ 288 ] {} <Debug> TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
740 | 2024.12.06 21:14:51.345353 [ 292 ] {} <Debug> TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Authenticating user 'default' from [fd00:1122:3344:101::a]:62493 | ||
741 | 2024.12.06 21:14:51.345368 [ 288 ] {} <Debug> TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
742 | 2024.12.06 21:14:51.345429 [ 292 ] {} <Debug> TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
743 | 2024.12.06 21:14:51.345493 [ 291 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
744 | 2024.12.06 21:14:51.345507 [ 292 ] {} <Debug> TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
745 | 2024.12.06 21:14:51.345604 [ 291 ] {} <Debug> TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Authenticating user 'default' from [fd00:1122:3344:101::a]:40949 | ||
746 | 2024.12.06 21:14:51.345636 [ 291 ] {} <Debug> TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
747 | 2024.12.06 21:14:51.345677 [ 291 ] {} <Debug> TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
748 | 2024.12.06 21:14:51.346048 [ 289 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
749 | 2024.12.06 21:14:51.346092 [ 289 ] {} <Debug> TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Authenticating user 'default' from [fd00:1122:3344:101::a]:35720 | ||
750 | 2024.12.06 21:14:51.346114 [ 289 ] {} <Debug> TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
751 | 2024.12.06 21:14:51.346169 [ 289 ] {} <Debug> TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
752 | 2024.12.06 21:14:52.000172 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 136.71 MiB, peak 136.71 MiB, free memory in arenas 0.00 B, will set to 141.16 MiB (RSS), difference: 4.45 MiB | ||
753 | 2024.12.06 21:14:57.745068 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
754 | 2024.12.06 21:14:57.745149 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
755 | 2024.12.06 21:14:57.745205 [ 243 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
756 | 2024.12.06 21:14:57.745310 [ 244 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
757 | 2024.12.06 21:14:57.752752 [ 244 ] {} <Debug> system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Loading data parts | ||
758 | 2024.12.06 21:14:57.753139 [ 244 ] {} <Debug> system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): There are no data parts | ||
759 | 2024.12.06 21:14:57.763120 [ 244 ] {} <Trace> system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
760 | 2024.12.06 21:14:57.763194 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. | ||
761 | 2024.12.06 21:14:57.766612 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
762 | 2024.12.06 21:14:57.767222 [ 244 ] {} <Trace> system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
763 | 2024.12.06 21:14:57.767862 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
764 | 2024.12.06 21:14:57.777239 [ 243 ] {} <Debug> system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Loading data parts | ||
765 | 2024.12.06 21:14:57.777450 [ 243 ] {} <Debug> system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): There are no data parts | ||
766 | 2024.12.06 21:14:57.803083 [ 243 ] {} <Trace> system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
767 | 2024.12.06 21:14:57.803126 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. | ||
768 | 2024.12.06 21:14:57.810270 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
769 | 2024.12.06 21:14:57.811004 [ 243 ] {} <Trace> system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
770 | 2024.12.06 21:14:57.813341 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
771 | 2024.12.06 21:14:58.000256 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 146.20 MiB, peak 150.20 MiB, free memory in arenas 0.00 B, will set to 151.02 MiB (RSS), difference: 4.82 MiB | ||
772 | 2024.12.06 21:15:00.245043 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
773 | 2024.12.06 21:15:00.245160 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
774 | 2024.12.06 21:15:00.251340 [ 242 ] {} <Debug> system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Loading data parts | ||
775 | 2024.12.06 21:15:00.251596 [ 242 ] {} <Debug> system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): There are no data parts | ||
776 | 2024.12.06 21:15:00.259992 [ 242 ] {} <Trace> system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
777 | 2024.12.06 21:15:00.260055 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.19 GiB. | ||
778 | 2024.12.06 21:15:00.262282 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
779 | 2024.12.06 21:15:00.262636 [ 242 ] {} <Trace> system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
780 | 2024.12.06 21:15:00.263191 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
781 | 2024.12.06 21:15:01.000175 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 155.20 MiB, peak 155.20 MiB, free memory in arenas 0.00 B, will set to 151.41 MiB (RSS), difference: -3.79 MiB |