09-06-2023 12:32 AM
Hi, i'm trying to run a restore on postgresql DB and having a error message "Failed to begin the transaction -3"
Anyone can give solution for this?
--------------------------------------------------------------------------------LOGS------------------------------------------------------------16:15:10.961 [9906] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=testpgsql2 SVC=NULL
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1420] vnet_cached_getaddrinfo_and_update() failed 6 0x6
16:15:10.961 [9906] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3095] vnet_cached_getaddrinfo() failed STAT=6 RV=-2 NAME1=testpgsql2
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1697] in failed cache ERR=-2 NAME=testpgsql2 SVC=NULL
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1420] vnet_cached_getaddrinfo_and_update() failed 6 0x6
16:15:10.961 [9906] <8> vnet_is_local_host: [vnet_addrinfo.c:347] vnet_cached_getaddrinfo() failed STAT=6 RV=-2 NAME=testpgsql2
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1697] in failed cache ERR=-2 NAME=testpgsql2 SVC=NULL
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1420] vnet_cached_getaddrinfo_and_update() failed 6 0x6
16:15:10.961 [9906] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3095] vnet_cached_getaddrinfo() failed STAT=6 RV=-2 NAME1=testpgsql2
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1697] in failed cache ERR=-2 NAME=testpgsql2 SVC=NULL
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1420] vnet_cached_getaddrinfo_and_update() failed 6 0x6
16:15:10.961 [9906] <8> vnet_is_local_host: [vnet_addrinfo.c:347] vnet_cached_getaddrinfo() failed STAT=6 RV=-2 NAME=testpgsql2
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1697] in failed cache ERR=-2 NAME=testpgsql2 SVC=NULL
16:15:10.961 [9906] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1420] vnet_cached_getaddrinfo_and_update() failed 6 0x6
16:15:10.961 [9906] <8> init_connect_recs: [vnet_connect.c:1096] vnet_cached_getaddrinfo() failed STAT=6 RV=-2 HOST=testpgsql2
16:15:10.961 [9906] <8> connect_to_service: [vnet_connect.c:879] init_connect_recs() failed 6 0x6
16:15:10.961 [9906] <16> connect_to_service: JSON data = {"allow_large_status": {"timestamp": 1693984510, "who": "vnet_tss_init", "line_number": 32, "comment": "allow vnet status > 255", "data": false}, "direct_connect": {"timestamp": 1693984510, "who": "connect_to_service", "line_number": 834, "comment": "connect parameters", "data": {"who": "vnet_connect_to_service", "host": "testpgsql2", "service": "bprd", "override_required_interface": null, "extra_tries_on_connect": 0, "getsock_disable_to": 0, "overide_connect_timeout": 0, "connect_options": null}}, "status": {"timestamp": 1693984510, "who": "connect_to_service", "line_number": 981, "comment": "vnet status", "data": 6}}
16:15:10.961 [9906] <8> vnet_connect_to_service: [vnet_connect.c:286] connect_to_service() failed 6 0x6
16:15:10.961 [9906] <2> bprd_connect: vnet_connect_to_service(testpgsql2) failed: 6
16:15:10.961 [9906] <2> bprd_get_features: bprd_connect(testpgsql2) failed, cannot connect on socket (25)
16:15:10.961 [9906] <16> bsa_checkFeatureId: unable to check if feature <46> is licensed
16:15:10.961 [9906] <16> bsa_checkFeatureId: Server exit status = 25: cannot connect on socket
16:15:10.961 [9906] <16> Restore: BSABeginTxn: Unknown XBSA Error
16:15:10.961 [9906] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.
Solved! Go to Solution.
09-06-2023 01:30 AM - edited 09-06-2023 03:59 AM
Looks like a name resolution problem - Netbackup cannot resolve the client name via DNS.
vnet_cached_getaddrinfo_and_update() failed 6 0x6
09-06-2023 11:57 PM
Netbackup first tried 1556 (PBX) , then 13724 (vnetd) and then 13720 (bpcd).
For connectivity test try using bptestbpcd from master server, media server AND from client to master server.
09-06-2023 01:30 AM - edited 09-06-2023 03:59 AM
Looks like a name resolution problem - Netbackup cannot resolve the client name via DNS.
vnet_cached_getaddrinfo_and_update() failed 6 0x6
09-06-2023 07:39 AM
In addition to what @Nicolai stated... following string also catches my attention which is potentially a port connection failure.
16:15:10.961 [9906] <2> bprd_get_features: bprd_connect(testpgsql2) failed, cannot connect on socket (25)
DB servers makes connection with Primary Server over Port 1556 and 13720 (bprd). Validate if both ports are opened to Primary server. My suspicion is more on 13720 (bprd).
Hope it helps.
09-06-2023 11:57 PM
Netbackup first tried 1556 (PBX) , then 13724 (vnetd) and then 13720 (bpcd).
For connectivity test try using bptestbpcd from master server, media server AND from client to master server.