2988752 - Migration of a IQ 15.4 DB with IQ_SHARED_TEMP to IQ 16.1 cause crash - SAP IQ

• Simplex system
• IQ 15.4 DB has the dbspace IQ_SHARED_TEMP
• Start IQ 15.4 DB with IQ 16.1 binaries crash with stack trace in s_dbmvbio::DeAllocateSpecial
• Thus, cannot run "alter database upgrade"

Exceprt of IQMSG:

IQ OpenDatabase, checkpointblock: 512050, recover: 1
[DIO] hos_svbio::OpenFile() on /dir/MyDB.main_1 succeeded with DIRECT IO.
[DIO] hos_svbio::OpenFile() on /dir/MyDB.main_2 succeeded with DIRECT IO.
[DIO] hos_svbio::OpenFile() on /dir/MyDB.tempdb_1 succeeded with DIRECT IO.
[DIO] hos_svbio::OpenFile() on /dir/MyDB.tempdb_2 succeeded with DIRECT IO.
[DIO] hos_svbio::OpenFile() on /dir/MyDB.sharedtmpdb_1 succeeded with DIRECT IO.
set PITRlog threshold space to 0M
Initialized beginLogTime in backupID
set PITRlog threshold space to default: 3889Mfor main IQ Store size: 38890M
| 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 Q S F s A a P |
| i i d e u B l h a p r s a u t r A f d r |
| r r s r s u o e s e e e p a a e f f O e |
s_buf(s) | l l e i p V a F h k i t t y L c |
follow... | e o d t p a L e e n P y A i a |
| c e e l B d d e a r s t |
| r d i u d 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 Q X F Z R H L | LockRefCnt | DBSpaceID | BlkMapUID | Blk Num | _dskBlk | BlockMap | VersionRange | prev | next |
+----------------+-----------------------------------------+------------+------------+------------+------------+------------+------------+--------------+----------------+----------------+
0x7fbd53e7a5f0 | a D n v y w b c I s P u m q x F z r h L | 0 | 0 | 2 | 82 | 0x7fbd4fb45000 | 0x7fbe18506c88 | 1..1 | 0x7fbd53e7af50 | 0x7fbd53e7b270
[5] Lock{?:0} UnLock{?:0}
[4] Lock{?:0} UnLock{?:0}
[3] Lock{?:0} UnLock{?:0}
[2] Lock{?:0} UnLock{?:0}
[1] Lock{slib/s_bufman.cxx:3946} UnLock{/home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64_debug/gitsrc/cm/iqa/include/s_buf.h:1309}
[0] Lock{slib/s_bufman.cxx:3946} UnLock{/home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64_debug/gitsrc/cm/iqa/include/s_pageList.h:510}
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
&s_dskbkhdr | Block Type | Transaction ID | SavePoint | Ver | Physical Block | Data |NumPBlk|NumLBlk| Req/Actual Comp Types
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
0x7fbd4fb45000 | bm | 0 | 0 | 1 | 82 | 0x7fbd4fb45020 | 16 | 16 | NONE/NONE
s_bufhash TEMP @0x7fbe182176c8
17/32768 Buckets used:
-----------+------------+------------------+----------------------+-----------------+--------------
Bucket # | Pool Index | 1st Key | 2nd Key | s_buf* | ModNumRange
-----------+------------+------------------+----------------------+-----------------+--------------
20635 | 12 | 4000000000000002 | 82 | 0x7fbd53e7a5f0 | 1..1 | 82 | 0 | 2 | 0x7fbe18506c88 | 2 | 1:1 | 0 |

********************************************************
**
** Informational stack trace from Duplicate buffer insertion detected, exiting buf: 0x7fbd53e7a5f0
** at slib/s_bufhash.cxx:381 on thread 140453563930368 (TID 33)

s_bufhash::RemoveEntryInsertHelper
s_bufhash::Insert
s_bufpartition::InsertInHT
s_bufpartition::GetCleanPage
s_bufpartition::Create(
s_blockmap::CreateDontZero
s_scratchPage::CreateBuf
v2s_bmcontext::bmlev1sgblkalloc
v2s_bmcontext::bmsgblkfl_add_lev1
v2s_bmcontext::bmsgblkflinit
s_bmfreelist::AddBlocksToFreeList
s_dbmvbio::FreeListPreAllocate
s_dbmvbio::RebuildFL
s_iqstore::InitializeEmptyFL
st_database::OpenDatabase
...

**************************************************
*** SAP IQ Abort:
*** From: slib/s_db.cxx:1661
*** PID: 3902
*** Message: s_dbmvbio::DeAllocateSpecial Error
*** Thread: 140453563930368 (TID: 33)
**************************************************

s_dbmvbio::DeAllocateSpecial
s_blockmap::CreateDontZero
s_scratchPage::CreateBuf
v2s_bmcontext::bmlev1sgblkalloc
v2s_bmcontext::bmsgblkfl_add_lev1
v2s_bmcontext::bmsgblkflinit
s_bmfreelist::AddBlocksToFreeList
s_dbmvbio::FreeListPreAllocate
s_dbmvbio::RebuildFL
s_iqstore::InitializeEmptyFL
st_database::OpenDatabase
db_opendb::Execute
st_command::DoCmdThroughResourceGate
st_iqctl::OpenDB
.....

• SAP IQ 15.4
• SAP IQ 16.1 

s_dbmvbio::DeAllocateSpecial ; s_blockmap::CreateDontZero ; s_bmfreelist::AddBlocksToFreeList ; s_dbmvbio::FreeListPreAllocate ; s_dbmvbio::RebuildFL ; s_iqstore::InitializeEmptyFL ; st_database::OpenDatabase , KBA , BC-SYB-IQ , Sybase IQ , How To