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@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.kla...@aklaver.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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.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@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
