Tommu10ve opened a new issue, #2816: URL: https://github.com/apache/incubator-hugegraph/issues/2816
### Problem Type (问题类型) None ### Before submit - [x] 我已经确认现有的 [Issues](https://github.com/apache/hugegraph/issues) 与 [FAQ](https://hugegraph.apache.org/docs/guides/faq/) 中没有相同 / 重复问题 (I have confirmed and searched that there are no similar problems in the historical issue and documents) ### Environment (环境信息) - Server Version: 1.0.0 (Apache Release Version) - Backend: RocksDB x nodes, HDD or SSD - OS: xx CPUs, xx G RAM, Ubuntu 2x.x / CentOS 7.x - Data Size: xx vertices, xx edges <!-- (like 1000W 点, 9000W 边) --> ### Your Question (问题描述) ``` # # Licensed to the Apache Software Foundation (ASF) under one or more # contributor license agreements. See the NOTICE file distributed with # this work for additional information regarding copyright ownership. # The ASF licenses this file to You under the Apache License, Version 2.0 # (the "License"); you may not use this file except in compliance with # the License. You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # # TODO: reuse the configs for same type containers # User could modify the node nums and the port by themselves version: "3" services: pd0: image: hugegraph/pd container_name: pd0 hostname: pd0 network_mode: host healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8620";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-pd0.yml:/hugegraph-pd/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true pd1: image: hugegraph/pd container_name: pd1 hostname: pd1 network_mode: host healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8621";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-pd1.yml:/hugegraph-pd/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true pd2: image: hugegraph/pd container_name: pd2 hostname: pd2 network_mode: host healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8622";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-pd2.yml:/hugegraph-pd/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true store0: image: hugegraph/store container_name: store0 hostname: store0 network_mode: host depends_on: pd0: condition: service_healthy pd1: condition: service_healthy pd2: condition: service_healthy healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8520";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-store0.yml:/hugegraph-store/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true store1: image: hugegraph/store container_name: store1 hostname: store1 network_mode: host depends_on: pd0: condition: service_healthy pd1: condition: service_healthy pd2: condition: service_healthy healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8521";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-store1.yml:/hugegraph-store/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true store2: image: hugegraph/store container_name: store2 hostname: store2 network_mode: host depends_on: pd0: condition: service_healthy pd1: condition: service_healthy pd2: condition: service_healthy healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8522";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/application-store2.yml:/hugegraph-store/conf/application.yml # 容器启动时赋予该容器几乎所有的主机权限 privileged: true server1: image: hugegraph/server container_name: server1 hostname: server1 network_mode: host depends_on: store0: condition: service_healthy store1: condition: service_healthy store2: condition: service_healthy healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8081";] interval: 10s timeout: 5s retries: 3 environment: # - PRELOAD=true 为可选参数，为 True 时可以在启动的时候预加载一个内置的样例图 - PASSWORD=hugegraph@2024 volumes: - ./configs/server1-conf:/hugegraph-server/conf # 容器启动时赋予该容器几乎所有的主机权限 privileged: true server2: image: hugegraph/server container_name: server2 hostname: server2 network_mode: host depends_on: store0: condition: service_healthy store1: condition: service_healthy store2: condition: service_healthy healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8082";] interval: 10s timeout: 5s retries: 3 environment: # - PRELOAD=true 为可选参数，为 True 时可以在启动的时候预加载一个内置的样例图 - PASSWORD=hugegraph@2024 volumes: - ./configs/server2-conf:/hugegraph-server/conf # 容器启动时赋予该容器几乎所有的主机权限 privileged: true server3: image: hugegraph/server container_name: server3 hostname: server3 network_mode: host depends_on: store0: condition: service_healthy store1: condition: service_healthy store2: condition: service_healthy environment: # - PRELOAD=true 为可选参数，为 True 时可以在启动的时候预加载一个内置的样例图 - PASSWORD=hugegraph@2024 healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8083";] interval: 10s timeout: 5s retries: 3 volumes: - ./configs/server3-conf:/hugegraph-server/conf # 容器启动时赋予该容器几乎所有的主机权限 privileged: true ``` 增加 environment: - PASSWORD=hugegraph@2024 配置后 链接报错 ``` ### Error updating database. Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.CONSTRAINT_INDEX_9 ON PUBLIC.GRAPH_CONNECTION(NAME) VALUES 3"; SQL statement: INSERT INTO graph_connection ( name, graph, host, port, timeout, username, password, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) [23505-199] ### The error may exist in org/apache/hugegraph/mapper/GraphConnectionMapper.java (best guess) ### The error may involve org.apache.hugegraph.mapper.GraphConnectionMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO graph_connection ( name, graph, host, port, timeout, username, password, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.CONSTRAINT_INDEX_9 ON PUBLIC.GRAPH_CONNECTION(NAME) VALUES 3"; SQL statement: INSERT INTO graph_connection ( name, graph, host, port, timeo ut, username, password, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) [23505-199] ; Unique index or primary key violation: "PUBLIC.CONSTRAINT_INDEX_9 ON PUBLIC.GRAPH_CONNECTION(NAME) VALUES 3"; SQL statement: INSERT INTO graph_connection ( name, graph, host, port, timeout, username, password, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) [23505-199]; nested exception is org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.CONSTRAINT_INDEX_9 ON PUBLIC.GRAPH_CONNECTION(NAME) VALUES 3"; SQL statement: INSERT INTO graph_connection ( name, graph, host, port, timeout, username, password, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) [23505-199] ``` ### Vertex/Edge example (问题点 / 边数据举例) ```javascript ``` ### Schema [VertexLabel, EdgeLabel, IndexLabel] (元数据结构) ```javascript ``` -- 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...@hugegraph.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
