cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Replication Error - source system and target system have overlapping logical hostnames

tamil_arasan
Active Contributor
0 Kudos

Dear Experts,

We have done HANA DB failover and failback. After the failback to primary host, the replication is not working. When we tried to register secondary, we are getting the below error.

Could you please let us know how to resolve this ?

Main Error:

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.623129 e sr_nameserver    TNSClient.cpp(06963) : source system and target system have overlapping logical hostnames; each site mu

st have a unique set of logical hostnames. hdbrename can be used to change names

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.623159 e sr_nameserver    TopologyUtil.cpp(02403) : source system and target system have overlapping logical hostnames; each site

must have a unique set of logical hostnames. hdbrename can be used to change names;

Trace File:

  1. 4.7.2 20130108 [gcc-4_7-branch revision 195014]

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768200 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768218 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768240 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768244 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768246 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768247 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768249 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.768252 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.773583 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_register --name=PD1_secondary --mode=sync --remoteHos

t=<primary_host> --remoteInstance=00 --force_full_replica

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.779545 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.838826 w Environment      Environment.cpp(00356) : Changing environment set LINES=44

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.838842 w Environment      Environment.cpp(00356) : Changing environment set COLUMNS=168

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.867164 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.878997 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.881711 e sr_nameserver    TNSClient.cpp(06963) : source system and target system have overlapping logical hostnames; each site m

ust have a unique set of logical hostnames. hdbrename can be used to change names

[144680]{-1}[-1/-1] 2015-09-21 13:03:44.881747 e sr_nameserver    TopologyUtil.cpp(02403) : source system and target system have overlapping logical hostnames; each sit

e must have a unique set of logical hostnames. hdbrename can be used to change names;

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505752 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505881 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505899 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505916 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505917 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505919 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505921 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505923 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.505925 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.511128 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_register --name=PD1_secondary --mode=sync --remoteHost

=<primary_host> --remoteInstance=00 --force_full_replica

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.517053 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.576784 w Environment      Environment.cpp(00356) : Changing environment set LINES=44

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.576800 w Environment      Environment.cpp(00356) : Changing environment set COLUMNS=168

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.604526 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.618653 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.623129 e sr_nameserver    TNSClient.cpp(06963) : source system and target system have overlapping logical hostnames; each site mu

st have a unique set of logical hostnames. hdbrename can be used to change names

[12501]{-1}[-1/-1] 2015-09-21 13:13:43.623159 e sr_nameserver    TopologyUtil.cpp(02403) : source system and target system have overlapping logical hostnames; each site

must have a unique set of logical hostnames. hdbrename can be used to change names;

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920400 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920528 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920548 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920571 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920572 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920574 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920576 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920578 e Configuration    ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.920580 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.925789 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_hint --sapcontrol=1

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.931711 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.977311 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.983437 e TNS              TNSClient.cpp(00669) : sendRequest getvalue to <secondary_host>:30001 failed with NetException. data=(S)path=

/datacenters/isSource/0|

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.985934 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.988242 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.990558 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.990991 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/mappings/0/*|

[17225]{-1}[-1/-1] 2015-09-21 13:16:25.993297 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709089 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709216 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709236 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709252 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709254 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709256 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709258 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709260 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.709262 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.714514 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_state --sapcontrol=1

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.720488 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.764431 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[17310]{-1}[-1/-1] 2015-09-21 13:16:28.772068 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985113 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985243 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985263 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985279 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985281 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985283 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985284 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985287 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.985289 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.990518 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_hint --sapcontrol=1

[17403]{-1}[-1/-1] 2015-09-21 13:16:32.996545 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.040392 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.046175 e TNS              TNSClient.cpp(00669) : sendRequest getvalue to <secondary_host>:30001 failed with NetException. data=(S)path=

/datacenters/isSource/0|

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.048649 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.050959 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.053293 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.053730 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/mappings/0/*|

[17403]{-1}[-1/-1] 2015-09-21 13:16:33.056008 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751265 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751389 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751409 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751427 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751428 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751430 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751432 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751434 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.751436 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.756654 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_state --sapcontrol=1

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.762582 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.806080 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[17486]{-1}[-1/-1] 2015-09-21 13:16:35.813532 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434270 i Basis            TraceStream.cpp(00467) : ==== Starting hdbnsutil, version 1.00.095.00.1429086950 (fa/newdb100_rel), bui

ld linuxx86_64 9a90dc475042e305cd4edc5c078f34b708ffce42 2015-04-15 10:44:35 ld7337.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4

.7.2 20130108 [gcc-4_7-branch revision 195014]

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434392 i Basis            TraceStream.cpp(00469) : MaxOpenFiles: 1048576

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434412 i Basis            TraceStream.cpp(00472) : Server Mode: L2 Delta

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434429 i Basis            ProcessorInfo.cpp(00713) : Using GDT segment limit to determine current CPU ID

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434430 i Basis            Timer.cpp(00650) : Using RDTSC for HR timer

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434432 i Memory           AllocatorImpl.cpp(01334) : Allocators activated

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434434 i Memory           AllocatorImpl.cpp(01350) : Using big block segment size 67108864

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434436 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.434438 e Configuration ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.439665 i Basis            TopologyUtil.cpp(03973) : command: hdbnsutil -sr_state

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.445678 w Environment      Environment.cpp(00383) : Changing environment set SSL_WITH_OPENSSL=0

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.489976 e ipc              TrexIpc.cpp(00462) : SHM_ATTACH failed: 3,2,No such file or directory

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.530859 w Environment      Environment.cpp(00356) : Changing environment set LINES=44

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.530876 w Environment      Environment.cpp(00356) : Changing environment set COLUMNS=168

[35911]{-1}[-1/-1] 2015-09-21 13:26:01.540699 e TNS              TNSClient.cpp(00669) : sendRequest querytree to <secondary_host>:30001 failed with NetException. data=(I)mode

=0|(N)query=/datacenters/takeover/*|logpos=*|

Thanks and regards,

Pradeep

View Entire Topic
tamil_arasan
Active Contributor
0 Kudos

Dear All,

Issue has been resolved by editing the the nameserver.ini file in secondary host.


Change was done by HP support team as below,

Old Entry : roles_<primary-host> = worker


Update one: roles_<secondary-host> = worker

Thanks all,

Pradeep

former_member185954
Active Contributor
0 Kudos

Ah, missed that key part.