[MCOL-1279] cpimport table lock is locking the table for too long Created: 2018-03-16  Updated: 2019-02-07  Resolved: 2019-01-12

Status: Closed
Project: MariaDB ColumnStore
Component/s: cpimport
Affects Version/s: 1.1.3, 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: BOBY PETER Assignee: Roman
Resolution: Duplicate Votes: 0
Labels: None
Environment:

REHL 7
Mariadb Version : 1.1.3

Attachments: Microsoft Word Details.docx    
Issue Links:
Duplicate
is duplicated by MCOL-1828 Failed cpimport, due to a Connection ... Closed

 Description   

Scenario: 2 UMs and 3 PMs
Mode 1: UM gets the file to CPIMPORT to all nodes.

The table lock is not cleared because, the process triggered from UM is not cleared. When UM creates a CPIMPORT to all its PM nodes, it creates a PID attached to the CPIMPORT which locks the table. It keeps it even if the cpimport is successful. May be, the acknowledgement from PMs is not reaching UM at sometimes, resulting in locked table.

Attached is the complete details.

 Comments   
Comment by Roman [ 2019-01-12 ]

Yes, both looks the same for me. I will continue with MCOL-1828

Generated at Thu Feb 08 02:27:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.