:Partitioning plan tasks

Background

OceanBase Developer Center (ODC) allows users to apply for permissions on partitioning plans from the administrator of the public resource console.

After a user creates a partitioning plan task in Task Center, the administrator can approve the task on the Tasks page in Task Center. The user can view the task information and approval status on the Tasks page in Task Center.

Task list

After you enter the target database connection, click Task Center in the top navigation bar to open the Task Center panel. Click the Partition Plan tab to view the partitioning plan tasks.

The following table describes the columns contained in the task list on this tab. You can filter and sort the tasks in the list.

Create a partitioning plan task

1. In the task center panel that pops up, click + on the right side of Partition Plan, and a new partitioning plan panel will pop up.

2. In the Create a partition plan panel, specify the following information.

   Parameter	Description
   Connection	The connection to which the partitioning plan belongs. The default value is the current connection.
   Partition policy	The information about the partitioning strategy. Search for and select a RANGE-partitioned table in the database and edit its partitioning strategy. You can select Only tables that are not set are displayed on the right side of Partition policy to display only tables with no partitioning strategies. You can also select multiple RANGE-partitioned tables and configure a partitioning strategy for them at a time. In the Partition policy column, click the edit icon and then you can edit the number of partitions to create, partitioning interval, retention period, and naming rules.
   Remarks (Optional)	Enter the reason for application.

3. Click Submit.

   Note

   After you submit the application, the task will automatically match the default partitioning plan task application process in the public resource console. For more information about task processes, see Manage task processes.

View a partitioning plan task*

Task information

1. Click Task Center in the top navigation bar, and click the Partition Plan tab. In the task list on the tab, click View in the Actions column of the target task to view its details.

2. In the Task Details panel, click the Task Information tab and view the basic task information and task settings.

   Item	Description
   Basic task information	You can view the task status, task ID, task type, connection, inspection cycle, remarks, creator, and creation time.
   Task settings	You can view the partitioning strategy of the RANGE-partitioned table selected when you created the partitioning plan task.

3. In the task information panel, click Initiate Again in the lower-right corner to initiate the task again.

Task Process

1. In the Task Details panel, click the Task Process tab to view information about the task process, including the task initiation information, approval status, execution status, and completion status.

2. You can click Initiate Again in the lower-right corner of the panel to re-initiate the task.

Associated records

1. In the Task Details panel, click the Associated Records tab to view information including the task ID, database, creation time, task status, and supported actions such as view.

2. You can click Initiate Again in the lower-right corner of the panel to initiate the task again.

Task logs

1. In the Task Details panel, click the Task Logs tab and view all logs and alert logs of the task.

   Item	Description
   All Logs	Displays the INFO, ERROR, and WARN logs of the task. You can click Find, Download, or Copy to search for, download, or copy all logs.
   Alert Logs	Displays the ERROR and WARN logs of the task. When a task fails, you can view the error message in the alert logs. You can click Find, Download, or Copy to search for, download, or copy alert logs.

2. Click Initiate Again to initiate the task again.

Related topics

• Manage task processes

• Partitioning plan