FS#31127 - MySQL 5.5.27-2 breaks under systemd

Attached to Project: Arch Linux
Opened by Joseph Yaworski (jyaworski) - Tuesday, 14 August 2012, 20:02 GMT
Last edited by Andrea Scarpino (BaSh) - Wednesday, 15 August 2012, 15:05 GMT
Task Type Bug Report
Category Packages: Testing
Status Closed
Assigned To Andrea Scarpino (BaSh)
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description: Mysqld fails to start with the systemd service file. This happened after the update. Previously, using the files on the Archwiki produced no problems.


Additional info:
* Version 5.5.27-2
* config and/or log files etc.
[root@Licht run]# systemctl status mysqld.service
mysqld.service - MySQL Server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled)
Active: deactivating (stop-sigterm) (Result: exit-code)
Process: 7060 ExecStartPost=/usr/bin/mysqld-post (code=exited, status=203/EXEC)
Main PID: 7059 (mysqld)
CGroup: name=systemd:/system/mysqld.service
└ 7059 /usr/bin/mysqld --user=mysql

Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: The InnoDB memory heap is disabled
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: Compressed tables use zlib 1.2.7
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: Initializing buffer pool, size = 128.0M
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: Completed initialization of buffer pool
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: highest supported file format is Barracuda.
Aug 14 16:00:49 Licht mysqld[7059]: 120814 16:00:49 InnoDB: Waiting for the background threads to start



Steps to reproduce:

Install package, attempt to enable with "systemctl start mysqld.service".
This task depends upon

Closed by  Andrea Scarpino (BaSh)
Wednesday, 15 August 2012, 15:05 GMT
Reason for closing:  Fixed
Additional comments about closing:  mysql 5.5.27-3
Comment by Bastian Beranek (totsilence) - Tuesday, 14 August 2012, 20:20 GMT
I think I found the problem: /usr/bin/mysqld-post misses the shebang. With #!/bin/sh it works for me.
Comment by Joseph Yaworski (jyaworski) - Tuesday, 14 August 2012, 20:26 GMT
I can confirm that Bastian's solution is the correct one. Adding the shebang fixed it for me.
Comment by Eric Belanger (Snowman) - Wednesday, 15 August 2012, 08:27 GMT
Also, I believe that the mysqld.conf config for temporary files should be moved from /etc/tmpfiles.d/ to /usr/lib/tmpfiles.d/. I only started to read the systemd documantation so you'll need to confirm this with someone else but my understanding is that /etc/tmpfiles.d/ is reserved for users' customisations.
Comment by Andrea Scarpino (BaSh) - Wednesday, 15 August 2012, 14:03 GMT
@Eric
yes, you're right, the packages should use /usr/lib/.

Loading...