Marc Herbert wrote:
Maybe you could set the logs to the DEBUG level, try to find something
interesting and post it? Thanks in advance.
Here are the preliminary results. I don't see anything obvious (to me)
in the debug log, but maybe the status codes mean something significant
that I'm not aware of.
Same setup as before; table "foo" does exist, table "bar" does not.
The Ruby session:
$
LD_LIBRARY_PATH=/home/pjlegato/sequoiaTest/libmysequoia/lib:/home/pjlegato/sequoiaTest/carob/
LD_PRELOAD=libmysequoia.so irb
irb(main):001:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
NameError: uninitialized constant Mysql
from (irb):1
from :0
irb(main):002:0> require 'mysql.so'
=> true
irb(main):003:0> x = Mysql.connect "localhost", "sequoia", "sequoia",
"testDB", 25322
=> #<Mysql:0xb76cdbf0>
irb(main):004:0> z = x.query("select * from foo") # produces correct
result
=> #<Mysql::Result:0xb76c05a4>
irb(main):005:0> x.query("select * from bar")
Mysql::Error: Virtual database testDB not found on any of the controllers
from (irb):5:in `query'
from (irb):5
from :0
And the corresponding debug log:
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:188)
- Entering mysql_server_init: argc=0 argv=0 groups=0
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:196)
- Leaving mysql_server_init.
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:109)
- Entering mysql_init: mysql=0x80c5770
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:47) - Entering constructor; mysql=0x80c5770 free_me=0
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:69) - Leaving constructor.
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:134)
- Leaving mysql_init: mysql=0x80c5770
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:245)
- Entering mysql_real_connect: : mysql=0x80c5770 host=localhost
user=sequoia passwd=sequoia db=testDB port=25322
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:111) - Entering connect: host=localhost user=sequoia
passwd=sequoia db=testDB port=25322
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:1144) - Entering read_ini_file.
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:917) - Entering push_init_command: cmd=
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:920) - Leaving push_init_command.
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:1229) - Leaving read_ini_file.
2007-02-13 05:52:59,753 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:195) - Connect (adding host): host=localhost port=25322
2007-02-13 05:52:59,931 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:981) - Entering delete_connection.
2007-02-13 05:52:59,931 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:992) - Leaving delete_connection.
2007-02-13 05:52:59,931 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:963) - Entering set_connect_info: host=localhost
user=sequoia passwd=sequoia db=testDB port=25322
2007-02-13 05:52:59,932 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:975) - Leaving set_connect_info.
2007-02-13 05:52:59,932 INFO 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:212) - Connected: host=localhost user=sequoia
passwd=sequoia db=testDB port=25322 persistent_connection=0 ping_delay=0
controller_timeout=0
2007-02-13 05:52:59,932 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:224) - Leaving connect.
2007-02-13 05:52:59,932 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:260)
- Leaving mysql_real_connect: result=0x80c5770
2007-02-13 05:53:06,761 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:426)
- Entering mysql_real_query: mysql=0x80c5770 query=select * from foo
length=17
2007-02-13 05:53:06,761 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:306) - Entering real_query: query=select * from foo
length=17
2007-02-13 05:53:06,761 INFO 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:308) - Executing query=select * from foo length=17
2007-02-13 05:53:07,065 INFO 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:385) - Executed query with result set. Field_count=2
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:406) - Leaving real_query: result=1
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:435)
- Leaving mysql_real_query: result=0
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:730)
- Entering mysql_field_count: mysql=0x80c5770
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:734)
- Leaving mysql_field_count: result=2
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:469)
- Entering mysql_store_result: mysql=0x80c5770
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:455) - Entering get_results: fetch_all=1
2007-02-13 05:53:07,065 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobCommon.cpp:45) - Entering get_query_fields: result=0rsmPtr=0xbfe7f10c
2007-02-13 05:53:07,066 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobCommon.cpp:98) - Leaving get_query_fields: result=2
2007-02-13 05:53:07,066 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:532) - Leaving get_results: result=0x809b4b0
2007-02-13 05:53:07,067 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:478)
- Leaving mysql_store_result: result=0x809b4b0
2007-02-13 05:55:40,972 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:426)
- Entering mysql_real_query: mysql=0x80c5770 query=select * from bar
length=17
2007-02-13 05:55:40,972 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:306) - Entering real_query: query=select * from bar
length=17
2007-02-13 05:55:40,972 INFO 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:308) - Executing query=select * from bar length=17
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobCommon.cpp:160) - Entering set_error
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobCommon.cpp:182) - Leaving set_error.
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia.CarobCommon
(CarobMySQL.cpp:418) - Leaving real_query: result=0
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:435)
- Leaving mysql_real_query: result=1
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:830)
- Entering mysql_error: mysql=0x80c5770
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:834)
- Leaving mysql_error: result=Virtual database testDB not found on any
of the controllers
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:818)
- Entering mysql_errno: mysql=0x80c5770
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:822)
- Leaving mysql_errno: result=2000
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:842)
- Entering mysql_sqlstate: mysql=0x80c5770
2007-02-13 05:55:40,977 DEBUG 3078916960 LibMySequoia (MySQLAPI.cpp:846)
- Leaving mysql_sqlstate: result=HY000
--
--------------------------------------------------
-- 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
