error occurs when executing the sql statement of the POSTGRESQL database #978
Unanswered
wtttt123456
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
the log is as follows:
[INFO] 2022-11-07 16:31:10.243 +0800 [taskAppId=TASK-20221107-17078_1-396714-845861] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[394] - Sql Params are replaced sql , parameters:circ_pi(VARCHAR)localapp_circ_pi(VARCHAR)
[INFO] 2022-11-07 16:31:10.243 +0800 [taskAppId=TASK-20221107-17078_1-396714-845861] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[463] - can't find udf function resource
[ERROR] 2022-11-07 16:31:10.244 +0800 [taskAppId=TASK-20221107-17078_1-396714-845861] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[211] - execute sql error: SQL task prepareStatementAndBind error
[ERROR] 2022-11-07 16:31:10.246 +0800 [taskAppId=TASK-20221107-17078_1-396714-845861] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[164] - sql task error
org.apache.dolphinscheduler.plugin.task.api.TaskException: SQL task prepareStatementAndBind error
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.prepareStatementAndBind(SqlTask.java:370)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeUpdate(SqlTask.java:304)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:202)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:158)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:208)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:57)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: 栏位索引超过许可范围:1,栏位数:0。
at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:133)
at org.postgresql.jdbc.PgPreparedStatement.bindString(PgPreparedStatement.java:1064)
at org.postgresql.jdbc.PgPreparedStatement.setString(PgPreparedStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.setString(PgPreparedStatement.java:351)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setString(HikariProxyPreparedStatement.java)
at org.apache.dolphinscheduler.plugin.task.api.parser.ParameterUtils.setInParameter(ParameterUtils.java:135)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.prepareStatementAndBind(SqlTask.java:364)
... 11 common frames omitted
Beta Was this translation helpful? Give feedback.
All reactions