SAP Knowledge Base Article - Preview

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

Symptom

  • 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
.....


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.1 

Product

SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

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

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.