search

spack / spack

A flexible package manager that supports multiple versions, configurations, platforms, and compilers.
https://spack.io
Other
4.23k stars 2.25k forks source link

Installation issue: `sqlite@3.46.0 platform=windows` #46241

Open johnwparent opened 3 weeks ago

johnwparent commented 3 weeks ago

Steps to reproduce the issue

This issue was spun off https://github.com/spack/spack/issues/46070 (originally filed by @gongwaner) to track the Sqlite failure observed in confirming that particular issue was resolved.

[spack] D:\Library\spack>spack install vtk@9.3.1
...

Error message

Error message 
**********************************************************************
** Spack Package Manager
**********************************************************************
[spack] D:\Library\spack>spack install vtk@9.3.1
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\zlib-ng-2.2.1-bvw7i2nkluxa6ctot57pq32632m2zfos
[+] C:\Program Files\CMake (external cmake-3.30.0-2upzicgnwcozckggewejmh3phoyr3gpo)
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\bzip2-1.0.8-lyg7akgxp4rdc3luesvyqmhtd6albmbc
[+] C:\Program Files (x86)\Windows Kits\10 (external wgl-10.0.22621-qtifbhjawy3xumwsxuw7fynfqp5vim4i)
[+] C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\Ninja (external ninja-1.11.0-nlbkgux5y5vdhqiey4hi4cdj6rvtyxs6)
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\xz-5.4.6-oamcjhzhycx6zjkhfug3xn2lfnmvudkw
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\utf8cpp-2.3.4-tbggxmfbqdqirvqyggsweqseosffgktd
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\tcl-8.6.12-hyk2hnzlwsbjtp2ol2jaliwcxnktrvxb
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\jsoncpp-1.9.5-bpa3ldtlvsu434mj73qpl724ozghovhu
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\hdf5-1.14.3-cokcthjb4jmw2ixcro7exrx66eoewsc5
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\glew-2.2.0-jmuhtwbxromkzdqyb3j3ujyopuqgnidz
==> Installing zstd-1.5.5-j5qx52wpyv4prp3wfkicvm4ogbynk2fv [12/36]
==> No binary for zstd-1.5.5-j5qx52wpyv4prp3wfkicvm4ogbynk2fv found: installing from source
==> Using cached archive: D:\Library\spack\var\spack\cache\_source-cache\archive\98\98e9c3d949d1b924e28e01eccb7deed865eefebf25c2f21c702e5cd5b63b85e1.tar.gz
zstd-1.5.5/tests/cli-tests/bin/unzstd: Can't create '\\\\?\\D:\\Library\\spack\\.staging\\zstd-1.5.5-j5qx52w\\spack-expanded-archive\\zstd-1.5.5\\tests\\cli-tests\\bin\\unzstd'
zstd-1.5.5/tests/cli-tests/bin/zstdcat: Can't create '\\\\?\\D:\\Library\\spack\\.staging\\zstd-1.5.5-j5qx52w\\spack-expanded-archive\\zstd-1.5.5\\tests\\cli-tests\\bin\\zstdcat'
tar.exe: Error exit delayed from previous errors.
==> Error: ProcessError: Command exited with status 1:
    'C:\Windows\system32\tar.exe' '-oxf' 'D:\Library\spack\.staging\zstd-1.5.5-j5qx52w\spack-expanded-archive\v1.5.5.tar'
==> Warning: Skipping build of c-blosc-1.21.5-4p3tntv2msec2po2n45lzv3znnotnl6w since zstd-1.5.5-j5qx52wpyv4prp3wfkicvm4ogbynk2fv failed
==> Warning: Skipping build of netcdf-c-4.9.2-ome763a2bmcy2dch56hvunqm66podawz since c-blosc-1.21.5-4p3tntv2msec2po2n45lzv3znnotnl6w failed
==> Warning: Skipping build of seacas-2022-10-14-nv2ah7ihbqhgdqlsu5yvk4lomgdbwog5 since netcdf-c-4.9.2-ome763a2bmcy2dch56hvunqm66podawz failed
==> Warning: Skipping build of vtk-9.3.1-xq2if4m4qlr3m42wdja3gi2wglxmwowx since seacas-2022-10-14-nv2ah7ihbqhgdqlsu5yvk4lomgdbwog5 failed
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\lz4-1.9.4-bcc6tzirayevlld52ribvy2ekkpadyiu
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libaec-1.0.6-jaj2xw55ypw7wqvqmy4omeou6tudxtpz
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\double-conversion-3.3.0-noudmvfepmsn4j5r766dgfezxuvmuoug
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libogg-1.3.5-wfx3btmp74n2zs4kf3vcokueiiowevvd
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\eigen-3.4.0-jswe2byms6jwuny7bcflsf4dyecyuftv
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\snappy-1.1.10-wzkyv4anranqxutalyij52qw3wkzp5eo
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libjpeg-turbo-3.0.3-ht3m3fhjfnw7xcxx67fp4cngl5ij23mi
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\nlohmann-json-3.11.3-vjccd4xws67hgrrdlykvsuzqib3f573f
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\pugixml-1.14-6wgbzctjwrynamt64yb6ghan3xtfhslq
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\expat-2.6.2-z6jcoufluj55tnhid74rbvhqagxexhh2
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\fmt-9.1.0-w2bafpknhbeeohcvrze2i2rsn3avhbfh
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libpng-1.6.39-54r7omsx73aagra4e3hdpd2p6uapcqej
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libxml2-2.10.3-fat2nyh55ytnjcrbmj7ja3nz6i4dlscp
==> Installing sqlite-3.46.0-xzbhutrk5cauonc5gtreeju6g366trsz [26/36]
==> No binary for sqlite-3.46.0-xzbhutrk5cauonc5gtreeju6g366trsz found: installing from source
==> Using cached archive: D:\Library\spack\var\spack\cache\_source-cache\archive\6f\6f8e6a7b335273748816f9b3b62bbdc372a889de8782d7f048c653a447417a7d.tar.gz
==> Using cached archive: D:\Library\spack\var\spack\cache\_source-cache\archive\99\991b40fe8b2799edc215f7260b890f14a833512c9d9896aa080891330ffe4052
==> Moving resource stage
        source: D:\Library\spack\.staging\resource-extension-functions-xzbhutrk5cauonc5gtreeju6g366trsz\spack-src\extension-functions.c?get=25
        destination: D:\Library\spack\.staging\sqlite-3.46.0-xzbhutr\spack-src\extension-functions.c
==> Applied patch D:\Library\spack\var\spack\repos\builtin\packages\sqlite\quote_compiler_in_makefile.patch
==> Error: ProcessError: Command exited with status 2:
    'nmake' '/NOLOGO' 'USE_NATIVE_LIBPATHS=1' 'DYNAMIC_SHELL=1' 'OPTS=-DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION=1 -DSQLITE_ENABLE_PREUPDATE_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS=1' '/FMakefile.msc'

8 errors found in build log:
     15         link.exe /DEBUG  /NOLOGO /MACHINE:x64  /DLL  /OUT:sqlite3.dll sqlit
           e3.lo sqlite3res.lo
     16       Creating library sqlite3.lib and object sqlite3.exp
     17         "C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\M
           SVC\14.41.34120\bin\Hostx64\x64\cl.exe" -nologo -W4 -DINCLUDE_MSVC_H
           =1   -DSQLITE_OS_WIN=1 -I. -I. -fp:precise -MT -DNDEBUG -D_CRT_SECUR
           E_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE
            -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OV
           ERRIDE_LOCK=-1 -DSQLITE_TEMP_STORE=1  -DSQLITE_MAX_TRIGGER_DEPTH=100
             -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTRE
           E=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_STMTVTAB=1 -DSQLITE_EN
           ABLE_DBPAGE_VTAB=1 -DSQLITE_ENABLE_DBSTAT_VTAB=1 -DSQLITE_ENABLE_BYT
           ECODE_VTAB=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_MATH_
           FUNCTIONS  -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_EN
           ABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE
           _ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION=1 -DSQLITE_ENABLE_PREUPDAT
           E_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS=
           1 -O2 -Zi -Fesqlite3.exe  -DSQLITE_API=__declspec(dllimport) -DHAVE_
           READLINE=0 shell.c   /link /pdb:sqlite3sh.pdb /DEBUG  /NOLOGO /MACHI
           NE:x64 sqlite3.lib  sqlite3res.lo
     18    shell.c
     19    shell.c(1): warning C4819: The file contains a character that cannot
            be represented in the current code page (936). Save the file in Uni
           code format to prevent data loss
     20    shell.c(27262): warning C4819: The file contains a character that ca
           nnot be represented in the current code page (936). Save the file in
            Unicode format to prevent data loss
  >> 21    shell.c(27705): error C2001: newline in constant
  >> 22    shell.c(27706): error C2143: syntax error: missing ';' before 'const
           '
  >> 23    shell.c(27720): error C2065: 'zBom': undeclared identifier
     24    shell.c(27720): warning C4047: '=': 'int' differs in levels of indir
           ection from 'const char *'
  >> 25    shell.c(27787): error C2065: 'zBom': undeclared identifier
  >> 26    shell.c(27787): error C2065: 'zBom': undeclared identifier
     27    shell.c(27787): warning C4047: 'function': 'const char *' differs in
            levels of indirection from 'int'
     28    shell.c(27787): warning C4024: 'oPutsUtf8': different types for form
           al and actual parameter 1
  >> 29    shell.c(27800): error C2065: 'zBom': undeclared identifier
  >> 30    shell.c(27800): error C2065: 'zBom': undeclared identifier
     31    shell.c(27800): warning C4047: 'function': 'const char *' differs in
            levels of indirection from 'int'
     32    shell.c(27800): warning C4024: 'oPutsUtf8': different types for form
           al and actual parameter 1
  >> 33    NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studi
           o\2022\Community\VC\Tools\MSVC\14.41.34120\bin\Hostx64\x64\cl.exe" -
           nologo -W4 -DINCLUDE_MSVC_H=1   -DSQLITE_OS_WIN=1 -I. -I. -fp:precis
           e -MT -DNDEBUG -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS
           -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_THRE
           ADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_TEMP_STORE=1  -DS
           QLITE_MAX_TRIGGER_DEPTH=100  -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_
           FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_EN
           ABLE_STMTVTAB=1 -DSQLITE_ENABLE_DBPAGE_VTAB=1 -DSQLITE_ENABLE_DBSTAT
           _VTAB=1 -DSQLITE_ENABLE_BYTECODE_VTAB=1 -DSQLITE_ENABLE_COLUMN_METAD
           ATA=1 -DSQLITE_ENABLE_MATH_FUNCTIONS  -DSQLITE_ENABLE_FTS3=1 -DSQLIT
           E_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQL
           ITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION
           =1 -DSQLITE_ENABLE_PREUPDATE_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQ
           LITE_ENABLE_MATH_FUNCTIONS=1 -O2 -Zi -Fesqlite3.exe  -DSQLITE_API=__
           declspec(dllimport) -DHAVE_READLINE=0 shell.c   /link /pdb:sqlite3sh
           .pdb /DEBUG  /NOLOGO /MACHINE:x64 sqlite3.lib  sqlite3res.lo   ' : r
           eturn code '0x2'
     34    Stop.

See build log for details:
  D:\Library\spack\.staging\sqlite-3.46.0-xzbhutr\spack-build-out.txt

==> Warning: Skipping build of proj-9.4.1-fw2rkg5vmzlvv3yzidezphaal24myxif since sqlite-3.46.0-xzbhutrk5cauonc5gtreeju6g366trsz failed
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\cgns-4.4.0-i4c5hfphhg44mzstlq5xmcepqvvod7gz
==> Installing libtiff-4.6.0-bz74muvct5zl5a6wet6t5vpo5sn2nksy [28/36]
==> No binary for libtiff-4.6.0-bz74muvct5zl5a6wet6t5vpo5sn2nksy found: installing from source
==> Fetching https://download.osgeo.org/libtiff/tiff-4.6.0.tar.gz
==> Ran patch() for libtiff
==> libtiff: Successfully installed libtiff-4.6.0-bz74muvct5zl5a6wet6t5vpo5sn2nksy
  Stage: 3.78s.  Cmake: 13.00s.  Build: 5.50s.  Install: 0.44s.  Post-install: 0.62s.  Total: 23.48s
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libtiff-4.6.0-bz74muvct5zl5a6wet6t5vpo5sn2nksy
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\gl2ps-1.4.2-dom264wj5ixlqzqljf4nyxpyo7f45grm
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\freetype-2.13.2-q5neke2omqwqrx3ydqgfpk3zgqyk6356
[+] D:\Library\spack\opt\spack\windows-windows10.0.19045-skylake\msvc-19.41.34120\libtheora-1.1.1-hhbay7u7aoxrwyqubocg3alzlo6f6qle
==> Error: vtk-9.3.1-xq2if4m4qlr3m42wdja3gi2wglxmwowx: Package was not installed
==> Error: Installation request failed.  Refer to reported errors for failing package(s).

Information on your system

Additional information

cc @gongwaner

General information

gongwaner commented 5 days ago

hi I just updated to the latest commit(https://github.com/spack/spack/commit/2778e530ad711e86411cb61db4417a2b74858664) and tried to install VTK9.3.1 and the issue still persists.

==> Installing sqlite-3.46.0-xzbhutrk5cauonc5gtreeju6g366trsz [26/36]
==> No binary for sqlite-3.46.0-xzbhutrk5cauonc5gtreeju6g366trsz found: installing from source
==> Using cached archive: D:\Library\spack\var\spack\cache\_source-cache\archive\6f\6f8e6a7b335273748816f9b3b62bbdc372a889de8782d7f048c653a447417a7d.tar.gz
==> Using cached archive: D:\Library\spack\var\spack\cache\_source-cache\archive\99\991b40fe8b2799edc215f7260b890f14a833512c9d9896aa080891330ffe4052
==> Moving resource stage
        source: D:\Library\spack\.staging\resource-extension-functions-xzbhutrk5cauonc5gtreeju6g366trsz\spack-src\extension-functions.c?get=25
        destination: D:\Library\spack\.staging\sqlite-3.46.0-xzbhutr\spack-src\extension-functions.c
==> Applied patch D:\Library\spack\var\spack\repos\builtin\packages\sqlite\quote_compiler_in_makefile.patch
==> Error: ProcessError: Command exited with status 2:
    'nmake' '/NOLOGO' 'USE_NATIVE_LIBPATHS=1' 'DYNAMIC_SHELL=1' 'OPTS=-DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION=1 -DSQLITE_ENABLE_PREUPDATE_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS=1' '/FMakefile.msc'

8 errors found in build log:
     15         link.exe /DEBUG  /NOLOGO /MACHINE:x64  /DLL  /OUT:sqlite3.dll sqlit
           e3.lo sqlite3res.lo
     16       Creating library sqlite3.lib and object sqlite3.exp
     17         "C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\M
           SVC\14.41.34120\bin\Hostx64\x64\cl.exe" -nologo -W4 -DINCLUDE_MSVC_H
           =1   -DSQLITE_OS_WIN=1 -I. -I. -fp:precise -MT -DNDEBUG -D_CRT_SECUR
           E_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE
            -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OV
           ERRIDE_LOCK=-1 -DSQLITE_TEMP_STORE=1  -DSQLITE_MAX_TRIGGER_DEPTH=100
             -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTRE
           E=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_STMTVTAB=1 -DSQLITE_EN
           ABLE_DBPAGE_VTAB=1 -DSQLITE_ENABLE_DBSTAT_VTAB=1 -DSQLITE_ENABLE_BYT
           ECODE_VTAB=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_MATH_
           FUNCTIONS  -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_EN
           ABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE
           _ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION=1 -DSQLITE_ENABLE_PREUPDAT
           E_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS=
           1 -O2 -Zi -Fesqlite3.exe  -DSQLITE_API=__declspec(dllimport) -DHAVE_
           READLINE=0 shell.c   /link /pdb:sqlite3sh.pdb /DEBUG  /NOLOGO /MACHI
           NE:x64 sqlite3.lib  sqlite3res.lo
     18    shell.c
     19    shell.c(1): warning C4819: The file contains a character that cannot
            be represented in the current code page (936). Save the file in Uni
           code format to prevent data loss
     20    shell.c(27262): warning C4819: The file contains a character that ca
           nnot be represented in the current code page (936). Save the file in
            Unicode format to prevent data loss
  >> 21    shell.c(27705): error C2001: newline in constant
  >> 22    shell.c(27706): error C2143: syntax error: missing ';' before 'const
           '
  >> 23    shell.c(27720): error C2065: 'zBom': undeclared identifier
     24    shell.c(27720): warning C4047: '=': 'int' differs in levels of indir
           ection from 'const char *'
  >> 25    shell.c(27787): error C2065: 'zBom': undeclared identifier
  >> 26    shell.c(27787): error C2065: 'zBom': undeclared identifier
     27    shell.c(27787): warning C4047: 'function': 'const char *' differs in
            levels of indirection from 'int'
     28    shell.c(27787): warning C4024: 'oPutsUtf8': different types for form
           al and actual parameter 1
  >> 29    shell.c(27800): error C2065: 'zBom': undeclared identifier
  >> 30    shell.c(27800): error C2065: 'zBom': undeclared identifier
     31    shell.c(27800): warning C4047: 'function': 'const char *' differs in
            levels of indirection from 'int'
     32    shell.c(27800): warning C4024: 'oPutsUtf8': different types for form
           al and actual parameter 1
  >> 33    NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studi
           o\2022\Community\VC\Tools\MSVC\14.41.34120\bin\Hostx64\x64\cl.exe" -
           nologo -W4 -DINCLUDE_MSVC_H=1   -DSQLITE_OS_WIN=1 -I. -I. -fp:precis
           e -MT -DNDEBUG -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS
           -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_THRE
           ADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_TEMP_STORE=1  -DS
           QLITE_MAX_TRIGGER_DEPTH=100  -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_
           FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_EN
           ABLE_STMTVTAB=1 -DSQLITE_ENABLE_DBPAGE_VTAB=1 -DSQLITE_ENABLE_DBSTAT
           _VTAB=1 -DSQLITE_ENABLE_BYTECODE_VTAB=1 -DSQLITE_ENABLE_COLUMN_METAD
           ATA=1 -DSQLITE_ENABLE_MATH_FUNCTIONS  -DSQLITE_ENABLE_FTS3=1 -DSQLIT
           E_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_RTREE=1 -DSQL
           ITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_SESSION
           =1 -DSQLITE_ENABLE_PREUPDATE_HOOK=1 -DSQLITE_ENABLE_SERIALIZE=1 -DSQ
           LITE_ENABLE_MATH_FUNCTIONS=1 -O2 -Zi -Fesqlite3.exe  -DSQLITE_API=__
           declspec(dllimport) -DHAVE_READLINE=0 shell.c   /link /pdb:sqlite3sh
           .pdb /DEBUG  /NOLOGO /MACHINE:x64 sqlite3.lib  sqlite3res.lo   ' : r
           eturn code '0x2'
     34    Stop.

See build log for details:
  D:\Library\spack\.staging\sqlite-3.46.0-xzbhutr\spack-build-out.txt

I wonder if the build log could be of any help. Here's the file D:\Library\spack.staging\sqlite-3.46.0-xzbhutr\spack-build-out.txt

spack-build-out.txt

johnwparent commented 3 days ago

Thanks @gongwaner, I've been attempting to replicate this behavior locally to no avail, so the build output from your side is much appreciated!

johnwparent commented 3 days ago

@gongwaner So I am still unable to replicate your failure for some reason, but I do see the bizarre characters that are causing these failures for you when I checkout the sqlite sources.

I have some potential fixes in mind, but if possible would you be able to provide:

Your version of Visual Studio: Your version of MSVC: Any locales you have enabled on your system:

That said, I also don't see the -DUNICODE -D_UNICODE definitions I should be in that failed compile line, so that may be the issue.

gongwaner commented 2 days ago

hi @johnwparent glad it helped. I think the problem is most probably caused by locales as you've suspected. I checked the system locale by going to control panel->Clock and Region->Region. The format is English(United States), however, on administrative tab, I can see the "Current language for non-Unicode programs" is set as Chinese(Simplified, China). For some reason, I can't change the system locale at the moment, so I tried with a different pc to see if this issue was caused by locale. The second pc's Format is set as English(Canada) and current language for non-Unicode programs is set as English(United States). This time, sqlite is installed without any errors. Here's the full log.

[spack] C:\Users\gongwaner\Projects\Library\spack>spack install vtk@9.3.1
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\zlib-ng-2.2.1-tkdxytagkd3cqvjpcwf5ip26zupjyb6g
[+] C:\Program Files\CMake (external cmake-3.30.2-7a2dpykatbel3fgmqdkyu3zxqftgdmhy)
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\double-conversion-3.3.0-ejclo5f6ead7sj6v43j6bisqvpl4p57z
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\eigen-3.4.0-alkxaqtd4mnbiqqllbonubnilyrcj65p
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\expat-2.6.2-m77qw4gp44z3p5uanzwiqqrubkj3o5eg
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\bzip2-1.0.8-dworrho4bc75pi3p5pkfxnbeg6mmdgw3
[+] C:\Program Files (x86)\Windows Kits\10 (external wgl-10.0.20348-47boelevi4hqbjkiammydw3q7ytatru6)
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\jsoncpp-1.9.5-ja7bnnhkcpvzektbqjfyqull6ig32hai
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libjpeg-turbo-3.0.3-lfht3xibgxw7kwcadc3pz7zoim2kp4fu
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libogg-1.3.5-2clzykjplg5ofy77mbsi7f4lgwhhhtai
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\xz-5.4.6-bwth7p5k4ol6ujeayugutc2brh52sgye
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\lz4-1.9.4-hqjzthzkv4xdbxqie6p6dghhyjgr2rdb
[+] C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\Ninja (external ninja-1.11.0-t6a7uaannhbub2tt7cfzuv7pprmpz56k)
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\snappy-1.1.10-w5b4ws4myc373nivg4adkh7rfaodiwp7
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libaec-1.0.6-hyv6zvkusbnhrv3qwesks2huarwaaqk5
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\nlohmann-json-3.11.3-rctxc34vbpbhfgy643p3sydx6g6shibh
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\pugixml-1.14-4sc74rwwlovyhdgfhom2bw7suub3r4wr
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\fmt-9.1.0-qxye3at2caq5l6rrgyp2gfk5gqzhf2tj
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\utf8cpp-2.3.4-wp7phulbt7kd4kgcqncnb2utxydoqxrr
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\tcl-8.6.12-53qjix6agpngf32e3z4cou3ivzkrmolw
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\hdf5-1.14.3-iqewerlswnqxd6tnwbq5g6efqkisu6tx
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libpng-1.6.39-x6upqqewfafqrcrkoq7luds5orgxbxz5
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libtiff-4.6.0-5pqvpi65kbffrfjxnd4xlknt6jrwiy5l
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libxml2-2.10.3-jurv4qyztdy6pnsglbwlphdjrilzn6zy
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\glew-2.2.0-3p72ymgpxwctq24eptzjwh7jokla3uar
==> Installing zstd-1.5.5-okpgmu2dn3jb3pscucq3e5slde253knz [26/36]
==> No binary for zstd-1.5.5-okpgmu2dn3jb3pscucq3e5slde253knz found: installing from source
==> Using cached archive: C:\Users\gongwaner\Projects\Library\spack\var\spack\cache\_source-cache\archive\98\98e9c3d949d1b924e28e01eccb7deed865eefebf25c2f21c702e5cd5b63b85e1.tar.gz
==> No patches needed for zstd
==> zstd: Successfully installed zstd-1.5.5-okpgmu2dn3jb3pscucq3e5slde253knz
  Stage: 0.80s.  Cmake: 9.39s.  Build: 11.08s.  Install: 0.39s.  Post-install: 0.26s.  Total: 22.57s
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\zstd-1.5.5-okpgmu2dn3jb3pscucq3e5slde253knz
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\sqlite-3.46.0-afk7wveq2jy43tkp4ks6rmhjnwpfspg3
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\cgns-4.4.0-jnejr67pcsd73oxypdexcgx47tms4mmj
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\gl2ps-1.4.2-5ady4khd6m2rfkpv2se6wa35o5l3323k
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\freetype-2.13.2-2r6qmqdbdg36mmdr2qutncgnc763ysrd
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\libtheora-1.1.1-ckjfzz6gerhbjdanzknkojzatbj3wpk6
==> Installing c-blosc-1.21.5-2bjj7djzeqjpvb7tnmapdloxini4t2da [32/36]
==> No binary for c-blosc-1.21.5-2bjj7djzeqjpvb7tnmapdloxini4t2da found: installing from source
==> Fetching https://github.com/Blosc/c-blosc/archive/v1.21.5.tar.gz
==> No patches needed for c-blosc
==> c-blosc: Successfully installed c-blosc-1.21.5-2bjj7djzeqjpvb7tnmapdloxini4t2da
  Stage: 10.22s.  Cmake: 5.28s.  Build: 1.69s.  Install: 0.38s.  Post-install: 0.43s.  Total: 18.35s
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\c-blosc-1.21.5-2bjj7djzeqjpvb7tnmapdloxini4t2da
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\proj-9.4.1-wloh343sqe2fx24t7nw2so5jhnrihavk
==> Installing netcdf-c-4.9.2-c7irqf2nh3s5zxunue4lmyizxbrfsgik [34/36]
==> No binary for netcdf-c-4.9.2-c7irqf2nh3s5zxunue4lmyizxbrfsgik found: installing from source
==> Fetching https://github.com/Unidata/netcdf-c/archive/refs/tags/v4.9.2.tar.gz
==> Fetching https://github.com/Unidata/netcdf-c/commit/f8904d5a1d89420dde0f9d2c0e051ba08d08e086.patch?full_index=1
==> Applied patch C:\Users\gongwaner\Projects\Library\spack\var\spack\repos\builtin\packages\netcdf-c\4.8.1-win-hdf5-with-zlib.patch
==> Applied patch C:\Users\gongwaner\Projects\Library\spack\var\spack\repos\builtin\packages\netcdf-c\netcdfc_correct_and_export_link_interface.patch
==> Applied patch https://github.com/Unidata/netcdf-c/commit/f8904d5a1d89420dde0f9d2c0e051ba08d08e086.patch?full_index=1
==> netcdf-c: Successfully installed netcdf-c-4.9.2-c7irqf2nh3s5zxunue4lmyizxbrfsgik
  Stage: 12.61s.  Cmake: 1m 44.41s.  Build: 41.59s.  Install: 1.38s.  Post-install: 1.03s.  Total: 2m 41.56s
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\netcdf-c-4.9.2-c7irqf2nh3s5zxunue4lmyizxbrfsgik
==> Installing seacas-2022-10-14-2csuk4gcl46xs42hh6zhhyn7xzv4o57j [35/36]
==> No binary for seacas-2022-10-14-2csuk4gcl46xs42hh6zhhyn7xzv4o57j found: installing from source
==> Fetching https://github.com/sandialabs/seacas/archive/v2022-10-14.tar.gz
==> Fetching https://github.com/sandialabs/seacas/commit/29a9ebeccb5a656b4b334fa6af904689da9ffddc.diff?full_index=1
==> Applied patch https://github.com/sandialabs/seacas/commit/29a9ebeccb5a656b4b334fa6af904689da9ffddc.diff?full_index=1
==> seacas: Successfully installed seacas-2022-10-14-2csuk4gcl46xs42hh6zhhyn7xzv4o57j
  Stage: 21.75s.  Cmake: 1m 8.09s.  Build: 4m 29.33s.  Install: 9.00s.  Post-install: 5.10s.  Total: 6m 13.93s
[+] C:\Users\gongwaner\Projects\Library\spack\opt\spack\windows-windows10.0.19045-x86_64_v3\msvc-19.41.34120\seacas-2022-10-14-2csuk4gcl46xs42hh6zhhyn7xzv4o57j
==> Installing vtk-9.3.1-dthkmcgyn74puwgtetxbvjp3hxtwer63 [36/36]
==> No binary for vtk-9.3.1-dthkmcgyn74puwgtetxbvjp3hxtwer63 found: installing from source
==> Fetching http://www.vtk.org/files/release/9.3/VTK-9.3.1.tar.gz
==> Applied patch C:\Users\gongwaner\Projects\Library\spack\var\spack\repos\builtin\packages\vtk\vtk_proj_include_no_strict.patch
==> Applied patch C:\Users\gongwaner\Projects\Library\spack\var\spack\repos\builtin\packages\vtk\vtk_findproj_config.patch
==> Applied patch C:\Users\gongwaner\Projects\Library\spack\var\spack\repos\builtin\packages\vtk\vtk_alias_hdf5.patch
==> Ran patch() for vtk

The steps for installation on 2 computers are exactly the same(and both ran as administrator), so it looks like the problem is caused by locales.

Regards