Bug 1024676 - Warnings in PostgreSQL 9.2 log
Warnings in PostgreSQL 9.2 log
Product: OpenShift Online
Classification: Red Hat
Component: Image (Show other bugs)
Unspecified Unspecified
medium Severity medium
: ---
: ---
Assigned To: Paul Morie
libra bugs
: SupportQuestion, UpcomingRelease
Depends On:
  Show dependency treegraph
Reported: 2013-10-30 04:44 EDT by Jarek Zgoda
Modified: 2015-05-14 20:34 EDT (History)
7 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2014-02-21 12:34:07 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Jarek Zgoda 2013-10-30 04:44:23 EDT
Related forum post: https://www.openshift.com/forums/openshift/warnings-in-postgresql-log

Description of problem:
postgresql-9.2 cartridge in application brewlog-zgoda.rhcloud.com

After startup of cartridge there are following entries in log

LOG:  could not bind socket for statistics collector: Permission denied
LOG:  trying another address for the statistics collector
LOG:  could not bind socket for statistics collector: Permission denied
LOG:  trying another address for the statistics collector
LOG:  could not bind socket for statistics collector: Cannot assign requested address
LOG:  trying another address for the statistics collector
LOG:  could not bind socket for statistics collector: Cannot assign requested address
LOG:  disabling statistics collector for lack of working socket
WARNING:  autovacuum not started because of misconfiguration
HINT:  Enable the "track_counts" option.

PostgreSQL is running without autovacuum process:

[brewlog-zgoda.rhcloud.com log]\> ps -A f | grep postgres
 1932 ?        S      0:00 /opt/rh/postgresql92/root/usr/bin/postgres
 1939 ?        Ss     0:00  \_ postgres: logger process                  
 1941 ?        Ss     0:00  \_ postgres: checkpointer process            
 1942 ?        Ss     0:00  \_ postgres: writer process                  
 1943 ?        Ss     0:00  \_ postgres: wal writer process              
13879 ?        Ss     0:00  \_ postgres: username dbname idle
14161 ?        Ss     0:00  \_ postgres: username dbname idle

Version-Release number of selected component (if applicable):

How reproducible:
always in this application

Steps to Reproduce:
1. create application with MySQL cartridge and start it
2. add postgresql-9.2 cartridge
3. remove MySQL cartridge
4. restart application observing PostgreSQL log

Actual results:
PostgreSQL is running without autovacuum process

Expected results:
Autovacuum process is present

Additional info:
Tried and not working:
 - remove postgresql-9.2 cartridge then add it again
Comment 1 Jarek Zgoda 2013-10-30 11:51:36 EDT
Exactly same result can be observed with completely fresh application, just python-2.7 and postgresql-9.2 cartridges.
Comment 4 Jeff McCormick 2014-01-23 16:27:59 EST
just wondering about status of this bug. The issue seems to be in how localhost is locked down.  Can the internal IP address that is assigned by openshift be added to the list of IP addresses for localhost within /etc/hosts?

according to my collegue, Greg Smith, "What PostgreSQL does at startup is ask the OS for the addresses of "localhost" (hard-coded) using the getaddrinfo() system call: https://en.wikipedia.org/wiki/Getaddrinfo

It then loops over all the returned addresses until it successfully talks to socket it created, and if all addresses fail it gives the error in the bug report."
Comment 5 Clayton Coleman 2014-01-24 16:22:55 EST
Vacuum is pretty important.  Can we get this fixed in postgres?
Comment 6 Paul Morie 2014-01-27 13:47:50 EST
I've created a bug for this w/ Postgres.  Postgresql uses a mailing list for bug reports instead of an issue tracker; my report is current pending moderator approval.  Will link once it has been posted.
Comment 7 Paul Morie 2014-02-21 12:34:07 EST
Unfortunately it doesn't look like this is something we'll be able to fix right now.  We hope that we'll be able to support it in the future.
Comment 8 Andy Grimm 2015-02-10 14:18:56 EST
Just to connect the dots, here's what Paul filed upstream:

Given Tom Lane's response, I don't think postgres is going to change behavior:

Yeah.  In particular, I'd always supposed that a platform that wanted
to use some other IP address than for loopback would also be
expected to make sure that "localhost" mapped to that other IP address.
Otherwise, there simply isn't any way to make network-using software
work except random hacks.

Frankly, I don't think you're going to get any cooperation from Postgres
in adapting to such a broken networking environment as this, and I doubt
other upstreams are going to be any more positive about it.
Comment 9 Simon Brandhof 2015-02-21 07:41:57 EST
Paul, you mention in http://www.postgresql.org/message-id/1241903739.14805210.1390938412164.JavaMail.root@redhat.com that using network namespaces in OpenShift is a high priority improvement. Where can its status be tracked ? Is there a bugzilla bug ?
Thank you

Note You need to log in before you can comment on or make changes to this bug.