Informix - Problem description
Problem IT15859 | Status: Closed |
LOG REPLAY ERROR ON SECONDARY WHEN ADDING A CHUNK TO AN SBSPACE WITH FULL METADATA | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The secondary of an HDR pair will Assert Fail with a log replay error when adding a chunk to an sbspace while metadata space is full: 12:01:14 Assert Failed: Logical log replay error. 12:01:14 IBM Informix Dynamic Server Version 12.10.FC4W1XAC 12:01:14 Who: Session(28, informix@server, 0, 0x44c32908) Thread(53, xchg_2.0, 44bfa268, 1) File: rsprecvr.c Line: 7585 12:01:14 Results: The secondary server cannot continue. 12:01:14 Action: Reestablish the secondary server. 12:01:14 stack trace for pid 10275 written to /usr/informix/tmp/af.41d1349 12:01:14 See Also: /usr/informix/tmp/af.41d1349 The secondary will also add the chunk while it fails on the primary. The error received on the primary is: Verifying physical disk space, please wait ... Cannot add sbspace chunk info, errno 12123 onstat -d output on Primary ------------------------------- =>onstat -d IBM Informix Dynamic Server Version 12.10.FC4W1XAC -- On-Line (Prim) -- Up 00:30:17 -- 165008 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 44b31028 1 0x60001 1 1 2048 N BA informix rootdbs 4d4a0dd0 2 0x68001 2 1 2048 N SBA informix sbspace 2 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 44b31258 1 1 0 250000 181806 PO-B-- /home/informix/chunks/rootchunk 463c1028 2 2 0 5000 20 4587 POSB-- /home/informix/chunks/sbsp1 Metadata 360 268 360 2 active, 32766 maximum onstat -d output on secondary ------------------------------ informix@server:/home/informix/chunks> onstat -d IBM Informix Dynamic Server Version 12.10.FC4W1XAC -- Read-Only (Sec) -- Up 00:29:22 -- 156816 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 44afd028 1 0x60801 1 1 2048 NL BA informix rootdbs 4d1dc610 2 0x68801 2 2 2048 NLSBA informix sbspace 2 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 44afd258 1 1 0 250000 181806 PI-B-- /home/informix/chunks/rootchunk 45c69028 2 2 0 5000 20 4587 PISB-- /home/informix/chunks/sbsp1 Metadata 360 268 360 4d1f9028 3 2 0 500000 -1 -1 PISB-- /home/informix/chunks/ch1 3 active, 32766 maximum This requires a restore of the secondary to resolve. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.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) |