Re: Weird sequence behaviour

[Geert Bevin <gbevin@xxxxxxxx>]

This seems to be the same error as Volker describes here:
http://mckoi.com/database/mail/subject.jsp?id=6902

No solution was proposed though.

Geert Bevin wrote:
> I'm running a series of unittests, and in the middle of inserting a
> bunch of rows which each time take a new value from a sequence, it seems
> like the sequence suddenly disappears. The weird thing is that this only
> happens when I run another test first. That test does exactly the same,
> except that the query on the data is different. Each test creates the
> database structure before it's executed and drops it again at the end.
> Somehow it looks as though the dropping of the previous test 'bleeds'
> into the next test. Is that possible? It seems plausible since the 
> second test successfully recreates the structure, but the sequence 
> values aren't reset, the start where they left off in the first test.
> 
> After some investigating it seems that it's related to sequence cache 
> values. This error used to appear after 13 inserts in the 2nd unittest. 
> When I set the cache value at sequence creation to 1, it happens 
> immediately in the second unittest.
-- 
Geert Bevin                       Uwyn bvba
"Use what you need"               Avenue de Scailmont 34
http://www.uwyn.com               7170 Manage
gbevin[remove] at uwyn dot com    Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619  719A C8F4 D40D 309F D6A9
Public PGP key  : available at servers pgp.mit.edu, wwwkeys.pgp.net