Informix - Problem description
Problem IT09256 | Status: Closed |
PARALLEL BACKUPS OF DBSPACES CAN FAIL WITH 143 (DEADLOCK) ERRORS | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Performing parallel backups with BAR_MAX_BACKUP > 1 can occasionally fail with 143 deadlock errors on sysutils:bar_instance. Sample BAR_ACT_LOG output: 2015-04-24 05:55:08 19297 14955 Process 19297 14955 successfully forked. 2015-04-24 05:55:09 19297 14955 Begin level 0 backup crsllog417. 2015-04-24 05:55:09 19297 14955 Successfully connected to Storage Manager. 2015-04-24 05:55:11 19297 14955 SQL -243 Could not position within a table (sysutils:informix.bar_instance). 2015-04-24 05:55:11 19297 14955 ISAM -143 ISAM error: deadlock detected 2015-04-24 05:55:11 19297 14955 SQL -243 Could not position within a table (sysutils:informix.bar_instance). 2015-04-24 05:55:11 19297 14955 ISAM -143 ISAM error: deadlock detected 2015-04-24 05:55:11 19297 14955 Process 19297 14955 completed. 2015-04-24 05:55:11 14955 14953 (-43246) The ON-Bar process 19297 exited with a problem (exit code 122 (0x7a),signal 0). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users running On-Bar backups with many dbspaces * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 11.70.xC9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.06.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |