Thread: Sequence failure after some time

Sequence failure after some time

From
"Jed Nicolau Filho"
Date:
Hi there
 
I am doing a Stress Test in my app.
I have to clients connected into Postgre 8.0 using a sequence as PK generator.
Then two clients execute a login search a PK of generator that is placed in a table log
and logoff . This is executed in looping with 2 seconds delay between logon and logoff.
 
The problem is that for some minutes all work fine, then Postgre fail trying to generate PK in
a sequence !
 
How to fix it ?
 
Thanks in advance
 
Best Regards
 
Jed