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 |
