pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Invalid frontend message type 87?
2+ messages / 2 participants
[nested] [flat]

* Invalid frontend message type 87?
@ 2007-05-10 08:37  Szabolcs BALLA <szballa@confinsystems.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Szabolcs BALLA @ 2007-05-10 08:37 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I have a problem with postgresql 8.1.4. and libpq 4.
I found this error message in the log file: PGRES_FATAL_ERROR invalid frontend message type 87
As I see it is coming from libpqfe.c 

Do you have any idea about this message?

The sql query what I want to run it's very simpe....
Thanks,
Szabolcs BALLA





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Invalid frontend message type 87?
@ 2007-05-10 15:12  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Szabolcs BALLA <szballa@confinsystems.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2007-05-10 15:12 UTC (permalink / raw)
  To: Szabolcs BALLA <szballa@confinsystems.com>; +Cc: pgsql-admin

Szabolcs BALLA <szballa@confinsystems.com> writes:
> I have a problem with postgresql 8.1.4. and libpq 4.
> I found this error message in the log file: PGRES_FATAL_ERROR invalid frontend message type 87

"Invalid frontend message" means the server got a message with an
unexpected first byte, which usually means the server and libpq got
out of sync about where the message boundaries are.  It's been quite
a long time since we've seen an actual bug of that sort, though.
The cases that I've heard of recently involve multiple threads in an
application trying to use the same PGconn without any interlocking.
You can't have multiple queries active on a single connection, but
libpq itself doesn't contain any locking to prevent multiple threads
from trying to use the PGconn at once.

If you're getting this with a single-threaded client, please submit
a test case to pgsql-bugs.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-05-10 15:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-10 08:37 Invalid frontend message type 87? Szabolcs BALLA <szballa@confinsystems.com>
2007-05-10 15:12 ` Tom Lane <tgl@sss.pgh.pa.us>

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