SQL Reference
Data Definition Language (DDL)...
Distributed Tasks
you can manage distributed tasks in the {{ocient}} system these tasks are processes that run in the background of the system to keep it running smoothly and efficiently these ddl commands create tasks to rebuild damaged or missing segment data and check data integrity for information about managing these tasks, see docid\ nciheom sgkckc1rybggi create task launches a new task to create a rebuild or check disk task, you must be assigned the system administrator role syntax create task { \<rebuild segment task definition> \| \<check disk task definition> \| \<rebalance task definition> } \<rebuild segment task definition> = \[name] type rebuild \[ options ('location type' \[, 'location name' \[, \<rebuild args> ]])] \<check disk task definition> = \[name] type check disk \[ options ('location type' \[, 'location name' \[, \<check disk args> ]])] \<rebalance task definition> = \[name] type rebalance rebuilding segment task ( \<rebuild segment task definition> ) performing a rebuild segment operation reconstructs data segments by using erasure coded data in the same segment group this task allows segments that are in damaged or missing status to be restored to full performance for details about rebuild tasks, see the docid\ nzb9y1csi47ecmhwhbsay to create a rebuild segment task, you must have update privileges on the system specifying locationtype of system means every segment in the system is rebuilt alternatively, you can specify individual clusters or nodes by name to rebuild their segments 220,220,221 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type rebuild arguments ( \<rebuild args> ) additional arguments for the rebuild task these arguments must be in a valid json format all fields are optional you must specify all arguments in a single json object \<rebuild args> = '{ "node" "node name", "segment groups" segment array, "table id" "table id string" }' 152,98,410 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type checking disk task ( \<check disk task definition> ) a check disk task verifies the segments on a node by computing checksums 150,103,410 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type check disk arguments ( \<check disk args> ) arguments must be in a valid json format all fields are optional you must specify all arguments in a single json object \<check disk args> = '{ "fix" true, "sample" false, "only unhealthy"\ false, "storage ids" \["02c65e30 3651 478e 96bf 9935c1bc8fb4"] }' 151,116,410 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type examples rebuild all segments on a system create task type rebuild; create task type rebuild options ('system'); rebuild all segments on a system for a specified table with the table identifier 529a2e9d d06c 46cd a93b 624d3bed1c08 create task type rebuild options ('system', '{"table id" "529a2e9d d06c 46cd a93b 624d3bed1c08"}'); rebuild segments on foundation cluster my lts cluster1 create task type rebuild options ('cluster', 'my lts cluster1'); rebuild segments on a foundation node my node1 create task type rebuild options ('cluster', 'my lts cluster1', '{"node" "my node1"}'); rebuild segments on a segment group with the identifier 53 create task type rebuild options ('cluster', 'my lts cluster1', '{"segment groups" \[53]}'); rebuild only the segment in segment group 53 on a foundation node my node create task type rebuild options ('cluster', 'my lts cluster1', '{"node" "my node1", "segment groups" \[53]}'); compute the checksum on all segments on storage node my node1 create task type check disk options ('node', 'my node1'); compute a checksum on a sample of blocks for each segment on storage cluster my lts cluster1 create task type check disk options ('cluster', 'my lts cluster1', '{"sample" true}'); compute a checksum on all nodes in the system and modify the state based on the result create task type check disk options ('system', '{"fix" true}'); compute a checksum for a segment with storage identifier 529a2e9d d06c 46cd a93b 624d3bed1c08 on the storage node my node1 create task type check disk options ('node', 'my node1', '{"storage ids" \["529a2e9d d06c 46cd a93b 624d3bed1c08"]}'); rebalance task ( \<rebalance task definition> ) rebalancing evenly distributes data across disks in the system run this task if data is not balanced properly across the system, such as after adding additional nodes or drives for details about rebalancing, see docid\ j4kyelk3harota82ysjqo cancel task cancels a running task to cancel a task, you must be assigned the system administrator role syntax cancel task ('task name' | 'task id') 135,115,411 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example cancel a task named my task cancel task 'my task'; related links https //docs ocient com/system catalog docid\ nzb9y1csi47ecmhwhbsay