From: | Ron Snyder <snyder(at)roguewave(dot)com> |
---|---|
To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
Cc: | Ron Snyder <snyder(at)roguewave(dot)com>, 'Henrik Steffen' <steffen(at)city-map(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Invalid length of startup packet |
Date: | 2002-05-28 16:28:25 |
Message-ID: | F888C30C3021D411B9DA00B0D0209BE803BB9A0E@cvo-exchange.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> timestamp [PID] LOG: received connection from foo.bar port 12345
> timestamp [PID] FATAL: Invalid length of startup packet
>
> The PID in the first of these messages would already be the PID of the
> forked-off child, so there would be a clear correlation to
> the following
> failure message, even if other connection requests were being
> processed
> at about the same time.
That works for me, although won't there will be some redundancy in some
cases?
May 28 09:14:55 vault pgqv[4332]: [1] DEBUG: connection:
host=172.21.41.62:3586 user=dbuser database=test
I can live with that redundancy, especially considering that some of our
logging tools rely on those three pieces of information being together.
If the output becomes something similar to this:
May 28 09:14:55 vault pgqv[4332]: [1] DEBUG: connection:
host=172.21.41.62:3586
May 28 09:14:55 vault pgqv[4332]: [2] DEBUG: authorize: user=dbuser
database=test
Or
May 28 09:14:55 vault pgqv[4332]: [1] DEBUG: connection:
host=172.21.41.62:3586
May 28 09:14:55 vault pgqv[4332]: [2] FATAL: Invalid length of startup
packet
Then we (my group) could adjust. We're flexible. :)
To answer an earlier question:
> the text of the error message. So the "attempted connection" message
> would have to be logged unconditionally for every connection attempt.
> Does that seem useful? Would you want it to be automatic when
> LOG_CONNECTIONS is on, or should it require some higher-than-normal
> debug setting?
I think that it should be automatic when LOG_CONNECTIONS is on. I have
connection logging on specifically so I can discover this _type_ of problem.
(specifically, relating problems seen later in a connection back to the
client that initiated it)
-ron
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-05-28 16:45:35 | Re: triggers cant see functions |
Previous Message | Chris Humphries | 2002-05-28 15:01:02 | triggers cant see functions |