[YSQL] yb-ctl create then ysqlsh can fail
#18.620 aberto em 9 de ago. de 2023
Métricas do repositório
- Stars
- (8.229 stars)
- Métricas de merge de PR
- (Mesclagem média 17d 21h) (92 fundiu PRs em 30d)
Description
Jira Link: DB-7546
Description
I don't know when it started happening, but I noticed yb-ctl create immediately followed by ysqlsh can fail. This was not the case before (a month or more ago). I hit this multiple times today on alma8 release build (in-progress work on top of commit 142d3cfdfab00ffd4b7bde9a8226a6be272e218a). This also resulted in a jenkins build failure on centos-clang16-debug: https://jenkins.dev.yugabyte.com/job/yugabyte-db-phabricator/177251/consoleText
[2023-08-09T01:30:30.721Z] + python bin/yb-ctl create
[2023-08-09T01:30:45.558Z] Creating cluster.
[2023-08-09T01:30:45.558Z] Waiting for cluster to be ready.
[2023-08-09T01:30:45.558Z] ----------------------------------------------------------------------------------------------------
[2023-08-09T01:30:45.558Z] | Node Count: 1 | Replication Factor: 1 |
[2023-08-09T01:30:45.558Z] ----------------------------------------------------------------------------------------------------
[2023-08-09T01:30:45.558Z] | JDBC : jdbc:postgresql://127.0.0.1:5433/yugabyte |
[2023-08-09T01:30:45.558Z] | YSQL Shell : bin/ysqlsh |
[2023-08-09T01:30:45.558Z] | YCQL Shell : bin/ycqlsh |
[2023-08-09T01:30:45.558Z] | YEDIS Shell : bin/redis-cli |
[2023-08-09T01:30:45.558Z] | Web UI : http://127.0.0.1:7000/ |
[2023-08-09T01:30:45.558Z] | Cluster Data : /root/yugabyte-data |
[2023-08-09T01:30:45.559Z] ----------------------------------------------------------------------------------------------------
[2023-08-09T01:30:45.559Z]
[2023-08-09T01:30:45.559Z] For more info, please use: yb-ctl status
[2023-08-09T01:30:45.559Z] + bin/ysqlsh -c 'create table t (k int primary key, v int);
[2023-08-09T01:30:45.559Z] insert into t values (1, 2);
[2023-08-09T01:30:45.559Z] select * from t;'
[2023-08-09T01:30:45.559Z] ysqlsh: could not connect to server: Connection refused
[2023-08-09T01:30:45.559Z] Is the server running on host "localhost" (127.0.0.1) and accepting
[2023-08-09T01:30:45.559Z] TCP/IP connections on port 5433?
[2023-08-09T01:30:45.559Z] could not connect to server: Network is unreachable
[2023-08-09T01:30:45.559Z] Is the server running on host "localhost" (::1) and accepting
[2023-08-09T01:30:45.559Z] TCP/IP connections on port 5433?
A temporary fix for jenkins build is to do a retry-loop or similar, but a better fix is to figure out why yb-ctl behaves this way.
I did not test ycqlsh.
Warning: Please confirm that this issue does not contain any sensitive information
- I confirm this issue does not contain any sensitive information.