Hi all,
I've been running into some strange issues while trying to connect to
Sequoia 3.0 beta 2 with libmysequoia and Ruby's mysql driver version
2.7.3 (http://www.tmtm.org/en/mysql/ruby/). Maybe someone else has run
into similar problems, and can point me in the right direction..
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.)
I recompiled everything and got Ruby to connect to Sequoia. It even
works OK with simple, valid queries. However, if the queries produce any
error, the client application freezes and must be manually killed.
Here's an example of what happens:
:~/sequoiaTest/mysql-ruby-2.7.3$
LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjlegato/sequoiaTest/carob/
irb
irb(main):001:0> require 'mysql.so'
=> true
irb(main):002:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
=> #<Mysql:0xb7cd401c>
irb(main):003:0> x.query("select * from foo") # valid query, foo
actually exists
=> #<Mysql::Result:0xb7cccb00>
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
(I've pasted the (rather verbose) controller output below, after the end
of the message.)
Incidentally, I can't get the mysql client app to connect to Sequoia at
all by LD_PRELOADing libmysequoia.so. It just says:
LD_PRELOAD=/home/pjlegato/sequoiaTest/libmysequoia/lib/libmysequoia.so
LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjlegato/sequoiaTest/carob/
mysql -h localhost -P 25322 -u sequoia -p testDB
Enter password:
ERROR 2001 (HY000):
and nothing else. This may or may not be related.
Also, the mysql Ruby driver's test suite will not work at all with
libmysequoia.
I can think of a few possibilities:
* 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.)
* This is due to some bug in how I configured them when I was compiling
them (This seems very possible to me.)
* This is due to some subtle incompatibility with one of the support
libraries that I compiled them against.
* This is due to Ruby's mysql.so library not liking libmysequoia (Seems
unlikely, since the mysql command line client also doesn't work.)
Any ideas? Have any of you run into similar issues?
Best,
Paul
Sequoia controller output when I connect from Ruby/mysql with
libmysequoia and execute a bad query:
21:11:10,475 WARN controller.RequestManager.testDB Failed to execute
request select * from bar because of (read request 17 failed:
Backend testDB - BackendWorkerThread for backend 'nksdev-sdbn-000-a'
with RAIDb level:1 failed (ERROR: relation "bar" does not exist)
Backend testDB - BackendWorkerThread for backend 'nksdev-sdbn-000-b'
with RAIDb level:1 failed (ERROR: relation "bar" does not exist)
)
21:11:10,475 WARN controller.RequestManager.testDB SQLException while
executing remote read request.
java.sql.SQLException: read request 17 failed:
Backend testDB - BackendWorkerThread for backend 'nksdev-sdbn-000-a'
with RAIDb level:1 failed (ERROR: relation "bar" does not exist)
Backend testDB - BackendWorkerThread for backend 'nksdev-sdbn-000-b'
with RAIDb level:1 failed (ERROR: relation "bar" does not exist)
at
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:936)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execBroadcastReadRequest(RAIDb1.java:223)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:158)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:592)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1351)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteQuery.executeScheduledRequest(DistributedStatementExecuteQuery.java:93)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
21:11:10,485 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.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:219)
at
java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:558)
at
java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1513)
at
java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1435)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1626)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324)
at
org.continuent.appia.core.message.Message.popObject(Message.java:1250)
... 3 more
21:11:10,495 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.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:219)
at
java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:558)
at
java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1513)
at
java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1435)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1626)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at
java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1845)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1769)
at
java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1646)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1274)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:324)
at
org.continuent.appia.core.message.Message.popObject(Message.java:1250)
... 3 more
21:11:28,754 ERROR virtualdatabase.VirtualDatabaseWorkerThread.testDB
I/O error during user authentication (java.io.EOFException)
--
--------------------------------------------------
-- 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
