You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "changxue (Jira)" <ji...@apache.org> on 2022/11/02 12:46:00 UTC
[jira] [Created] (IOTDB-4839) [trigger]多个trigger叠加到一个timeseries上,插入时报错:355
changxue created IOTDB-4839:
-------------------------------
Summary: [trigger]多个trigger叠加到一个timeseries上,插入时报错:355
Key: IOTDB-4839
URL: https://issues.apache.org/jira/browse/IOTDB-4839
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: 0.14.0-SNAPSHOT
Reporter: changxue
Assignee: Yuan Tian
[trigger]多个trigger叠加到一个timeseries上,插入时报错:355
environment:
3C3D cluster , 10-31日master代码
reproduction:
在start-cli.sh模式下,依次执行以下sql
{code:java}
CREATE TIMESERIES root.sg1.d1.s1 WITH DATATYPE=DOUBLE, ENCODING=PLAIN
CREATE STATELESS TRIGGER `alert01` AFTER INSERT ON root.sg1.d1.s1 AS 'org.example.DoubleValueMonitor' WITH ( "lo" = '5' )
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (1, 0);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2, 2);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (3, 4);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (4, 6);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (5, 8);
-- 2条
select * from root.ln.alerting;
CREATE STATELESS TRIGGER `alert02` before INSERT ON root.sg1.d1.* AS 'org.example.DoubleValueMonitor' WITH ( 'lo' = '10', hi = 80 )
CREATE TIMESERIES root.sg1.d1.s2 WITH DATATYPE=DOUBLE, ENCODING=PLAIN;
INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (6,4,5.00000000000000000000000000001);
INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (7,8,4.567);
-- 从这里开始报错
INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (8,10,18);
INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (9,20,1.8);
INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (10,120,80.00000000000000000000123);
{code}
错误日志datanode:
{code:java}
2022-11-02 20:44:15,940 [pool-25-IoTDB-ClientRPC-Processor-87$20221102_124416_04406_3] INFO o.a.i.d.m.p.Coordinator:123 - [QueryStart] sql: INSERT INTO root.sg1.d1(timestamp, s1, s2) VALUES (10,120,80.00000000000000000000123)
2022-11-02 20:44:15,942 [pool-25-IoTDB-ClientRPC-Processor-87$20221102_124416_04406_3.1.0] ERROR o.a.i.d.m.p.s.FragmentInstanceDispatcherImpl:173 - dispatch write failed. status: TSStatus(code:355, message:Meet trigger error before/after the insertion, the insertion itself is completed.), message: Meet trigger error before/after the insertion, the insertion itself is completed.
2022-11-02 20:44:15,943 [pool-21-IoTDB-MPPCoordinator-4$20221102_124416_04406_3] INFO o.a.i.d.m.p.e.QueryExecution:159 - [ReleaseQueryResource] state is: FAILED {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)