f



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

OK, getting closer.  The error happens if in jdbc I reuse
PreparedStatement objects to reexecute the same set of queries multiple
times.  Specifically if I do the following set of queries:

Declare cursor
Close cursor
Declare cursor
Close cursor
Declare cursor
Close cursor
Declare cursor
Close cursor
Declare cursor=20
Close cursor

After the 5th close the server will gpf on windows (if I add fetches
between the declare and close then I don't get a gfp, but instead get
"ERROR: unrecognized node type: 0"

I believe the current jdbc driver begins to use a named portal for reuse
after five executions of the same jdbc PreparedStatement (until then it
uses an unnamed portal), which would seem to jive with the fact that it
errors after the fifth execution. (Oliver please correct me if I am
wrong here).

If you still need a test case, let me know, and I will continue to
package up what I have been working on.

Thanks,
--Barry

-----Original Message-----
From: Barry Lind=20
Sent: Monday, November 22, 2004 7:48 PM
To: pgsql-jdbc@postgresql.org; pgsql-hackers@postgresql.org
Subject: FW: [HACKERS] [JDBC] Strange server error with current 8.0beta
driver

I have been unable to come up with a simple test case for this problem
(yet).  But here is some additional information.

Today I setup a 7.4.6 and an 8.0.0beta5 on linux (RH9) and could also
reproduce the problem.  However there were some new twists.

I now sometimes get the following error on 8.0:

ERROR:  cache lookup failed for function 18005

I did as Tom suggested and rebuilt with --enable-cassert and strangely
that made the problem more difficult to reproduce.  Once I finally was
able to get the server to start having errors, I got the following
interesting message in the log file:

TRAP: FailedAssertion("!(serializable ? !((MyProc->xmin) !=3D
((TransactionId) 0)) : ((MyProc->xmin) !=3D ((TransactionId) 0)))", File:
"sinval.c", Line: 767)


I am going to try to continue to see if I can come up with a test case,
but I wanted to pass this information on in case it might mean anything
to anyone.

Thanks,
--Barry


-----Original Message-----
From: Barry Lind
Sent: Friday, November 19, 2004 5:40 PM
To: Kris Jurka
Cc: pgsql-jdbc@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [JDBC] Strange server error with current 8.0beta
driver

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@ejurka.com]
Sent: Friday, November 19, 2004 3:57 PM
To: Barry Lind
Cc: pgsql-jdbc@postgresql.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=20
> 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:
>=20
> 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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

0
blind
11/23/2004 5:34:48 AM
comp.postgresql.hackers 2733 articles. 0 followers. Post Follow

1 Replies
395 Views

Similar Articles

[PageSpeed] 2

"Barry Lind" <blind@xythos.com> writes:
> OK, getting closer.  The error happens if in jdbc I reuse
> PreparedStatement objects to reexecute the same set of queries multiple
> times.

The TRAP you showed looked like it might have something to do with
trying to execute code outside any transaction.  But I dunno how it got
there.

> If you still need a test case, let me know, and I will continue to
> package up what I have been working on.

What I'd actually rather have is a list of the exact sequence of
messages sent to the server.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

0
tgl
11/23/2004 3:09:51 PM
Reply:

Similar Artilces:

FW: [JDBC] Strange server error with current 8.0beta driver
I have been unable to come up with a simple test case for this problem (yet). But here is some additional information. Today I setup a 7.4.6 and an 8.0.0beta5 on linux (RH9) and could also reproduce the problem. However there were some new twists. I now sometimes get the following error on 8.0: ERROR: cache lookup failed for function 18005 I did as Tom suggested and rebuilt with --enable-cassert and strangely that made the problem more difficult to reproduce. Once I finally was able to get the server to start having errors, I got the following interesting message in the lo...

FW: [JDBC] Strange server error with current 8.0beta driver
I have been unable to come up with a simple test case for this problem (yet). But here is some additional information. Today I setup a 7.4.6 and an 8.0.0beta5 on linux (RH9) and could also reproduce the problem. However there were some new twists. I now sometimes get the following error on 8.0: ERROR: cache lookup failed for function 18005 I did as Tom suggested and rebuilt with --enable-cassert and strangely that made the problem more difficult to reproduce. Once I finally was able to get the server to start having errors, I got the following interesting message in the lo...

Re: Re: {Spam?} RE: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
Seconded.<br /><br />j.<br /><br /><p>On Apr 14, 2009, <strong>Obnoxio The = Clown</strong> &lt;obnoxio@serendipita.com&gt; wrote: </p><div class=3D"rep= lyBody"><blockquote style=3D"padding-left: 1ex; margin: 0pt 0pt 0pt 1.8ex; = border-left: #267fdb 2px solid">Ian Michael Gumby wrote:<br />&gt; Poor Clo= wn.<br />&gt; <br />&gt; What don't you understand?<br /><br />Why you won'= t just shut the fuck up, ever.<br /><br />-- <br />Che...

MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the MS SQL Server 2000 onto two computers, which reside on the same network. (In fact, these two computers comprise the entire network). The network server (computer name=SUNCDS1), and the lone node (SUNCDS2), each have their own SQL Server 2000 instance. The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2. It may be worthwhile to mention t...

Re: postgresql 8
This is with the MSI installer, right? Try using .\user instead of servername\user. This apparantly does not work on all OS versions, and I just can't remember which doesn't work, but it's worth a try. In general, try to fix your machine :) Having different netbios and DNS names *will* give you problems, and not just with postgresql. //Magnus > -----Original Message----- > From: Van den bosch [mailto:Guy@mcsc.be] > Sent: Thursday, August 19, 2004 10:33 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] postgresql 8 - DNS server > > Unable to install ...

Re: postgresql 8
This is with the MSI installer, right? Try using .\user instead of servername\user. This apparantly does not work on all OS versions, and I just can't remember which doesn't work, but it's worth a try. In general, try to fix your machine :) Having different netbios and DNS names *will* give you problems, and not just with postgresql. //Magnus > -----Original Message----- > From: Van den bosch [mailto:Guy@mcsc.be] > Sent: Thursday, August 19, 2004 10:33 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] postgresql 8 - DNS server > > Unable to install ...

Re: pgadminII error in connecting to PostgreSQL Server
Hi! I have already created database on my postgresql server and connected successfully using pgsql command on linux machine. I've installed my pgadminII build 1.6 to windows 98 machine. My problem is that when I try to connect using the said pgadmin it gives me an error of "class does not support Automation or does not Support expected interface" What dows it mean? Can you help me? Regards, dojie __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------(end of b...

JDBC driver for Postgresql 8.1.3
Hi, trouble finding JDBC driver for Postgresql version 8.1.3. Postgresql-homepage has only drivers for newer versions. Br, Miikka Miipe wrote: > Hi, > > trouble finding JDBC driver for Postgresql version 8.1.3. > Postgresql-homepage has only drivers for newer versions. > > Br, Miikka > I don't know where you looked. Look @ http://www.postgresql.org/ftp/odbc/versions/ and download the appropriate format for PostgreSQL 8.01. Don't worry about matching the minor version number (e.g. PostgreSQL 8.01.x will work with an ODBC driver psqlodbc 8.01.y) As long...

Re: pgadminII error in connecting to PostgreSQL Server
Hi! I have already created database on my postgresql server and connected successfully using pgsql command on linux machine. I've installed my pgadminII build 1.6 to windows 98 machine. My problem is that when I try to connect using the said pgadmin it gives me an error of "class does not support Automation or does not Support expected interface" What dows it mean? Can you help me? Regards, dojie __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------(end of b...

Re: PostgreSQL 8 on Win2003 AD server
There is a known issue with installations on Domain Controllers. See pgfoundry tracker item at http://pgfoundry.org/tracker/index.php?func=3Ddetail&aid=3D1000096&group_id= =3D 1000007&atid=3D126. You can get through part of it by specifying DOMAIN\username, but there may be further issues down the road from there. If this doesn't work, you can install it *without* installing as a service. Then create the account and register it manually using "pg_ctl register". The issue is only in the installer, not in postgresql itself. //Magnus > -----Original...

Re: pgadminII error in connecting to PostgreSQL Server #2
Dojie; Have you already tried the solution below (from archives)? ************************************************************************ ****** Re: [pgadmin-support] pgAdmin II connection error ------------------------------------------------------------------------ -------- From: Dave Page Subject: Re: [pgadmin-support] pgAdmin II connection error Date: Wed, 20 Aug 2003 11:46:09 -0700 ------------------------------------------------------------------------ -------- Please try (re)installing the latest version of MDAC from http://www.microsoft.com/data Regard,s D...

Unable to find JDBC Driver error on Linux server
Hi, I have to run a script which basically connects to MySQL database on Linux server and pulls data from a table. I'm trying this on Linux server with MATLAB Installed on the server as well. I have installed MySQL. I used the below function: conn = database('Database','username','password','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/database-name'); and conn = database('Database','username','password','Vendor','MySQL','Server','Server name'); but when i run the above cod...

BUG report, BIND crash when dlz postgresql driver receives error from database server.
--001a11c306285e1ebb04fef26c4b Content-Type: text/plain; charset=UTF-8 I attempted to submit this bug report via the online form, but that failed ("Failed to send your message. Please try later or contact the administrator by another method.") Bind, configured with "dlz postgresql", successfully connects to the database, but crashes (or corrupts the heap, randomly) on the very first query submitted, if the "find zone" query receives a "permission denied" error from Postgresql. The problem goes away when I correct the permissions on the...

Re: Also cannot build the postgresql server under Mingw using 8.0 beta 2
This is a multi-part message in MIME format. ------_=_NextPart_001_01C49058.9FD51EAF Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Adding this to the c.h file solved most of the problems for the libpq DLL: =20 #if defined(HAVE_STRINGS_H) && !defined(_MSC_VER) #include <strings.h> #endif .... #if defined(WIN32) && defined(_MSC_VER) #include <winsock2.h> #define snprintf _snprintf #endif Since I ran configure for MINGW (which has strings.h) it creates a header file which is partly invalid for...

Web resources about - Re: [JDBC] Strange server error with current 8.0beta driver - comp.postgresql.hackers

Strange - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Matthew Perry not joining Friends reunion; ‘strange’ appearance on Graham Norton Show
HE may have shot down the much-hyped Friends reunion, but that wasn’t what got people talking when Matthew Perry dropped in for a visit to Graham ...

The Strange Brew of Curious Political Data
It happens every election season: A flood of eye-catching data points turn up in political stories about voters. More Democrats like salsa music ...

Cardinals’ Rashad Johnson responds to strange analysis
Most of the time, athletes don't take exception to criticism. But when the analysis is so inaccurate they have to, like Arizona's Rashad Johnson ...

Strange Trades Are Happening in Global Markets
Have the global financial markets lost their collective mind?

A Strange But Effective Tool
LoL by: Unknown Tagged: cat , baby , pacifier Share on Facebook

Strange Bedfellows: Atlantis, Backed By Cisco, Inks Hyper-Converged Deal With Dell
Strange Bedfellows: Atlantis, Backed By Cisco, Inks Hyper-Converged Deal With Dell CRN Atlantis Computing, a hyper-converged infrastructure ...

R. Kelly Defends Bill Cosby: ‘It’s Strange The Accusers Waited So Long’
R. Kelly Defends Bill Cosby: ‘It’s Strange The Accusers Waited So Long’

Everything You Need To Know About Last Night's Strange Coin Toss
Something extremely unusual happened during the overtime coin toss of last night’s Packers-Cardinals game. After Green Bay quarterback Aaron ...

The Grateful Dead Literary-Industrial Complex Is A Long, Strange Trip All Its Own
The Grateful Dead are with us, always—in the past year, inescapably so. In our modern, retromaniacal culture, their benevolent aims and DIY apparatuses, ...

Resources last updated: 1/27/2016 12:13:17 PM