IQ crash at dfo_HashSortMerge

[corona_yao]

At first, iq only crashes when some script was run, now IQ will crash just a few minutes after a restart.

I will attach the relevant log files and sysoptions output(please change txt to html for sysoptions).

Thanks if anyone could help me with some clue of this.

Is this a new bug?

stacktrace like below:

I. 04/27 17:55:39. 0000000324 **************************************************
I. 04/27 17:55:39. 0000000324 ***  SAP IQ Abort:
I. 04/27 17:55:39. 0000000324 ***      From:  stcxtlib/st_server.cxx:1703
I. 04/27 17:55:39. 0000000324 ***      PID: 8219
I. 04/27 17:55:39. 0000000324 ***      Message: caught signal 11, program abort
I. 04/27 17:55:39. 0000000324 ***      Thread: 140557252290304  (TID: 667)
I. 04/27 17:55:39. 0000000324 **************************************************
I. 04/27 17:55:39. 0000000324 
I. 04/27 17:55:39. 0000000324    **  Error from IQ connection: 
I. 04/27 17:55:39. 0000000324    **  Time of error:  2015-04-27 17:55:39
I. 04/27 17:55:39. 0000000324    **  IQ Version:  SAP IQ/16.0.0/140804/P/sp08.03
I. 04/27 17:55:39. 0000000324    **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/SAPIQ/3.0.76-0.11-default/#1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990)/x86_64
I. 04/27 17:55:39. 0000000324    **  Command status when error occured:  COMMAND ACTIVE
I. 04/27 17:55:39. 0000000324    **  Command text: 
Statement text unavailable

I. 04/27 17:55:39. 0000000324 Dump all thread stacks at stcxtlib/st_server.cxx:1703 for PID: 8219

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bea4672 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bea4ce1 ucstkgentrace(int, int)+0x121

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bea5f1e DumpAllThreads(char const*, unsigned int, int)+0x12e

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bc32e6e hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x19e

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61c97a12f SigHndlr+0x4f

I. 04/27 17:55:39. 0000000324 pc: 0x7fd6afe597c0 _fini+0x92067538

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bac5b6c dfo_HashSortMerge<df_QSortRow>::Merge(unsigned int, df_QuicksortAux<df_QSortRow>**, unsigned char*, unsigned long long*, unsigned int, unsigned int)+0xb6c

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bacecff dfo_HashSortMerge<df_QSortRow>::GetRowBufferAndWait(unsigned int, dfo_FileSource*)+0xef

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61bacf4ac dfo_HashSortMerge<df_QSortRow>::FetchOpus()+0x66c

I. 04/27 17:55:39. 0000000324 pc: 0x7fd61b9b87e0 dfo_Hash_RowID::FetchOpus()+0x80

sysoptions.txt.zip

iocdbiqmsg.txt.zip

zrlog.txt.zip

[Former Member]

Hi Corona Yao,

I currently have a simmilar problem with my SAP Sybase IQ 16 IQ Version:  SAP IQ/16.0.102.2/20080/P/sp10.06.

Its only crash when I run a bigger query, It doen't happend when I run the same query with little data.

I want to know if you have some idea about this case, 'cause I am looking for this simmilar case but I am not finding answers.

Please if you have some idea I will apreciate it.

-----

This is my error message:

    **  Error from IQ connection:  SA connHandle: 56  SA connID: 10  IQ connID: 0000000243 

  User: DBA   

  **  Time of error:  2016-03-23 16:12:41   

  **  IQ Version:  SAP IQ/16.0.102.2/20080/P/sp10.06   

  **  OS info:  IQ built on: RS6000MP/AIX 6.1.0,  Executed on: AIX/bgdcmigiq/1/7/00F79C114C00   

  **  Command status when error occured:  CURSOR ACTIVE   

  **  Command text: 

Greetings

Santiago