Bug #18469 make test fails on information_schema
Submitted: 23 Mar 2006 19:14 Modified: 7 Apr 2006 14:44
Reporter: Issac Goldstand Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.19 OS:Linux (Linux 2.6.8-2-68)
Assigned to: Sergei Glukhov CPU Architecture:Any

[23 Mar 2006 19:14] Issac Goldstand
Description:
Got the following output from make test:

issac@ark:~/build/mysql-5.0.19$ make test
cd mysql-test ; \
./mysql-test-run && \
./mysql-test-run --ps-protocol
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --based
ir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
--language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --based
ir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     -
-language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
alias                          [ pass ]
alter_table                    [ pass ]
analyse                        [ pass ]
analyze                        [ pass ]
ansi                           [ pass ]
archive                        [ skipped ]
archive_gis                    [ skipped ]
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 ]
bdb_gis                        [ skipped ]
bench_count_distinct           [ pass ]
bigint                         [ pass ]
binary                         [ pass ]
binlog                         [ skipped ]
blackhole                      [ skipped ]
bool                           [ pass ]
bulk_replace                   [ pass ]
case                           [ pass ]
cast                           [ pass ]
check                          [ pass ]
client_xml                     [ pass ]
comments                       [ pass ]
compare                        [ pass ]
compress                       [ pass ]
connect                        [ pass ]
consistent_snapshot            [ pass ]
constraints                    [ pass ]
count_distinct                 [ pass ]
count_distinct2                [ pass ]
count_distinct3                [ pass ]
create                         [ pass ]
create_select_tmp              [ pass ]
csv                            [ skipped ]
ctype_big5                     [ skipped ]
ctype_collate                  [ pass ]
ctype_cp1250_ch                [ skipped ]
ctype_cp1251                   [ pass ]
ctype_cp932                    [ skipped ]
ctype_cp932_binlog             [ skipped ]
ctype_cp932_notembedded        [ skipped ]
ctype_create                   [ pass ]
ctype_eucjpms                  [ skipped ]
ctype_euckr                    [ skipped ]
ctype_gb2312                   [ skipped ]
ctype_gbk                      [ skipped ]
ctype_latin1                   [ pass ]
ctype_latin1_de                [ pass ]
ctype_latin2                   [ pass ]
ctype_many                     [ skipped ]
ctype_mb                       [ pass ]
ctype_recoding                 [ pass ]
ctype_sjis                     [ skipped ]
ctype_tis620                   [ skipped ]
ctype_uca                      [ skipped ]
ctype_ucs                      [ skipped ]
ctype_ucs_binlog               [ skipped ]
ctype_ujis                     [ skipped ]
ctype_utf8                     [ pass ]
date_formats                   [ pass ]
default                        [ pass ]
delayed                        [ pass ]
delete                         [ pass ]
derived                        [ pass ]
dirty_close                    [ pass ]
distinct                       [ pass ]
drop                           [ pass ]
drop_temp_table                [ pass ]
empty_table                    [ pass ]
endspace                       [ pass ]
errors                         [ pass ]
exampledb                      [ skipped ]
explain                        [ pass ]
federated                      [ skipped ]
federated_archive              [ skipped ]
federated_bug_13118            [ skipped ]
flush                          [ pass ]
flush_block_commit             [ pass ]
flush_read_lock_kill           [ skipped ]
flush_table                    [ pass ]
foreign_key                    [ pass ]
fulltext                       [ pass ]
fulltext2                      [ pass ]
fulltext_cache                 [ pass ]
fulltext_distinct              [ pass ]
fulltext_left_join             [ pass ]
fulltext_multi                 [ pass ]
fulltext_order_by              [ pass ]
fulltext_update                [ pass ]
fulltext_var                   [ pass ]
func_compress                  [ pass ]
func_concat                    [ pass ]
func_crypt                     [ pass ]
func_date_add                  [ pass ]
func_default                   [ pass ]
func_des_encrypt               [ skipped ]
func_encrypt                   [ skipped ]
func_encrypt_nossl             [ skipped ]
func_equal                     [ pass ]
func_gconcat                   [ pass ]
func_group                     [ pass ]
func_if                        [ pass ]
func_in                        [ pass ]
func_isnull                    [ pass ]
func_like                      [ pass ]
func_math                      [ pass ]
func_misc                      [ pass ]
func_op                        [ pass ]
func_regexp                    [ pass ]
func_sapdb                     [ pass ]
func_set                       [ pass ]
func_str                       [ pass ]
func_system                    [ pass ]
func_test                      [ pass ]
func_time                      [ pass ]
func_timestamp                 [ pass ]
gcc296                         [ pass ]
gis-rtree                      [ pass ]
gis                            [ pass ]
grant                          [ pass ]
grant2                         [ pass ]
grant3                         [ pass ]
grant_cache                    [ pass ]
greedy_optimizer               [ pass ]
group_by                       [ pass ]
group_min_max                  [ pass ]
handler                        [ pass ]
having                         [ pass ]
heap                           [ pass ]
heap_auto_increment            [ pass ]
heap_btree                     [ pass ]
heap_hash                      [ pass ]
help                           [ pass ]
index_merge                    [ pass ]
index_merge_bdb                [ skipped ]
index_merge_innodb             [ pass ]
index_merge_innodb2            [ pass ]
index_merge_ror                [ pass ]
index_merge_ror_cpk            [ pass ]
information_schema             [ fail ]

Errors are (from /home/issac/build/mysql-5.0.19/mysql-test/var/log/mysqltest-tim
e) :
mysqltest: At line 737: query 'create table t1(a blob, b text charset utf8, c te
xt charset ucs2)' failed: 1115: Unknown character set: 'ucs2'
(the last lines may be the most important ones)

Aborting: information_schema failed in default mode. To continue, re-run with '-
-force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1

How to repeat:
Compiled from source with CFLAGS="-O3 -march=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-const
ructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local --enable-asse
mbler --sysconfdir=/config/mysql --with-unix-socket-path=/var/lib/mysql/mysql.so
ck --localstatedir=/var/lib/mysql --enable-thread-safe-client --enable-local-inf
ile --with-server-suffix=-mirimar --with-mysqld-user=mysql --without-debug --wit
h-embedded-server --with-embedded-privilige-control --with-openssl=/usr/local/ss
l --with-vio --enable-assembler --with-mysql-ldflags=--all-static --with-big-tab
les
[24 Mar 2006 0:03] Hartmut Holzgraefe
i'm getting the same on amd64 with 5.0.19 source and a simple "configure && make && make test",
with latest 5.0bk source i get a timeout with

ctype_ucs                      [ skipped ]
ERROR: /data1/users/hartmut/5.0/mysql-test/var/run/master.pid was not created in 400 seconds;  Aborting
make: *** [test] Error 1

and the same happens when i try to run the information_schema test right away
[30 Mar 2006 4:44] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4306
[7 Apr 2006 7:27] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4594
[7 Apr 2006 7:55] Sergei Glukhov
'information_schema' tes is fixed(5.0.21), 
see also 'Bug #18743 Several test cases fails if "classic" configuration in 5.0' 
for other failed tests
[7 Apr 2006 14:44] Paul DuBois
No changelog entry needed.