agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone
@ 2008-03-04 20:27
0 siblings, 1 reply; 3+ messages in thread
From: @ 2008-03-04 20:27 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone
@ 2008-03-04 21:19
parent:
0 siblings, 1 reply; 3+ messages in thread
From: @ 2008-03-04 21:19 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone
@ 2008-03-04 23:31
parent:
0 siblings, 0 replies; 3+ messages in thread
From: @ 2008-03-04 23:31 UTC (permalink / raw)
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-04 23:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-04 20:27 [Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone
2008-03-04 21:19 `
2008-03-04 23:31 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox