Database Manager error 'system out of memory exception was thrown'

e.jenidy

I'm getting error while executing below query, can anyone advise what could be the reason.

select * from InterfaceTraffic_Detail

Logs

2019-12-16 07:58:50,329 [6] ERROR SolarWinds.DatabaseManager.Controls.Models.SQLManager - An error occurred while executing SQL query "select * from InterfaceTraffic_Detail"

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

   at System.Data.Common.DateTimeStorage.SetCapacity(Int32 capacity)

   at System.Data.RecordManager.set_RecordCapacity(Int32 value)

   at System.Data.RecordManager.GrowRecordCapacity()

   at System.Data.RecordManager.NewRecordBase()

   at System.Data.DataTable.NewRecordFromArray(Object[] value)

   at System.Data.DataTable.LoadRow(Object[] values, LoadOption loadOption, Index searchIndex)

   at System.Data.DataTable.LoadDataRow(Object[] values, LoadOption loadOption)

   at System.Data.ProviderBase.SchemaMapping.LoadDataRow()

   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)

   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)

   at SolarWinds.DatabaseManager.Controls.Models.SQLManager.GetData(String connString, String sqlCommand)

2019-12-16 07:59:04,969 [6] ERROR SolarWinds.DatabaseManager.Controls.Models.SQLManager - System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

   at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)

   at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)

   at SolarWinds.DatabaseManager.Controls.Models.EditTableLoader.sqlManager_QueryExecuted(Object sender, GenericEventArgs`1 e)

   at SolarWinds.DatabaseManager.Controls.Models.SQLManager.QueryExecutedHandler(GenericEventArgs`1 e)

   at SolarWinds.DatabaseManager.Controls.Models.SQLManager.GetDataAsync()

mesverrum

Can you right click the table details and see how large the table is?

How many interfaces do you have and what is your polling interval for interface metrics set to?

Do you know if the nightly maintenance job is completing successfully?

It's not uncommon for that to be one of the largest tables in the database, and the specific size that would be "normal" depends on your particulars, but its a fair guess to say anything bigger than a gig is likely to cause errors in the db manager viewer and you would have to something like select top 10,000 from interfacetraffic_detail or filter it against a specific interfaceid to keep from trying to pull back a mountain of data.  Also, if your maintenance isn't working I have seen cases where the details tables never get aged out and cleared appropriately and they very quickly become way too big and have performance problems in various places in the application.  One way to spot check for this is just to query for the min(datetime) or timestamp, i don't recall off the top of my head, to make sure it matches up with the retention period you set.