Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
MySQL Hangs
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Kernel & Hardware
View previous topic :: View next topic  
Author Message
kuteninja
n00b
n00b


Joined: 07 Sep 2009
Posts: 58

PostPosted: Tue Jul 06, 2010 12:50 pm    Post subject: MySQL Hangs Reply with quote

I know MySQL is not hardware, but I believe that this hangs are because some hardware related issue...

This is the output from dmesg: http://pastebin.com/rSKrpDFE

And this is the usual information:

- emerge --info: http://pastebin.com/vvWQpsxG
- uname -a: Linux sql16 2.6.30-gentoo-r2 #1 SMP Mon Jul 6 04:45:28 Local time zone must be set--see zic m x86_64 Pentium(R) Dual-Core CPU E5200 @ 2.50GHz GenuineIntel GNU/Linux
- make.conf: http://pastebin.com/q6ZFA3Rr

I don't know where to start looking... could you give me a hint ?

- It could be the hard drive...
- The memorys might be failing...
- Maybe it's just the reiserfs journal service...
- Is it kernel / software related ?
Back to top
View user's profile Send private message
audiodef
Watchman
Watchman


Joined: 06 Jul 2005
Posts: 6639
Location: The soundosphere

PostPosted: Tue Jul 06, 2010 2:53 pm    Post subject: Reply with quote

If MySQL is the only program giving you this kind of problem, then something is wrong with MySQL. If you had hardware trouble, your entire system would be screwy. I don't think it's reiser. I've used MySQL with reiserfs.

Maybe try re-emerging MySQL.

You've got ~arch. Sync, world update and switch to gcc 4.4.4, then emerge -e world. If nothing else, it should smooth things out a bit overall.
_________________
decibel Linux: https://decibellinux.org
Github: https://github.com/Gentoo-Music-and-Audio-Technology
Facebook: https://www.facebook.com/decibellinux
Discord: https://discord.gg/73XV24dNPN
Back to top
View user's profile Send private message
kuteninja
n00b
n00b


Joined: 07 Sep 2009
Posts: 58

PostPosted: Tue Jul 06, 2010 6:11 pm    Post subject: Reply with quote

audiodef wrote:
Maybe try re-emerging MySQL.


I've not touched this server for like months, there has been not any software changes lately.
Although, there seems to be a newer version of MySQL... it wouldn't hurt to try...

I'll give an update soon if it keeps failing.
Back to top
View user's profile Send private message
madchaz
l33t
l33t


Joined: 01 Jul 2003
Posts: 993
Location: Quebec, Canada

PostPosted: Tue Jul 06, 2010 7:05 pm    Post subject: Reply with quote

you're getting page faults and an out of memory at the end. Sounds like mysql is going into an infinite loop somewhere. If you follow processes while it tries to start, you see it spawning a shitload of them?
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it.
www.madchaz.com A small candle of a website. As my lab specs on it.
Back to top
View user's profile Send private message
kuteninja
n00b
n00b


Joined: 07 Sep 2009
Posts: 58

PostPosted: Tue Jul 06, 2010 8:32 pm    Post subject: Reply with quote

kuteninja wrote:
I'll give an update soon if it keeps failing.

Well, after an "emerge -Du portage mysql" to update the services, it seems to be a bit more stable now.
I'll try a kernel update too, but thanks :)
Back to top
View user's profile Send private message
Mad Merlin
Veteran
Veteran


Joined: 09 May 2005
Posts: 1155

PostPosted: Tue Jul 06, 2010 11:37 pm    Post subject: Reply with quote

Actually, it sounds like you're running out of memory and swapping yourself to death. Eventually the OOM killer kills the offending process (mysqld). Check your mysql config, you're probably letting it use more memory than you have.
_________________
Game! - Where the stick is mightier than the sword!
Back to top
View user's profile Send private message
audiodef
Watchman
Watchman


Joined: 06 Jul 2005
Posts: 6639
Location: The soundosphere

PostPosted: Wed Jul 07, 2010 12:46 pm    Post subject: Reply with quote

kuteninja wrote:
kuteninja wrote:
I'll give an update soon if it keeps failing.

Well, after an "emerge -Du portage mysql" to update the services, it seems to be a bit more stable now.
I'll try a kernel update too, but thanks :)


If you want to update your kernel, check out Pappy's Kernel Seeds.
_________________
decibel Linux: https://decibellinux.org
Github: https://github.com/Gentoo-Music-and-Audio-Technology
Facebook: https://www.facebook.com/decibellinux
Discord: https://discord.gg/73XV24dNPN
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Kernel & Hardware 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