| 1 | [ Oct 29 04:29:41 Enabled. ] | ||
| 2 | [ Oct 29 04:29:41 Rereading configuration. ] | ||
| 3 | [ Oct 29 04:29:47 Rereading configuration. ] | ||
| 4 | [ Oct 29 04:29:56 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 | ++ svcprop -c -p config/datalink svc:/oxide/clickhouse:default | ||
| 23 | + DATALINK=oxControlService12 | ||
| 24 | ++ svcprop -c -p config/gateway svc:/oxide/clickhouse:default | ||
| 25 | + GATEWAY=fd00:1122:3344:101::1 | ||
| 26 | + [[ oxControlService12 == unknown ]] | ||
| 27 | + [[ fd00:1122:3344:101::1 == unknown ]] | ||
| 28 | + ipadm delete-if oxControlService12 | ||
| 29 | ipadm: Could not delete oxControlService12: Interface does not exist | ||
| 30 | + true | ||
| 31 | + ipadm create-if -t oxControlService12 | ||
| 32 | + ipadm set-ifprop -t -p mtu=9000 -m ipv4 oxControlService12 | ||
| 33 | + ipadm set-ifprop -t -p mtu=9000 -m ipv6 oxControlService12 | ||
| 34 | + ipadm show-addr oxControlService12/ll | ||
| 35 | ipadm: Address object not found | ||
| 36 | + ipadm create-addr -t -T addrconf oxControlService12/ll | ||
| 37 | + ipadm show-addr oxControlService12/omicron6 | ||
| 38 | ipadm: Address object not found | ||
| 39 | + ipadm create-addr -t -T static -a fd00:1122:3344:101::e oxControlService12/omicron6 | ||
| 40 | + route get -inet6 default -inet6 fd00:1122:3344:101::1 | ||
| 41 | default: not in table | ||
| 42 | + route add -inet6 default -inet6 fd00:1122:3344:101::1 | ||
| 43 | add net default: gateway fd00:1122:3344:101::1 | ||
| 44 | + single_node=true | ||
| 45 | + command=() | ||
| 46 | + true | ||
| 47 | + command+=("/opt/oxide/clickhouse/clickhouse" "server" "--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 48 | + exec /opt/oxide/clickhouse/clickhouse server --log-file /var/tmp/clickhouse-server.log --errorlog-file /var/tmp/clickhouse-server.errlog -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
| 49 | [ Oct 29 04:29:57 Method "start" exited with status 0. ] | ||
| 50 | Processing configuration file 'config.xml'. | ||
| 51 | There is no file 'config.xml', will use embedded config. | ||
| 52 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 53 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 54 | 2023.10.29 04:29:57.539613 [ 1 ] {} <Information> Application: Will watch for the process with pid 24079 | ||
| 55 | 2023.10.29 04:29:57.539713 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 56 | 2023.10.29 04:29:58.396483 [ 1 ] {} <Information> : Starting ClickHouse 22.8.9.1 with revision 54465, no build id, PID 24079 | ||
| 57 | 2023.10.29 04:29:58.396654 [ 1 ] {} <Information> Application: starting up | ||
| 58 | 2023.10.29 04:29:58.396851 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 59 | 2023.10.29 04:29:58.510541 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 60 | 2023.10.29 04:29:58.510589 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 61 | 2023.10.29 04:29:58.510605 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 62 | 2023.10.29 04:29:58.510641 [ 1 ] {} <Debug> Application: Setting up /data/tmp/ to store temporary data in it | ||
| 63 | 2023.10.29 04:29:58.510964 [ 1 ] {} <Debug> Application: Initiailizing interserver credentials. | ||
| 64 | 2023.10.29 04:29:58.511651 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 65 | Processing configuration file 'config.xml'. | ||
| 66 | There is no file 'config.xml', will use embedded config. | ||
| 67 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 68 | 2023.10.29 04:29:58.512138 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 69 | 2023.10.29 04:29:58.512398 [ 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) | ||
| 70 | 2023.10.29 04:29:58.515100 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 71 | 2023.10.29 04:29:58.515147 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 72 | 2023.10.29 04:29:58.515935 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 73 | Processing configuration file 'config.xml'. | ||
| 74 | There is no file 'config.xml', will use embedded config. | ||
| 75 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 76 | 2023.10.29 04:29:58.516120 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 77 | 2023.10.29 04:29:58.522429 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 78 | 2023.10.29 04:29:58.522935 [ 1 ] {} <Debug> Access(user directories): Added users.xml access storage 'users.xml', path: config.xml | ||
| 79 | 2023.10.29 04:29:58.522964 [ 1 ] {} <Information> Application: Uncompressed cache policy name | ||
| 80 | 2023.10.29 04:29:58.524380 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32 | ||
| 81 | 2023.10.29 04:29:58.524919 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 82 | 2023.10.29 04:29:58.525219 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 83 | 2023.10.29 04:29:58.525637 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 84 | 2023.10.29 04:29:58.526428 [ 1 ] {} <Information> Application: Loading user defined objects from /data/ | ||
| 85 | 2023.10.29 04:29:58.526469 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoader: Loading user defined objects | ||
| 86 | 2023.10.29 04:29:58.526526 [ 1 ] {} <Debug> Application: Loaded user defined objects | ||
| 87 | 2023.10.29 04:29:58.526546 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 88 | 2023.10.29 04:29:58.548012 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 89 | 2023.10.29 04:29:58.548045 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000127033 sec | ||
| 90 | 2023.10.29 04:29:58.548699 [ 1 ] {} <Information> TablesLoader: Loading 0 tables with 0 dependency level | ||
| 91 | 2023.10.29 04:29:58.548781 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 92 | 2023.10.29 04:29:58.548807 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 93 | 2023.10.29 04:29:58.548824 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 94 | 2023.10.29 04:29:58.548836 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 95 | 2023.10.29 04:29:58.548850 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 96 | 2023.10.29 04:29:58.548872 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 97 | 2023.10.29 04:29:58.548903 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 98 | 2023.10.29 04:29:58.548922 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 99 | 2023.10.29 04:29:58.548953 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 100 | 2023.10.29 04:29:58.548965 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 101 | 2023.10.29 04:29:58.548979 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 102 | 2023.10.29 04:29:58.548994 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 103 | 2023.10.29 04:29:58.549025 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 104 | 2023.10.29 04:29:58.549040 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 105 | 2023.10.29 04:29:58.549051 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 106 | 2023.10.29 04:29:58.584037 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 107 | 2023.10.29 04:29:58.585756 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 108 | 2023.10.29 04:29:58.585784 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.3871e-05 sec | ||
| 109 | 2023.10.29 04:29:58.585807 [ 1 ] {} <Information> TablesLoader: Loading 0 tables with 0 dependency level | ||
| 110 | 2023.10.29 04:29:58.585822 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 111 | 2023.10.29 04:29:58.585843 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 112 | 2023.10.29 04:29:58.588259 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 113 | 2023.10.29 04:29:58.593687 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 114 | 2023.10.29 04:29:58.593764 [ 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). | ||
| 115 | 2023.10.29 04:29:58.593806 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 116 | 2023.10.29 04:29:58.795526 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 22.8.9.1) | ||
| 117 | 2023.10.29 04:29:58.813472 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 22.8.9.1) | ||
| 118 | 2023.10.29 04:29:58.813556 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 119 | 2023.10.29 04:29:58.865175 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 120 | 2023.10.29 04:29:58.865950 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 5.95 MiB, peak 10.41 MiB, will set to 216.67 MiB (RSS), difference: 210.72 MiB | ||
| 121 | 2023.10.29 04:29:58.866306 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 122 | 2023.10.29 04:29:58.866351 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 24; logical cores: 48. | ||
| 123 | 2023.10.29 04:29:58.866372 [ 60 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 124 | 2023.10.29 04:29:58.866461 [ 60 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 125 | 2023.10.29 04:29:58.866489 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 126 | 2023.10.29 04:29:58.866542 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 127 | 2023.10.29 04:29:58.867176 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004 | ||
| 128 | 2023.10.29 04:29:58.867222 [ 1 ] {} <Information> Application: Ready for connections. | ||