问题描述
我们在ubuntu 16.04上的sql server 2017中遇到周期性(每隔几天)崩溃。 我们正在运行最新的铜(在撰写本文时为14)。 这些转储和消息含糊不清,我们没有找到任何有意义的崩溃原因。
我们已经检查了文件和文件夹权限(都属于mssql组和用户),并且该服务正在从ps aux下载为mssql
We are running into periodic (every few days) crashes in sql server 2017 on ubuntu 16.04. We are running the latest cu (14 at time of writing) . These dumps and messages are vague, and we are not finding any meaningful reason for the crashes. We've checked file and folder permissions (all belong to mssql group and user) and the service is sunning as mssql
:
mssql     75280  0.0  0.0 151292 24492?       SSL  07:37  0:00 / opt / mssql / bin / sqlservr
mssql 75280 0.0 0.0 151292 24492 ? Ssl 07:37 0:00 /opt/mssql/bin/sqlservr
mssql     75284  2.1  1.9 6286520 1256404?     S1中    07:38  0:21 / opt / mssql / bin / sqlservr
mssql 75284 2.1 1.9 6286520 1256404 ? Sl 07:38 0:21 /opt/mssql/bin/sqlservr
crash.txt文件包含以下内容:
The crash.txt file contains the following:
此程序遇到致命错误且无法继续运行于4月16日星期二009:24:27 2019 $
以下诊断信息是可用:
    原因:0x00000006
    状态:0xc000009a
   消息:最后机会
   地址:0x6bc23904
Stacktrace:000000006bd2fc73 000000006bc5fb06 000000006bc5f909
            000000006bc5fd47 000000006bc2394c 000000006bc04f33
            000000006bc4193f 000000014d564ddb 000000014d5616a8
            000000006bc43ca2 000000006bc436b5 000000006bc3bcaa
            000000006bc3bdbe 000000006bc3c292 000000006bc02f19
            000000006bd6cf48 000000049e336a82
   流程:17490 - sqlservr
    主题:17575(申请主题0x154)
实例ID:8c7af317-fb54-4aa3-a4ba-109ba998a961
  崩溃ID:46611e97-4209-43ce-97ce-a2c213775514
建造图章:70437f6583b8ef39b1ef70539ef84690980315dc7a4436c9c40015f28610e4aa
发行:Ubuntu 16.04.6 LTS
处理器:8
总内存:67145662464字节
 时间戳:4月16日星期二009:14:27 2019
This program has encountered a fatal error and cannot continue running at Tue Apr 16 00:14:27 2019
The following diagnostic information is available:
Reason: 0x00000006
Status: 0xc000009a
Message: Last Chance
Address: 0x6bc23904
Stacktrace: 000000006bd2fc73 000000006bc5fb06 000000006bc5f909
000000006bc5fd47 000000006bc2394c 000000006bc04f33
000000006bc4193f 000000014d564ddb 000000014d5616a8
000000006bc43ca2 000000006bc436b5 000000006bc3bcaa
000000006bc3bdbe 000000006bc3c292 000000006bc02f19
000000006bd6cf48 000000049e336a82
Process: 17490 - sqlservr
Thread: 17575 (application thread 0x154)
Instance Id: 8c7af317-fb54-4aa3-a4ba-109ba998a961
Crash Id: 46611e97-4209-43ce-97ce-a2c213775514
Build stamp: 70437f6583b8ef39b1ef70539ef84690980315dc7a4436c9c40015f28610e4aa
Distribution: Ubuntu 16.04.6 LTS
Processors: 8
Total Memory: 67145662464 bytes
Timestamp: Tue Apr 16 00:14:27 2019
有没有人碰巧知道是什么导致这些,更重要的是,我们如何可以阻止linux上的sql server崩溃吗?
Does anyone out there happen to know what causes these, and more importantly, how we can stop sql server on linux from crashing?
推荐答案
这篇关于Sql Server 2017 - Linux - 间歇性崩溃消息“Last Chance”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!