cancel
Showing results for 
Search instead for 
Did you mean: 

Query Server crashed, caught signal 11, s_csort.cxx:1806

0 Kudos

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:

  • (db.iqmgs):

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)

  • (db.stderr):

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)

  • (stack trace):

===== 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!

Accepted Solutions (0)

Answers (1)

Answers (1)

tayeb_hadjou
Advisor
Advisor
0 Kudos

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.