SAP Knowledge Base Article - Preview

2950039 - IQ Coor node crash at s_blockmap_RelocateData_Work when running ALTER TABLE MOVE

Symptom

IQ coordinator crashed down when running alter table to move data. The other MPX nodes works fine at that time.
The following stack trace raises:

pc: 0x900000003431968 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)
pc: 0x9000000034312b8 .ucstkgentrace(int,int)
pc: 0x90000000342f740 .DumpAllThreads(const char*,unsigned int,int)
pc: 0x90000000342ccb8 .hos_ABORT(const char*,unsigned int,const char*,char*,char*,__sigcontext*)
pc: 0x90000000489ac6c .SigHndlr
pc: 0x90000000366bd60 .s_blockmap_RelocateData_WorkIter::ExecWork
pc: 0x900000003e48484 .workAllocator::DoWork
pc: 0x900000003e4c0b0 .workAllocator::sDoWork
pc: 0x90000000393c0ac .hos_thread::Main()
pc: 0x900000003437404 .hos_lwtask::Start
pc: 0x900000001918fcc .IQWorkerStarter(void*)
pc: 0x900000001700e88 .run_task_body
pc: 0x9000000016fb354 .UnixTask::pre_body(void*)


Read more...

Environment

SAP IQ/16.x

Keywords

Alter table, move data, s_blockmap_RelocateData_WorkIter, workAllocator, hos_mutex_lock , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.