SQLite Disk I/O Error - Githubissues

leonardofalk commented 5 years ago

could not prepare statement: 10; Message: disk I/O error

Sometimes we get this message after doing a count query.

Sample model that triggers the error:

class Parametro
  include Rhom::FixedSchema

  property :id_parametro, :string
  property :valor,        :string
end

Parametro.count # this triggers the error

This was introduced after upgrading from 6.1 (gem, not git) to master branch (commit 1225a60826c0768129802606ae370d1b324c1ae5), as we're testing x64 Android builds. After digging a while some people say this is because the database journal file (ending in -journal) is not writable. I will try to keep this updated if I find anything more useful.

alex-epifanoff commented 5 years ago

@leonardofalk what is the device you observe this issue on? Also could you please point to discussion where journal file is pointed at as a reason.

leonardofalk commented 5 years ago

@alex-epifanoff Mostly Android devices, any version.

Discussions:

alex-epifanoff commented 5 years ago

fixed by 2cbb916db610930b031be499ef7fe3d9ac9d817a

rhomobile / rhodes

SQLite Disk I/O Error #1007