每次我检查MSSQL服务失败时,我的虚拟服务器上都有超过5GB的内存。我已将sql端口更改为1533。
r*****k:~# sudo systemctl状态mssql-server
mssql-server.service - Microsoft SQL Server数据库引擎加载: loaded (/lib/systemd/system/mssql-server.service;已启用;供应商预置:已启用)活动:自2017年星期五-11-17 15:39:39 :39:37时起活动:非活动(死)(结果:退出代码)
Process: 4906 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=255)
Main PID: 4906 (code=exited, status=255)
Nov 17 15:39:39 SV0*****com systemd[1]: mssql-server.service: Unit entered failed state.
Nov 17 15:39:39 SV0*****com systemd[1]: mssql-server.service: Failed with result 'exit-code'.
Nov 17 15:39:39 SV0*****.com systemd[1]: mssql-server.service: Service hold-off time over, scheduling restart.
Nov 17 15:39:39 SV0*****.com systemd[1]: Stopped Microsoft SQL Server Database Engine.
Nov 17 15:39:39 SV0*****.com systemd[1]: mssql-server.service: Start request repeated too quickly.
Nov 17 15:39:39 SV0*****.com systemd[1]: Failed to start Microsoft SQL Server Database Engine.r*k:/var/opt/mssql# cat mssql.conf
> [EULA] accepteula = Y</br>
>
> [network] ipaddress = 6*.*1.1*2.*8 kerberoskeytabfile =
> /var/opt/mssql/secrets/mssql.keytab tcpport = 1533
>
> [memory] memorylimitmb = 3328
>
> [filelocation] defaultdatadir = /tmp/data任何人都可以帮助稳定vm上的mssql服务。
发布于 2018-04-30 16:30:45
您的Ubuntu服务器启用防火墙了吗?如果是这样,则可能阻塞端口1533,从而阻止服务在该自定义端口上启动。
您可能也希望查看/var/log/messages中的其他信息。
https://stackoverflow.com/questions/47354662
复制相似问题