ok i enabled log_connections 2018-11-01 13:44:18 UTC LOG: connection received: host=::1 port=47574 2018-11-01 13:44:18 UTC LOG: incomplete startup packet i see this in my /etc/hosts ::1 localhost ip6-localhost ip6-loopback and host all all ::1/128 md5 in my hba,conf i'll check why there is an attempt to make a connection. Regards, Vijay On Thu, Nov 1, 2018 at 6:57 PM Vijaykumar Jain <vjain@xxxxxxxxxxxxx> wrote: > > Hi Team, > > I know this is has been answered a lot on the internet wrt ignoring, > but i am unable to figure out why I get these messages in logs > "incomplete startup packet" > > I have a server running postgresql 10.5 on ubuntu16.04 > > i do not have any active external connections other than streaming > postgres replication. > > > postgres 7757 1 0 12:20 ? 00:00:00 > /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c > config_file=/etc/postgresql/10/main/postgresql.conf > > postgres 7759 7757 0 12:20 ? 00:00:00 postgres: 10/main: > checkpointer process > > postgres 7760 7757 0 12:20 ? 00:00:00 postgres: 10/main: > writer process > > postgres 7761 7757 0 12:20 ? 00:00:00 postgres: 10/main: wal > writer process > > postgres 7762 7757 0 12:20 ? 00:00:00 postgres: 10/main: > autovacuum launcher process > > postgres 7763 7757 0 12:20 ? 00:00:00 postgres: 10/main: > archiver process > > postgres 7764 7757 0 12:20 ? 00:00:00 postgres: 10/main: > stats collector process > > postgres 7765 7757 0 12:20 ? 00:00:00 postgres: 10/main: > bgworker: logical replication launcher > > postgres 7779 7757 0 12:20 ? 00:00:00 postgres: 10/main: wal > sender process replicator x.x.x.x(47792) streaming 3/FA0001B0 > > postgres 7780 7757 0 12:20 ? 00:00:00 postgres: 10/main: wal > sender process replicator x.x.x.x(50526) streaming 3/FA0001B0 > > postgres 7786 7757 0 12:21 ? 00:00:00 postgres: 10/main: wal > sender process barman_streaming x.x.x.x(43566) streaming 3/FA0001B0 > > > > also, > > postgres=# select backend_type, query from pg_stat_activity; > > backend_type | query > > ---------------------+--------------------------------------------------- > > autovacuum launcher | > > background worker | > > walsender | > > walsender | > > walsender | > > client backend | select backend_type, query from pg_stat_activity; > > background writer | > > checkpointer | > > walwriter | > > > > but i still see > > > tail -1000 /var/log/postgresql/postgresql-10-main.log| grep > 'incomplete startup packet' > > 2018-11-01 13:04:18 UTC LOG: incomplete startup packet > > 2018-11-01 13:08:18 UTC LOG: incomplete startup packet > > 2018-11-01 13:12:18 UTC LOG: incomplete startup packet > > > Note: exactly at 4 min interval. > > i do not know C, but i tried to understand something from > https://github.com/postgres/postgres/blob/197e4af9d5da180190a0f2be851b095dba57d9cd/src/backend/postmaster/postmaster.c#L1891 > > without any active connections, i would rule any driver issue out. > > i do not have ssl enabled, but not using it. I tried disabling it too. > > postgres=# show ssl; > > ssl > > ----- > > off > > (1 row) > > > > I do not know, why those log messages are then showing up. > > not errors in > > ens160 Link encap:Ethernet HWaddr 00:50:56:a4:53:b6 > > inet addr:x.x.x.x Bcast:x.x.x.x Mask:x.x.x.x > > inet6 addr: xxxxx/64 Scope:Link > > UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 > > RX packets:45403371 errors:0 dropped:0 overruns:0 frame:0 > > TX packets:8834699 errors:0 dropped:0 overruns:0 carrier:0 > > collisions:0 txqueuelen:1000 > > RX bytes:6417380742 (6.4 GB) TX bytes:56209193635 (56.2 GB) > > > lo Link encap:Local Loopback > > inet addr:127.0.0.1 Mask:255.0.0.0 > > inet6 addr: ::1/128 Scope:Host > > UP LOOPBACK RUNNING MTU:65536 Metric:1 > > RX packets:28985185 errors:0 dropped:0 overruns:0 frame:0 > > TX packets:28985185 errors:0 dropped:0 overruns:0 carrier:0 > > collisions:0 txqueuelen:1 > > RX bytes:7078785550 (7.0 GB) TX bytes:7078785550 (7.0 GB) > > > > > > > > Regards, > Vijay
