[Bug] Table 'streampark.t_flink_app' doesn't exist

[HungPhann]

Search before asking

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

Java Version

No response

Scala Version

2.11.x

StreamPark Version

2.1.5

Flink Version

1.20.0

Deploy mode

kubernetes-application

What happened

I'm deploying StreamPark in K8s with Helm.
I'm encountering this error from StreamPark pods:

### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'streampark.t_flink_app' doesn't exist
### The error may exist in org/apache/streampark/console/core/mapper/ApplicationMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT  id,team_id,job_type,project_id,user_id,job_name,job_id,job_manager_url,version_id,cluster_id,flink_image,k8s_namespace,state,`release`,build,restart_size,restart_count,option_state,alert_id,args,module,options,hot_params,resolve_order,execution_mode,dynamic_properties,app_type,tracking,jar,jar_check_sum,main_class,dependency,start_time,end_time,duration,cp_max_failure_interval,cp_failure_rate_interval,cp_failure_action,TOTAL_TM,total_slot,available_slot,jm_memory,tm_memory,total_task,flink_cluster_id,create_time,option_time,modify_time,k8s_rest_exposed_type,k8s_pod_template,k8s_jm_pod_template,k8s_tm_pod_template,ingress_template,default_mode_ingress,resource_from,k8s_hadoop_integration,tags,description  FROM t_flink_app     WHERE (tracking = ? AND execution_mode NOT IN (?,?))
### Cause: java.sql.SQLSyntaxErrorException: Table 'streampark.t_flink_app' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'streampark.t_flink_app' doesn't exist

I want to check if StreamPart itself will initialize MySQL database or StreamPark admin needs to do that. If it's the later case, is there any scripts admin can use to do it?

Thank you!

Error Exception

Screenshots

Are you willing to submit PR?

• Yes I am willing to submit a PR!(您是否要贡献这个PR?)

Code of Conduct

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