[MCOL-2080] mcsimport hangs towards mcs system with DBRoot problems Created: 2019-01-15  Updated: 2023-10-26  Resolved: 2022-05-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-5013 Support Load data from AWS S3 : UDF... Closed
Epic Link: Consolidate & Redevelop All Columnstore Tools (SDK, Adapters, Backup, Restore, mcsimport)

 Description   

mcsimport hangs towards mcs system with DBRoot problems

expected : receive Error when run mcsimport to mcs with some internal problem

Remote tool was run towards cs single server.
command hangs and any Error is not received

  1. /usr/local/mariadb/columnstore/tools/mcsimport/mcsimport mytest lineitem lineitem1.tbl -c Columnstore.xml

On the remote side it's found that cannot insert into the table due to Internal Errors

MariaDB [(none)]> insert into mytest.lineitem1 values() ;
ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2043: An internal error occurred.  Check the error log file & contact support.

the error log from the remote cs server:

pm1 ~]# cat /var/log/mariadb/columnstore/err.log
 
Jan 15 11:06:14 pm1 joblist[12523]: 14.186697 |2147483648|0|0| C 05 CAL0000: st: 0 TupleBPS::sendPrimitiveMessages() caught an exception: IDB-2034: At least one DBRoot required for that query is offline.
 
Jan 15 11:06:14 pm1 controllernode[12523]: 14.187158 |0|0|0| C 29 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.
 
Jan 15 11:16:29 pm1 joblist[13007]: 29.427530 |2147483648|0|0| C 05 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.
 
Jan 15 11:16:29 pm1 joblist[13007]: 29.427624 |2147483648|0|0| C 05 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.
 
Jan 15 11:16:29 pm1 dmlpackageproc[13007]: 29.428497 |0|0|0| E 21 CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2043: An internal error occurred.  Check the error log file & contact support.



 Comments   
Comment by Ben Thompson (Inactive) [ 2022-05-09 ]

Newer project reference MCOL-5013 to replace mcsimport

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