Hi.
we are writing an application that in runtime produces a sqlite database.
we are using this set of pragmas:( and also the CEROD extension for
compression purposes).
"PRAGMA cache_size=10000;"
"PRAGMA synchronous = 0;";
"PRAGMA temp_store=MEMORY";
"PRAGMA journal_mode = MEMORY;"
"PRAGMA count_changes=OFF;"
"PRAGMA locking_mode=EXCLUSIVE;"
"PRAGMA page_size = 8192;"
"PRAGMA cache_size=10000;"
from time to time when we are trying to analyze created DB we get via some
SELECT stmts and the c API (see below)
int execSql(sqlite3_stmt *stmt) throw(SQLException) {
char *zErrMsg = 0;
int rc = sqlite3_step(stmt);
if (rc != SQLITE_DONE && rc != SQLITE_ROW && rc != SQLITE_OK) {
std::ostringstream extendedErrCode;
extendedErrCode << " Extended Error code: " <<
sqlite3_extended_errcode(m_db);
* throw SQLException(string("Could not execute SQL statement. Error: ")
+sqlite3_errmsg(m_db); + extendedErrCode.str());*
}
return rc;
}
we get the following error:*Error: database disk image is malformed
Extended Error code: 11*
*
*
*what can cause this error ? how can I recover from it ? *
*please assist !*
*Tal*
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
