Dear Sir:
I am writing to enquire about a bug we found. Now the SQLITE3 database we use
is version 3.6.23.1, which running in the red hat compiler and the hardware
system is Linux(version 2.6).We have a problem that for select
database(SQL),return "The database disk image is malformed" ,How to solve my
trouble?
(1)The reason of coming out "The database disk image is malformed":
In my system, the code that I carry out:
sprintf(sql, "select log_time,id,log_type,log_string from logrecord");
renSql = sqlite3_get_table(BuDatabaseHandle, sql, &azResult, &nRow, &nColumn,
&zErrMsg);
it returns error11. After my analysis, I found anomalous data in the database
table logrecord. In my attachment, the error data "id=27490" in logrecord, I
think the reason is carring out the function update. My function of update(sql)
is:
{
sqlite3 * BuDatabaseHandle;
if(open_database()==-1)
return -1;
sprintf(sql,"update logrecord set upload_sign=1 where upload_sign=0 and
id<=%ld;",LogMaxId);
renSql=sqlite3_exec( BuDatabaseHandle , sql , 0 , 0 , &zErrMsg );
if(renSql!=0)
{
close_database();
return -4;
}
close_database();
}
(2)Using the latest version3.7.2 to compile, when I carry out my function to
insert data, I found that the Utilization rate of RAM(linux: /proc cat meminfo)
have been reduced quickly. I don' kown, is it a BUG for the version3.7.2,
because when I used version3.6.23 to compile my code, it had no problem.
question?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
