Re: Problems with make test for 4.0.14
Hi again, Does any of you have an idea on this? I get the same error in 4.0.15. I could find that the problematic code was in mysql-test/mysql-test-run.sh: sleep_until_file_created $MASTER_MYPID $wait_for_master wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER MASTER_RUNNING=1 I guess I could probably disable that code from the test program and compile anyway, but would the resulting MySQL installation work? Also, there are currently RPMs of MySQL installed on the server. Should these be removed before compiling? Any help would be greatly appreciated. Pierre-Luc Soucy Pierre-Luc Soucy wrote: Hi, I'm trying to compile MySQL 4.0.14 on a server which was previously using RPMs, and although the ./configure (with no arguments) and make steps went fine, make test does not want to work. The error I am getting is : "/home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting" (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT -- alias [ pass ] alter_table[ pass ] analyse[ pass ] ansi [ pass ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] constraints[ pass ] convert[ pass ] count_distinct [ pass ] count_distinct2[ pass ] create [ pass ] ctype_cp1251 [ pass ] ERROR: /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 [EMAIL PROTECTED] mysql-4.0.14]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with make test for 4.0.14
Hi, I'm trying to compile MySQL 4.0.14 on a server which was previously using RPMs, and although the ./configure (with no arguments) and make steps went fine, make test does not want to work. The error I am getting is : "/home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting" (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT -- alias [ pass ] alter_table[ pass ] analyse[ pass ] ansi [ pass ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] constraints[ pass ] convert[ pass ] count_distinct [ pass ] count_distinct2[ pass ] create [ pass ] ctype_cp1251 [ pass ] ERROR: /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 [EMAIL PROTECTED] mysql-4.0.14]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with merge tables in 4.1
Hi Dan, Ooops, this makes a lot of sense - it works now. Thanks for letting me know about the perror utility, it should help greatly to identify problems in the future. Regards, Pierre-Luc Dan Nelson wrote: In the last episode (Aug 06), Pierre-Luc Soucy said: I was working on some merge tables this morning and it worked fine, but after a few unsuccessful table creation requests (I was making some tests), I could not alter or select from a table for the following reason: mysql> create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries); Query OK, 0 rows affected (0.00 sec) mysql> select * from test_table; ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143) $ perror 143 Error code 143: Unknown error: 143 143 = Conflicting table definitions in sub-tables of MERGE table Does your countries table layout match that of test_table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimization question - enum vs tinyint
Hi, I currently store some boolean values in tinyint(1) unigned fields. When running the procedure analyze on my tables, I am told that the best data type for these fields would be an enum(0,1). Is that true? How is that faster than tinyints? Also, does specifying the length of an integer-type field (say 1 for tinyint) make any difference on speed/storage issues? Thanks, Pierre-Luc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with merge tables in 4.1
Hi, I was working on some merge tables this morning and it worked fine, but after a few unsuccessful table creation requests (I was making some tests), I could not alter or select from a table for the following reason: mysql> create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries); Query OK, 0 rows affected (0.00 sec) mysql> select * from test_table; ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143) mysql> check table test_table; +-+---+--+-+ | Table | Op| Msg_type | Msg_text| +-+---+--+-+ | statscounter.test_table | check | error| Can't open file: 'test_table.MRG'. (errno: 143) | +-+---+--+-+ 1 row in set (0.00 sec) mysql> repair table test_table; +-++--+-+ | Table | Op | Msg_type | Msg_text| +-++--+-+ | statscounter.test_table | repair | error| Can't open file: 'test_table.MRG'. (errno: 143) | +-++--+-+ 1 row in set (0.00 sec) I then dropped the table and attempted to create a new one, with no success. Also tried another table name, or putting the table in another database, and that did not work either. Since it worked earlier, I tried restarting the MySQL server, but that didn't correct the problem either. Do you have any idea of what I'm doing wrong, or what needs to be done to get rid of that error? I thought about submitting a bug report but do not know how this error could be reproduced on another machine. I am running 4.1.0 on dual-CPU debian box with SCSI RAID hard drives, if that can help. Thanks! Pierre-Luc Soucy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]