Postgres SSL error

Question

I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres database to mysql.

It works fine for a while (~5 mins or so), but then I get the error:

SQLSTATE[HY000]: General error: 7 SSL [error] SYSCALL error: EOF detected

The postgres database connection seems to have gone, and I just get errors:

SQLSTATE[HY000]: General error: 7 no [error] connection to the server

It works fine locally, so I think the problem must be with postgres and running a script over SSH - but googling these errors returns nothing useful. Does anyone know what could be causing this?

Could be a timeout. first inspect the log (maybe change ssl_renegotiation_limit) — wildplasser
– wildplasser, Commented Jul 12, 2012 at 10:56
Yep, that was exactly the problem - query was taking too long to run, I rewrote it and all's fine now. Thanks very much for the help. Do you want to post your comment as an answer & I can mark it as accepted? — Ben Scott
– Ben Scott, Commented Jul 18, 2012 at 7:58

wildplasser · Accepted Answer · 2014-04-01 22:47:46Z

4

Could be a timeout. first inspect the log (maybe change ssl_renegotiation_limit)

BTW: IIRC, the renegotiation does not take place after a fixed amount of time, but after a certain amount of transmitted characters (2GB?)

edited Apr 1, 2014 at 22:47

answered Jul 18, 2012 at 8:40

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Stosberg · Accepted Answer · 2012-07-12 11:58:06Z

1

You should check both your PostgreSQL and MySQL logs for further potential details. If there's not much in the PostgreSQL log, look at the log_min_error_statement in postgresql.conf. As you'll find through that link, you can tune it to increase the amount of logging. If there's still not clues in the PostgreSQL log, I would look at other components in your system for the problem.

answered Jul 12, 2012 at 11:58

Mark Stosberg

13.5k6 gold badges48 silver badges49 bronze badges

1 Comment

Ben Scott Over a year ago

Thanks for the tip. I had checked the log and there wasn't anything helpful, but I'll try increasing the logging and see if there's any clues there. Cheers, Ben

Collectives™ on Stack Overflow

Postgres SSL error

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related