[GitHub] [dolphinscheduler] gt199899 commented on issue #4650: [Bug][Api] Process definition create, update and copy error in PostgreSQL

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

gt199899 commented on issue #4650:
URL: https://github.com/apache/dolphinscheduler/issues/4650#issuecomment-1006262928


   > Unfortunately, I meet this error with the latest version (2.0.1) via bootstrapping with docker compose.
   > 
   > ```shell
   > 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.
   
   select * from t_ds_process_definition_id_sequence；
   
   same with me, any suggestion?


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