getPKEYCompactionTaskStatus
Syntax
getPKEYCompactionTaskStatus([count])
Arguments
count (optional) is a non-negative integer that specifies how many recent completed compaction tasks (successful or failed) to report per volume. The default value is 0, indicating that all completed compaction tasks are returned.
Details
Obtain the status of PKEY level file compaction tasks, including all pending tasks and completed tasks.The optional count limits the number of completed tasks returned. The function can only be executed on a data node.
Return value: A table with the following columns:
- volume: the volume where the compaction is performed. It is set by the configuration parameter volumes.
- level: the level of files that are involved in the current compaction. An empty cell means the compaction hasn’t started, is ongoing, or failed.A compaction involves up to two levels at a time.
- chunkId: the ID of chunk where the compaction is performed.
- tableName: the physical name of the table where the compaction is performed.
- files: the level files involved in the current compaction. An empty cell means the compaction hasn’t started, is ongoing, or failed.
- force: whether the compaction is triggered by
triggerPKEYCompaction
. - receivedTime: the timestamp when the compaction task enqueued.
- startTime: the timestamp when the compaction task started.
- endTime: the timestamp when the compaction task ended.
- errorMessage: If a task failed, the column displays the failure cause; otherwise it is left empty.
Examples
getPKEYCompactionTaskStatus()
volume | level | chunkId | tableName | files | force | receivedTime | startTime | endTime | errorMessage |
---|---|---|---|---|---|---|---|---|---|
/home/dolphindb/server/local8848/storage | 2 | ac872f06-abed-339c-8642-ce7dcf415691 | pt1_2 | 2-000000046-002 | true | 2024.09.24 13:52:37.746 | 2024.09.24 13:52:37.746 | 2024.09.24 13:52:37.816 | |
/home/dolphindb/server/local8848/storage | 1 | ac872f06-abed-339c-8642-ce7dcf415691 | pt1_2 | 1-000000046-001 | true | 2024.09.24 13:52:32.431 | 2024.09.24 13:52:32.431 | 2024.09.24 13:52:32.437 | |
/home/dolphindb/server/local8848/storage | 0 | ac872f06-abed-339c-8642-ce7dcf415691 | pt1_2 | 0-000000046-000 | true | 2024.09.24 11:58:42.006 | 2024.09.24 11:58:42.006 | 2024.09.24 11:58:42.011 | |
/home/dolphindb/server/local8848/storage | 0 | 62ab7ebb-03f2-10a5-5445-c537512aee06 | pt1_2 | 0-000000045-000 | true | 2024.09.24 11:57:13.596 | 2024.09.24 11:57:13.596 | 2024.09.24 11:57:13.601 |