[GitHub] [incubator-devlake] abeizn opened a new issue, #5696: [Bug][Framework] the migration process is not successful when using Postgres.

Tue, 18 Jul 2023 06:50:10 -0700 


abeizn opened a new issue, #5696:
URL: https://github.com/apache/incubator-devlake/issues/5696

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### What happened
   
   The migration process is not successful when using Postgres.
   1. ERROR: cached plan must not change result type (SQLSTATE 0A00)
   
![img_v2_89fcbde4-a095-4843-adf7-58930bd5d43g](https://github.com/apache/incubator-devlake/assets/101256042/40860f69-3ed5-400c-86f4-a9abfe5d914e)
   2. ERROR: could not idertify an ordering operator for type json 
(SQLSTATE42883)
   
![img_v2_e54d79f4-3ba2-4182-add3-93b20c96b73g](https://github.com/apache/incubator-devlake/assets/101256042/7ca8c7a5-d5af-4e84-b4c6-3857283f9a16)
   3. panic: runtime error: invalid memory address or nil pointer dereference
   
![img_v2_6131ef96-c132-4665-9e52-f032fbbee17g](https://github.com/apache/incubator-devlake/assets/101256042/a4192711-3aa3-42fa-8852-34bd63fe95d3)
   4.  ERROR: syntax error at or near (SQLSTATE 42601), that causes the process 
loop.
   
![33f7f10d-d6b8-48ca-a7e5-460ca26d89c7](https://github.com/apache/incubator-devlake/assets/101256042/7f1e3d46-e37e-4a94-ac5c-0daa2d87927d)
   
   
   ### What do you expect to happen
   
   The migration process can be successful on PostgreSQL.
   
   ### How to reproduce
   
   run devlake migration on postgres
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   v0.18.0-beta1
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to