sqlite3_prepare fails if db opened with SQLITE_OPEN_READONLY

Question

sqlite3_prepare function fails if DB is opened with SQLITE_OPEN_READONLY.

Error message:  error #10: disk I/O error 
Sqlite extended error code: SQLITE_IOERR_LOCK (3850)
Errno: EBADF 9  /* Bad file number */

Everything works fine if DB is opened with SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_FULLMUTEX;
Any ideas on what may cause this problem?

rc=sqlite3_open_v2("example.db",&db,SQLITE_OPEN_READONLY,0);
sqlite3_busy_timeout(db,1000); 
selectQuery = "select * from test;";
rc = sqlite3_prepare(db, selectQuery, strlen(selectQuery), &stmt, 0);
if(rc!=SQLITE_OK) 
{
    printf("sql error #%d: %s", rc, sqlite3_errmsg(db));
    printf( "SQL ext error: %d\n", sqlite3_extended_errcode(db));
    printf( "errno: %d\n", errno );
}

Does this DB use WAL? What file system?

CL.
– CL.

2015-01-06 09:43:08 +00:00
Commented Jan 6, 2015 at 9:43 — CL.
– CL., Commented Jan 6, 2015 at 9:43

incogn1to · Accepted Answer · 2015-01-08 08:16:28Z

1

The problem is in OS lock implementation. Fcntl() doesn't allow to lock file if it is opened with read only permissions. As a result - SQLite can't do anything in read only mode.

answered Jan 8, 2015 at 8:16

incogn1to

4275 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite3_prepare fails if db opened with SQLITE_OPEN_READONLY

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related