Informix - Problem description
Problem IT42672 | Status: Closed |
REPLICATING SMARTBLOBS GREATER THAN 2GB ISSUE. | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When replicating smartblobs with a size greater than 2GB, you can see it going through ER queues but then it just ends up with a 0 byte in the sbspace. In the following oncheck output, there's a ~1.5 MB FILETOBLOB which shows correctly, the second one corresponds to a ~3.5 GB FILETOBLOB on the replicated server informix@farias-ThinkPad-P50:~/prods/12.10/FC14$ oncheck -cS sbspace1 Validating space 'sbspace1' ... sbspace Metadata Partition Partnum Used Free sbspace1:'informix'.TBLSpace 0xb00001 6 44 sbspace1:'informix'.sbspace_desc 0xb00002 2 2 sbspace1:'informix'.chunk_adjunc 0xb00003 2 2 sbspace1:'informix'.LO_ud_free 0xb00004 2 10865 sbspace1:'informix'.LO_hdr_partn 0xb00005 2 61361 Large Objects ID Ref Size Allocced Creat Last Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified ---- ---- ----- ---- ---------- -------- ----- ----- ------------------------ 11 11 1 1 1674465 833 1 N-N-H Wed Dec 7 14:33:47 2022 11 11 2 1 0 0 0 N-N-H Wed Dec 7 15:31:18 2022 informix@farias-ThinkPad-P50:~/prods/12.10/FC14$ oncheck -pe sbspace1 DBspace Usage Report: sbspace1 Owner: informix Created: 12/07/2022 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 11 /External/prods/12.10/FC14/storage/ol_informix1210_sbspace1_p_1 2 4194304 see below see below Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 sbspace1:'informix'.TBLSpace 3 50 SBLOBSpace LO [11,11,1] 53 833 SBLOBSpace FREE USER DATA (AREA 1) 886 1116286 SBLOBSpace RESERVED USER DATA (AREA 1) 1117172 838848 sbspace1:'informix'.sbspace_desc 1956020 4 sbspace1:'informix'.chunk_adjunc 1956024 4 sbspace1:'informix'.LO_ud_free 1956028 10867 sbspace1:'informix'.LO_hdr_partn 1966895 61363 SBLOBSpace FREE META DATA 2028258 210078 SBLOBSpace RESERVED USER DATA (AREA 2) 2238336 838848 SBLOBSpace FREE USER DATA (AREA 2) 3077184 1117120 Total Used: 73124 Total SBLOBSpace FREE META DATA: 210078 Total SBLOBSpace FREE USER DATA: 3911102 i While following shows on the source correctly: informix@affinity:~$ oncheck -cS sbspace1 Validating space 'sbspace1' ... sbspace Metadata Partition Partnum Used Free sbspace1:'informix'.TBLSpace 0xb00001 6 44 sbspace1:'informix'.sbspace_desc 0xb00002 2 2 sbspace1:'informix'.chunk_adjunc 0xb00003 2 2 sbspace1:'informix'.LO_ud_free 0xb00004 2 10865 sbspace1:'informix'.LO_hdr_partn 0xb00005 2 61361 Large Objects ID Ref Size Allocced Creat Last Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified ---- ---- ----- ---- ---------- -------- ----- ----- ------------------------ 11 11 1 1 1674465 829 1 N-N-H Wed Dec 7 14:33:45 2022 11 11 2 1 1674465 1907463 2 N-N-H Wed Dec 7 14:45:23 2022 informix@affinity:~$ oncheck -pe sbspace1 DBspace Usage Report: sbspace1 Owner: informix Created: 12/07/2022 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 11 /home/informix/prods/12.10/FC14/storage/ol_informix1210_sbspace1 _p_1 2 4194304 see below see below Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 sbspace1:'informix'.TBLSpace 3 50 SBLOBSpace LO [11,11,1] 53 829 SBLOBSpace LO [11,11,2] 882 790343 SBLOBSpace FREE USER DATA (AREA 1) 791225 325947 SBLOBSpace RESERVED USER DATA (AREA 1) 1117172 838848 sbspace1:'informix'.sbspace_desc 1956020 4 sbspace1:'informix'.chunk_adjunc 1956024 4 sbspace1:'informix'.LO_ud_free 1956028 10867 sbspace1:'informix'.LO_hdr_partn 1966895 61363 SBLOBSpace FREE META DATA 2028258 210078 SBLOBSpace RESERVED USER DATA (AREA 2) 2238336 838848 SBLOBSpace LO [11,11,2] 3077184 1117120 Total Used: 1980583 Total SBLOBSpace FREE META DATA: 210078 Total SBLOBSpace FREE USER DATA: 2003643 You can verify with onstat -g rqm recvq that it's being sent/received | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.FC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.FC10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.FC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.FC10. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.FC10. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.12.2022 23.02.2023 23.02.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |