2512495 - Task poll query happens very frequently | SAP Knowledge Base Article

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 , CPS Core (SAP Hybris) , Problem

About this page

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

Search for additional results

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