Avamar：SQL 备份失败，并显示错误：“发现日志间隙，或未找到完整备份”

Summary: Avamar：SQL 备份失败，并显示错误：“已识别日志间隙，或者未找到完整备份。”

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

SQL 备份随机失败，并显示日志间隙错误：“已识别日志间隙，或者未找到完整备份。”

备份日志中的相应部分（带调试）： 
2022/05/04-23:00:22.09299 [avsql_assist] called avspawnpipe::~avspawnpipe
2022/05/04-23:00:22.09299 [avsql_assist] avspawnpipe::~avspawnpipe done with avspawnpipe::wait stdout
2022/05/04-23:00:22.09299 [avsql_assist] called avspawnpipe::~avspawnpipe
2022/05/04-23:00:22.09299 [avsql_assist] avspawnpipe::~avspawnpipe done with avspawnpipe::wait stderr
2022/05/04-23:00:22.16199 [avsql_assist] xml_message::parse parse error: expected = at 000000001C8D3041 in input
2022/05/04-23:00:22.17100 [avsql_assist] ERROR:  xml_message::validname('') invalid xml name
2022/05/04-23:00:22.17100 [avsql_assist] avsql_metadata::avsql_metadata sqlmetadata = '< />
'..
.
.
.
2022/05/04-23:00:22.18400 [avsql_assist] ===> avsql_assist::evaluate_backup_lsn
2022-05-04 19:00:22 avsql Warning : Evaluate backup LSN numbers is not supported in this version of metadata file (v0.000000).
2022/05/04-23:00:22.18499 [avsql_assist]  sqlconnectimpl_smo::get_last_backup_lsn
2022/05/04-23:00:22.18499 [avsql_assist] retrieving last backup lsn for '' db from sys.database_recovery_status
2022/05/04-23:00:22.18499 [avsql_assist] ===> sqlconnectimpl_smo::InitDll
2022/05/04-23:00:22.18499 [avsql_assist] SMO dll already loaded.
2022/05/04-23:00:22.18600 [avsql_assist]  SMOWrap::SMO_GetLastBackupLSN
2022/05/04-23:00:22.19000 [avsql_assist] database '', last backup lsn = '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist]  avsql_metadata::get
2022/05/04-23:00:22.19099 [avsql_assist] ===> avsql_metadata::get
2022/05/04-23:00:22.19099 [avsql_assist]  avsql_assist::align_numeric_ustrings
2022/05/04-23:00:22.19099 [avsql_assist] Before alignment - Str1: '', Str2: '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist] After alignment - Str1: '000000000000000000', Str2: '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist] : A log gap was identified or a full backup was not found.

Cause

问题是从以前的增量备份解析 sqlmeta 文件。

sqlmeta 文件的底部部分（存在于system_info区域文件中 — 请参阅 KB 000102778 Avamar — 如何从 Avamar 备份检索system_info区域文件 

          
          
          
         

文件从17411017截断到16777216 BYTES **}

由于 avtar 大小限制 16 MB， sqlmeta 文件被截断。
有问题的 SQL Server 有多个数据库。每个数据库都有多个文件组，这导致文件 （sqlmeta） 具有超过 90，000 行（16 MB 以上大小）。 

Resolution

要解决 Avamar 问题，请执行以下操作：SQL 备份失败，并显示错误：“已识别日志间隙，或者未找到完整备份。”

Affected Products

Avamar
Article Properties
Article Number: 000201975
Article Type: Solution
Last Modified: 15 Feb 2024
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.