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.

Sign up for GitHub

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

Jump to bottom

Fatal Python error: Bus error - when loading the SpatiaLite extension #3

Closed
simonw opened this issue Jun 25, 2023 · 6 comments
Closed

Fatal Python error: Bus error - when loading the SpatiaLite extension #3

simonw opened this issue Jun 25, 2023 · 6 comments

Comments

@simonw
Copy link

simonw commented Jun 25, 2023

I got this while running the test suite for my new sqlite-utils branch for sqlean:

https://github.com/simonw/sqlite-utils/tree/sqlean

I installed sqlean.py into the same environment and ran this:

pytest tests/test_gis.py

Here's the test failure:

============================================================================ test session starts =============================================================================
platform darwin -- Python 3.11.4, pytest-7.2.2, pluggy-1.0.0
rootdir: /Users/simon/Dropbox/Development/sqlite-utils
plugins: hypothesis-6.68.2
collected 12 items                                                                                                                                                           

tests/test_gis.py .Fatal Python error: Bus error

Current thread 0x00000001e5735b40 (most recent call first):
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/python.py", line 195 in pytest_pyfunc_call
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_callers.py", line 39 in _multicall
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_manager.py", line 80 in _hookexec
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_hooks.py", line 265 in __call__
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/python.py", line 1789 in runtest
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 167 in pytest_runtest_call
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_callers.py", line 39 in _multicall
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_manager.py", line 80 in _hookexec
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_hooks.py", line 265 in __call__
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 260 in <lambda>
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 339 in from_call
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 259 in call_runtest_hook
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 220 in call_and_report
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 131 in runtestprotocol
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/runner.py", line 112 in pytest_runtest_protocol
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_callers.py", line 39 in _multicall
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_manager.py", line 80 in _hookexec
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_hooks.py", line 265 in __call__
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/main.py", line 349 in pytest_runtestloop
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_callers.py", line 39 in _multicall
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_manager.py", line 80 in _hookexec
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_hooks.py", line 265 in __call__
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/main.py", line 324 in _main
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/main.py", line 270 in wrap_session
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/main.py", line 317 in pytest_cmdline_main
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_callers.py", line 39 in _multicall
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_manager.py", line 80 in _hookexec
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/pluggy/_hooks.py", line 265 in __call__
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/config/__init__.py", line 167 in main
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.11/site-packages/_pytest/config/__init__.py", line 190 in console_main
  File "/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/bin/pytest", line 8 in <module>

Extension modules: sqlean._sqlite3 (total: 1)
zsh: bus error  pytest tests/test_gis.py
@simonw
Copy link
Author

simonw commented Jun 25, 2023

When I tried to run the whole pytest suite I got a macOS error box with the following error report (not sure why I get that for pytest but not for pytest tests/test_gis.py):

-------------------------------------
Translated Report (Full Report Below)
-------------------------------------

Process:               Python [91597]
Path:                  /opt/homebrew/*/Python.framework/Versions/3.11/Resources/Python.app/Contents/MacOS/Python
Identifier:            org.python.python
Version:               3.11.4 (3.11.4)
Code Type:             ARM-64 (Native)
Parent Process:        zsh [91496]
Responsible:           Terminal [483]
User ID:               501

Date/Time:             2023-06-25 14:33:50.4278 -0700
OS Version:            macOS 13.3 (22E252)
Report Version:        12
Anonymous UUID:        AA32BCEA-02C3-0406-C103-6C81844AE525

Sleep/Wake UUID:       A29C5D5F-11C7-4A88-8FAC-BE834A478139

Time Awake Since Boot: 780000 seconds
Time Since Wake:       2509 seconds

System Integrity Protection: enabled

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_BAD_ACCESS (SIGBUS)
Exception Codes:       UNKNOWN_0x101 at 0x7369646565727472 -> 0x0000646565727472 (possible pointer authentication failure)
Exception Codes:       0x0000000000000101, 0x7369646565727472

VM Region Info: 0x646565727472 is not in any region.  Bytes after previous region: 4833003336819  
      REGION TYPE                    START - END         [ VSIZE] PRT/MAX SHRMOD  REGION DETAIL
      MALLOC_NANO              600018000000-600020000000 [128.0M] rw-/rwx SM=PRV  
--->  
      UNUSED SPACE AT END

Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib        	       0x18a2a4724 __pthread_kill + 8
1   libsystem_pthread.dylib       	       0x18a2dbc28 pthread_kill + 288
2   libsystem_c.dylib             	       0x18a1b246c raise + 32
3   Python                        	       0x10538d3c0 faulthandler_fatal_error + 440
4   libsystem_platform.dylib      	       0x18a30aa84 _sigtramp + 56
5   _sqlite3.cpython-311-darwin.so	       0x10664e0c8 sqlite3LeaveMutexAndCloseZombie + 544
6   _sqlite3.cpython-311-darwin.so	       0x1066553b8 sqlite3Close + 104
7   _sqlite3.cpython-311-darwin.so	       0x106655420 sqlite3_close_v2 + 16
8   _sqlite3.cpython-311-darwin.so	       0x106718654 pysqlite_connection_dealloc + 36
9   Python                        	       0x1052aef54 subtype_dealloc + 460
10  Python                        	       0x1053465e8 _PyFrame_Clear + 100
11  Python                        	       0x10532b484 _PyEval_Vector + 140
12  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
13  Python                        	       0x10532b46c _PyEval_Vector + 116
14  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
15  Python                        	       0x10532b46c _PyEval_Vector + 116
16  Python                        	       0x10524ee58 _PyObject_FastCallDictTstate + 208
17  Python                        	       0x1052b3758 slot_tp_call + 180
18  Python                        	       0x10524eb3c _PyObject_MakeTpCall + 128
19  Python                        	       0x105326dc0 _PyEval_EvalFrameDefault + 40664
20  Python                        	       0x10532b46c _PyEval_Vector + 116
21  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
22  Python                        	       0x10532b46c _PyEval_Vector + 116
23  Python                        	       0x10524ee58 _PyObject_FastCallDictTstate + 208
24  Python                        	       0x1052b3758 slot_tp_call + 180
25  Python                        	       0x10524f9cc _PyObject_Call + 124
26  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
27  Python                        	       0x10532b46c _PyEval_Vector + 116
28  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
29  Python                        	       0x10532b46c _PyEval_Vector + 116
30  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
31  Python                        	       0x10532b46c _PyEval_Vector + 116
32  Python                        	       0x10524ee58 _PyObject_FastCallDictTstate + 208
33  Python                        	       0x1052b3758 slot_tp_call + 180
34  Python                        	       0x10524eb3c _PyObject_MakeTpCall + 128
35  Python                        	       0x105326dc0 _PyEval_EvalFrameDefault + 40664
36  Python                        	       0x10532b46c _PyEval_Vector + 116
37  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
38  Python                        	       0x10532b46c _PyEval_Vector + 116
39  Python                        	       0x10524ee58 _PyObject_FastCallDictTstate + 208
40  Python                        	       0x1052b3758 slot_tp_call + 180
41  Python                        	       0x10524eb3c _PyObject_MakeTpCall + 128
42  Python                        	       0x105326dc0 _PyEval_EvalFrameDefault + 40664
43  Python                        	       0x10532b46c _PyEval_Vector + 116
44  Python                        	       0x105328be4 _PyEval_EvalFrameDefault + 48380
45  Python                        	       0x10532b46c _PyEval_Vector + 116
46  Python                        	       0x10524ee58 _PyObject_FastCallDictTstate + 208
47  Python                        	       0x1052b3758 slot_tp_call + 180
48  Python                        	       0x10524eb3c _PyObject_MakeTpCall + 128
49  Python                        	       0x105326dc0 _PyEval_EvalFrameDefault + 40664
50  Python                        	       0x10531c3a4 PyEval_EvalCode + 168
51  Python                        	       0x10536dc64 run_eval_code_obj + 84
52  Python                        	       0x10536dbc8 run_mod + 112
53  Python                        	       0x10536da08 pyrun_file + 148
54  Python                        	       0x10536d45c _PyRun_SimpleFileObject + 268
55  Python                        	       0x10536cdec _PyRun_AnyFileObject + 216
56  Python                        	       0x105388c94 pymain_run_file_obj + 220
57  Python                        	       0x1053885d4 pymain_run_file + 72
58  Python                        	       0x105387eb4 Py_RunMain + 704
59  Python                        	       0x105388fec Py_BytesMain + 40
60  dyld                          	       0x189f83f28 start + 2236


Thread 0 crashed with ARM Thread State (64-bit):
    x0: 0x0000000000000000   x1: 0x0000000000000000   x2: 0x0000000000000001   x3: 0x0000000000000000
    x4: 0x0000000000000073   x5: 0x0000000000000073   x6: 0x0000000000000600   x7: 0x00000000fffffffe
    x8: 0x544bd3f08c3d920f   x9: 0x544bd3f1694ec94f  x10: 0xcccccccccccccccd  x11: 0x00000000000000f6
   x12: 0x000000012014fa63  x13: 0x0000000000000000  x14: 0x0000000000000031  x15: 0x00000000ffffffd1
   x16: 0x0000000000000148  x17: 0x00000001ea25cf20  x18: 0x0000000000000000  x19: 0x000000000000000a
   x20: 0x00000001e5735b40  x21: 0x0000000000000103  x22: 0x00000001e5735c20  x23: 0x0000000000000000
   x24: 0x0000000000000001  x25: 0x00000001054dfc78  x26: 0x00000001052ba790  x27: 0x0000000104ea5490
   x28: 0x0000000104ea54a0   fp: 0x000000012014fae0   lr: 0x000000018a2dbc28
    sp: 0x000000012014fac0   pc: 0x000000018a2a4724 cpsr: 0x40001000
   far: 0x0000000105f44098  esr: 0x56000080  Address size fault

Binary Images:
       0x104cf4000 -        0x104cf7fff org.python.python (3.11.4) <9dc70b4b-b47b-3d35-b01f-5ba6fea9d0ec> /opt/homebrew/*/Python.framework/Versions/3.11/Resources/Python.app/Contents/MacOS/Python
       0x1051ec000 -        0x105483fff org.python.python (3.11.4, (c) 2001-2023 Python Software Foundation.) <ff1b9a38-8c48-37c7-a653-cc5fd69bbf29> /opt/homebrew/*/Python.framework/Versions/3.11/Python
       0x1050bc000 -        0x1050bffff _opcode.cpython-311-darwin.so (*) <66d8c6b3-fb84-36b2-840b-a13797c6d05c> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_opcode.cpython-311-darwin.so
       0x1051cc000 -        0x1051cffff _typing.cpython-311-darwin.so (*) <0de32fb1-0c65-3673-a516-8e816433fe23> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_typing.cpython-311-darwin.so
       0x1057e8000 -        0x1057effff _csv.cpython-311-darwin.so (*) <f013a63a-17b6-33f4-b86c-7b3c2b0e84c3> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_csv.cpython-311-darwin.so
       0x1057fc000 -        0x105803fff binascii.cpython-311-darwin.so (*) <72a70cad-76ca-37a9-9d53-82eb43b6a615> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/binascii.cpython-311-darwin.so
       0x105810000 -        0x105817fff zlib.cpython-311-darwin.so (*) <b0a5fab2-03c0-36d3-813f-e5e2ad4e028a> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/zlib.cpython-311-darwin.so
       0x1051dc000 -        0x1051dffff _bz2.cpython-311-darwin.so (*) <a972cae5-ddce-3c55-b967-641c422e81d8> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_bz2.cpython-311-darwin.so
       0x10583c000 -        0x105843fff _lzma.cpython-311-darwin.so (*) <3b0c13fa-2f8c-31d1-86e1-d3b5bc9d5948> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_lzma.cpython-311-darwin.so
       0x105884000 -        0x1058a3fff liblzma.5.dylib (*) <b0eb2993-ed5b-313b-8e4e-4f206b05ea68> /opt/homebrew/*/liblzma.5.dylib
       0x105824000 -        0x10582bfff _struct.cpython-311-darwin.so (*) <78212abb-d873-3a30-bdb4-1d95a42e032f> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_struct.cpython-311-darwin.so
       0x10586c000 -        0x105877fff math.cpython-311-darwin.so (*) <3e5aee3b-0a9a-3b62-b0ce-971737c0b9c5> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/math.cpython-311-darwin.so
       0x1057d4000 -        0x1057d7fff _bisect.cpython-311-darwin.so (*) <0485697b-5f35-363c-bf21-1ca99882739b> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_bisect.cpython-311-darwin.so
       0x105854000 -        0x105857fff _random.cpython-311-darwin.so (*) <9a40fb5d-035f-3596-bcc6-52ec5b4f06ef> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_random.cpython-311-darwin.so
       0x1059b4000 -        0x1059b7fff _sha512.cpython-311-darwin.so (*) <d5768942-bc77-3e29-817a-cb14ca2bed2c> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_sha512.cpython-311-darwin.so
       0x1059e0000 -        0x1059effff _socket.cpython-311-darwin.so (*) <8aeb9152-a04c-36c8-902c-e0f5b77496c3> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_socket.cpython-311-darwin.so
       0x1059fc000 -        0x105a03fff select.cpython-311-darwin.so (*) <299158ec-38c8-3acc-bd1d-07edd1305c2d> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/select.cpython-311-darwin.so
       0x105a10000 -        0x105a17fff array.cpython-311-darwin.so (*) <f7aecc79-fe10-3cd4-ba3d-cecb3b9de79c> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/array.cpython-311-darwin.so
       0x105a44000 -        0x105a53fff _datetime.cpython-311-darwin.so (*) <c57fc72c-ea98-3d43-8a36-7b2680d86c34> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_datetime.cpython-311-darwin.so
       0x105c80000 -        0x105d8ffff unicodedata.cpython-311-darwin.so (*) <f22b815f-c98a-3750-8b7d-ebc1bffd41ba> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/unicodedata.cpython-311-darwin.so
       0x1059c4000 -        0x1059c7fff _uuid.cpython-311-darwin.so (*) <d3822f3a-a54f-35e7-8dc3-64bb3184dc38> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_uuid.cpython-311-darwin.so
       0x105c64000 -        0x105c6bfff _json.cpython-311-darwin.so (*) <ed48f59d-c04c-3cb7-ae60-419f04ed3bf0> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_json.cpython-311-darwin.so
       0x105a24000 -        0x105a27fff _heapq.cpython-311-darwin.so (*) <c2a2fce5-02e4-39b8-b32e-7e405790d604> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_heapq.cpython-311-darwin.so
       0x105fcc000 -        0x105fe7fff _decimal.cpython-311-darwin.so (*) <d1a34e1a-3b98-3799-8ee4-40d080a9aabf> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_decimal.cpython-311-darwin.so
       0x106030000 -        0x10604ffff libmpdec.2.5.1.dylib (*) <19d22096-3c8e-3629-84c1-08b5029699a3> /opt/homebrew/*/libmpdec.2.5.1.dylib
       0x105a34000 -        0x105a37fff fcntl.cpython-311-darwin.so (*) <6315c932-cd38-3e79-bd5b-1d5fb863a43f> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/fcntl.cpython-311-darwin.so
       0x105f9c000 -        0x105f9ffff _posixsubprocess.cpython-311-darwin.so (*) <ac517351-6084-3d4c-8fd9-af2a4d7549bc> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_posixsubprocess.cpython-311-darwin.so
       0x105ffc000 -        0x106007fff _elementtree.cpython-311-darwin.so (*) <c2d81ca0-dfef-332e-b119-384c3fb2efcb> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_elementtree.cpython-311-darwin.so
       0x106018000 -        0x10601ffff pyexpat.cpython-311-darwin.so (*) <1c8cadb5-9958-3eff-965f-c5f1f2d75eb2> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/pyexpat.cpython-311-darwin.so
       0x106164000 -        0x10616bfff _hashlib.cpython-311-darwin.so (*) <c58233f0-f88c-324e-81f2-47477bbb828c> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_hashlib.cpython-311-darwin.so
       0x106818000 -        0x106997fff libcrypto.1.1.dylib (*) <3fa12991-7e4b-39ea-bfd2-fdd5d71a0714> /opt/homebrew/*/libcrypto.1.1.dylib
       0x10617c000 -        0x106183fff _blake2.cpython-311-darwin.so (*) <bfb55ded-ac7e-3005-aaad-f9c6caee0732> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_blake2.cpython-311-darwin.so
       0x106600000 -        0x106763fff _sqlite3.cpython-311-darwin.so (*) <51ad54d0-358e-30db-aeb9-a8543685da6d> /Users/USER/*/_sqlite3.cpython-311-darwin.so
       0x105fac000 -        0x105faffff termios.cpython-311-darwin.so (*) <e5eb5b39-6936-340a-b1bd-30bd426d5cb0> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/termios.cpython-311-darwin.so
       0x105fbc000 -        0x105fbffff _contextvars.cpython-311-darwin.so (*) <3b534670-b594-390f-a57b-f605f1f98bd6> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_contextvars.cpython-311-darwin.so
       0x1061c4000 -        0x1061dbfff _ssl.cpython-311-darwin.so (*) <62a2432a-e615-385e-b474-ea53fd556405> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_ssl.cpython-311-darwin.so
       0x106f00000 -        0x106f4bfff libssl.1.1.dylib (*) <6d28d494-f7da-3688-a9ca-d5b7e14a9008> /opt/homebrew/*/libssl.1.1.dylib
       0x106d34000 -        0x106d3ffff _asyncio.cpython-311-darwin.so (*) <921ce766-5c7b-3fc0-bb07-41b3f5a36942> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_asyncio.cpython-311-darwin.so
       0x106d50000 -        0x106d5ffff _sqlite3.cpython-311-darwin.so (*) <bb9b3734-4686-3585-adeb-50b06ccacd08> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_sqlite3.cpython-311-darwin.so
       0x10781c000 -        0x10790bfff libsqlite3.0.dylib (*) <9d56adc4-e59d-3334-9706-7fb8cfa82c2c> /opt/homebrew/*/libsqlite3.0.dylib
       0x1061a4000 -        0x1061abfff _zoneinfo.cpython-311-darwin.so (*) <b3c3a9d5-2a09-3bc1-991a-695d83eb45e0> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_zoneinfo.cpython-311-darwin.so
       0x106190000 -        0x106193fff _statistics.cpython-311-darwin.so (*) <75a5be34-5c3c-3685-86e1-5ff67fdf2ec8> /opt/homebrew/*/Python.framework/Versions/3.11/lib/python3.11/lib-dynload/_statistics.cpython-311-darwin.so
       0x10c6cc000 -        0x10cd4bfff mod_spatialite.7.dylib (*) <801bdac4-7fc1-3e78-beff-67b0661c77ba> /opt/homebrew/*/mod_spatialite.7.dylib
       0x109d18000 -        0x109df3fff libxml2.2.dylib (*) <d485ee1d-b254-3745-8d28-85993cc37b84> /opt/homebrew/*/libxml2.2.dylib
       0x106d94000 -        0x106da7fff libminizip.1.dylib (*) <3d621da8-92f1-3e41-bb5a-883472404f03> /opt/homebrew/*/libminizip.1.dylib
       0x10823c000 -        0x108283fff librttopo.1.dylib (*) <9cc1b769-e145-32d6-bfa2-6848f43176a9> /opt/homebrew/*/librttopo.1.dylib
       0x106db8000 -        0x106dbffff libfreexl.1.dylib (*) <2ea9e006-ca56-3cae-b145-fe191861430a> /opt/homebrew/*/libfreexl.1.dylib
       0x10c000000 -        0x10c227fff libproj.25.9.2.1.dylib (*) <ab74d024-6601-3f3e-ad71-c108481c7ad0> /opt/homebrew/*/libproj.25.9.2.1.dylib
       0x1082a0000 -        0x1082bffff libgeos_c.1.17.2.dylib (*) <d845ecd1-a51b-31d9-8c94-bb6431618a11> /opt/homebrew/*/libgeos_c.1.17.2.dylib
       0x10c374000 -        0x10c4fffff libicui18n.73.2.dylib (*) <ac7ad526-d2a3-32ff-86a1-e6d7c801314d> /opt/homebrew/*/libicui18n.73.2.dylib
       0x10b000000 -        0x10b12ffff libicuuc.73.2.dylib (*) <1b3a8563-e617-37ee-b943-3a1266a41e99> /opt/homebrew/*/libicuuc.73.2.dylib
       0x118000000 -        0x119e8ffff libicudata.73.2.dylib (*) <924ed196-193c-3ed9-b403-40f8690348f1> /opt/homebrew/*/libicudata.73.2.dylib
       0x10cd98000 -        0x10ceb3fff libgeos.3.11.2.dylib (*) <8d014496-596e-361b-9654-cbd6e26da56a> /opt/homebrew/*/libgeos.3.11.2.dylib
       0x109800000 -        0x10985ffff libtiff.6.dylib (*) <e353338f-a1a5-3e35-9618-effba1dd5430> /opt/homebrew/*/libtiff.6.dylib
       0x109e30000 -        0x109ed3fff libzstd.1.5.5.dylib (*) <9cc1e4e5-da83-3b83-a1b9-b4f1ccc5d596> /opt/homebrew/*/libzstd.1.5.5.dylib
       0x10987c000 -        0x1098b7fff libjpeg.8.2.2.dylib (*) <fab24eae-3511-36b2-9850-98f2a3737006> /opt/homebrew/*/libjpeg.8.2.2.dylib
       0x18a29b000 -        0x18a2d4fe7 libsystem_kernel.dylib (*) <7acbd9bc-d056-310e-858d-81b116cf6d28> /usr/lib/system/libsystem_kernel.dylib
       0x18a2d5000 -        0x18a2e1fff libsystem_pthread.dylib (*) <b401cfb3-8dfe-32db-92b3-ba8af0f8ca6e> /usr/lib/system/libsystem_pthread.dylib
       0x18a173000 -        0x18a1f1ff7 libsystem_c.dylib (*) <9277aff7-3cc3-30d0-99b7-c62680da95cf> /usr/lib/system/libsystem_c.dylib
       0x18a307000 -        0x18a30dff3 libsystem_platform.dylib (*) <756cd10d-62a0-3283-9e57-cbaa810c95ac> /usr/lib/system/libsystem_platform.dylib
       0x189f7e000 -        0x18a00c53b dyld (*) <6f2c2bb8-4bbc-3b64-b927-d3f3193b6295> /usr/lib/dyld
               0x0 - 0xffffffffffffffff ??? (*) <00000000-0000-0000-0000-000000000000> ???

External Modification Summary:
  Calls made by other processes targeting this process:
    task_for_pid: 0
    thread_create: 0
    thread_set_state: 0
  Calls made by this process:
    task_for_pid: 0
    thread_create: 0
    thread_set_state: 0
  Calls made by all processes on this machine:
    task_for_pid: 1
    thread_create: 0
    thread_set_state: 0

VM Region Summary:
ReadOnly portion of Libraries: Total=977.1M resident=0K(0%) swapped_out_or_unallocated=977.1M(100%)
Writable regions: Total=1.9G written=0K(0%) resident=0K(0%) swapped_out=0K(0%) unallocated=1.9G(100%)

                                VIRTUAL   REGION 
REGION TYPE                        SIZE    COUNT (non-coalesced) 
===========                     =======  ======= 
Activity Tracing                   256K        1 
Kernel Alloc Once                   32K        1 
MALLOC                           703.2M       49 
MALLOC guard page                   96K        5 
MALLOC_MEDIUM (reserved)           1.2G       10         reserved VM address space (unallocated)
SQLite page cache                  384K        3 
Stack                             16.0M        1 
Stack Guard                         16K        1 
VM_ALLOCATE                       39.0M       40 
__AUTH                             323K       66 
__AUTH_CONST                      3817K      154 
__DATA                            3892K      203 
__DATA_CONST                      5786K      210 
__DATA_DIRTY                       361K       58 
__LINKEDIT                       808.1M       57 
__OBJC_RO                         66.2M        1 
__OBJC_RW                         2011K        1 
__TEXT                           169.1M      219 
dyld private memory                272K        2 
mapped file                         64K        1 
shared memory                       32K        2 
===========                     =======  ======= 
TOTAL                              2.9G     1085 
TOTAL, minus reserved VM space     1.8G     1085 



-----------
Full Report
-----------

{"app_name":"Python","timestamp":"2023-06-25 14:33:50.00 -0700","app_version":"3.11.4","slice_uuid":"9dc70b4b-b47b-3d35-b01f-5ba6fea9d0ec","build_version":"3.11.4","platform":1,"bundleID":"org.python.python","share_with_app_devs":1,"is_first_party":0,"bug_type":"309","os_version":"macOS 13.3 (22E252)","roots_installed":0,"name":"Python","incident_id":"4380EB6C-2620-4426-8087-4565056A2707"}
{
  "uptime" : 780000,
  "procRole" : "Unspecified",
  "version" : 2,
  "userID" : 501,
  "deployVersion" : 210,
  "modelCode" : "Mac14,6",
  "coalitionID" : 541,
  "osVersion" : {
    "train" : "macOS 13.3",
    "build" : "22E252",
    "releaseType" : "User"
  },
  "captureTime" : "2023-06-25 14:33:50.4278 -0700",
  "incident" : "4380EB6C-2620-4426-8087-4565056A2707",
  "pid" : 91597,
  "translated" : false,
  "cpuType" : "ARM-64",
  "roots_installed" : 0,
  "bug_type" : "309",
  "procLaunch" : "2023-06-25 14:33:44.7255 -0700",
  "procStartAbsTime" : 18927572942388,
  "procExitAbsTime" : 18927709789142,
  "procName" : "Python",
  "procPath" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/Resources\/Python.app\/Contents\/MacOS\/Python",
  "bundleInfo" : {"CFBundleShortVersionString":"3.11.4","CFBundleVersion":"3.11.4","CFBundleIdentifier":"org.python.python"},
  "storeInfo" : {"deviceIdentifierForVendor":"C04BD6BF-6B7A-57DA-9F14-0996F542057B","thirdParty":true},
  "parentProc" : "zsh",
  "parentPid" : 91496,
  "coalitionName" : "com.apple.Terminal",
  "crashReporterKey" : "AA32BCEA-02C3-0406-C103-6C81844AE525",
  "responsiblePid" : 483,
  "responsibleProc" : "Terminal",
  "codeSigningID" : "org.python.python",
  "codeSigningTeamID" : "",
  "codeSigningFlags" : 570425857,
  "codeSigningValidationCategory" : 10,
  "codeSigningTrustLevel" : 0,
  "wakeTime" : 2509,
  "sleepWakeUUID" : "A29C5D5F-11C7-4A88-8FAC-BE834A478139",
  "sip" : "enabled",
  "vmRegionInfo" : "0x646565727472 is not in any region.  Bytes after previous region: 4833003336819  \n      REGION TYPE                    START - END         [ VSIZE] PRT\/MAX SHRMOD  REGION DETAIL\n      MALLOC_NANO              600018000000-600020000000 [128.0M] rw-\/rwx SM=PRV  \n--->  \n      UNUSED SPACE AT END",
  "exception" : {"codes":"0x0000000000000101, 0x7369646565727472","rawCodes":[257,8316288573572805746],"type":"EXC_BAD_ACCESS","signal":"SIGBUS","subtype":"UNKNOWN_0x101 at 0x7369646565727472 -> 0x0000646565727472 (possible pointer authentication failure)"},
  "vmregioninfo" : "0x646565727472 is not in any region.  Bytes after previous region: 4833003336819  \n      REGION TYPE                    START - END         [ VSIZE] PRT\/MAX SHRMOD  REGION DETAIL\n      MALLOC_NANO              600018000000-600020000000 [128.0M] rw-\/rwx SM=PRV  \n--->  \n      UNUSED SPACE AT END",
  "extMods" : {"caller":{"thread_create":0,"thread_set_state":0,"task_for_pid":0},"system":{"thread_create":0,"thread_set_state":0,"task_for_pid":1},"targeted":{"thread_create":0,"thread_set_state":0,"task_for_pid":0},"warnings":0},
  "faultingThread" : 0,
  "threads" : [{"triggered":true,"id":17671917,"threadState":{"x":[{"value":0},{"value":0},{"value":1},{"value":0},{"value":115},{"value":115},{"value":1536},{"value":4294967294},{"value":6074181552537702927},{"value":6074181556246595919},{"value":14757395258967641293},{"value":246},{"value":4833213027},{"value":0},{"value":49},{"value":4294967249},{"value":328},{"value":8223313696},{"value":0},{"value":10},{"value":8144509760,"symbolLocation":0,"symbol":"_main_thread"},{"value":259},{"value":8144509984,"symbolLocation":224,"symbol":"_main_thread"},{"value":0},{"value":1},{"value":4383964280,"symbolLocation":0,"symbol":"PyBaseObject_Type"},{"value":4381714320,"symbolLocation":0,"symbol":"object_dealloc"},{"value":4377433232},{"value":4377433248}],"flavor":"ARM_THREAD_STATE64","lr":{"value":6613220392},"cpsr":{"value":1073745920},"fp":{"value":4833213152},"sp":{"value":4833213120},"esr":{"value":1442840704,"description":" Address size fault"},"pc":{"value":6612993828,"matchesCrashFrame":1},"far":{"value":4394860696}},"queue":"com.apple.main-thread","frames":[{"imageOffset":38692,"symbol":"__pthread_kill","symbolLocation":8,"imageIndex":56},{"imageOffset":27688,"symbol":"pthread_kill","symbolLocation":288,"imageIndex":57},{"imageOffset":259180,"symbol":"raise","symbolLocation":32,"imageIndex":58},{"imageOffset":1708992,"symbol":"faulthandler_fatal_error","symbolLocation":440,"imageIndex":1},{"imageOffset":14980,"symbol":"_sigtramp","symbolLocation":56,"imageIndex":59},{"imageOffset":319688,"symbol":"sqlite3LeaveMutexAndCloseZombie","symbolLocation":544,"imageIndex":32},{"imageOffset":349112,"symbol":"sqlite3Close","symbolLocation":104,"imageIndex":32},{"imageOffset":349216,"symbol":"sqlite3_close_v2","symbolLocation":16,"imageIndex":32},{"imageOffset":1148500,"symbol":"pysqlite_connection_dealloc","symbolLocation":36,"imageIndex":32},{"imageOffset":798548,"symbol":"subtype_dealloc","symbolLocation":460,"imageIndex":1},{"imageOffset":1418728,"symbol":"_PyFrame_Clear","symbolLocation":100,"imageIndex":1},{"imageOffset":1307780,"symbol":"_PyEval_Vector","symbolLocation":140,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":405080,"symbol":"_PyObject_FastCallDictTstate","symbolLocation":208,"imageIndex":1},{"imageOffset":816984,"symbol":"slot_tp_call","symbolLocation":180,"imageIndex":1},{"imageOffset":404284,"symbol":"_PyObject_MakeTpCall","symbolLocation":128,"imageIndex":1},{"imageOffset":1289664,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":40664,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":405080,"symbol":"_PyObject_FastCallDictTstate","symbolLocation":208,"imageIndex":1},{"imageOffset":816984,"symbol":"slot_tp_call","symbolLocation":180,"imageIndex":1},{"imageOffset":408012,"symbol":"_PyObject_Call","symbolLocation":124,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":405080,"symbol":"_PyObject_FastCallDictTstate","symbolLocation":208,"imageIndex":1},{"imageOffset":816984,"symbol":"slot_tp_call","symbolLocation":180,"imageIndex":1},{"imageOffset":404284,"symbol":"_PyObject_MakeTpCall","symbolLocation":128,"imageIndex":1},{"imageOffset":1289664,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":40664,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":405080,"symbol":"_PyObject_FastCallDictTstate","symbolLocation":208,"imageIndex":1},{"imageOffset":816984,"symbol":"slot_tp_call","symbolLocation":180,"imageIndex":1},{"imageOffset":404284,"symbol":"_PyObject_MakeTpCall","symbolLocation":128,"imageIndex":1},{"imageOffset":1289664,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":40664,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":1297380,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":48380,"imageIndex":1},{"imageOffset":1307756,"symbol":"_PyEval_Vector","symbolLocation":116,"imageIndex":1},{"imageOffset":405080,"symbol":"_PyObject_FastCallDictTstate","symbolLocation":208,"imageIndex":1},{"imageOffset":816984,"symbol":"slot_tp_call","symbolLocation":180,"imageIndex":1},{"imageOffset":404284,"symbol":"_PyObject_MakeTpCall","symbolLocation":128,"imageIndex":1},{"imageOffset":1289664,"symbol":"_PyEval_EvalFrameDefault","symbolLocation":40664,"imageIndex":1},{"imageOffset":1246116,"symbol":"PyEval_EvalCode","symbolLocation":168,"imageIndex":1},{"imageOffset":1580132,"symbol":"run_eval_code_obj","symbolLocation":84,"imageIndex":1},{"imageOffset":1579976,"symbol":"run_mod","symbolLocation":112,"imageIndex":1},{"imageOffset":1579528,"symbol":"pyrun_file","symbolLocation":148,"imageIndex":1},{"imageOffset":1578076,"symbol":"_PyRun_SimpleFileObject","symbolLocation":268,"imageIndex":1},{"imageOffset":1576428,"symbol":"_PyRun_AnyFileObject","symbolLocation":216,"imageIndex":1},{"imageOffset":1690772,"symbol":"pymain_run_file_obj","symbolLocation":220,"imageIndex":1},{"imageOffset":1689044,"symbol":"pymain_run_file","symbolLocation":72,"imageIndex":1},{"imageOffset":1687220,"symbol":"Py_RunMain","symbolLocation":704,"imageIndex":1},{"imageOffset":1691628,"symbol":"Py_BytesMain","symbolLocation":40,"imageIndex":1},{"imageOffset":24360,"symbol":"start","symbolLocation":2236,"imageIndex":60}]}],
  "usedImages" : [
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4375658496,
    "CFBundleShortVersionString" : "3.11.4",
    "CFBundleIdentifier" : "org.python.python",
    "size" : 16384,
    "uuid" : "9dc70b4b-b47b-3d35-b01f-5ba6fea9d0ec",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/Resources\/Python.app\/Contents\/MacOS\/Python",
    "name" : "Python",
    "CFBundleVersion" : "3.11.4"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4380868608,
    "CFBundleShortVersionString" : "3.11.4, (c) 2001-2023 Python Software Foundation.",
    "CFBundleIdentifier" : "org.python.python",
    "size" : 2719744,
    "uuid" : "ff1b9a38-8c48-37c7-a653-cc5fd69bbf29",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/Python",
    "name" : "Python",
    "CFBundleVersion" : "3.11.4"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4379623424,
    "size" : 16384,
    "uuid" : "66d8c6b3-fb84-36b2-840b-a13797c6d05c",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_opcode.cpython-311-darwin.so",
    "name" : "_opcode.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4380737536,
    "size" : 16384,
    "uuid" : "0de32fb1-0c65-3673-a516-8e816433fe23",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_typing.cpython-311-darwin.so",
    "name" : "_typing.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387143680,
    "size" : 32768,
    "uuid" : "f013a63a-17b6-33f4-b86c-7b3c2b0e84c3",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_csv.cpython-311-darwin.so",
    "name" : "_csv.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387225600,
    "size" : 32768,
    "uuid" : "72a70cad-76ca-37a9-9d53-82eb43b6a615",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/binascii.cpython-311-darwin.so",
    "name" : "binascii.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387307520,
    "size" : 32768,
    "uuid" : "b0a5fab2-03c0-36d3-813f-e5e2ad4e028a",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/zlib.cpython-311-darwin.so",
    "name" : "zlib.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4380803072,
    "size" : 16384,
    "uuid" : "a972cae5-ddce-3c55-b967-641c422e81d8",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_bz2.cpython-311-darwin.so",
    "name" : "_bz2.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387487744,
    "size" : 32768,
    "uuid" : "3b0c13fa-2f8c-31d1-86e1-d3b5bc9d5948",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_lzma.cpython-311-darwin.so",
    "name" : "_lzma.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387782656,
    "size" : 131072,
    "uuid" : "b0eb2993-ed5b-313b-8e4e-4f206b05ea68",
    "path" : "\/opt\/homebrew\/*\/liblzma.5.dylib",
    "name" : "liblzma.5.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387389440,
    "size" : 32768,
    "uuid" : "78212abb-d873-3a30-bdb4-1d95a42e032f",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_struct.cpython-311-darwin.so",
    "name" : "_struct.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387684352,
    "size" : 49152,
    "uuid" : "3e5aee3b-0a9a-3b62-b0ce-971737c0b9c5",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/math.cpython-311-darwin.so",
    "name" : "math.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387061760,
    "size" : 16384,
    "uuid" : "0485697b-5f35-363c-bf21-1ca99882739b",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_bisect.cpython-311-darwin.so",
    "name" : "_bisect.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4387586048,
    "size" : 16384,
    "uuid" : "9a40fb5d-035f-3596-bcc6-52ec5b4f06ef",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_random.cpython-311-darwin.so",
    "name" : "_random.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389027840,
    "size" : 16384,
    "uuid" : "d5768942-bc77-3e29-817a-cb14ca2bed2c",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_sha512.cpython-311-darwin.so",
    "name" : "_sha512.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389208064,
    "size" : 65536,
    "uuid" : "8aeb9152-a04c-36c8-902c-e0f5b77496c3",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_socket.cpython-311-darwin.so",
    "name" : "_socket.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389322752,
    "size" : 32768,
    "uuid" : "299158ec-38c8-3acc-bd1d-07edd1305c2d",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/select.cpython-311-darwin.so",
    "name" : "select.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389404672,
    "size" : 32768,
    "uuid" : "f7aecc79-fe10-3cd4-ba3d-cecb3b9de79c",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/array.cpython-311-darwin.so",
    "name" : "array.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389617664,
    "size" : 65536,
    "uuid" : "c57fc72c-ea98-3d43-8a36-7b2680d86c34",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_datetime.cpython-311-darwin.so",
    "name" : "_datetime.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4391960576,
    "size" : 1114112,
    "uuid" : "f22b815f-c98a-3750-8b7d-ebc1bffd41ba",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/unicodedata.cpython-311-darwin.so",
    "name" : "unicodedata.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389093376,
    "size" : 16384,
    "uuid" : "d3822f3a-a54f-35e7-8dc3-64bb3184dc38",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_uuid.cpython-311-darwin.so",
    "name" : "_uuid.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4391845888,
    "size" : 32768,
    "uuid" : "ed48f59d-c04c-3cb7-ae60-419f04ed3bf0",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_json.cpython-311-darwin.so",
    "name" : "_json.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389486592,
    "size" : 16384,
    "uuid" : "c2a2fce5-02e4-39b8-b32e-7e405790d604",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_heapq.cpython-311-darwin.so",
    "name" : "_heapq.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395417600,
    "size" : 114688,
    "uuid" : "d1a34e1a-3b98-3799-8ee4-40d080a9aabf",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_decimal.cpython-311-darwin.so",
    "name" : "_decimal.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395827200,
    "size" : 131072,
    "uuid" : "19d22096-3c8e-3629-84c1-08b5029699a3",
    "path" : "\/opt\/homebrew\/*\/libmpdec.2.5.1.dylib",
    "name" : "libmpdec.2.5.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4389552128,
    "size" : 16384,
    "uuid" : "6315c932-cd38-3e79-bd5b-1d5fb863a43f",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/fcntl.cpython-311-darwin.so",
    "name" : "fcntl.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395220992,
    "size" : 16384,
    "uuid" : "ac517351-6084-3d4c-8fd9-af2a4d7549bc",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_posixsubprocess.cpython-311-darwin.so",
    "name" : "_posixsubprocess.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395614208,
    "size" : 49152,
    "uuid" : "c2d81ca0-dfef-332e-b119-384c3fb2efcb",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_elementtree.cpython-311-darwin.so",
    "name" : "_elementtree.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395728896,
    "size" : 32768,
    "uuid" : "1c8cadb5-9958-3eff-965f-c5f1f2d75eb2",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/pyexpat.cpython-311-darwin.so",
    "name" : "pyexpat.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397088768,
    "size" : 32768,
    "uuid" : "c58233f0-f88c-324e-81f2-47477bbb828c",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_hashlib.cpython-311-darwin.so",
    "name" : "_hashlib.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4404117504,
    "size" : 1572864,
    "uuid" : "3fa12991-7e4b-39ea-bfd2-fdd5d71a0714",
    "path" : "\/opt\/homebrew\/*\/libcrypto.1.1.dylib",
    "name" : "libcrypto.1.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397187072,
    "size" : 32768,
    "uuid" : "bfb55ded-ac7e-3005-aaad-f9c6caee0732",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_blake2.cpython-311-darwin.so",
    "name" : "_blake2.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4401922048,
    "size" : 1458176,
    "uuid" : "51ad54d0-358e-30db-aeb9-a8543685da6d",
    "path" : "\/Users\/USER\/*\/_sqlite3.cpython-311-darwin.so",
    "name" : "_sqlite3.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395286528,
    "size" : 16384,
    "uuid" : "e5eb5b39-6936-340a-b1bd-30bd426d5cb0",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/termios.cpython-311-darwin.so",
    "name" : "termios.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395352064,
    "size" : 16384,
    "uuid" : "3b534670-b594-390f-a57b-f605f1f98bd6",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_contextvars.cpython-311-darwin.so",
    "name" : "_contextvars.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397481984,
    "size" : 98304,
    "uuid" : "62a2432a-e615-385e-b474-ea53fd556405",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_ssl.cpython-311-darwin.so",
    "name" : "_ssl.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4411359232,
    "size" : 311296,
    "uuid" : "6d28d494-f7da-3688-a9ca-d5b7e14a9008",
    "path" : "\/opt\/homebrew\/*\/libssl.1.1.dylib",
    "name" : "libssl.1.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4409475072,
    "size" : 49152,
    "uuid" : "921ce766-5c7b-3fc0-bb07-41b3f5a36942",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_asyncio.cpython-311-darwin.so",
    "name" : "_asyncio.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4409589760,
    "size" : 65536,
    "uuid" : "bb9b3734-4686-3585-adeb-50b06ccacd08",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_sqlite3.cpython-311-darwin.so",
    "name" : "_sqlite3.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4420911104,
    "size" : 983040,
    "uuid" : "9d56adc4-e59d-3334-9706-7fb8cfa82c2c",
    "path" : "\/opt\/homebrew\/*\/libsqlite3.0.dylib",
    "name" : "libsqlite3.0.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397350912,
    "size" : 32768,
    "uuid" : "b3c3a9d5-2a09-3bc1-991a-695d83eb45e0",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_zoneinfo.cpython-311-darwin.so",
    "name" : "_zoneinfo.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397268992,
    "size" : 16384,
    "uuid" : "75a5be34-5c3c-3685-86e1-5ff67fdf2ec8",
    "path" : "\/opt\/homebrew\/*\/Python.framework\/Versions\/3.11\/lib\/python3.11\/lib-dynload\/_statistics.cpython-311-darwin.so",
    "name" : "_statistics.cpython-311-darwin.so"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4503420928,
    "size" : 6815744,
    "uuid" : "801bdac4-7fc1-3e78-beff-67b0661c77ba",
    "path" : "\/opt\/homebrew\/*\/mod_spatialite.7.dylib",
    "name" : "mod_spatialite.7.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4459692032,
    "size" : 901120,
    "uuid" : "d485ee1d-b254-3745-8d28-85993cc37b84",
    "path" : "\/opt\/homebrew\/*\/libxml2.2.dylib",
    "name" : "libxml2.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4409868288,
    "size" : 81920,
    "uuid" : "3d621da8-92f1-3e41-bb5a-883472404f03",
    "path" : "\/opt\/homebrew\/*\/libminizip.1.dylib",
    "name" : "libminizip.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4431527936,
    "size" : 294912,
    "uuid" : "9cc1b769-e145-32d6-bfa2-6848f43176a9",
    "path" : "\/opt\/homebrew\/*\/librttopo.1.dylib",
    "name" : "librttopo.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4410015744,
    "size" : 32768,
    "uuid" : "2ea9e006-ca56-3cae-b145-fe191861430a",
    "path" : "\/opt\/homebrew\/*\/libfreexl.1.dylib",
    "name" : "libfreexl.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4496293888,
    "size" : 2260992,
    "uuid" : "ab74d024-6601-3f3e-ad71-c108481c7ad0",
    "path" : "\/opt\/homebrew\/*\/libproj.25.9.2.1.dylib",
    "name" : "libproj.25.9.2.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4431937536,
    "size" : 131072,
    "uuid" : "d845ecd1-a51b-31d9-8c94-bb6431618a11",
    "path" : "\/opt\/homebrew\/*\/libgeos_c.1.17.2.dylib",
    "name" : "libgeos_c.1.17.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4499914752,
    "size" : 1622016,
    "uuid" : "ac7ad526-d2a3-32ff-86a1-e6d7c801314d",
    "path" : "\/opt\/homebrew\/*\/libicui18n.73.2.dylib",
    "name" : "libicui18n.73.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4479516672,
    "size" : 1245184,
    "uuid" : "1b3a8563-e617-37ee-b943-3a1266a41e99",
    "path" : "\/opt\/homebrew\/*\/libicuuc.73.2.dylib",
    "name" : "libicuuc.73.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4697620480,
    "size" : 32047104,
    "uuid" : "924ed196-193c-3ed9-b403-40f8690348f1",
    "path" : "\/opt\/homebrew\/*\/libicudata.73.2.dylib",
    "name" : "libicudata.73.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4510547968,
    "size" : 1163264,
    "uuid" : "8d014496-596e-361b-9654-cbd6e26da56a",
    "path" : "\/opt\/homebrew\/*\/libgeos.3.11.2.dylib",
    "name" : "libgeos.3.11.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4454350848,
    "size" : 393216,
    "uuid" : "e353338f-a1a5-3e35-9618-effba1dd5430",
    "path" : "\/opt\/homebrew\/*\/libtiff.6.dylib",
    "name" : "libtiff.6.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4460838912,
    "size" : 671744,
    "uuid" : "9cc1e4e5-da83-3b83-a1b9-b4f1ccc5d596",
    "path" : "\/opt\/homebrew\/*\/libzstd.1.5.5.dylib",
    "name" : "libzstd.1.5.5.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4454858752,
    "size" : 245760,
    "uuid" : "fab24eae-3511-36b2-9850-98f2a3737006",
    "path" : "\/opt\/homebrew\/*\/libjpeg.8.2.2.dylib",
    "name" : "libjpeg.8.2.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6612955136,
    "size" : 237544,
    "uuid" : "7acbd9bc-d056-310e-858d-81b116cf6d28",
    "path" : "\/usr\/lib\/system\/libsystem_kernel.dylib",
    "name" : "libsystem_kernel.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6613192704,
    "size" : 53248,
    "uuid" : "b401cfb3-8dfe-32db-92b3-ba8af0f8ca6e",
    "path" : "\/usr\/lib\/system\/libsystem_pthread.dylib",
    "name" : "libsystem_pthread.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6611742720,
    "size" : 520184,
    "uuid" : "9277aff7-3cc3-30d0-99b7-c62680da95cf",
    "path" : "\/usr\/lib\/system\/libsystem_c.dylib",
    "name" : "libsystem_c.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6613397504,
    "size" : 28660,
    "uuid" : "756cd10d-62a0-3283-9e57-cbaa810c95ac",
    "path" : "\/usr\/lib\/system\/libsystem_platform.dylib",
    "name" : "libsystem_platform.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6609690624,
    "size" : 582972,
    "uuid" : "6f2c2bb8-4bbc-3b64-b927-d3f3193b6295",
    "path" : "\/usr\/lib\/dyld",
    "name" : "dyld"
  },
  {
    "size" : 0,
    "source" : "A",
    "base" : 0,
    "uuid" : "00000000-0000-0000-0000-000000000000"
  }
],
  "sharedCache" : {
  "base" : 6609027072,
  "size" : 3539501056,
  "uuid" : "581a6955-d455-3735-973b-5233bd5dd16e"
},
  "vmSummary" : "ReadOnly portion of Libraries: Total=977.1M resident=0K(0%) swapped_out_or_unallocated=977.1M(100%)\nWritable regions: Total=1.9G written=0K(0%) resident=0K(0%) swapped_out=0K(0%) unallocated=1.9G(100%)\n\n                                VIRTUAL   REGION \nREGION TYPE                        SIZE    COUNT (non-coalesced) \n===========                     =======  ======= \nActivity Tracing                   256K        1 \nKernel Alloc Once                   32K        1 \nMALLOC                           703.2M       49 \nMALLOC guard page                   96K        5 \nMALLOC_MEDIUM (reserved)           1.2G       10         reserved VM address space (unallocated)\nSQLite page cache                  384K        3 \nStack                             16.0M        1 \nStack Guard                         16K        1 \nVM_ALLOCATE                       39.0M       40 \n__AUTH                             323K       66 \n__AUTH_CONST                      3817K      154 \n__DATA                            3892K      203 \n__DATA_CONST                      5786K      210 \n__DATA_DIRTY                       361K       58 \n__LINKEDIT                       808.1M       57 \n__OBJC_RO                         66.2M        1 \n__OBJC_RW                         2011K        1 \n__TEXT                           169.1M      219 \ndyld private memory                272K        2 \nmapped file                         64K        1 \nshared memory                       32K        2 \n===========                     =======  ======= \nTOTAL                              2.9G     1085 \nTOTAL, minus reserved VM space     1.8G     1085 \n",
  "legacyInfo" : {
  "threadTriggered" : {
    "queue" : "com.apple.main-thread"
  }
},
  "logWritingSignature" : "abded0be4698b9f65f355d66a57c4139baa859c3",
  "trialInfo" : {
  "rollouts" : [
    {
      "rolloutId" : "6246d6a916a70b047e454124",
      "factorPackIds" : {

      },
      "deploymentId" : 240000010
    },
    {
      "rolloutId" : "60da5e84ab0ca017dace9abf",
      "factorPackIds" : {

      },
      "deploymentId" : 240000008
    }
  ],
  "experiments" : [
    {
      "treatmentId" : "c28e4ee6-1b08-4f90-8e05-2809e78310a3",
      "experimentId" : "6317d2003d24842ff850182a",
      "deploymentId" : 400000012
    }
  ]
}
}

@simonw simonw mentioned this issue Jun 25, 2023
Merged
@simonw
Copy link
Author

simonw commented Jun 25, 2023

I ran with -vv to try to isolate the test:

% pytest tests/test_gis.py -vv
============================================================================ test session starts =============================================================================
platform darwin -- Python 3.11.4, pytest-7.2.2, pluggy-1.0.0 -- /Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/bin/python
cachedir: .pytest_cache
hypothesis profile 'default' -> database=DirectoryBasedExampleDatabase('/Users/simon/Dropbox/Development/sqlite-utils/.hypothesis/examples')
rootdir: /Users/simon/Dropbox/Development/sqlite-utils
plugins: hypothesis-6.68.2
collected 12 items                                                                                                                                                           

tests/test_gis.py::test_find_spatialite PASSED                                                                                                                         [  8%]
tests/test_gis.py::test_init_spatialite Fatal Python error: Bus error

Current thread 0x00000001e5735b40 (most recent call first):

It looks like it's test_init_spatialite that is crashing: https://github.com/simonw/sqlite-utils/blob/2747257a3334d55e890b40ec58fada57ae8cfbfd/tests/test_gis.py#L26-L30

def test_init_spatialite():
    db = Database(memory=True)
    spatialite = find_spatialite()
    db.init_spatialite(spatialite)
    assert "spatial_ref_sys" in db.table_names()

Here's the most interesting part of what init_spatialite() does: https://github.com/simonw/sqlite-utils/blob/2747257a3334d55e890b40ec58fada57ae8cfbfd/sqlite_utils/db.py#L1184-L1191

        self.conn.enable_load_extension(True)
        self.conn.load_extension(path)
        # Initialize SpatiaLite if not yet initialized
        if "spatial_ref_sys" in self.table_names():
            return False
        cursor = self.execute("select InitSpatialMetadata(1)")
        result = cursor.fetchone()
        return result and bool(result[0])

@simonw
Copy link
Author

simonw commented Jun 25, 2023

So it looks like the problem here may be that sqlean.py doesn't play well with the SpatiaLite module, in particular the version that I have installed on my Mac (which I got via Homebrew, brew install spatialite-tools).

@simonw simonw changed the title Fatal Python error: Bus error Fatal Python error: Bus error - when loading the SpatiaLite extension Jun 25, 2023
@simonw
Copy link
Author

simonw commented Jun 25, 2023

I opened this in the wrong repo, it should be in https://github.com/nalgeon/sqlean.py

simonw referenced this issue in simonw/sqlite-utils Jun 25, 2023
@simonw
Skip SpatiaLite tests with sqlean.py
01e92b0 
Refs https://github.com/nalgeon/sqlean/issues/87
@nalgeon nalgeon transferred this issue from nalgeon/sqlean Jun 26, 2023
@nalgeon
Copy link
Owner

nalgeon commented Jun 26, 2023 •
edited

I tried loading spatialite with pysqlite3 (python 3.11.2, pysqlite 0.5.1) and got exactly the same error:

import pysqlite3 as sqlite3
conn = sqlite3.connect(":memory:")
conn.enable_load_extension(True)
conn.load_extension("/opt/homebrew/lib/mod_spatialite.dylib")
conn.close()

Result:

Bus error: 10

So I don't think the problem is with sqlean.py per se. It probably "inherited" it from pysqlite3 (which in turn inherited it from Python's sqlite3).

@nalgeon
Copy link
Owner

nalgeon commented Jun 26, 2023

See this CPython issue python/cpython#101974:

Using mod_spatialite from conda instead of homebrew fixed the issue - no more bus errors! Are you happy to consider this fixed, or is the behaviour with the homebrew mod_spatialite still considered a bug?

Sounds to me that this is not an sqlite3 bug. The spatialite SQLite modules from Homebrew vs Conda may be compiled with different compilers, different compiler flags, and against different SQLite versions.

Closing as not-a-bug.

I'll probably do the same.

@nalgeon nalgeon closed this as not planned Won't fix, can't repro, duplicate, stale Jun 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@simonw @nalgeon