[GitHub] [pulsar-manager] penghuizhang opened a new issue #400: init environment fail

[GitBox]

penghuizhang opened a new issue #400:
URL: https://github.com/apache/pulsar-manager/issues/400


   use pgsql init environment fail  v0.2
   
   docker run -it -d \
       -p 9527:9527 -p 7750:7750 \
       -e 
SPRING_CONFIGURATION_FILE=/pulsar-manager/pulsar-manager/application.properties 
\
       apachepulsar/pulsar-manager:v0.2.0
   
   `error: "Internal Server Error"
   message: "\n### Error updating database.  Cause: 
org.postgresql.util.PSQLException: ERROR: null value in column \"bookie\" 
violates not-null constraint\n  Detail: Failing row contains (env, 
http://192.168.33.11:8080, null).\n### The error may exist in 
org/apache/pulsar/manager/mapper/EnvironmentsMapper.java (best guess)\n### The 
error may involve 
org.apache.pulsar.manager.mapper.EnvironmentsMapper.insert-Inline\n### The 
error occurred while setting parameters\n### SQL: INSERT INTO 
environments(name,broker) VALUES(?,?)\n### Cause: 
org.postgresql.util.PSQLException: ERROR: null value in column \"bookie\" 
violates not-null constraint\n  Detail: Failing row contains (env, 
http://192.168.33.11:8080, null).\n; ]; ERROR: null value in column \"bookie\" 
violates not-null constraint\n  Detail: Failing row contains (env, 
http://192.168.33.11:8080, null).; nested exception is 
org.postgresql.util.PSQLException: ERROR: null value in column \"bookie\" 
violates not-null constraint\n  Detail: Fai
 ling row contains (env, http://192.168.33.11:8080, null)."
   path: "/pulsar-manager/environments/environment"
   status: 500
   timestamp: "2021-06-29T13:51:11.275+0000"`
   
   url: http://192.168.33.11:9527/pulsar-manager/environments/environment
   post data：{name: "env", broker: "http://192.168.33.11:8080"}
   but use original init_data.sql is not have bookie propertity
   
   however springboot META-INF\sql\postgresql-schema.sql   have bookie field
   
   **My conclusion is that the front end is not exactly matched in the code of 
6.22, which leads to the failure of adding environment**
   


-- 
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: dev-unsubscr...@pulsar.apache.org

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