Skip to content

INSERT INTO fdw SELECT or VALUES not working  #43

@drtrotter74

Description

@drtrotter74

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

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