Hello,
I am having problems with mysql_install_db. I am running a bleeding-edge Gentoo system (gcc 3.2.1 and glibc 2.3.1, both with some compatibility patches. also running unpatched kernel 2.5.52).
MySQL compiles with no errors or problems, but mysql_install_db will not run correctly. Its output is:
------------------------------------------------------------
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
021217 12:09:26 /usr/sbin/mysqld: Shutdown Complete
[password reminder, license info, etc]
------------------------------------------------------------
My configure options are the typical Gentoo options, although nobody on the Gentoo forums seems to be having the problem that I am:
./configure --prefix=/usr --host=i686-pc-linux-gnu
--mandir=/usr/share/man --infodir=/usr/share/info --datadir=/usr/share
--sysconfdir=/etc --localstatedir=/var/lib --libexecdir=/usr/sbin
--sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --with-raid
--with-low-memory --enable-assembler --with-charset=latin1
--with-mysqld-user=mysql --with-extra-charsets=all
--enable-thread-safe-client --with-client-ldflags=-lstdc++
--with-unix-socket-path=/var/run/mysqld/mysqld.sock
--with-berkeley-db=./bdb --with-readline --enable-shared
--enable-static --with-libwrap --with-innodb --with-vio
--with-openssl --without-debug
I have tried dropping the following options, with no success:
--with-low-memory, --with-berkeley-db, --with-innodb,
--with-vio, --with-openssl
My CFLAGS and CXXFLAGS for the build are as follows:
CFLAGS="-march=athlon-xp -O3 -pipe -fomit-frame-pointer"
CXXFLAGS="-march=athlon-xp -O3 -pipe -fomit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti"
and I have also tried
CFLAGS="-O3"
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
I have tried versions 3.23.52, 3.23.53, 3.23.54a, and 4.0.5-beta. For kicks, I also tried one of the builds while booted into a 2.4 kernel but had the same problem. There is no previous build of MySQL installed, nor are there any databases in the datadir. I am using ext3 partitions, but booting them as ext2 didn't change anything. I don't use NFS or anything like that. From what I can track down, I think the error is being triggered in file sql/table.cc in function openfrm. I can track down the specific conditionals in the function that are being triggered, if that would be helpful. I am at a loss. Any help would be very much appreciated.
Thanks!
Chun
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
