Re: [JDBC] Strange server error with current 8.0beta driver

From: "Barry Lind" <blind(at)xythos(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [JDBC] Strange server error with current 8.0beta driver
Date: 2004-11-20 01:40:04
Message-ID: 03E7D3E231BB7B4A915A6581D4296CC6C08B66@NSNOVPS00411.nacio.xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Kris,

Environment #1: WinXP 8.0beta4 server, 8.0jdbc client

I get random failures with the following errors:
$ grep ERROR postgresql-2004-11-19_091524.log
2004-11-19 12:19:06 ERROR: unrecognized node type: 25344832
2004-11-19 12:20:06 ERROR: unrecognized node type: 25344832
2004-11-19 12:21:06 ERROR: unrecognized node type: 0
2004-11-19 12:22:06 ERROR: unrecognized node type: 0
2004-11-19 12:23:06 ERROR: unrecognized node type: 0
2004-11-19 12:24:06 ERROR: unrecognized node type: 0
2004-11-19 12:25:06 ERROR: unrecognized node type: 0
2004-11-19 12:26:06 ERROR: unrecognized node type: 0
2004-11-19 12:27:06 ERROR: unrecognized node type: 0
2004-11-19 12:28:06 ERROR: unrecognized node type: 653
2004-11-19 12:29:06 ERROR: unrecognized node type: 0
2004-11-19 12:30:06 ERROR: unrecognized node type: 0
2004-11-19 12:30:30 ERROR: unrecognized node type: 26
2004-11-19 12:31:06 ERROR: unrecognized node type: 0
2004-11-19 12:32:06 ERROR: unrecognized node type: 0
2004-11-19 12:33:06 ERROR: unrecognized node type: 0
2004-11-19 12:34:06 ERROR: unrecognized node type: 0
2004-11-19 12:35:06 ERROR: unrecognized node type: 0
2004-11-19 12:36:06 ERROR: unrecognized node type: 0
2004-11-19 12:37:06 ERROR: unrecognized node type: 0

Environment #2: Sun Solaris 7.4.3 server, 8.0jdbc client

I get random failures with the following errors:
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1
ERROR: no value found for parameter 1

I am seeing errors in the two different environments where I am testing
the 8.0 driver (which fully uses the V3 protocol), I don't have errors
with the 7.4 driver (which only used basic V3 protocol features). I
will work to try to come up with a smaller reproducable test case and
repro in a linux environment where I can do more.

Thanks,
--Barry

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Friday, November 19, 2004 3:57 PM
To: Barry Lind
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Strange server error with current 8.0beta driver

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2004-11-20 07:53:08 Re: Error handling in plperl and pltcl
Previous Message Tom Lane 2004-11-20 01:07:05 Re: Error handling in plperl and pltcl

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-11-20 04:47:41 Re: Patch for jdbc escaped functions
Previous Message Tom Lane 2004-11-20 01:28:55 Re: Strange server error with current 8.0beta driver