pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedunknown log messages
6+ messages / 3 participants
[nested] [flat]
* unknown log messages
@ 2011-01-05 15:16 Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
0 siblings, 1 reply; 6+ messages in thread
From: Little, Douglas @ 2011-01-05 15:16 UTC (permalink / raw)
To: 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.Little@orbitz.com<mailto:Douglas.Little@orbitz.com>
[cid:image001.jpg@01CBACB9.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/;
Attachments:
image001.jpg (image/jpeg, 2.3K) download
view image
* Re: unknown log messages
@ 2011-01-05 16:31 bricklen <bricklen@gmail.com>
parent: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
0 siblings, 2 replies; 6+ messages in thread
From: bricklen @ 2011-01-05 16:31 UTC (permalink / raw)
To: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>; +Cc: pgsql-admin
On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas
<DOUGLAS.LITTLE@orbitz.com>wrote:
>
> 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
>
Do you actually have a database named "root" and a db user named "root"? If
not, I'd check your client connection details to ensure you pass in the
database name and user.
Also, if you have a support contract, you could contact Greenplum -- I've
generally found them to be pretty responsive. Barring that, you could also
try posting to http://community.greenplum.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: unknown log messages
@ 2011-01-05 16:34 Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
parent: bricklen <bricklen@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Little, Douglas @ 2011-01-05 16:34 UTC (permalink / raw)
To: bricklen <bricklen@gmail.com>; +Cc: pgsql-admin
No dbuser named Root. Don’t know who is the client, so having trouble identifying it.
So it sounds like the log messages are standard for a login attempt with unknown user.
I have a case open with GP.
Thanks for the thoughts.
Doug
From: bricklen [mailto:bricklen@gmail.com]
Sent: Wednesday, January 05, 2011 10:32 AM
To: Little, Douglas
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unknown log messages
On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas <DOUGLAS.LITTLE@orbitz.com<mailto:DOUGLAS.LITTLE@orbitz.com>> wrote:
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
Do you actually have a database named "root" and a db user named "root"? If not, I'd check your client connection details to ensure you pass in the database name and user.
Also, if you have a support contract, you could contact Greenplum -- I've generally found them to be pretty responsive. Barring that, you could also try posting to http://community.greenplum.com<http://community.greenplum.com/;
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: unknown log messages
@ 2011-01-05 16:35 Scott Ribe <scott_ribe@elevated-dev.com>
parent: bricklen <bricklen@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Scott Ribe @ 2011-01-05 16:35 UTC (permalink / raw)
To: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>; +Cc: pgsql-admin
Could it be an automatic process, kicked off by cron or some such, running as root, and not specifying the db or user, therefore defaulting to root & root?
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: unknown log messages
@ 2011-01-05 17:15 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Ribe @ 2011-01-05 17:15 UTC (permalink / raw)
To: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>; +Cc: pgsql-admin
On Jan 5, 2011, at 9:34 AM, Little, Douglas wrote:
> No dbuser named Root.
That's my point, you don't have a db user named root, but you do (maybe) have a process running as root trying to connect to the db.
> So it sounds like the log messages are standard for a login attempt with unknown user.
No, they are standard for root trying to connect to the database when you do not have a db user named root.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: unknown log messages
@ 2011-01-05 17:26 bricklen <bricklen@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 6+ messages in thread
From: bricklen @ 2011-01-05 17:26 UTC (permalink / raw)
To: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>; +Cc: pgsql-admin; Scott Ribe <scott_ribe@elevated-dev.com>
On Wed, Jan 5, 2011 at 9:15 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Jan 5, 2011, at 9:34 AM, Little, Douglas wrote:
>
>> No dbuser named Root.
>
> That's my point, you don't have a db user named root, but you do (maybe) have a process running as root trying to connect to the db.
>
>> So it sounds like the log messages are standard for a login attempt with unknown user.
>
> No, they are standard for root trying to connect to the database when you do not have a db user named root.
As Scott says, check your root crontab for any scripts that might
connect to the db, and check the connection string. The "[local]" part
means that the call is being initiated locally to that box, else it
would should the IP.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2011-01-05 17:26 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-01-05 15:16 unknown log messages Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
2011-01-05 16:31 ` bricklen <bricklen@gmail.com>
2011-01-05 16:34 ` Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
2011-01-05 17:15 ` Scott Ribe <scott_ribe@elevated-dev.com>
2011-01-05 17:26 ` bricklen <bricklen@gmail.com>
2011-01-05 16:35 ` Scott Ribe <scott_ribe@elevated-dev.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