Re: [sqlite] ????: sqlite3 error: database or disk is full when?commit?transaction

2010-03-27 Thread Jay A. Kreibich
On Sat, Mar 27, 2010 at 04:44:56PM +0800, Tim scratched on the wall: > Hi Donald, > > Thanks for your information. And I don't know how to reach Jay kreibich's > email address, so I CC this mail to 'General Discussion of SQLite Database'. > > Could you please help me forward to Jay Kreibich if

Re: [sqlite] sqlite3 error: database or disk is full when commit transaction

2010-03-25 Thread Bravo Shen
of my database? Do you have any comments on this case? Regards,Tim > From: donald.gri...@allscripts.com > To: sqlite-users@sqlite.org > CC: bh_s...@hotmail.com > Date: Thu, 25 Mar 2010 12:41:28 -0400 > Subject: RE: [sqlite] sqlite3 error: database or disk is full when commit

Re: [sqlite] sqlite3 error: database or disk is full when commit transaction

2010-03-25 Thread Jay A. Kreibich
On Thu, Mar 25, 2010 at 10:56:40PM +0800, Tim scratched on the wall: > > I have a 32MB hard disk. My OS is about 17MB and my application's size is > about 3MB. So there is only 10MB for program data. > > My database is about 4.74MB. When I perform following sql query in a > transaction > >

Re: [sqlite] sqlite3 error: database or disk is full when commit transaction

2010-03-25 Thread Griggs, Donald
Tim, Regarding: "I guess when do the transaction, the database was duplicated, and it caused no free disk space" Unless you do something such as "vacuum" the database should not actually be duplicated. A rollback journal file, though, **is** created. (details at

[sqlite] sqlite3 error: database or disk is full when commit transaction

2010-03-25 Thread Tim
Hello, I have a 32MB hard disk. My OS is about 17MB and my application's size is about 3MB. So there is only 10MB for program data. My database is about 4.74MB. When I perform following sql query in a transaction sqlite3_exec(m_sqlite3, "delete from table", 0, 0, ); I got the error