GPCC connectivity issue
search cancel

GPCC connectivity issue

book

Article ID: 371468

calendar_today

Updated On:

Products

VMware Tanzu Data Suite

Issue/Introduction

There is a known GPCC connectivity issue in version 6.9.1 which is due to an outdated lib/pq module which is also in GPCC version 6.10.0.

Some GPCC logs that can be found:

2024-05-07 10:56:56 [WARNING]GPSS: the connection of GPCC and GPSS broken with error(we will retry after 5s): rpc error: code = Unavailable desc = closing transport due to: connection error: desc = "error reading from server: EOF", received prior goaway: code: NO_ERROR, debug data: "graceful_stop"
2024-05-07 10:57:00 [INFO]DiskUsageSaver: finish loading data into db in 22.62 ms
2024-05-07 10:57:00 [INFO]ResGroupHistoryWriter: harvest sample data at 2024-05-07 10:57:00.509416693 +0200 CEST m=+2823642.186668151 for 160.41125ms
2024-05-07 10:57:00 [INFO]ResGroupHistoryWriter: finish loading data into db in 160.55 ms
2024-05-07 10:57:01 [WARNING]GPSS: the connection of GPCC and GPSS broken with error(we will retry after 5s): failed to create monitor job api: rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp 10.XX.XX.XX:XXXX: connect: connection refused"2024-05-07 10:57:06 [WARNING]GPSS: the connection of GPCC and GPSS broken with error(we will retry after 5s): failed to create monitor job api: rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp 10.XX.XX.XX:XXXX: connect: connection refused"
2024-05-07 10:57:10 [INFO]QueryInfoWriter: finish copy of query info: 325 1.554440391s
2024-05-07 10:57:11 [WARNING]GPSS: the connection of GPCC and GPSS broken with error(we will retry after 5s): failed to create monitor job api: rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp 10.XX.XX.XX:XXXX: connect: connection refused"
2024-05-07 10:57:15 [INFO]DatabaseHistoryWriter: harvest sample data at 2024-05-07 10:57:15.679602106 +0200 CEST m=+2823657.356853535 for 678.255666ms
2024-05-07 10:57:15 [INFO]DatabaseHistoryWriter: finish loading data into db in 678.31 ms

Resolution

Upgrade to GPCC version 6.11.1 because it has the latest update of lib/pq module and a change is included to improve the ErrBadConnection error handling.