MySQL Forums
Forum List  »  General

Re: Staring mysqld with systemd hangs at "Activating" -- and there's not much on Google
Posted by: Authorized User
Date: January 22, 2022 11:56AM

I turned on systemd debug logging the information seems helpful, but I'm not sure what to make of it. Based on my non-expert eye, it would seem that the mysqld process is indeed forking, but it is not telling systemd that it can go on with its business. (Btw, selinux is in permissive mode.)

Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Bus private-bus-connection: changing state UNSET → OPENING
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Bus private-bus-connection: changing state OPENING → AUTHENTICATING
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Accepted new private connection.
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Bus private-bus-connection: changing state AUTHENTICATING → RUNNING
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Got message type=method_call sender=n/a destination=org.freedesktop.systemd1 path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=Start Unit cookie=1 reply_cookie=0 signature=ss error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: SELinux access check scon=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 tcon=unconfined_u:object_r:systemd_unit_file_t:s0 tclass=service perm=start path=/u sr/lib/systemd/system/mysql@.service cmdline=: 0
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: SELinux access check scon=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 tcon=unconfined_u:object_r:systemd_unit_file_t:s0 tclass=service perm=start path=/u sr/lib/systemd/system/mysql@.service cmdline=: 0
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Trying to enqueue job mysql@site622.service/start/replace
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Installed new job mysql@site622.service/start as 47392
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Enqueued job mysql@site622.service/start as 47392
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=method_return sender=org.freedesktop.systemd1 destination=n/a path=n/a interface=n/a member=n/a cookie=1 reply_cookie=1 signature=o error-name=n/ a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=UnitNew c ookie=2 reply_cookie=0 signature=so error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=UnitNew cookie=68153 reply_coo kie=0 signature=so error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=JobNew co okie=3 reply_cookie=0 signature=uos error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=JobNew cookie=68154 reply_cook ie=0 signature=uos error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Got message type=method_call sender=n/a destination=org.freedesktop.systemd1 path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=GetUn it cookie=2 reply_cookie=0 signature=s error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: SELinux access check scon=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 tcon=unconfined_u:object_r:systemd_unit_file_t:s0 tclass=service perm=status path=/ usr/lib/systemd/system/mysql@.service cmdline=: 0
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=method_return sender=org.freedesktop.systemd1 destination=n/a path=n/a interface=n/a member=n/a cookie=4 reply_cookie=2 signature=o error-name=n/ a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: BPF firewalling not supported on this manager, proceeding without.
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Passing 0 fds to service
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: About to execute: /usr/sbin/mysql57/bin/mysqld $MYSQLD_OPTS
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Forked /usr/sbin/mysql57/bin/mysqld as 654655
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: Changed dead -> start
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Starting MySQL Service for site622...
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DB us.Properties member=PropertiesChanged cookie=5 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DB us.Properties member=PropertiesChanged cookie=6 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DBus.Properties member= PropertiesChanged cookie=68155 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DBus.Properties member= PropertiesChanged cookie=68156 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1/job/47392 interface=org.freedesktop.DBus.Properties member= PropertiesChanged cookie=7 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1/job/47392 interface=org.freedesktop.DBus.Properties member=PropertiesChanged coo kie=68157 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Got message type=method_call sender=n/a destination=org.freedesktop.systemd1 path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedeskto p.DBus.Properties member=Get cookie=3 reply_cookie=0 signature=ss error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: SELinux access check scon=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 tcon=unconfined_u:object_r:systemd_unit_file_t:s0 tclass=service perm=status path=/ usr/lib/systemd/system/mysql@.service cmdline=: 0
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=method_return sender=org.freedesktop.systemd1 destination=n/a path=n/a interface=n/a member=n/a cookie=8 reply_cookie=3 signature=v error-name=n/ a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Got message type=method_call sender=:1.998 destination=org.freedesktop.systemd1 path=/org/freedesktop/systemd1 interface=org.freedesktop.systemd1.Manager member=Ge tDynamicUsers cookie=2 reply_cookie=0 signature=n/a error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=method_return sender=n/a destination=:1.998 path=n/a interface=n/a member=n/a cookie=68158 reply_cookie=2 signature=a(us) error-name=n/a error-me ssage=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: mysql@site622.service: User lookup succeeded: uid=1122 gid=1122
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DB us.Properties member=PropertiesChanged cookie=9 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=org.freedesktop.systemd1 destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DB us.Properties member=PropertiesChanged cookie=10 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DBus.Properties member= PropertiesChanged cookie=68159 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: Sent message type=signal sender=n/a destination=n/a path=/org/freedesktop/systemd1/unit/mysql_40site622_2eservice interface=org.freedesktop.DBus.Properties member= PropertiesChanged cookie=68160 reply_cookie=0 signature=sa{sv}as error-name=n/a error-message=n/a
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: systemd-journald.service: Got notification message from PID 1408 (FDSTORE=1)
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: systemd-journald.service: Added fd 26 (n/a) to fd store.
Jan 22 09:45:06 ha50a.mycharts.md systemd[1]: systemd-journald.service: Received EPOLLHUP on stored fd 26 (stored), closing.
Jan 22 09:45:14 ha50a.mycharts.md systemd[1]: Bus private-bus-connection: changing state RUNNING → CLOSING
Jan 22 09:45:14 ha50a.mycharts.md systemd[1]: Received SIGCHLD from PID 654654 (systemd-tty-ask).
Jan 22 09:45:14 ha50a.mycharts.md systemd[1]: Child 654654 (systemd-tty-ask) died (code=exited, status=0/SUCCESS)
Jan 22 09:45:14 ha50a.mycharts.md systemd[1]: Bus private-bus-connection: changing state CLOSING → CLOSED
Jan 22 09:45:14 ha50a.mycharts.md systemd[1]: Got disconnect on private connection.

Options: ReplyQuote


Subject
Written By
Posted
Re: Staring mysqld with systemd hangs at "Activating" -- and there's not much on Google
January 22, 2022 11:56AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.