Thread: Unable to start Statistics Collector

Unable to start Statistics Collector

From
"Senthil Kumar G"
Date:

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

Re: Unable to start Statistics Collector

From
"Kevin Grittner"
Date:
"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

Re: Unable to start Statistics Collector

From
"Senthil Kumar G"
Date:
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


Re: Unable to start Statistics Collector

From
sivakumar krishnamurthy
Date:


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

Re: Unable to start Statistics Collector

From
"Senthil Kumar G"
Date:

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

Re: Unable to start Statistics Collector

From
"Kevin Grittner"
Date:
"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

Re: Unable to start Statistics Collector

From
Alvaro Herrera
Date:
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

Re: Unable to start Statistics Collector

From
Tom Lane
Date:
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

Re: Unable to start Statistics Collector

From
rafael@santosgrupo.com
Date:
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

Re: Unable to start Statistics Collector

From
rafael@santosgrupo.com
Date:
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

Re: Unable to start Statistics Collector

From
"Senthil Kumar G"
Date:
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