NetWorker:通知数据库和逻辑日志备份/恢复中止

Summary: 对于某些数据库空间,Informix 数据库和逻辑日志备份会频繁中止。“发生系统错误。”“中止 XBSA 会话。”“Aborted by client.”(客户端中止)。在数据库恢复过程中也发生相同的错误。

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.

Symptoms

在守护程序日志中,我们不会看到任何特定错误。

 

libnssinmx-xxxxx.log 中的错误消息:

XBSA-1.0.1 #.#.#.#.Build.### 16384588 DAY MONTH ## HH:mm:SS YYYY   _nwbsa_is_retryable_error: received a retryable network error (Severity 0 Number -13): busy

 

在按栏 (bar_act.log) 日志中备份期间出现错误消息:

YYYY-MM-DD HH:mm:SS 20120112  7930210 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
YYYY-MM-DD HH:mm:SS 10814124  7930210 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
YYYY-MM-DD HH:mm:SS 16843426  7930210 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
YYYY-MM-DD HH:mm:SS 28508590  7930210 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.

 

还原过程中的错误消息。

YYYY-MM-DD HH:mm:SS 11207038  18088436 XBSA Error: (BSAGetData) A system error occurred. Aborting XBSA session.
YYYY-MM-DD HH:mm:SS 11207038  18088436 (-43391) Skipped backup/restore of space '<dbspace-name>'.
YYYY-MM-DD HH:mm:SS 18088436  28442904 (-43246) The ON-Bar process 11207038 exited with a problem (exit code 3 (0x3),signal 0).
YYYY-MM-DD HH:mm:SS 23396846  18088436 XBSA Error: (BSAGetData) A system error occurred. Aborting XBSA session.
YYYY-MM-DD HH:mm:SS 23396846  18088436 (-43391) Skipped backup/restore of space '<dbspace-name>'.

 

Informix online.log 中的错误消息:

MM/DD/YY HH:mm:SS  Archive on <dbspace-name> Completed.
MM/DD/YY HH:mm:SS  Level 0 Archive started on <dbspace-name> 
MM/DD/YY HH:mm:SS  Archive on <dbspace-name> ABORTED.
MM/DD/YY HH:mm:SS  Aborted by client.
MM/DD/YY HH:mm:SS  Archive on <dbspace-name> ABORTED.
MM/DD/YY HH:mm:SS  Aborted by client.

 

Cause

客户已在 onconfig 文件中将 BAR_MAX_BACKUP 值设置为 0 ,这意味着无限制的备份流。特定的 Informix 数据库有 47 个数据库空间,因此在备份(数据库或逻辑日志备份)或恢复启动时,数据库服务器会创建许多条形进程。恢复期间也会发生同样的情况。这会导致停滞的情况,并且根据为BAR_RETRY设置的重试值重试后,某些线程会失败。

 

Resolution

在 onconfig 文件中 将BAR_MAX_BACKUP 值设置为 10 (位置:/infx/inst/<DB-Name>/informixdir/etc/onconfig.xxx) 解决了此问题。我们可以使用较低的值,例如 4 或 6,具体取决于情况。

 

Affected Products

NetWorker Module for Databases and Applications
Article Properties
Article Number: 000218332
Article Type: Solution
Last Modified: 18 Jan 2024
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.