[Python-checkins] SQLite test hangs - was: Re: Python Regression Test Failures basics (1)

[Gerhard Häring]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Neal Norwitz wrote:
> Gerhard,
> 
> There is another problem with test_sqlite on the trunk.  In
> Lib/sqlite3/test/transactions.py two functions cause hangs:
> 
>   CheckLocking
>   CheckRaiseTimeout
> 
> which is causing the builtbots to fail.
> 
> Could you take a look?

I tried to investigate this one.

First, I couldn't find the hangs you described in the buildbot status
pages.

Second, my first guess was that it was caused by old SQLite versions
rather than SQLite. I set up a test environment in which I build and
test pysqlite trunk (which is almost exactly the same code as the
sqlite3 module) against all SQLite versons from 3.0.8 to 3.5.6.

I couldn't reproduce the hang (this is Linux on x86; Ubuntu 7.10). I'm
currently out of ideas, as I don't have a hardware/software
combination available in which I can reproduce the hang.

What I did find, however, was that two aggregate-related tests fail
with SQLite verson 3.5.5 and 3.5.6. I'm 99.999 % sure it's caused by
SQLite swapping out its stack-based VM in favour of a new
register-based one.  So I can wait out this particular problem ;-)

- -- Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFH08xqdIO4ozGCH14RAthNAKCQO/cKWdFIxyx15nHIlBrq3jah8wCgnmEZ
+qIFzgak5R7FWEcJwwnPDb4=
=TsPC
-----END PGP SIGNATURE-----