This response would be good to put in swiki.
--Keith
**
- I'm not a professional; I just get paid to do this.
- Things I've learned about multithreaded programming:
123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt
rhheiianndgge dwi
If I do pragma integrity_check on a database I get:
*** in database main ***
On page 8 cell 0: invalid page number 1581
On page 8 at right child: invalid page number 1582
On page 7 cell 0: invalid page number 593
On page 7 cell 1: invalid page number 594
On page 7 cell 2: invalid page number 1171
Nuno,
You right. I just caught that last night, Sunday night, when I was
working on it. Sorry for missing that. Does version 3.0.7 have
datalocks? I know version 2.8.15 came equipped with datalocks. The
config.h file for 3.0.7 version does not contain structures, define
statements, inline
Steve Frierdich, dando pulos de alegria, escreveu :
Nuno,
You right. I just caught that last night, Sunday night, when I was
working on it. Sorry for missing that. Does version 3.0.7 have
datalocks? I know version 2.8.15 came equipped with datalocks. The
config.h file for 3.0.7 version does
Hello,
SQLite 3.0 concurrency was greatly improved via multi lock
states. Despite this, some stuff seems, to me, quite
inappropriate.
Busy handler is the "sure" way to avoid deadlocks; But
on heavily multi threaded systems, you are forced to
determine an acceptable latency time to avoid many
Paul Smith wrote:
If I do pragma integrity_check on a database I get:
*** in database main ***
On page 8 cell 0: invalid page number 1581
SQL error: database disk image is malformed
---
Is there any way to "fix" this (even if some data is lost), or does it
just need throwing away and restoring
On Fri, 3 Sep 2004, D. Richard Hipp wrote:
>Christian Smith wrote:
>>
>> How often does the balancer run?
>>
>
>No so much, it turns out. Long ago, it used to run a lot
>more often and was a high runner. But I've since optimized
>it out of a lot of situations.
>
>So allocating with malloc()
Christian Smith wrote:
Just run the test suite on NetBSD/sparc64, and test pagesize-2.3000.7 died
with a SIGBUS. Full stack trace at bottom of mail[0].
#0 0x00108d80 in balance_nonroot (pPage=0x39dc10)
at ../sqlite/src/btree.c:3045
3045p->aData = &((u8*)p)[-pBt->pageSize];
On Mon, 11 Oct 2004, D. Richard Hipp wrote:
>Christian Smith wrote:
>>
>> Just run the test suite on NetBSD/sparc64, and test pagesize-2.3000.7 died
>> with a SIGBUS. Full stack trace at bottom of mail[0].
>>
>> #0 0x00108d80 in balance_nonroot (pPage=0x39dc10)
>> at
Version 3.0.8 is now available on the website. http://www.sqlite.org/.
The primary change is a series of code size optimizations.
There are also some obscure bug fixes and a few minor enhancments.
If you are not having problems with version 3.0.7 there is little
reason to upgrade.
--
D. Richard
At 9:09 PM -0400 10/11/04, D. Richard Hipp wrote:
Version 3.0.8 is now available on the website. http://www.sqlite.org/.
The primary change is a series of code size optimizations.
There are also some obscure bug fixes and a few minor enhancments.
If you are not having problems with version 3.0.7
11 matches
Mail list logo