Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
-
None
-
single server
Description
cleartablelock is allowed during mcsapi transaction but it breaks with what(): Error rolling back BRM and cannot be restarted
note: the same is not observed with cpimport as cleartablelock is rejected during cpimport activities with error" Rollback error: Unable to grab lock; Lock not found or still in use.Table lock xxx for table xx.yy is not cleared."
/usr/local/mariadb/columnstore/tools/mcsimport/mcsimport mytest lineitem tests/tests_2019-01-17--16-44-30_LOAD_DATA_IN_FILE/features/cpimportLineitem/lineitem.tbl -c Columnstore.xml -d "|"
|
from CS Module
[root@pm1 ~]# /usr/local/mariadb/columnstore/bin/viewtablelock
|
There is 1 table lock
|
|
|
Table LockID Process PID Session Txn CreationTime State DBRoots
|
mytest.lineitem 51 mcsapi 11786 73608 7599 Fri Jan 18 15:57:28 2019 LOADING 1
|
[root@pm1 ~]# /usr/local/mariadb/columnstore/bin/cleartablelock 51
|
Rolling back and clearing table lock for table mytest.lineitem; table lock 51
|
|
|
Sending rollback request to PM1...
|
Successful rollback response from PM1
|
Sending cleanup request to PM1...
|
Successful cleanup response from PM1
|
|
|
Table lock 51 for table mytest.lineitem is cleared.
|
[root@pm1 ~]#
|
|
/usr/local/mariadb/columnstore/tools/mcsimport/mcsimport mytest lineitem tests/tests_2019-01-17--16-44-30_LOAD_DATA_IN_FILE/features/cpimportLineitem/lineitem.tbl -c Columnstore.xml -d "|"
|
Error during mcsapi bulk operation: Failed to read from a compressed data file.
|
terminate called after throwing an instance of 'mcsapi::ColumnStoreServerError'
|
what(): Error rolling back BRM
|
Aborted
|
|
|