OS:
LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description: CentOS Linux release 7.4.1708 (Core)
Release: 7.4.1708
Codename: Core
clickhouse version:
19.8.3.8
cmake && make install build_options from system.build_options
┌─name──────────────────────┬─value─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ VERSION_FULL │ ClickHouse 19.8.3.8 │
│ VERSION_DESCRIBE │ v19.8.3.8-stable │
│ VERSION_INTEGER │ 19008003 │
│ VERSION_GITHASH │ 55c0a90cae7ee61d43b24f110c9a195c8a1cee93 │
│ VERSION_REVISION │ 54420 │
│ BUILD_DATE │ 2019-12-13 │
│ SYSTEM │ Linux-3.10.0-957.10.1.el7.x86_64 │
│ BUILD_TYPE │MinSizeRel │
│ SYSTEM_PROCESSOR │ x86_64 │
│ LIBRARY_ARCHITECTURE │ │
│ CMAKE_VERSION │ 3.13.5 │
│ C_COMPILER │ /opt/rh/devtoolset-8/root/usr/bin/gcc │
│ C_COMPILER_VERSION │ 8.3.1 │
│ CXX_COMPILER │ /opt/rh/devtoolset-8/root/usr/bin/g++ │
│ CXX_COMPILER_VERSION │ 8.3.1 │
│ C_FLAGS │ -pipe -msse4.1 -msse4.2 -mpopcnt -fno-omit-frame-pointer -Wall -no-pie -Os -DNDEBUG -no-pie -O2 -g -DNDEBUG -O3 │
│ CXX_FLAGS │ -pipe -msse4.1 -msse4.2 -mpopcnt -fno-omit-frame-pointer -Wall -Wnon-virtual-dtor -no-pie -Os -no-pie -O2 -g -DNDEBUG -O3 │
│ LINK_FLAGS │ │
│ BUILD_COMPILE_DEFINITIONS │ │
│ BUILD_INCLUDE_DIRECTORIES │ │
│ STATIC │ ON │
│ SPLIT_BINARY │ │
│ USE_EMBEDDED_COMPILER │ 0 │
│ USE_INTERNAL_MEMCPY │ ON │
│ USE_GLIBC_COMPATIBILITY │ OFF │
│ USE_JEMALLOC │ 1 │
│ USE_TCMALLOC │ │
│ USE_LFALLOC │ │
│ USE_LFALLOC_RANDOM_HINT │ │
│ USE_UNWIND │ 1 │
│ USE_ICU │ 1 │
│ USE_MYSQL │ 1 │
│ USE_RE2_ST │ 1 │
│ USE_VECTORCLASS │ │
│ USE_LIBGSASL │ 1 │
│ USE_RDKAFKA │ 1 │
│ USE_CAPNP │ 1 │
│ USE_POCO_SQLODBC │ │
│ USE_POCO_DATAODBC │ 1 │
│ USE_POCO_MONGODB │ 1 │
│ USE_POCO_NETSSL │ 1 │
│ USE_BASE64 │ 1 │
│ USE_XXHASH │ 1 │
│ USE_HDFS │ 1 │
│ USE_SNAPPY │ 1 │
│ USE_PARQUET │ 1 │
│ USE_PROTOBUF │ 1 │
│ USE_BROTLI │ 1 │
│ USE_SSL │ 1 │
│ USE_HYPERSCAN │ 1 │
│ USE_SIMDJSON │ ON │
└───────────────────────────┴───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
build_options from builder of clickhouse-rpm
comamnd
After ./builder install --deps
./builder build --rpms --from-sources-in-SOURCES-dir --cmake-build-type MinSizeRel >/tmp/build_log/build_update_glibc_minsizerel.log 2>&1
SELECT *
FROM system.build_options
┌─name──────────────────────┬─value───────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ VERSION_FULL │ ClickHouse 19.8.3.8 │
│ VERSION_DESCRIBE │ v19.8.3.8-stable │
│ VERSION_INTEGER │ 19008003 │
│ VERSION_GITHASH │ 55c0a90cae7ee61d43b24f110c9a195c8a1cee93 │
│ VERSION_REVISION │ 54420 │
│ BUILD_DATE │ 2019-12-12 │
│ SYSTEM │ Linux-3.10.0-957.10.1.el7.x86_64 │
│ BUILD_TYPE │ MinSizeRel │
│ SYSTEM_PROCESSOR │ x86_64 │
│ LIBRARY_ARCHITECTURE │ │
│ CMAKE_VERSION │ 3.13.5 │
│ C_COMPILER │ /opt/rh/devtoolset-8/root/usr/bin/gcc │
│ C_COMPILER_VERSION │ 8.3.1 │
│ CXX_COMPILER │ /opt/rh/devtoolset-8/root/usr/bin/g++ │
│ CXX_COMPILER_VERSION │ 8.3.1 │
│ C_FLAGS │ -pipe -msse4.1 -msse4.2 -mpopcnt -fno-omit-frame-pointer -Wall -no-pie -Os -DNDEBUG │
│ CXX_FLAGS │ -pipe -msse4.1 -msse4.2 -mpopcnt -fno-omit-frame-pointer -Wall -Wnon-virtual-dtor -no-pie -Os -DNDEBUG │
│ LINK_FLAGS │ │
│ BUILD_COMPILE_DEFINITIONS │ │
│ BUILD_INCLUDE_DIRECTORIES │ │
│ STATIC │ ON │
│ SPLIT_BINARY │ │
│ USE_EMBEDDED_COMPILER │ 0 │
│ USE_INTERNAL_MEMCPY │ ON │
│ USE_GLIBC_COMPATIBILITY │ OFF │
│ USE_JEMALLOC │ 1 │
│ USE_TCMALLOC │ │
│ USE_LFALLOC │ │
│ USE_LFALLOC_RANDOM_HINT │ │
│ USE_UNWIND │ 1 │
│ USE_ICU │ 1 │
│ USE_MYSQL │ 1 │
│ USE_RE2_ST │ 1 │
│ USE_VECTORCLASS │ │
│ USE_LIBGSASL │ 1 │
│ USE_RDKAFKA │ 1 │
│ USE_CAPNP │ 1 │
│ USE_POCO_SQLODBC │ │
│ USE_POCO_DATAODBC │ 1 │
│ USE_POCO_MONGODB │ 1 │
│ USE_POCO_NETSSL │ 1 │
│ USE_BASE64 │ 1 │
│ USE_XXHASH │ 1 │
│ USE_HDFS │ 1 │
│ USE_SNAPPY │ 1 │
│ USE_PARQUET │ 1 │
│ USE_PROTOBUF │ 1 │
│ USE_BROTLI │ 1 │
│ USE_SSL │ 1 │
│ USE_HYPERSCAN │ 1 │
│ USE_SIMDJSON │ ON │
└───────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
51 rows in set. Elapsed: 0.002 sec.
They are the same.
The apperance is that:
The abnormal clickhouse-client:
op_admin@m6v-10-9-5-19 bin]$ ./clickhouse-client
ClickHouse client version 19.8.3.8.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.8.3 revision 54420.
m6v-10-9-5-19.bj.idc.sprucetec.com :) ^[OA^[OA^[OA^[OB^[OB^[OA^[OA^[OB^[OB^[OA
The clickhouse-server's whe connected with this disnormal clickhouse-client log:
2019.12.13 07:47:07.206835 [ 38 ] {} TCPHandlerFactory: TCP Request. Address: 127.0.0.1:17071
2019.12.13 07:47:07.206928 [ 38 ] {} TCPHandler: Connected ClickHouse client version 19.8.0, revision: 54420, user: default.
The normal clickhouse-client:
op_admin@m6v-10-9-5-19 programs]$ ./clickhouse-client
ClickHouse client version 19.8.3.8.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.8.3 revision 54420.
m6v-10-9-5-19.bj.idc.sprucetec.com :) select * from system.build_options; //we can use the uparrow to scan the history command.
The clickhouse-server's log when connected with the client is :
019.12.13 07:45:44.434749 [ 26 ] {} TCPHandlerFactory: TCP Request. Address: 127.0.0.1:17065
2019.12.13 07:45:44.434836 [ 26 ] {} TCPHandler: Connected ClickHouse client version 19.8.0, revision: 54420, user: default.
2019.12.13 07:45:44.441371 [ 25 ] {} TCPHandlerFactory: TCP Request. Address: 127.0.0.1:17067
2019.12.13 07:45:44.441438 [ 25 ] {} TCPHandler: Connected ClickHouse client version 19.8.0, revision: 54420, user: default.
2019.12.13 07:45:44.443652 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} executeQuery: (from 127.0.0.1:17067) SELECT DISTINCT arrayJoin(extractAll(name, '[\w_]{2,}')) AS res FROM (SELECT name FROM system.functions UNION ALL SELECT name FROM system.table_engines UNION ALL SELECT name FROM system.formats UNION ALL SELECT name FROM system.table_functions UNION ALL SELECT name FROM system.data_type_families UNION ALL SELECT name FROM system.settings UNION ALL SELECT concat(func.name, comb.name) FROM system.functions AS func CROSS JOIN system.aggregate_function_combinators AS comb WHERE is_aggregate UNION ALL SELECT name FROM system.databases LIMIT 10000 UNION ALL SELECT DISTINCT name FROM system.tables LIMIT 10000 UNION ALL SELECT DISTINCT name FROM system.columns LIMIT 10000) WHERE notEmpty(res)
2019.12.13 07:45:44.444828 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} Join: setSampleBlock: comb.name String String(size = 0)
2019.12.13 07:45:44.446489 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} Join: setSampleBlock: comb.name String String(size = 0)
2019.12.13 07:45:44.448204 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} Join: setSampleBlock: comb.name String String(size = 0)
2019.12.13 07:45:44.449533 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.449610 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.449670 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.449733 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.449826 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450034 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450525 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450654 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450762 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450911 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.450979 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.452173 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} executeQuery: Query pipeline:
Expression
Distinct
Union
Distinct × 6
Expression
Filter
Converting
Expression
Expression
One
Distinct
Expression
Filter
Converting
Expression
CreatingSets
Lazy
Expression
Filter
Expression
One
Distinct
Expression
Filter
Converting
Limit
Expression
Expression
One
Distinct
Expression
Filter
Converting
Limit
Expression
Distinct
Expression
Tables
Distinct
Expression
Filter
Converting
Limit
Expression
Distinct
Expression
Columns
2019.12.13 07:45:44.452596 [ 28 ] {} CreatingSetsBlockInputStream: Creating join.
2019.12.13 07:45:44.452696 [ 28 ] {} InterpreterSelectQuery: FetchColumns -> Complete
2019.12.13 07:45:44.452749 [ 28 ] {} CreatingSetsBlockInputStream: Created. Join with 6 entries from 6 rows. In 0.000 sec.
2019.12.13 07:45:44.454031 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} UnionBlockInputStream: Waiting for threads to finish
2019.12.13 07:45:44.454065 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} UnionBlockInputStream: Waited for threads to finish
2019.12.13 07:45:44.454118 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} executeQuery: Read 2006 rows, 83.00 KiB in 0.010 sec., 192804 rows/sec., 7.79 MiB/sec.
2019.12.13 07:45:44.454141 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} MemoryTracker: Peak memory usage (for query): 1.92 MiB.
2019.12.13 07:45:44.454187 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} UnionBlockInputStream: Waiting for threads to finish
2019.12.13 07:45:44.454209 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} UnionBlockInputStream: Waited for threads to finish
2019.12.13 07:45:44.454342 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} MemoryTracker: Peak memory usage (total): 1.92 MiB.
2019.12.13 07:45:44.454371 [ 25 ] {f1e87796-9ea3-4bc2-8623-3d04d5146192} TCPHandler: Processed in 0.011 sec.
2019.12.13 07:45:44.454406 [ 25 ] {} TCPHandler: Done processing connection.
We can see this, the clickhouse-client has queried the database's all metadata by now, while the disnormal clickhouse-client does not do that.
Where is the problem when builder runs the compliation.