[jira] [Created] (IOTDB-5957) Failed to insert into the alias series on the first attempt, succeeded on the second attempt

[Jira]

刘珍 created IOTDB-5957:
-------------------------

             Summary: Failed to insert into the alias series on the first 
attempt, succeeded on the second attempt
                 Key: IOTDB-5957
                 URL: https://issues.apache.org/jira/browse/IOTDB-5957
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Server, mpp-cluster
    Affects Versions: 1.2
            Reporter: 刘珍
            Assignee: Xingyu Liu
         Attachments: image-2023-05-31-16-47-58-799.png

问题描述：向别名序列insert，相同的SQL，第一次执行报错，第2次执行成功。
测试版本：iotdb_master_0531_fc2746e]

drop database root.1Y ;
drop database root.0Y ;
create database root.1Y ;
create database root.0Y ;
create ALIGNED timeseries root.1Y.2MO(1Y DOUBLE compressor=SNAPPY,2MO DOUBLE 
ENCODING=RLE compressor=LZ4,3W DOUBLE ENCODING=TS_2DIFF compressor=GZIP,4D 
DOUBLE ENCODING=GORILLA compressor=ZSTD,5H DOUBLE ENCODING=FREQ 
compressor=LZMA2,6M DOUBLE ENCODING=CHIMP compressor=UNCOMPRESSED,7S DOUBLE 
ENCODING=SPRINTZ compressor=LZ4,8MS DOUBLE ENCODING=RLBE compressor=GZIP,9US 
DOUBLE compressor=ZSTD,10NS DOUBLE compressor=LZMA2,11ns DOUBLE 
compressor=SNAPPY,12us DOUBLE compressor=UNCOMPRESSED) ;
insert into root.1Y.2MO(time,1Y) ALIGNED values(1,1.1);
insert into root.1Y.2MO(time,2MO) ALIGNED values(1,1.1);
insert into root.1Y.2MO(time,3W) ALIGNED values(2,2.1);
insert into root.1Y.2MO(time,4D) ALIGNED values(2,2.1);
insert into root.1Y.2MO(time,5H) ALIGNED values(3,3.1);
insert into root.1Y.2MO(time,6M) ALIGNED values(3,3.1);
insert into root.1Y.2MO(time,7S) ALIGNED values(4,4.1);
insert into root.1Y.2MO(time,8MS) ALIGNED values(4,4.1);
insert into root.1Y.2MO(time,9US) ALIGNED values(5,5.1);
insert into root.1Y.2MO(time,10NS) ALIGNED values(5,5.1);
insert into root.1Y.2MO(time,11ns) ALIGNED values(6,6.1);
insert into root.1Y.2MO(time,12us) ALIGNED values(6,6.1);
select * from root.1Y.2MO;
flush;
select * from root.1Y.2MO;
create view root.0Y.2MO(1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us 
) as root.1Y.2MO(1Y,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us );
select 1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us from 
root.1Y.**,root.0Y.**;
下面的2条sql在cli 串行执行。
insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns 
,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns 
,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
 !image-2023-05-31-16-47-58-799.png! 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)