[MCOL-5558] analyze and restore regr test for nightly develop Created: 2023-08-21  Updated: 2023-09-12  Resolved: 2023-09-12

Status: Closed
Project: MariaDB ColumnStore
Component/s: regression suite
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Kirill Perov Assignee: Kirill Perov
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2023-8, 2023-10

 Description   

analyze and restore regr test for nightly develop



 Comments   
Comment by Kirill Perov [ 2023-08-29 ]

What I found for now:
test005 query 'bug3040d' failed at drone because cpimport loads strange data into table.
table t1 (c1 char(1))
loaded file = '12|\n'
c1 contains '1' but "select * from t1 where c1='1'" returns empty set
select * from t1 where c1 like '1%' works well - returns rows where c1='1'
table charset is utf, engine=columnstore, OS = centos7, MCS = develop from 27 Aug 2023

same problem not happens at ubuntu 22 VM

Comment by Kirill Perov [ 2023-08-29 ]

dleeyh It looks like all test queries where default charset latin was used should be extended with charset utf so doubling number of tables/tested queries, instead of just setting creation table to latin. Probably Gagan already added some such queries.

Comment by Kirill Perov [ 2023-09-01 ]

I have checked that bug mentioned in comment above is fixed by branch MCOL-4931.

Comment by Kirill Perov [ 2023-09-04 ]

Now at drone global variable lower_case_table_names = 1. (I expect it was 0 before).
This possibly leads to cpimport can not find tables.
Tables are created with capital letters but become lower-letters. Cpimport is trying to use tables with capital letters but can not find them.
Test011 is failing now because of it.

tntnatbry, leonid.fedorov, dleeyh - FYI

I see lower_case_table_names=1 is long ago for drone. And test011 is started to fail at Aug,16.

Comment by Kirill Perov [ 2023-09-05 ]

test300 is stuck because of mcsSetConfig SystemConfig DataFilePlugin "libcloudio.so" 2>&1
after it columnstore service could not start
if it is disabled, service is started

echo "enabling storagemanager" > $TEST.status
echo "enabling storagemanager 1"
shutdownSystem
echo "enabling storagemanager 2"
mcsSetConfig StorageManager Enabled Y 2>&1
echo "enabling storagemanager 3"
mcsSetConfig Installation DBRootStorageType storagemanager 2>&1
echo "enabling storagemanager 4"
<#> mcsSetConfig SystemConfig DataFilePlugin "libcloudio.so" 2>&1
echo "enabling storagemanager 5"
mcsSetConfig -x SystemConfig DataFileEnvFile N 2>&1
echo "enabling storagemanager 6"
startSystem
echo "storagemanager enabled" > $TEST.status
echo "storagemanager enabled"

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