[sqlite] Error: database disk image is malformed

[Tal Tabakman]

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