Database Maintenance Overdue - Summarizing Detailed Wireless_AccessPoints

Question

I just noticed that the database maintenance has been overdue on my 2020.2.4 environment. When I look at the swdebugmaintenance.log I'm seeing that the last thing it is doing is Summarizing Detailed Wireless_AccessPoints.  It looks to have been running for 8 hours.  Is there somewhere else I can look to see why it is taking so long?

bharris1 · Answer

An update on this, it looks like everything seems to work fairly well until it gets to the Wireless part of the maintenance. Once it hits the Wireless portion it just slows to a crawl and most of the time it just sits and I can't tell if it is progressing slowly or if it has hung.  The detailed Wireless_AccessPoints step took over 8 hours to finish, which seems insane.

I've seen other threads about the wireless portion taking a long time but no follow up on if or how it was fixed.

bharris1 · Answer

I let it run overnight and it is still on that step. In the logs I'm seeing these debug messages relating to HA. I don't have HA set up so I'm wondering why they are popping up. Here is what the log is showing - after it shows the summarizing detailed data line, I get the HA lines every 2-5 minutes. There has been no new "AccessPoint" lines since 856AM. 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Beginning Maintenance for Wireless_AccessPoints 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Remove orphaned data from Wireless_AccessPoints' started 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Remove orphaned data from Wireless_AccessPoints' finished, time elapsed: 0.000 sec. 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Compute baseline statistics from Wireless_AccessPoints' started 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Compute baseline statistics from Wireless_AccessPoints' finished, time elapsed: 0.000 sec. 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Compute forecast coefficients from Wireless_AccessPoints' started 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Compute forecast coefficients from Wireless_AccessPoints' finished, time elapsed: 0.000 sec. 2021-05-28 08:56:52,611 [4] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Summarize detailed data from Wireless_AccessPoints' started 2021-05-28 08:56:52,611 [4] DEBUG SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Executing Wireless_AccessPoints_DetailToHourly( @date=5/21/2021 12:00:00 AM ) 2021-05-28 08:58:20,737 [9] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: IF EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'[dbo].[HA_PoolMembersView]') AND type in (N'V')) AND EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'dbo.HA_PoolMembers') AND type in (N'U')) BEGIN SELECT PoolMemberId, PoolMemberType, PoolId, HostName, ElectionPriority, Priority, PreferredStatus, PreferredStatusTimestamp, PreferredStatusRevision, Status, StatusMessage, ReasonOfFail, ReasonOfFailRevision, HeartBeat, LastHeartBeatTimestamp, PoolIdRevision FROM dbo.HA_PoolMembersView WHERE PoolId<>0 AND (PoolMemberType='MainPoller' OR PoolMemberType='MainPollerStandby') ORDER BY HostName END 2021-05-28 08:58:20,737 [9] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT TOP 1 ServerName FROM dbo.Engines WITH (NOLOCK) WHERE ServerType = 'Primary' ORDER BY KeepAlive DESC 2021-05-28 08:58:20,737 [9] DEBUG SolarWinds.Orion.Swis.PubSub.MessageBus.MessageBusTopologyProvider - No message bus host change detected. 2021-05-28 09:00:20,751 [11] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: IF EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'[dbo].[HA_PoolMembersView]') AND type in (N'V')) AND EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'dbo.HA_PoolMembers') AND type in (N'U')) BEGIN SELECT PoolMemberId, PoolMemberType, PoolId, HostName, ElectionPriority, Priority, PreferredStatus, PreferredStatusTimestamp, PreferredStatusRevision, Status, StatusMessage, ReasonOfFail, ReasonOfFailRevision, HeartBeat, LastHeartBeatTimestamp, PoolIdRevision FROM dbo.HA_PoolMembersView WHERE PoolId<>0 AND (PoolMemberType='MainPoller' OR PoolMemberType='MainPollerStandby') ORDER BY HostName END 2021-05-28 09:00:20,751 [11] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT TOP 1 ServerName FROM dbo.Engines WITH (NOLOCK) WHERE ServerType = 'Primary' ORDER BY KeepAlive DESC 2021-05-28 09:00:20,751 [11] DEBUG SolarWinds.Orion.Swis.PubSub.MessageBus.MessageBusTopologyProvider - No message bus host change detected. 2021-05-28 09:02:20,770 [11] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: IF EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'[dbo].[HA_PoolMembersView]') AND type in (N'V')) AND EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'dbo.HA_PoolMembers') AND type in (N'U')) BEGIN SELECT PoolMemberId, PoolMemberType, PoolId, HostName, ElectionPriority, Priority, PreferredStatus, PreferredStatusTimestamp, PreferredStatusRevision, Status, StatusMessage, ReasonOfFail, ReasonOfFailRevision, HeartBeat, LastHeartBeatTimestamp, PoolIdRevision FROM dbo.HA_PoolMembersView WHERE PoolId<>0 AND (PoolMemberType='MainPoller' OR PoolMemberType='MainPollerStandby') ORDER BY HostName END 2021-05-28 09:02:20,770 [11] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT TOP 1 ServerName FROM dbo.Engines WITH (NOLOCK) WHERE ServerType = 'Primary' ORDER BY KeepAlive DESC 2021-05-28 09:02:20,770 [11] DEBUG SolarWinds.Orion.Swis.PubSub.MessageBus.MessageBusTopologyProvider - No message bus host change detected. 2021-05-28 09:04:20,786 [10] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: IF EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'[dbo].[HA_PoolMembersView]') AND type in (N'V')) AND EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE id = OBJECT_ID(N'dbo.HA_PoolMembers') AND type in (N'U')) BEGIN SELECT PoolMemberId, PoolMemberType, PoolId, HostName, ElectionPriority, Priority, PreferredStatus, PreferredStatusTimestamp, PreferredStatusRevision, Status, StatusMessage, ReasonOfFail, ReasonOfFailRevision, HeartBeat, LastHeartBeatTimestamp, PoolIdRevision FROM dbo.HA_PoolMembersView WHERE PoolId<>0 AND (PoolMemberType='MainPoller' OR PoolMemberType='MainPollerStandby') ORDER BY HostName END 2021-05-28 09:04:20,786 [10] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT TOP 1 ServerName FROM dbo.Engines WITH (NOLOCK) WHERE ServerType = 'Primary' ORDER BY KeepAlive DESC 2021-05-28 09:04:20,786 [10] DEBUG SolarWinds.Orion.Swis.PubSub.MessageBus.MessageBusTopologyProvider - No message bus host change detected.