incubator-streampark icon indicating copy to clipboard operation
incubator-streampark copied to clipboard

[Bug] pgsql

Open hezhi3f opened this issue 1 year ago • 2 comments

Search before asking

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

Java Version

java 8

Scala Version

2.12.x

StreamPark Version

2.1.4

Flink Version

1.18.1

deploy mode

None

What happened

use pgsql

Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: ` smallint

Hint: No operator matches the given name and argument type. You might need to add an explicit type cast. Position: 134

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,exec

ution_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 (?,?))

org.apache.streampark.console.core.task.FlinkAppHttpWatcher.initialize() there is a release make error, I saw org.apache.streampark.console.base.mybatis.interceptor.PostgreSQLPrepareInterceptor handle '`'

Error Exception

No response

Screenshots

No response

Are you willing to submit PR?

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

Code of Conduct

hezhi3f avatar May 21 '24 09:05 hezhi3f

'`'

hezhi3f avatar May 21 '24 09:05 hezhi3f

org.apache.streampark.console.core.entity.Application

 @TableField("`release`")

hezhi3f avatar May 22 '24 01:05 hezhi3f

fixed. https://github.com/apache/incubator-streampark/issues/3714

wolfboys avatar May 24 '24 15:05 wolfboys