Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
23.02.4, 23.10.0
-
None
-
2023-11
Description
PrimProc crashes when the following query is executed:
SELECT
|
DATE(rc_ts) PERIOD,
|
pvid,
|
moid
|
FROM
|
temp_cs.codesP149
|
JOIN isweb.rilevazione_custom_cs
|
ON rc_cd_id = cdid
|
AND rc_codice = codice
|
AND rc_pv_id = pvid
|
AND rc_prezzo > 0
|
WHERE JSON_VALUE(rc_obs, CONCAT('$.vaid')) IS NOT NULL
|
AND JSON_VALUE(rc_obs, CONCAT('$.mostro')) IS NULL
|
AND rc_ts >= '2023-11-07'
|
AND DATE(rc_ts) BETWEEN '2023-11-07' AND '2023-11-08'
|
GROUP BY PERIOD,pvid,moid
|
the stack trace:
Date/time: 2023-11-10 10:35:05
|
Signal: 11
|
|
|
/usr/bin/PrimProc(+0xb74b6)[0x55c9f1f344b6]
|
/lib64/libpthread.so.0(+0x12cf0)[0x7ff2933c5cf0]
|
/lib64/libexecplan.so(+0x136809)[0x7ff29431c809]
|
/usr/bin/PrimProc(+0x1b8cc2)[0x55c9f2035cc2]
|
/usr/bin/PrimProc(json_key_matches+0x15)[0x55c9f2036cf5]
|
/usr/bin/PrimProc(json_find_path+0x149)[0x55c9f2036e79]
|
/lib64/libfuncexp.so(_ZN7funcexp15JSONPathWrapper7extractERNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERN8rowgroup3RowERN5boost10shared_ptrIN8execplan9ParseTreeEEESG_+0x213)[0x7ff293f43a13]
|
/lib64/libfuncexp.so(_ZN7funcexp15Func_json_value9getStrValB5cxx11ERN8rowgroup3RowERSt6vectorIN5boost10shared_ptrIN8execplan9ParseTreeEEESaIS9_EERbRNS7_20CalpontSystemCatalog7ColTypeE+0x4d)[0x7ff293f43d0d]
|
/lib64/libexecplan.so(_ZN8execplan14FunctionColumn9getStrValB5cxx11ERN8rowgroup3RowERb+0x5b)[0x7ff2942e5c3b]
|
/lib64/libexecplan.so(_ZN8execplan17PredicateOperator10getBoolValERN8rowgroup3RowERbPNS_14ReturnedColumnES6_+0x6f3)[0x7ff2942f3c93]
|
/lib64/libfuncexp.so(_ZN7funcexp14FuncExpWrapper8evaluateEPN8rowgroup3RowE+0xa4)[0x7ff293ef7bd4]
|
/usr/bin/PrimProc(+0x5e213)[0x55c9f1edb213]
|
/usr/bin/PrimProc(+0x5f681)[0x55c9f1edc681]
|
/usr/bin/PrimProc(+0x72f90)[0x55c9f1eeff90]
|
/lib64/libthreadpool.so(_ZN10threadpool14FairThreadPool9threadFcnENS_18PriorityThreadPool8PriorityE+0x713)[0x7ff293166bd3]
|
/usr/bin/PrimProc(+0xb8f97)[0x55c9f1f35f97]
|
/lib64/libpthread.so.0(+0x81ca)[0x7ff2933bb1ca]
|
/lib64/libc.so.6(clone+0x43)[0x7ff291dcce73]
|
