Thread: Unable to start Statistics Collector
Hi
I set it up the postgres db and wanted to enable the statistics collector in one of our customer server. Some how, it is not running. Please see the error below.
Can you let me know what could be the issue?
1. Error during server startup
2. On executing ps -ef |grep post, it is showing eth0 IP address. It should be localhost IP 127.0.0.1
Regards
Senthil
Attachment
"Senthil Kumar G" <senthil@zoniac.com> wrote: > I set it up the postgres db and wanted to enable the statistics > collector in one of our customer server. Some how, it is not > running. Please see the error below. I am not able to view that. (I assume you embedded some image format my OS doesn't understand.) Could you repost with text? Before you repost, please review this for ideas on other information which might be useful: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin
Hi Here is the error: 2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for statistics collector: Connection refused 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of working socket Regards Senthil -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Tuesday, June 22, 2010 10:43 PM To: pgsql-admin@postgresql.org; senthil@zoniac.com Subject: Re: [ADMIN] Unable to start Statistics Collector "Senthil Kumar G" <senthil@zoniac.com> wrote: > I set it up the postgres db and wanted to enable the statistics > collector in one of our customer server. Some how, it is not > running. Please see the error below. I am not able to view that. (I assume you embedded some image format my OS doesn't understand.) Could you repost with text? Before you repost, please review this for ideas on other information which might be useful: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin
2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for
statistics collector: Connection refused
2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of
working socket
Can you check if ping 127.0.0.1 is working if not start the loopback interface.
Thanks,
Sivakumar.K
Hi
I executed follows. I am able to ping.
>ping 127.0.0.1
PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms
64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms
Please let me know what should I do next.
Regards
Senthil
From: sivakumar krishnamurthy [mailto:sivakumar.mailinglist@gmail.com]
Sent: Wednesday, June 23, 2010 4:04 PM
To: senthil@zoniac.com
Cc: Kevin Grittner; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Unable to start Statistics Collector
2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for
statistics collector: Connection refused
2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of
working socket
I remember having the same problem last week and after debugging found that my loopback wasn't working.
Can you check if ping 127.0.0.1 is working if not start the loopback interface.
Thanks,
Sivakumar.K
"Senthil Kumar G" <senthil@zoniac.com> wrote: > sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com> wrote: >>> 2010-04-08 17:30:41 ISTLOG: could not receive test message on >>> socket for statistics collector: Connection refused >>> 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for >>> lack of working socket >> >> I remember having the same problem last week and after debugging >> found that my loopback wasn't working. >> Can you check if ping 127.0.0.1 is working if not start the >> loopback interface. > 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms > 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms > 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms > > Please let me know what should I do next. Is there any sort of firewall software running on the OS of this machine which might be blocking UDP packets? -Kevin
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: > Hi > > > > I executed follows. I am able to ping. > > >ping 127.0.0.1 So can you ping localhost? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010:
>> I executed follows. I am able to ping.
>> ping 127.0.0.1
> So can you ping localhost?
I'm betting the problem is kernel-level filter rules that let through
ping packets but not the stats collector traffic. The reason that the
stats collector goes to such length to test the connection is that stuff
like this isn't uncommon :-(. You need to look at your firewall packet
filtering settings and back off the restrictions on localhost UDP
traffic.
regards, tom lane
Rrtrtt BlackBerry de movistar, allí donde estés está tu oficin@ -----Original Message----- From: Alvaro Herrera <alvherre@commandprompt.com> Sender: pgsql-admin-owner@postgresql.org Date: Wed, 23 Jun 2010 13:11:44 To: Senthil Kumar G<senthil@zoniac.com> Cc: sivakumar krishnamurthy<sivakumar.mailinglist@gmail.com>; Kevin Grittner<kevin.grittner@wicourts.gov>; pgsql-admin<pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Unable to start Statistics Collector Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: > Hi > > > > I executed follows. I am able to ping. > > >ping 127.0.0.1 So can you ping localhost? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Rtt BlackBerry de movistar, allí donde estés está tu oficin@ -----Original Message----- From: Alvaro Herrera <alvherre@commandprompt.com> Sender: pgsql-admin-owner@postgresql.org Date: Wed, 23 Jun 2010 13:11:44 To: Senthil Kumar G<senthil@zoniac.com> Cc: sivakumar krishnamurthy<sivakumar.mailinglist@gmail.com>; Kevin Grittner<kevin.grittner@wicourts.gov>; pgsql-admin<pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Unable to start Statistics Collector Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: > Hi > > > > I executed follows. I am able to ping. > > >ping 127.0.0.1 So can you ping localhost? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Hi I am able to ping localhost also. ping localhost PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.037 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.026 ms 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.050 ms 64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.030 ms 64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.051 ms Let me also check any firewall issue? Regards Senthil -----Original Message----- From: rafael@santosgrupo.com [mailto:rafael@santosgrupo.com] Sent: Thursday, June 24, 2010 11:44 AM To: Alvaro Herrera; pgsql-admin-owner@postgresql.org; Senthil Kumar G Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin Subject: Re: [ADMIN] Unable to start Statistics Collector Rtt BlackBerry de movistar, allí donde estés está tu oficin@ -----Original Message----- From: Alvaro Herrera <alvherre@commandprompt.com> Sender: pgsql-admin-owner@postgresql.org Date: Wed, 23 Jun 2010 13:11:44 To: Senthil Kumar G<senthil@zoniac.com> Cc: sivakumar krishnamurthy<sivakumar.mailinglist@gmail.com>; Kevin Grittner<kevin.grittner@wicourts.gov>; pgsql-admin<pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Unable to start Statistics Collector Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: > Hi > > > > I executed follows. I am able to ping. > > >ping 127.0.0.1 So can you ping localhost? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin