Problem with SQL Server 2019 in docker on synology nas
Hi to all,
I installed SQL SERVER 2019 datagrip from docker on synology nas. My nas turns off automatically everyday at 01:00 and restarts at 06:00. Sometimes the NAS does not shut down because SQL Server does not start properly and the instance can not be terminated. If I trie to kill the instance manually even with sudo, the istance stays open.
Can you help me or advise me on how to solve the problem?
Log of the error:
2024/10/29 06:06:14
stdout
Tue Oct 29 05:06:14 UTC 2024 Not compressing the dump files, moving instead to: /var/opt/mssql/log/core.sqlservr.10_29_2024_05_06_10.87.d
2024/10/29 06:06:12
stdout
Tue Oct 29 05:06:12 UTC 2024 Capturing program binaries
2024/10/29 06:06:12
stdout
Moving logs to /var/opt/mssql/log/core.sqlservr.87.temp/log/paldumper-debug.log
2024/10/29 06:06:12
stdout
Dump already generated: /var/opt/mssql/log/core.sqlservr.10_29_2024_5_6_8.87, moving to /var/opt/mssql/log/core.sqlservr.87.temp/core.sqlservr.87.gdmp
2024/10/29 06:06:12
stdout
Tue Oct 29 05:06:12 UTC 2024 Capturing program information
2024/10/29 06:06:12
stdout
No journal files were found.
2024/10/29 06:06:12
stdout
No journal files were found.
2024/10/29 06:06:10
stdout
Capturing core dump and information to /var/opt/mssql/log...
2024/10/29 06:06:10
stdout
Ubuntu 16.04.6 LTS
2024/10/29 06:06:09
stdout
2024/10/29 06:06:09
stdout
/var/opt/mssql/log/core.sqlservr.10_29_2024_5_6_8.87
2024/10/29 06:06:09
stdout
2024/10/29 06:06:09
stdout
b9490fb3-e4a4-4af6-8c33-04dd6572c500
2024/10/29 06:06:09
stdout
ef64a5a2-c3b1-4d1b-9a7a-db39e0a398c1
2024/10/29 06:06:09
stdout
2024/10/29 06:06:09
stdout
/var/opt/mssql/log/
2024/10/29 06:06:09
stdout
/opt/mssql/bin
2024/10/29 06:06:09
stdout
87
2024/10/29 06:06:09
stdout
/opt/mssql/bin/sqlservr
2024/10/29 06:06:09
stdout
handle-crash.sh
2024/10/29 06:06:09
stdout
Executing: /opt/mssql/bin/handle-crash.sh with parameters
2024/10/29 06:06:09
stdout
Successfully captured dump: /var/opt/mssql/log/core.sqlservr.10_29_2024_5_6_8.87
2024/10/29 06:06:08
stdout
Capturing a dump of 87
2024/10/29 06:06:08
stdout
Last errno text: No such file or directory
2024/10/29 06:06:08
stdout
Last errno: 2
2024/10/29 06:06:08
stdout
Timestamp: Tue Oct 29 05:06:08 2024
2024/10/29 06:06:08
stdout
Total Memory: 33629888512 bytes
2024/10/29 06:06:08
stdout
Processors: 8
2024/10/29 06:06:08
stdout
Distribution: Ubuntu 16.04.6 LTS
2024/10/29 06:06:08
stdout
Build stamp: 82c124b437032b3bd5fa2d4a778ccd5f3b5ecd96c42089b421e400714d9e97fb
2024/10/29 06:06:08
stdout
Crash Id: b9490fb3-e4a4-4af6-8c33-04dd6572c500
2024/10/29 06:06:08
stdout
Instance Id: ef64a5a2-c3b1-4d1b-9a7a-db39e0a398c1
2024/10/29 06:06:08
stdout
Thread: 206 (application thread 0x1d8)
2024/10/29 06:06:08
stdout
Process: 87 - sqlservr
2024/10/29 06:06:08
stdout
file:///windows/system32/ntdll.dll=45137AA3F9814512B3123991067EEE6E2
2024/10/29 06:06:08
stdout
file:///Windows/SYSTEM32/KERNEL32.DLL=C715300FB2664729A6126A3F591E6F302
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll=6FFB7B27BC2A465E8099B496D00BAAC02
2024/10/29 06:06:08
stdout
file:///binn/sqlservr.exe=8956F54BC3EC44DE96B50E5655C830E42
2024/10/29 06:06:08
stdout
file:///binn/sqlmin.dll=1614C9333C364972BECDCEFA3A6EB9E72
2024/10/29 06:06:08
stdout
file:///Windows/SYSTEM32/KERNELBASE.dll=ACB8C8887582458AADBABAF6F2400B2C2
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll=04539DF05A6D11220BDCACD5910ED7B91
2024/10/29 06:06:08
stdout
Modules:
2024/10/29 06:06:08
stdout
file:///windows/system32/ntdll.dll+0x0000000000075541
2024/10/29 06:06:08
stdout
file:///Windows/SYSTEM32/KERNEL32.DLL+0x0000000000014414
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x000000000003461A
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x0000000000033E6F
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x00000000000342B2
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x000000000000A1DE
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x000000000000A61F
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x0000000000009FD3
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x00000000001149A9
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x0000000000015C72
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x00000000000163B2
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x000000000001725F
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x000000000007E78B
2024/10/29 06:06:08
stdout
file:///binn/sqldk.dll+0x00000000000A6A20
2024/10/29 06:06:08
stdout
file:///binn/sqlservr.exe+0x0000000000003DC9
2024/10/29 06:06:08
stdout
file:///binn/sqlmin.dll+0x00000000001F0217
2024/10/29 06:06:08
stdout
file:///binn/sqlmin.dll+0x00000000001EFF38
2024/10/29 06:06:08
stdout
file:///Windows/SYSTEM32/KERNELBASE.dll+0x0000000000070A5F
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x00000000002023A8
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x0000000000003D1F
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000005A269
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000005D19C
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000005D621
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000006B929
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x00000000000A272E
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x0000000000013F3B
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000000CEF3
2024/10/29 06:06:08
stdout
file://package5/windows/system32/sqlpal.dll+0x000000000000E16F
2024/10/29 06:06:08
stdout
Stack Trace:
2024/10/29 06:06:08
stdout
Message: RETAIL ASSERT: Expression=(!"A timeout or deadlock was encountered while waiting" " for a thread to terminate/suspend/resume.") File=NtumWaiter.cpp Line=702
2024/10/29 06:06:08
stdout
Reason: 0x00000004
2024/10/29 06:06:08
stdout
2024/10/29 06:06:08
stdout
The following diagnostic information is available:
2024/10/29 06:06:08
stdout
This program has encountered a fatal error and cannot continue running at Tue Oct 29 05:06:08 2024
2024/10/29 06:03:26
stdout
=============== MSSQL SERVER SUCCESSFULLY STARTED ==========================
请先登录再写评论。