Postgresql restore fails with the error message"Failed to begin the transaction - 3"
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.
Looks like a name resolution problem - Netbackup cannot resolve the client name via DNS.
vnet_cached_getaddrinfo_and_update() failed 6 0x6
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.