Re: [HACKERS] Backend sent 0x45 type while idle - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Backend sent 0x45 type while idle
Date
Msg-id 8946.928163527@sss.pgh.pa.us
Whole thread Raw
In response to Backend sent 0x45 type while idle  (Trever Adams <trever_Adams@bigfoot.com>)
List pgsql-hackers
Trever Adams <trever_Adams@bigfoot.com> writes:
> did a pgdump of the database (cannot remember command line options...
> data and schema I remember that much).  I then loaded it into a newly
> created database on the new machine.

> I get the error above (or something VERY similar...).

When exactly?  While trying to reload the pg_dump script, or during
subsequent usage of the database?

> I have posted a
> bug report, but I want to know what the heck the message really means. 
> What is type 0x45?  Does this mean my app has a problem or?

It's probably a symptom of a backend bug :-(.  It means that libpq
wasn't expecting a backend message when it got one.  0x45 = 'E' which
would be the start of an Error message, which ordinarily shouldn't be
emitted except in response to a frontend query.  Try looking in the
postmaster log --- the error message should be logged there as well.
Knowing what the backend is trying to tell us would be helpful...

Another possibility is that the frontend and backend got out of sync,
which is particularly likely during COPY commands --- does your pg_dump
script use COPY or INSERT to reload data into tables?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Open 6.5 items
Next
From: Horak Daniel
Date:
Subject: RE: [HACKERS] report for Win32 port