Score:0

I've created a file, "sqlKill.shutdown", in ~/lib/systemd/system-shutdown, was this the correct way to stop MSSQL at shutdown?

in flag

My mssql-server service has a bad habit of not being stopped at shutdown. To remedy this, I've navigated to ~/lib/systemd/system-shutdown and created the file sqlKill.shutdown containing exactly the following

#!/bin/sh
sudo systemctl stop mssql-server.service

Is this a sufficient and safe way to force MSSQL server to stop at shutdown?

Liso avatar
sd flag
If you shutdown your computer, it should **stop** all running service. Can anyone clarify this ?
in flag
I agree with @Liso. I’ve been running SQL Server on Linux since 16.04 and it consistently shuts down correctly when the system goes down for a reboot. What issue are you seeing when you try to shut down? Is there anything in the log that points to the issue, such as delayed writes, an open transaction, or something else?
J. Mini avatar
in flag
@matigo When I shut down, I'll get the to splash screen and the shutdown will never finish. Pressing an arrow key shows that I'm waiting on mssql-server to stop, but it never does stop. There shouldn't be anything of relevant in the server logs, but if you can tell me where to look, then I will get back to you.
Score:0
in flag

One week later. I've not had any issues since doing this, so I guess it was safe?

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.