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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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