SqlServer Hekaton could not clean up root row within 10 seconds
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 28.999999999999996%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Chris Hruska
0
Reputation points
Hi, We have been runnin SQL Server 2016 for some time now, and are seeing a lot of the following errors in the SQL Log files:
[WARNING] ALTER or DROP TABLE could not clean up root row within 10 seconds. (e:\b\s3\sources\ntdbms\hekaton\engined\core\gc.cpp : 3694) it looks like it throws this issue about once every 10-15 seconds.
How can we fix this issue?
SQL Server | Other
{count} votes
-
Erland Sommarskog 129.6K Reputation points MVP Volunteer Moderator2023-07-03T21:10:09.32+00:00 Hekaton is the code name for In-Memory OLTP. You are using this feature, I assume?
What does "SELECT @@version" report?
I have not seen this error before, but I would be inclined to restart SQL Server if that is possible.
-
Chris Hruska 0 Reputation points
2023-07-03T21:24:34.5333333+00:00 Yes, we are using In-Memory OLTP. the version is Microsoft SQL Server 2016 (SP2-CU17-GDR) (KB5014351) - 13.0.5893.48 (X64) May 24 2022 02:58:22 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)
the server service was restarted shortly before these errors.
-
Erland Sommarskog 129.6K Reputation points MVP Volunteer Moderator
2023-07-03T21:34:58.2766667+00:00 I'm afraid that I don't have much of ideas. Searching on that message I found two other hits beside this thread. In these hits where were also other errors. And since SQL 2016 is in extended support, there may not be much point in opening a support case, but maybe that is the best path - unless a restart actually resolves the issue.
-
Erland Sommarskog 129.6K Reputation points MVP Volunteer Moderator
2023-07-03T22:03:48.33+00:00 By the way, beside the errorlog being flooded, do you see any other issues on the system? Does DBCC has anything to report?
Sign in to comment
Sign in to answer