SQLite3::IOException: disk I/O error on SELECT

2019-06-25 12:04发布

I have a Sinatra application using the Sequel gem against a sqlite3 database. I've been developing on a MacBook Pro running Mavericks. I have been running the app locally using the shotgun gem and everything has been working just fine. Recently I decided to run the application with Passenger and Nginx. When I run the application under passenger/nginx, the app errors out with the following 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 permissions on the database and I believe they are set 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 there is some sort of permissions problem going on with the passenger process reading the database but I am unsure why the database would not be readable with the permissions I listed above. I saw a similar question on Stack Overflow - "Exception Message: Some kind of disk I/O error occurred", but this seems to pertain to deletes against the database.

I don't believe there is any database corruption going on, the app still works when I run it using shotgun.

Has anyone run across anything similar?

0条回答
登录 后发表回答