Crash while trying to open connection to DuckDB on Windows

[ghyatzo]

julia> using TidierDB

julia> import TidierDB as DB

julia> DB.duckdb()
duckdb()

julia> db = DB.connect(DB.duckdb())

Please submit a bug report with steps to reproduce this fault, and any error messages that follow (in their entirety). Thanks.
Exception: EXCEPTION_ACCESS_VIOLATION at 0x7ffe59678dd4 -- RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
in expression starting at REPL[4]:1
RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
free_base at C:\WINDOWS\System32\ucrtbase.dll (unknown line)
.text$_ZNSt10_HashtableINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEESt4pairIKS5_N6duckdb15ExtensionOptionEESaISA_ENSt8__detail10_Select1stENS8_29CaseInsensitiveStringEqualityENS8_33CaseInsensitiveStringHashFunctionENSC_18_Mod_range_hashingENSC_20_Default_ranged_hashENSC_20_Prime_rehash_policyENSC_17_Hashtable_traitsILb1ELb0ELb1EEEE9_M_rehashEyRKy at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdb8DBConfig18AddExtensionOptionERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES6_NS_11LogicalTypeERKNS_5ValueEPFvRNS_13ClientContextENS_8SetScopeERSA_ESF_ at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdbL12LoadInternalERNS_15ExtensionLoaderE at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdb15ExtensionHelper29LoadExternalExtensionInternalERNS_16DatabaseInstanceERNS_10FileSystemERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERNS_19ExtensionActiveLoadE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb15ExtensionHelper21LoadExternalExtensionERNS_13ClientContextERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZNK6duckdb12PhysicalLoad7GetDataERNS_16ExecutionContextERNS_9DataChunkERNS_19OperatorSourceInputE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor15FetchFromSourceERNS_9DataChunkE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor7ExecuteEy at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb12PipelineTask11ExecuteTaskENS_17TaskExecutionModeE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb12ExecutorTask7ExecuteENS_17TaskExecutionModeE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb13TaskScheduler12ExecuteTasksEPSt6atomicIbEy at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
duckdb_execute_n_tasks_state at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\api.jl:7903 [inlined]
execute_tasks at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:637
unknown function (ip: 000001b935ba6973) at (unknown file)
unknown function (ip: 000001b935ba66fd) at (unknown file)
unknown function (ip: 000001b935ba66c4) at (unknown file)
#execute_multithreaded##0 at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:689
unknown function (ip: 000001b935ba6604) at (unknown file)
jl_apply at C:/workdir/src\julia.h:2391 [inlined]
start_task at C:/workdir/src\task.c:1249
Allocations: 116084716 (Pool: 116084266; Big: 450); GC: 69

Info:

(proj) pkg> st
Status `...`
  [c3e4b0f8] Pluto v0.20.21
  [86993f9b] TidierDB v0.8.10
  [fe2206b3] TidierData v0.17.2

julia> versioninfo()
Julia Version 1.12.4
Commit 01a2eadb04 (2026-01-06 16:56 UTC)
Build Info:
  Official https://julialang.org release
Platform Info:
  OS: Windows (x86_64-w64-mingw32)
  CPU: 12 × 13th Gen Intel(R) Core(TM) i7-1355U
  WORD_SIZE: 64
  LLVM: libLLVM-18.1.7 (ORCJIT, alderlake)
  GC: Built with stock GC
Threads: 8 default, 1 interactive, 8 GC (on 12 virtual cores)
Environment:
  JULIA_PKG_DEVDIR = ~/Dev/+Julia

shell> duckdb --version
v1.4.4 (Andium) 6ddac802ff

shell>

Plain DuckDB.jl works fine:

julia> using DuckDB

julia>  db = DuckDB.DB()
DuckDB.DB(":memory:")

[drizk1]

Interesting, the code you posted suggests that TidierDB may be loading fine given you are able to progress to julia> DB.duckdb(), and that is an issue with the TidierDB.connect function and see if this lets you set up a database ? I dont have PC to test this with, so thank you for find this

can you try

using TidierDB
db = DuckDB.DB()

[ghyatzo]

works fine!

[drizk1]

Ok, thats good news. You should be able to use that db object in TidierDB.

when you have a chance, I have added a branch connupdate if you can please try out the below to see if it fixes this issue

import TidierDB as DB 
db = DB.connect(DB.duckdb())

[ghyatzo]

unfortunately that does not work:

julia> DB.connect(DB.duckdb())

Please submit a bug report with steps to reproduce this fault, and any error messages that follow (in their entirety). Thanks.
Exception: EXCEPTION_ACCESS_VIOLATION at 0x7ffa20cd8dd4 -- RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
in expression starting at REPL[6]:1
RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
free_base at C:\WINDOWS\System32\ucrtbase.dll (unknown line)
.text$_ZNSt10_HashtableINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEESt4pairIKS5_N6duckdb15ExtensionOptionEESaISA_ENSt8__detail10_Select1stENS8_29CaseInsensitiveStringEqualityENS8_33CaseInsensitiveStringHashFunctionENSC_18_Mod_range_hashingENSC_20_Default_ranged_hashENSC_20_Prime_rehash_policyENSC_17_Hashtable_traitsILb1ELb0ELb1EEEE9_M_rehashEyRKy at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdb8DBConfig18AddExtensionOptionERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES6_NS_11LogicalTypeERKNS_5ValueEPFvRNS_13ClientContextENS_8SetScopeERSA_ESF_ at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdbL12LoadInternalERNS_15ExtensionLoaderE at C:\Users\camillo.schenone\.duckdb\extensions\v1.4.3\windows_amd64_mingw\httpfs.duckdb_extension (unknown line)
_ZN6duckdb15ExtensionHelper29LoadExternalExtensionInternalERNS_16DatabaseInstanceERNS_10FileSystemERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERNS_19ExtensionActiveLoadE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb15ExtensionHelper21LoadExternalExtensionERNS_13ClientContextERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZNK6duckdb12PhysicalLoad7GetDataERNS_16ExecutionContextERNS_9DataChunkERNS_19OperatorSourceInputE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor15FetchFromSourceERNS_9DataChunkE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor7ExecuteEy at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb12PipelineTask11ExecuteTaskENS_17TaskExecutionModeE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb12ExecutorTask7ExecuteENS_17TaskExecutionModeE at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb8Executor11ExecuteTaskEb at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb13ClientContext19ExecuteTaskInternalERNS_17ClientContextLockERNS_15BaseQueryResultEb at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
_ZN6duckdb18PendingQueryResult11ExecuteTaskEv at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
duckdb_pending_execute_task at C:\Users\camillo.schenone\.julia\artifacts\9f4df99c777cbc8db22f231fd936374baba1511e\bin\libduckdb.dll (unknown line)
duckdb_pending_execute_task at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\api.jl:2819 [inlined]
pending_execute_tasks at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:624
execute_singlethreaded at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:676
execute at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:719
execute at C:\Users\camillo.schenone\.julia\packages\DuckDB\AHUoM\src\result.jl:872 [inlined]
execute at C:\Users\camillo.schenone\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:130 [inlined]
#execute#2 at C:\Users\camillo.schenone\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:152 [inlined]
execute at C:\Users\camillo.schenone\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:152 [inlined]
#connect#166 at C:\Users\camillo.schenone\.julia\packages\TidierDB\2ld7w\src\TidierDB.jl:386
connect at C:\Users\camillo.schenone\.julia\packages\TidierDB\2ld7w\src\TidierDB.jl:378
unknown function (ip: 000002282978fbd4) at (unknown file)
jl_apply at C:/workdir/src\julia.h:2391 [inlined]
do_call at C:/workdir/src\interpreter.c:123
eval_value at C:/workdir/src\interpreter.c:243
eval_stmt_value at C:/workdir/src\interpreter.c:194 [inlined]
eval_body at C:/workdir/src\interpreter.c:707
jl_interpret_toplevel_thunk at C:/workdir/src\interpreter.c:898
jl_toplevel_eval_flex at C:/workdir/src\toplevel.c:1035
__repl_entry_eval_expanded_with_loc at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:301
jl_apply at C:/workdir/src\julia.h:2391 [inlined]
jl_f_invokelatest at C:/workdir/src\builtins.c:881
toplevel_eval_with_hooks at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:308
toplevel_eval_with_hooks at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:312
toplevel_eval_with_hooks at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:312
toplevel_eval_with_hooks at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:312
toplevel_eval_with_hooks at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:305 [inlined]
eval_user_input at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:330
repl_backend_loop at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:452
#start_repl_backend#41 at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:427
start_repl_backend at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:424 [inlined]
#run_repl#50 at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:653
run_repl at C:\workdir\usr\share\julia\stdlib\v1.12\REPL\src\REPL.jl:639
jfptr_run_repl_20000.1 at C:\Users\camillo.schenone\.julia\juliaup\julia-1.12.4+0.x64.w64.mingw32\share\julia\compiled\v1.12\REPL\u0gqU_hz07T.dll (unknown line)
run_std_repl at .\client.jl:478
jfptr_run_std_repl_34629.1 at C:\Users\camillo.schenone\.julia\juliaup\julia-1.12.4+0.x64.w64.mingw32\lib\julia\sys.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2391 [inlined]
jl_f_invokelatest at C:/workdir/src\builtins.c:881
run_main_repl at .\client.jl:499
repl_main at .\client.jl:586 [inlined]
_start at .\client.jl:561
jfptr__start_67175.1 at C:\Users\camillo.schenone\.julia\juliaup\julia-1.12.4+0.x64.w64.mingw32\lib\julia\sys.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2391 [inlined]
true_main at C:/workdir/src\jlapi.c:971
jl_repl_entrypoint at C:/workdir/src\jlapi.c:1139
mainCRTStartup at C:/workdir/cli\loader_exe.c:58
BaseThreadInitThunk at C:\WINDOWS\System32\KERNEL32.DLL (unknown line)
RtlUserThreadStart at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
Allocations: 195500899 (Pool: 195498521; Big: 2378); GC: 81

I double checked and I tested the correct version in the connupdate branch.

[ghyatzo]

I tried manually running each line of the connect function and the crash happens at the
DBInterface.execute(db, "LOAD httpfs;") line:

julia> db = DuckDB.DB()
DuckDB.DB(":memory:")

julia> DBInterface.execute(db, "SET autoinstall_known_extensions=1;")
(Success = Bool[],)

julia> DBInterface.execute(db, "SET autoload_known_extensions=1;")
(Success = Bool[],)

julia> DBInterface.execute(db, "INSTALL httpfs;")
(Success = Bool[],)

julia> DBInterface.execute(db, "LOAD httpfs;")

** The crash posted above **

The line you changed in the connupdate branch works fine:

julia> db = DBInterface.connect(DuckDB.DB, ":memory:")
DuckDB.DB(":memory:")

This seems like a upstream DBInterface issue?