unknown log messages

From: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: unknown log messages
Date: 2011-01-05 15:16:15
Message-ID: 8585BA53443004458E0BAA6134C5A7FB48204514@EGEXCMB01.oww.root.lcl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I'm getting the following error in my log file. Normally it's every 10 minutes, but occasionally the frequency changes to 5min, 3,1,30sec, 10sec, 5sec and then every second. Weeks ago it took the db down with a disk full situation, but usually it clears after a few minutes of continuous errors.

Can anybody offer any thoughts for how to identify what this is, and how to correct the issue.
Thanks
Doug

Env: Greenplum 3.3.6(based on PG 8.2.13), Solaris 10u5, Sun X4540 (x86)
We are probing the machine with sitescope for cpu/mem/disk stats, but I don't believe it's connecting to the db.

2011-01-01 13:01:56.848368 CST,"root","root",p427,th1,"[local]",,2011-01-01 13:01:56 CST,0,,,seg-1,,,,,"FATAL","28000","no pg_hba.conf entry for host ""[local]"", user ""root"", database ""root"", SSL off",,,,,,,0,,"auth.c",369,"Traceback 0: a12ca6: /usr/local/greenplum-db-3.3.6.6/bin/postgres errstart+0x3e6
Traceback 1: 748915: /usr/local/greenplum-db-3.3.6.6/bin/postgres ClientAuthentication+0x4c5
Traceback 2: 84a4c0: /usr/local/greenplum-db-3.3.6.6/bin/postgres ClosePostmasterPorts+0x5610
Traceback 3: 84b789: /usr/local/greenplum-db-3.3.6.6/bin/postgres PostmasterMain+0x959
Traceback 4: 76bb84: /usr/local/greenplum-db-3.3.6.6/bin/postgres main+0x474
Traceback 5: 4dae6c: /usr/local/greenplum-db-3.3.6.6/bin/postgres _start+0x6c
"

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CBACB9(dot)03E975B0] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message bricklen 2011-01-05 16:31:58 Re: unknown log messages
Previous Message ojas dubey 2011-01-05 06:00:08 Re: Find all running postgres DB servers on a network