[sqlite] help:sqlite3 table and struct is miss at working
hello: 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 table and struct is miss at working. Attachment is exception database. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] change sqlite table column type
Dear Sir: I have a table type is blob,I think update integer type, How to solve my trouble? alter SQL? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] HELP:The database disk image is malformed
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
[sqlite] sqlite3 question
您好: 我们使用的SQLITE3 数据库版本为3.6.23.1版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,长时间运行后会出现查询数据库返回The database disk image is malformed, 请问这是什么原因造成的.如何解决,使用最新版本3.7.2是否会避免出现这个问题? 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? Is use version 3.7.2 ? Do you have any idea about this? I would like get support for SQLite ? Wish you happiness ! Yours sincerely, Lizhe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Fw: sqlite3 support
- Original Message - From: lizhe To: d...@hwaci.com Cc: us...@sqlite.org Sent: Friday, October 29, 2010 2:41 PM Subject: sqlite3 support 您好: 我们使用的SQLITE3 数据库版本为3.6.23.1版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,长时间运行后会出现查询数据库返回The database disk image is malformed, 请问这是什么原因造成的.如何解决,使用最新版本3.7.2是否会避免出现这个问题? 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? Is use version 3.7.2 ? Do you have any idea about this? I would like get support for SQLite ? Wish you happiness ! Yours sincerely, Lizhe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Fw: sqlite3 support
- Original Message - From: lizhe To: d...@hwaci.com Cc: us...@sqlite.org Sent: Friday, October 29, 2010 2:41 PM Subject: sqlite3 support 您好: 我们使用的SQLITE3 数据库版本为3.6.23.1版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,长时间运行后会出现查询数据库返回The database disk image is malformed, 请问这是什么原因造成的.如何解决,使用最新版本3.7.2是否会避免出现这个问题? 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? Is use version 3.7.2 ? Do you have any idea about this? I would like get support for SQLite ? Wish you happiness ! Yours sincerely, Lizhe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 question
您好: 我们使用的SQLITE3 数据库版本为3.6版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,对有些板子,发现如果连续插入数据库会造成LINUX系统的崩溃,有的时候会造成FLASH的丢失,使用调试口测试,发现是堆栈益出,但是在有些板子上却很正常,可以连续插入几万条记录,请问这是什么原因造成的. Dear Sir: I am writing to enquire about a bug we found. Now the SQLITE3 database we use is version 3.6, which running in the red hat compiler and the hardware system is Linux(version 2.6).We have a problem that for some broads, if inserting the records into database continuously will make the Linux system breakdown, and sometimes lose Flash too. Using debugcom to test, it comes out stack overflow . But for some broads are not, we can insert tens of thousands of records into it. Do you have any idea about this? Wish you happiness ! Yours sincerely, Lizhe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
