Forum Discussion

baumkuchen's avatar
baumkuchen
Level 3
2 years ago

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

     

     

  • Nicolai's avatar
    Nicolai
    2 years ago

    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.

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

     vnet_cached_getaddrinfo_and_update() failed 6 0x6

     

     

  • 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's avatar
      Nicolai
      Moderator

      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.