Would you mind not sending logfiles of several MB to the list. Either
put it on a server somewhere or send it in a private mail to the person
having requested it.
Thank you.
Marc
J. Eduardo wrote:
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'll take a look to understand what happens in your case this afternoon.
Thanks.
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
