[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Hi, I am not an expert,so I do'nt know how to apply the Bruno's fix When I start mysql I get: Sep 11 11:08:52 serv mysql[25802]: Checking for tables which need an up...e Sep 11 11:08:52 serv mysql[25802]: not closed cleanly.. Hint: Some lines were ellipsized, use -l to show in full. I understand I have to Create a newfile /etc/tmpfiles.d/mysql.conf: What does it mean " d /var/run/mysqld 0755 mysql mysql - " ? Delete? Thank You to all mysql experts that can solve this question. Yours Sincerely, Alex -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Hi al, As per tempfile(1) (man tempfile) that line creates a new directory at /var/run/mysqld with 0755 permissions and sets the owner and group to mysql. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
** Changed in: mysql-5.6 (Ubuntu) Status: Confirmed = Fix Committed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
This bug was fixed in the package mysql-5.6 - 5.6.23-1~exp1~ubuntu5
---
mysql-5.6 (5.6.23-1~exp1~ubuntu5) vivid; urgency=medium
* Ubuntu upload from Debian VCS commit 804459b.
mysql-5.6 (5.6.23-1~exp1) UNRELEASED; urgency=medium
[ Robie Basak ]
* New upstream release.
[ Norvald H. Ryeng ]
* Remove unused build options.
* Add libedit dependency to mysql-client-core-5.6.
* Remove chmods not needed after fix for upstream bug #68517.
* Lintian fixes.
[ Bjoern Boschman ]
* Removed hardening-wrapper from build-deps.
* Added python dep for mysql-testsuite-5.6.
* Added dpkg-dev dep.
* Cleanup a bit more.
[ Robie Basak ]
* Add dep8 smoke test.
* Re-enable libmysqld-pic, libmysqld-dev, libmysqlclient18 and
libmysqlclient-dev (renamed accordingly) to replace binary packages
provided by src:mysql-5.5.
* Add mysql-server, mysql-client and mysql-testsuite to be switched
over from src:mysql-5.5.
* Import mysql-common from src:mysql-5.5 for 5.5 - 5.6 switchover.
* Cherry-pick relevant parts of Ubuntu delta from mysql-5.5:
- d/mysql-server-5.5.postrm: restoring postrm debhelper token to get
proper behaviors from dh_installinit and dh_apparmor.
- Add Apport hook.
[ James Page ]
* d/tests/upstream: Add main.ctype_uca to skip-test list as it requires
writable /usr.
* d/p/fix-mysqlhotcopy-test-failure.patch: Add return code 255 to the
list of allowed return codes.
* d/tests/control: Re-enable upstream DEP-8 tests.
[ Otto Kekäläinen ]
* Added parallel build support via DEB_BUILD_OPTIONS
[ Otto Kekäläinen ]
* Remove makeflags from cmake command and output MAKEFLAGS for debugging
purposes just before make is run
[ Akhil Mohan ]
* Provisioned dep8 test case upstream separated to run as non-root
[ Norvald H. Ryeng ]
* Simplify and stabilize tests
* Remove USE_STATIC_MYSQLD
* Add test plan to README.Maintainer
* Add --force rationale to test plan
[ Akhil Mohan ]
* Make builds parallel Use MAKEFLAGS for parallel builds
[ Otto Kekäläinen ]
* Move mysql_plugin to server package as it controls the server plugins
* Wrap-and-sort
* Remove legacy 5.0-5.1 transition code that refers a internal-use-only
-directory that does not even exist anymore.
* Removed all unnecessary .dirs as most of the directories are generated
automatically
* Don't emit extra output at init invocation Many users have complained that
they're database is corrupt because they tried to start the database and it
refuses to do so, and at the same time emitting a message with the word
corrupt. this is just plain wrong and confusing, so I'm removing it.
[ Akhil Mohan ]
* added systemd service profile and script
[ Norvald H. Ryeng ]
* Remove special build options for taocrypt
[ Robie Basak ]
* Drop unused variable definition
* Create /etc/mysql manually in debian/rules
* Replace conf.d/.keepme with an empty directory
[ Akhil Mohan ]
* Standards version moved up to 3.9.6 in d/control
* Added Systemd service profile and script
[ Robie Basak ]
* wrap-and-sort for systemd change
* Drop unnecessary binary target
* Fix race between builds and source tar generation
* Move innochecksum to server package
* Replace unversioned Breaks with Conflicts
* Switch to new /etc/mysql/my.cnf management scheme
[ Akhil Mohan ]
* Refactor supplied my.cnf
[ Robie Basak ]
* Request my.cnf symlink from server package
* Drop mysql-common-5.6
* Conflict and Replace 5.5 server packages
[ Clint Byrum ]
* Changing key_buffer to key_buffer_size (Thanks Akhil Mohan)
(Closes: #777668)
[ Robie Basak ]
* Fix dep8 smoke test dependency
* Amend AppArmor profile to permit reads of everything in /etc/mysql/, now
that we have a number of included directories in there
* Ship my-default.cnf with mysql-server-core-5.6 (LP: #1422391).
* Add mysql-server-core-5.6 Breaks/Replaces older mariadb-client-10.0
since innochecksum has moved into the server package across all
variants (LP: #1421520).
[ Martin Pitt ]
* Call dh --with systemd to enable systemd unit.
[ Robie Basak ]
* AppArmor-related fixes (LP: #1421303):
- d/rules: call dh_apparmor from override_dh_install so that it is run
before dh_installinit. This causes the AppArmor profile to be loaded
correctly before mysqld is started.
- d/mysql-server-5.6.postinst: manually load the AppArmor profile earlier
in the postinst as a workaround, since the postinst needs to start mysqld
for bootstrapping purposes before the dh_apparmor snippet has run
(workaround for bug tracked in LP #1435368).
[ Oleg Strikov ]
* d/mysql-server-5.6.{mysql.service, postinst, postrm}:
Fix to create /var/run/mysql using facilities provided by systemd.
Initialization scripts get executed as user (not root) and don't
have enough permissions to create the folder (LP: #1435823).
*
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Comment #3 works perfect, thank you! -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
** Changed in: mysql-5.6 (Ubuntu) Milestone: None = ubuntu-15.04 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Comment #3 fixed it for me, too. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Comment #3 fixed it for me, too. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
Comment #3 works for me as well. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
@Luca: prego;) I guess that /run/mysqld is not created after boot because in /lib/systemd/mysql.service, mysqld_safe script (which seems to be responsible for its creation) is invoked with user/group mysql/mysql and /run is only writable by root. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
** Changed in: mysql-5.6 (Ubuntu) Importance: Undecided = High ** Tags added: mysql-5.6-transition -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1435823] Re: Disappearing /var/run/mysqld causes mysqld to fail after reboot
** Summary changed: - mysql.service fail to start (mysql-server version: 5.6.23-1~exp1~ubuntu4) + Disappearing /var/run/mysqld causes mysqld to fail after reboot -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1435823 Title: Disappearing /var/run/mysqld causes mysqld to fail after reboot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
