Skip to content

[Bug] Build pljava success,bug can't run create extension pljava #6

@cleverxiao001

Description

@cleverxiao001

Cloudberry Database and PL/Java version

cbdb version:1.6.0
pljava version:1.6.8
java version:openjdk version "11.0.26" 2025-01-21
maven version:3.8.8
os version:Kylin Linux Advanced Server V10 (Halberd)

What happened

I build pljava from source code, step:
1.unzip pljava-1_6_8.zip
2.cd pljava-1_6_8
3.mvn clean package
4.java -Dpgconfig=/usr/local/cloudberrydb/bin/pg_config -jar pljava-packaging/target/pljava-pg14.jar
build success and output:
java -jar pljava-packaging/target/pljava-pg14.jar
/usr/local/cloudberrydb/lib/postgresql/libpljava-so-1.6.8.so as bytes
/usr/local/cloudberrydb/share/postgresql/pljava/pljava-1.6.8.jar as bytes
/usr/local/cloudberrydb/share/postgresql/pljava/pljava-api-1.6.8.jar as bytes
/usr/local/cloudberrydb/share/postgresql/pljava/pljava-examples-1.6.8.jar as bytes
/usr/local/cloudberrydb/share/postgresql/extension/pljava.control as lines (ASCII)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--unpackaged--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.7--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.6--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.5--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.4--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.3--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.2--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.1--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.6.0--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.8--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.7--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.6--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.5--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.4--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.3--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.2--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.1--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.1-BETA3--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.1-BETA2--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.1-BETA1--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.0--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.0-BETA3--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.0-BETA2--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--1.5.0-BETA1--1.6.8.sql as lines (UTF8)
/usr/local/cloudberrydb/share/postgresql/pljava/pljava--unpackaged.sql as lines (UTF8)
/usr/local/cloudberrydb/etc/postgresql/pljava.policy as lines (UTF8)
5.vi /root/to/datapath/coordinator/gpseg-1/postgresql.conf add pljava.libjvm_location = '/usr/lib/jvm/java-11-openjdk-11.0.26.4-1.p01.ky10.aarch64/lib/server/libjvm.so'
6.gpstop -u
All above step run success,But exec create extension pljava,I got an ERROR:
2025-04-02 13:50:00 CST|929|con9|cmd28|seg-1||dx46|x930|sx3|ERROR: |XX000|java.sql.SQLException: An attempt was made to call a PostgreSQL backend function after an elog(ERROR) had been issued (JNICalls.c:203)||||||CREATE EXTENSION pljava|0||JNICalls.c|203|Stack trace:
1 0xfffd8f4588d8 libpostgres.so errstart + 0x248
2 0xfffd7401bc9c libpljava-so-1.6.8.so + 0x7401bc9c
3 0xfffd7401f274 libpljava-so-1.6.8.so JNI_callVoidMethodLocked + 0x6c
4 0xfffd7401b818 libpljava-so-1.6.8.so Invocation_popInvocation + 0x80
5 0xfffd7401b2ec libpljava-so-1.6.8.so InstallHelper_groundwork + 0x1cc
6 0xfffd74014bcc libpljava-so-1.6.8.so + 0x74014bcc
7 0xfffd8f45d624 libpostgres.so + 0x8f45d624
8 0xfffd8f45e1dc libpostgres.so load_file + 0x1a4
9 0xfffd8f2c2fc8 libpostgres.so standard_ProcessUtility + 0x2e8
10 0xfffd8f2c3c5c libpostgres.so ProcessUtility + 0xe4
11 0xfffd8eff5a50 libpostgres.so execute_sql_string + 0x130
12 0xfffd8eff6154 libpostgres.so + 0x8eff6154
13 0xfffd8eff6c1c libpostgres.so + 0x8eff6c1c
14 0xfffd8f2c4600 libpostgres.so + 0x8f2c4600
15 0xfffd8f2c2e1c libpostgres.so standard_ProcessUtility + 0x13c
16 0xfffd8f2c3c5c libpostgres.so ProcessUtility + 0xe4
17 0xfffd8f2c00f8 libpostgres.so + 0x8f2c00f8
18 0xfffd8f2c1900 libpostgres.so PortalRun + 0x180
19 0xfffd8f2bdb08 libpostgres.so PostgresMain + 0x21d8
20 0xfffd8f205bc4 libpostgres.so + 0x8f205bc4
21 0xfffd8f206ca8 libpostgres.so PostmasterMain + 0xf58
22 0x401808 postgres main + 0x4f8
23 0xfffd8e784000 libc.so.6 __libc_start_main + 0xe0
24 0x4019cc postgres _start + 0x4c

What you think should happen instead

I follow this step success install pljava to postgresql14,I think is success in cloudberrydb

How to reproduce

No response

Operating System

No response

Anything else

No response

Are you willing to submit PR?

  • Yes, I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions