Loading...
Loading...
SQL incremental backups were getting randomly promoted to full backups on a busy SQL server with a lot of transactions. The log gap detection mechanism within Avamar SQL Plugin was triggering incorrectly, even though the Log Sequence Number (LSN) continuity was not broken. Randomly Avamar SQL Incremental Backups would fail with: 2025-02-05 07:01:16 avsql Info <15765>: A log gap was identified or a full backup was not found. 2025/02/05-07:01:16.98499 [avsql_assist] ===> sqlconnect::~sqlconnect 2025/02/05-07:01:16.98499 [avsql_assist] <=== sqlconnect::~sqlconnect 2025/02/05-07:01:16.98499 [avsql_assist] <=== avsql_assist::snapup_check_timestamps 2025-02-05 07:01:16 avsql Warning <7420>: Forcing FULL backup for database 'sql1\GRS/GRSBLOBS' due to the following reason: A log gap was identified or a full backup was not found.
A fix was generated to address this issue. This issue shows when the Avamar SQL plug-in algorithm retrieving the last LSN from the SQL server and would no always get the most up-to-date LSN. This behavior caused unexpected promotions to full backups.
Fixes for this issue can be found on the Dell page Avamar Drivers and Download Avamar SQL plug-in version 19.10.100.166 Hotfix number 338887 Avamar SQL plug-in version 19.12.100.186 Hotfix number 338888 For Hotfixes Download instructions, see: Avamar: How to find and download a product hotfix, patch, install or upgrade package from the Dell Support website These hotfixes use a new SQL Plugin flag which must be added to the avsql.cmd file or in the Dataset. To use this new flag in Avamar, follow these steps: Locate the avsql.cmd file: This file is typically found in the Avamar client installation directory. Edit the avsql.cmd file: Open the file in a text editor with administrative privileges. Add the flag below: Save and close the file --latest-lsn-from-msdb=True When this flag is enabled (True), it ensures that the correct LSN number is retrieved from the SQL server for "log gap" validation. The above flag can also be added to the dataset. For UI see Avamar: How to supply specialized flags to Avamar backups For AUI Go to the AUI Locate Backup Policy. Select a policy Click Edit. Go to the Dataset page. In the Edit Dataset section, enable the toggle labeled "Turn on this toggle to edit dataset" In the Plugins section: Select a plug-in. Turn on the Show Free Form toggle. Add the required flag using key-value pairs. For example, to enable period lock, use: Key: [avtar]"Flag" Value: true Click Submit to save the dataset changes.
Click on a version to see all relevant bugs
Dell Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.