I've installed the CVS versions of Carob and libmysequoia. I now get
different and inconsistent results.
*Sometimes* I get the "virtual database testDB not found on any of the
controllers" message, sometimes I don't, even with valid queries. I
can't see any pattern to when the error occurs and when it doesn't.
(as before, table "foo" exists, table "bar" does not.)
Session One:
$ LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjle
gato/sequoiaTest/carob/ LD_PRELOAD=libmysequoia.so irb
irb(main):001:0> require 'mysql.so'
=> true
irb(main):002:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
=> #<Mysql:0xb76d79fc>
irb(main):003:0> x.query("select * from foo")
Mysql::Error: Virtual database testDB not found on any of the controllers
from (irb):3:in `query'
from (irb):3
from :0
irb(main):004:0>
Session Two. (No changes whatsoever to the environment or Sequoia server.)
$ LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjle
gato/sequoiaTest/carob/ LD_PRELOAD=libmysequoia.so irb
irb(main):001:0> require 'mysql.so'
=> true
irb(main):002:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
=> #<Mysql:0xb773ca14>
irb(main):003:0> x.query("select * from foo")
=> #<Mysql::Result:0xb7735fc0>
irb(main):004:0> 100.times {|t| print t.to_s + " " ; puts "ERROR"
unless x.query("select * from foo").is_a?(Mysql::Re
sult) }
0 1 2 3 4 5 Mysql::Error: Virtual database testDB not found on any of
the controllers
from (irb):4:in `query'
from (irb):4
from (irb):4:in `times'
from (irb):4
from :0
irb(main):005:0>
Session Three. Again, no environmental changes.
$ LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjle
gato/sequoiaTest/carob/ LD_PRELOAD=libmysequoia.so irb
irb(main):001:0> require 'mysql.so'
=> true
irb(main):002:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
=> #<Mysql:0xb777c9fc>
irb(main):003:0> x.query("select * from foo")
=> #<Mysql::Result:0xb7775fa8>
irb(main):004:0> 100.times {|t| print t.to_s + " " ; puts "ERROR"
unless x.query("select * from foo").is_a?(Mysql::Re
sult) }
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
27 28 29 30 31 32 33 Mysql::Error: Virtual database testDB not found on
any of the controllers
from (irb):4:in `query'
from (irb):4
from (irb):4:in `times'
from (irb):4
from :0
irb(main):005:0>
As you can see, there is no obvious pattern - sometimes it doesn't work
at all (even with a valid query); sometimes 30 or more valid queries
work fine, then it fails (on a valid query.)
The only event noted in the serverside log is:
2007-02-16 18:10:13,193 ERROR
virtualdatabase.VirtualDatabaseWorkerThread.testDB I/O error during user
authentication (j
ava.io.EOFException)
2007-02-16 18:11:03,301 WARN
virtualdatabase.VirtualDatabaseWorkerThread.testDB Client
(login:sequoia,host:localhost cl
osed connection with server)
libmysequoia.log in debug mode produces a lot of this:
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobCommon.cpp:105) - Entering delete_query_fields: fields=0x80b04a0
field_count=2
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobCommon.cpp:121) - Leaving delete_query_fields.
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobMySQL.cpp:721) - Leaving free_results.
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia (MySQLAPI.cpp:491)
- Leaving mysql_free_result.
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia (MySQLAPI.cpp:486)
- Entering mysql_free_result: res=0x80a27b8
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobMySQL.cpp:656) - Entering free_results: res=0x80a27b8
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobCommon.cpp:105) - Entering delete_query_fields: fields=0x809ab20
field_count=2
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobCommon.cpp:121) - Leaving delete_query_fields.
2007-02-16 05:48:02,455 DEBUG 3079568224 LibMySequoia.CarobCommon
(CarobMySQL.cpp:721) - Leaving free_results.
2007-02-16 05:48:02,456 DEBUG 3079568224 LibMySequoia (MySQLAPI.cpp:491)
- Leaving mysql_free_result.
But nothing obviously broken.
Any ideas?
Best,
Paul
--
--------------------------------------------------
-- 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
