mssql-docker icon indicating copy to clipboard operation
mssql-docker copied to clipboard

sqlservr crashes on ressource temporarily not available

Open FootStark opened this issue 3 years ago • 1 comments

My container crashes on an access to a temporarily not available ressource. Access method: xp_dirtree to a mapped cifs-Volume.

Container image: 2019-CU17-ubuntu-20.04 Running: Microsoft SQL Server 2019 (RTM-CU17) (KB5016394) - 15.0.4249.2 (X64) Express Edition Host-OS: Ubuntu Server 22.04 LTS

Is this a known error or can it be related to Host-OS version (Ubuntu Server 22.04) != Container OS version (20.04.04)? Any workarounds?

Crash-Message (core.sqlservr.09_05_2022_19_00_02.24.txt):

This program has encountered a fatal error and cannot continue running at Mon Sep  5 19:00:02 2022
The following diagnostic information is available:

         Reason: 0x00000003
         Status: 0x0000000b
        Message: Invalid switch case with switch(status.ToDkStatus()) encountering unexpected value = 18446744072635809793
          Stack:
                 IP               Function
                 ---------------- --------------------------------------
                 000055e222345a9c <unknown>
                 000055e2223454e2 <unknown>
                 000055e2222a6326 <unknown>
                 000055e2222a63bd <unknown>
                 000055e2222bed6b <unknown>
                 000055e222356691 <unknown>
        Process: 24 - sqlservr
         Thread: 8302 (application thread 0x2c0)
    Instance Id: f25a4429-fc5b-4eb5-85eb-f747e0f47c21
       Crash Id: 0674bcbd-e39e-4905-ad3d-a8f41edfbec2
    Build stamp: e5dea205d0938e2848fb2509856a7e8f30783e6d5f62d0c88355e288de0db89a
   Distribution: Ubuntu 20.04.4 LTS
     Processors: 10
   Total Memory: 3724021760 bytes
      Timestamp: Mon Sep  5 19:00:02 2022
     Last errno: 11
Last errno text: Resource temporarily unavailable

FootStark avatar Sep 06 '22 12:09 FootStark

Are you trying to connect on the first time starting sqlserver, with an empty data directory in particular?

I've found that sometimes, if I try to connect a client too quickly, it will mess up during initialization.

tracker1 avatar Sep 14 '22 21:09 tracker1