I'm about 5 hours looking for a solution without any luck.
I'm using Plesk and mssql server, I updated some packages and restarted my server. (Everything was worked fine before) and now sql can't start because something related to permissions I guess.
SQL Version: 2017 CentOS
Here is the log of sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Mon 2018-10-08 16:44:50 -05; 4s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Process: 6534 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=255)
Main PID: 6534 (code=exited, status=255)
Oct 08 16:44:49 www systemd[1]: Unit mssql-server.service entered failed state.
Oct 08 16:44:49 www systemd[1]: mssql-server.service failed.
Oct 08 16:44:50 www systemd[1]: mssql-server.service holdoff time over, scheduling restart.
Oct 08 16:44:50 www systemd[1]: start request repeated too quickly for mssql-server.service
Oct 08 16:44:50 www systemd[1]: Failed to start Microsoft SQL Server Database Engine.
Oct 08 16:44:50 www systemd[1]: Unit mssql-server.service entered failed state.
Oct 08 16:44:50 www systemd[1]: mssql-server.service failed.
And this one when I use journalctl -u mssql-server.service -b
Oct 08 16:44:49 www systemd[1]: Starting Microsoft SQL Server Database Engine...
Oct 08 16:44:49 www sqlservr[6534]: sqlservr: Unable to read instance id from /var/opt/mssql/.system/instance_id: Permission denied (13)
Oct 08 16:44:49 www sqlservr[6534]: This program has encountered a fatal error and cannot continue running.
Oct 08 16:44:49 www sqlservr[6534]: The following diagnostic information is available:
Oct 08 16:44:49 www sqlservr[6534]: Reason: 0x00000004
Oct 08 16:44:49 www sqlservr[6534]: Message: (null)
Oct 08 16:44:49 www sqlservr[6534]: Process: 6534 - sqlservr
Oct 08 16:44:49 www sqlservr[6534]: Thread: 6535 (application thread 0x1000)
Oct 08 16:44:49 www sqlservr[6534]: Instance Id:
Oct 08 16:44:49 www sqlservr[6534]: Crash Id:
Oct 08 16:44:49 www sqlservr[6534]: Build stamp: acecaf702f3f60e2400b49e58bc9a8a85f76949c5c2ecd1dd7fd60fc26bb8526
Oct 08 16:44:49 www systemd[1]: mssql-server.service: main process exited, code=exited, status=255/n/a
Oct 08 16:44:49 www systemd[1]: Unit mssql-server.service entered failed state.
Oct 08 16:44:49 www systemd[1]: mssql-server.service failed.
Oct 08 16:44:50 www systemd[1]: mssql-server.service holdoff time over, scheduling restart.
Oct 08 16:44:50 www systemd[1]: start request repeated too quickly for mssql-server.service
Oct 08 16:44:50 www systemd[1]: Failed to start Microsoft SQL Server Database Engine.
Oct 08 16:44:50 www systemd[1]: Unit mssql-server.service entered failed state.
Oct 08 16:44:50 www systemd[1]: mssql-server.service failed.
User contributions licensed under CC BY-SA 3.0