I have a Sinatra application using Sequel stone for sqlite3 database. I am developing a MacBook Pro running Mavericks. I run the application locally using a shotgun gem and everything works fine. I recently decided to launch the application using Passenger and Nginx. When I run the application under the passenger / nginx, when the application fails in the logs
App 17805 stdout: E, [2014-02-09T20:44:42.491448 #17805] ERROR -- : SQLite3::IOException: disk I/O error: SELECT * FROM `movies`
App 17735 stderr: Sequel::DatabaseError - SQLite3::IOException: disk I/O error:
I checked the permissions on the database and I believe that they are installed correctly.
smbp2:storage jojoba$ ls -lthr
total 112
-rw-rw-rw- 1 jojoba staff 28K Feb 1 22:40 dev.db
I have a feeling that during the processing of passenger processes there is some kind of problem with access rights, but I'm not sure why the database will not be readable with the permissions listed above. I saw a similar question in Qaru - " Exception message: there was some disk I / O error ", but this seems to apply to deleting through the database.
I do not believe that any damage to the database is happening, the application is still working when I launch it with a shotgun.
Does anyone come across something similar?
source
share