Strange problems using libmysequoia with Carob 3 beta / Ruby

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 -----
------           plegato-S1aAME+IMEg@xxxxxxxxxxxxxxxx            ------
--------------------------------------------------

--------------------------------------------------
-----   This email bound by the following:   -----
---- http://www.nks.net/email_disclaimer.html ----
--------------------------------------------------