MySQL Bugs: #30313: ERROR: 1193 Unknown system variable 'table

Bug #30313	ERROR: 1193 Unknown system variable 'table_type'
Submitted:	8 Aug 2007 16:02	Modified:	10 Feb 2008 20:55
Reporter:	Benjamin DUPUIS	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	4.1.19 to 4.1.22 and 5.0.41, 5.0.45	OS:	IBM AIX (5.3)
Assigned to:		CPU Architecture:	Any
Tags:	ERROR: 1193 Unknown system variable 'table_type'

Description:
After successfull compilation; I cannot create system tables :
I've been searching since some days on google but not finding ...

./mysql_install_db
Installing all prepared tables
ERROR: 1193  Unknown system variable 'table_type'
070808 17:46:37 [ERROR] Aborting
070808 17:46:37 [Note] /ibp/uti/msq/4.1.22/bin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /ibp/uti/msq/4.1.22/var for more information.

How to repeat:
Here are option for compilation; i've tryed with and without the -mcpu option :

CC="gcc -pipe -mcpu=power -Wa,-many"
CXX="gcc -pipe -mcpu=power -Wa,-many"
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti"
export CC CXX CXXFLAGS

make clean
./configure \
--prefix=${MYSQL_DIR} \
--localstatedir=${MYSQL_DIR}/var \
--sysconfdir=${MYSQL_DIR}/etc \
--sbindir=${MYSQL_DIR}/bin \
--libexecdir=${MYSQL_DIR}/bin \
--with-low-memory \
--enable-thread-safe-client \
--enable-large-files \
--enable-local-infile \
--without-debug \
--without-bench \
--without-man \
--with-isam \
--with-zlib-dir=${ZLIB_DIR} \
--with-openssl=${OPENSSL_DIR}

Software version :
zlib-1.2.3
openssl-0.9.8e
powerpc-ibm-aix5.3.0.0-gcc-4.0.2

Thank you for a problem report. Please, try to repeat with a newer versions, 4.1.23 and 5.0.45, and inform about the results.

I don't find 4.1.23 on your website and on http://mirrors.ircam.fr/pub/mysql/Downloads/MySQL-4.1/
Where can I find it ?

Trying in 5.0.45.

Best regards,

with mysql 5.0.45 I ve got this error :

./mysql_install_db[283]: 225462 Memory fault(coredump)
Installation of system tables failed!
Examine the logs in /ibp/uti/msq/5.0.45/var for more information.
You can try to start the mysqld daemon with:

There is no log on /ibp/uti/msq/5.0.45.
directories var/mysql and var/test are created but are empty.

If i relaunch mysql_install_db i've got this error
/ibp/uti/msq/5.0.45/bin:root# ./mysql_install_db
Installing MySQL system tables...
./mysql_install_db[283]: 430270 Memory fault(coredump)
Installation of system tables failed!

Here are report of mysqlbug>Release:       mysql-5.0.45 (Source distribution)

>C compiler:    gcc (GCC) 4.0.2
>C++ compiler:  gcc (GCC) 4.0.2
>Environment:
        <machine, os, target, libraries (multiple lines)>
System: AIX ibifai2a 3 5 00CCBE6F4C00

Some paths:  /usr/bin/perl /usr/bin/make /opt/freeware/gcc/gcc/bin/gcc
GCC: Using built-in specs.
Target: powerpc-ibm-aix5.3.0.0
Configured with: ../gcc-4.0.2/configure --disable-nls
Thread model: aix
gcc version 4.0.2
Compilation info: CC='gcc -pipe -mcpu=power -Wa,-many'  CFLAGS=''  CXX='gcc -pipe -mcpu=power -Wa,-many'  CXXFLAGS='-felide
-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx   1 bin      bin              19 Apr 13 2006  /lib/libc.a -> /usr/ccs/lib/libc.a
lrwxrwxrwx   1 bin      bin              19 Apr 13 2006  /usr/lib/libc.a -> /usr/ccs/lib/libc.a

Thank you for the report.

I can not repeat described behaviour in my environment. Please try to run `mysql_install_db --no-defaults` and say us result.

Hello,

I have same error; and no log.

/ibp/uti/msq/5.0.45/bin:root# ./mysql_install_db --no-defaults
Installing MySQL system tables...
./mysql_install_db[283]: 2027772 Memory fault(coredump)
Installation of system tables failed!

Have you got AIX 5.3 ? 
I saw same error in this thread http://bugs.mysql.com/bug.php?id=19677
 
Thanks for help

Thank you for the feedback, but with --no-defaults option you get different error from initial description.

About error same as in Bug #19677. 

Bug #19677 has been tested on AIX 5.2. We currently have not AIX 5.3

Have you tried current version 5.0.45? If not, please do and say us result.

Yes I am in 5.0.45 since "[9 Aug 10:19] Benjamin DUPUIS"

Best regards

Please, send the results of:

gcc --version 

from your AIX 5.3 system.

gcc (GCC) 4.0.2
Copyright (C) 2005 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Best regards,

Please, try to repeat with 5.0.51a and inform about the results.

We now have a working compilation.

We remove "-mcpu=power" from CC and CXX
We add --with-charset=latin1 to the ./configure

Here are all flags set :

CC="gcc -pipe -Wa,-many"
CXX="gcc -pipe -Wa,-many"
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti"
export CC CXX CXXFLAGS

./configure \
--prefix=${MYSQL_DIR} \
--localstatedir=${MYSQL_DIR}/var \
--sysconfdir=${MYSQL_DIR}/etc \
--sbindir=${MYSQL_DIR}/bin \
--libexecdir=${MYSQL_DIR}/bin \
--with-low-memory \
--enable-thread-safe-client \
--enable-large-files \
--enable-local-infile \
--without-debug \
--without-bench \
--without-man \
--with-isam \
--with-zlib-dir=${ZLIB_DIR} \
--with-charset=latin1 \
--with-extra-charsets=all \
--with-openssl=${OPENSSL_DIR}

Working (see last msg)