[GitHub] [dolphinscheduler] icexxxxxx edited a comment on issue #4650: [Bug][Api] Process definition create, update and copy error in PostgreSQL

[GitBox <gi...@apache.org>]

icexxxxxx edited a comment on issue #4650:
URL: https://github.com/apache/dolphinscheduler/issues/4650#issuecomment-1004574574


   Unfortunately, I meet this error with the latest version (2.0.1) via bootstrapping with docker compose.
   
   ```bash
   Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint
     Detail: Failing row contains (null, 4076540669184, test, 1, desc, 4074888816256, 1, SHELL, {"resourceList":[],"localParams":[],"rawScript":"echo \"bala\";"..., 1, 0, test worker, -1, 0, 1, 0, 0, 0, 0, , 2022-01-04 14:55:41.81, 2022-01-04 14:55:41.81).
           at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
           at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
           at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
           at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
           at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
           at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
           at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132)
           at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
           at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
           at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
           at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:498)
           at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
           at com.sun.proxy.$Proxy175.update(Unknown Source)
           at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
           at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
           at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
           at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:498)
           at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
           ... 118 common frames omitted
   ```
   
   
   I followed the document [QuickStart in Docker](https://dolphinscheduler.apache.org/en-us/docs/latest/user_doc/guide/installation/docker.html) tightly, however failed.
   
   


-- 
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: commits-unsubscribe@dolphinscheduler.apache.org

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