Hi
I'm checking some HANA logs and in indexserver_alert.trc I found some error regarding to division by zero:
[9031]{331428}[234/254365734] 2023-09-05 15:35:43.998815 e parallel BwPopHavingParallel.cpp(00110) : exception 1: no.70006859 (OlapEngine/Parallel/BwPopHavingParallel.cpp:110) TID: 9031
AttributeEngine: divide by zero; $message$=AttributeEngine: divide by zero;sqlsub(fixed("MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$7$", 23, 6), fixed("MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$8$", 23, 6)) -> "__common4"[fixed23.6], fixed(jf(isnull("__common4"), fixed(0, 23, 6), "__common4"), 15, 6) -> "__common2"[fixed15.6], jf(isnull("MY_DATABASE.#_SYS_QO_COL_L:884_7f73f2d26560:4018000000ab1197.COL$3$$aggr$$sum$"), fixed(0, 22, 6), "MY_DATABASE.#_SYS_QO_COL_L:884_7f73f2d26560:4018000000ab1197.COL$3$$aggr$$sum$") -> "__common3"[fixed15.6], box("__common2", fixed(0, 15, 6), decfloat(0), decfloat("__common3") / decfloat("__common2")) -> "__common1"[decfloat], round(sqlsub(decfloat("MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$3$"), "__common1") [here]/ "__common1", 4) > 0.1 and "__common3" > fixed(0, 15, 6), (MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$3$ = 0.000000[fixed12_15.6], MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$7$ = 37.000000[fixed12_15.6], MY_DATABASE.#_SYS_QO_COL_L:1030_7f73f2d5dc70:4018000000ab11a2.COL$8$ = 0.000000[fixed12_15.6], MY_DATABASE.#_SYS_QO_COL_L:884_7f73f2d26560:4018000000ab1197.COL$3$$aggr$$sum$ = 0.000000[fixed12_15.6])(6859)
exception throw location:
1: 0x00007f870e9ab312 in TRexUtils::Parallel::JobBase::run(Execution::Context&, Execution::JobObject&)+0x40 at ParallelDispatcher.cpp:225 (libhdbbasement.so)
2: 0x00007f8709724c96 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x2372 at JobExecutorImpl.cpp:1200 (libhdbbasis.so)
3: 0x00007f870970db7a in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x336 at JobExecutorThreads.cpp:384 (libhdbbasis.so)
4: 0x00007f8709702da8 in Execution::JobWorker::run(void*&)+0x764 at JobExecutorThreads.cpp:1284 (libhdbbasis.so)
5: 0x00007f87096c5cf5 in Execution::Thread::staticMainImp(Execution::Thread*)+0x531 at Thread.cpp:522 (libhdbbasis.so)
6: 0x00007f87096b5978 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1e4 at ThreadInterposition.cpp:639 (libhdbbasis.so)
7: 0x00007f8708d0e6ea in start_thread+0xd8 (libpthread.so.0)
8: 0x00007f870735ea6f in __GI___clone+0x3b (libc.so.6)
exception type information:
- 0: public TREX_ERROR::TRexErrorException@0x7f862dd8c690 SI
- 0: public ltt::exception@0x7f8708c70c40
How can I find the query with the issue or problem?
I know that there is some other logs (ex: indexserver.30003.executed_statements.067.trc) but lines there doesn't have time stamps, I don't know how to make the relation indexserver_alert.trc <---> executed_statements trace
Some help here please?
Thanks.
PS: Sorry for my english, it's not my primary language.