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+

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 ONE Support launchpad (Login required).

Search for additional results

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