On 2/2/07, Guillaume Smet <[EMAIL PROTECTED]> wrote:
Thanks for checking. I just wanted to be sure it was a Sequoia issue before digging into the code.
Sure.
> CREATE TABLE auditoriacontrole ( > codsistema integer NOT NULL, > codauditoria serial NOT NULL, OK, so you have a nextval somewhere because serial generates a sequence and a default value of nextval(this sequence).
Exactly, but I can reproduce the problem with a table without a serial value. I created a table without a serial value, populated it and performed queries over it on the Sequoia console and the problem also appeared. Here are the queries: jdbc:sequoia://10.15.117.21/sentinela (user) > create table test (field integer) Affected rows: 0 Query executed in 0 s 98 ms . jdbc:sequoia://10.15.117.21/sentinela (user) > select * from test +-------------+ | field | +-------------+ +-------------+ Query executed in 1 s 535 ms . *** The error was triggered here. jdbc:sequoia://10.15.117.21/sentinela (user) > insert into test (field) values (1) Affected rows: 1 Query executed in 0 s 6 ms . jdbc:sequoia://10.15.117.21/sentinela (user) > insert into test (field) values (2) Affected rows: 1 Query executed in 0 s 5 ms . jdbc:sequoia://10.15.117.21/sentinela (user) > insert into test (field) values (3) Affected rows: 1 Query executed in 0 s 5 ms . jdbc:sequoia://10.15.117.21/sentinela (user) > insert into test (field) values (4) Affected rows: 1 Query executed in 0 s 10 ms . jdbc:sequoia://10.15.117.21/sentinela (user) > select * from test +-------------+ | field | +-------------+ | 1 | | 2 | | 3 | | 4 | +-------------+ Query executed in 0 s 10 ms . *** and here jdbc:sequoia://10.15.117.21/sentinela (user) > select * from test +-------------+ | field | +-------------+ | 1 | | 2 | | 3 | | 4 | +-------------+ Query executed in 0 s 7 ms . *** and here. jdbc:sequoia://10.15.117.21/sentinela (user) > The database output is attached. I've tried to send the same message before but forgot to compress the database log, oops. Now it is compressed
I'll take a look to understand what happens in your case this afternoon.
Thanks. -- João Eduardo
postgresql-2007-02-02_092357.log.bz2
Description: BZip2 compressed data
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
