FHIR: Postgres connection timeout

while posting a large bundle there is connection timeout after 120 seconds. Even after adding the socketTimeout=0 in the connectProperties , connection timeout after 120 seconds.

"default": {
                    "type": "postgresql",
                    "connectionProperties": {
                        "serverName": "localhost",
                        "portNumber": 5432,
                        "databaseName": "fhirdb",
                        "user": "fhiruser",
                        "password": "change-password",
                        "currentSchema": "fhirdata",
			"socketTimeout": 0
                    }
}

00009bc7 com.ibm.tx.jta.embeddable.impl.EmbeddableTimeoutManager I WTRN0006W: Transaction 00000172E5C5BE53000000012865CE9C1494C99A328B344FC9E38C285820417EA54DA49E00000172E5C5BE53000000012865CE9C1494C99A328B344FC9E38C285820417EA54DA49E00000001 has timed out after 120 seconds.

About this issue

  • Original URL
  • State: closed
  • Created 4 years ago
  • Comments: 21 (7 by maintainers)

Most upvoted comments

Thank you @sridhar-shivraj I will review and post an update later today.

@sridhar-shivraj we haven’t had time to investigate. We’ll get to investigate some point over the next few days.