Re: [sqlite] How much disk space is required to checkpoint?

2012-09-25 Thread Dan Kennedy
On 09/26/2012 05:48 AM, Simon Slavin wrote: On 25 Sep 2012, at 10:54pm, David Barrett wrote: If my database is X GB, and the WAL file is Y GB, how much total disk space is required to: 1) Checkpoint the database I think it's a maximum of X+Y+Y (including the

Re: [sqlite] database disk image is malformed - Error

2012-09-25 Thread Rittick Gupta
Do you think a retry of the query would help resolve this issue ? Do I have to close & reopen the database. Thanks for your help. regards, Rittick ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] database disk image is malformed - Error

2012-09-25 Thread David Barrett
Yes, still having that problem. We've moved to new servers with SSD's and a ton of RAM, and that seems to have helped matters -- not sure why, though I don't know why it was happening in the first place. (I'm *guessing* the issue is due to two conflicting queries happening at the same time, so if

Re: [sqlite] database disk image is malformed - Error

2012-09-25 Thread Rittick Gupta
David, Thanks. Do you still have the problem ? Did you find a workaround to avoid the problem - appreciate your response. regards, Rittick ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How much disk space is required to checkpoint?

2012-09-25 Thread Simon Slavin
On 25 Sep 2012, at 10:54pm, David Barrett wrote: > If my database is X GB, and the WAL file is Y GB, how much total disk space > is required to: > > 1) Checkpoint the database I think it's a maximum of X+Y+Y (including the existing X+Y) plus or minus a page or two. >

[sqlite] How much disk space is required to checkpoint?

2012-09-25 Thread David Barrett
If my database is X GB, and the WAL file is Y GB, how much total disk space is required to: 1) Checkpoint the database 2) Vacuum the database Additionally, if there are any temporary files created, where do they exist? We've done some poking around and are having some crazy theory about a

Re: [sqlite] database disk image is malformed - Error

2012-09-25 Thread David Barrett
You might be interested in this thread: http://www.theusenetarchive.com/usenet-message-sqlite-does-disabling-synchronous-and-shared-cache-cause-%22error-database-disk-image-is-malformed%22-20780199.htm No conclusion was ever obtained, but the discussion was good. -david On Mon, Sep 24, 2012 at

Re: [sqlite] [Fwd: [FEATURE REQUEST] support of %y in strftime()]

2012-09-25 Thread Clemens Ladisch
LacaK wrote: > But why not add %y, when it is only 5 lines of source code, Plus documentation, test cases, etc. > take into account that %y is supported also by C strftime() > or PHP etc. Those languages are not called Clite or PHPlite. > and it is really useful. You still haven't mentioned a

[sqlite] [Fwd: [FEATURE REQUEST] support of %y in strftime()]

2012-09-25 Thread LacaK
Yes I know, that there is workaround using: substr(strftime('%Y',d),3) But why not add %y, when it is only 5 lines of source code, take into account that %y is supported also by C strftime() or PHP etc. and it is really useful. -Laco. Seriously, what your patch is actually about is to

Re: [sqlite] [Fwd: [FEATURE REQUEST] support of %y in strftime()]

2012-09-25 Thread Clemens Ladisch
LacaK wrote: > some month ago I wrote question about possibility to add support of %y > (2 digit year) to strftime() function. > Patch is very simple (only few lines of code) and I hope, that will be > useful for many users. Two-digit years happend about two thousand years ago, and at that time,

[sqlite] [Fwd: [FEATURE REQUEST] support of %y in strftime()]

2012-09-25 Thread LacaK
Please can any developer do any comment on this request? Would it be possible to add such support? Thanks -Laco. - Pôvodná správa - Predmet:[FEATURE REQUEST] support of %y in strftime() Dátum: Fri, 21 Sep 2012 14:15:45 +0200 Od: LacaK Pre: