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

Tue Mar 4 20:27:13 UTC 2008

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://pgfoundry.org/pipermail/pljava-dev/attachments/20080304/63b39f68/attachment.html 