Обсуждение: Help with error message
During our load testing we saw the errors below. I believe that the "Sorry, too many clients already" is because we exceeding the max connections to the database. The "Socket command type 'unknown" error I do not understand.
Our installation is postgres 7.2.1 on Solaris 8 sun server. Thanks for any help!
Oct 16 14:41:28 test postgres[12736]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 14:43:27 test postgres[12754]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 14:43:58 test postgres[12770]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 14:44:32 test postgres[12789]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 15:05:45 test postgres[12868]: [ID 553393 local0.error] [2]
FATAL 1: Sorry, too many clients already
Oct 16 15:05:58 test postgres[12907]: [ID 553393 local0.error] [2]
FATAL 1: Sorry, too many clients already
Oct 16 15:08:28 test postgres[14278]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
FATAL 1: Socket command type ' unknown
Oct 16 14:43:27 test postgres[12754]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 14:43:58 test postgres[12770]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 14:44:32 test postgres[12789]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
Oct 16 15:05:45 test postgres[12868]: [ID 553393 local0.error] [2]
FATAL 1: Sorry, too many clients already
Oct 16 15:05:58 test postgres[12907]: [ID 553393 local0.error] [2]
FATAL 1: Sorry, too many clients already
Oct 16 15:08:28 test postgres[14278]: [ID 553393 local0.error] [3]
FATAL 1: Socket command type ' unknown
"JOE" <joe@piscitella.com> writes:
> During our load testing we saw the errors below. I believe that the "Sorry=
> , too many clients already" is because we exceeding the max connections to =
> the database.
Check.
> The "Socket command type ' unknown" error I do not understand.
The most likely bet is loss of synchronization between backend and
client. The typical scenario is that the client is sending COPY data
and the server has a problem with some row and errors out. The client
keeps sending COPY data, so the next thing the server gets is more
COPY data instead of the fresh command it's expecting. If the first
character of the additional data is "'" then you'd get the above
message. Is your load testing exercising COPY with bad data?
(Yes, the COPY protocol is misdesigned. We're talking about fixing
that in 7.4.)
regards, tom lane