[GitHub] [incubator-streampark] macksonmu opened a new issue, #2649: [Bug] postgresql scheme data type error

["macksonmu (via GitHub)" <gi...@apache.org>]

macksonmu opened a new issue, #2649:
URL: https://github.com/apache/incubator-streampark/issues/2649

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-streampark/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
   
   
   ### Java Version
   
   _No response_
   
   ### Scala Version
   
   2.11.x
   
   ### StreamPark Version
   
   2.0.1
   
   ### Flink Version
   
   1.16
   
   ### deploy mode
   
   None
   
   ### What happened
   
   ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: column "success" is of type smallint but expression is of type boolean 建议：You will need to rewrite or cast the expression. 位置：91 ### The error may exist in org/apache/streampark/console/core/mapper/ApplicationLogMapper.java (best guess) ### The error may involve org.apache.streampark.console.core.mapper.ApplicationLogMapper.insert-Inline ### The error occurred while setting parameters ### SQL: insert into t_flink_log ( app_id, success, option_name, option_time ) values ( ?, ?, ?, ? ) ### Cause: org.postgresql.util.PSQLException: ERROR: column "success" is of type smallint but expression is of type boolean 建议：You will need to rewrite or cast the expression. 位置：91 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "success" is of type smallint but expression is of type boolean 建议：You will need to rewrite or cast the expression. 位置：
 91
   
   ### Error Exception
   
   _No response_
   
   ### Screenshots
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!(您是否要贡献这个PR?)
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@streampark.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-streampark] wolfboys closed issue #2649: [Bug] postgresql scheme data type error

["wolfboys (via GitHub)" <gi...@apache.org>]

wolfboys closed issue #2649: [Bug] postgresql scheme data type error
URL: https://github.com/apache/incubator-streampark/issues/2649


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@streampark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org