completion for 1) while the table creation process is still working( too long ) on the mysql backend node the CPU are aprox 80-90% busy by mysql daemon
on the second test i used the following sql sintax ... and ... the same too long process time CREATE TABLE `testT1` ( `col1` BIGINT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `col2` DOUBLE NOT NULL , `col3` TEXT NOT NULL , `col4` DATETIME NOT NULL , `col5` VARCHAR( 255 ) NOT NULL ) ENGINE = innodb; running this sql from sequoia console it took 0,002 sec for the first 4 time and aprox 60 sec for the 5 time ( between create and drop i wait for aprox 15-10 sec) for 2) i use a sql sintax like this ALTER TABLE `testT1` CHANGE `col3` `col3` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL for 3) i have this log from libmysequoia 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:125) - Entering mysql_init: mysql=0x89df41c 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:57) - Entering constructor; mysql=0x89df41c free_me=0 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:79) - Leaving constructor. 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:150) - Leaving mysql_init: mysql=0x89df41c 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:326) - Entering mysql_options: mysql=0x89df41c option=0 arg=0xbff2c034 2007-04-10 16:45:41,377 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:392) - Leaving mysql_options: result=0 2007-04-10 16:45:41,378 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:264) - Entering mysql_real_connect: : mysql=0x89df41c host= user= passwd= db= 2007-04-10 16:45:41,378 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:121) - Entering connect: host= user= passwd= db= 2007-04-10 16:45:41,378 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1154) - Entering read_ini_file. 2007-04-10 16:45:41,380 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:927) - Entering push_init_command: cmd= 2007-04-10 16:45:41,380 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:930) - Leaving push_init_command. 2007-04-10 16:45:41,380 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1239) - Leaving read_ini_file. 2007-04-10 16:45:41,380 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobCommon.cpp:160) - Entering set_error 2007-04-10 16:45:41,381 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobCommon.cpp:182) - Leaving set_error. 2007-04-10 16:45:41,381 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:144) - Leaving connect: user name missing. 2007-04-10 16:45:41,381 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:279) - Leaving mysql_real_connect: result=0 2007-04-10 16:45:41,382 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:850) - Entering mysql_error: mysql=0x89df41c 2007-04-10 16:45:41,382 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:854) - Leaving mysql_error: result=Invalid use of null pointer 2007-04-10 16:45:41,382 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:838) - Entering mysql_errno: mysql=0x89df41c 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:842) - Leaving mysql_errno: result=2029 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:125) - Entering mysql_init: mysql=0x89df41c 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:84) - Entering destructor. 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1274) - Entering resetPreparedStatment 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1279) - Leaving resetPreparedStatment 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:991) - Entering delete_connection. 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1002) - Leaving delete_connection. 2007-04-10 16:45:41,383 INFO 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:91) - Closing: host= 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:113) - Leaving destructor. 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:57) - Entering constructor; mysql=0x89df41c free_me=0 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:79) - Leaving constructor. 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:150) - Leaving mysql_init: mysql=0x89df41c 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:326) - Entering mysql_options: mysql=0x89df41c option=0 arg=0xbff2bbb4 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:392) - Leaving mysql_options: result=0 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:264) - Entering mysql_real_connect: : mysql=0x89df41c host=127.0.0.1 user=user_test passwd=pass_test db= 2007-04-10 16:45:41,383 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:121) - Entering connect: host=127.0.0.1 user=user_test passwd=pass_test db= 2007-04-10 16:45:41,384 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1154) - Entering read_ini_file. 2007-04-10 16:45:41,384 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:927) - Entering push_init_command: cmd= 2007-04-10 16:45:41,384 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:930) - Leaving push_init_command. 2007-04-10 16:45:41,384 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1239) - Leaving read_ini_file. 2007-04-10 16:45:41,384 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:205) - Connect (adding host): host=127.0.0.1 port=25322 2007-04-10 16:45:41,385 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:991) - Entering delete_connection. 2007-04-10 16:45:41,385 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1002) - Leaving delete_connection. 2007-04-10 16:45:41,385 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:973) - Entering set_connect_info: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 2007-04-10 16:45:41,385 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:985) - Leaving set_connect_info. 2007-04-10 16:45:41,385 INFO 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:222) - Connected: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 persistent_connection=0 ping_delay=0 controller_timeout=0 2007-04-10 16:45:41,385 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:234) - Leaving connect. 2007-04-10 16:45:41,386 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:279) - Leaving mysql_real_connect: result=0x89df41c 2007-04-10 16:45:41,386 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:287) - Entering mysql_select_db: mysql=0x89df41c db=db_test 2007-04-10 16:45:41,386 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:269) - Entering select_db: db=db_test 2007-04-10 16:45:41,386 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:121) - Entering connect: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 2007-04-10 16:45:41,386 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:205) - Connect (adding host): host=127.0.0.1 port=25322 2007-04-10 16:45:41,387 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:991) - Entering delete_connection. 2007-04-10 16:45:41,387 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1002) - Leaving delete_connection. 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:973) - Entering set_connect_info: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:985) - Leaving set_connect_info. 2007-04-10 16:45:41,388 INFO 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:222) - Connected: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 persistent_connection=0 ping_delay=0 controller_timeout=0 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:234) - Leaving connect. 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:298) - Leaving select_db: result=1 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:298) - Leaving mysql_select_db: result=0 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:158) - Entering mysql_close: mysql=0x89df41c 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:84) - Entering destructor. 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1274) - Entering resetPreparedStatment 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1279) - Leaving resetPreparedStatment 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:991) - Entering delete_connection. 2007-04-10 16:45:41,388 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:1002) - Leaving delete_connection. 2007-04-10 16:45:41,389 INFO 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:91) - Closing: host=127.0.0.1 user=user_test passwd=pass_test db=db_test port=25322 2007-04-10 16:45:41,389 DEBUG 3069458112 LibMySequoia.CarobCommon (CarobMySQL.cpp:113) - Leaving destructor. 2007-04-10 16:45:41,389 DEBUG 3069458112 LibMySequoia (MySQLAPI.cpp:165) - Leaving mysql_close. On Tue, 2007-04-10 at 18:11 +0200, Gilles Rayrat wrote: > Hi again. > Please see my last email for the logging. > 1/ I will investigate this later on. Did you try without the myIsam > directive ? > 2/ what is the alter command you are issuing ? > 3/ BigIntegers are supported by both sequoia and carob. There may be > bugs but basically, this is ok > > Gilles. > > > Mihai Costache wrote: > > > > > hi l ist, > > again me !!!! > > > > test env: > > apache 1.3.37 > > php 4.4.6 > > sequoia 2.10.6 > > carob 0.7.3 (or latest from cvs) > > libmysequoia 0.9.8 (or latest from cvs) > > mysql 4.1.22 > > > > 1) the create table process, when this tables have at least one > > column bigint type, it too long ... 5-8 min !!! > > > > --------- example for create table --------- > > CREATE TABLE `testT1` ( `col1` BIGINT( 20 ) NOT NULL , > > `col2` DOUBLE NOT NULL , > > `col3` TEXT NOT NULL , > > `col4` DATETIME NOT NULL , > > `col5` FLOAT NOT NULL , > > `col6` VARCHAR( 255 ) NOT NULL , > > PRIMARY KEY ( `col1` ) ) ENGINE = MYISAM > > > > 2) when i must alterate a table (for example change the type for a > > empty column .. or add auto_increment for an empty column with int > > type .... etc) > > i have the following error > > > > ----- snip ---------- > > 18:25:36,234 WARN controller.virtualdatabase.epayment Request > > '11895' failed (Malformed Alter Request. No drop or add condition) > > 18:25:36,234 WARN > > virtualdatabase.VirtualDatabaseWorkerThread.epayment Error during > > command execution (Malformed Alter Request. No drop or add > > condition) > > ----- snip ---------- > > > > 3) when i want to select from tables with column with bigint type i > > don't see any action ... it not doing nothing and i haven't any log > > from sequoia or libmysequoia .. > > > > > > question: is there any chanse that this weird things to be related > > to some wrong configuration on my test env ? or are some limitation > > of l ibmysequoia ? > > > > > > Thanks, > > Mihai > > > > > > ____________________________________________________________________ > > > > _______________________________________________ > > Carob mailing list > > [email protected] > > https://forge.continuent.org/mailman/listinfo/carob > >
_______________________________________________ Carob mailing list [email protected] https://forge.continuent.org/mailman/listinfo/carob
