- 
                Notifications
    You must be signed in to change notification settings 
- Fork 3
Description
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
- I agree to follow this project's Code of Conduct.