Article ID: 127858, created on Dec 25, 2015, last review on Nov 29, 2016

  • Applies to:
  • Operations Automation 7.0
  • Business Automation 5.5
  • Business Automation 6.0

Symptoms

The symptoms may vary:

  • failed tasks with ODBC-related errors:

PSSDBImpl: your call failed due to database server connectivity problem. The application has restored the connection. Please, retry your call.

Execution Failed: server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request."

  • CP availability issues with the same errors in the logs.
  • In the online store domains are shown as unavailable for registration, logs show connection error, e.g:

    [15-10-01 10:24:20.324 OPENSRS_Obj RQ00000 TH24894 NTE] Entering method OPENSRS.CheckAvailability(user = -1, SID = 0, lang = en, request = 0, localObject = 1, transaction = 0 (HP))
    [15-10-01 10:24:20.324 OPENSRS_Obj RQ00000 TH24894 TRC]  +++[1] ItemResult* OPENSRS::CheckAvailability(Int, Str)()
    [15-10-01 10:24:20.325 generic_wor RQ00000 TH24894 DBG] [16072] Loading readonly a row (RegistrarID=11) in table OpenSRSConf
    [15-10-01 10:24:20.325 RDBMS       RQ00000 TH24894 INF] Prepare [0x7f4908014390]: SELECT "RegistrarID", "UID", "Pass", "TechContactMode", "Mode", "TestHost", "TestPort", "RealHost", "RealPort", "UserArc", "DateArc" FROM "OpenSRSConf" WHERE "RegistrarID" = $1
    [15-10-01 10:24:20.326 RDBMS       RQ00000 TH24894 NTE] Code: 1000. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
    [15-10-01 10:24:20.326 OPENSRS_Obj RQ00000 TH24894 TRC]  ...[1] *** INTERRUPTED BY EXCEPTION *** ItemResult* OPENSRS::CheckAvailability(Int, Str)
    [15-10-01 10:24:20.326 OPENSRS_Obj RQ00000 TH24894 NTE] Finished method OPENSRS.CheckAvailability(user = -1, SID = 0, lang = en, request = 0, localObject = 1, transaction = 0 (HP))
    
  • In postgresql logs errors LOG: could not receive data from client: Connection reset by peer and LOG: unexpected EOF on client connection appear from time to time.

Cause

BA attempts to reuse the postgresql connection created earlier, but due to some networking issue the existing connection has been reset. BA does not validate the connection status, method just fails, system does not attempt to initiate a new connection, which is a bug with id #PBA-66084 ("Status of the database process transaction is associated with is not checked". But the initial root cause lays in the connection being dropped somewhere in the middle of the connection BA application server <-> database (it can be done by firewall, router, some third-party applications).

Resolution

The suggestion here is either increasing the idle connections timeout on router or move BA database to the same network as BA application server to avoid connections being dropped, please contact the system administrator for the details.

To workaround the issue you may change the system settings on the database server, e.g. initial settings:

[root@hostname ipv4]# cat tcp_keepalive_time
7200
[root@hostname ipv4]# cat tcp_keepalive_intvl
75
[root@hostname ipv4]# cat tcp_keepalive_probes
9

Change them to check the behaviour:

echo 600 > /proc/sys/net/ipv4/tcp_keepalive_time 
echo 90 > /proc/sys/net/ipv4/tcp_keepalive_intvl 
echo 1000 > /proc/sys/net/ipv4/tcp_keepalive_probes

Note, the change is reset after the server reboot.

See also: https://kb.odin.com/en/129876

Search Words

performance issues in PBA

Unable to login

Connection to has failed

Service Unavailable

pba service instable

intermittent issue with domains showing not available

unresponsive pba

pba outage

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 3627d36199b8ff577605df76e2fa222b bb7e9177fb03488961a3ea554120f328 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 5356b422f65bdad1c3e9edca5d74a1ae 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF