[
https://issues.apache.org/jira/browse/IOTDB-4839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17628110#comment-17628110
]
liaolanyu commented on IOTDB-4839:
----------------------------------
Fixed. The implemented Trigger Class should be modified.
> [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: liaolanyu
> Priority: Major
> Attachments: DoubleValueMonitor.java,
> double-value-monitor-0.14-SNAPSHOT.jar, log_datanode_all.log
>
>
> [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)
