[Pljava-dev] Problem PL/Java installation
Hauke Luckow
hauke.luckow at gmail.com
Fri Apr 25 16:20:37 UTC 2008
Hello all,
I try to install PL/Java on the following system:
OpenSUSE 10.2 (32bit)
PostgreSQL 8.1.11 i586
Java-1-6-0-sun 1.6.0 i586
PL/Java package: pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar.gz
I would very much appreciate if anybody of you can help me with that.
Thanks in advance.
During installation I receive the following errormessage:
java -cp postgresql.jar:pljava.jar:deploy.jar
org.postgresql.pljava.deploy.Deployer -database adempiere -user
adempiere -password adempiere -innstall
org.postgresql.util.PSQLException: FEHLER: konnte Bibliothek
»/opt/pljava/pljava.so« nicht laden: /opt/pljava/pljava.so: undefined
symbol: assert_enabled
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
Output "ldd -v /opt/pljava/pljava.so":
linux-gate.so.1 => (0xffffe000)
libjvm.so => /usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/client/libjvm.so
(0xb772a000)
libc.so.6 => /lib/libc.so.6 (0xb75ec000)
libm.so.6 => /lib/libm.so.6 (0xb75c6000)
libdl.so.2 => /lib/libdl.so.2 (0xb75c1000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb75a9000)
/lib/ld-linux.so.2 (0x80000000)
Version information:
/opt/pljava/pljava.so:
libjvm.so (SUNWprivate_1.1) =>
/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/client/libjvm.so
libc.so.6 (GLIBC_2.1.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.0) => /lib/libc.so.6
/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/client/libjvm.so:
libm.so.6 (GLIBC_2.0) => /lib/libm.so.6
libdl.so.2 (GLIBC_2.1) => /lib/libdl.so.2
libdl.so.2 (GLIBC_2.0) => /lib/libdl.so.2
libc.so.6 (GLIBC_2.2.4) => /lib/libc.so.6
libc.so.6 (GLIBC_2.1) => /lib/libc.so.6
libc.so.6 (GLIBC_2.1.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.1.2) => /lib/libc.so.6
libc.so.6 (GLIBC_2.2) => /lib/libc.so.6
libc.so.6 (GLIBC_2.0) => /lib/libc.so.6
libpthread.so.0 (GLIBC_2.2.3) => /lib/libpthread.so.0
libpthread.so.0 (GLIBC_2.2) => /lib/libpthread.so.0
libpthread.so.0 (GLIBC_2.0) => /lib/libpthread.so.0
libpthread.so.0 (GLIBC_2.1) => /lib/libpthread.so.0
/lib/libc.so.6:
ld-linux.so.2 (GLIBC_PRIVATE) => /lib/ld-linux.so.2
ld-linux.so.2 (GLIBC_2.3) => /lib/ld-linux.so.2
ld-linux.so.2 (GLIBC_2.1) => /lib/ld-linux.so.2
/lib/libm.so.6:
ld-linux.so.2 (GLIBC_PRIVATE) => /lib/ld-linux.so.2
libc.so.6 (GLIBC_2.1.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.0) => /lib/libc.so.6
/lib/libdl.so.2:
ld-linux.so.2 (GLIBC_PRIVATE) => /lib/ld-linux.so.2
libc.so.6 (GLIBC_2.1.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.1) => /lib/libc.so.6
libc.so.6 (GLIBC_2.0) => /lib/libc.so.6
libc.so.6 (GLIBC_PRIVATE) => /lib/libc.so.6
/lib/libpthread.so.0:
ld-linux.so.2 (GLIBC_2.3) => /lib/ld-linux.so.2
ld-linux.so.2 (GLIBC_2.1) => /lib/ld-linux.so.2
ld-linux.so.2 (GLIBC_PRIVATE) => /lib/ld-linux.so.2
libc.so.6 (GLIBC_2.1.3) => /lib/libc.so.6
libc.so.6 (GLIBC_2.1) => /lib/libc.so.6
libc.so.6 (GLIBC_2.3.2) => /lib/libc.so.6
libc.so.6 (GLIBC_2.2) => /lib/libc.so.6
libc.so.6 (GLIBC_PRIVATE) => /lib/libc.so.6
libc.so.6 (GLIBC_2.0) => /lib/libc.so.6
Output "ldd -r /opt/pljava/pljava.so":
linux-gate.so.1 => (0xffffe000)
libjvm.so => /usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/client/libjvm.so
(0xb7720000)
libc.so.6 => /lib/libc.so.6 (0xb75e2000)
libm.so.6 => /lib/libm.so.6 (0xb75bc000)
libdl.so.2 => /lib/libdl.so.2 (0xb75b7000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb759f000)
/lib/ld-linux.so.2 (0x80000000)
undefined symbol: QueryCancelPending (/opt/pljava/pljava.so)
undefined symbol: proc_exit_inprogress (/opt/pljava/pljava.so)
undefined symbol: SPI_tuptable (/opt/pljava/pljava.so)
undefined symbol: CurrentMemoryContext (/opt/pljava/pljava.so)
undefined symbol: PG_exception_stack (/opt/pljava/pljava.so)
undefined symbol: global_timezone (/opt/pljava/pljava.so)
undefined symbol: MyProcPid (/opt/pljava/pljava.so)
undefined symbol: TopMemoryContext (/opt/pljava/pljava.so)
undefined symbol: assert_enabled (/opt/pljava/pljava.so)
undefined symbol: textout (/opt/pljava/pljava.so)
undefined symbol: stack_base_ptr (/opt/pljava/pljava.so)
undefined symbol: ProcDiePending (/opt/pljava/pljava.so)
undefined symbol: log_min_messages (/opt/pljava/pljava.so)
undefined symbol: SPI_result (/opt/pljava/pljava.so)
undefined symbol: error_context_stack (/opt/pljava/pljava.so)
undefined symbol: SPI_processed (/opt/pljava/pljava.so)
undefined symbol: client_min_messages (/opt/pljava/pljava.so)
undefined symbol: InterruptPending (/opt/pljava/pljava.so)
undefined symbol: SPI_execute_plan (/opt/pljava/pljava.so)
undefined symbol: heap_copytuple (/opt/pljava/pljava.so)
undefined symbol: elog_finish (/opt/pljava/pljava.so)
undefined symbol: inv_drop (/opt/pljava/pljava.so)
undefined symbol: SPI_cursor_fetch (/opt/pljava/pljava.so)
undefined symbol: errstart (/opt/pljava/pljava.so)
undefined symbol: SPI_freeplan (/opt/pljava/pljava.so)
undefined symbol: GetConfigOption (/opt/pljava/pljava.so)
undefined symbol: appendStringInfoString (/opt/pljava/pljava.so)
undefined symbol: inv_tell (/opt/pljava/pljava.so)
undefined symbol: GetSessionUserId (/opt/pljava/pljava.so)
undefined symbol: appendBinaryStringInfo (/opt/pljava/pljava.so)
undefined symbol: RegisterSubXactCallback (/opt/pljava/pljava.so)
undefined symbol: get_typlenbyvalalign (/opt/pljava/pljava.so)
undefined symbol: pfree (/opt/pljava/pljava.so)
undefined symbol: get_fn_expr_rettype (/opt/pljava/pljava.so)
undefined symbol: find_coercion_pathway (/opt/pljava/pljava.so)
undefined symbol: SPI_gettypeid (/opt/pljava/pljava.so)
undefined symbol: SPI_getrelname (/opt/pljava/pljava.so)
undefined symbol: ReleaseSysCache (/opt/pljava/pljava.so)
undefined symbol: pg_usleep (/opt/pljava/pljava.so)
undefined symbol: Float4GetDatum (/opt/pljava/pljava.so)
undefined symbol: SPI_fname (/opt/pljava/pljava.so)
undefined symbol: CreateTupleDescCopy (/opt/pljava/pljava.so)
undefined symbol: errfinish (/opt/pljava/pljava.so)
undefined symbol: GetCurrentSubTransactionId (/opt/pljava/pljava.so)
undefined symbol: inv_read (/opt/pljava/pljava.so)
undefined symbol: lookup_rowtype_tupdesc_noerror (/opt/pljava/pljava.so)
undefined symbol: AllocSetContextCreate (/opt/pljava/pljava.so)
undefined symbol: DefineCustomBoolVariable (/opt/pljava/pljava.so)
undefined symbol: ReThrowError (/opt/pljava/pljava.so)
undefined symbol: FunctionCall3 (/opt/pljava/pljava.so)
undefined symbol: ExecCopySlotTuple (/opt/pljava/pljava.so)
undefined symbol: pqsignal (/opt/pljava/pljava.so)
undefined symbol: construct_md_array (/opt/pljava/pljava.so)
undefined symbol: inv_seek (/opt/pljava/pljava.so)
undefined symbol: lookup_rowtype_tupdesc (/opt/pljava/pljava.so)
undefined symbol: SearchSysCache (/opt/pljava/pljava.so)
undefined symbol: format_type_be (/opt/pljava/pljava.so)
undefined symbol: byteasend (/opt/pljava/pljava.so)
undefined symbol: superuser_arg (/opt/pljava/pljava.so)
undefined symbol: SPI_modifytuple (/opt/pljava/pljava.so)
undefined symbol: disable_sig_alarm (/opt/pljava/pljava.so)
undefined symbol: inv_open (/opt/pljava/pljava.so)
undefined symbol: heap_formtuple (/opt/pljava/pljava.so)
undefined symbol: end_MultiFuncCall (/opt/pljava/pljava.so)
undefined symbol: Float8GetDatum (/opt/pljava/pljava.so)
undefined symbol: SPI_cursor_move (/opt/pljava/pljava.so)
undefined symbol: GetUserId (/opt/pljava/pljava.so)
undefined symbol: DirectFunctionCall1 (/opt/pljava/pljava.so)
undefined symbol: pg_do_encoding_conversion (/opt/pljava/pljava.so)
undefined symbol: ExceptionalCondition (/opt/pljava/pljava.so)
undefined symbol: unknownrecv (/opt/pljava/pljava.so)
undefined symbol: CreateTupleDescCopyConstr (/opt/pljava/pljava.so)
undefined symbol: GetAttributeByNum (/opt/pljava/pljava.so)
undefined symbol: unknownsend (/opt/pljava/pljava.so)
undefined symbol: elog_start (/opt/pljava/pljava.so)
undefined symbol: inv_write (/opt/pljava/pljava.so)
undefined symbol: GetUserNameFromId (/opt/pljava/pljava.so)
undefined symbol: get_fn_expr_argtype (/opt/pljava/pljava.so)
undefined symbol: UnregisterSubXactCallback (/opt/pljava/pljava.so)
undefined symbol: SysCacheGetAttr (/opt/pljava/pljava.so)
undefined symbol: CopyErrorData (/opt/pljava/pljava.so)
undefined symbol: ArrayGetNItems (/opt/pljava/pljava.so)
undefined symbol: pq_endtypsend (/opt/pljava/pljava.so)
undefined symbol: DefineCustomIntVariable (/opt/pljava/pljava.so)
undefined symbol: SPI_finish (/opt/pljava/pljava.so)
undefined symbol: SPI_result_code_string (/opt/pljava/pljava.so)
undefined symbol: parseTypeString (/opt/pljava/pljava.so)
undefined symbol: initStringInfo (/opt/pljava/pljava.so)
undefined symbol: SPI_getargcount (/opt/pljava/pljava.so)
undefined symbol: pg_namespace_aclcheck (/opt/pljava/pljava.so)
undefined symbol: SPI_is_cursor_plan (/opt/pljava/pljava.so)
undefined symbol: heap_freetuple (/opt/pljava/pljava.so)
undefined symbol: BeginInternalSubTransaction (/opt/pljava/pljava.so)
undefined symbol: SPI_connect (/opt/pljava/pljava.so)
undefined symbol: ReleaseCurrentSubTransaction (/opt/pljava/pljava.so)
undefined symbol: pq_begintypsend (/opt/pljava/pljava.so)
undefined symbol: errmsg (/opt/pljava/pljava.so)
undefined symbol: SPI_getargtypeid (/opt/pljava/pljava.so)
undefined symbol: GetCurrentTransactionNestLevel (/opt/pljava/pljava.so)
undefined symbol: fmgr_info_cxt (/opt/pljava/pljava.so)
undefined symbol: SPI_restore_connection (/opt/pljava/pljava.so)
undefined symbol: UnregisterExprContextCallback (/opt/pljava/pljava.so)
undefined symbol: SPI_cursor_close (/opt/pljava/pljava.so)
undefined symbol: FunctionCall1 (/opt/pljava/pljava.so)
undefined symbol: SPI_freetuptable (/opt/pljava/pljava.so)
undefined symbol: GetMemoryChunkContext (/opt/pljava/pljava.so)
undefined symbol: FreeTupleDesc (/opt/pljava/pljava.so)
undefined symbol: SPI_cursor_open (/opt/pljava/pljava.so)
undefined symbol:
RollbackAndReleaseCurrentSubTransaction (/opt/pljava/pljava.so)
undefined symbol: inv_create (/opt/pljava/pljava.so)
undefined symbol: errcode (/opt/pljava/pljava.so)
undefined symbol: EmitWarningsOnPlaceholders (/opt/pljava/pljava.so)
undefined symbol: SPI_getbinval (/opt/pljava/pljava.so)
undefined symbol: MemoryContextDelete (/opt/pljava/pljava.so)
undefined symbol: SPI_saveplan (/opt/pljava/pljava.so)
undefined symbol: SPI_getnspname (/opt/pljava/pljava.so)
undefined symbol: MemoryContextStrdup (/opt/pljava/pljava.so)
undefined symbol: FlushErrorState (/opt/pljava/pljava.so)
undefined symbol: pg_localtime (/opt/pljava/pljava.so)
undefined symbol: appendStringInfo (/opt/pljava/pljava.so)
undefined symbol: pq_copymsgbytes (/opt/pljava/pljava.so)
undefined symbol: SPI_exec (/opt/pljava/pljava.so)
undefined symbol: UnregisterXactCallback (/opt/pljava/pljava.so)
undefined symbol: MemoryContextAllocZero (/opt/pljava/pljava.so)
undefined symbol: SPI_fnumber (/opt/pljava/pljava.so)
undefined symbol: bytearecv (/opt/pljava/pljava.so)
undefined symbol: DefineCustomStringVariable (/opt/pljava/pljava.so)
undefined symbol: RegisterExprContextCallback (/opt/pljava/pljava.so)
undefined symbol: get_call_result_type (/opt/pljava/pljava.so)
undefined symbol: GetDatabaseEncoding (/opt/pljava/pljava.so)
undefined symbol: on_proc_exit (/opt/pljava/pljava.so)
undefined symbol: MemoryContextReset (/opt/pljava/pljava.so)
undefined symbol: GetCurrentAbsoluteTime (/opt/pljava/pljava.so)
undefined symbol: SetUserIdAndContext (/opt/pljava/pljava.so)
undefined symbol: enable_sig_alarm (/opt/pljava/pljava.so)
undefined symbol: appendStringInfoChar (/opt/pljava/pljava.so)
undefined symbol: SPI_prepare (/opt/pljava/pljava.so)
undefined symbol: per_MultiFuncCall (/opt/pljava/pljava.so)
undefined symbol: RegisterXactCallback (/opt/pljava/pljava.so)
undefined symbol: init_MultiFuncCall (/opt/pljava/pljava.so)
undefined symbol: Int64GetDatum (/opt/pljava/pljava.so)
undefined symbol: FreeErrorData (/opt/pljava/pljava.so)
undefined symbol: pg_detoast_datum (/opt/pljava/pljava.so)
undefined symbol: inv_close (/opt/pljava/pljava.so)
undefined symbol: MemoryContextAlloc (/opt/pljava/pljava.so)
Output "export":
...
declare -x
LD_LIBRARY_PATH="/var/lib/pgsql/lib:/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386:/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/client:/usr/lib/jvm/java-1.
6.0-sun-1.6.0/jre/lib/i386/native_threads:/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/lib/i386/server"
...
declare -x JAVA_BINDIR="/usr/lib/jvm/java/bin"
declare -x JAVA_HOME="/usr/lib/jvm/java-1.6.0-sun-1.6.0"
declare -x JAVA_ROOT="/usr/lib/jvm/java"
declare -x JDK_HOME="/usr/lib/jvm/java"
declare -x JRE_HOME="/usr/lib/jvm/java/jre"
...
File "/var/lib/pgsql/data/postgresql.conf":
...
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------
...
dynamic_library_path = '$libdir:/opt/pljava'
...
#---------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#---------------------------------------------------------------------------
custom_variable_classes = 'pljava'
pljava.classpath = '/opt/pljava/pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = ''
pljava.debug = false
More information about the Pljava-dev
mailing list