Hi listers
Sofar (i.e. up to fedora 15) no problem to start mysqld at system startup.

Since i did a fresh install of fedora 17, no more startup of mysqld at
sysemboot.


I call
systemctl start mysqld.service

and it hangs forever.

I do an
strace systemctl start mysqld service

and i see that the process is waiting for a reply from systemd from the
/run/systemd/private

socket.

....
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC, 0) = 3
connect(3, {sa_family=AF_FILE, sun_path="/run/systemd/private"}, 22) = 0
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
geteuid() = 0
getsockname(3, {sa_family=AF_FILE, NULL}, [2]) = 0
getsockopt(3, SOL_SOCKET, SO_PEERCRED, {pid=1, uid=0, gid=0}, [12]) = 0
poll([{fd=3, events=POLLOUT}], 1, 90000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "", 1, MSG_NOSIGNAL, NULL, 0) = 1
sendto(3, "AUTH EXTERNAL 30
", 18, MSG_NOSIGNAL, NULL, 0) = 18
poll([{fd=3, events=POLLIN}], 1, 90000) = 1 ([{fd=3, revents=POLLIN}])
read(3, "OK 7c36b0471db110e67219972800000"..., 2048) = 37
poll([{fd=3, events=POLLOUT}], 1, 90000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "NEGOTIATE_UNIX_FD
", 19, MSG_NOSIGNAL, NULL, 0) = 19
poll([{fd=3, events=POLLIN}], 1, 89999) = 1 ([{fd=3, revents=POLLIN}])
read(3, "AGREE_UNIX_FD
", 2048) = 15
poll([{fd=3, events=POLLOUT}], 1, 89999) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "BEGIN
", 7, MSG_NOSIGNAL, NULL, 0) = 7
stat("/proc/1/root", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
stat("/", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
ioctl(0, SNDCTL_TMR_TIMEBASE or SNDRV_TIMER_IOCTL_NEXT_DEVICE or TCGETS,
{B38400 opost isig icanon echo ...}) = 0
clone(child_stack=0,
flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGC HLD,
child_tidptr=0x7fee91890b10) = 2070

gettid() = 2069
mmap(NULL, 548864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x7fee9180a000
sendmsg(3, {msg_name(0)=NULL, msg_iov(2)=[{"l11
124011o31/org/fre"..., 176},
{"16mysqld.service7replace", 32}], msg_controllen=0,
msg_flags=0}, MSG_NOSIGNAL) = 208

poll([{fd=3, events=POLLIN}], 1, 25000) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL,
msg_iov(1)=[{"l211&11751u1101g1o"...,
2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC)
= 276
recvmsg(3, 0x7fff2f449670, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource
temporarily unavailable)
sendmsg(3, {msg_name(0)=NULL,
msg_iov(2)=[{"l1123222711o31/org/fre"...,
168}, {"16mysqld.service", 19}], msg_controllen=0,
msg_flags=0}, MSG_NOSIGNAL) = 187

poll([{fd=3, events=POLLIN}], 1, 25000) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL,
msg_iov(1)=[{"l2101421751u2101g1o"...,
2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC)
= 84
recvmsg(3, 0x7fff2f449670, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource
temporarily unavailable)
sendmsg(3, {msg_name(0)=NULL,
msg_iov(2)=[{"l1019324011o//org/fre"...,
176}, {"35org.freedesktop.systemd1.Uni"..., 57}],
msg_controllen=0, msg_flags=0}, MSG_NOSIGNAL) = 233

poll([{fd=3, events=POLLIN}], 1, 25000) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL,
msg_iov(1)=[{"l2111031751u3101g1v"...,
2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC)
= 40
recvmsg(3, 0x7fff2f449670, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource
temporarily unavailable)

poll([{fd=3, events=POLLIN}], 1, -1


The process hangs at the last poll.

-------------------------------

If I, however, do (bypassing systemd)

[root@myworkstation ~]# /usr/libexec/mysqld -u mysql &
[1] 2144
[root@myworkstation ~]# 120625 15:36:40 [Note] Plugin 'FEDERATED' is
disabled.

120625 15:36:40 InnoDB: The InnoDB memory heap is disabled
120625 15:36:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120625 15:36:40 InnoDB: Compressed tables use zlib 1.2.5
120625 15:36:40 InnoDB: Using Linux native AIO
120625 15:36:40 InnoDB: Initializing buffer pool, size = 128.0M
120625 15:36:40 InnoDB: Completed initialization of buffer pool
120625 15:36:40 InnoDB: highest supported file format is Barracuda.
120625 15:36:40 InnoDB: Waiting for the background threads to start
120625 15:36:41 InnoDB: 1.1.8 started; log sequence number 1595675
120625 15:36:41 [Note] Server hostname (bind-address): '(null)'; port: 3306
120625 15:36:41 [Note] - '(null)' resolves to '0.0.0.0';
120625 15:36:41 [Note] - '(null)' resolves to '::';
120625 15:36:41 [Note] Server socket created on IP: '0.0.0.0'.
120625 15:36:41 [Note] Event Scheduler: Loaded 0 events
120625 15:36:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.24' socket: '/var/lib/mysql/mysql.sock' port: 3306
MySQL Community Server (GPL)


[root@myworkstation ~]#

mysqld runs perfectly and I can connect to it, no problem:


[myuser@myworkstation ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 5
Server version: 5.5.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input
statement.


mysql>


In dmesg I cannot find anything obvious.
In /var/log/messages I cannot find anything obvious.
In /var/lib/mysql/myworkstation.lan.err I cannot find anything neither,
because at the point, when systemctl blocks, mysqld has not been invoked
yet.


Has anybody of you had such an systemd problem? If yes, would you share
how you resolved it?


Thanks for any hints.

suomi
--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org

Am 25.06.2012 16:18, schrieb fedora:
> Hi listers
> Sofar (i.e. up to fedora 15) no problem to start mysqld at system startup.
>
> Since i did a fresh install of fedora 17, no more startup of mysqld at sysemboot.
>
> I call
> systemctl start mysqld.service
>
> and it hangs forever

maybe some side-effect of the dumb still using of mysqld_safe
thats why i define since F15 my own mysqld.service which
worked perfectly long before any fedora-package and respects
service ordering of mysqld-dependent services

this one blow is untouched since a long time and working
from F15 until F17 unchanged

[Unit]
Description=MySQL Database
Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service
dbmail-postfix-policyd.service

[Service]
Type=simple
PIDFile=/var/run/mysqld/mysqld.pid
ExecStartPre=/usr/libexec/mysqld-prepare-db-dir
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/lib/mysql/mysql.sock --open-files-limit=30000 --basedir=/usr --user=mysql
ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID
ExecStop=/bin/kill -15 $MAINPID
Restart=always
RestartSec=1
TimeoutSec=300
LimitNOFILE=30000
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
SysVStartPriority=64

[Install]
WantedBy=multi-user.target

--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org