Skip to main content

 none
In-Mmory OLTP tables is crashing a database RRS feed

  • Question

  • Hi Experts,

    Our database is going to suspect mode after SQL is getting restarted.

    Further scrutinizing, we could see surplus space in OLTP In-memory filegroup.So kindly help to check on the issue based on below logs.

    Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{0A5F80AB-2DB8-421E-AB01-C9EC2ED1F215}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
    [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
       [WARNING] Database ID: [6]. Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{3E9AB42B-2830-469F-8E3F-3FAA3AB7606D}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
    [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
      [WARNING] Database ID: [6]. Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{F45E0049-CB14-4286-BC31-D5678D81601E}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
      [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
    [WARNING] Database ID: [6]. Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{50E2314D-4916-46D2-BF5E-2034CC484F3D}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
      [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
      [WARNING] Database ID: [6]. Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{031AEB33-4670-4B73-A644-16545EB9C794}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
     [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
      [WARNING] Database ID: [6]. Failed to create new file 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\{AB62B3CF-C4EF-4BC5-A949-4BDF8D6A3D8D}.hkckp'. Error code: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\stgutil.cpp : 171)
     [WARNING] Database ID: [6]. Container ID: [{B63A9CA0-1367-4348-A464-6F7254D786F4}]. Container Path: [K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\]. Failed to allocate free file in container, will try again later. Error: 0x88000028. (e:\b\s3\sources\sql\ntdbms\hekaton\stglib\freefilemgr.cpp : 725)
    [INFO] Database ID: [6]. Failed to open/create file of type '2' in container 'K:\MSSQL13.MSSQLSERVER\MSSQL\Data\XXXXXX_mod_dir\$HKv2\'. Error code: 0x88000028. Retrying the operation (1).

    So kindly do check and let us know if you need any more information on this matter.Thank you

    Regards,

    Naren poosa

    Monday, October 14, 2019 12:34 PM

All replies