问题描述
我正在尝试通过 SSH 和 drush(命令行 shell)运行 Drupal 迁移，将数据从 postgres 数据库复制到 mysql.
I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres database to mysql.
它可以正常工作一段时间(约 5 分钟左右)，但随后出现错误:
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
postgres 数据库连接似乎已经消失，我只是收到错误:
The postgres database connection seems to have gone, and I just get errors:
SQLSTATE[HY000]: General error: 7 no [error] connection to the server
它在本地运行良好，所以我认为问题一定出在 postgres 上并通过 SSH 运行脚本 - 但是在谷歌上搜索这些错误没有任何用处.有谁知道这可能是什么原因造成的?
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?
推荐答案
可能是超时.首先检查日志(可能更改 ssl_renegotiation_limit)
Could be a timeout. first inspect the log (maybe change ssl_renegotiation_limit)
顺便说一句:IIRC，重新协商不会在固定的时间后发生，而是在传输一定数量的字符(2GB?)后发生
BTW: IIRC, the renegotiation does not take place after a fixed amount of time, but after a certain amount of transmitted characters (2GB?)
这篇关于Postgres SSL 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！