debugsqlModerate
mssql-service error exit with status 255 ubuntu
Viewed 0 times
errorwithubuntu255mssqlstatusexitservice
Problem
I cannot run mssql immediately following an apt-get update. Is this due to a bad script (below:
```
sudo systemctl start mssql-server
sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: active (running)
...
sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: inactive (dead) (Result: exit-code) since Wed 2018-03-21 22:46:15 PDT; 1min 27s ago
Docs: https://learn.microsoft.com/en-us/sql/linux
Process: 2977 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=255)
Main PID: 2977 (code=exited, status=255)
...
sudo cat /var/opt/mssql/log/errorlog
2018-03-21 22:36:24.19 Server Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) - 14.0.3023.8 (X64)
...
2018-03-21 22:36:35.90 spid6s Creating SSIS folders...
...
2018-03-21 22:36:35.91 spid6s Creating procedure [dbo].[sp_syscollector_upload_instmdw]...
2018-03-21 22:36:35.92 spid6s Uploading data collector package from disk: C:\Install\SqlTraceCollect.dtsx
2018-03-21 22:36:35.92 spid6s Uploading data collector package from disk: C:\Install\SqlTraceCollect.dtsx
2018-03-21 22:36:35.93 spid6s Error: 4860, Severity: 16, State: 1.
2018-03-21 22:36:35.93 spid6s Cannot bulk load. The file "C:\Install\SqlTraceCollect.dtsx" does not exist or you don't have file access rights.
2018-03-21 22:36:35.93 spid6s Error: 912, Severity: 21, State: 2.
2018-03-21 22:36:35.93 spid6s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql'
The file "C:\Install\SqlTraceCollect.dtsx" does not exist)? Any suggestions on a fix? I'm at a loss.```
sudo systemctl start mssql-server
sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: active (running)
...
sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: inactive (dead) (Result: exit-code) since Wed 2018-03-21 22:46:15 PDT; 1min 27s ago
Docs: https://learn.microsoft.com/en-us/sql/linux
Process: 2977 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=255)
Main PID: 2977 (code=exited, status=255)
...
sudo cat /var/opt/mssql/log/errorlog
2018-03-21 22:36:24.19 Server Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) - 14.0.3023.8 (X64)
...
2018-03-21 22:36:35.90 spid6s Creating SSIS folders...
...
2018-03-21 22:36:35.91 spid6s Creating procedure [dbo].[sp_syscollector_upload_instmdw]...
2018-03-21 22:36:35.92 spid6s Uploading data collector package from disk: C:\Install\SqlTraceCollect.dtsx
2018-03-21 22:36:35.92 spid6s Uploading data collector package from disk: C:\Install\SqlTraceCollect.dtsx
2018-03-21 22:36:35.93 spid6s Error: 4860, Severity: 16, State: 1.
2018-03-21 22:36:35.93 spid6s Cannot bulk load. The file "C:\Install\SqlTraceCollect.dtsx" does not exist or you don't have file access rights.
2018-03-21 22:36:35.93 spid6s Error: 912, Severity: 21, State: 2.
2018-03-21 22:36:35.93 spid6s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql'
Solution
Seems like the only solution is downgrading:
On a Ubuntu server do the following to perform a downgrade to the previous (14.0.3022.28-2) version:
For other linux OS use your package manager or download the package manually from here: https://packages.microsoft.com
Update 2018-03-25:
The support team replied and included a solution for this problem in the release notes:
To resolve this error, enable SQL Server Agent and restart SQL Server with the following commands:
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes#known-upgrade-issue
On a Ubuntu server do the following to perform a downgrade to the previous (14.0.3022.28-2) version:
systemctl stop mssql-server
sudo apt-get install mssql-server=14.0.3022.28-2
systemctl start mssql-serverFor other linux OS use your package manager or download the package manually from here: https://packages.microsoft.com
Update 2018-03-25:
The support team replied and included a solution for this problem in the release notes:
To resolve this error, enable SQL Server Agent and restart SQL Server with the following commands:
sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
sudo systemctl start mssql-serverhttps://learn.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes#known-upgrade-issue
Code Snippets
systemctl stop mssql-server
sudo apt-get install mssql-server=14.0.3022.28-2
systemctl start mssql-serversudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
sudo systemctl start mssql-serverContext
StackExchange Database Administrators Q#201957, answer score: 10
Revisions (0)
No revisions yet.