Empty return for the show slave status or show replica status command

Products

• CA API Gateway

Issue/Introduction

The log showed error: 

2025-04-07T11:30:20.594-0500 WARNING 82 com.l7tech.server.cluster.DatabaseReplicationMonitor: 2380: Error accessing host/database <server name>/ssg: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions

 

When I try to execute show slave status on this gateway node, i do not see any output. Please find below.

mysql> show slave status\G;
Empty set, 1 warning (0.00 sec)

ERROR:
No query specified

Environment

API Gateway ssg 11.x

Cause

replication master did not set

Resolution

Stop replication:

sudo mysqladmin stop-replica

Run MySQL: 

CHANGE MASTER TO MASTER_HOST=<full host name>

and restart the replication:  

sudo mysqladmin start-replica