[debian-mysql] Bug#800588: Upgrade from jessie

[micah]

I upgraded a machine from jessie to stretch today and then when I went
to reboot, I had to wait 10 minutes for mysql to fail to shutdown.

when the machine finally did reboot, i logged in and tried 'systemctl
stop mysql' and it didn't do anything. I could see in the systemctl
status that it was trying:

mysql.service                    loaded deactivating stop-sigterm stop MySQL Community Server             

i then tried it again, this time stracing what was going on, I found
this interesting bit at the end:

1538  set_tid_address(0x7f1a78bb3b90)   = 1538
1538  set_robust_list(0x7f1a78bb3ba0, 24) = 0
1538  rt_sigaction(SIGRTMIN, {sa_handler=0x7f1a7856db80, sa_mask=[], sa_flags=SA_RESTORER|SA_SIGINFO, sa_restorer=0x7f1a78579100}, NULL, 8) = 0
1538  rt_sigaction(SIGRT_1, {sa_handler=0x7f1a7856dc10, sa_mask=[], sa_flags=SA_RESTORER|SA_RESTART|SA_SIGINFO, sa_restorer=0x7f1a78579100}, NULL, 8) = 0
1538  rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
1538  getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
1538  brk(NULL)                         = 0x56016fb2f000
1538  brk(0x56016fb50000)               = 0x56016fb50000
1538  statfs("/sys/fs/selinux", 0x7ffdeb2c6a20) = -1 ENOENT (No such file or directory)
1538  statfs("/selinux", 0x7ffdeb2c6a20) = -1 ENOENT (No such file or directory)
1538  open("/proc/filesystems", O_RDONLY) = 3
1538  fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
1538  read(3, "nodev\tsysfs\nnodev\trootfs\nnodev\tr"..., 1024) = 293
1538  read(3, "", 1024)                 = 0
1538  close(3)                          = 0
1538  access("/etc/selinux/config", F_OK) = -1 ENOENT (No such file or directory)
1538  open("/proc/self/stat", O_RDONLY|O_CLOEXEC) = 3
1538  fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
1538  read(3, "1538 (systemd-tty-ask) R 1537 15"..., 1024) = 316
1538  close(3)                          = 0
1538  ioctl(2, TCGETS, {B38400 opost isig icanon echo ...}) = 0
1538  umask(022)                        = 022
1538  open("/proc/self/stat", O_RDONLY|O_CLOEXEC) = 3
1538  fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
1538  read(3, "1538 (systemd-tty-ask) R 1537 15"..., 1024) = 316
1538  close(3)                          = 0
1538  stat("/run/systemd/ask-password-block", {st_mode=S_IFDIR|0700, st_size=60, ...}) = 0
1538  mknod("/run/systemd/ask-password-block/136:0", S_IFIFO|0600) = -1 EEXIST (File exists)
1538  open("/run/systemd/ask-password-block/136:0", O_RDONLY|O_NOCTTY|O_NONBLOCK|O_CLOEXEC) = 3
1538  stat("/run/systemd", {st_mode=S_IFDIR|0755, st_size=440, ...}) = 0
1538  mkdir("/run/systemd/ask-password", 0755) = -1 EEXIST (File exists)
1538  stat("/run/systemd/ask-password", {st_mode=S_IFDIR|0755, st_size=40, ...}) = 0
1538  inotify_init1(IN_CLOEXEC)         = 4
1538  inotify_add_watch(4, "/run/systemd/ask-password", IN_CLOSE_WRITE|IN_MOVED_TO) = 1
1538  rt_sigprocmask(SIG_SETMASK, [INT TERM], NULL, 8) = 0
1538  signalfd4(-1, [INT TERM], 8, SFD_CLOEXEC|SFD_NONBLOCK) = 5
1538  open("/run/systemd/ask-password", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 6
1538  fstat(6, {st_mode=S_IFDIR|0755, st_size=40, ...}) = 0
1538  getdents(6, /* 2 entries */, 32768) = 48
1538  getdents(6, /* 0 entries */, 32768) = 0
1538  close(6)                          = 0
1538  poll([{fd=4, events=POLLIN}, {fd=5, events=POLLIN}], 2, -1

it seemed to be trying to poll an inotify fd and was waiting on
/run/systemd/ask-password?

I have no idea why any of those would be involved here.