[Bug] [Kubernetes application] task submit fail with `Table "dinky_sys_config" not found (this database is empty)`

[jasgok]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

flink version: 1.20.1
dinky version: 1.2.3

setting kubernetes application cluster according to https://www.dinky.org.cn/docs/1.1/practical_guide/run_mode_practice/dinky_k8s_quick_start

dockerfile:
FROM flink:1.20.1
COPY dinky-app-1.20-1.2.3-jar-with-dependencies.jar /opt/flink/lib/
COPY flink-table-planner_2.12-1.20.1.jar /opt/flink/lib/
COPY commons-cli-1.9.0.jar /opt/flink/lib/
RUN rm -rf /opt/flink/lib/flink-table-planner-loader-*.jar

task fail to start as nothing in h2 database, error log as below:

Caused by: org.apache.flink.client.deployment.application.ApplicationExecutionException: Could not execute application.
... 14 more
Caused by: org.apache.flink.client.program.ProgramInvocationException: The main method caused an error: Table "dinky_sys_config" not found (this database is empty); SQL statement:
SELECT * FROM dinky_sys_config [42104-232]
at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:373) ~[flink-dist-1.20.1.jar:1.20.1]
at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:223) ~[flink-dist-1.20.1.jar:1.20.1]
at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:113) ~[flink-dist-1.20.1.jar:1.20.1]
at org.apache.flink.client.deployment.application.ApplicationDispatcherBootstrap.runApplicationEntryPoint(ApplicationDispatcherBootstrap.java:301) ~[flink-dist-1.20.1.jar:1.20.1]
... 13 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "dinky_sys_config" not found (this database is empty); SQL statement:
SELECT * FROM dinky_sys_config [42104-232]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:514) ~[h2-2.3.232.jar:2.3.232]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:489) ~[h2-2.3.232.jar:2.3.232]
at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.3.232.jar:2.3.232]
at org.h2.message.DbException.get(DbException.java:199) ~[h2-2.3.232.jar:2.3.232]
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:7932) ~[h2-2.3.232.jar:2.3.232]
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:7916) ~[h2-2.3.232.jar:2.3.232]

What you expected to happen

submit and work in kubernetes application mode

How to reproduce

as described in what happen

Anything else

No response

Version

dev

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hello @jasgok, this issue is about K8S, so I assign it to @gaoyan1998 and @zackyoungh. If you have any questions, you can comment and reply.

你好 @jasgok, 这个 issue 是关于 K8S 的，所以我把它分配给了 @gaoyan1998 和 @zackyoungh。如有任何问题，可以评论回复。