Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Runtime crash with libduckdb 1.0.0 #47

Open
Vonng opened this issue Jun 14, 2024 · 1 comment
Open

Runtime crash with libduckdb 1.0.0 #47

Vonng opened this issue Jun 14, 2024 · 1 comment

Comments

@Vonng
Copy link
Contributor

Vonng commented Jun 14, 2024

postgres=# create extension duckdb_fdw;
CREATE EXTENSION
postgres=#  CREATE SERVER duckdb_server
postgres-#  FOREIGN DATA WRAPPER duckdb_fdw
postgres-#  OPTIONS (
postgres(#           database '/tmp/duck.db'
postgres(#  );
CREATE SERVER
postgres=# CREATE FOREIGN TABLE t1 (
postgres(#   a integer,
postgres(#   b text
postgres(# )
postgres-# SERVER duckdb_server
postgres-# OPTIONS (
postgres(#   table 't1_duckdb'
postgres(# );
CREATE FOREIGN TABLE
postgres=# select * from t1;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.

postgres=# \errverbose
There is no previous error.
postgres=# insert into t1 values (1,'a');
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?> ^C
!?> \q
[postgres@build-el8 tmp]$ psql -E
psql (16.3)
Type "help" for help.

postgres=# \errverbose
There is no previous error.
postgres=# select * from t1;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?> \errverbose
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
@eydunn
Copy link
Contributor

eydunn commented Jun 20, 2024

Is the /tmp/duck.db created with version 1.0.0?

The commands above work for me, if I also create the t1_duckdb table with:

SELECT duckdb_execute('duckdb_server','CREATE TABLE t1_duckdb (a integer, b text);');

The versions that I am using:

+--------------+------------------+---------------------------------------------------------------------------------------------------------------------------------+
|duckdb_version|duckdb_fdw_version|postgrsql_version                                                                                                                |
+--------------+------------------+---------------------------------------------------------------------------------------------------------------------------------+
|v1.0.0        |20101             |PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit|
+--------------+------------------+---------------------------------------------------------------------------------------------------------------------------------+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants