Details
-
New Feature
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
None
-
2024-1
Description
cpimport creates table locks when inserting data into a columnstore table, however during a network failure in a cluster, or unforseen circumstance/hardware issue, its possible for the cpimport PID to be killed and gone, but the table lock still exist in viewtablelock.
The current workaround is to restart columnstore, during which loadbrm/rollback resolution resolves and frees the locks but the desire is for once the hardware issue is resolved, for these locks to auto resolve themselves. This will increase durability of the product and require less manual intervention to get back online.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Allen Herrera [ JIRAUSER48651 ] |
| Assignee | Allen Herrera [ JIRAUSER48651 ] | Leonid Fedorov [ JIRAUSER48443 ] |
| Sprint | 2024-1 [ 755 ] |
| Fix Version/s | 23.10.2 [ 29807 ] |
| Labels | triage |
| Zendesk Related Tickets | 201635 | |
| Zendesk active tickets | 201635 |
| Fix Version/s | 23.10.3 [ 29862 ] | |
| Fix Version/s | 23.10.2 [ 29807 ] |
| Sprint | 2024-1 [ 755 ] | 2024-1, 2024-2 [ 755, 764 ] |
| Description |
cpimport creates table locks when inserting data into a columnstore table, however
during a network failure in a cluster, or unforseen circumstance/hardware issue, its possible for the cpimport PID to be killed and gone, but the table lock still exist in viewtablelock. The current workaround is to restart columnstore, during which loadbrm/rollback resolution resolves and frees the locks but the desire is for once the hardware issue is resolved, for these locks to auto resolve themselves. This will increase durability of the product and require less manual intervention to get back online. |
cpimport creates table locks when inserting data into a columnstore table, however during a network failure in a cluster, or unforseen circumstance/hardware issue, its possible for the cpimport PID to be killed and gone, but the table lock still exist in viewtablelock.
The current workaround is to restart columnstore, during which loadbrm/rollback resolution resolves and frees the locks but the desire is for once the hardware issue is resolved, for these locks to auto resolve themselves. This will increase durability of the product and require less manual intervention to get back online. |
| Sprint | 2024-1, 2024-2 [ 755, 764 ] | 2024-1 [ 755 ] |
| Labels | triage |
| Fix Version/s | 23.10 [ 28540 ] | |
| Fix Version/s | 23.10.3 [ 29862 ] |