yugabyte/yugabyte-db

[YSQL] yb-ctl create then ysqlsh can fail

Open

#18,620 创建于 2023年8月9日

在 GitHub 查看
 (0 评论) (0 反应) (0 负责人)C (1,003 fork)batch import
area/ysqlhelp wantedkind/bugpriority/mediumstatus/awaiting-triage

仓库指标

Star
 (8,229 star)
PR 合并指标
 (平均合并 17天 21小时) (30 天内合并 92 个 PR)

描述

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.

贡献者指南