Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 490618 - dev-db/mysql-init-scripts-2.0_pre1-r6 - mysqld.service: Failed to start MySQL database server.
Summary: dev-db/mysql-init-scripts-2.0_pre1-r6 - mysqld.service: Failed to start MySQL...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Server (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-06 21:36 UTC by C. Wijtmans
Modified: 2013-11-08 18:02 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description C. Wijtmans 2013-11-06 21:36:19 UTC
neither mysql_safe or mysql_wait_ready exist but the service file is linking them.
Comment 1 C. Wijtmans 2013-11-06 21:38:03 UTC
also i would like to note that After=network.target should be removed since mysql can be used locally, it doesnt require the network to operate and booting before ore after network serving should make no difference?
Comment 2 Brian Evans (RETIRED) gentoo-dev 2013-11-07 13:38:46 UTC
(In reply to C.J. Wijtmans from comment #1)
> also i would like to note that After=network.target should be removed since
> mysql can be used locally, it doesnt require the network to operate and
> booting before ore after network serving should make no difference?

I would like to note that this should not be removed because of the potential to hang the server.

MySQL expects every interface that it is configured to be available on startup.
If you bind it to 192.168.0.1 and that interface is not up, it will hang trying to bind to it.

Now this may clear up since systemd is in parallel, but I've never tested if the binding clears if the network is started later.
Comment 3 C. Wijtmans 2013-11-08 08:21:20 UTC
hmm that is true i guess? i will edit the service file to work today.
Comment 4 C. Wijtmans 2013-11-08 08:22:10 UTC
well. what happens if you have no network service will mysql hang/fail?
Comment 5 C. Wijtmans 2013-11-08 17:20:25 UTC
okay, the binaries actually exist.

Unit mysqld.service has begun starting up.
Nov 08 17:56:24 HTPC systemd[1]: mysqld.service start request repeated too quick
Nov 08 17:56:24 HTPC systemd[1]: Failed to start MySQL database server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02c
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Nov 08 17:56:24 HTPC systemd[1]: Unit mysqld.service entered failed state.
Comment 6 C. Wijtmans 2013-11-08 18:02:59 UTC
yeah just ignore my stupidity.
/var/log/mysql did not exist then i created it and it had the wrong permissions.