MySQL Not Starting

tsc

@tsc said: `Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

invoke-rc.d: initscript mysql, action "start" failed.`

That's basically what it shows, the rest is dpkg errors. No errors are logged to any log files, so I have no idea WHY it failed at all.

It appears other users on Dotdeb are reporting the same thing (at least in the initial 5.5 release post).

-

@tsc said: That shouldn't be the problem, since LES loads a skip-innodb into conf.d, but I did find something after trying to install another package:

120112 2:39:30 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/

120112 2:39:30 [ERROR] Use --lc-messages-dir without language specific part instead.
120112 2:39:30 [Note] Plugin 'FEDERATED' is disabled.
120112 2:39:30 [Note] Plugin 'InnoDB' is disabled.
120112 2:39:30 [ERROR] Unknown/unsupported storage engine: InnoDB
120112 2:39:30 [ERROR] Aborting

120112 2:39:30 [Note] /usr/sbin/mysqld: Shutdown complete

Tried editing my.cnf to add the directive directly, but that failed too.

yomero

I have this lines in my.cnf

skip-innodb
default-storage-engine=MyISAM

Damian

What version of 5.5 are you on? http://bugs.mysql.com/bug.php?id=55608

To disable InnoDB, use --innodb=OFF or --skip-innodb. In this case, because the default storage engine is InnoDB, the server will not start unless you also use --default-storage-engine to set the default to some other engine.

Try changing skip-innodb to ignore-builtin-innodb: http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb

(edit: yomero's fix is probably better)

dmmcintyre3

add
default-storage-engine = myisam
ignore_builtin-innodb
to your config.

tsc

Well, it started (with the default-storage-engine and ignore-builtin-innodb). Now why it wouldn't start even if all of those configs were removed (enabling InnoDB and keeping it default) is beyond me.

I'm installing from Dotdeb latest (5.5.19 I believe). It appears that this is going to happen with most LES scripts at the moment.

Thanks for the help!

vedran

Oh, wow! 3 almost identical replies in one minute, that's geat ^^

@tsc said: Now why it wouldn't start even if all of those configs were removed (enabling InnoDB and keeping it default) is beyond me.

Not enough RAM?

tsc

Well, by that I meant I would have expected it to log OOM errors, but it didn't.

yomero

@tsc said: Well, by that I meant I would have expected it to log OOM errors, but it didn't.

I've never seen one of these. Where they get logged? And in OpenVZ servers?

tsc

Eh, I don't know if MySQL even does report those kinds of errors (git reports malloc() fails, at least), but that's because I'm inexperienced and I would expect good design to include reporting out-of-memory errors instead of failing without any notice.

vedran

Have you checked the logs?

tsc

Logs show up empty when it failed. That's what perplexed me.

dmmcintyre3

Are any failcnt values above 0 in /proc/user_beancounters?

tsc

privvmpages is at 87. Considering how many times I tried reinstalling it, I'm not quite surprised.

TigersWay

@yomero said: I have this lines in my.cnf

skip-innodb
default-storage-engine=MyISAM

And you are right :-) The purpose of ignore-builtin-innodb is different.
http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html#id508757
http://dev.mysql.com/doc/refman/5.5/en/innodb-configuration.html#id1060396

tsc

Eh, another problem. MySQLd refuses to stop for some reason:

Stopping MySQL database server: mysqld failed!
Starting MySQL database server: mysqld already running.

I'm guessing it's because debian-sys-maint is never created properly during the installation because the server never starts properly. This is becoming too complicated...

yomero

Yes, let me see..

Start mysql and do an

mysql -u root

Then do this

CREATE USER 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password_in debian.cnf';
GRANT SHUTDOWN ON *.* TO 'debian-sys-maint'@'localhost';
GRANT SELECT ON `mysql`.`user` TO 'debian-sys-maint'@'localhost';

Where debian.cnf is the file in /etc/mysql/debian.cnf

tsc

All right. It's actually working now.

I wonder what's going to happen with LE scripts (like LES and Minstall), though, because that's really complicated to work around - either you have to create configuration files before install or do all of these steps after install.

yomero

Heh, well, IMHO isn't complicated :P

Probably they will update this later

TigersWay

@tsc said: either you have to create configuration files before install or do all of these steps after install

Create configuration files before installing is - sometimes at least - not a good idea... But there is an official way to install without the autostart procedure (other scripts exist), and it seems to be working fine so far.

yomero

Yes, click on the signature link of TigersWay

Look for this

cat > /usr/sbin/policy-rc.d <<EOF
#!/bin/sh
exit 101
EOF

tsc

It works. My mind has been blown.