Comments (3)
kernel288
commented on May 23, 2024
SELECT
merge_reason,
event_time,
duration_ms,
table_uuid,
part_name,
partition_id,
path_on_disk,
merged_from
FROM system.part_log
WHERE part_name IN ('f4cc9647ec6de93c356313be86f5d391_474_499_5', 'f4cc9647ec6de93c356313be86f5d391_499_499_0')
ORDER BY event_time ASC
Query id: 634a9470-a0e3-4909-9d44-714b374af41e
Row 1:
──────
merge_reason: NotAMerge
event_time: 2024-04-27 13:23:15
duration_ms: 1
table_uuid: 759c66c6-ba9a-47d2-b3b2-53381e355e02
part_name: f4cc9647ec6de93c356313be86f5d391_499_499_0
partition_id: f4cc9647ec6de93c356313be86f5d391
path_on_disk: /data21/clickhouse/store/759/759c66c6-ba9a-47d2-b3b2-53381e355e02/f4cc9647ec6de93c356313be86f5d391_499_499_0/
merged_from: []
Row 2:
──────
merge_reason: RegularMerge
event_time: 2024-04-27 15:18:16
duration_ms: 5116
table_uuid: 759c66c6-ba9a-47d2-b3b2-53381e355e02
part_name: f4cc9647ec6de93c356313be86f5d391_474_499_5
partition_id: f4cc9647ec6de93c356313be86f5d391
path_on_disk: /data11/clickhouse/store/759/759c66c6-ba9a-47d2-b3b2-53381e355e02/f4cc9647ec6de93c356313be86f5d391_474_499_5/
merged_from: ['f4cc9647ec6de93c356313be86f5d391_474_494_4','f4cc9647ec6de93c356313be86f5d391_495_495_0','f4cc9647ec6de93c356313be86f5d391_496_496_0','f4cc9647ec6de93c356313be86f5d391_497_497_0','f4cc9647ec6de93c356313be86f5d391_498_498_0','f4cc9647ec6de93c356313be86f5d391_499_499_0']
Row 3:
──────
merge_reason: NotAMerge
event_time: 2024-04-27 15:27:39
duration_ms: 0
table_uuid: 759c66c6-ba9a-47d2-b3b2-53381e355e02
part_name: f4cc9647ec6de93c356313be86f5d391_499_499_0
partition_id: f4cc9647ec6de93c356313be86f5d391
path_on_disk:
merged_from: []
Row 4:
──────
merge_reason: NotAMerge
event_time: 2024-04-27 15:32:15
duration_ms: 0
table_uuid: 759c66c6-ba9a-47d2-b3b2-53381e355e02
part_name: f4cc9647ec6de93c356313be86f5d391_474_499_5
partition_id: f4cc9647ec6de93c356313be86f5d391
path_on_disk:
merged_from: []
4 rows in set. Elapsed: 0.028 sec. Processed 408.99 thousand rows, 22.54 MB (14.59 million rows/s., 803.86 MB/s.)
Peak memory usage: 6.06 MiB.from clickhouse.
alexey-milovidov
commented on May 23, 2024
This isn't an error.
from clickhouse.
alexey-milovidov
commented on May 23, 2024
No action is needed - keep it as is.
from clickhouse.
Related Issues (20)
- Create role or user with only digits in name via XML
- Not a bug: libunwind: aarch64: SIGSEGV signal handler leads to another seg fault HOT 3
- Apache Datasketches: UBSan report: load of misaligned address HOT 1
- DB::Exception: Invalid type for SerializationLowCardinality index column
- Locally querying a Map(LowCardinality(String), String)) inside a Tuple leads to segfault in clickhouse server
- ubsan: Unsafe integer cast in `replaceNodesWithPositionalArguments` HOT 1
- Context has expired in `SetOrJoinSink::consume` (when writing through MV)
- (experimental transactions) An EXPLAIN query causes a segfault
- After using projection, the same query statement has different values and cannot be hit. HOT 7
- Wrong result in left join HOT 2
- query with view is slower HOT 4
- Clickhouse reads too many marks on large parts when query filter by PK HOT 2
- cross-version query : Not found column ip in block HOT 4
- Unable to Connect to HDFS for Tiered Storage Setup HOT 6
- Not found column in block, optimize_skip_unused_shards = 1, analyzer
- Filtering by `dictGet()` column leads to `TYPE_MISMATCH` exception HOT 1
- Unexpected exception when using final modifier with non MergeTree table HOT 1
- LOGICAL_ERROR Pipeline for PushingPipelineExecutor was finished before all data was inserted HOT 1
- clickhouse-keeper-client: add flag to allow rm & rmr command non-interactive
- Parallel replicas and join throw error 'expected to process query to fetch columns stage. Actual WithMergeableState'
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clickhouse.