Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
'emerge -u world' killed my mysql server
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
Sylvester
n00b
n00b


Joined: 16 Feb 2003
Posts: 10
Location: Netherlands

PostPosted: Sun Feb 16, 2003 8:53 pm    Post subject: 'emerge -u world' killed my mysql server Reply with quote

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
View user's profile Send private message
Starfox
Tux's lil' helper
Tux's lil' helper


Joined: 04 Sep 2002
Posts: 93

PostPosted: Sun Feb 16, 2003 9:13 pm    Post subject: Re: 'emerge -u world' killed my mysql server Reply with quote

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
View user's profile Send private message
Sylvester
n00b
n00b


Joined: 16 Feb 2003
Posts: 10
Location: Netherlands

PostPosted: Sun Feb 16, 2003 10:41 pm    Post subject: Reply with quote

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
View user's profile Send private message
Starfox
Tux's lil' helper
Tux's lil' helper


Joined: 04 Sep 2002
Posts: 93

PostPosted: Mon Feb 17, 2003 3:15 pm    Post subject: Reply with quote

What about very conservativ:

CFLAGS="-O2"
????
Back to top
View user's profile Send private message
Sylvester
n00b
n00b


Joined: 16 Feb 2003
Posts: 10
Location: Netherlands

PostPosted: Mon Feb 17, 2003 7:01 pm    Post subject: Reply with quote

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
View user's profile Send private message
Sylvester
n00b
n00b


Joined: 16 Feb 2003
Posts: 10
Location: Netherlands

PostPosted: Mon Feb 17, 2003 9:29 pm    Post subject: Reply with quote

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 :cry:
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum