search

pgspider / jdbc_fdw

JDBC Foreign Data Wrapper for PostgreSQL
Other
64 stars 21 forks source link

INSERT INTO fdw SELECT or VALUES not working #43

Open drtrotter74 opened 4 hours ago

drtrotter74 commented 4 hours ago

Trying to run an INSERT INTO myfdwtable SELECT FROM localpgtable or with INSERT INTO myfdwtable VALUES () fails with a pg server crash.

Normal select queries and more of the fdw operation are working just fine.
Here is the PG log, and a part of the core dump below.

2024-10-10 18:58:36.581 UTC [3656141] ocient_user@ocient_db LOG: execute : insert into ocient_sim.test_iasvalues values('Hank',68,'Chicago') 2024-10-10 18:58:36.626 UTC [3656141] ocient_user@ocient_db DEBUG: jdbc_fdw : jq_bind_sql_var 1 type=1043 #

A fatal error has been detected by the Java Runtime Environment:

#

SIGSEGV (0xb) at pc=0x00007ff39bba1c7a, pid=3656141, tid=3656141

#

JRE version: OpenJDK Runtime Environment (17.0.11+9) (build 17.0.11+9-Ubuntu-120.04.2)

Java VM: OpenJDK 64-Bit Server VM (17.0.11+9-Ubuntu-120.04.2, mixed mode, sharing, tiered, compressed oops, compressed class ptrs, g1 gc, linux-amd64)

Problematic frame:

C [jdbc_fdw.so+0xfc7a] jq_bind_sql_var+0x42a

#

drtrotter74 commented 4 hours ago

Internal exceptions (20 events): Event: 3.184 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db2b740}: 'java.lang.Object java.lang.invoke.DirectMethodHandle$Holder.invokeSpecial(java.lang.Object, java.lang.Object, int, java.lang.Object, java.lang.Object)'> (0x000000070db2b740) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758] Event: 3.185 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db35558}: 'void java.lang.invoke.DirectMethodHandle$Holder.invokeStatic(java.lang.Object, int, java.lang.Object)'> (0x000000070db35558) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758] Event: 3.185 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db3f5e8}: 'java.lang.Object java.lang.invoke.DirectMethodHandle$Holder.newInvokeSpecial(java.lang.Object, java.lang.Object, java.lang.Object, long)'> (0x000000070db3f5e8) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758] Event: 3.185 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db43b88}: 'java.lang.Object java.lang.invoke.DirectMethodHandle$Holder.invokeSpecial(java.lang.Object, java.lang.Object, java.lang.Object, java.lang.Object, long)'> (0x000000070db43b88) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758] Event: 3.185 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db47a00}: 'java.lang.Object java.lang.invoke.Invokers$Holder.linkToTargetMethod(java.lang.Object, java.lang.Object, long, java.lang.Object)'> (0x000000070db47a00) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758] Event: 3.186 Thread 0x000055cbbc396c70 Exception <a 'java/lang/NoSuchMethodError'{0x000000070db4b468}: 'void java.lang.invoke.DirectMethodHandle$Holder.invokeStatic(java.lang.Object, java.lang.Object, java.lang.Object, int, java.lang.Object, java.lang.Object)'> (0x000000070db4b468) thrown [src/hotspot/share/interpreter/linkResolver.cpp, line 758]