search

karlb / sqlite-icu

Loadable ICU extension for sqlite as python package
MIT License
4 stars 3 forks source link

Broken on ArchLinux with icu version 71 #1

Closed bravebug closed 2 years ago

bravebug commented 2 years ago 
pacman -Qi icu | grep Version
Version         : 71.1-1
    self.conn.load_extension(sqlite_icu.extension_path().replace('.so', ''))
sqlite3.OperationalError: libicui18n.so.70: cannot open shared object file: No such file or directory
karlb commented 2 years ago

Could you post the value of sqlite_icu.extension_path() and a listing of the directory it is supposed to be in?

bravebug commented 2 years ago

It is installed in a virtual environment, but the same Exception anyway with icu 71

print(sqlite_icu.extension_path())
/home/bravebug/python/myproject/venv/lib/python3.10/site-packages/icu.cpython-310-x86_64-linux-gnu.so
pip show sqlite-icu
Name: sqlite-icu
Version: 1.0
Summary: Loadable ICU extension for sqlite
Home-page: http://github.com/karlb/sqlite-icu
Author: 
Author-email: 
License: UNKNOWN
Location: /home/bravebug/python/myproject/venv/lib/python3.10/site-packages
Requires: 
Required-by: 

ls -la /home/bravebug/python/myproject/venv/lib/python3.10/site-packages | grep icu
icu.cpython-310-x86_64-linux-gnu.so
sqlite_icu-1.0.dist-info
sqlite_icu.py

I don't understand how this information helps you in debugging.

Useful information below, I think (list of package files for different versions):

pacman -Qil icu
Name            : icu
Version         : 71.1-1
Description     : International Components for Unicode library
Architecture    : x86_64
URL             : https://icu.unicode.org
Licenses        : custom:icu
Groups          : None
Provides        : libicudata.so=71-64  libicui18n.so=71-64  libicuio.so=71-64  libicutest.so=71-64  libicutu.so=71-64  libicuuc.so=71-64
Depends On      : gcc-libs  sh
Optional Deps   : None
Required By     : bind  boost-libs  chromium  dwdiff  freerdp  harfbuzz-icu  haskell-text-icu  lib32-icu  libcdr  libical  libmspub  libphonenumber  libreoffice-fresh  libretro-play  libvisio  libxml2  mongo-c-driver  nodejs-lts-gallium
                  raptor  smbclient  texlive-bin  thunderbird  tracker  tracker3  webkit2gtk  webkit2gtk-5.0  xfsprogs
Optional For    : None
Conflicts With  : None
Replaces        : None
Installed Size  : 39.73 MiB
Packager        : Andreas Radke <andyrtr@archlinux.org>
Build Date      : Thu Apr 14 17:09:12 2022
Install Date    : Tue Apr 19 21:30:18 2022
Install Reason  : Installed as a dependency for another package
Install Script  : No
Validated By    : Signature

icu /usr/
icu /usr/bin/
icu /usr/bin/derb
icu /usr/bin/escapesrc
icu /usr/bin/genbrk
icu /usr/bin/genccode
icu /usr/bin/gencfu
icu /usr/bin/gencmn
icu /usr/bin/gencnval
icu /usr/bin/gendict
icu /usr/bin/gennorm2
icu /usr/bin/genrb
icu /usr/bin/gensprep
icu /usr/bin/icu-config
icu /usr/bin/icuexportdata
icu /usr/bin/icuinfo
icu /usr/bin/icupkg
icu /usr/bin/makeconv
icu /usr/bin/pkgdata
icu /usr/bin/uconv
icu /usr/include/
icu /usr/include/unicode/
icu /usr/include/unicode/alphaindex.h
icu /usr/include/unicode/appendable.h
icu /usr/include/unicode/basictz.h
icu /usr/include/unicode/brkiter.h
icu /usr/include/unicode/bytestream.h
icu /usr/include/unicode/bytestrie.h
icu /usr/include/unicode/bytestriebuilder.h
icu /usr/include/unicode/calendar.h
icu /usr/include/unicode/caniter.h
icu /usr/include/unicode/casemap.h
icu /usr/include/unicode/char16ptr.h
icu /usr/include/unicode/chariter.h
icu /usr/include/unicode/choicfmt.h
icu /usr/include/unicode/coleitr.h
icu /usr/include/unicode/coll.h
icu /usr/include/unicode/compactdecimalformat.h
icu /usr/include/unicode/curramt.h
icu /usr/include/unicode/currpinf.h
icu /usr/include/unicode/currunit.h
icu /usr/include/unicode/datefmt.h
icu /usr/include/unicode/dbbi.h
icu /usr/include/unicode/dcfmtsym.h
icu /usr/include/unicode/decimfmt.h
icu /usr/include/unicode/docmain.h
icu /usr/include/unicode/dtfmtsym.h
icu /usr/include/unicode/dtintrv.h
icu /usr/include/unicode/dtitvfmt.h
icu /usr/include/unicode/dtitvinf.h
icu /usr/include/unicode/dtptngen.h
icu /usr/include/unicode/dtrule.h
icu /usr/include/unicode/edits.h
icu /usr/include/unicode/enumset.h
icu /usr/include/unicode/errorcode.h
icu /usr/include/unicode/fieldpos.h
icu /usr/include/unicode/filteredbrk.h
icu /usr/include/unicode/fmtable.h
icu /usr/include/unicode/format.h
icu /usr/include/unicode/formattedvalue.h
icu /usr/include/unicode/fpositer.h
icu /usr/include/unicode/gender.h
icu /usr/include/unicode/gregocal.h
icu /usr/include/unicode/icudataver.h
icu /usr/include/unicode/icuplug.h
icu /usr/include/unicode/idna.h
icu /usr/include/unicode/listformatter.h
icu /usr/include/unicode/localebuilder.h
icu /usr/include/unicode/localematcher.h
icu /usr/include/unicode/localpointer.h
icu /usr/include/unicode/locdspnm.h
icu /usr/include/unicode/locid.h
icu /usr/include/unicode/measfmt.h
icu /usr/include/unicode/measunit.h
icu /usr/include/unicode/measure.h
icu /usr/include/unicode/messagepattern.h
icu /usr/include/unicode/msgfmt.h
icu /usr/include/unicode/normalizer2.h
icu /usr/include/unicode/normlzr.h
icu /usr/include/unicode/nounit.h
icu /usr/include/unicode/numberformatter.h
icu /usr/include/unicode/numberrangeformatter.h
icu /usr/include/unicode/numfmt.h
icu /usr/include/unicode/numsys.h
icu /usr/include/unicode/parseerr.h
icu /usr/include/unicode/parsepos.h
icu /usr/include/unicode/platform.h
icu /usr/include/unicode/plurfmt.h
icu /usr/include/unicode/plurrule.h
icu /usr/include/unicode/ptypes.h
icu /usr/include/unicode/putil.h
icu /usr/include/unicode/rbbi.h
icu /usr/include/unicode/rbnf.h
icu /usr/include/unicode/rbtz.h
icu /usr/include/unicode/regex.h
icu /usr/include/unicode/region.h
icu /usr/include/unicode/reldatefmt.h
icu /usr/include/unicode/rep.h
icu /usr/include/unicode/resbund.h
icu /usr/include/unicode/schriter.h
icu /usr/include/unicode/scientificnumberformatter.h
icu /usr/include/unicode/search.h
icu /usr/include/unicode/selfmt.h
icu /usr/include/unicode/simpleformatter.h
icu /usr/include/unicode/simpletz.h
icu /usr/include/unicode/smpdtfmt.h
icu /usr/include/unicode/sortkey.h
icu /usr/include/unicode/std_string.h
icu /usr/include/unicode/strenum.h
icu /usr/include/unicode/stringoptions.h
icu /usr/include/unicode/stringpiece.h
icu /usr/include/unicode/stringtriebuilder.h
icu /usr/include/unicode/stsearch.h
icu /usr/include/unicode/symtable.h
icu /usr/include/unicode/tblcoll.h
icu /usr/include/unicode/timezone.h
icu /usr/include/unicode/tmunit.h
icu /usr/include/unicode/tmutamt.h
icu /usr/include/unicode/tmutfmt.h
icu /usr/include/unicode/translit.h
icu /usr/include/unicode/tzfmt.h
icu /usr/include/unicode/tznames.h
icu /usr/include/unicode/tzrule.h
icu /usr/include/unicode/tztrans.h
icu /usr/include/unicode/ubidi.h
icu /usr/include/unicode/ubiditransform.h
icu /usr/include/unicode/ubrk.h
icu /usr/include/unicode/ucal.h
icu /usr/include/unicode/ucasemap.h
icu /usr/include/unicode/ucat.h
icu /usr/include/unicode/uchar.h
icu /usr/include/unicode/ucharstrie.h
icu /usr/include/unicode/ucharstriebuilder.h
icu /usr/include/unicode/uchriter.h
icu /usr/include/unicode/uclean.h
icu /usr/include/unicode/ucnv.h
icu /usr/include/unicode/ucnv_cb.h
icu /usr/include/unicode/ucnv_err.h
icu /usr/include/unicode/ucnvsel.h
icu /usr/include/unicode/ucol.h
icu /usr/include/unicode/ucoleitr.h
icu /usr/include/unicode/uconfig.h
icu /usr/include/unicode/ucpmap.h
icu /usr/include/unicode/ucptrie.h
icu /usr/include/unicode/ucsdet.h
icu /usr/include/unicode/ucurr.h
icu /usr/include/unicode/udat.h
icu /usr/include/unicode/udata.h
icu /usr/include/unicode/udateintervalformat.h
icu /usr/include/unicode/udatpg.h
icu /usr/include/unicode/udisplaycontext.h
icu /usr/include/unicode/uenum.h
icu /usr/include/unicode/ufieldpositer.h
icu /usr/include/unicode/uformattable.h
icu /usr/include/unicode/uformattedvalue.h
icu /usr/include/unicode/ugender.h
icu /usr/include/unicode/uidna.h
icu /usr/include/unicode/uiter.h
icu /usr/include/unicode/uldnames.h
icu /usr/include/unicode/ulistformatter.h
icu /usr/include/unicode/uloc.h
icu /usr/include/unicode/ulocdata.h
icu /usr/include/unicode/umachine.h
icu /usr/include/unicode/umisc.h
icu /usr/include/unicode/umsg.h
icu /usr/include/unicode/umutablecptrie.h
icu /usr/include/unicode/unifilt.h
icu /usr/include/unicode/unifunct.h
icu /usr/include/unicode/unimatch.h
icu /usr/include/unicode/unirepl.h
icu /usr/include/unicode/uniset.h
icu /usr/include/unicode/unistr.h
icu /usr/include/unicode/unorm.h
icu /usr/include/unicode/unorm2.h
icu /usr/include/unicode/unounclass.h
icu /usr/include/unicode/unum.h
icu /usr/include/unicode/unumberformatter.h
icu /usr/include/unicode/unumberrangeformatter.h
icu /usr/include/unicode/unumsys.h
icu /usr/include/unicode/uobject.h
icu /usr/include/unicode/upluralrules.h
icu /usr/include/unicode/uregex.h
icu /usr/include/unicode/uregion.h
icu /usr/include/unicode/ureldatefmt.h
icu /usr/include/unicode/urename.h
icu /usr/include/unicode/urep.h
icu /usr/include/unicode/ures.h
icu /usr/include/unicode/uscript.h
icu /usr/include/unicode/usearch.h
icu /usr/include/unicode/uset.h
icu /usr/include/unicode/usetiter.h
icu /usr/include/unicode/ushape.h
icu /usr/include/unicode/uspoof.h
icu /usr/include/unicode/usprep.h
icu /usr/include/unicode/ustdio.h
icu /usr/include/unicode/ustream.h
icu /usr/include/unicode/ustring.h
icu /usr/include/unicode/ustringtrie.h
icu /usr/include/unicode/utext.h
icu /usr/include/unicode/utf.h
icu /usr/include/unicode/utf16.h
icu /usr/include/unicode/utf32.h
icu /usr/include/unicode/utf8.h
icu /usr/include/unicode/utf_old.h
icu /usr/include/unicode/utmscale.h
icu /usr/include/unicode/utrace.h
icu /usr/include/unicode/utrans.h
icu /usr/include/unicode/utypes.h
icu /usr/include/unicode/uvernum.h
icu /usr/include/unicode/uversion.h
icu /usr/include/unicode/vtzone.h
icu /usr/lib/
icu /usr/lib/icu/
icu /usr/lib/icu/71.1/
icu /usr/lib/icu/71.1/Makefile.inc
icu /usr/lib/icu/71.1/pkgdata.inc
icu /usr/lib/icu/Makefile.inc
icu /usr/lib/icu/current
icu /usr/lib/icu/pkgdata.inc
icu /usr/lib/libicudata.so
icu /usr/lib/libicudata.so.71
icu /usr/lib/libicudata.so.71.1
icu /usr/lib/libicui18n.so
icu /usr/lib/libicui18n.so.71
icu /usr/lib/libicui18n.so.71.1
icu /usr/lib/libicuio.so
icu /usr/lib/libicuio.so.71
icu /usr/lib/libicuio.so.71.1
icu /usr/lib/libicutest.so
icu /usr/lib/libicutest.so.71
icu /usr/lib/libicutest.so.71.1
icu /usr/lib/libicutu.so
icu /usr/lib/libicutu.so.71
icu /usr/lib/libicutu.so.71.1
icu /usr/lib/libicuuc.so
icu /usr/lib/libicuuc.so.71
icu /usr/lib/libicuuc.so.71.1
icu /usr/lib/pkgconfig/
icu /usr/lib/pkgconfig/icu-i18n.pc
icu /usr/lib/pkgconfig/icu-io.pc
icu /usr/lib/pkgconfig/icu-uc.pc
icu /usr/share/
icu /usr/share/icu/
icu /usr/share/icu/71.1/
icu /usr/share/icu/71.1/LICENSE
icu /usr/share/icu/71.1/config/
icu /usr/share/icu/71.1/config/mh-linux
icu /usr/share/icu/71.1/install-sh
icu /usr/share/icu/71.1/mkinstalldirs
icu /usr/share/licenses/
icu /usr/share/licenses/icu/
icu /usr/share/licenses/icu/LICENSE
icu /usr/share/man/
icu /usr/share/man/man1/
icu /usr/share/man/man1/derb.1.gz
icu /usr/share/man/man1/genbrk.1.gz
icu /usr/share/man/man1/gencfu.1.gz
icu /usr/share/man/man1/gencnval.1.gz
icu /usr/share/man/man1/gendict.1.gz
icu /usr/share/man/man1/genrb.1.gz
icu /usr/share/man/man1/icu-config.1.gz
icu /usr/share/man/man1/icuexportdata.1.gz
icu /usr/share/man/man1/makeconv.1.gz
icu /usr/share/man/man1/pkgdata.1.gz
icu /usr/share/man/man1/uconv.1.gz
icu /usr/share/man/man8/
icu /usr/share/man/man8/genccode.8.gz
icu /usr/share/man/man8/gencmn.8.gz
icu /usr/share/man/man8/gensprep.8.gz
icu /usr/share/man/man8/icupkg.8.gz
pacman -Qil icu
Name            : icu
Version         : 70.1-1
Description     : International Components for Unicode library
Architecture    : aarch64
URL             : https://icu.unicode.org
Licenses        : custom:icu
Groups          : None
Provides        : libicudata.so=70-64  libicui18n.so=70-64  libicuio.so=70-64  libicutest.so=70-64  libicutu.so=70-64  libicuuc.so=70-64
Depends On      : gcc-libs  sh
Optional Deps   : None
Required By     : libxml2  nodejs  postgresql  smbclient  xfsprogs
Optional For    : None
Conflicts With  : None
Replaces        : None
Installed Size  : 39.21 MiB
Packager        : Arch Linux ARM Build System <builder+n1@archlinuxarm.org>
Build Date      : Wed Nov 24 06:49:00 2021
Install Date    : Sat Jan 1 15:06:24 2022
Install Reason  : Installed as a dependency for another package
Install Script  : No
Validated By    : Signature

icu /usr/
icu /usr/bin/
icu /usr/bin/derb
icu /usr/bin/escapesrc
icu /usr/bin/genbrk
icu /usr/bin/genccode
icu /usr/bin/gencfu
icu /usr/bin/gencmn
icu /usr/bin/gencnval
icu /usr/bin/gendict
icu /usr/bin/gennorm2
icu /usr/bin/genrb
icu /usr/bin/gensprep
icu /usr/bin/icu-config
icu /usr/bin/icuexportdata
icu /usr/bin/icuinfo
icu /usr/bin/icupkg
icu /usr/bin/makeconv
icu /usr/bin/pkgdata
icu /usr/bin/uconv
icu /usr/include/
icu /usr/include/unicode/
icu /usr/include/unicode/alphaindex.h
icu /usr/include/unicode/appendable.h
icu /usr/include/unicode/basictz.h
icu /usr/include/unicode/brkiter.h
icu /usr/include/unicode/bytestream.h
icu /usr/include/unicode/bytestrie.h
icu /usr/include/unicode/bytestriebuilder.h
icu /usr/include/unicode/calendar.h
icu /usr/include/unicode/caniter.h
icu /usr/include/unicode/casemap.h
icu /usr/include/unicode/char16ptr.h
icu /usr/include/unicode/chariter.h
icu /usr/include/unicode/choicfmt.h
icu /usr/include/unicode/coleitr.h
icu /usr/include/unicode/coll.h
icu /usr/include/unicode/compactdecimalformat.h
icu /usr/include/unicode/curramt.h
icu /usr/include/unicode/currpinf.h
icu /usr/include/unicode/currunit.h
icu /usr/include/unicode/datefmt.h
icu /usr/include/unicode/dbbi.h
icu /usr/include/unicode/dcfmtsym.h
icu /usr/include/unicode/decimfmt.h
icu /usr/include/unicode/docmain.h
icu /usr/include/unicode/dtfmtsym.h
icu /usr/include/unicode/dtintrv.h
icu /usr/include/unicode/dtitvfmt.h
icu /usr/include/unicode/dtitvinf.h
icu /usr/include/unicode/dtptngen.h
icu /usr/include/unicode/dtrule.h
icu /usr/include/unicode/edits.h
icu /usr/include/unicode/enumset.h
icu /usr/include/unicode/errorcode.h
icu /usr/include/unicode/fieldpos.h
icu /usr/include/unicode/filteredbrk.h
icu /usr/include/unicode/fmtable.h
icu /usr/include/unicode/format.h
icu /usr/include/unicode/formattedvalue.h
icu /usr/include/unicode/fpositer.h
icu /usr/include/unicode/gender.h
icu /usr/include/unicode/gregocal.h
icu /usr/include/unicode/icudataver.h
icu /usr/include/unicode/icuplug.h
icu /usr/include/unicode/idna.h
icu /usr/include/unicode/listformatter.h
icu /usr/include/unicode/localebuilder.h
icu /usr/include/unicode/localematcher.h
icu /usr/include/unicode/localpointer.h
icu /usr/include/unicode/locdspnm.h
icu /usr/include/unicode/locid.h
icu /usr/include/unicode/measfmt.h
icu /usr/include/unicode/measunit.h
icu /usr/include/unicode/measure.h
icu /usr/include/unicode/messagepattern.h
icu /usr/include/unicode/msgfmt.h
icu /usr/include/unicode/normalizer2.h
icu /usr/include/unicode/normlzr.h
icu /usr/include/unicode/nounit.h
icu /usr/include/unicode/numberformatter.h
icu /usr/include/unicode/numberrangeformatter.h
icu /usr/include/unicode/numfmt.h
icu /usr/include/unicode/numsys.h
icu /usr/include/unicode/parseerr.h
icu /usr/include/unicode/parsepos.h
icu /usr/include/unicode/platform.h
icu /usr/include/unicode/plurfmt.h
icu /usr/include/unicode/plurrule.h
icu /usr/include/unicode/ptypes.h
icu /usr/include/unicode/putil.h
icu /usr/include/unicode/rbbi.h
icu /usr/include/unicode/rbnf.h
icu /usr/include/unicode/rbtz.h
icu /usr/include/unicode/regex.h
icu /usr/include/unicode/region.h
icu /usr/include/unicode/reldatefmt.h
icu /usr/include/unicode/rep.h
icu /usr/include/unicode/resbund.h
icu /usr/include/unicode/schriter.h
icu /usr/include/unicode/scientificnumberformatter.h
icu /usr/include/unicode/search.h
icu /usr/include/unicode/selfmt.h
icu /usr/include/unicode/simpleformatter.h
icu /usr/include/unicode/simpletz.h
icu /usr/include/unicode/smpdtfmt.h
icu /usr/include/unicode/sortkey.h
icu /usr/include/unicode/std_string.h
icu /usr/include/unicode/strenum.h
icu /usr/include/unicode/stringoptions.h
icu /usr/include/unicode/stringpiece.h
icu /usr/include/unicode/stringtriebuilder.h
icu /usr/include/unicode/stsearch.h
icu /usr/include/unicode/symtable.h
icu /usr/include/unicode/tblcoll.h
icu /usr/include/unicode/timezone.h
icu /usr/include/unicode/tmunit.h
icu /usr/include/unicode/tmutamt.h
icu /usr/include/unicode/tmutfmt.h
icu /usr/include/unicode/translit.h
icu /usr/include/unicode/tzfmt.h
icu /usr/include/unicode/tznames.h
icu /usr/include/unicode/tzrule.h
icu /usr/include/unicode/tztrans.h
icu /usr/include/unicode/ubidi.h
icu /usr/include/unicode/ubiditransform.h
icu /usr/include/unicode/ubrk.h
icu /usr/include/unicode/ucal.h
icu /usr/include/unicode/ucasemap.h
icu /usr/include/unicode/ucat.h
icu /usr/include/unicode/uchar.h
icu /usr/include/unicode/ucharstrie.h
icu /usr/include/unicode/ucharstriebuilder.h
icu /usr/include/unicode/uchriter.h
icu /usr/include/unicode/uclean.h
icu /usr/include/unicode/ucnv.h
icu /usr/include/unicode/ucnv_cb.h
icu /usr/include/unicode/ucnv_err.h
icu /usr/include/unicode/ucnvsel.h
icu /usr/include/unicode/ucol.h
icu /usr/include/unicode/ucoleitr.h
icu /usr/include/unicode/uconfig.h
icu /usr/include/unicode/ucpmap.h
icu /usr/include/unicode/ucptrie.h
icu /usr/include/unicode/ucsdet.h
icu /usr/include/unicode/ucurr.h
icu /usr/include/unicode/udat.h
icu /usr/include/unicode/udata.h
icu /usr/include/unicode/udateintervalformat.h
icu /usr/include/unicode/udatpg.h
icu /usr/include/unicode/udisplaycontext.h
icu /usr/include/unicode/uenum.h
icu /usr/include/unicode/ufieldpositer.h
icu /usr/include/unicode/uformattable.h
icu /usr/include/unicode/uformattedvalue.h
icu /usr/include/unicode/ugender.h
icu /usr/include/unicode/uidna.h
icu /usr/include/unicode/uiter.h
icu /usr/include/unicode/uldnames.h
icu /usr/include/unicode/ulistformatter.h
icu /usr/include/unicode/uloc.h
icu /usr/include/unicode/ulocdata.h
icu /usr/include/unicode/umachine.h
icu /usr/include/unicode/umisc.h
icu /usr/include/unicode/umsg.h
icu /usr/include/unicode/umutablecptrie.h
icu /usr/include/unicode/unifilt.h
icu /usr/include/unicode/unifunct.h
icu /usr/include/unicode/unimatch.h
icu /usr/include/unicode/unirepl.h
icu /usr/include/unicode/uniset.h
icu /usr/include/unicode/unistr.h
icu /usr/include/unicode/unorm.h
icu /usr/include/unicode/unorm2.h
icu /usr/include/unicode/unum.h
icu /usr/include/unicode/unumberformatter.h
icu /usr/include/unicode/unumberrangeformatter.h
icu /usr/include/unicode/unumsys.h
icu /usr/include/unicode/uobject.h
icu /usr/include/unicode/upluralrules.h
icu /usr/include/unicode/uregex.h
icu /usr/include/unicode/uregion.h
icu /usr/include/unicode/ureldatefmt.h
icu /usr/include/unicode/urename.h
icu /usr/include/unicode/urep.h
icu /usr/include/unicode/ures.h
icu /usr/include/unicode/uscript.h
icu /usr/include/unicode/usearch.h
icu /usr/include/unicode/uset.h
icu /usr/include/unicode/usetiter.h
icu /usr/include/unicode/ushape.h
icu /usr/include/unicode/uspoof.h
icu /usr/include/unicode/usprep.h
icu /usr/include/unicode/ustdio.h
icu /usr/include/unicode/ustream.h
icu /usr/include/unicode/ustring.h
icu /usr/include/unicode/ustringtrie.h
icu /usr/include/unicode/utext.h
icu /usr/include/unicode/utf.h
icu /usr/include/unicode/utf16.h
icu /usr/include/unicode/utf32.h
icu /usr/include/unicode/utf8.h
icu /usr/include/unicode/utf_old.h
icu /usr/include/unicode/utmscale.h
icu /usr/include/unicode/utrace.h
icu /usr/include/unicode/utrans.h
icu /usr/include/unicode/utypes.h
icu /usr/include/unicode/uvernum.h
icu /usr/include/unicode/uversion.h
icu /usr/include/unicode/vtzone.h
icu /usr/lib/
icu /usr/lib/icu/
icu /usr/lib/icu/70.1/
icu /usr/lib/icu/70.1/Makefile.inc
icu /usr/lib/icu/70.1/pkgdata.inc
icu /usr/lib/icu/Makefile.inc
icu /usr/lib/icu/current
icu /usr/lib/icu/pkgdata.inc
icu /usr/lib/libicudata.so
icu /usr/lib/libicudata.so.70
icu /usr/lib/libicudata.so.70.1
icu /usr/lib/libicui18n.so
icu /usr/lib/libicui18n.so.70
icu /usr/lib/libicui18n.so.70.1
icu /usr/lib/libicuio.so
icu /usr/lib/libicuio.so.70
icu /usr/lib/libicuio.so.70.1
icu /usr/lib/libicutest.so
icu /usr/lib/libicutest.so.70
icu /usr/lib/libicutest.so.70.1
icu /usr/lib/libicutu.so
icu /usr/lib/libicutu.so.70
icu /usr/lib/libicutu.so.70.1
icu /usr/lib/libicuuc.so
icu /usr/lib/libicuuc.so.70
icu /usr/lib/libicuuc.so.70.1
icu /usr/lib/pkgconfig/
icu /usr/lib/pkgconfig/icu-i18n.pc
icu /usr/lib/pkgconfig/icu-io.pc
icu /usr/lib/pkgconfig/icu-uc.pc
icu /usr/share/
icu /usr/share/icu/
icu /usr/share/icu/70.1/
icu /usr/share/icu/70.1/LICENSE
icu /usr/share/icu/70.1/config/
icu /usr/share/icu/70.1/config/mh-linux
icu /usr/share/icu/70.1/install-sh
icu /usr/share/icu/70.1/mkinstalldirs
icu /usr/share/licenses/
icu /usr/share/licenses/icu/
icu /usr/share/licenses/icu/LICENSE
icu /usr/share/man/
icu /usr/share/man/man1/
icu /usr/share/man/man1/derb.1.gz
icu /usr/share/man/man1/genbrk.1.gz
icu /usr/share/man/man1/gencfu.1.gz
icu /usr/share/man/man1/gencnval.1.gz
icu /usr/share/man/man1/gendict.1.gz
icu /usr/share/man/man1/genrb.1.gz
icu /usr/share/man/man1/icu-config.1.gz
icu /usr/share/man/man1/icuexportdata.1.gz
icu /usr/share/man/man1/makeconv.1.gz
icu /usr/share/man/man1/pkgdata.1.gz
icu /usr/share/man/man1/uconv.1.gz
icu /usr/share/man/man8/
icu /usr/share/man/man8/genccode.8.gz
icu /usr/share/man/man8/gencmn.8.gz
icu /usr/share/man/man8/gensprep.8.gz
icu /usr/share/man/man8/icupkg.8.gz
karlb commented 2 years ago

The relevant build options are generated by pkg-config --cflags --libs icu-uc icu-i18n. It looks like the module has been successfully linked to libicui18n.so.70, but the library is either gone or not in the library search path when executing self.conn.load_extension. I don't see how that error can happen if the icu package is installed in version 70.1-1, which you showed above, since it contains /usr/lib/libicui18n.so.70 which is the right library in the right place. Is that file actually there and does it have the usual permissions? I assume it is, since the linking would have failed otherwise.

So I don't have a good explanation for this, unfortunately.

karlb commented 2 years ago

Why doesn't

pacman -Qi icu | grep Version
Version         : 71.1-1

include version 70.1-1? It says Install Date : Sat Jan 1 15:06:24 2022 for it in your later output?

bravebug commented 2 years ago

I have several hardware. On one of them, the 'icu' package has already been updated to version 71, on the other not yet. I have provided lists of files for different versions.

bravebug commented 2 years ago

I will try to rebuild the binary later

bravebug commented 2 years ago

I will try to rebuild the binary later

Works well after rebuilding the binary file.

Created PKGBUILD in AUR: https://aur.archlinux.org/packages/python-sqlite-icu-git

karlb commented 2 years ago

Nice to have it on AUR!

I'll close this issue, since it might not be a problem with the package itself and I don't see anything actionable.