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?