apache / apache/pulsar-manager

init environment fail

Open
#400 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Vue
Stars
539
Forks
239
PR merge metrics
No merged PRs in 30d

Description

**use pgsql init environment fail v0.2**
**expect: use META-INF\sql\postgresql-schema.sql does't use init_data.sql**
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: Failing 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**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.