05-21-2025 03:41 AM
When issuing the command "utils dbreplication runtimestate" three of the servers in my cluster show "N/A" in the ping column. The servers have a "2" listed in the replication column and they can be pinged from the publisher by IP and by hostname. I've tried restarting the servers but it doesn't make a difference. Does anyone have some idea of how this can be fixed? Is it something I probably don't need to worry about?
Solved! Go to Solution.
05-22-2025 04:19 AM
If everything appears normal except for the PING showing as 'N/A', I would consider this a cosmetic issue, like the TAC said, and leave it as is.
However, you should strongly consider upgrading to a latest version, as version 12.5 is reaching EOL in couple of months.
05-22-2025 08:17 AM
It turns out the issue was an MTU mismatch. These servers had to be rebuilt a little while ago, and the person that did so didn't pay attention. The MTU on the Publisher was at our organization's standard amount, but the servers that were rebuilt were at the default 1500. I'm going to be changing the MTUs with a "set" command and have been assured that there will only be a short network drop from this change.
05-21-2025 07:56 AM
I would not say that it's nothing to worry about. You should absolutely see something in that column.
05-21-2025 10:45 PM
are all your PUB & SUB servers in same Vlan/Subnet ? or in different Vlan/Subnet ?
is there a Firewall between them ? (maybe something is blocking ICMP packet between them..)
did you test ping to each other servers using CLI command ? (utils network ping ...)
also, as dear @Roger Kallberg said, you must have an output like he is shared with us..
specially you must have "Y/Y/Y" for DB/RPC/DbMon section
and you must have "(2) setup completed" for Replication details section..
05-21-2025 11:30 PM
Run the following command to check the database replication status:
utils dbreplication status
Then, execute the following to get detailed runtime state information:
utils dbreplication runtimestate
The ping value represents the round-trip time (RTT) between servers. The maximum acceptable RTT is 80 milliseconds.
Please also provide the output of the following commands:
show network cluster
utils network connectivity <IP Address>
05-22-2025 02:30 AM
Thanks for the replies folks.
Mohammadreza, the Publisher and Subscribers are all on the same subnet, and there is no firewall between them. Also, all of the servers that don't ping have a "(2) Setup Completed".
Nithin, the servers are inside the same physical chassis, so there isn't an issue with round-trip-time. My organization won't allow me to post the output from the two commands you suggested for security reasons, but I had already run them and they looked fine other than the ping issue. The fact is that I was on the line with a TAC engineer when we saw the output of "utils dbreplication runtimestate" and he didn't seem to indicate that it was any big deal at the time which is why I wondered if it was cosmetic for a 12.5 server.
I'm going to open a separate TAC case and see if it can be worked out.
05-22-2025 04:19 AM
If everything appears normal except for the PING showing as 'N/A', I would consider this a cosmetic issue, like the TAC said, and leave it as is.
However, you should strongly consider upgrading to a latest version, as version 12.5 is reaching EOL in couple of months.
05-22-2025 08:15 AM
We actually are going to be upgrading this summer.
05-22-2025 03:45 AM - edited 05-22-2025 03:49 AM
I agree with the others that this sounds like a problem. If it is possible to reboot the node in question, you could use the "utils dbreplication forcedatasyncsub" command.
05-22-2025 08:17 AM
It turns out the issue was an MTU mismatch. These servers had to be rebuilt a little while ago, and the person that did so didn't pay attention. The MTU on the Publisher was at our organization's standard amount, but the servers that were rebuilt were at the default 1500. I'm going to be changing the MTUs with a "set" command and have been assured that there will only be a short network drop from this change.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide