The database I'm using is PostgreSQL 8.1.5.
Here is what I did to reproduce the problem :
- Create two databases called test and test_2, respectively.
- In each database create table "mytable" like this : "CREATE TABLE mytable (i int primary key, t text);"
- In each database, execute this INSERT : "INSERT INTO mytable VALUES (1,'A') ;"
- Create a recovery log databse.
- Create controller and virtual database configuration files with appropriate settings. Virtual DB is called "vdb". Of notice, autoEnableBackends in the controller configuration file is set to "true" .
- Start the controller.
- Connect to Sequoia console.
- Since the controller was started with autoEnableBackends="true", but no initial checkpoint to start from, force enable on both backends in the console's admin mode. Both backends are now enabled, as shown by "show backend *".
- Come back to main menu and connect to database : "sql client jdbc:sequoia://localhost/vdb". Login, pasword ...
- Type "show tables". The console displays "mytable".
- Type "select * from mytable ". The console displays :
+-------------+--+
| i | t |
+-------------+--+
| 1 | A |
+-------------+--+
- Now type : "INSERT INTO mytable VALUES (2,'B')". Console displays :
"An error occured while executing SQL query ( org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Unknown table 'mytable' in this INSERT statement: 'INSERT INTO mytable VALUES (2,'B')')"
- Of notice, adding a ";" at the end of the sql statement produces a different error message :
"An error occured while executing SQL query (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Failed to execute request INSERT INTO mytable VALUES (2,'B') ;/ because of (org.continuent.sequoia.controller.requests.StoredProcedure ))"
Thanks,
Paul
On 10/27/06, Emmanuel Cecchet <[EMAIL PROTECTED]
> wrote:
Hi Paul,
> Using Sequoia 2.10.2, I try to execute this INSERT query : "INSERT
> INTO mytable VALUES (4,'test','test)" .
>
> I get this error message : "An error occured while executing SQL query
> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException :
> Message of cause: Unknown table 'mytable' in this INSERT statement:
> 'INSERT INTO mytable VALUES (4,'test','test)' )"
>
> However, I can do "SELECT * from mytable", and it works perfectly.
> "show tables" also returns "mytable" in its list.
For some reason, your database backend schema does not seem up-to-date.
Could you provide us with a full scenario to reproduce the issue? Also
which database are you using?
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet
Chief Architect, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
