From Bugzilla Helper: User-Agent: Mozilla/5.0 Galeon/1.2.6 (X11; Linux i686; U;) Gecko/20021105 Description of problem: Under heave network loads, postgres access over ssl intermittently shows one of the following error messages: LOG: pq_recvbuf: unexpected EOF on client connection LOG: SSL SYSCALL error: EOF detected LOG: SSL error: decryption failed or bad record mac , resulting in loss of the connection. After some googling around I came across a recent patch by one of the postgres developers, which apparently solves this. I would appreciate if this patch were to be included in the upgrades; the current version (7.3.4-9) does not. Incidentally, the logging of the error messages as shown above required some small changes to the postgresql init script, which I'd be very happy to share. Regards, Philip Lijnzaad Version-Release number of selected component (if applicable): rh-postgres-7.3.4-9 How reproducible: Sometimes Steps to Reproduce: access postgres over an ssl connection on a different machine Actual Results: connection to database lost. In postgres log file: LOG: pq_recvbuf: unexpected EOF on client connection LOG: SSL SYSCALL error: EOF detected LOG: SSL error: decryption failed or bad record mac Expected Results: No connection loss. Additional info: A patch has been provided by Tom Lane, Postgresql developer. It is available from http://groups.google.com/groups?q=pgsql+patch+against+7.3.4+ssl+fe-misc
Created attachment 97642 [details] patch that addresses said pbug patching requires use of -w (indentation is wrong)
sorry, patch -l (not -w)
rh-postgresql will be updated to 7.3.6 in RHEL3 Update 2.
An errata has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on the solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHBA-2004-116.html