Postgresql restore fails with the error message"Failed to begin the transaction - 3"

[baumkuchen]

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.

[Nicolai · Accepted solution]

Looks like a name resolution problem - Netbackup cannot resolve the client name via DNS.

 vnet_cached_getaddrinfo_and_update() failed 6 0x6

[sanket_pathak1]

@baumkuchen 

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.

[Nicolai · Accepted solution]

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.