From: kongsen.tian at tokuii.com (kstian) Date: Fri, 09 Sep 2005 17:39:34 +0800 Subject: [Pljava-dev] Errors running pljava test In-Reply-To: References: <431FBC71.5060803@tokuii.com> <431FD8ED.9050502@mailblocks.com> <431FE0EB.5070601@tokuii.com> <431FE4BE.30304@mailblocks.com> <43200729.1090407@tokuii.com> <43215109.2060004@tokuii.com> <4321550D.2000109@mailblocks.com> Message-ID: <43215856.3070606@tokuii.com> Hi Thomas, I just tried the first option. Enclosed is the debug info in postgresql.log in case you can spot something quick (since I can't). Otherwise, I will try second option and see how much I can do. Thank you so much again. Regards, Kong Thomas Hallgren wrote: > 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 > > > > -------------- next part -------------- A non-text attachment was scrubbed... Name: postgresql.log Type: text/x-log Size: 13542 bytes Desc: not available URL: