-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
About the DROP table statement failure, if instead "DROP table test5;" y write on terminal "DROP table test5 ;" it works. Is it a bug ? Ruben Rubio escribió: > > > 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 > > > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJR8T+Io1XmbAXRboRAvUpAKCnThkTZiyHZhgnOvXnO/9VC+R6AgCgpXat TWa71ssotGutu2V5QJFneA8= =pHdr -----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
