none
SQL Server 2016 in-memory optimized tables error RRS feed

  • Question

  • Recently we frequently got some errors like:

    [WARNING] === At least 4 extensions for file {005811BF-0722-4108-ABEF-9C629E11E18C}
    (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)

    There is not much info online regarding this.

    What is the nature of this error?  what is its causes and how can we get rid of it?

    Thanks,

    • Moved by Olaf HelperMVP Saturday, January 20, 2018 4:33 AM Moved from "Database Engine" to a more related forum
    Tuesday, July 18, 2017 7:00 PM

All replies

  • Hi Sheng Wang,

     

    When did you meet this warning? Did you execute some operation like checkpoint? Besides, could you please share the full error message to us for analysis? You can find related error from C:\Program Files\Microsoft SQL Server\MSSQL13.****\MSSQL\Log

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, July 19, 2017 6:14 AM
  • Thanks for your response.

    This SQL server 2016 enterprise edition sp CU3 on window server 2012 R2.  The in-memory optimized tables are deployed in this dedicated sql server box.   It occurs randomly.

    Here is the log of this morning.

    2017-07-19 00:00:00.38 spid58      Microsoft SQL Server 2016 (SP1-CU3) (KB4019916) - 13.0.4435.0 (X64)
     Apr 27 2017 17:36:12
     Copyright (c) Microsoft Corporation
     Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

    2017-07-19 00:00:00.38 spid58      UTC adjustment: -4:00
    2017-07-19 00:00:00.39 spid58      (c) Microsoft Corporation.
    2017-07-19 00:00:00.39 spid58      All rights reserved.
    2017-07-19 00:00:00.39 spid58      Server process ID is 1328.
    2017-07-19 00:00:00.39 spid58      System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
    2017-07-19 00:00:00.39 spid58      Authentication mode is MIXED.
    2017-07-19 00:00:00.39 spid58      Logging SQL Server messages in file 'M:\mssql\data\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2017-07-19 00:00:00.39 spid58      The service account is 'TN\SVC_APDWEBCAT14_E'. This is an informational message; no user action is required.
    2017-07-19 00:00:00.39 spid58      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
    2017-07-19 00:00:00.39 spid58      The error log has been reinitialized. See the previous log for older entries.
    2017-07-19 00:00:01.57 Server      [WARNING] === At least 4 extensions for file {6D04F425-6209-43DF-8507-55F929E1B44B} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:00:04.27 spid68      AppDomain 28 (master.sys[runtime].27) created.
    2017-07-19 00:00:38.88 spid38s     This instance of SQL Server has been using a process ID of 1328 since 6/18/2017 5:18:57 AM (local) 6/18/2017 9:18:57 AM (UTC). This is an informational message only; no user action is required.
    2017-07-19 00:00:44.44 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19619).
    2017-07-19 00:01:12.97 Server      [WARNING] === At least 4 extensions for file {029B868D-ACC2-492B-8A4B-9130C9459736} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:02:31.00 spid20s     FlushCache: cleaned up 34513 bufs with 18156 writes in 73736 ms (avoided 4718 new dirty bufs) for db 6:0
    2017-07-19 00:02:31.00 spid20s                 average writes per second: 246.23 writes/sec
                average throughput:   3.65 MB/sec, I/O saturation: 13553, context switches 20814
    2017-07-19 00:02:31.00 spid20s                 last target outstanding: 40, avgWriteLatency 32
    2017-07-19 00:05:02.69 spid52      SQL Trace ID 2 was started by login "TN\svc_sqlsentry".
    2017-07-19 00:06:23.18 spid20s     FlushCache: cleaned up 55114 bufs with 28220 writes in 171440 ms (avoided 33673 new dirty bufs) for db 6:0
    2017-07-19 00:06:23.18 spid20s                 average writes per second: 164.61 writes/sec
                average throughput:   2.51 MB/sec, I/O saturation: 17603, context switches 22653
    2017-07-19 00:06:23.18 spid20s                 last target outstanding: 2716, avgWriteLatency 88
    2017-07-19 00:07:46.39 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19620).
    2017-07-19 00:09:47.98 spid20s     FlushCache: cleaned up 85396 bufs with 43138 writes in 144500 ms (avoided 22420 new dirty bufs) for db 6:0
    2017-07-19 00:09:47.98 spid20s                 average writes per second: 298.53 writes/sec
                average throughput:   4.62 MB/sec, I/O saturation: 27718, context switches 43838
    2017-07-19 00:09:47.98 spid20s                 last target outstanding: 5520, avgWriteLatency 20
    2017-07-19 00:12:39.31 spid20s     FlushCache: cleaned up 64587 bufs with 32734 writes in 110042 ms (avoided 21188 new dirty bufs) for db 6:0
    2017-07-19 00:12:39.31 spid20s                 average writes per second: 297.47 writes/sec
                average throughput:   4.58 MB/sec, I/O saturation: 21378, context switches 32718
    2017-07-19 00:12:39.31 spid20s                 last target outstanding: 5520, avgWriteLatency 6
    2017-07-19 00:12:58.85 Server      [WARNING] === At least 4 extensions for file {FDCD02D2-0AC5-4709-AD38-02A591DE6790} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:13:51.95 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19621).
    2017-07-19 00:15:25.92 spid20s     FlushCache: cleaned up 64054 bufs with 35632 writes in 106137 ms (avoided 25710 new dirty bufs) for db 6:0
    2017-07-19 00:15:25.92 spid20s                 average writes per second: 335.72 writes/sec
                average throughput:   4.71 MB/sec, I/O saturation: 21083, context switches 31168
    2017-07-19 00:15:25.92 spid20s                 last target outstanding: 1238, avgWriteLatency 4
    2017-07-19 00:18:28.31 spid20s     FlushCache: cleaned up 71084 bufs with 38724 writes in 121726 ms (avoided 22964 new dirty bufs) for db 6:0
    2017-07-19 00:18:28.31 spid20s                 average writes per second: 318.12 writes/sec
                average throughput:   4.56 MB/sec, I/O saturation: 21383, context switches 32879
    2017-07-19 00:18:28.31 spid20s                 last target outstanding: 5520, avgWriteLatency 83
    2017-07-19 00:19:52.33 spid21s     [WARNING] === At least 4 extensions for file {0E31C3FD-7D7C-4DE2-A39A-4D8224D129B4} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:19:53.30 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19622).
    2017-07-19 00:21:01.75 spid20s     FlushCache: cleaned up 59575 bufs with 31548 writes in 92983 ms (avoided 14490 new dirty bufs) for db 6:0
    2017-07-19 00:21:01.75 spid20s                 average writes per second: 339.29 writes/sec
                average throughput:   5.00 MB/sec, I/O saturation: 17099, context switches 24405
    2017-07-19 00:21:01.75 spid20s                 last target outstanding: 30, avgWriteLatency 36
    2017-07-19 00:25:23.58 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19623).
    2017-07-19 00:25:46.92 Server      [WARNING] === At least 4 extensions for file {5682C5F3-B88C-4A0A-90AD-D1E5FF5A67C3} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:26:21.89 Server      [WARNING] === At least 4 extensions for file {8B9AA5DD-E5D8-40CA-A533-22D3160495AF} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:39:25.07 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19624).
    2017-07-19 00:48:50.35 spid34s     [WARNING] === At least 4 extensions for file {C70B26F3-A555-4602-BEC7-B8653CFD15EB} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 00:53:31.61 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19625).
    2017-07-19 00:54:01.50 Server      [WARNING] === At least 4 extensions for file {FD9C7EE1-0A08-4E32-B986-5986AF8B1F80} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 01:13:20.55 Server      [WARNING] === At least 4 extensions for file {65EEAFE6-9A11-4C8C-8FE9-4632B1DBF6C7} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 01:13:56.50 Server      [WARNING] === At least 4 extensions for file {281251C4-DAE7-45FF-B9E4-D918EED9F3B0} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 01:14:34.57 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19626).
    2017-07-19 01:15:49.45 spid20s     FlushCache: cleaned up 38037 bufs with 25782 writes in 88443 ms (avoided 23942 new dirty bufs) for db 6:0
    2017-07-19 01:15:49.45 spid20s                 average writes per second: 291.51 writes/sec
                average throughput:   3.36 MB/sec, I/O saturation: 14744, context switches 21676
    2017-07-19 01:15:49.45 spid20s                 last target outstanding: 5520, avgWriteLatency 9
    2017-07-19 01:18:59.65 spid20s     FlushCache: cleaned up 73140 bufs with 43363 writes in 129765 ms (avoided 20533 new dirty bufs) for db 6:0
    2017-07-19 01:18:59.65 spid20s                 average writes per second: 334.17 writes/sec
                average throughput:   4.40 MB/sec, I/O saturation: 23687, context switches 34444
    2017-07-19 01:18:59.65 spid20s                 last target outstanding: 5520, avgWriteLatency 11
    2017-07-19 01:30:41.78 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19627).
    2017-07-19 01:37:22.30 Server      [WARNING] === At least 4 extensions for file {FF9C340E-B0AE-4C2A-B244-F012C751B40F} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 01:49:28.46 Server      [WARNING] === At least 4 extensions for file {0846B895-F132-453A-8925-364F594C4245} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 01:50:44.45 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19628).
    2017-07-19 02:02:34.36 Server      [WARNING] === At least 4 extensions for file {6BFEFCD2-5A37-4CE7-A12A-A128F193FC1E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 02:07:20.60 Server      [WARNING] === At least 4 extensions for file {6230D252-39DC-45FE-A08F-23CDFCDE2471} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 02:08:46.83 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19629).
    2017-07-19 02:15:25.67 Server      [WARNING] === At least 4 extensions for file {3C87051D-2655-408B-B9CB-ABD82E7BB2CF} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 02:21:48.81 spid21s     [WARNING] === At least 4 extensions for file {9AAD9D96-34CA-4DAD-B8E0-BEA4338162DB} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 02:21:49.14 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19630).
    2017-07-19 02:44:53.35 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19631).
    2017-07-19 02:49:45.25 Server      [WARNING] === At least 4 extensions for file {FB6BDAE4-6629-4D2F-BC32-F4B0590D72BD} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 03:00:03.46 Backup      Database backed up. Database: master, creation date(time): 2017/06/18(05:18:57), pages dumped: 531, first LSN: 1880:158:83, last LSN: 1880:193:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\A10b027\datahotstore\PROD\APDWEBCAT14\master\FULL\APDWEBCAT14_master_FULL_20170719_030001.bak'}). This is an informational message only. No user action is required.
    2017-07-19 03:00:03.49 Backup      BACKUP DATABASE successfully processed 523 pages in 1.558 seconds (2.618 MB/sec).
    2017-07-19 03:00:05.47 Backup      Database backed up. Database: model, creation date(time): 2003/04/08(09:13:36), pages dumped: 338, first LSN: 36:1991:37, last LSN: 36:2008:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\A10b027\datahotstore\PROD\APDWEBCAT14\model\FULL\APDWEBCAT14_model_FULL_20170719_030004.bak'}). This is an informational message only. No user action is required.
    2017-07-19 03:00:05.50 Backup      BACKUP DATABASE successfully processed 330 pages in 0.359 seconds (7.161 MB/sec).
    2017-07-19 03:00:09.62 Backup      Database backed up. Database: msdb, creation date(time): 2016/04/30(00:46:38), pages dumped: 5006, first LSN: 77491:1207:254, last LSN: 77491:1312:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\A10b027\datahotstore\PROD\APDWEBCAT14\msdb\FULL\APDWEBCAT14_msdb_FULL_20170719_030006.bak'}). This is an informational message only. No user action is required.
    2017-07-19 03:00:09.66 Backup      BACKUP DATABASE successfully processed 4967 pages in 2.972 seconds (13.055 MB/sec).
    2017-07-19 03:03:41.53 Server      [WARNING] === At least 4 extensions for file {2BCE640E-0E2B-4276-B95F-97C725F34995} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 03:07:57.19 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19632).
    2017-07-19 03:13:29.74 Server      [WARNING] === At least 4 extensions for file {64E5F207-E790-4127-B9FB-C1DC8409D504} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 03:15:05.53 Server      [WARNING] === At least 4 extensions for file {92884C49-2906-474F-824E-3368A2B1E073} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 03:28:59.86 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19633).
    2017-07-19 03:51:02.94 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19634).
    2017-07-19 04:24:08.57 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19635).
    2017-07-19 04:56:43.24 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19636).
    2017-07-19 04:56:51.35 Server      [WARNING] === At least 4 extensions for file {A8B133CE-31A1-4579-99E4-F90777F56DD8} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:20:46.65 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19637).
    2017-07-19 05:22:14.57 Server      [WARNING] === At least 4 extensions for file {FA38C19F-1654-447F-B9A9-7E07AE04022B} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:24:59.36 Server      [WARNING] === At least 4 extensions for file {327ABB85-38E5-4344-B59B-A6A2AF105507} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:27:17.38 Server      [WARNING] === At least 4 extensions for file {F646006F-0FD8-4B81-B89F-18C61250DF97} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:27:27.79 Server      [WARNING] === At least 4 extensions for file {C82F251E-9D79-43B0-9DE1-8BC20A23ACC3} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:32:19.04 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19638).
    2017-07-19 05:36:28.20 Server      [WARNING] === At least 4 extensions for file {F531E2DD-00A3-45FB-9A98-0EB49CE9225E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:37:46.80 Server      [WARNING] === At least 4 extensions for file {59E821F4-6CB9-4F40-AF81-AC1AE36D2F7E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 05:44:20.29 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19639).
    2017-07-19 05:44:27.36 Server      [WARNING] === At least 4 extensions for file {E36C39F6-FB14-4CC4-AA2E-63F3D0721ABB} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 06:00:17.68 Server      [WARNING] === At least 4 extensions for file {50236D00-15D0-4D08-B843-9DA3401A7113} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 06:07:53.42 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19640).
    2017-07-19 06:12:45.80 Server      [WARNING] === At least 4 extensions for file {1CACF2A9-E376-47B5-AB78-BF5EC628066B} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 06:23:28.13 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19641).
    2017-07-19 06:50:09.36 Server      [WARNING] === At least 4 extensions for file {062F29E3-ABCB-4BB4-946F-C4ACFF9CE171} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 06:53:01.48 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19642).
    2017-07-19 07:11:01.68 Server      [WARNING] === At least 4 extensions for file {DEE644FD-2C6C-4D58-9836-2015027BD06E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 07:11:03.71 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19643).
    2017-07-19 07:11:13.08 Server      [WARNING] === At least 4 extensions for file {3A1B5DB3-30AA-45D8-95A8-4F06CDC87F7D} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 07:13:18.97 Server      [WARNING] === At least 4 extensions for file {1D8922FD-40BC-4CA6-9E87-A8CD53F166F4} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 07:15:01.37 Server      [WARNING] === At least 4 extensions for file {2A6AB44C-A89F-4322-9374-32BBC86B83ED} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 07:23:35.35 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19644).
    2017-07-19 07:40:28.76 Server      [WARNING] === At least 4 extensions for file {225E3546-ABA2-49A1-9D16-B8F18B52601F} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 07:41:37.30 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19645).
    2017-07-19 07:55:38.82 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19646).
    2017-07-19 07:58:52.93 Server      [WARNING] === At least 4 extensions for file {1FECFD99-38E6-44E9-9C07-A3EDD50A901D} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:05:39.87 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19647).
    2017-07-19 08:06:15.00 Server      [WARNING] === At least 4 extensions for file {B29F6A95-BDF0-4364-872E-0E3C6128CE93} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:10:19.57 Server      [WARNING] === At least 4 extensions for file {17B24AE0-6B45-4C56-BD86-9F80CD1AC109} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:15:10.54 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19648).
    2017-07-19 08:19:36.84 spid34s     [WARNING] === At least 4 extensions for file {AD464179-E0E5-47B5-A1AC-C9910AABA710} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:20:41.60 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19649).
    2017-07-19 08:21:34.61 Server      [WARNING] === At least 4 extensions for file {490499A1-12BE-4E4E-87C0-13C024A8D958} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:29:12.22 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19650).
    2017-07-19 08:31:33.65 Server      [WARNING] === At least 4 extensions for file {62D2D557-36C0-4B64-9687-750197226ADA} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:34:35.65 Server      [WARNING] === At least 4 extensions for file {5D728B3A-5E83-4ECA-8C86-586B7193668D} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:38:42.79 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19651).
    2017-07-19 08:39:08.72 Server      [WARNING] === At least 4 extensions for file {6B026B14-1FB5-44C0-80D8-4B59C5BC481C} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:49:13.50 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19652).
    2017-07-19 08:51:56.23 Server      [WARNING] === At least 4 extensions for file {6F142690-687C-492C-A40D-09F37635BC2C} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:55:51.74 Server      [WARNING] === At least 4 extensions for file {07C4B898-909C-4088-91BC-1BC99F5175FD} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:57:41.97 Server      [WARNING] === At least 4 extensions for file {4EEF3405-78B3-4213-B42A-54F0C042AB3E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 08:57:44.08 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19653).
    2017-07-19 09:06:39.71 spid20s     FlushCache: cleaned up 30151 bufs with 21486 writes in 71899 ms (avoided 8221 new dirty bufs) for db 6:0
    2017-07-19 09:06:39.71 spid20s                 average writes per second: 298.84 writes/sec
                average throughput:   3.27 MB/sec, I/O saturation: 13460, context switches 20568
    2017-07-19 09:06:39.71 spid20s                 last target outstanding: 2736, avgWriteLatency 155
    2017-07-19 09:14:46.65 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19654).
    2017-07-19 09:15:24.62 spid20s     FlushCache: cleaned up 66510 bufs with 38030 writes in 70608 ms (avoided 18020 new dirty bufs) for db 6:0
    2017-07-19 09:15:24.62 spid20s                 average writes per second: 538.61 writes/sec
                average throughput:   7.35 MB/sec, I/O saturation: 18102, context switches 24707
    2017-07-19 09:15:24.62 spid20s                 last target outstanding: 2, avgWriteLatency 36
    2017-07-19 09:23:45.96 Server      [WARNING] === At least 4 extensions for file {B4A321B9-3896-46FF-AF22-DCC873995489} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:23:47.29 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19655).
    2017-07-19 09:30:38.28 Server      [WARNING] === At least 4 extensions for file {ED9A7656-13DE-40A6-91ED-402ADDA66BDA} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:35:17.79 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19656).
    2017-07-19 09:36:55.02 spid20s     FlushCache: cleaned up 43155 bufs with 29160 writes in 73917 ms (avoided 15366 new dirty bufs) for db 6:0
    2017-07-19 09:36:55.02 spid20s                 average writes per second: 394.50 writes/sec
                average throughput:   4.56 MB/sec, I/O saturation: 17100, context switches 26211
    2017-07-19 09:36:55.02 spid20s                 last target outstanding: 3160, avgWriteLatency 3
    2017-07-19 09:39:07.76 spid20s     FlushCache: cleaned up 74212 bufs with 46784 writes in 72406 ms (avoided 10330 new dirty bufs) for db 6:0
    2017-07-19 09:39:07.76 spid20s                 average writes per second: 646.13 writes/sec
                average throughput:   8.00 MB/sec, I/O saturation: 22982, context switches 30728
    2017-07-19 09:39:07.76 spid20s                 last target outstanding: 8, avgWriteLatency 7
    2017-07-19 09:47:48.49 spid21s     [WARNING] === At least 4 extensions for file {EDC04798-351C-4B5A-82B8-6AAED4AA208F} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:47:48.82 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19657).
    2017-07-19 09:48:44.47 Server      [WARNING] === At least 4 extensions for file {2537ED8B-40AE-4635-BD96-1E5410EA2230} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:52:25.71 Server      [WARNING] === At least 4 extensions for file {5E721ED0-8CDD-4605-B484-C2BB1E8B623E} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:58:48.73 Server      [WARNING] === At least 4 extensions for file {F0791BE1-C758-4FBE-A4B8-0739377F327F} (d:\b\s3\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 5912)
    2017-07-19 09:59:20.64 spid21s     [INFO] Database ID: [6]. Deleting unrecoverable checkpoint table row (id: 19658).
    2017-07-19 09:59:35.58 spid20s     FlushCache: cleaned up 56988 bufs with 41208 writes in 69930 ms (avoided 10286 new dirty bufs) for db 6:0
    2017-07-19 09:59:35.58 spid20s                 average writes per second: 589.27 writes/sec
                average throughput:   6.36 MB/sec, I/O saturation: 15821, context switches 19729
    2017-07-19 09:59:35.58 spid20s                 last target outstanding: 3950, avgWriteLatency 11

    Wednesday, July 19, 2017 2:05 PM
  • Let me know if you need more info.  Thanks,
    Wednesday, July 19, 2017 2:05 PM
  • Hi Sheng Wang,

     

    Based on the error message, this problem can be related to transactional log file and checkpoint.

     

    We are currently looking into this issue and will give you an update as soon as possible. Thank you for your understanding and support.

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, July 21, 2017 6:15 AM
  • Greatly appreciated.
    Friday, July 21, 2017 12:08 PM
  • Any finding on this yet?
    Tuesday, August 1, 2017 5:40 PM