SQL Server Errors or Failures from Error: 5854 to Error: 6102

 

Error: 5854, Severity: 16, A %S_MSG value was specified more than one time in the range list for an ALTER SERVER CONFIGURATION SET PROCESS AFFINITY statement.
Error: 5855, Severity: 16, The affinity setting was not changed. This can be caused by low system resources.
Error: 5856, Severity: 16, The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance. The maximum %S_MSG number that is available to this instance is %d.
Error: 5857, Severity: 10, CPU

Error: 5858, Severity: 10, NUMANODE
Error: 5859, Severity: 16, The current affinity setting specifies the use of more than 64 processors. Before you use sp_configure to change affinity settings, remove these processors by using ALTER SERVER CONFIGURATION.
Error: 5860, Severity: 10, Affinity changed for node %d: from 0x%0*I64x:%u to 0x%0*I64x:%u. This is an informational message only. No user action is required.
Error: 5861, Severity: 16, A %S_MSG with id %d does not exist on this system. Use sys.dm_os_schedulers to locate valid %S_MSGs for this system.
Error: 5862, Severity: 16, The number of max worker threads is set too low. On this computer, the number must be more than %u. You should increase the number of max worker threads.

Error: 5863, Severity: 16, Could not change the value of the ‘%.*ls’ property. Operating system error %ls
Error: 5864, Severity: 16, IO affinity is not supported on this edition of sql server.
Error: 5901, Severity: 16, One or more recovery units belonging to database ‘%.*ls’ failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log f
Error: 5904, Severity: 17, Unable to issue checkpoint: there are not enough locks available. Background checkpoint process will remain suspended until locks are available. To free up locks, list transactions and their locks, and terminate transactions with the highest number of loc
Error: 6001, Severity: 10, SHUTDOWN is waiting for %d process(es) to complete.
Error: 6004, Severity: 10, User does not have permission to perform this action.
Error: 6005, Severity: 10, SHUTDOWN is in progress.
Error: 6006, Severity: 10, Server shut down by %.*ls from login %.*ls.
Error: 6007, Severity: 10, The SHUTDOWN statement cannot be executed within a transaction or by a stored procedure.
Error: 6101, Severity: 16, Session ID %d is not valid.
Error: 6102, Severity: 14, User does not have permission to use the KILL statement.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.