Ok...good news for 3.7.5 is that once I increased my commit interval I started
seeing problems with 3.7.3 -- so I think it's me causing the problem.
What I'm doing is a begin/commit in a thread while the main thread is doing a
lot of inserts (almost as fast as possible...doing some other math in there
too).
threadsafe=3
I either get an error on insert "data disk image is malformed" from the main
process, or
SQlite commit err=5
SQlite begin err=1
Here' s my thread code...any observations about "bad idea" here that I'm doing?
dbCommit() {
sqlite3_stmt *pStmt;
const char *sql="COMMIT";
int err = sqlite3_prepare_v2(pDb,sql,strlen(sql),&pStmt,NULL);
if (err != SQLITE_OK) {
cerr << "Error preparing '" << sql << "':" << sqlite3_errmsg(pDb);
}
do {
err = sqlite3_step(pStmt);
if (err != SQLITE_DONE) {
cerr << "SQlite commit err=" << sqlite3_reset(pStmt) << endl;
Sleep(1000);
}
} while (err!=SQLITE_DONE);
sqlite3_finalize(pStmt);
dbBegin(); // we'll crank up another begin to keep it going
}
dbBegin() {
sqlite3_stmt *pStmt;
const char *sql="BEGIN";
int err = sqlite3_prepare_v2(pDb,sql,strlen(sql),&pStmt,NULL);
if (err != SQLITE_OK) {
cerr << "Error preparing '" << sql << "':" << sqlite3_errmsg(pDb);
}
do {
err = sqlite3_step(pStmt);
if (err != SQLITE_DONE) {
cerr << "SQlite begin err=" << sqlite3_reset(pStmt) << endl;
Sleep(1000);
}
} while (err!=SQLITE_DONE);
sqlite3_finalize(pStmt);
}
And the insert inside the main proces
do {
err = sqlite3_step(pStmt);
if (err != SQLITE_DONE) {
cerr << "Error on insert with '" << mysql << "'=" <<
sqlite3_reset(pStmt) << endl;
Sleep(1000);
}
} while (err != SQLITE_DONE);
sqlite3_finalize(pStmt);
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
________________________________________
From: [email protected] [[email protected]] on
behalf of Richard Hipp [[email protected]]
Sent: Monday, January 24, 2011 4:29 PM
To: General Discussion of SQLite Database
Subject: EXTERNAL:Re: [sqlite] :Re: SQLite version 3.7.5 - code freeze
On Mon, Jan 24, 2011 at 5:23 PM, Black, Michael (IS) <[email protected]
> wrote:
> I plugged 3.7.5 code freeze into my app and fairly quickly hit a potential
> bug.
>
> I'm using a separate thread to commit my transactions and
> SQLITE_THREADSAFE=2
>
> I never saw a problem in my testing so far with 3.7.3 -- but a few runs
> after putting 3.7.5 in I started getting an insert error followed by
> "database disk image is malformed". It's probalistic.
>
> I never saw any errors or with 3.7.3.
>
> I should be able to write a standalone app that simulates this and
> increases the likelihood of failure if it'd help (no doubt it would so I'll
> start).
>
That would be great. Thanks.
>
> Michael D. Black
> Senior Scientist
> NG Information Systems
> Advanced Analytics Directorate
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
