Skip site navigation (1) Skip section navigation (2)

Re: Strange server error with current 8.0beta driver

From: Kris Jurka <books(at)ejurka(dot)com>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Strange server error with current 8.0beta driver
Date: 2004-11-19 23:57:27
Message-ID: Pine.BSO.4.56.0411191849080.25486@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 19 Nov 2004, Barry Lind wrote:

> During my testing with the 8.0 driver, I am occasionally getting
> failures.  The strange thing is that a test will only fail 1 out of 10
> times.  The error I am getting from the server is:
> 
> ERROR:  unrecognized node type: 25344832

This type of error points to a bug in the server.  It means a query plan
is created that it can't process.  A higher level node finds a lower level
node that it doesn't expect.  The variability of the test failure could be
due to different plans being generated (note that V2 vs V3 can generate
different plans because of string substitution vs a prepared query).  The
fact that the node number varies is a little suspicious, also because it's
a very large value.  Does it vary between a couple values or is it
different every time.  If it varies wildly then that could point to a 
memory overwrite instead of a bad plan being created, but in any case this 
problem is on the server side.

Kris Jurka


In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-11-20 01:28:55
Subject: Re: Strange server error with current 8.0beta driver
Previous:From: Barry LindDate: 2004-11-19 20:40:15
Subject: Strange server error with current 8.0beta driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group