Bug #13105 ctype_ucs_binlog fails on RH ia64
Submitted: 10 Sep 2005 16:36 Modified: 14 Sep 2005 6:40
Reporter: John Leonard Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.12 OS:Linux (Red Hat Enterprise Linux AS 3)
Assigned to: CPU Architecture:Any

[10 Sep 2005 16:36] John Leonard
Description:
Hi,

The ctype_ucs_binlog test fails for me when I do the recommended build (see steps to repeat).  If I do a standard build (no config optons) MySQL make and make test run fine, but I get a core dump after entering password when I try to run the mysql client.

In order to pass commands to mysql, I have been redirecting commands written to files like this (which works):
/usr/local/mysql/bin/mysql -u root -p < command.sql

Details of test failure:
ctype_ucs_binlog               [ fail ]

Errors are (from /installs/mysql/mysql-4.1.12/mysql-test/var/log/mysqltest-time) :
/installs/mysql/mysql-4.1.12/client/.libs/mysqltest: At line 21: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ctype_ucs_binlog.result   2005-05-13 15:04:01.000000000 +0300
--- r/ctype_ucs_binlog.reject   2005-09-10 18:41:47.000000000 +0300
***************
*** 8,14 ****
  master-bin.000001     79      User var        1       79      @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci
  master-bin.000001     119     Query   1       119     use `test`; insert into t2 values (@v)
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
! SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`;
  use test;
  SET TIMESTAMP=10000;
  insert into t2 values (@v);
--- 8,14 ----
  master-bin.000001     79      User var        1       79      @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci
  master-bin.000001     119     Query   1       119     use `test`; insert into t2 values (@v)
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
! SET @`v`:=???;
  use test;
  SET TIMESTAMP=10000;
  insert into t2 values (@v);
-------------------------------------------------------

Example of core dump:
/usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26106 to server version: 4.1.12

Segmentation fault

Please help, and thanks in advance!

John

How to repeat:
CC=gcc \
CFLAGS="-O3 -fno-omit-frame-pointer" \
CXX=gcc \
CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors \
    -fno-exceptions -fno-rtti" \
    ./configure --prefix=/usr/local/mysql \
    "--with-comment=Official MySQL binary" \
    --with-extra-charsets=complex

make && make test

Suggested fix:
I believe the problem may lie with character sets, but I do not know enough about them to help.  For a perl module install of LWP before, I had to get rid of any UTF-8 in the env, so 

export LANG=en_IE

had to be set prior to making.  I have tried this for mysql but no luck.
[12 Sep 2005 8:10] John Leonard
(forgot to set severity level)
[12 Sep 2005 13:49] Valeriy Kravchuk
Have you tried to run this test on a newer version of MySQL, 4.1.14? Is it still fails?
[12 Sep 2005 15:47] John Leonard
Hi Valeriy,

Thanks for replying.  I used 4.1.12 because it was listed beside RH Enterprise Edition 3.0 in the downloads.  I just tried 4.1.14 and make test fails on archive:

TEST                            RESULT
-------------------------------------------------------

alias                           [ pass ]
alter_table                     [ pass ]
analyse                         [ pass ]
analyze                         [ pass ]
ansi                            [ pass ]
archive                         [ fail ]
Errors are (from /installs/mysql/mysql-4.1.14/mysql-test/var/log/mysqltest-time) :
This test is not supported by this installation
mysqltest returned unexpected code 15872, it has probably crashed
(the last lines may be the most important ones)

Aborting: archive failed. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon

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

Any ideas??

Thanks,
    John
[13 Sep 2005 7:24] Valeriy Kravchuk
This "archive" test failure has nothing to do with the original issue tyou pointed out. This failure simply means that ARCHIVE storage engine is not supported by the binary you used (try to use Max version instead if this is really needed, see http://dev.mysql.com/downloads/mysql/4.1.html).

Please, rerun your test with --force option, as suggested, fgor us to be able to verify the failure of ctype_ucs_binlog test.
[13 Sep 2005 9:24] John Leonard
Valeriy,

Sorry about this, 4.1.14 passes on ctype_ucs_binlog.  I have one additional question though, usually when I run make test for unsupported tests, I get [skipped] however on this it actually fails - any ideas?

Thanks for all your help so far,
John
[14 Sep 2005 6:40] Valeriy Kravchuk
Testing yesterday's build of 4.1.15-BK just shown me archive test as [skipped], so it may be just a problem in a test suit.

I'll mark this report as "can't repeat" on 4.1.14 and suggest you to open a new bug report if 4.1.15 (when officially released) will fail on archive test with the same messages.