View previous topic :: View next topic |
Author |
Message |
Sylvester n00b
Joined: 16 Feb 2003 Posts: 10 Location: Netherlands
|
Posted: Sun Feb 16, 2003 8:53 pm Post subject: 'emerge -u world' killed my mysql server |
|
|
Today I did a emerge -u world, and now my mysql (3.23.54a) server doesn't work anymore
All my update queries don't work anymore and when I create a new table i get ERROR: 1033 Incorrect information in file: './mysql/<table>.frm'
So I First thought it had something to do with the upgrade, so I removed the currect datebase and tried to create a new one:
/usr/bin/mysql_install_db
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'
030216 21:40:50 /usr/sbin/mysqld: Shutdown Complete
But it gave the same errors.
I did read some topics from people who had the same problems, but they all used a AMD processors, and I use a Intel P4.
I must say that the update also replaced gcc 3.2 with gcc 3.2.1.
I saw in the cvs that there is allready a 3.23.55, I just compiled that version, but it gaves the same problem.
Version 3.23.53 with gcc 3.2 did work.
What can I do to fix this problem ? |
|
Back to top |
|
|
Starfox Tux's lil' helper
Joined: 04 Sep 2002 Posts: 93
|
Posted: Sun Feb 16, 2003 9:13 pm Post subject: Re: 'emerge -u world' killed my mysql server |
|
|
Sylvester wrote: |
I did read some topics from people who had the same problems, but they all used a AMD processors, and I use a Intel P4.
What can I do to fix this problem ? |
Have you tried your build without -fomit-frame-pointer???
Or without -march=X ???
Maybe you should try this!
bye fox |
|
Back to top |
|
|
Sylvester n00b
Joined: 16 Feb 2003 Posts: 10 Location: Netherlands
|
Posted: Sun Feb 16, 2003 10:41 pm Post subject: |
|
|
Ok, I changed the CFLAGS in make.conf but I still get the errors.
Flags that I tryed:
CFLAGS="-O3 -pipe"
CFLAGS="-march=pentium4 -O3 -pipe"
CFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer"
CFLAGS="-O3 -pipe -fomit-frame-pointer"
Any other sugestions ? |
|
Back to top |
|
|
Starfox Tux's lil' helper
Joined: 04 Sep 2002 Posts: 93
|
Posted: Mon Feb 17, 2003 3:15 pm Post subject: |
|
|
What about very conservativ:
CFLAGS="-O2"
???? |
|
Back to top |
|
|
Sylvester n00b
Joined: 16 Feb 2003 Posts: 10 Location: Netherlands
|
Posted: Mon Feb 17, 2003 7:01 pm Post subject: |
|
|
I just tryed that, but during compiling I still see -O3 instead of -O2.
Can it be something with the Glibc 3.2.1 ? I saw there are more people with problems. |
|
Back to top |
|
|
Sylvester n00b
Joined: 16 Feb 2003 Posts: 10 Location: Netherlands
|
Posted: Mon Feb 17, 2003 9:29 pm Post subject: |
|
|
Ok, I allready compiled gcc 3.2.1 again, gcc-config etc, but after compiling mysql, I still get the same error when I want to create the database |
|
Back to top |
|
|
|