Re: FATAL: invalid frontend message type 8 - Mailing list pgsql-general

From Tom Lane
Subject Re: FATAL: invalid frontend message type 8
Date
Msg-id 2330.1092850464@sss.pgh.pa.us
Whole thread Raw
In response to FATAL: invalid frontend message type 8  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: FATAL: invalid frontend message type 8
List pgsql-general
Steve Crawford <scrawford@pinpointresearch.com> writes:
> I've started seeing the following in my logs:
> FATAL:  invalid frontend message type 8

> I searched back over a month and there are 5 instances of this error
> of which 4 are in the last 24 hours.

> I could not find this error defined. Any ideas of what it means, it's
> severity, how to track the cause and cure?

It looks to me like you've got an erroneous client that is sending bad
data.  The error is from tcop/postgres.c, when it doesn't recognize the
first byte of what should be a message:

        default:
            /*
             * Otherwise we got garbage from the frontend.  We treat this
             * as fatal because we have probably lost message boundary
             * sync, and there's no good way to recover.
             */
            ereport(FATAL,
                    (errcode(ERRCODE_PROTOCOL_VIOLATION),
                     errmsg("invalid frontend message type %d", qtype)));

Can you determine exactly which client-side code is provoking the error?

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Installing FullTextSearchTool tsearch2
Next
From: Devrim GUNDUZ
Date:
Subject: Re: (S)RPMS for 7.4.4 released.