Re: Pgbouncer and postgres

I'm not aware of any update installed. There were like 600+ updates in fact.

These are the logs when connecting via telnet :

2018-09-17 14:18:18.933 65617 NOISE safe_accept(11) = 14 (10.151.2.145:39478
)
2018-09-17 14:18:18.933 65617 NOISE new fd from accept=14
2018-09-17 14:18:18.933 65617 NOISE safe_accept(11) = Resource temporarily
unavailable
2018-09-17 14:18:28.385 65617 NOISE safe_accept(12) = 15 (::1/49712)
2018-09-17 14:18:28.385 65617 NOISE new fd from accept=15
2018-09-17 14:18:28.385 65617 NOISE safe_accept(12) = Resource temporarily
unavailable
2018-09-17 14:18:30.703 65617 NOISE safe_accept(11) = 16 (10.151.2.145:39520
)
2018-09-17 14:18:30.703 65617 NOISE new fd from accept=16
2018-09-17 14:18:30.703 65617 NOISE safe_accept(11) = Resource temporarily
unavailable
2018-09-17 14:18:34.416 65617 NOISE safe_accept(11) = 17 (10.151.2.145:39530
)
2018-09-17 14:18:34.416 65617 NOISE new fd from accept=17
2018-09-17 14:18:34.416 65617 NOISE safe_accept(11) = Resource temporarily
unavailable

[root(at)cmd-dev1 pgbouncer]# telnet localhost 6543
Trying ::1...
Connected to localhost.
Escape character is '^]'.
Connection closed by foreign host.

Il giorno lun 17 set 2018 alle ore 16:11 Adrian Klaver <
adrian(dot)klaver(at)aklaver(dot)com> ha scritto:

> On 9/17/18 7:05 AM, Nicola Contu wrote:
> > The log is from pgbouncer.
> >
> > I installed updates after this problem, but they did not resolve
> anything.
>
> I was thinking more of updates that where done between the last time it
> worked and the time it started failing.
>
> Along that line, when was the last time it worked?
>
> >
> > I compiled 1.9.0 from source on the same path of the previous one. Then
> > back to 1.8.1 on the same path.
> >
> > I also tried changing the listening port on pgbouncer, but that does not
> > change too much.
>
> Yeah, your log shows the port/socket coming up:
>
> 2018-09-17 12:21:14.422 88424 LOG listening on 127.0.0.1:6543
> 2018-09-17 12:21:14.422 88424 DEBUG add_listen: unix:/tmp/.s.PGSQL.6543
> 2018-09-17 12:21:14.422 88424 LOG listening on unix:/tmp/.s.PGSQL.6543
> 2018-09-17 12:21:14.423 88424 LOG process up: pgbouncer 1.8.1, libevent
> 2.0.21-stable (epoll), adns: evdns2, tls: OpenSSL 1.0.2k-fips 26 Jan 2017
>
> > I can connect via telnet on that port, but we I try with anything else
> > (like Apache) it makes pgbouncer crashing.
>
> Are there log entries from that?
>
> >
> >
> > Il giorno lun 17 set 2018 alle ore 15:44 Adrian Klaver
> > <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> ha
> scritto:
> >
> > On 9/17/18 5:33 AM, Nicola Contu wrote:
> > > Hello,
> > >
> > > I'm trying to get pgbouncer working but I'm getting this error :
> > >
> > >
> >
> > What is generating the log below?
> >
> > To me it looks like everything is on track until this:
> >
> > > 2018-09-17 12:21:48.917 88424 WARNING tune_socket(13) failed:
> > Operation
> > > not supported
> > > 2018-09-17 12:21:48.917 88424 NOISE safe_close(13) = 0
> > > 2018-09-17 12:21:48.918 88424 NOISE safe_accept(12) = Resource
> > > temporarily unavailable
> > > 2018-09-17 12:22:14.422 88424 LOG Stats: 0 xacts/s, 0 queries/s,
> > in 0
> > > B/s, out 0 B/s, xact 0 us, query 0 us wait time 0 us
> > > 2018-09-17 12:23:14.423 88424 LOG Stats: 0 xacts/s, 0 queries/s,
> > in 0
> > > B/s, out 0 B/s, xact 0 us, query 0 us wait time 0 us
> > > 2018-09-17 12:23:26.561 88424 LOG Got SIGINT, shutting down
> > > 2018-09-17 12:23:26.872 88424 LOG server connections dropped,
> exiting
> > > 2018-09-17 12:23:26.872 88424 NOISE safe_close(11) = 0
> > > 2018-09-17 12:23:26.872 88424 NOISE safe_close(12) = 0
> > >
> > >
> > > Postgres version : 10.5
> > >
> > > Libevent : 2.0.5
> > >
> > > Pgbouncer : 1.8.1
> > >
> > > OS : Centos 7
> >
> > Have there been updates to CentOS during this?
> >
> > >
> > >
> > > It used to work. Now after trying to install latest version of
> > pgbouncer
> > > (1.9.0) does not work anymore. Then I re-compiled the v 1.8.1
> >
> > Did you compile 1.9.0 from source or install from package?
> >
> > >
> > >
> > >
> > > Content of the pgbouncer.ini
> > >
> > > [databases]
> > > DB_NAME = host=IP_ADDD port=5432
> dbname=DB_NAME auth_user=pgbouncer
> > > pool_size=120
> > >
> > > [pgbouncer]
> > > listen_port = 6543
> > > listen_addr = *
> > > auth_type = md5
> > > auth_file = /etc/pgbouncer/users.txt
> > > auth_query = select uname,phash from user_lookup($1)
> > > logfile = /var/log/pgbouncer.log
> > > pidfile = /home/postgres/pgbouncer.pid
> > > admin_users = admin
> > > user=postgres
> > > max_db_connections = 220
> > > log_connections=0
> > > log_disconnections=0
> > > verbose=3
> > >
> > >
> > > Content of the users .txt
> > >
> > > [root(at)cmd-dev1 pgbouncer]# cat users.txt
> > > "pgbouncer" "***************"
> > >
> > >
> > > I tried to change the listen address to 127.0.0.1 or to the IP of
> > the
> > > VM. Nothing changed.
> > >
> > >
> > > Can anyone help?
> > >
> > >
> > > Thanks
> > >
> > >
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>