PVE环境下LXC容器中SQL Server 2022崩溃后无法重启求助

问题描述 #

• 在Proxmox Virtual Environment（PVE）的LXC容器中部署SQL Server 2022时遇到严重故障：SQL Server 2019在相同环境下可正常运行，但SQL Server 2022在稳定运行数月后突然崩溃，且崩溃后无法重启，目前找到的唯一解决方式是重装容器。

崩溃时的错误日志 #

Feb 19 04:30:58 sqll sqlservr[4857]: This program has encountered a fatal error and cannot continue running at Sun Feb 19 04:30:58 2023
Feb 19 04:30:58 sqll sqlservr[4857]: The following diagnostic information is available:
Feb 19 04:30:58 sqll sqlservr[4857]:          Reason: 0x00000001
Feb 19 04:30:58 sqll sqlservr[4857]:          Signal: SIGABRT - Aborted (6)
Feb 19 04:30:58 sqll sqlservr[4857]:           Stack:
Feb 19 04:30:58 sqll sqlservr[4857]:                  IP               Function
Feb 19 04:30:58 sqll sqlservr[4857]:                  ---------------- --------------------------------------
Feb 19 04:30:58 sqll sqlservr[4857]:                  0000562a9b7549d2 <unknown>
Feb 19 04:30:58 sqll sqlservr[4857]:                  0000562a9b7543f0 <unknown>
Feb 19 04:30:58 sqll sqlservr[4857]:                  0000562a9b753a8f <unknown>
Feb 19 04:30:58 sqll sqlservr[4857]:                  00007f093a98f090 killpg+0x40
Feb 19 04:30:58 sqll sqlservr[4857]:                  00007f093a98f00b gsignal+0xcb
Feb 19 04:30:58 sqll sqlservr[4857]:                  00007f093a96e859 abort+0x12b
Feb 19 04:30:58 sqll sqlservr[4857]:                  0000562a9b70ec26 <unknown>
Feb 19 04:30:58 sqll sqlservr[4857]:                  0000562a9b78576a <unknown>
Feb 19 04:30:58 sqll sqlservr[4857]:         Process: 4857 - sqlservr
Feb 19 04:30:58 sqll sqlservr[4857]:          Thread: 4862 (application thread 0x8)
Feb 19 04:30:58 sqll sqlservr[4857]:     Instance Id: 1f101619-527d-4094-ac00-c2b857339367
Feb 19 04:30:58 sqll sqlservr[4857]:        Crash Id: 8b1a4608-d26c-421a-beff-e83d1f30b91f
Feb 19 04:30:58 sqll sqlservr[4857]:     Build stamp: 7381104a7baabc096c65c6cf9b3c3c2c36e1f155ac27f817e87fab585602cb5f
Feb 19 04:30:58 sqll sqlservr[4857]:    Distribution: Ubuntu 20.04.5 LTS
Feb 19 04:30:58 sqll sqlservr[4857]:      Processors: 2
Feb 19 04:30:58 sqll sqlservr[4857]:    Total Memory: 67350208512 bytes
Feb 19 04:30:58 sqll sqlservr[4857]:       Timestamp: Sun Feb 19 04:30:58 2023
Feb 19 04:30:58 sqll sqlservr[4857]:      Last errno: 2
Feb 19 04:30:58 sqll sqlservr[4857]: Last errno text: No such file or directory
Feb 19 04:30:58 sqll sqlservr[4855]: Capturing a dump of 4857
Feb 19 04:30:58 sqll sqlservr[4855]: FAILED to capture a dump. Details in paldumper log.
Feb 19 04:30:58 sqll sqlservr[4855]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
Feb 19 04:30:58 sqll sqlservr[4855]:      handle-crash.sh
Feb 19 04:30:58 sqll sqlservr[4855]:      /opt/mssql/bin/sqlservr
Feb 19 04:30:58 sqll sqlservr[4855]:      4857
Feb 19 04:30:58 sqll sqlservr[4855]:      /opt/mssql/bin
Feb 19 04:30:58 sqll sqlservr[4855]:      /var/opt/mssql/log/
Feb 19 04:30:58 sqll sqlservr[4855]:
Feb 19 04:30:58 sqll sqlservr[4855]:      1f101619-527d-4094-ac00-c2b857339367
Feb 19 04:30:58 sqll sqlservr[4855]:      8b1a4608-d26c-421a-beff-e83d1f30b91f
Feb 19 04:30:58 sqll sqlservr[4855]:
Feb 19 04:30:58 sqll sqlservr[4855]:
Feb 19 04:30:58 sqll sqlservr[4855]: Ubuntu 20.04.5 LTS

问题相关说明 #

• 该问题可能需要微软官方人员介入排查，目前已有相同问题在微软文档相关仓库及Proxmox官方论坛被用户报告。

内容的提问来源于stack exchange，提问作者hex