Thread: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
From
Douglas Stetner
Date:
Hi all, Looking for confirmation there is an issue with pg_dump failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhatlinux. -bash-4.1$ pg_dump -V pg_dump (PostgreSQL) 8.4.9 -bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz pg_dump: Dumping the contents of table "mafs" failed: PQgetCopyData() failed. pg_dump: Error message from server: SSL error: unexpected message pg_dump: The command was: COPY public.mafs (hugo_symbol, ... ... analysis_id) TO stdout; This is only happening on 2 tables in this database. The same database can be backed up with pgAdmin3.app remotely froma Mac As stated I am fairly sure the cause was the upgrade of openssl as it started to fail the next day: Jun 16 05:18:25 qcmg-database1 yum[2965]: Updated: openssl-1.0.1e-30.el6_6.11.x86_64 Douglas Stetner Mobile 0474 082 019 UNIX - Live Free Or Die
Attachment
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
From
Albe Laurenz
Date:
Douglas Stetner wrote: > Looking for confirmation there is an issue with pg_dump failing after upgrade to openssl-1.0.1e- > 30.el6_6.11.x86_64 on redhat linux. > > -bash-4.1$ pg_dump -V > pg_dump (PostgreSQL) 8.4.9 > > -bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz > pg_dump: Dumping the contents of table "mafs" failed: PQgetCopyData() failed. > pg_dump: Error message from server: SSL error: unexpected message > pg_dump: The command was: COPY public.mafs (hugo_symbol, > ... > ... > analysis_id) TO stdout; > > > This is only happening on 2 tables in this database. The same database can be backed up with > pgAdmin3.app remotely from a Mac > > As stated I am fairly sure the cause was the upgrade of openssl as it started to fail the next day: > Jun 16 05:18:25 qcmg-database1 yum[2965]: Updated: openssl-1.0.1e-30.el6_6.11.x86_64 This looks like a renegotiation problem. Could you run the following two statements in a psql session: SET ssl_renegotiation_limit='3kB'; SELECT repeat('0123456789', 900)"; and see if it triggers the problem? If you set "ssl_renegotiation_limit" to 0, either on the server on using the PGOPTIONS environment variable on the client side, does the problem go away? Since you upgraded OpenSSL on one end (you didn't tell us on which), maybe the problem is the age of the OpenSSL library on the other side --- if one side follows RFC 5746 and the other doesn't (because it is pre-2010) you can end up with problems like that. If my guess is correct, the solution would be to upgrade OpenSSL on the other end too. And while you are at it, upgrade to PostgreSQL 9.4 if your data are important for you. Yours, Laurenz Albe