SAP Knowledge Base Article - Preview

2512495 - Task poll query happens very frequently

Symptom

Task polling query happens every 20 ~30millis and the result is too many tasks.

68|master|170720-13:58:00:282|4 ms|statement|SELECT item_t0.PK , hjmpTS FROM tasks item_t0 WHERE ( item_t0.p_failed = ? AND (( item_t0.p_expirationtimemillis < ? ) OR ( item_t0.p_executiontimemillis <= ? AND ( item_t0.p_nodeid = ? OR item_t0.p_nodeid IS NULL ) AND item_t0.p_nodegroup IS NULL AND item_t0.p_runningonclusternode = ? AND NOT EXISTS(SELECT item_t1.PK FROM taskconditions item_t1 WHERE ( item_t1.p_task = item_t0.PK AND ( item_t1.p_fulfilled = ? OR item_t1.p_fulfilled IS NULL )) AND (item_t1.TypePkString=? )) ) )) AND (item_t0.TypePkString IN (?,?,?,?,?,?) ) LIMIT 2000 OFFSET 0

68|master|170720-13:58:00:306|3 ms|statement|SELECT item_t0.PK , hjmpTS FROM tasks item_t0 WHERE ( item_t0.p_failed = ? AND (( item_t0.p_expirationtimemillis < ? ) OR ( item_t0.p_executiontimemillis <= ? AND ( item_t0.p_nodeid = ? OR item_t0.p_nodeid IS NULL ) AND item_t0.p_nodegroup IS NULL AND item_t0.p_runningonclusternode = ? AND NOT EXISTS(SELECT item_t1.PK FROM taskconditions item_t1 WHERE ( item_t1.p_task = item_t0.PK AND ( item_t1.p_fulfilled = ? OR item_t1.p_fulfilled IS NULL )) AND (item_t1.TypePkString=? )) ) )) AND (item_t0.TypePkString IN (?,?,?,?,?,?) ) LIMIT 2000 OFFSET 0

and a lot of "update task" statement happens.

If the database is HANA, the log backup every 8mins is 1 GB!


Read more...

Environment

SAP Hybris Commerce 6.3

Product

SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3

Keywords

database performance task engine kill database , KBA , CEC-COM-CPS-COR , SAP Commerce Core , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.