Hi,
I have done some experimentation with the latest Carob/libmysequoia
pair. I tried upgrading to the new 0.7.2/0.9.7 releases. They will not
work with Sequoia 3.0 beta 2; the controller complains about a protocol
version mismatch (8.10 in Sequoia vs. 8.11 in Carob), so I upgraded the
server to the nightly build of 1/18, which reports itself as Sequoia 3.0
beta 3.
The new Carob does work with this nightly version of Sequoia, but it
still crashes if an invalid query is executed. Next, I'll try the CVS
head version, and then finally downgrade to the last 2.x stable release..
Is there anything I may be doing wrong that could cause these errors?
The observed behavior from Ruby via libmysequoia changes slightly: An
invalid query now causes a long pause, after which the error
"Mysql::Error: Virtual database testDB not found on any of the
controllers" is returned. Repeating any query after this point produces
"Mysql::Error: Request cannot be processed : connection is closed!"
On the server side, the controller produces:
00:50:37,361 ERROR continuent.hedera.adapters PullPushAdapter: Error
while reading from channel
org.continuent.appia.core.message.MessageException: Trying to read an
unknown object from message.
at
org.continuent.appia.core.message.Message.popObject(Message.java:1254)
at
org.continuent.hedera.channel.AppiaReliableGroupChannel.receive(AppiaReliableGroupChannel.java:292)
at
org.continuent.hedera.adapters.PullPushAdapter.run(PullPushAdapter.java:166)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.lang.ClassNotFoundException:
org.postgresql.util.PSQLException
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
[...]
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324)
at
org.continuent.appia.core.message.Message.popObject(Message.java:1250)
... 3 more
when the invalid query is executed.
Thanks, and best regards,
Paul
Csaba Simon wrote:
Hi Paul,
Thanks for your lengthly feedback. Please find inlined my answers.
I'm running Debian Linux and currently using Carob 0.6.2 (version
0.7.1 refuses to work with Sequoia, complaining about a protocol
mismatch when connected) and libmysequoia 0.9.5 (since 0.9.6 won't
work with Carob 0.6.2.)
Please try the latest Carob and LibMySequoia from the CVS or wait for a
few days until Carob 0.7.2 and LibMySequoia 0.9.7 will be released.
irb(main):004:0> x.query("select * from bar") # invalid query, bar
does not exist
(client app freezes here, must ^C)
terminate called after throwing an instance of 'CarobNS::DriverException'
Aborted
irb(main):006:0> x.query("select * from bar")
Mysql::Error: Table 'DB1.bar' doesn't exist
from (irb):6:in `query'
from (irb):6
As you see no problem with the latest code.
What is strange that in your ruby example is missing the LD_PRELOAD...
Did you renamed the libmysequoia library?
Incidentally, I can't get the mysql client app to connect to Sequoia
at all by LD_PRELOADing libmysequoia.so. It just says:
This was fixed two days ago in the CVS (first reported by Raúl Rodríguez)
Also, the mysql Ruby driver's test suite will not work at all with
libmysequoia.
Most of the test suite is working, there are only a few failing tests.
This need furtherer investigation.
* This is due to some bug in these older versions of Carob and
libmysequoia that has since been fixed in their newer releases. (Seems
very possible.)
True.
The latest Carob and LibMySequoia is working only with the stable
Sequoia 2.10 branch. Can you try this? Or you absolutely need the
Sequoia 3.0 development branch?
Cheers,
Csaba
--
--------------------------------------------------
-- Paul Legato, Senior Software Engineer --
--- Networked Knowledge Systems ---
---- P.O. Box 20772 Tampa, FL. 33622-0772 ----
----- (415)846-0702 Voice (813)594-0045 FAX -----
------ [EMAIL PROTECTED] ------
--------------------------------------------------
--------------------------------------------------
----- This email bound by the following: -----
---- http://www.nks.net/email_disclaimer.html ----
--------------------------------------------------
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
