Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005
Why?
PostgreSQL updated the default fallback behavior in the 42.2.16 driver in a way that breaks support for PostgreSQL instances. This version of the driver was bundled into ServiceDeskplus build version less than 13006. This PostgreSQL bug will affect only certain environments which is caused due to configurations, resource constraints, version discrepancies in the hosted environment.
This Article is only applicable for build versions less than 13006
Reference Traces :
- Caused by: java.net.SocketException: Connection reset
(OR)
- org.postgresql.util.PSQLException: Connection attempt timed out.
(OR)
- invalid frontend protocol
How to resolve this issue ?
An immediate workaround for this issue is by replacing the probelamatic version of postgresql driver with the bug fixed driver which is of version "42.2.19".
- Shut Down the Application Service, If it is running.
- Navigate to "<Product_Installation_Directory> \ lib " folder and move the "postgresql-42.2.16.jar" to a different location as a backup.
- Now download the attached zip, extract it and then place the "postgresql-42.2.16.jar" extracted from the zip inside the above lib folder.
- Now try to start the database using "startDB" script present in the "<product_installation_location> \ bin".
- If the database is started, you are good to proceed with your operations.
- If it fails to start, then please report it to our support Team with the "<product_installation_location>\logs" folder.
New to ADSelfService Plus?
Related Articles
Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005
Please follow the below instructions: -> Go to <Installation-directory>/Servicedesk/lib folder and move the postgresql-42.2.16.jar to a different location as a backup. -> Now download the jar from the below link and then place it inside the above lib ...How to customize MailFetching Connectivity issue Notification
MailFetching connectivity issueExternal Postges - PG Extension Issue
Error: If cxs who are using external postgres(not bundled postgres) faces below error, 1. Migration fails with "Upgrade halted. Please create postgres extension pg_trgm and try again" error. (or) 2. Start-up fails with "Application startup halted. ...Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175.
Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175. The content-type of the attachment is APPLICATION/OCTET-STREAM. Since it is in Upper case the following condition - ...Basic Performance Issues RCA On Postgres DB Cx
Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...