Transaction log for Spotlight Playback Database is growing too fast (4270552)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Transaction log for Spotlight Playback Database is growing too fast
Description

Spotlight Playback transaction log in version 11.1.1.7759 keeps getting full throwing this alarm...
"The log in database SpotlightPlaybackDatabase has 0 growths remaining"
... and promoting a restore of the playback constantly. Hence playback data cannot be accessed.
Cause

From the SQL Server Error Logs, this message is recorded:
"The transaction log of database 'SpotlightPlaybackDatabase' is full due to 'ACTIVE_TRANSACTIONS.'

SQL Activity will show that the query in quesiton is playbackhistory.delete_data_sql.
It seems that deleting 25000 rows at a time is causing the playback database transaction log to get full fast.
Resolution

WORKAROUND:
1. If not already, upgrade to v11.2 because the query for deleting playback data is accessible
2. Once upgraded, change the number of row to delete from 25,000 to 10,000 in this file {DS dir}\Agent\conf\sql\Playback-DeleteData.sql
delete top (25000) pd...
delete top (25000) ps...
STATUS: Waiting for fix in a future release of Spotlight on SQL Server Enterprise.
Defect ID

SOSSE-4237

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title