on 06-23-2016 10:03 AM
Hi,
My environment:
OS info: IQ built on: RS6000MP/AIX 6.1.0, Executed on: AIX/audwh02/1/6/000C327AD400
IQ Version: Sybase IQ/15.4.0/130221/P/ESD 3
Multiplex: one Coordinator and one Query Server
Query Server crashed with the following message:
I. 06/21 17:41:49. 0000957432 ** While handling one abort, caught signal 11, program abort on thread 11823 (TID 129)
I. 06/21 17:42:43. 0000957080
I. 06/21 17:42:43. 0000957080 ********************************************************
I. 06/21 17:42:43. 0000957080 **
I. 06/21 17:42:43. 0000957080 ** Non-Fatal IQ Internal Error Detected
I. 06/21 17:42:43. 0000957080 ** at s_csort.cxx:1806 on thread 294013 (TID 1142)
I. 06/21 17:42:43. 0000957080 ** While handling one abort, caught signal 4, program abort on thread 294013 (TID 1142)
New process id is 17367042
**************************************************
*** Sybase IQ Abort:
*** From: st_server.cxx:1432
*** PID: 17367042
*** Message: caught signal 11, program abort
*** Thread: 42920 (TID: 7)
**************************************************
** While handling one abort, caught signal 11, program abort on thread 45747 (TID 0)
** While handling one abort, caught signal 11, program abort on thread 11823 (TID 129)
** While handling one abort, caught signal 11, program abort on thread 16449 (TID 111)
** While handling one abort, caught signal 4, program abort on thread 294013 (TID 1142)
Using licenses from: /sybase/SYSAM-2_0/licenses/xxx.lic
Checked out license for 8 IQ_CORE (2015.06260/permanent/0A9D 71BC 4247 86C7).
Checked out support-graced license for 1 IQ_MPXNODE (2012.06260/permanent/0C0B 6378 21F2 2BCC).
inc_rpcCmdHandler::CallRemoteRPC:Connect() Failed
inc_rpcCmdHandler::CallRemoteRPC:Connect() Failed
**************************************************
*** Sybase IQ Abort:
*** From: st_server.cxx:1432
*** PID: 17367042
*** Message: caught signal 11, program abort
*** Thread: 42920 (TID: 7)
**************************************************
** While handling one abort, caught signal 11, program abort on thread 45747 (TID 0)
** While handling one abort, caught signal 11, program abort on thread 16449 (TID 111)
===== Thread Number 42920 =====
pc: 0x900000006e36be8 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8()
pc: 0x900000006e364d8 .ucstkgentrace(int,int)+0xb8()
pc: 0x900000006e34c64 .DumpAllThreads(const char*,unsigned int,int)+0x184()
pc: 0x9000000065da1f8 .hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x1d8()
pc: 0x900000006e3c5d4 .SigHndlr+0x54()
pc: 0x900000004dff914 .CSwap+0x14()
pc: 0x900000004e3caac .MainHeap::Free(void*)+0xec()
pc: 0x900000004e3ec00 .LargeAllocHeap::Free(void*)+0x40()
pc: 0x900000004e3d9b8 .LargeAllocHeap::Free(void*)+0x18()
pc: 0x9000000053cba84 .GetConnParms(Pres*,an_sqlpres_receive*,a_string_parms*)+0x184()
pc: 0x9000000053ca0ac .db__connect(an_sqlpres_receive*)+0x26c()
pc: 0x900000004eb9854 .RequestProcedure::call()+0xe94()
pc: 0x9000000050247b8 .Context::call(Procedure*,Context**)+0x78()
pc: 0x900000005026128 .Worker::call_on_stack(Procedure*)+0x48()
pc: 0x900000004ebae64 .TopProcedure::call()+0x44()
pc: 0x900000005025a38 .Worker::spawn(Procedure*)+0x98()
pc: 0x900000004ebb064 .EngStream::handle_ind(unsigned char,unsigned int)+0xc4()
pc: 0x900000004ebba34 .EngStream::execute()+0x4f4()
pc: 0x900000004ebd388 .RQBaseItem::do_work(Worker*)+0x48()
pc: 0x900000004e17524 .RequestQueue::worker_body()+0xc4()
pc: 0x900000004ebd25c .request_task(void*)+0x5c()
pc: 0x90000000501d508 .run_task_body+0x48()
pc: 0x900000005019eb4 .UnixTask::pre_body(void*)+0x134()
pc: 0x900000000b68d54 ()
===== Thread Number 294013 (IQ connID: 0000957080) =====
pc: 0x900000006e36be8 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8()
pc: 0x900000006e364d8 .ucstkgentrace(int,int)+0xb8()
pc: 0x900000006e3c548 .SigHndlrUSR1+0x28()
pc: 0x900000000b7af84 ()
pc: 0x900000000b7b89c ()
pc: 0x900000000b89668 ()
pc: 0x900000000b89c40 ()
pc: 0x900000000b8a8ac ()
pc: 0x900000006e5f650 .hos_condvar::Wait() const+0x50()
pc: 0x900000006d82c68 .s_buf::WaitForSignal_DontCareIfBusy()+0x148()
pc: 0x900000007cc37cc .s_bufhash::Find(unsigned int,unsigned long,unsigned long,unsigned long,unsigned int) const+0x12c()
pc: 0x900000006b3c4a8 .s_bufpartition::FindLogicalBuffer(s_bufman_errorInfo*,s_connectionCacheStats*,unsigned long,s_blockmap*,s_bufman::s_dirtyMode)+0x128()
pc: 0x90000000662c3b8 .s_blockmap::Find(unsigned long,short,int)+0xb8()
pc: 0x900000006efab3c .s_prefetch::Find(unsigned long,short,int)+0x1c()
pc: 0x900000006ee08a8 .s_pageListCursor::PositionPrefetchedPage(unsigned long)+0x248()
pc: 0x900000006eb7b8c .v2s_bmcontext::bmlfblkget(int)+0xcc()
pc: 0x900000006c43e50 .v2s_bmcontext::bmselfint(s_bm*,const s_bm&)+0x1890()
pc: 0x900000006c702c8 .s_bm::And(const s_bm&)+0x248()
pc: 0x900000006f60098 .s_index::EvaluateNulls(s_bm*,hos_boolop,const s_bm*,int) const+0x1d8()
pc: 0x9000000077f18fc .vpp_IsNull::ExecuteOpus()+0x2fc()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623dc0 .vpp_Boolean::ExecuteOpus()+0x240()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623e64 .vpp_Boolean::ExecuteOpus()+0x2e4()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623e64 .vpp_Boolean::ExecuteOpus()+0x2e4()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623e64 .vpp_Boolean::ExecuteOpus()+0x2e4()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623e64 .vpp_Boolean::ExecuteOpus()+0x2e4()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007623e64 .vpp_Boolean::ExecuteOpus()+0x2e4()
pc: 0x90000000762995c .vpp::Execute(s_bm**,const s_bm*,const s_bm*,hos_boolop)+0x19c()
pc: 0x900000007467030 .vp_Predicates::PreExecute()+0x130()
pc: 0x90000000745fb88 .vp_Cursor::PreExecute(unsigned int)+0x88()
pc: 0x9000000076fca70 .opt_QueryExpExecTopIter::ExecWork(int&,unsigned int)+0x70()
pc: 0x900000006fa4d04 .workAllocator::DoWork(unsigned int)+0xe4()
pc: 0x900000006fa8e50 .workAllocator::sDoWork(workAllocator*,unsigned int)+0x30()
pc: 0x900000006fb8a88 .hos_thread::Main()+0x248()
pc: 0x900000006603d84 .hos_lwtask::Start(hos_lwtask*)+0x64()
pc: 0x9000000051c076c .IQWorkerStarter(void*)+0x6c()
pc: 0x90000000501d508 .run_task_body+0x48()
pc: 0x900000005019eb4 .UnixTask::pre_body(void*)+0x134()
pc: 0x900000000b68d54 ()
Could anyone help me?
Thanks!
Hi Yuan,
Please see if there is another stacktrace prior to this.
By the way your current patch ESD3 (IQ/15.4.0/130221/P/ESD 3) is quite old. The latest one is ESD7.
Also, 15.4 will be end of maintenance in few months (November 30). So, you need schedue an upgrade to IQ 16:
SAP IQ 15 End of Maintenance Report - SAP IQ - SCN Wiki
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.