-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi, I just installed sequoia and I am testing it. I am able to execute select statements, create statements but it fails with DROP. I have set up one controller with two backends. I have fully followed the Installation and configuration guide. To replicate data at the send back end I dump / restore. (vacadbdummydummy is the first backend and vacadbdummydummy2 is the second backend) I am using the sequoia SQL client: Create table seems ok: jdbc:sequoia://127.0.0.1:25322/vvacadb (vaca) > CREATE table test5 (i int ); Affected rows: 0 Query executed in 0 s 90 ms . Log: 15:03:15,799 INFO DatabaseBackend.vvacadb.vacadbdummydummy2 Checking compatibility with existing database schema 15:03:15,833 WARN DatabaseBackend.vvacadb.vacadbdummydummy2 Gathered schema for login "vaca" is not compatible with existing shema. Keeping current schema. Drop table fails: jdbc:sequoia://127.0.0.1:25322/vvacadb (vaca) > DROP table test5; An error occured while executing SQL query (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Unknown table 'test5;' in this DROP statement 'DROP table test5;') Log: 15:06:07,023 WARN controller.virtualdatabase.vvacadb Distributed request DROP table test5;/ did not remove itself from the total order queue 15:06:07,058 INFO controller.RequestManager.vvacadb Request 24 failed on controller Member(address=/192.168.12.8:50461, uid=vvacadb) (java.sql.SQLException: Unknown table 'test5;' in this DROP statement 'DROP table test5;') 15:06:07,128 INFO virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Error during command execution (Unknown table 'test5;' in this DROP statement 'DROP table test5;') I have no idea about what to try next to get DROP working. I have google and I get nothing. Any ideas? Sequoia version: 2.10.10 Postgres version: 8.2 Postgres JDBC: 8.2-509 Thanks in advance, Ruben -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJR7cpIo1XmbAXRboRAm1CAJsEY5hqRTVlhJHUdVN+UWJ7hZwN9QCeKoZH HMOgqyd4Qhw6Ph4gaF5UAbw= =3JpU -----END PGP SIGNATURE-----
begin:vcard fn:Ruben Rubio n:Rubio;Ruben org:Rentalia Holidays S.L adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain email;internet:[email protected] tel;work:+34915233104 url:http://www.rentalia.com version:2.1 end:vcard
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
