[Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone

I have been trying to install pljava on a system and keep running into
the same issue. I have managed to work my way through the majority of
the common installation issues (libjvm not in ldconfig, etc), but now
I'm stuck.

My system:

Red Hat Linux ES 5 (selinux disabled)

Postgres 8.2.6

Java jre1.6.0

When I try to run the "deploy" command, I get:

java -cp $CLASSPATH org.postgresql.pljava.deploy.Deployer -install
-database provision -user postgres

org.postgresql.util.PSQLException: ERROR: could not load library

"/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined

symbol: session_timezone at

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1592)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1327)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
192)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:451)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:336)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:328)

at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474
)

at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

Linking wise, if I do an ldd -v /usr/share/pljava/pljava.so, I see the

following:

[root at localhost pljava]# ldd -v /usr/share/pljava/pljava.so

linux-gate.so.1 =3D> (0x00d49000)

libjvm.so =3D> /usr/java/latest//lib/i386/client/libjvm.so

(0x00d4a000)

libc.so.6 =3D> /lib/libc.so.6 (0x00175000)

libm.so.6 =3D> /lib/libm.so.6 (0x00110000)

libdl.so.2 =3D> /lib/libdl.so.2 (0x00b20000)

libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00ad6000)

/lib/ld-linux.so.2 (0x006b8000)

Version information:

/usr/share/pljava/pljava.so:

libjvm.so (SUNWprivate_1.1) =3D>
/usr/java/latest//lib/i386/client/libjvm.so

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

/usr/java/latest//lib/i386/client/libjvm.so:

libm.so.6 (GLIBC_2.0) =3D> /lib/libm.so.6

libdl.so.2 (GLIBC_2.1) =3D> /lib/libdl.so.2

libdl.so.2 (GLIBC_2.0) =3D> /lib/libdl.so.2

libc.so.6 (GLIBC_2.2.4) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

libpthread.so.0 (GLIBC_2.2.3) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.2) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.0) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.1) =3D> /lib/libpthread.so.0

/lib/libc.so.6:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.3) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.1) =3D> /lib/ld-linux.so.2

/lib/libm.so.6:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

/lib/libdl.so.2:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_PRIVATE) =3D> /lib/libc.so.6

/lib/libpthread.so.0:

ld-linux.so.2 (GLIBC_2.3) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.1) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.3.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_PRIVATE) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

I tried to run "ldconfig" on the /usr/share/pljava directory, but it did
not appear to find anything in that directory.

[root at localhost pljava]# ldconfig -v /usr/share/pljava

/usr/share/pljava:

/usr/lib/qt-3.3/lib:

libqui.so.1 -> libqui.so.1.0.0

libqt-mt.so.3 -> libqt-mt.so.3.3.6

/lib:

libnss_ldap.so.2 -> libnss_ldap-2.5.so . . .

Finally, when I do an "ldd -r" on the pljava.so file, I see the
following (and many more) unrecognized symbols. Anyone have a clue what
libraries I'm missing?

[root at localhost pljava]# ldd -r pljava.so

linux-gate.so.1 =3D> (0x00c2a000)

libjvm.so =3D> /usr/java/latest//lib/i386/client/libjvm.so
(0x00cc5000)

libc.so.6 =3D> /lib/libc.so.6 (0x002dd000)

libm.so.6 =3D> /lib/libm.so.6 (0x006df000)

libdl.so.2 =3D> /lib/libdl.so.2 (0x00292000)

libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00421000)

/lib/ld-linux.so.2 (0x006b8000)

undefined symbol: QueryCancelPending (./pljava.so)

undefined symbol: proc_exit_inprogress (./pljava.so)

undefined symbol: SPI_tuptable (./pljava.so)

undefined symbol: CurrentMemoryContext (./pljava.so)

undefined symbol: PG_exception_stack (./pljava.so)

undefined symbol: MyProcPid (./pljava.so)

undefined symbol: TopMemoryContext (./pljava.so)

undefined symbol: assert_enabled (./pljava.so)

undefined symbol: textout (./pljava.so)

undefined symbol: stack_base_ptr (./pljava.so)

undefined symbol: ProcDiePending (./pljava.so)

undefined symbol: log_min_messages (./pljava.so)

undefined symbol: SPI_result (./pljava.so)

undefined symbol: session_timezone (./pljava.so)

undefined symbol: error_context_stack (./pljava.so)

undefined symbol: SPI_processed (./pljava.so)

undefined symbol: client_min_messages (./pljava.so)

undefined symbol: InterruptPending (./pljava.so)

undefined symbol: SPI_execute_plan (./pljava.so)

undefined symbol: heap_copytuple (./pljava.so)

undefined symbol: elog_finish (./pljava.so)

undefined symbol: inv_drop (./pljava.so)

undefined symbol: SPI_cursor_fetch (./pljava.so)

Anyone have any ideas of what to try next?

Michael

This message is confidential to Prodea Systems, Inc unless otherwise indicated
or apparent from its nature. This message is directed to the intended recipient
only, who may be readily determined by the sender of this message and its
contents. If the reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to the intended
recipient:(a)any dissemination or copying of this message is strictly
prohibited; and(b)immediately notify the sender by return message and destroy
any copies of this message in any form(electronic, paper or otherwise) that you
have.The delivery of this message and its information is neither intended to be
nor constitutes a disclosure or waiver of any trade secrets, intellectual
property, attorney work product, or attorney-client communications. The
authority of the individual sending this message to legally bind Prodea Systems
is neither apparent nor implied,and must be independently verified.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080304/63b39f68/attachment.html>

On Tue, 4 Mar 2008, Mike Toler wrote:

> I have been trying to install pljava on a system and keep running into
> the same issue. I have managed to work my way through the majority of
> the common installation issues (libjvm not in ldconfig, etc), but now
> I'm stuck.
>
> Postgres 8.2.6
>
> org.postgresql.util.PSQLException: ERROR: could not load library
> "/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined
> symbol: session_timezone at
>

It looks like you're trying to load a pljava build for postgresql 8.3 into
an 8.2 server because session_timezone is an 8.3 only symbol. Are you
sure you've got the right version? Did you download this or build it
yourself?

Kris Jurka

Ok, now I feel like an idiot.

First I downloaded the 64 bit version of pljava, then the wrong postgres
version of it.

Thanks.

Michael

> -----Original Message-----
> From: Kris Jurka [mailto:books at ejurka.com]
> Sent: Tuesday, March 04, 2008 3:20 PM
> To: Mike Toler
> Cc: pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] (Third try to post) Installation issue:
> /usr/share/pljava/pljava.so: undefined symbol: session_timezone
>
>
>
> On Tue, 4 Mar 2008, Mike Toler wrote:
>
> > I have been trying to install pljava on a system and keep running
into
> > the same issue. I have managed to work my way through the majority
of
> > the common installation issues (libjvm not in ldconfig, etc), but
now
> > I'm stuck.
> >
> > Postgres 8.2.6
> >
> > org.postgresql.util.PSQLException: ERROR: could not load library
> > "/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so:
undefined
> > symbol: session_timezone at
> >
>
> It looks like you're trying to load a pljava build for postgresql 8.3
into
> an 8.2 server because session_timezone is an 8.3 only symbol. Are you
> sure you've got the right version? Did you download this or build it
> yourself?
>
> Kris Jurka

This message is confidential to Prodea Systems, Inc unless otherwise indicated
or apparent from its nature. This message is directed to the intended recipient
only, who may be readily determined by the sender of this message and its
contents. If the reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to the intended
recipient:(a)any dissemination or copying of this message is strictly
prohibited; and(b)immediately notify the sender by return message and destroy
any copies of this message in any form(electronic, paper or otherwise) that you
have.The delivery of this message and its information is neither intended to be
nor constitutes a disclosure or waiver of any trade secrets, intellectual
property, attorney work product, or attorney-client communications. The
authority of the individual sending this message to legally bind Prodea Systems
is neither apparent nor implied,and must be independently verified.