Re: [Fab-user] Fabric hanging on mysql data import

[Lachlan Cannon]

Adding keepalive to the env dictionary worked perfectly. Thanks.

On Thu, Oct 3, 2013 at 8:25 PM, Jens Rantil <address@hidden> wrote:

Hi Lachian,

I remember having issues with long running tasks, too. What solved my issue was to to add the `--keepalive=30` parameter to `fab` at command line. This made sure that the connection was constantly kept alive. I have no idea whether this was a firewall issue or not but like I said, this solved my problem. Give it a try and get back to the list to tell whether it fixed your issue or not.

Cheers,

Jens

On 2 okt 2013, at 08:03, Lachlan Cannon <address@hidden> wrote:

Hi,

I'm currently writing deployment scripts to create a new environment in the rackspace cloud, which involves creating the servers with pyrax, and then configuring them using fabric. First time using fabric, by the way, and I love it. So simple and clean to get up and running. However, I'm having a problem where, after downloading the latest database dump to a server, the import is hanging. That is, it successfully completes, but the fabric script never continues. Logging in to the server verifies that the data has all finished importing, and that there is no activity within mysql, and running the same command myself on the command line executes and finishes perfectly.

The output is:
 [root@<ip>] run: mysql <dbname> -uroot -p"<password string>" < db_daily.sql

Versions are:
Python 2.7.4
Fabric 1.8.0
Paramiko 1.11.1

and I'm using Fabric as a library from within my own script.

The database file itself is 20GB and take a while to import -- I'm wondering if this might be causing the issue, and if there's anything I can do to mitigate it?

Thanks for your time.

--

Lachlan Cannon

_______________________________________________
Fab-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/fab-user