Bug #6351 make test failure "Unknown character set"
Submitted: 31 Oct 2004 19:20 Modified: 5 Nov 2004 6:15
Reporter: David Dick Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S2 (Serious)
Version:4.1.7 OS:
Assigned to: Alexander Barkov CPU Architecture:Any

[31 Oct 2004 19:20] David Dick
Description:
i unpacked the mysql-4.1.7.tar.gz source distribution and attempted to compile it on a Red Hat Linux release 7.3 (Valhalla) system with a 2.4.20 kernel.  make test failed with the following error.

*snip*
packet                         [ pass ]
preload                        [ pass ]
ps                             [ fail ]

Errors are (from /home/dave/mysql-4.1.7/mysql-test/var/log/mysqltest-time) :
/home/dave/mysql-4.1.7/client/.libs/mysqltest: At line 114: query 'set @str2 = convert(@str1 using ucs2)' failed: 1115: Unknown character set: 'ucs2'
(the last lines may be the most important ones)

Aborting: ps failed. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
[dave@matrix mysql-4.1.7]$ uname -a
Linux localhost.localdomain 2.4.20 #8 Fri May 30 07:11:23 EST 2003 i686 unknown
[dave@matrix mysql-4.1.7]$

i have no idea what the "ucs" character set is.  if i run a "set | grep -i ucs" nothing is returned.

How to repeat:
tar -zxf mysql-4.1.7.tar.gz
./configure
make
make test
[31 Oct 2004 20:16] David Dick
details about ps version

$ ps --help
********* simple selection *********  ********* selection by list *********
-A all processes                      -C by command name
-N negate selection                   -G by real group ID (supports names)
-a all w/ tty except session leaders  -U by real user ID (supports names)
-d all except session leaders         -g by session leader OR by group name
-e all processes                      -p by process ID
T  all processes on this terminal     -s processes in the sessions given
a  all w/ tty, including other users  -t by tty
g  all, even group leaders!           -u by effective user ID (supports names)
r  only running processes             U  processes for specified users
x  processes w/o controlling ttys     t  by tty
*********** output format **********  *********** long options ***********
-o,o user-defined  -f full            --Group --User --pid --cols
-j,j job control   s  signal          --group --user --sid --rows
-O,O preloaded -o  v  virtual memory  --cumulative --format --deselect
-l,l long          u  user-oriented   --sort --tty --forest --version
                   X  registers       --heading --no-heading
                    ********* misc options *********
-V,V show version       L  list format codes  f  ASCII art forest
-m,m show threads       S  children in sum    -y change -l format
-n,N set namelist file  c  true command name  n  numeric WCHAN,UID
-w,w wide output        e  show environment   -H process heirarchy
$ ps --version
procps version 2.0.7
[1 Nov 2004 12:05] MySQL Verification Team
Thank you for the bug report. I was able to repeat on my
Slackware box too.
[4 Nov 2004 5:23] Brian Wright
I can confirm this problem on Fedora Core 2:

packet                         [ pass ]
preload                        [ pass ]
ps                             [ fail ]
 
Errors are (from /root/mysql-4.1.7/mysql-test/var/log/mysqltest-time) :
/root/mysql-4.1.7/client/.libs/mysqltest: At line 114: query 'set @str2 = convert(@str1 using ucs2)' failed: 1115: Unknown character set: 'ucs2'
(the last lines may be the most important ones)
 
Aborting: ps failed. To continue, re-run with '--force'.
 
Ending Tests
Shutting-down MySQL daemon