SAP Knowledge Base Article - Preview

2824518 - Getting error "FP Check encountered leaked blocks. Should be reclaimed at the end of current operation" -- SAP IQ

Symptom

Even though sp_iqcheckdb indicates no problem with target table or column, update on target table may log error messages like these in iqmsg
--------
FP Check encountered leaked blocks. Should be reclaimed at the end of current operation. You may run sp_iqcheckdb on the index in question to verify.
t140695963866880 *** a2p_archive.messages_fr1.ASIQ_IDX_T3912_C39_FP dtwouttime (datetime): blockmap page allocation mismatch(3): 822233966 1814,171,1641,1
{2421} mismatch - allocated but not used: (this = 0x7ff654f24400, temp Bufman uid=3662468548, Count = 1)
{2421} 218,
{2421} mismatch - allocated but not used: (this = 0x7ff654f24400) reached EOD.
Blockmap Member Variables for 0x7ffc989cb078
From slib/s_dpidx.cxx:640
--------

Each error message is followed by a diagnostic dump. Short version of such diagnostic dump looks like this.
--------
_nextPartitionForHelperFlush = 0
IsEBufNoWait = 0
IsProxyFreelist = 0
_OrigRootBlock = 2763222660
_Bio = 0x7ffc702b23a8
_tempSpace = 0
_Bufman = 0x7ffc702b7a58 main Bufman
_allocFromLastLink = 1
_isMeta = 0
_m_dbspaceID = 16388
_dbspaceID = 16388
_rangePIDmap = 0x7ffc740201d8
_useGlobalLBNs = 0
_isDistributedOwner = 0
_LBNOffset = 1
_LBNBase = 1
_nextGlobalLBN = 1
_RWAccess = 1
_gotIdentity = 1
_gotIdentityWithNoEntries = 0
_allocationPrivilege = 0
_pageInfo = 0x7ffc98649518
_perConnStats = 0x7ffc98649598
_tmp_rangePIDmap = 0
_nPhysicalWrites = 1
_nPhysicalReads = 44
_LockRefCount = 2
_PrefetchRefCount = 0
_ScanModeRefCount = 0
_DirtyList = 0x7ffc98649e48
_ownerObjectName = a2p_archive.messages_fr1.ASIQ_IDX_T3912_C39_FP
#DirtyReferences = 56
#DirtyLinks = 1
_pnext = 0x7ffc9840f1d8
_pprev = 0x7ffc989ea4c8
_cacheSize = 0
_cache = 0
_nBlks = 0
_leaderCxtCursor = 0
_allowToFree = 0
_psuAll = 0

[s_blockmap_identity]
_UniqueId: 822233966
_RootBlockId: 3171286876
_NEntries: 1813
_LastWriterTxnId: 275433590
_LastWriterSavePoint: 17672
_FanOutAndFlags2: 0x8
_Flags: 0xd
_Version: 1
_NLinks: 1
_EntriesPerLink: 19959
_FirstAvailLink: 0
_MaxLink: 1
_ModNum: 11648
_RootModNum: 11648
[end s_blockmap_identity]

Blockmap On Disk (blondi)
Block Number: 3171286876
HasModNum: 8
Mod Number: 11648
OrigMod Number: 11648
Link Number: 0
Flags: 12
Bitvec Words: 312
HasNextLogical: 0
Entries/Capacity: 1813/19959
-------+-----------------+---------------------------------+---+-----+---+----------+-------
Index# | Logical Block# | Physical Block# |EBM| Size|Cmp|nxtLogical|modNum|
-------+-----------------+---------------------------------+---+-----+---+----------+-------
0 | 1 | 65535 | 0 | 2740992380 | 1 | 3 | 1 | 0 | 11604
........
1812 | 1813 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 11648
Dirty s_buf(s):
| I I N I I H I I I I I I I I I I H I H I |
Flags: | s s e s s a s s n s s s s s s s a n e s |
| D D e V B s B C W S P U M O S F s A a P |
| i i d e u B l h a p r s a w t r A f d r |
| r r s r s u o e s e e e p n a e f f O e |
| t t D s y s c c h c f r e l e f i f A |
| i y e i y k S A i e L r e l i n T l |
| a a o W M u r a t o i l n x i |
| b l n a a m e l c c s i t n o |
s_buf(s) | l l e i p V a F h k t t y L c |
follow... | e o d t p a L e e P y A i a |
| c e e l B d d a r s t |
| r d i u g e t e |
| s d f e a d |
+----------+-----------------------------------------+------------+------------+------------+------------+------------+------------+-------------
| &s_buf | A D N V Y W B C I S P U M O X F Z R H L | LockRefCnt | DBSpaceID | BlkMapUID | Blk Num | _dskBlk | BlockMap | VersionRange
+----------+-----------------------------------------+------------+------------+------------+------------+------------+------------+-------------
0x7ff5e7102aa8 | a D n V y w B c i s P u m x f z r h L | 0 | 16388 | 822233966 | 1794 | 0x7fede1cd6000 | 0x7ffc98646c28 | 11648..11648
...
0x7ff5e58d8040 | a D n V y w B c i s P u m x f z r h L | 0 | 0 | 822233966 | 1681 | 0x7fb35124e000 | 0x7ffc98646c28 | 11648..11648
{2445} bitmap pages: (this = 0x7ff65430f350, temp Bufman uid=3662466980, Count = 171)
{2445} 1, 10-14, 20-25, 52-59, 61, 74-75, 86,
{2445} 119, 172-195, 221, 325, 453-465, 468, 594,
{2445} 932-941, 943-945, 1014, 1136, 1391-1404, 1406-1410, 1469-1470,
{2445} 1484-1491, 1513-1535, 1552, 1573, 1632-1645, 1656, 1681,
{2445} 1691-1692, 1695, 1713-1715, 1721, 1751, 1753, 1793-1802,
{2445} 1811,
{2445} bitmap pages: (this = 0x7ff65430f350) reached EOD.
{2445} just ridmap (this = 0x7ff65430f6f0, temp Bufman uid=3662466980, Count = 1)
{2445} 65,
{2445} just ridmap (this = 0x7ff65430f6f0) reached EOD.
{2445} barray pages: (this = 0x7ff65430f8c0, temp Bufman uid=3662466980, Count = 1640)
{2445} 2-9, 15-19, 26-51, 60, 62-64, 66-73, 76-85,
{2445} 87-118, 120-171, 196-217, 219-220, 222-324, 326-452, 466-467,
{2445} 469-593, 595-931, 942, 946-1013, 1015-1135, 1137-1390, 1405,
{2445} 1411-1468, 1471-1483, 1492-1512, 1536-1551, 1553-1572, 1574-1631, 1646-1655,
{2445} 1657-1680, 1682-1690, 1693-1694, 1696-1712, 1716-1720, 1722-1750, 1752,
{2445} 1754-1792, 1803-1810, 1812-1813,
{2445} barray pages: (this = 0x7ff65430f8c0) reached EOD.
t140695951185664 *** a2p_archive.messages_fr1.ASIQ_IDX_T3912_C39_FP dtwouttime RidMap:
barray t140695951185664 C39: dtwouttime
barray t140695951185664 C39 BEGIN dump RidMap:
barray t140695951185664 C39 startRecid=16513 endRecid=278592 block=26 hasNBit=1
...
barray t140695951185664 C39 startRecid=67243144769 endRecid=67243175381 block=51 hasNBit=1
barray t140695951185664 C39 startRecid=67310192001 endRecid=67310233442 block=1750 hasNBit=1
barray t140695951185664 C39 END dump RidMap
---------


Read more...

Environment

  • IQ 16.1 SP02 PL15+
  • IQ 16.0 SP11

Product

SAP IQ 16.1

Keywords

ridmap , encountered leaked blocks , reclaimed at the end of current operation , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.