pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error msg
3+ messages / 3 participants
[nested] [flat]

* Error msg
@ 1999-01-30 17:00 Bill Brandt <brandtwr-pgsql@draaw.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Bill Brandt @ 1999-01-30 17:00 UTC (permalink / raw)
  To: pgsql-sql@hub.org

I'm running 6.3 right now... I've been having a problem that results in
this message:

PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
        This probably means the backend terminated abnormally before or
while processing the request.

It occurs anytime someone who does not have the proper permissions
attempts to create something in the database.  This particular one was
caused by the root user attempting to create an index.  The problem with
it is, that the name of the index is now assigned to something that
doesn't exist.  I later logged in as postgres (the users postgres is
running under) and attempted to execute the same command.  I get the
following error:

ERROR:  cannot open cntrsindx

If I change the name of the index slightly, it works.  I don't know if
this is a problem in 6.3 that is fixed in 6.4 or what.  I was just
wondering if I'm missing something that will free up those entries that
"half exist".  

-- 
Bill Brandt                                   
brandtwr@draaw.net                              http://www.draaw.net/



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

* Error msg.
@ 2001-05-23 21:00 Diehl, Jeffrey <jdiehl@sandia.gov>
  2001-05-23 21:57 ` Re: Error msg. Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Diehl, Jeffrey @ 2001-05-23 21:00 UTC (permalink / raw)
  To: pgsql-sql

Hi all,

I've been getting strange error messages from a new installation of
postgres.  Occasionally, it prints out:

"invalid packet length"

What does this mean?  Should I worry?

Thanx in advance,
Mike Diehl,
Network Monitoring Tool Devl.
Sandia National Laboratories.
(505) 284-3137
jdiehl@sandia.gov




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

* Re: Error msg.
  2001-05-23 21:00 Error msg. Diehl, Jeffrey <jdiehl@sandia.gov>
@ 2001-05-23 21:57 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2001-05-23 21:57 UTC (permalink / raw)
  To: Diehl, Jeffrey <jdiehl@sandia.gov>; +Cc: pgsql-sql

"Diehl, Jeffrey" <jdiehl@sandia.gov> writes:
> I've been getting strange error messages from a new installation of
> postgres.  Occasionally, it prints out:

> "invalid packet length"

> What does this mean?  Should I worry?

It means the postmaster got a message with an unreasonable packet length
(first word of the connect request message is supposed to be its total
length, IIRC).  Yes, I'd wonder about it too.  Got any broken clients,
portscanners hitting 5432, etc?

			regards, tom lane



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


end of thread, other threads:[~2001-05-23 21:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-30 17:00 Error msg Bill Brandt <brandtwr-pgsql@draaw.net>
2001-05-23 21:00 Error msg. Diehl, Jeffrey <jdiehl@sandia.gov>
2001-05-23 21:57 ` Re: Error msg. 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