Yes looks like that "." folder is correctly detected to not have access and sqlite returns "error: SQLITE_IOERR: disk I/O error" which confirms the fix
but still is there a preffered way how to set directory for those transition files , should we use env "SQLITE_TMPDIR" or is there a better way? kr Martin D?a 22.04.2016 o 15:22 Richard Hipp nap?sal(a): > On 4/22/16, Martin Trnovec <martin.trnovec at pipelinersales.com> wrote: >> It seems that the problem is/was that the application can't create >> transient files in the "." directory returned by >> os_unix.c::unixTempFileDir due to Android os file restrictions. > Does the fix at https://www.sqlite.org/src/info/67985761aa93fb61 help? > >> It also >> looks like that this function is not able to correctly check if the >> folder is writable for transient files , there are some check but all >> off them passed. Setting the correct temp directory helped but >> >> Is there a preffered way how to set a user temp director for sqlite ? >> >> I saw some chances via env variable SQLITE_TMPDIR but not sure if that's >> the best practise ? >> >> kr >> Martin >> >> D?a 22.04.2016 o 13:09 Richard Hipp nap?sal(a): >>> On 4/22/16, Martin Trnovec <martin.trnovec at pipelinersales.com> wrote: >>>> Hello, >>>> >>>> we are using sqlite 3.12.1 on Android device and we are tring to copy >>>> content of the one table into another table using >>>> >>>> INSERT OR REPLACE INTO <dst_table> SELECT * FROM <src_table> >>>> >>>> This commad will fail on Android with error code SQLITE_CANTOPEN when >>>> - <dst_table> has any triggers configured (also empty one like >>>> "select 1" ) >>>> - and the amount of row to be inserted is larger (currently it fails >>>> if it's 9226 rows but not with 9225 rows) >>> My guess: unable to open a transient file to store the statement journal. >>> >>> Have you tried activating the error and warning log for more details: >>> https://www.sqlite.org/errlog.html >>> >>>> the same code works perfectly on Windows or Mac OS o iOS, when we >>>> dropped the trigger it works also perfectly on Android ? >>>> >>>> Any hints ? >>>> >>>> Martin >>>> >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users at mailinglists.sqlite.org >>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>>> >> >> -- >> ------------------------------------------------------------------- >> Mgr Martin Trnovec >> Head of development >> >> Pipelinersales Inc. >> R?ntgenova 26, 851 01 Bratislava, Slovakia >> >> @: martin.trnovec at pipelinersales.com | www.pipelinersales.com >> ------------------------------------------------------------------- >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > -- ------------------------------------------------------------------- Mgr Martin Trnovec Head of development Pipelinersales Inc. R?ntgenova 26, 851 01 Bratislava, Slovakia @: martin.trnovec at pipelinersales.com | www.pipelinersales.com -------------------------------------------------------------------
