Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2DWF-0005OF-Kg for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 18 Sep 2018 10:46:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g2DWD-0006lK-UT for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 18 Sep 2018 10:46:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2DWD-0006lD-Lr for pgsql-pkg-debian@lists.postgresql.org; Tue, 18 Sep 2018 10:46:09 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2DW9-00076a-Dh for pgsql-pkg-debian@postgresql.org; Tue, 18 Sep 2018 10:46:08 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 42F05l6dyCz3Dwv; Tue, 18 Sep 2018 12:46:03 +0200 (CEST) Date: Tue, 18 Sep 2018 12:46:03 +0200 From: Christoph Berg To: Chapman Flack Cc: pgsql-pkg-debian@postgresql.org Subject: Re: PL/Java 1.5.1_BETA2 Message-ID: <20180918104603.GE6196@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Chapman Flack , pgsql-pkg-debian@postgresql.org References: <5B96B226.2080803@anastigmatix.net> <20180915203221.GA19015@msg.df7cb.de> <5B9D73A2.2090402@anastigmatix.net> <20180916201808.GA30681@msg.df7cb.de> <5B9ECCD1.1050309@anastigmatix.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5B9ECCD1.1050309@anastigmatix.net> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Chapman Flack 2018-09-16 <5B9ECCD1.1050309@anastigmatix.net> > > i.e. it's replacing both occurrences of "i386" by "1". > > Ok, that's irritating. I can guess what is happening. I implement the > -Dpljava.libjvmdefault by passing the string into cpp with a -D, and that > gets converted to a string using the CppAsString2 macro, and that apparently > is not protected from expansion of other macros, and I bet something is > defining i386 to be 1. > > Phooey. > > I don't know if that will be easy to fix using cpp. An alternative would be > to pass it to cpp already quoted according to C rules, but that would be > somewhat ugly to express in a Maven build script. We could try "-Ui386" if there's a way to pass that flag into the build process? Filed at https://github.com/tada/pljava/issues/176, let's continue there. > Your SET command to correct the library name completed the installation > of PL/Java, but at that point it was no longer within a CREATE EXTENSION > command, so the various functions, tables, etc., have just been installed > 'loose' (exactly as they would if you were installing in 9.0 or earlier > with no 'extension' mechanism). Oh, that's unexpected. Wouldn't it be time to unsupport that and move to a "normal" extension .sql script? > > Proceeding to load the examples: > > > Server beendete die Verbindung unerwartet > > Is there anything in the server log with details of the crash? > In many cases there will be a lengthy message from the JVM in the server > log, and that message will contain a file name (something like > /tmp/hs_err_pidnnnn.log) which will contain *even more* detail. > I would be interested to see that. Was this still on i386 ? Filed as https://github.com/tada/pljava/issues/177 with attachment. > > 20:07:07 ERROR: java.lang.ClassNotFoundException: org.postgresql.pljava.example.annotation.ComplexTuple > > 20:07:07 CONTEXT: SQL statement "SELECT javatest.assertHasValues( CAST('(1,2)' AS javatest.complextuple), 1, 2)" > > I believe you'll find this a Heisenbug, and it will go away if you repeat > the build and the test. https://github.com/tada/pljava/issues/178 Christoph