Bug 8477 - cannot start mysqld because teh PID file cannot be created
Summary: cannot start mysqld because teh PID file cannot be created
Status: RESOLVED INVALID
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: Cauldron
Hardware: x86_64 Linux
Priority: Normal critical
Target Milestone: ---
Assignee: Mageia Bug Squad
QA Contact:
URL:
Whiteboard:
Keywords: NEEDINFO
Depends on:
Blocks:
 
Reported: 2012-12-22 18:55 CET by Thomas Spuhler
Modified: 2013-03-13 16:11 CET (History)
4 users (show)

See Also:
Source RPM: mariadb
CVE:
Status comment:


Attachments

Description Thomas Spuhler 2012-12-22 18:55:17 CET
Description of problem:

121222 10:51:02 [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
121222 10:51:02 [ERROR] Can't start server: can't create PID file: No such file or directory

As a result, it also fill the log file

Version-Release number of selected component (if applicable):
Current Cauldron

How reproducible:
every time
Comment 1 Bit Twister 2012-12-22 20:32:04 CET
I have yet to see that problem for Mageia 3 on any phase/release installed on 3 systems. All installs are clean/fresh installs. 

Running MythTv on my back end system and connecting to mysqld from my front end system. Front end system is also running it's own mysqld service.

$ cat /etc/release
Mageia release 3 (Cauldron) for x86_64

# systemctl status mysqld
mysqld.service - MySQL database server
          Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
          Active: active (running) since Fri, 2012-12-21 23:31:22 CST; 13h ago

CC: (none) => junk_no_spam

Comment 2 roelof Wobben 2012-12-22 21:38:39 CET
I can reproduce this. 
If you start the service as user the error appear.
As suoeruser (su) everything will work fine.

CC: (none) => r.wobben

Comment 3 roelof Wobben 2012-12-22 21:42:03 CET
@thonas Spulhler: 

Did you do the steps as a user or a superuser (su) or root ?

Roelof
Comment 4 Bit Twister 2012-12-22 21:45:26 CET
(In reply to comment #2)
> I can reproduce this. 

I would feel sad if users can manage system services from their account.

> If you start the service as user the error appear.

Heheh, I can not even do a systemctl status mysqld.service as user like I could on Alpha 1-3.
roelof Wobben 2012-12-22 21:49:32 CET

Keywords: (none) => NEEDINFO
CC: (none) => alien

Comment 5 AL13N 2012-12-22 21:54:04 CET
i didn't expect systemctl to be executable as regular user...
Comment 6 Thomas Spuhler 2012-12-22 21:58:41 CET
(In reply to comment #3)
> @thonas Spulhler: 
> 
> Did you do the steps as a user or a superuser (su) or root ?
> 
> Roelof

As su -
and it's also started at the boot process. Teh it fills the logs with the above messages.
Comment 7 Thomas Spuhler 2012-12-22 22:00:06 CET
Well, I am going to do a fresh install, this was an urpmi upgrade fro maga1 to mga2 and then cauldron.
There are a few other things that act up strange.
Comment 8 roelof Wobben 2012-12-22 22:18:31 CET
Fine, 

Could you report if the problem exist there, so we can investigate it further.

Roelof
Comment 9 AL13N 2012-12-23 00:02:30 CET
my first thought was about the /usr merge thing. as iinm mariadb got modified for it. (that also includes /var temp stuff)

perhaps your /var tmpfiles thing isn't working correctly?

CC: (none) => mageia

Comment 10 Colin Guthrie 2012-12-28 12:05:38 CET
Yeah, check that /var/run is really a symlink to /run on your upgraded machine. Perhaps the /var part of the usrmerge didn't work (if it was done with older mageia-prepare-upgrade package and /var is on a separate partition, then this could theoretically have happened).

tmpfiles should have created the directory with the right user and permissions.
Comment 11 Colin Guthrie 2012-12-28 12:07:02 CET
Oh and systemctl can be used fine by a regular user. It will only show you things you can already tell from other tools tho' - e.g. it won't show you extracts from the logs (unless you are in the adm group).

You can also use systemd as a user session (work is ongoing in his area) and as a result you can use systemctl --user to talk to your user session daemon.
Comment 12 Thomas Spuhler 2013-03-13 16:11:15 CET
I close this. It didn't surface anymore. It was probably a borked update.

Resolution: (none) => INVALID
Status: NEW => RESOLVED


Note You need to log in before you can comment on or make changes to this bug.