MySQL dies during hard work

Question

I have a MySQL database installed on a OpenSuse 11.1 server (it is a Bitnami image).

The database works fine, it can stay many days without any error, but when MySQL receives a huge amount of transactions, it dies immediately. The next screen shows the error:

screenshot of the error

Moreover, I don't know how to restart MySQL. I have tried this:

/opt/bitnami/mysql/bin/mysqld start

But it doesn't work, that gives me the next output:

110209 17:09:01 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

110209 17:09:01 [ERROR] Aborting

110209 17:09:01 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete

It doesn't matter which kind of statements are executing, if they are a huge amount, MySQL dies. The MySQL server version is 5.1.30

What can be causing these sudden failures?

Are you running out of memory (real plus swap) and the OOM-Killer (out-of-memory killer) is killing your MySQL server processes? — David Mackintosh, Feb 09 '11 at 22:17
To find out if the OOM-Killer is killing it, check /var/log/syslog or /var/log/kern.log for messages about being out of memory and invoking oom-killer. — DerfK, Feb 09 '11 at 23:43
If you'd copied and pasted the actual text instead of taking a screen shot it might have been a lot easier to read. — John Gardeniers, Feb 09 '11 at 23:45
@Mark I don't understand the error and I don't know how to solve it. That's why I called Creepy, sorry, I will remove it. — kiewic, Feb 10 '11 at 13:23
@Kiewic - it's OK you don't have to remove it, I was just curious. It's most likely a cultural difference ;) — Mark Henderson, Feb 10 '11 at 19:34

score 1 · Answer 1 · answered Feb 09 '11 at 22:29

It means what it says: MySQL won't run as the root user for security reasons. The init script for MySQL contains some magic to make it run as an unprivileged user. The documentation I found says this is what you want to run:

/opt/bitnami/ctlscript.sh restart mysql

score 1 · Answer 2 · answered Feb 09 '11 at 22:31

1

Hypothesis: OOMKiller is killing your mysql daemon because you're near to out of memory.

Fact: You can't start mysqld directly as root; see [mysqlroot]/bin/mysqld_safe for a daemon wrapper you can start as root.

answered Feb 09 '11 at 22:31

Jeff Albert

1,987
9
14

MySQL dies during hard work

2 Answers2