Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

执行knext project restore --host_addr http://127.0.0.1:8887 --proj_path . 出现问题 #89

Open
fairleehu opened this issue Nov 29, 2024 · 11 comments
Assignees

Comments

@fairleehu
Copy link

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'})
HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection;
镜像已经启动:
image

@caszkgui
Copy link
Collaborator

caszkgui commented Nov 29, 2024

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

you can adjust the mysql host,neo4j by modifying docker-compose.yml

image

@fairleehu
Copy link
Author

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

you can adjust the mysql host,neo4j by modifying docker-compose.yml

image

Thank you, it's ok.

@fairleehu
Copy link
Author

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

you can adjust the mysql host,neo4j by modifying docker-compose.yml
image

Thank you, it's ok.

还是出现了一样的问题,配置这样
image

@fairleehu
Copy link
Author

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

you can adjust the mysql host,neo4j by modifying docker-compose.yml
image

Thank you, it's ok.

还是出现了一样的问题,配置这样 image

neo4j已经可以了,没有问题。但是mysql还是不行。没动什么别的配置,都是直接现拉的镜像。大佬们看看

@andylau-55
Copy link
Collaborator

The error indicates that the mysql connection failed. Please confirm that openspg-mysql can be correctly connected in the openspg-server container. Use the default configuration of server.repository.impl.jdbc.host=mysql. If you need to change to a custom host of 10.110.3.163, you need to ensure that it can be accessed normally in the openspg-server container.

ping 10.110.3.163
telnet 10.110.3.163 3306
ping mysql
telnet mysql 3306

image

@fairleehu
Copy link
Author

The error indicates that the mysql connection failed. Please confirm that openspg-mysql can be correctly connected in the openspg-server container. Use the default configuration of server.repository.impl.jdbc.host=mysql. If you need to change to a custom host of 10.110.3.163, you need to ensure that it can be accessed normally in the openspg-server container.

ping 10.110.3.163
telnet 10.110.3.163 3306
ping mysql
telnet mysql 3306

image

what that mean? my linux has three docker containers, you say mysql server must be in the spg-server.? i use dockercompose.yam to deploy,
image

@shaoshixuan
Copy link

屏幕截图 2024-12-03 113739
初始化的时候出现了这个问题,不知道您是否能够解决

@caszkgui
Copy link
Collaborator

caszkgui commented Dec 4, 2024

The error indicates that the mysql connection failed. Please confirm that openspg-mysql can be correctly connected in the openspg-server container. Use the default configuration of server.repository.impl.jdbc.host=mysql. If you need to change to a custom host of 10.110.3.163, you need to ensure that it can be accessed normally in the openspg-server container.

ping 10.110.3.163
telnet 10.110.3.163 3306
ping mysql
telnet mysql 3306

image

what that mean? my linux has three docker containers, you say mysql server must be in the spg-server.? i use dockercompose.yam to deploy, image

The error message of Failed to obtain JDBC Connection means mysql is not accessible in your openspg -server container.
you can check accessibility by:

ping 10.110.3.163
telnet 10.110.3.163 3306

And 10.110.3.163 is the IP address of the host where the mysql container is located

@caszkgui
Copy link
Collaborator

caszkgui commented Dec 4, 2024

屏幕截图 2024-12-03 113739 初始化的时候出现了这个问题,不知道您是否能够解决

I have no idea of how this happened, maybe you can follow the user manual guide of start up and have another try.

@AIREBA1
Copy link

AIREBA1 commented Dec 4, 2024

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

you can adjust the mysql host,neo4j by modifying docker-compose.yml

image

报错问题为:HTTP response headers: HTTPHeaderDict({'Vary': 'Origin, Access-Control-Request-Method, Access-Control-Request-Headers', 'Remote': '10.88.0.13', 'Content-Type': 'application/json;charset=UTF-8', 'Transfer-Encoding': 'chunked', 'Date': 'Fri, 29 Nov 2024 09:24:18 GMT', 'Connection': 'close'}) HTTP response body: "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; 镜像已经启动: image

@AIREBA1
Copy link

AIREBA1 commented Dec 4, 2024

可以试试把3306变成其他的端口号,例如3307。报错的原因应该是和本地的mysql数据库的3306端口重复了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants