View previous topic :: View next topic |
Author |
Message |
kuteninja n00b
Joined: 07 Sep 2009 Posts: 58
|
Posted: Tue Jul 06, 2010 12:50 pm Post subject: MySQL Hangs |
|
|
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 |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
kuteninja n00b
Joined: 07 Sep 2009 Posts: 58
|
Posted: Tue Jul 06, 2010 6:11 pm Post subject: |
|
|
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 |
|
|
madchaz l33t
Joined: 01 Jul 2003 Posts: 993 Location: Quebec, Canada
|
Posted: Tue Jul 06, 2010 7:05 pm Post subject: |
|
|
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 |
|
|
kuteninja n00b
Joined: 07 Sep 2009 Posts: 58
|
Posted: Tue Jul 06, 2010 8:32 pm Post subject: |
|
|
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 |
|
|
Mad Merlin Veteran
Joined: 09 May 2005 Posts: 1155
|
Posted: Tue Jul 06, 2010 11:37 pm Post subject: |
|
|
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 |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
|