Re: [Fab-user] trouble with pgbouncer - SIGINT?

[Marcelo Araújo Pontes]

Hi Andy,

I've had the same problem when trying to start apache remotely using fabric and after some research on the web i found out that that's a problem with fabric's "run" command using pseudo-terminals(pty). The default behavior for "run" command is to use a pty in the remote machine so it doesn't interact directly with a remote machine terminal, and this causes some commands to run in a weird way, such as apache and pgbouncer i believe. Unfortunately i haven't been able to fully understand why fabric does this... if anyone have a good explanation, please share.

Anyways, try setting "pty=False" in the run/sudo command. It should solve your problem.

Regards,

Marcelo Araújo Pontes

Infra e Redes

---

De: "Andy Mroczkowski" <address@hidden>
Para: address@hidden
Enviadas: Domingo, 1 de Abril de 2012 22:24:06
Assunto: [Fab-user] trouble with pgbouncer - SIGINT?

Greetings.

I'm trying to use fabric to set up a postgresql server with pgbouncer http://wiki.postgresql.org/wiki/PgBouncer roughly based on these instructions http://www.askthepony.com/blog/2011/07/django-and-postgresql-improving-the-performance-with-no-effort-and-no-code/. I have everything working except for actually starting the pgbouncer service. I have the following line in my fabfile:

sudo("service pgbouncer restart")

The output looks ok:

address@hidden sudo: service pgbouncer restart

address@hidden out:  * Restarting pgbouncer pgbouncer

address@hidden out:    ...done.

However, after fabric disconnects, pgbouncer is not running. It's log file reports:

2012-04-02 00:53:56.205 22454 LOG File descriptor limit: 1024 (H:4096), max_client_conn: 100, max fds possible: 110

2012-04-02 00:53:56.207 22456 LOG listening on 127.0.0.1:6432

2012-04-02 00:53:56.208 22456 LOG listening on unix:/var/run/postgresql/.s.PGSQL.6432

2012-04-02 00:53:56.208 22456 LOG process up: pgbouncer 1.4.2, libevent 2.0.12-stable (epoll), adns: evdns2

2012-04-02 00:54:03.904 22456 LOG Got SIGINT, shutting down

2012-04-02 00:54:04.233 22456 LOG server connections dropped, exiting

It seems like the service is starting, and then exiting almost immediately due to receiving a SIGINT.

If I run the command manually from my local shell (without fabric) it works fine. No immediate shutdown due to SIGINT

ssh -i key.pem address@hidden 'sudo service pgbouncer restart'

I can only assume that somehow fabric is sending SIGINT (directly or indirectly), but I don't know a lot the fabric execution environment or UNIX signals/daemons in general.

Any ideas?

Thanks,

- Andy

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