<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Hi again,<div><br></div><div>I have now resolved this issue by rebuilding SQLite with the <span style="font-family: "Helvetica Neue"; font-size: 13px;">SQLITE_OMIT_PROGRESS_CALLBACK=OFF</span></div><div><font face="Helvetica Neue" size="2"><br></font></div><div><font face="Helvetica Neue" size="2">GDAL 3.6.0 will now build successfully with my updated buiild of SQLite.</font></div><div><font face="Helvetica Neue" size="2"><br></font></div><div><font face="Helvetica Neue" size="2">Sorry to have troubled you with this one.</font></div><div><font face="Helvetica Neue" size="2"><br></font></div><div>NB: This may still be worth pursuing within GDAL, since SQLite explicitly recommend building with this omitted, as per: <a href="https://www.sqlite.org/compile.html">https://www.sqlite.org/compile.html</a></div><div><br></div><div><font face="Helvetica Neue" size="2" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);">If you still wished to pursue a GDAL fix for possibility of missing </font><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);">sqlite3_progress_handler, then it’s worth noting that it’s not an iOS issue, as far as I know, since I was not using iOS default SQLite.</span></div><div><font face="Helvetica Neue" size="2"><br></font></div><div><font face="Helvetica Neue" size="2">Cheers,</font></div><div><font face="Helvetica Neue" size="2">Nik.</font></div><div><font face="Helvetica Neue" size="2"><br></font><div><br><blockquote type="cite"><div>On 12 Nov 2022, at 1:51 pm, Nik Sands <nik@nixanz.com> wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Hi Even,<div><br></div><div>Sorry, I should have mentioned that I’m not using the standard iOS/macOS SQLite (because it does not include <span style="font-family: "Helvetica Neue"; font-size: 13px;">RTREE extension which seems to be required for GDAL</span>).<br><div><br></div><div>I’m using a CMAKE compatible SQLite from: <a href="https://github.com/azadkuh/sqlite-amalgamation">https://github.com/azadkuh/sqlite-amalgamation</a> (which was working fine with GDAL 3.5.2)</div><div><br></div><div>I tried building SQLite with:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="font-family: "Helvetica Neue"; font-size: 13px; white-space: pre;"> </span><span style="font-family: "Helvetica Neue"; font-size: 13px;">-DSQLITE_OMIT_PROGRESS_CALLBACK=OFF</span></div><div><font face="Helvetica Neue" size="2">but it logged that it was ignoring this (not sure why, when it works OK when I specify other options similarly, such as </font><span style="font-family: "Helvetica Neue"; font-size: 13px;">-DSQLITE_OMIT_DECLTYPE=OFF</span><span style="font-family: "Helvetica Neue"; font-size: small;">)</span></div><div><br></div><div>Anyhow…</div><div><br></div><div>The patch build of GDAL did not resolve the problem, although the output is slightly different. I still got this error (re-pasted from current build, below).</div><div><br></div><div>I’m also trying to figure out how to get <span style="caret-color: rgb(0, 0, 0); font-family: "Helvetica Neue"; font-size: 13px;">SQLITE_OMIT_PROGRESS_CALLBACK disabled in my SQLite build, which may be a better way to go? Got to figure out the right CMakeLists.txt changes (in SQLite) for this.</span></div><div><br></div><div>Cheers,</div><div>Nik.</div><div><br></div><div><br></div><div><div>Consolidate compiler generated dependencies of target gdal_unit_test</div><div>[ 94%] Linking CXX executable gdal_unit_test.app/gdal_unit_test</div><div>Undefined symbols for architecture arm64:</div><div> "_sqlite3_progress_handler", referenced from:</div><div> OGRGeoPackageTableLayer::GetGeometryTypes(int, int, int&, int (*)(double, char const*, void*), void*) in libgdal.a(ogrgeopackagetablelayer.cpp.o)</div><div>ld: symbol(s) not found for architecture arm64</div><div>clang: error: linker command failed with exit code 1 (use -v to see invocation)</div><div>make[2]: *** [autotest/cpp/gdal_unit_test.app/gdal_unit_test] Error 1</div><div>make[1]: *** [autotest/cpp/CMakeFiles/gdal_unit_test.dir/all] Error 2</div><div>make: *** [all] Error 2</div></div><div><br><div><br><blockquote type="cite"><div>On 12 Nov 2022, at 12:45 pm, Even Rouault <even.rouault@spatialys.com> wrote:</div><br class="Apple-interchange-newline"><div><div>Weird. So it would seem the SQLite3 build on iOS lacks sqlite3_progress_handler()<br><br>As this is not critical for operations, I've added a CMake configure check for the presence of this function to conditionally enable it.<br><br>Can you try https://github.com/OSGeo/gdal/pull/6675 ?<br><br>Even<br><br>Le 12/11/2022 à 02:32, Nik Sands a écrit :<br><blockquote type="cite">After patching GDAL 3.6.0 for ‘pread64’ issue when building for iOS (see previous email), the build now progresses to the 100% mark, but then fails with the _sqlite3_progress_handler error below.<br><br>I’m afraid that I don’t even know where to start with this one. How should I proceed?<br><br>Cheers,<br>Nik.<br><br><br><br>[100%] Built target check_swq_parser_md5<br>Consolidate compiler generated dependencies of target my_test_sqlite3_ext<br>[100%] Built target my_test_sqlite3_ext<br>[100%] Built target check_ods_formula_parser_md5<br>Consolidate compiler generated dependencies of target test_gdal_fuzzer<br>[100%] Linking CXX executable test_gdal_fuzzer.app/test_gdal_fuzzer<br>Undefined symbols for architecture arm64:<br> "_sqlite3_progress_handler", referenced from:<br> OGRGeoPackageTableLayer::GetGeometryTypes(int, int, int&, int (*)(double, char const*, void*), void*) in libgdal.a(ogrgeopackagetablelayer.cpp.o)<br>ld: symbol(s) not found for architecture arm64<br>clang: error: linker command failed with exit code 1 (use -v to see invocation)<br>make[2]: *** [fuzzers/tests/test_gdal_fuzzer.app/test_gdal_fuzzer] Error 1<br>make[1]: *** [fuzzers/tests/CMakeFiles/test_gdal_fuzzer.dir/all] Error 2<br>make: *** [all] Error 2<br>_______________________________________________<br>gdal-dev mailing list<br>gdal-dev@lists.osgeo.org<br>https://lists.osgeo.org/mailman/listinfo/gdal-dev<br></blockquote><br>-- <br>http://www.spatialys.com<br>My software is free, but my time generally not.<br><br>_______________________________________________<br>gdal-dev mailing list<br>gdal-dev@lists.osgeo.org<br>https://lists.osgeo.org/mailman/listinfo/gdal-dev<br></div></div></blockquote></div><br><div>
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-caps: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br class="Apple-interchange-newline">========================================================</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-caps: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;">NIK SANDS</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-caps: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;">Line Tamer | Time Traveller | Space Cadet</div></div></div></div></div></div>
</div>
<br></div></div></div>_______________________________________________<br>gdal-dev mailing list<br>gdal-dev@lists.osgeo.org<br>https://lists.osgeo.org/mailman/listinfo/gdal-dev<br></div></blockquote></div><br><div>
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br class="Apple-interchange-newline">========================================================</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;">NIK SANDS</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;">Line Tamer | Time Traveller | Space Cadet</div></div></div></div></div></div>
</div>
<br></div></body></html>