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

Search for additional results

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