Connection stale when running a command that takes ~4 hours to finish

capistrano / capistrano

A deployment automation tool built on Ruby, Rake, and SSH.

http://www.capistranorb.com

MIT License

12.69k stars 1.77k forks source link

Connection stale when running a command that takes ~4 hours to finish #2118

Closed pioz closed 1 year ago

pioz commented 1 year ago

I'm running a mysqldump command using sshkit in a Ruby script. Something like execute 'mysqldump options...'

All works fine if the DB is small, but when I use my script on a big database (the mysqldump command takes ~4 hours to finish), the execute command never ends and the connection is stale. I can see that the mysqldump has finished logging via ssh to the database server.

Any idea to help me? Are there some options that I should use to avoid this problem?

mattbrictson commented 1 year ago

Closing as resolved via https://github.com/capistrano/sshkit/issues/503