Overnight, CPU and Memory graphs for all of my nodes stopped drawing data regardless of polling method. I can see all polled data in the database and all of the interface, volume and SAM metric charts are all working so it's confusing to me.
I see errors in the Collector log referencing CPU and memory:
019-01-25 09:54:27,586 [STP DatabaseProcessing Thread #10] ERROR SolarWinds.Collector.DBProcessing.DBProcessingWorkerWithAccess - Commit of - Core.CpuMemory.Snmp failed. System.Data.SqlClient.SqlException (0x80131904): The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
at SolarWinds.Database.TimeSeries.Helpers.SqlHelper.SolarWinds.Database.TimeSeries.Helpers.ISqlHelper.ExecuteBulkInsert(String tableName, IReadOnlyList`1 columnNames, IEnumerable`1 data, Boolean fireTriggers, IDbConnection connection)
at SolarWinds.Database.TimeSeries.Drivers.Legacy.LegacyDataInsertor.InsertData(String tableName, IReadOnlyList`1 columnNames, IEnumerable`1 data)
at SolarWinds.Orion.Core.Collector.CpuMemory.CpuMemoryPollingPlanBase.CommitResultToDatabase(Object customCollectionKey, IEnumerable`1 bags, IDBProcessingContext context)
at SolarWinds.Collector.DBProcessing.DBProcessingWorkerWithAccess.ProcessGroupItemInternal(WorkingGroup group, WorkingGroupKey key, List`1 bags)
ClientConnectionId:ee6a4852-b8ea-477b-920b-6346aad53e08
Error Number:4457,State:1,Class:16
The logs have rolled past when this started happening, so I don't have an idea of what caused this. I've done the usual configuration wizard, reinstall collector, database maintenance dance but it hasn't made a difference. There is a support ticket opened for it and I am waiting for a response, but figured I'd check here as well.
Management reports get generated from these charts, so it's going to become a larger issue for me if I can't get resolved unfortunately.
