[IOTDB-4343] [master]After starting mqtt, after executing Trigger's SQL, there is an NPE error in the log

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master branch, 0.14.0-SNAPSHOT
• Fix Version/s: 0.14.0, 0.13.3
• Component/s: Core/Server
• Labels: pull-request-available
• Sprint: 2022-9-Cluster
• Assignee: Hongyin Zhang
• Reporter: xiaozhihong
• Created: 06/Sep/22 02:26
• Updated: 17/Nov/22 02:56
• Resolved: 07/Sep/22 09:59

Description

commit 518dcfbfa461ffe4912fba18cb29299416301588

After enabling MQTT, execute the trigger use case, and find that there is an NPE authorization authentication error in the log.

Step 1: In the iotdb-datanode.properties ,modify parameter:
enable_mqtt_service=true
Step 2: Start server, Enter CLI

Step 3: Execute SQL:

set storage group to root.sg1;
CREATE TIMESERIES root.sg1.dev1.s_1 WITH DATATYPE=INT32, ENCODING=GORILLA;
CREATE TIMESERIES root.sg1.dev1.s_2 WITH DATATYPE=INT64, ENCODING=PLAIN;
CREATE TIMESERIES root.sg1.dev1.s_3 WITH DATATYPE=float, ENCODING=RLE;
CREATE TIMESERIES root.sg1.dev1.s_4 WITH DATATYPE=double, ENCODING=TS_2DIFF;
CREATE TIMESERIES root.sg1.dev1.s_5 WITH DATATYPE=text, ENCODING=DICTIONARY;
CREATE TIMESERIES root.sg1.dev1.s_6 WITH DATATYPE=boolean, ENCODING=PLAIN;

CREATE TRIGGER trig1
AFTER INSERT
ON root.sg1.dev1.s_1
AS 'TriggerTest'
WITH (
  'ts_type' = 'int32',
  'remote_ip' = '127.0.0.1',
  'trig_name'='trig1'
);

CREATE TRIGGER trig2
AFTER INSERT
ON root.sg1.dev1.s_2
AS 'TriggerTest'
WITH (
  'ts_type' = 'int64',
  'remote_ip' = '127.0.0.1',
  'trig_name'='trig2'
);

insert into root.sg1.dev1(time,s_1,s_2) values(1,100,200);
insert into root.sg1.dev1(time,s_1,s_2) values(2,300,400);

select s_1,s_2,s_3,s_4,s_5,s_6 from root.sg1.dev1;
select local_trig1,local_trig2,remotetrig1,remotetrig2 from root.target.alerting; 
  
delete timeseries root.sg1.dev1.s_1;
insert into root.sg1.dev1(time,s_2) values(100,1600);

Issue Links

• is duplicated by: IOTDB-2789 [Trigger] Status code: EXECUTE_STATEMENT_ERROR(400), operation: checkAuthority failed
• links to: GitHub Pull Request #7247
• links to: GitHub Pull Request #7249