[MCOL-4300] cmapi: Query failed after adding adding a new node Created: 2020-09-08  Updated: 2021-02-20

Status: Open
Project: MariaDB ColumnStore
Component/s: cmapi
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:


 Description   

Build tested: 1.5.4-1 (Drone #587), cmapi (Drone #251)

After installing the cmapi package on pm1, I was able perform the following tasks:

1. Add two nodes (the cluster is already in a functional state)
2. Create a ColumnStore database (DBT3)
3. Cpimported 100gb database
4. Executed "Select count from lineitem;"
5. Executed "Select count from lineitem where l_orderkey > 6000000;"

So far, all tasks worked fine.

Now I added another node. the same query from step 5 above failed

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [tpch100]> select count from lineitem where l_orderkey > 6000000;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in PrimitiveServer l
MariaDB [tpch100]> exit

After SHUTDOWN and START the cluster, the query worked again.

The question is after adding the first two nodes, I did not need to start or shutdown/start the cluster, why did I need to restart after the third node?

Is the restart a required step? or is it simply a bug?



 Comments   
Comment by Todd Stoffel (Inactive) [ 2021-02-20 ]

dleeyh Can you retest and close if appropriate?

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