SQLite Forum

sqlite native library in Android returns disk I/O error

sqlite native library in Android returns disk I/O error

(1) By anonymous on 2022-01-12 13:42:21 [link] [source]

I use cmake and sqlite native library in my Android app and I am getting error 10 : disk I/O error after a simple select clause on one table.

SELECT * FROM TABLE_3 After doing some experiment, I found out that I won't get this error if I limit the size of my select clause.

SELECT * FROM TABLE_3 LIMIT 100 this makes me wonder if this issue has something to do with the length/size of the data returned from the query (100 seems to be the magic number/threshold, I have 200 records in the table)

an exmaple of a record in table_3

All the columns are string/text, among them column_4 is considered the largest in size(about 15000 characters)

I am not familiar with SQL and wonder if there is any limit around the size of the data returned?

(2) By Richard Hipp (drh) on 2022-01-12 14:18:47 in reply to 1 [source]

The SQLite core does not have any limits like this. But I don't know what kind of limits you might be encountering from Android or from the wrapper class that you are using to access SQLite from your app.