Informix - Problem description
Problem IT15878 | Status: Closed |
DROPPING AN SBSPACE WHILE LEVEL 0 BACKUP IS RUNNING FAILS BUT LEAVES SBSPACE WITH NO USER DATA SPACE REFERENCE IN SHARED MEMORY | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
If an onspaces -d is run on an sbspace while a L0 backup is running it returns the error: =>onspaces -d sbsp1 -y Cannot drop the Space. ISAM error: archive in progress It then leaves the sbspace in a state that will cause backup to fail with: 12:51:23 ARCHIVE ERROR: Failure in sbx_arc_uelists_bld: sberrno = 12143 sbsnum = 4 It also shows -1 for free and bpages in onstat -d: address chunk/dbs offset size free bpages flags pathname 4e476028 4 4 0 512000 -1 -1 POSB-- /data1/dkolbin/sbsp1 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users trying to drop an sbspace during an archive. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Bouncing the engine resolves the issue. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.06.2016 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |