duckdb / duckdb/duckdb-spatial

Julia crashes after trying to load the spatial extension on Windows 11 OS

Open
#762 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
708
Forks
96
Avg merge
1d 21h
Merged PRs (30d)
5

Description

Julia crashes when trying to load the DuckDB spatial extension on Windows 11. I am using Julia v1.11 and tried both DuckDB@v1.4.1 and DuckDB@v1.0.0. The other packages I have installed are:

```
"CSV" => v"0.10.16"
"Statistics" => v"1.11.1"
"GeoDataFrames" => v"0.4.2"
"ArchGDAL" => v"0.10.11"
"MLJ" => v"0.22.0"
"Revise" => v"3.13.2"
"JSON3" => v"1.14.3"
"Parquet" => v"0.8.6"
"Extents" => v"0.1.6"
"Proj" => v"1.9.0"
"HTTP" => v"1.10.19"
"Shapefile" => v"0.13.3"
"MLJDecisionTreeInterface" => v"0.4.3"
"GeoParquet" => v"0.2.1"
"HDF5" => v"0.17.2"
"DecisionTree" => v"0.12.4"
"Distances" => v"0.10.12"
"Plots" => v"1.41.6"
"SpaceLiDAR" => v"0.4.2"
"CategoricalArrays" => v"1.0.2"
"DuckDB" => v"1.4.1"
"GeoInterface" => v"1.6.1"
"DataFrames" => v"1.8.1"
```

I used the following commands:
```
julia> using DuckDB

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

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

julia> DBInterface.execute(con, "LOAD spatial;")
```

The entire error message is pasted below:

```
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 0x7ffa284f5431 -- RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
in expression starting at REPL[8]:1
RtlFreeHeap at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
free_base at C:\WINDOWS\System32\ucrtbase.dll (unknown line)
_ZNSt6vectorIN6duckdb19FunctionDescriptionESaIS1_EE17_M_realloc_insertIJRKS1_EEEvN9__gnu_cxx17__normal_iteratorIPS1_S3_EEDpOT_ at C:\Users\Heiko\.duckdb\extensions\v1.4.4\windows_amd64_mingw\spatial.duckdb_extension (unknown line)
.text$_ZN6duckdb15FunctionBuilder8RegisterERNS_15ExtensionLoaderEPKcRNS_21ScalarFunctionBuilderE at C:\Users\Heiko\.duckdb\extensions\v1.4.4\windows_amd64_mingw\spatial.duckdb_extension (unknown line)
.text$_ZN6duckdb12_GLOBAL__N_18ST_Point8RegisterERNS_15ExtensionLoaderE at C:\Users\Heiko\.duckdb\extensions\v1.4.4\windows_amd64_mingw\spatial.duckdb_extension (unknown line)
.text$_ZN6duckdb30RegisterSpatialScalarFunctionsERNS_15ExtensionLoaderE at C:\Users\Heiko\.duckdb\extensions\v1.4.4\windows_amd64_mingw\spatial.duckdb_extension (unknown line)
.text$_ZN6duckdbL12LoadInternalERNS_15ExtensionLoaderE at C:\Users\Heiko\.duckdb\extensions\v1.4.4\windows_amd64_mingw\spatial.duckdb_extension (unknown line)
_ZN6duckdb15ExtensionHelper29LoadExternalExtensionInternalERNS_16DatabaseInstanceERNS_10FileSystemERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERNS_19ExtensionActiveLoadE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb15ExtensionHelper21LoadExternalExtensionERNS_13ClientContextERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZNK6duckdb12PhysicalLoad7GetDataERNS_16ExecutionContextERNS_9DataChunkERNS_19OperatorSourceInputE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor15FetchFromSourceERNS_9DataChunkE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb16PipelineExecutor7ExecuteEy at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb12PipelineTask11ExecuteTaskENS_17TaskExecutionModeE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb12ExecutorTask7ExecuteENS_17TaskExecutionModeE at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb8Executor11ExecuteTaskEb at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb13ClientContext19ExecuteTaskInternalERNS_17ClientContextLockERNS_15BaseQueryResultEb at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
_ZN6duckdb18PendingQueryResult11ExecuteTaskEv at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
duckdb_pending_execute_task at C:\Users\Heiko\.julia\artifacts\78e3513742a34caece3f6e81b88f50be69a3d5d6\bin\libduckdb.dll (unknown line)
duckdb_pending_execute_task at C:\Users\Heiko\.julia\packages\DuckDB\AHUoM\src\api.jl:2819 [inlined]
pending_execute_tasks at C:\Users\Heiko\.julia\packages\DuckDB\AHUoM\src\result.jl:624
execute_singlethreaded at C:\Users\Heiko\.julia\packages\DuckDB\AHUoM\src\result.jl:676
execute at C:\Users\Heiko\.julia\packages\DuckDB\AHUoM\src\result.jl:719
execute at C:\Users\Heiko\.julia\packages\DuckDB\AHUoM\src\result.jl:872 [inlined]
execute at C:\Users\Heiko\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:130 [inlined]
#execute#2 at C:\Users\Heiko\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:152 [inlined]
execute at C:\Users\Heiko\.julia\packages\DBInterface\nQcsk\src\DBInterface.jl:152
unknown function (ip: 000001dffdab6d20)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_call at C:/workdir/src\interpreter.c:126
eval_value at C:/workdir/src\interpreter.c:223
eval_stmt_value at C:/workdir/src\interpreter.c:174 [inlined]
eval_body at C:/workdir/src\interpreter.c:684
jl_interpret_toplevel_thunk at C:/workdir/src\interpreter.c:824
jl_toplevel_eval_flex at C:/workdir/src\toplevel.c:943
jl_toplevel_eval_flex at C:/workdir/src\toplevel.c:886
ijl_toplevel_eval at C:/workdir/src\toplevel.c:952 [inlined]
ijl_toplevel_eval_in at C:/workdir/src\toplevel.c:994
eval at .\boot.jl:430 [inlined]
eval_user_input at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:261
repl_backend_loop at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:368
#start_repl_backend#59 at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:343
start_repl_backend at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:340
#run_repl#76 at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:500
run_repl at C:\workdir\usr\share\julia\stdlib\v1.11\REPL\src\REPL.jl:486
jfptr_run_repl_10492.1 at C:\Users\Heiko\.julia\juliaup\julia-1.11.9+0.x64.w64.mingw32\share\julia\compiled\v1.11\REPL\u0gqU_hz07T.dll (unknown line)
#1152 at .\client.jl:439
jfptr_YY.1152_15284.1 at C:\Users\Heiko\.julia\juliaup\julia-1.11.9+0.x64.w64.mingw32\share\julia\compiled\v1.11\REPL\u0gqU_hz07T.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
jl_f__call_latest at C:/workdir/src\builtins.c:875
#invokelatest#2 at .\essentials.jl:1055 [inlined]
invokelatest at .\essentials.jl:1052 [inlined]
run_main_repl at .\client.jl:423
repl_main at .\client.jl:560 [inlined]
_start at .\client.jl:534
jfptr__start_75427.1 at C:\Users\Heiko\.julia\juliaup\julia-1.11.9+0.x64.w64.mingw32\lib\julia\sys.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
true_main at C:/workdir/src\jlapi.c:900
jl_repl_entrypoint at C:/workdir/src\jlapi.c:1059
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: 7432174 (Pool: 7431941; Big: 233); GC: 11
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.