Server crashes on executing "CREATE SCHEMA ..." #420
Description
What happens?
Server crashes when executing the script below
PostgreSQL build:
CFLAGS='-Og' ./configure --enable-tap-tests --with-openssl --enable-debug --enable-cassert --with-icu --with-lz4 --with-libxml
To Reproduce
CREATE EXTENSION pg_duckdb;
CREATE ROLE regress_create_schema_role SUPERUSER;
CREATE SCHEMA AUTHORIZATION regress_create_schema_role CREATE SEQUENCE schema_not_existing.seq;backtrace:
#0 __strncmp_evex () at ../sysdeps/x86_64/multiarch/strcmp-evex.S:318
#1 0x00007d87202c1539 in DuckdbHandleDDL (parsetree=parsetree@entry=0x61b1bdb0cbf0, queryString=queryString@entry=0x61b1bdb0bfb0 "CREATE SCHEMA AUTHORIZATION regress_create_schema_role CREATE SEQUENCE schema_not_existing.seq;")
at src/pgduckdb_ddl.cpp:77
#2 0x00007d87202cc34f in DuckdbUtilityHook_Cpp (qc=0x7ffdc22d8c70, dest=0x61b1bdb0d080, query_env=0x0, params=0x0, context=PROCESS_UTILITY_TOPLEVEL, read_only_tree=false,
query_string=0x61b1bdb0bfb0 "CREATE SCHEMA AUTHORIZATION regress_create_schema_role CREATE SEQUENCE schema_not_existing.seq;", pstmt=0x61b1bdb0ccc0) at src/pgduckdb_hooks.cpp:241
#3 pgduckdb::__CPPFunctionGuard__<void (*)(PlannedStmt*, char const*, bool, ProcessUtilityContext, ParamListInfoData*, QueryEnvironment*, _DestReceiver*, QueryCompletion*), DuckdbUtilityHook_Cpp, PlannedStmt*, char const*, bool, ProcessUtilityContext, ParamListInfoData*, QueryEnvironment*, _DestReceiver*, QueryCompletion*> (func_name=0x7d8720302513 "DuckdbUtilityHook") at src/pgduckdb_hooks.cpp:254
#4 0x000061b1bc9341ef in ProcessUtility (pstmt=pstmt@entry=0x61b1bdb0ccc0, queryString=<optimized out>, readOnlyTree=<optimized out>, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=<optimized out>, queryEnv=<optimized out>,
dest=0x61b1bdb0d080, qc=0x7ffdc22d8c70) at utility.c:519
#5 0x000061b1bc931736 in PortalRunUtility (portal=portal@entry=0x61b1bdb971f0, pstmt=pstmt@entry=0x61b1bdb0ccc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x61b1bdb0d080,
qc=qc@entry=0x7ffdc22d8c70) at pquery.c:1158
#6 0x000061b1bc9319ff in PortalRunMulti (portal=portal@entry=0x61b1bdb971f0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x61b1bdb0d080, altdest=altdest@entry=0x61b1bdb0d080,
qc=qc@entry=0x7ffdc22d8c70) at pquery.c:1315
#7 0x000061b1bc931d70 in PortalRun (portal=portal@entry=0x61b1bdb971f0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x61b1bdb0d080, altdest=altdest@entry=0x61b1bdb0d080,
qc=0x7ffdc22d8c70) at pquery.c:791
#8 0x000061b1bc92dfcf in exec_simple_query (query_string=query_string@entry=0x61b1bdb0bfb0 "CREATE SCHEMA AUTHORIZATION regress_create_schema_role CREATE SEQUENCE schema_not_existing.seq;") at postgres.c:1278
#9 0x000061b1bc92ff0f in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4767
#10 0x000061b1bc92950d in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at backend_startup.c:105
#11 0x000061b1bc883d79 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdc22d8e94 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdc22d8ed0)
at launch_backend.c:277
#12 0x000061b1bc888474 in BackendStartup (client_sock=client_sock@entry=0x7ffdc22d8ed0) at postmaster.c:3593
#13 0x000061b1bc8886ee in ServerLoop () at postmaster.c:1674
#14 0x000061b1bc889d60 in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0x61b1bdac6010) at postmaster.c:1372
#15 0x000061b1bc7ab5cc in main (argc=3, argv=0x61b1bdac6010) at main.c:197OS:
Ubuntu 24.04
pg_duckdb Version:
master
Postgres Version:
REL_17_STABLE
Hardware:
No response
Full Name:
Egor Chindyaskin
Affiliation:
Postgres Professional
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a source build
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
- Yes, I have
Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?
- Yes, I have