fhygh commented on issue #10392:
URL:
https://github.com/apache/dolphinscheduler/issues/10392#issuecomment-1151801945
here is the log:
`
[LOG-PATH]:
/data/apache-dolphinscheduler-3.0.0-beta-1-bin/worker-server/logs/20220610/5803827748480_10-155-217.log,
[HOST]: Host{address='xxxx:1234', ip='xxxx', port=1234}
[INFO] 2022-06-10 08:46:55.800 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[120] - Full sql
parameters: SqlParameters{type='MYSQL', datasource=1, sql='select name from
test.userinfo1 where name in (${name})', sqlType=0, sendEmail=null,
displayRows=10, limit=0, segmentSeparator=, udfs='null', showType='null',
connParams='null', groupId='0', title='null', preStatements=[],
postStatements=[]}
[INFO] 2022-06-10 08:46:55.801 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[121] - sql type : MYSQL,
datasource : 1, sql : select name from test.userinfo1 where name in (${name}) ,
localParams : [],udfs : null,showType : null,connParams : null,varPool :
[Property{prop='name', direct=IN, type=LIST, value='["lisi","zhangsan"]'}]
,query max result limit 0
[INFO] 2022-06-10 08:46:55.802 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[91] - setSqlParamsMap:
Property with paramName: name put in sqlParamsMap of content
select name from test.userinfo1 where name in (${name}) successfully.
[INFO] 2022-06-10 08:46:55.802 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[387] - after replace sql ,
preparing :
select name from test.userinfo1 where name in (?)
[INFO] 2022-06-10 08:46:55.802 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[396] - Sql Params are
replaced sql , parameters:["lisi","zhangsan"](LIST)
[INFO] 2022-06-10 08:46:55.802 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[465] - can't find udf
function resource
[INFO] 2022-06-10 08:46:55.804 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[369] - prepare statement
replace sql : HikariProxyPreparedStatement@1139720980 wrapping
com.mysql.cj.jdbc.ClientPreparedStatement:
select name from test.userinfo1 where name in (** NOT SPECIFIED **)
[INFO] 2022-06-10 08:46:55.805 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[297] - main statement
execute query, for sql:
select name from test.userinfo1 where name in (?)
[ERROR] 2022-06-10 08:46:55.805 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[213] - execute sql error:
No value specified for parameter 1
[ERROR] 2022-06-10 08:46:55.805 +0800
[taskAppId=TASK-20220610-5803827748480_10-155-217] TaskLogLogger-class
org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[164] - sql task error:
java.sql.SQLException: No value specified for parameter 1
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
