SAP Knowledge Base Article - Preview

3040364 - Load data failing and crashing the IQ server - SAP IQ

Symptom

When trying to load data from a source file it fails and crashes the server with the following information:

Rbck
s_bufpool::Release(this=0x7f66b4005508,Slot=0x7f61b2da41b0,isInHashTable=1,isForShutdown=0): main Bufman
| 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 |
| t t D s y s c c h c f r r l e f i f A |
| i y e i y k S A i e L a e l i n T l |
| a a o W M u r a t o n i l n x i |
| b l n a a m e l c c t s i t n o |
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 |
+----------------+-----------------------------------------+------------+------------+------------+------------+------------+------------+--------------+----------------+----------------+
0x7f61b2da41b0 | a d N V y w B c i s P U m q x f z r h L | 1 | 0 | 13401 | 16263 | 0x7f53ec481000 | 0x7ef697387e08 | 5974..5974 | 0 | 0
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
&s_dskbkhdr | Block Type | Transaction ID | SavePoint | Ver | Physical Block | Data |NumPBlk|NumLBlk| Req/Actual Comp Types
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
0x7f53ec481000 | bt(f) | 541277291 | 155 | 1 | 603776498 | 0x7f53ec481020 | 3 | 16 | ANY/LZRW1
Blockmap Member Variables for 0x7ef697387e08
From slib/s_ohcidx.cxx:7449
_nextPartitionForHelperFlush = 7
IsEBufNoWait = 0
IsProxyFreelist = 0
_OrigRootBlock = 261258538
_Bio = 0x7f63557cf978
_tempSpace = 0
_Bufman = 0x7f63546ccb48 main Bufman
_allocFromLastLink = 0
_isMeta = 0
_m_dbspaceID = 16387
_dbspaceID = 16387
_rangePIDmap = 0
_useGlobalLBNs = 0
_isDistributedOwner = 0
_LBNOffset = 1
_LBNBase = 1
_nextGlobalLBN = 1
_RWAccess = 1
_gotIdentity = 1
_gotIdentityWithNoEntries = 0
_allocationPrivilege = 0
_pageInfo = 0
_perConnStats = 0
_tmp_rangePIDmap = 0
_nPhysicalWrites = 28778
_nPhysicalReads = 39388
_LockRefCount = 0
_PrefetchRefCount = 0
_ScanModeRefCount = 0
_DirtyList = 0
_ownerObjectName = USER.table.unique_HG
**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:2450
*** PID: 49107
*** Message: caught signal 11, program abort
*** Thread: 140059922478848 (TID: 5)
**************************************************

140059922478848 Stacktrace requested from stcxtlib/st_server.cxx:2450 on thread 140059922478848 (TID 5) start stacktrace
** Error from IQ connection: SA connHandle: 167 SA connID: 3 IQ connID: 0000000522 User: USER
** Time of error: 2021-03-20 18:27:03
** IQ Version: SAP IQ/16.1.040/13442/P/SP04.03
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/db61w112m3.etrade.com/3.10.0-862.11.6.el7.x86_64/#1 SMP Fri Aug 10 16:55:11 UTC 2018/x86_64
** Command status when error occured: COMMAND ACTIVE
** Command text:

Dump all thread stacks at stcxtlib/st_server.cxx:2450 for PID: 49107
***************** This is the STACKTRACE ***************

===== Thread Number 140059922478848 (IQ connID: 0000000522) =====


hos_ABORT(char const*, unsigned int, char const*, char*, char*, sigcontext*)
__do_global_dtors_aux_fini_array_entry
s_blockmap::DumpMemberVariables_unsafe
s_bufpool::Release(s_buf*, int, int, int)
s_bufpool::Rollback(unsigned long long, unsigned int, s_bufpool_ReleaseType, int)
s_bufman::Rollback(unsigned long long, s_blockmaps_hashtb::txnIdType, unsigned int, int)
st_txncb::Rollback()
st_txnMgr::Rollback()
db_Rollback::Execute()
st_command::DoCmdThroughResourceGate()
st_iqtxn::RollbackTxn(UIConnection*)
UIQTxn_RollbackTxn
st_SAIQInterfaceInfo::callFunction()
st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)
st_SAIQInterface::Execute(int, void*, unsigned int (*)
saint_iqthresholdtxn::RollbackTxn(IConnection*)
DB_Rollback_Chgs(Connection*)
Connection::rollback_work_internal(unsigned int)
Connection::rollback_work(unsigned int)
Connection::common_cleanup(unsigned int, a_disconnect_reason, unsigned int)
Connection::close(unsigned int, a_disconnect_reason)
db__disconnect(an_sqlpres_receive*)
RequestProcedure::call()
Worker::spawn(Procedure*)
EngStream::handle_ind(unsigned char, unsigned int)
EngStream::execute()
RQConnItem::do_request()
RQBaseItem::do_work(Worker*)
RequestQueue::worker_body()DoCmdThroughResourceGate
request_task(void*)
run_task_body
UnixTask::pre_body(void*)



Read more...

Environment

IQ 16.1 SP04

Product

SAP IQ 16.1

Keywords

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.