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, "\0", 1, MSG_NOSIGNAL, NULL, 0) = 1
sendto(3, "AUTH EXTERNAL 30\r\n", 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\r\n", 19, MSG_NOSIGNAL, NULL, 0) = 19
poll([{fd=3, events=POLLIN}], 1, 89999) = 1 ([{fd=3, revents=POLLIN}])
read(3, "AGREE_UNIX_FD\r\n", 2048) = 15
poll([{fd=3, events=POLLOUT}], 1, 89999) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "BEGIN\r\n", 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|SIGCHLD,
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)=[{"l\1\0\1
\0\0\0\1\0\0\0\240\0\0\0\1\1o\0\31\0\0\0/org/fre"..., 176},
{"\16\0\0\0mysqld.service\0\0\7\0\0\0replace\0", 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)=[{"l\2\1\1&\0\0\0\1\0\0\0\17\0\0\0\5\1u\0\1\0\0\0\10\1g\0\1o\0\0"...,
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)=[{"l\1\0\1\23\0\0\0\2\0\0\0\227\0\0\0\1\1o\0\31\0\0\0/org/fre"...,
168}, {"\16\0\0\0mysqld.service\0", 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)=[{"l\2\1\0014\0\0\0\2\0\0\0\17\0\0\0\5\1u\0\2\0\0\0\10\1g\0\1o\0\0"...,
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)=[{"l\1\0\0019\0\0\0\3\0\0\0\240\0\0\0\1\1o\0/\0\0\0/org/fre"...,
176}, {"\35\0\0\0org.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)=[{"l\2\1\1\10\0\0\0\3\0\0\0\17\0\0\0\5\1u\0\3\0\0\0\10\1g\0\1v\0\0"...,
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@xxxxxxxxxxxxxxxxxxxxxxx
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
