From: thhal at mailblocks.com (Thomas Hallgren)
Date: Fri, 09 Sep 2005 11:25:33 +0200
Subject: [Pljava-dev] Errors running pljava test
In-Reply-To: <43215109.2060004@tokuii.com>
References: <431FBC71.5060803@tokuii.com>
	<431FD8ED.9050502@mailblocks.com>
	<thhal-0cHH7A5PG8LQxk2Nv1nWW2ejTEXji1F@mailblocks.com>
	<431FE0EB.5070601@tokuii.com>
	<431FE4BE.30304@mailblocks.com>
	<thhal-0QH37AwvH8LQwoKdphUc8mxoLtzBLd8@mailblocks.com>
	<43200729.1090407@tokuii.com> <43215109.2060004@tokuii.com>
	<4321550D.2000109@mailblocks.com>
	<thhal-0kO38A2nS8LQ1wXIaoHm0uVZBI23sC/@mailblocks.com>
Message-ID: <thhal-0ke38A2vS8LQTTwqQlsEeTbF7e+de95@mailblocks.com>

kstian wrote:

> Hi Thomas,
>
> I have switched to using Sun-jdk-1.4.2.08.  The pljava test is still 
> hanging in the middle. Sometimes, it hung at "*** 
> testBinaryColumns()", sometimes, it also hung at "*** DatabaseMetaData 
> 'int' functions:"
>
> Is there anything I can try?

That depends on how much time you have :-) I don't have your environment 
and I'm not able to reproduce the hanging so it would be very helpful if 
you could try two things. The first one is simple. Just change the 
log_min_messages setting in the postgresql.conf file to debug1 and run 
again. The log will be somewhat more verbose and perhaps that can give 
me a better idea of what's happening. The second thing requires a bit 
more work:

a. Compile PostgreSQL configured with --enable-debug
b. Compile PL/Java with MAKE CFLAGS=-g
c. Run the tests again. Once it hangs, attach to the backend process 
(the postgres that represents your sessoin) with GDB and print a stack 
backtrace. That should say a lot about where it hangs.

Regards,
Thomas Hallgren