無法配置/啟動 mssql-server

遵循本指南後出現錯誤：https ://computingforgeeks.com/how-to-install-ms-sql-on-ubuntu-18-04-lts/並執行配置命令。

我已經搜尋了幾個小時試圖找到我遇到的具體問題，但我似乎找不到任何東西。

我相信這與我執行 Ubuntu 18.10 有關，因為在 docker 容器中安裝 mssql（根據官方 M$ 指南）也不起作用。

安裝本身很順利，但我在配置命令結束時收到錯誤，手動啟動 mssql 服務只會使其處於失敗狀態。

安裝命令的輸出：

The following NEW packages will be installed:
 mssql-server
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/178 MB of archives.
After this operation, 927 MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously unselected package mssql-server.
(Reading database ... 167661 files and directories currently installed.)
Preparing to unpack .../mssql-server_14.0.3076.1-2_amd64.deb ...
Unpacking mssql-server (14.0.3076.1-2) ...
Processing triggers for libc-bin (2.28-0ubuntu1) ...
Setting up mssql-server (14.0.3076.1-2) ...
Processing triggers for man-db (2.8.4-2) ...
Processing triggers for libc-bin (2.28-0ubuntu1) ...

配置命令的輸出：

Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...

ForceFlush is enabled for this instance.
ForceFlush feature is enabled for log durability.
This program has encountered a fatal error and cannot continue running at Fri Apr  5 15:01:09 2019
The following diagnostic information is available:
      Reason: 0x00000004
     Message: RETAIL ASSERT: Expression=(false) File=Thread.cpp Line=4781 Description=Timed out waiting for thread terminate/suspend/resume.
  Stacktrace: 000000006ad31773 000000006ad2ad0a 000000006ac4b8b1
              000000006ac49dc5 000000006ac02f19 000000006ad6cf48
              00000002809328df
     Process: 11792 - sqlservr
      Thread: 11904 (application thread 0x1a0)
 Instance Id: 75c7c1b5-ce5f-4436-8acc-a2cdc97b6c0a
    Crash Id: 40695f67-2869-4316-b6e3-786530d7123c
 Build stamp: 70437f6583b8ef39b1ef70539ef84690980315dc7a4436c9c40015f28610e4aa
Distribution: Ubuntu 18.10
  Processors: 2
Total Memory: 4136767488 bytes
   Timestamp: Fri Apr  5 15:01:09 2019
Ubuntu 18.10
Capturing core dump and information to /var/opt/mssql/log...
Hint: You are currently not seeing messages from other users and the system.
     Users in groups 'adm', 'systemd-journal' can see all messages.
     Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
Hint: You are currently not seeing messages from other users and the system.
     Users in groups 'adm', 'systemd-journal' can see all messages.
     Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
/usr/bin/tail: cannot open '/var/log/syslog' for reading: Permission denied
Attempting to capture a dump with paldumper
Captured a dump with paldumper
Core dump and information are being compressed in the background. When
complete, they can be found in the following location:
 /var/opt/mssql/log/core.sqlservr.04_05_2019_15_01_09.11792.tbz2
Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
in /var/opt/mssql/log for more information.

錯誤日誌（相關位）：

Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64)
       Mar 12 2019 19:29:19
       Copyright (C) 2017 Microsoft Corporation
       Express Edition (64-bit) on Linux (Ubuntu 18.10)
2019-04-05 14:58:38.41 Server      Failed to verify the Authenticode signature of 'C:\binn\secforwarder.dll'. Signature verification of SQL Server DLLs will be skipped. Genuine copies of SQL Server are signed. Failure to verify the Authenticode signature might indicate that this is not an authentic release of SQL Server. Install a genuine copy of SQL Server or contact customer support.
2019-04-05 14:58:38.44 spid9s      Polybase feature disabled.
2019-04-05 14:58:38.44 spid9s      Clearing tempdb database.
2019-04-05 14:58:38.52 spid18s     A self-generated certificate was successfully loaded for encryption.
2019-04-05 14:58:39.00 spid9s      Starting up database 'tempdb'.
2019-04-05 14:58:39.23 spid17s     SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2019-04-05 14:58:39.24 spid23s     The Service Broker endpoint is in disabled or stopped state.
2019-04-05 14:58:39.24 spid23s     The Database Mirroring endpoint is in disabled or stopped state.

解決！

微軟官方倉庫安裝了14.0.3076.1-2版本的 mssql-server 但是這個版本沒有在累積更新頁面上列出，似乎也沒有安裝。

最新版本 (CU13) 14.0.3048.4-1也安裝失敗。

然後我下載了 CU13 之前的版本，即14.0.3045.24-1，你猜怎麼著……安裝和配置沒有任何問題！

14.0.3076.01-2失敗

14.0.3048.04-1失敗

14.0.3045.24-1確定

您確定您滿足此處所述的最低要求嗎？因為你寫了，它甚至在 docker 中失敗了，我假設你的 RAM 可能少於 2GB。如果檢測到可用的 RAM 少於 2 GB，mssql 將不會安裝。

引用自：https://serverfault.com/questions/961717