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
Uh oh!
There was an error while loading. Please reload this page.
-
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