Re: [sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

2008-02-13 Thread Zbigniew Baniewski
On Fri, Feb 01, 2008 at 11:46:06AM -0500, Rob Sciuk wrote:

> Actually, upon inspection, that may be an artifact of an earlier attempt 
> to run the tests as root, the "chocolate" directory was, in fact owned by 
> root.  I'm re-running the tests, having removed that directory, and I'll 
> repost the results upon completion ...

Hallo,

sent a question to OpenBSD list, before I noticed, you're user of both
OpenBSD and SQLite. Perhaps could you help me a little with my SQLite
problem:

I've compiled lately SQLite 3.5.6 and TCL/Tk 8.5.1 - everything seem to be
working OK, with one annoying exception: everytime, when I'm leaving tclsh,
when SQLite module has been loaded before ("package require sqlite3") there
is an error message: "Segmentation fault (core dumped)". Do you know the
origin of the problem - and (even better) the cure?

Both SQLite and TCL/Tk were compiled directly from the sources (_not_ from
OpenBSD's "ports"), OpenBSD 4.2/i386. TCL/Tk itself seems to be working just
fine (didn't notice any problems, as of yet).

Exactly the same issue I had earlier, trying SQLite 3.4.2 with TCL/Tk 8.5.0.
-- 
pozdrawiam / regards

Zbigniew Baniewski
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

2008-02-01 Thread Rob Sciuk

On Fri, 1 Feb 2008, [EMAIL PROTECTED] wrote:

We do not understand the async3 problem and cannot reproduce it.
All the other issues have been fixed in CVS HEAD.



Actually, upon inspection, that may be an artifact of an earlier attempt 
to run the tests as root, the "chocolate" directory was, in fact owned by 
root.  I'm re-running the tests, having removed that directory, and I'll 
repost the results upon completion ...


Cheers,
Rob.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

2008-02-01 Thread drh
Rob Sciuk <[EMAIL PROTECTED]> wrote:
> Dear DRH,
> 
> I post the previous (FreeBSD/Ubuntu) and this *ONLY* to exercise the new
> 3.5.5 bits given the wholsale changes.  I hope you find them useful, but
> AFAICT, 3.5.5 looks pretty good from a perf/stability standpoint.
> 
> In the obscure machine/OS category, I lit this up on an HP9000 K200 
> running not HP-UX, but rather OpenBSD 4.2 (heh heh).  Build was 
> uneventful, and testfixture ran to completion with the following output.
> 

We do not understand the async3 problem and cannot reproduce it.
All the other issues have been fixed in CVS HEAD.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

2008-02-01 Thread Rob Sciuk


Dear DRH,

I post the previous (FreeBSD/Ubuntu) and this *ONLY* to exercise the new
3.5.5 bits given the wholsale changes.  I hope you find them useful, but
AFAICT, 3.5.5 looks pretty good from a perf/stability standpoint.

In the obscure machine/OS category, I lit this up on an HP9000 K200 
running not HP-UX, but rather OpenBSD 4.2 (heh heh).  Build was 
uneventful, and testfixture ran to completion with the following output.


$ uname -a
OpenBSD hppa.controlq.com 4.2 xyzzy#0 hppa
$ make test | grep -v Ok | tee test.output.HPPA

./testfixture ../test/quick.test
async3-1.0...
Error: error deleting "chocolate/banana/vanilla/file.db": permission denied
async3-1.1...
Error: table abc already exists
async3-1.2.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
async3-1.3.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
async3-1.4.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
async3-1.5.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
async3-1.6.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
async3-1.7.2...
Expected: [1 {database is locked}]
 Got: [1 {attempt to write a readonly database}]
bind-4.4...
Error: floating point value is Not a Number
bind-4.5...
Expected: [null real real]
 Got: []
btree-2.1.1...CURSOR 485C3688 rooted at1(rw) currently at 1.0 eof
PAGE 1:  flags=0x09  frag=0   parent=0
cell  0: i=913..1023  chld=0nk=2020 nd=1792 payload=*** This is a very 
PAGE 2:  flags=0x08  frag=0   parent=0

PAGE   1 addr=42205894 nRef=2
Skipping crash5 tests: not compiled with -DSQLITE_MEMDEBUG...
lock4-1.3...
Error: database is locked
Skipping malloc5 tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping malloc6 tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping malloc7 tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping malloc8 tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping malloc9 tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocA tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocB tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocC tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocD tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocE tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocF tests: not compiled with -DSQLITE_MEMDEBUG...
Skipping mallocG tests: not compiled with -DSQLITE_MEMDEBUG...
printf-1.7.6...
Expected: [Three integers: (100) ( f4240) (3641100)]
 Got: [Three integers: ( 100) ( f4240) (3641100)]
printf-1.8.6...
Expected: [Three integers: (9) (3b9ac9ff) (7346544777)]
 Got: [Three integers: ( 9) (3b9ac9ff) (7346544777)]
printf-1.9.7...
Expected: [Three integers: ( 0) (   0x0) ( 0)]
 Got: [Three integers: ( 0) ( 0) ( 0)]
Skipping safety tests since SQLITE_DEBUG is off
time with cache: 38383126 microseconds per iteration
time without cache: 145730273 microseconds per iteration
result=one 10 three 5 two 14
speed3-1.incrvacuum..  4612032 uS216.82417 row/s
speed3-1.normal... 9631095 uS103.83035 row/s
Incrvacuum: Read 1098, wrote 94
Normal: Read 10479, wrote 43
speed3-2.incrvacuum..  1803619 uS554.44082 row/s
speed3-2.normal... 3585545 uS278.89763 row/s
Incrvacuum: Read 2843, wrote 1
Normal: Read 10011, wrote 0
tcl-1.6...
Expected: [1 {syntax error in expression "x*"}]
 Got: [1 {invalid bareword "x"
in expression "x*";
should be "$x" or "{x}" or "x(...)" or ...}]
vtab6-2.2...
Expected: [1 2 3 {} 2 3 4 1 3 4 5 2]
 Got: [1 2 3 {} 2 3 4 {} 3 4 5 {}]
vtab6-2.4...
Expected: [1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 1 2 3]
 Got: [1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 {} {} {}]
vtab6-2.5...
Expected: [2 3 4 {} {} {} 3 4 5 1 2 3]
 Got: [2 3 4 {} {} {} 3 4 5 {} {} {}]
vtab6-2.6...
Expected: [1 2 3 {} {} {} 2 3 4 {} {} {}]
 Got: [1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 {} {} {}]
vtab6-7.1...
Expected: [1 999 999 2 131 130 999]
 Got: [1 999 999 999 999 999 999]
vtab6-9.1.1...
Expected: []
 Got: [2 22 {}]
vtab6-9.2...
Expected: []
 Got: [2 22 {}]
22 errors out of 38217 tests
Failures on these tests: async3-1.0 async3-1.1 async3-1.2.2 async3-1.3.2 
async3-1.4.2 async3-1.5.2 async3-1.6.2 async3-1.7.2 bind-4.4 bind-4.5 lock4-1.3 
printf-1.7.6 printf-1.8.6 printf-1.9.7 tcl-1.6 vtab6-2.2 vtab6-2.4 vtab6-2.5 
vtab6-2.6 vtab6-7.1 vtab6-9.1.1 vtab6-9.2
All memory allocations freed - no leaks
Maximum memory usage: 14162418 bytes
Current memory usage: 0 bytes
*** Error code 1

Stop in /u0/sw/SQLite/sqlite-3.5.5/OpenBSD (line 568 of Makefile).

-
To unsubscribe, send email to [EMAIL PROTECTED]
-