-
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.