pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to start Statistics Collector
11+ messages / 6 participants
[nested] [flat]
* Unable to start Statistics Collector
@ 2010-06-22 15:03 Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 11+ messages in thread
From: Senthil Kumar G @ 2010-06-22 15:03 UTC (permalink / raw)
To: pgsql-admin
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
Attachments:
image003.jpg (image/jpeg, 11.2K) download
view image
image004.jpg (image/jpeg, 9.7K) download
view image
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
@ 2010-06-22 17:12 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
0 siblings, 1 reply; 11+ messages in thread
From: Kevin Grittner @ 2010-06-22 17:12 UTC (permalink / raw)
To: pgsql-admin; senthil@zoniac.com
"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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-06-23 04:52 ` Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Senthil Kumar G @ 2010-06-23 04:52 UTC (permalink / raw)
To: 'Kevin Grittner' <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
@ 2010-06-23 10:34 ` sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
0 siblings, 1 reply; 11+ messages in thread
From: sivakumar krishnamurthy @ 2010-06-23 10:34 UTC (permalink / raw)
To: senthil@zoniac.com; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
>
> 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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
@ 2010-06-23 11:59 ` Senthil Kumar G <senthil@zoniac.com>
2010-06-23 13:56 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 17:11 ` Re: Unable to start Statistics Collector Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 2 replies; 11+ messages in thread
From: Senthil Kumar G @ 2010-06-23 11:59 UTC (permalink / raw)
To: 'sivakumar krishnamurthy' <sivakumar.mailinglist@gmail.com>; +Cc: 'Kevin Grittner' <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
@ 2010-06-23 13:56 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 11+ messages in thread
From: Kevin Grittner @ 2010-06-23 13:56 UTC (permalink / raw)
To: 'sivakumar krishnamurthy' <sivakumar.mailinglist@gmail.com>; senthil@zoniac.com; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
@ 2010-06-23 17:11 ` Alvaro Herrera <alvherre@commandprompt.com>
2010-06-23 18:34 ` Re: Unable to start Statistics Collector Tom Lane <tgl@sss.pgh.pa.us>
2010-06-24 06:13 ` Re: Unable to start Statistics Collector rafael@santosgrupo.com
2010-06-24 06:13 ` Re: Unable to start Statistics Collector rafael@santosgrupo.com
1 sibling, 3 replies; 11+ messages in thread
From: Alvaro Herrera @ 2010-06-23 17:11 UTC (permalink / raw)
To: Senthil Kumar G <senthil@zoniac.com>; +Cc: sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>; Kevin Grittner <kevin.grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 17:11 ` Re: Unable to start Statistics Collector Alvaro Herrera <alvherre@commandprompt.com>
@ 2010-06-23 18:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 11+ messages in thread
From: Tom Lane @ 2010-06-23 18:34 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Senthil Kumar G <senthil@zoniac.com>; sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>; Kevin Grittner <kevin.grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 17:11 ` Re: Unable to start Statistics Collector Alvaro Herrera <alvherre@commandprompt.com>
@ 2010-06-24 06:13 ` rafael@santosgrupo.com
2 siblings, 0 replies; 11+ messages in thread
From: rafael@santosgrupo.com @ 2010-06-24 06:13 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-admin-owner@postgresql.org, "Senthil Kumar G" <senthil@zoniac.com>; +Cc: sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>; Kevin Grittner <kevin.grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 17:11 ` Re: Unable to start Statistics Collector Alvaro Herrera <alvherre@commandprompt.com>
@ 2010-06-24 06:13 ` rafael@santosgrupo.com
2010-06-24 06:43 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2 siblings, 1 reply; 11+ messages in thread
From: rafael@santosgrupo.com @ 2010-06-24 06:13 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-admin-owner@postgresql.org, "Senthil Kumar G" <senthil@zoniac.com>; +Cc: sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>; Kevin Grittner <kevin.grittner@wicourts.gov>; 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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Unable to start Statistics Collector
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Re: Unable to start Statistics Collector Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` Re: Unable to start Statistics Collector sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Re: Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-23 17:11 ` Re: Unable to start Statistics Collector Alvaro Herrera <alvherre@commandprompt.com>
2010-06-24 06:13 ` Re: Unable to start Statistics Collector rafael@santosgrupo.com
@ 2010-06-24 06:43 ` Senthil Kumar G <senthil@zoniac.com>
0 siblings, 0 replies; 11+ messages in thread
From: Senthil Kumar G @ 2010-06-24 06:43 UTC (permalink / raw)
To: rafael@santosgrupo.com; 'Alvaro Herrera' <alvherre@commandprompt.com>; pgsql-admin-owner@postgresql.org; +Cc: 'sivakumar krishnamurthy' <sivakumar.mailinglist@gmail.com>; 'Kevin Grittner' <kevin.grittner@wicourts.gov>; 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
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2010-06-24 06:43 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-22 15:03 Unable to start Statistics Collector Senthil Kumar G <senthil@zoniac.com>
2010-06-22 17:12 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 04:52 ` Senthil Kumar G <senthil@zoniac.com>
2010-06-23 10:34 ` sivakumar krishnamurthy <sivakumar.mailinglist@gmail.com>
2010-06-23 11:59 ` Senthil Kumar G <senthil@zoniac.com>
2010-06-23 13:56 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-23 17:11 ` Alvaro Herrera <alvherre@commandprompt.com>
2010-06-23 18:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-06-24 06:13 ` rafael@santosgrupo.com
2010-06-24 06:13 ` rafael@santosgrupo.com
2010-06-24 06:43 ` Senthil Kumar G <senthil@zoniac.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox