SAP HANA System Issue after a few days of runtime

Hi Gurus,

We are facing an Issue on our HANA System. Mostly after a runtime of more ore less than three days we are unable to log on to the sap system via SAP GUI. we see the folowing ABAP dumps. more than 500 dumps per Day

Systemdumps on ABAP side, Connect to the instance mostly not possible

At the HANA logs I see these entrys

HANA DB-Version 1.00.112.00.1457615240

Can somebody help me solve this issue?

SAP Managed Tags:
SAP HANA

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (4)

Keep in mind, there's more to HANA memory utilization than just the data in the database itself. There has to be enough space to be able to process data the data as well. Check this out to see if it helps you better understand what's going on. It's a bit old but gets the basics across: https://www.edge-solutions.com/wp-content/uploads/2014/03/HANA_Memory_Usage_v2.pdf

And the SQL statements that I use most from note 1969700 are:

HANA_Configuration_MiniChecks_<pick your appropriate version>.txt

HANA_Heap_MemoryObjects.txt

HANA_Memory_Overview.txt

HANA_Memory_TopConsumers_History_Rev90+_ESS.txt

HANA_Tables_LargestTables.txt

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Vincenzo,

Can you confirm that no memory allocation limit has been setup on Hana, because it could be a reason.

Also what i would recommend you to do is to run the system check based upon the sql statement collection from the following note :

1969700 - SQL statement collection for SAP HANA

This will help you to optimize your system at different place.

Please me know

Regard

Williams

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Guis,

Thanks for all hints.

I have set the limits discribed in this SAP Post.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/bd/43f1c0bb571014bf5acf22f379fd3d/content.htm

https://help.sap.com/saphelp_hanaplatform/helpdata/en/c1/a774b3bb571014af018d2352f0d757/content.htm

Now we are waiting to see if the Problem persists.

Thanks to all!!

Regards

Vincenzo

Hi @all,

Today I have the same Dumps on my System, so setting the memory parameter didn't help.

Now I was able to see the oom_Dumps but can't figure out whats wrong with the system.

I will paste the OOM_DUMP File

Thanks

Vincenzo

SQL: WITH _SYS_WITH_0 AS (/* procedure: _SYS_STATISTICS.SHARED_FOLLOW_UP_ACTIONS variable: RESULT line: 16 col: 1 */SELECT "LEAVE_ACTION", "COMMAND", "ACTION_EXECUTED", "ALERT_LAST_CHECK_RATING" FROM ( ( SELECT 1 AS "LEAVE_ACTION", CASE WHEN ( ( SELECT "ACTION_ID" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_ALERT_ACTIONS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(0 AS INT) AND IFNULL("ACTION_EXECUTED", 0) <> 1 ) ) ) = 1 THEN ( ( SELECT 'alter system alter configuration (''' || ( ( SELECT "FILENAME" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(0 AS INT) ) ) ) || ''', ''' || ( ( SELECT "LAYER" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(0 AS INT) ) ) ) || ''') unset ' || ( ( SELECT TRIM(TRAILING ',' FROM STRING_AGG('(''' || "SECTION" || ''', ''' || "KEY" || '''),')) AS "RTRIM(STRING_AGG('(''||SECTION||'', ''||KEY||''),'),',')" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(0 AS INT) ) ) ) || ' with reconfigure' AS "'alter system alter configuration (''||(SELECTFILENAMEFROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:LAST_SEVERITY)||'', ''||(SELECTLAYERFROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:LAST_SEVERITY)||'') unset '||(SELECTRTRIM(STRING_AGG('('''||SECTION||''','''||KEY||'''),'),',')FROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:LAST_SEVERITY)||' with reconfigure'" FROM "SYS"."DUMMY" ) ) WHEN ( ( SELECT "ACTION_ID" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_ALERT_ACTIONS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(0 AS INT) AND IFNULL("ACTION_EXECUTED", 0) <> 1 ) ) ) = 2 THEN ( ( SELECT 'select * from sys.dummy' FROM "SYS"."DUMMY" ) ) END AS "COMMAND", 1 AS "ACTION_EXECUTED", "ALERT_LAST_CHECK_RATING" AS "ALERT_LAST_CHECK_RATING" FROM "_SYS_STATISTICS"."STATISTICS_LAST_CHECKS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND CAST(0 AS INT) <> CAST(2 AS INT) ) ) UNION ALL ( SELECT 0 AS "LEAVE_ACTION", CASE WHEN ( ( SELECT "ACTION_ID" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_ALERT_ACTIONS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) AND IFNULL("ACTION_EXECUTED", 0) <> 1 ) ) ) = 1 THEN ( ( SELECT 'alter system alter configuration (''' || ( ( SELECT "FILENAME" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) ) ) ) || ''', ''' || ( ( SELECT "LAYER" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) ) ) ) || ''') set ' || ( ( SELECT TRIM(TRAILING ',' FROM STRING_AGG('(''' || "SECTION" || ''', ''' || "KEY" || ''')=''' || "VALUE" || ''',')) AS "RTRIM(STRING_AGG('(''||SECTION||'', ''||KEY||'')=''||VALUE||'','),',')" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) ) ) ) || ' with reconfigure' AS "'alter system alter configuration (''||(SELECTFILENAMEFROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:ACTUAL_SEVERITY)||'', ''||(SELECTLAYERFROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:ACTUAL_SEVERITY)||'') set '||(SELECTRTRIM(STRING_AGG('('''||SECTION||''','''||KEY||''')='''||VALUE||''','),',')FROM_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGSWHEREALERT_ID=:ALERT_IDANDSEVERITY=:ACTUAL_SEVERITY)||' with reconfigure'" FROM "SYS"."DUMMY" ) ) WHEN ( ( SELECT "ACTION_ID" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_ALERT_ACTIONS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) AND IFNULL("ACTION_EXECUTED", 0) <> 1 ) ) ) = 2 THEN ( ( SELECT 'call sys.management_console_proc(''' || "COMMAND" || ' ' || "OPTIONS" || ''' , ''' || "LOCATION" || ''',?)' AS "'call sys.management_console_proc(''||COMMAND||' '||OPTIONS||'' , ''||LOCATION||'',?)'" FROM "_SYS_STATISTICS"."STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND "SEVERITY" = CAST(2 AS INT) ) ) ) END AS "COMMAND", 0 AS "ACTION_EXECUTED", "ALERT_LAST_CHECK_RATING" AS "ALERT_LAST_CHECK_RATING" FROM "_SYS_STATISTICS"."STATISTICS_LAST_CHECKS" WHERE ( "ALERT_ID" = CAST(65 AS INT) AND CAST(0 AS INT) <> CAST(2 AS INT) ) ) ) WHERE "COMMAND" IS NOT NULL ) SELECT "LEAVE_ACTION","COMMAND","ACTION_EXECUTED","ALERT_LAST_CHECK_RATING" FROM _SYS_WITH_0 /* 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 */

QUERY PLAN:

|ROW SEARCH|_SYS_WITH_0.LEAVE_ACTION, _SYS_WITH_0.COMMAND, _SYS_WITH_0.ACTION_EXECUTED, _SYS_WITH_0.ALERT_LAST_CHECK_RATING|ROW|||||-1|2|7.51067e-05|1|0|1|1|svlidpdb|30203|105|

| MATERIALIZED UNION ALL|(1, 0) UNION_COL0, (CASE WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 1 THEN SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('alter system alter configuration ('', SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)), '', ''), SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)), '') unset '), RTRIM(STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), ''),')), ',')), ' with reconfigure')) WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 2 THEN 'select * from sys.dummy' ELSE NULL END, CASE WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 1 THEN SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('alter system alter configuration ('', SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)), '', ''), SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)), '') set '), RTRIM(STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), '')=''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.VALUE), '',')), ',')), ' with reconfigure')) WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 2 THEN TO_NCHAR(SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('call sys.management_console_proc('', STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.COMMAND), ' '), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.OPTIONS), '' , ''), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.LOCATION), '',?)'))) ELSE NULL END) UNION_COL1, (1, 0) UNION_COL2, (STATISTICS_LAST_CHECKS.ALERT_LAST_CHECK_RATING, STATISTICS_LAST_CHECKS.ALERT_LAST_CHECK_RATING) UNION_COL3|ROW|||||-1|2|6.85385e-05|2|1|2|0|svlidpdb|30203|103|

| NESTED LOOP JOIN|MANY-TO-ONE |ROW|||||-1|1|2.75902e-05|3|2|3|0|svlidpdb|30203|64|

| VIEW|PROJECT COLS: IFNULL(TO_INT(MAX(MAX(STATISTICS_ALERTS_BASE.ALERT_RATING))), 0), |ROW|||||-1|1|5.20802e-06|4|3|4|0|svlidpdb|30203|35|

| NESTED LOOP JOIN (LEFT OUTER)|ONE-TO-MANY (ENUM_BY: AGGR_THRU_JOIN)|ROW|||||-1|1|4.03802e-06|5|4|5|0|svlidpdb|30203|33|

| BTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#140519_#0_#P0, INDEX CONDITION: STATISTICS_LAST_CHECKS.ALERT_ID = 65 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_ALERT_INFORMATION|ROW TABLE|101|1|2.28089e-07|6|5|6|0|svlidpdb|30203|1|

| NESTED LOOP JOIN| (ENUM_BY: AGGR_THRU_JOIN)|ROW|||||-1|1|3.47045e-06|7|5|6|1|svlidpdb|30203|31|

| AGGREGATION|GROUPING: 0, AGGREGATION: MAX(MAX(STATISTICS_ALERTS_BASE.ALERT_RATING)) (ENUM_BY: PREAGGR_BEFORE_JOIN)|ROW|||||-1|1|2.90288e-06|8|7|7|0|svlidpdb|30203|27|

| BTREE INDEX JOIN|INDEX NAME: _SYS_TREE_RS_#9231269_#0_#P0, INDEX CONDITION: T.ALERT_ID = SCHEDULE.ID (ENUM_BY: INDEX_JOIN)|ROW||_SYS_STATISTICS|STATISTICS_SCHEDULE|ROW TABLE|153|1|4.29708e-07|9|8|8|0|svlidpdb|30203|25|

| COLUMN SEARCH|T.ALERT_ID, MAX(STATISTICS_ALERTS_BASE.ALERT_RATING) (PARALLELIZED, OLTP SEARCH, ENUM_BY: CS_AGGR, PREFERENCE: 2)|COLUMN|||||272.852|1|0|10|9|9|0|svlidpdb|30203|23|

| AGGREGATION|GROUPING: T.ALERT_ID, AGGREGATION: MAX(STATISTICS_ALERTS_BASE.ALERT_RATING)|COLUMN|||||-1|1|0.0837093|11|10|10|0||-1|23|

| COLUMN SEARCH|T.ALERT_ID, STATISTICS_ALERTS_BASE.ALERT_RATING (ENUM_BY: CS_AGGR, PREFERENCE: 2)|COLUMN|||#_SYS_QO_COL_7fc50040ed60:600000000005d36||-1|272.852|0|12|11|11|0|svlidpdb|30203|22|

| COLUMN UNION ALL|(STATISTICS_ALERTS_BASE.ALERT_ID, STATISTICS_ALERTS_BASE.ALERT_ID) UNION_COL1, (STATISTICS_ALERTS_BASE.ALERT_RATING, STATISTICS_ALERTS_BASE.ALERT_RATING) UNION_COL5, (ENUM_BY: CS_UNION_ALL, PREFERENCE: 2)|COLUMN|||||0|272.852|0|13|12|12|0|svlidpdb|30203|21|

| COLUMN SEARCH|STATISTICS_ALERTS_BASE.ALERT_RATING, STATISTICS_ALERTS_BASE.ALERT_ID (PARALLELIZED, ENUM_BY: CS_UNION_ALL)|COLUMN|||#_SYS_QO_COL_7fc50055e700:600000000005d09||-1|1.21863|0.0367652|14|13|13|0|svlidpdb|30203|8|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.SNAPSHOT_ID = MAX(STATISTICS_ALERTS_BASE.SNAPSHOT_ID)|COLUMN|||||-1|1.21863|0.0367552|15|14|15|0||-1|7|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|16|15|16|0|svlidpdb|30203|7|

| COLUMN SEARCH|MAX(STATISTICS_ALERTS_BASE.SNAPSHOT_ID), STATISTICS_ALERTS_BASE.ALERT_ID (ENUM_BY: CS_UNION_ALL)|OLAP|||#_SYS_QO_COL_7fc500512ff0:600000000005d00||-1|1|0.035067|17|15|16|1|svlidpdb|30203|6|

| AGGREGATION|GROUPING: STATISTICS_ALERTS_BASE.ALERT_ID, AGGREGATION: MAX(STATISTICS_ALERTS_BASE.SNAPSHOT_ID)|OLAP|||||-1|1|0.0350669|18|17|18|0||-1|5|

| FILTER|STATISTICS_ALERTS_BASE.SNAPSHOT_ID > ADD_SECONDS(IFNULL(SCHEDULE.LATEST_START_SERVERTIME_MANUAL, '2000-01-01'), SECONDS_BETWEEN(CURRENT_TIMESTAMP, CURRENT_UTCTIMESTAMP)) AND STATISTICS_ALERTS_BASE.SNAPSHOT_ID >= SCHEDULE.LATEST_START_SNAPSHOT_ID|OLAP|||||-1|1|0.00927616|19|18|19|0||-1|5|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.ALERT_ID = SCHEDULE.ID|OLAP|||||-1|46297.9|0.00181552|20|19|20|0||-1|5|

| COLUMN TABLE|[FACT] FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65 AND STATISTICS_ALERTS_BASE.ALERT_RATING != 0|OLAP||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|21|20|21|0|svlidpdb|30203|5|

| ROW SEARCH|SCHEDULE.ID, SCHEDULE.LATEST_START_SNAPSHOT_ID, SCHEDULE.LATEST_START_SERVERTIME_MANUAL (ENUM_BY: CS_JOIN)|ROW|||#_SYS_QO_ROW_7fc500507570:600000000005cf6||-1|153|6.273e-06|22|20|21|1|svlidpdb|30203|4|

| TABLE SCAN||ROW||_SYS_STATISTICS|STATISTICS_SCHEDULE|ROW TABLE|153|153|6.273e-06|23|22|22|0|svlidpdb|30203|3|

| COLUMN SEARCH|STATISTICS_ALERTS_BASE.ALERT_ID, STATISTICS_ALERTS_BASE.ALERT_RATING (PARALLELIZED, ENUM_BY: CS_UNION_ALL)|COLUMN|||#_SYS_QO_COL_7fc5005855d0:600000000005d2d||-1|271.633|0.0458398|24|13|13|1|svlidpdb|30203|19|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.SNAPSHOT_ID = STATISTICS_ALERTS_BASE.SNAPSHOT_ID|COLUMN|||||-1|271.633|0.0458107|25|24|15|0||-1|18|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|26|25|16|0|svlidpdb|30203|18|

| COLUMN SEARCH|STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID (ENUM_BY: CS_UNION_ALL)|COLUMN|||#_SYS_QO_COL_7fc50051bef0:600000000005d24||-1|228.442|0.0435488|27|25|16|1|svlidpdb|30203|17|

| DISTINCT|GROUPING: STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID|COLUMN|||||-1|228|0.0435308|28|27|18|0||-1|16|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.ALERT_ID = SCHEDULE.ID, (INNER) ADD_SECONDS(STATISTICS_ALERTS_BASE.SNAPSHOT_ID, SECONDS_BETWEEN(CURRENT_UTCTIMESTAMP, CURRENT_TIMESTAMP)) = SCHEDULE.LATEST_START_SERVERTIME_MANUAL|COLUMN|||||-1|194.914|0.0434131|29|28|19|0||-1|16|

| ROW SEARCH|SCHEDULE.ID, SCHEDULE.LATEST_START_SERVERTIME_MANUAL (PARALLELIZED, ENUM_BY: CS_JOIN)|ROW|||#_SYS_QO_ROW_7fc5005104b0:600000000005d11||-1|153|6.273e-06|30|29|20|0|svlidpdb|30203|11|

| TABLE SCAN||ROW||_SYS_STATISTICS|STATISTICS_SCHEDULE|ROW TABLE|153|153|6.273e-06|31|30|21|0|svlidpdb|30203|10|

| COLUMN SEARCH|STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID, ADD_SECONDS(STATISTICS_ALERTS_BASE.SNAPSHOT_ID, SECONDS_BETWEEN(CURRENT_UTCTIMESTAMP, CURRENT_TIMESTAMP)) (PARALLELIZED, ENUM_BY: CS_JOIN)|COLUMN|||#_SYS_QO_COL_7fc5005185d0:600000000005d1a||-1|37069.6|0.0229596|32|29|20|1|svlidpdb|30203|14|

| DISTINCT|GROUPING: STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID|COLUMN|||||-1|37069|0.0216434|33|32|22|0||-1|13|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|34|33|23|0|svlidpdb|30203|13|

| BTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#140519_#0_#P0, INDEX CONDITION: R.ALERT_ID = 65 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_ALERT_INFORMATION|ROW TABLE|101|1|2.28089e-07|35|7|7|1|svlidpdb|30203|29|

| NESTED LOOP JOIN|MANY-TO-ONE |ROW|||||-1|1|2.14192e-05|37|36|5|0|svlidpdb|30203|61|

| AGGREGATION|AGGREGATION: SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('alter system alter configuration ('', SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)), '', ''), SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)), '') unset '), RTRIM(STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), ''),')), ',')), ' with reconfigure'))|ROW|||||-1|1|1.21761e-05|38|37|6|0|svlidpdb|30203|51|

| NESTED LOOP JOIN|ONE-TO-ONE |ROW|||||-1|1|1.16549e-05|39|38|7|0|svlidpdb|30203|49|

| NESTED LOOP JOIN|ONE-TO-ONE |ROW|||||-1|1|7.65681e-06|40|39|8|0|svlidpdb|30203|44|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)|ROW|||||-1|1|3.65866e-06|41|40|9|0|svlidpdb|30203|39|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859813_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.SEVERITY = 0 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS|ROW TABLE|10000|1|3.13749e-06|42|41|10|0|svlidpdb|30203|38|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)|ROW|||||-1|1|3.65866e-06|43|40|9|1|svlidpdb|30203|42|

| AGGREGATION|AGGREGATION: STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), ''),'))|ROW|||||-1|1|3.65866e-06|45|39|8|1|svlidpdb|30203|47|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859833_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SEVERITY = 0 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS|ROW TABLE|10000|1|3.13749e-06|46|45|9|0|svlidpdb|30203|46|

| NESTED LOOP JOIN|ONE-TO-MANY |ROW|||||-1|1|8.90368e-06|47|37|6|1|svlidpdb|30203|59|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID)|ROW|||||-1|1|4.2821e-06|48|47|7|0|svlidpdb|30203|54|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859762_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_ALERT_ACTIONS.SEVERITY = 0, FILTER CONDITION: IFNULL(TO_INT(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_EXECUTED), 0) <> 1 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_ALERT_ACTIONS|ROW TABLE|10000|1|3.76092e-06|49|48|8|0|svlidpdb|30203|53|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID)|ROW|||||-1|1|4.2821e-06|50|47|7|1|svlidpdb|30203|57|

| FILTER|CASE WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 1 THEN SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('alter system alter configuration ('', SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)), '', ''), SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)), '') set '), RTRIM(STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), '')=''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.VALUE), '',')), ',')), ' with reconfigure')) WHEN SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID) = 2 THEN TO_NCHAR(SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('call sys.management_console_proc('', STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.COMMAND), ' '), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.OPTIONS), '' , ''), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.LOCATION), '',?)'))) ELSE NULL END IS NOT NULL|ROW|||||-1|1|3.15883e-05|52|2|3|1|svlidpdb|30203|100|

| NESTED LOOP JOIN|ONE-TO-MANY |ROW|||||-1|1|3.09649e-05|53|52|4|0|svlidpdb|30203|98|

| AGGREGATION|AGGREGATION: SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('alter system alter configuration ('', SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)), '', ''), SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)), '') set '), RTRIM(STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), '')=''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.VALUE), '',')), ',')), ' with reconfigure'))|ROW|||||-1|1|1.21761e-05|54|53|5|0|svlidpdb|30203|79|

| NESTED LOOP JOIN|ONE-TO-ONE |ROW|||||-1|1|1.16549e-05|55|54|6|0|svlidpdb|30203|77|

| NESTED LOOP JOIN|ONE-TO-ONE |ROW|||||-1|1|7.65681e-06|56|55|7|0|svlidpdb|30203|72|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.FILENAME)|ROW|||||-1|1|3.65866e-06|57|56|8|0|svlidpdb|30203|67|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859813_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.SEVERITY = 2 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS|ROW TABLE|10000|1|3.13749e-06|58|57|9|0|svlidpdb|30203|66|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.LAYER)|ROW|||||-1|1|3.65866e-06|59|56|8|1|svlidpdb|30203|70|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859813_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS.SEVERITY = 2 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS|ROW TABLE|10000|1|3.13749e-06|60|59|9|0|svlidpdb|30203|69|

| AGGREGATION|AGGREGATION: STRING_AGG(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('('', STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SECTION), '', ''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.KEY), '')=''), STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.VALUE), '','))|ROW|||||-1|1|3.65866e-06|61|55|7|1|svlidpdb|30203|75|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859833_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS.SEVERITY = 2 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS|ROW TABLE|10000|1|3.13749e-06|62|61|8|0|svlidpdb|30203|74|

| NESTED LOOP JOIN|MANY-TO-ONE |ROW|||||-1|1|1.84493e-05|63|53|5|1|svlidpdb|30203|96|

| NESTED LOOP JOIN|MANY-TO-ONE |ROW|||||-1|1|1.38277e-05|64|63|6|0|svlidpdb|30203|91|

| NESTED LOOP JOIN|MANY-TO-ONE |ROW|||||-1|1|8.28024e-06|65|64|7|0|svlidpdb|30203|87|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID)|ROW|||||-1|1|4.2821e-06|66|65|8|0|svlidpdb|30203|82|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859762_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_ALERT_ACTIONS.SEVERITY = 2, FILTER CONDITION: IFNULL(TO_INT(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_EXECUTED), 0) <> 1 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_ALERT_ACTIONS|ROW TABLE|10000|1|3.76092e-06|67|66|9|0|svlidpdb|30203|81|

| AGGREGATION|AGGREGATION: SINGLE(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('call sys.management_console_proc('', STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.COMMAND), ' '), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.OPTIONS), '' , ''), STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.LOCATION), '',?)'))|ROW|||||-1|1|3.65866e-06|68|65|8|1|svlidpdb|30203|85|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859850_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS.SEVERITY = 2 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS|ROW TABLE|10000|1|3.13749e-06|69|68|9|0|svlidpdb|30203|84|

| VIEW|PROJECT COLS: IFNULL(TO_INT(MAX(MAX(STATISTICS_ALERTS_BASE.ALERT_RATING))), 0), |ROW|||||-1|1|5.20802e-06|70|64|7|1|svlidpdb|30203|89|

| NESTED LOOP JOIN (LEFT OUTER)|ONE-TO-MANY (ENUM_BY: AGGR_THRU_JOIN)|ROW|||||-1|1|4.03802e-06|71|70|8|0|svlidpdb|30203|33|

| NESTED LOOP JOIN| (ENUM_BY: AGGR_THRU_JOIN)|ROW|||||-1|1|3.47045e-06|73|71|9|1|svlidpdb|30203|31|

| AGGREGATION|GROUPING: 0, AGGREGATION: MAX(MAX(STATISTICS_ALERTS_BASE.ALERT_RATING)) (ENUM_BY: PREAGGR_BEFORE_JOIN)|ROW|||||-1|1|2.90288e-06|74|73|10|0|svlidpdb|30203|27|

| COLUMN SEARCH|T.ALERT_ID, MAX(STATISTICS_ALERTS_BASE.ALERT_RATING) (PARALLELIZED, OLTP SEARCH, ENUM_BY: CS_AGGR, PREFERENCE: 2)|COLUMN|||||272.852|1|0|76|75|12|0|svlidpdb|30203|23|

| AGGREGATION|GROUPING: T.ALERT_ID, AGGREGATION: MAX(STATISTICS_ALERTS_BASE.ALERT_RATING)|COLUMN|||||-1|1|0.0837093|77|76|13|0||-1|23|

| COLUMN SEARCH|T.ALERT_ID, STATISTICS_ALERTS_BASE.ALERT_RATING (ENUM_BY: CS_AGGR, PREFERENCE: 2)|COLUMN|||#_SYS_QO_COL_7fc50040ed60:600000000005d36||-1|272.852|0|78|77|14|0|svlidpdb|30203|22|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.SNAPSHOT_ID = MAX(STATISTICS_ALERTS_BASE.SNAPSHOT_ID)|COLUMN|||||-1|1.21863|0.0367552|81|80|18|0||-1|7|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|82|81|19|0|svlidpdb|30203|7|

| AGGREGATION|GROUPING: STATISTICS_ALERTS_BASE.ALERT_ID, AGGREGATION: MAX(STATISTICS_ALERTS_BASE.SNAPSHOT_ID)|OLAP|||||-1|1|0.0350669|84|83|21|0||-1|5|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.ALERT_ID = SCHEDULE.ID|OLAP|||||-1|46297.9|0.00181552|86|85|23|0||-1|5|

| TABLE SCAN||ROW||_SYS_STATISTICS|STATISTICS_SCHEDULE|ROW TABLE|153|153|6.273e-06|89|88|25|0|svlidpdb|30203|3|

| JOIN|JOIN CONDITION: (INNER) STATISTICS_ALERTS_BASE.SNAPSHOT_ID = STATISTICS_ALERTS_BASE.SNAPSHOT_ID|COLUMN|||||-1|271.633|0.0458107|91|90|18|0||-1|18|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|92|91|19|0|svlidpdb|30203|18|

| DISTINCT|GROUPING: STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID|COLUMN|||||-1|228|0.0435308|94|93|21|0||-1|16|

| ROW SEARCH|SCHEDULE.ID, SCHEDULE.LATEST_START_SERVERTIME_MANUAL (PARALLELIZED, ENUM_BY: CS_JOIN)|ROW|||#_SYS_QO_ROW_7fc5005104b0:600000000005d11||-1|153|6.273e-06|96|95|23|0|svlidpdb|30203|11|

| TABLE SCAN||ROW||_SYS_STATISTICS|STATISTICS_SCHEDULE|ROW TABLE|153|153|6.273e-06|97|96|24|0|svlidpdb|30203|10|

| DISTINCT|GROUPING: STATISTICS_ALERTS_BASE.SNAPSHOT_ID, STATISTICS_ALERTS_BASE.ALERT_ID|COLUMN|||||-1|37069|0.0216434|99|98|25|0||-1|13|

| COLUMN TABLE|FILTER CONDITION: STATISTICS_CURRENT_ALERTS.ALERT_ID = 65|COLUMN||_SYS_STATISTICS|STATISTICS_ALERTS_BASE|COLUMN TABLE|102203|46297.9|-1|100|99|26|0|svlidpdb|30203|13|

| AGGREGATION|AGGREGATION: SINGLE(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_ID)|ROW|||||-1|1|4.2821e-06|102|63|6|1|svlidpdb|30203|94|

| CPBTREE INDEX SEARCH|INDEX NAME: _SYS_TREE_RS_#16859762_#0_#P0, INDEX CONDITION: STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ALERT_ID = 65 AND STATISTICS_FOLLOW_UP_ALERT_ACTIONS.SEVERITY = 2, FILTER CONDITION: IFNULL(TO_INT(STATISTICS_FOLLOW_UP_ALERT_ACTIONS.ACTION_EXECUTED), 0) <> 1 (ENUM_BY: INDEX_SEARCH)|ROW||_SYS_STATISTICS|STATISTICS_FOLLOW_UP_ALERT_ACTIONS|ROW TABLE|10000|1|3.76092e-06|103|102|7|0|svlidpdb|30203|93|

RELATED OBJECTS:

-TABLE:SYS.DUMMY(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_ALERT_INFORMATION(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_SCHEDULE(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_ALERTS_BASE(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_FOLLOW_UP_ALERT_ACTIONS(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_LAYER_SETTINGS(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_FOLLOW_UP_CONFIGURATION_SETTINGS(svlidpdb:30203),_SYS_STATISTICS.STATISTICS_FOLLOW_UP_HDBCONS_SETTINGS(svlidpdb:30203)

-VIEW:_SYS_STATISTICS.STATISTICS_ALERTS,_SYS_STATISTICS.STATISTICS_CURRENT_ALERTS,_SYS_STATISTICS.STATISTICS_LAST_CHECKS

-INDEX:_SYS_STATISTICS._SYS_TREE_RS_#9231269_#0_#P0,_SYS_STATISTICS._SYS_TREE_RS_#140519_#0_#P0,_SYS_STATISTICS._SYS_TREE_RS_#16859762_#0_#P0,_SYS_STATISTICS._SYS_TREE_RS_#16859813_#0_#P0,_SYS_STATISTICS._SYS_TREE_RS_#16859833_#0_#P0,_SYS_STATISTICS._SYS_TREE_RS_#16859850_#0_#P0

-USER:_SYS_STATISTICS

STATEMENT-TRANSTOKEN: Newdb::TransToken CONTENTS - 0x00007fbfd3bf9340 [ tid = -573724728 cid = 0 stmt_seq = 6 parallel_read_write_tx_scope_stmt_seq = 0 parallel_read_write_tx_scope = 0 parallel_read_write_tx_scope_parallel_writers = 0 parent = 0x00007fce57335b40 snapshot_token = 0x00007fce3419e400 trans = 0x00007fce72ba1c00 stmt = 0x00007fc53234a400 isoLevel = 1 trans_lock_timeout = -1 } / SnapshotToken ID - 0x00007fce3419e400

TRANSACTION-TRANSTOKEN: Newdb::TransToken CONTENTS - 0x00007fce57335b40 [ tid = 573724708 cid = 0 stmt_seq = 0 parallel_read_write_tx_scope_stmt_seq = 0 parallel_read_write_tx_scope = 0 parallel_read_write_tx_scope_parallel_writers = 0 parent = 0x0000000000000000 snapshot_token = 0x0000000000000000 trans = 0x00007fce72ba1c00 stmt = 0x0000000000000000 isoLevel = 1 trans_lock_timeout = -1 }

PARENT STATEMENT

STATEMENT-TRANSTOKEN: Newdb::TransToken CONTENTS - 0x00007fa13e21ac40 [ tid = -573724728 cid = 0 stmt_seq = 6 parallel_read_write_tx_scope_stmt_seq = 0 parallel_read_write_tx_scope = 0 parallel_read_write_tx_scope_parallel_writers = 0 parent = 0x00007fce57335b40 snapshot_token = 0x0000000000000000 trans = 0x00007fce72ba1c00 stmt = 0x00007fc51bfe3000 isoLevel = 1 trans_lock_timeout = -1 }

}

" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427369[thr=23219]: JobWrk0008, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427343[thr=23218]: JobWrk0007, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427281[thr=23217]: JobWrk0006, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427184[thr=23216]: LogBackupThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427161[thr=23213]: EpochCommunicator, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1443297[thr=23246]: TransTokenHistoryMgr, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "TransTokenHistoryMgr", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416132[thr=23174]: MvccAntiAgerChecker, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "MvccAntiAgerChecker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416134[thr=23175]: ExternalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "ExternalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416136[thr=23176]: RemotePostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "RemotePostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416138[thr=23177]: RemotePostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "RemotePostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416142[thr=23178]: CommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "CommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416150[thr=23185]: AsyncRSIndexLoadScheduler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Async RS Index Loading Thread", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416155[thr=23186]: AsyncRSIndexPreloader, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8525f0d in __nanosleep_nocancel+0x24 (libc.so.6)

1416326[thr=23189]: LogSegmentManager, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416329[thr=23187]: LogSegmentFinishIO, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416337[thr=23188]: LogSegmentFormatter[0], TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427146[thr=23211]: EpochCommunicator, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1443256[thr=23233]: JobWrk0022, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1429339[thr=23232]: JobWrk0021, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1429305[thr=23231]: JobWrk0020, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

709010549[thr=18903]: SqlExecutor, TID: 54, UTID: -1, CID: 323182, LCID: 323182, parent: ---, SQLUserName: "SAPERP", AppUserName: "BPINST", AppName: "ABAP:IDP", ConnCtx: 323182 {LDBID: 2, LCID: 323182}, StmtCtx: (1) 1388060344941833 {Parent: 323182, ObjHdl: 140410981247872, User: "SAPERP", Schema: "SAPERP, SesCtx: {ObjHdl: 140495316238848, CID: 323182, LCID: 323182, User: "SAPERP", Schema: "SAPERP, Ver: 10, CtxID: 11009210}}, type: "SqlExecutor", method: "", detail: "", command: "

{

SQL: SELECT "DATA" FROM "REPOSRC" WHERE "PROGNAME" = ? AND "R3STATE" = ?

QUERY PLAN:

|COLUMN SEARCH|REPOSRC.DATA (LATE MATERIALIZATION, OLTP SEARCH, ENUM_BY: CS_TABLE)|COLUMN|||||-1|1|9.72536e-07|1|0|1|1|svlidpdb|30203|2|

| COLUMN TABLE|FILTER CONDITION: REPOSRC.PROGNAME = ?1 AND REPOSRC.R3STATE = ?2|COLUMN||SAPERP|REPOSRC|COLUMN TABLE|4.82448e+06|1|-1|2|1|3|0|svlidpdb|30203|1|

RELATED OBJECTS:

-TABLE:SAPERP.REPOSRC(svlidpdb:30203)

-USER:SAPERP

STATEMENT-TRANSTOKEN: Newdb::TransToken CONTENTS - 0x00007fb5a89695c0 [ tid = -573724758 cid = 0 stmt_seq = 1 parallel_read_write_tx_scope_stmt_seq = 0 parallel_read_write_tx_scope = 0 parallel_read_write_tx_scope_parallel_writers = 0 parent = 0x00007fc50466b540 snapshot_token = 0x00007fcdd592aa00 trans = 0x00007f83191e5c00 stmt = 0x00007fbed2691c00 isoLevel = 1 trans_lock_timeout = -1 } / SnapshotToken ID - 0x00007fcdd592aa00

TRANSACTION-TRANSTOKEN: Newdb::TransToken CONTENTS - 0x00007fc50466b540 [ tid = -573724758 cid = 0 stmt_seq = 0 parallel_read_write_tx_scope_stmt_seq = 0 parallel_read_write_tx_scope = 0 parallel_read_write_tx_scope_parallel_writers = 0 parent = 0x0000000000000000 snapshot_token = 0x0000000000000000 trans = 0x00007f83191e5c00 stmt = 0x0000000000000000 isoLevel = 1 trans_lock_timeout = -1 }

}

" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1427981[thr=23229]: JobWrk0018, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4828[thr=23083]: JobWrk0004, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4830[thr=23084]: JobWrk0005, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4839[thr=23112]: RemotePostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "RemotePostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1414111[thr=23141]: EpochManager, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1414177[thr=23142]: LocalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "LocalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416103[thr=23163]: LocalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "LocalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416105[thr=23164]: LocalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "LocalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416107[thr=23165]: LocalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "LocalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416109[thr=23166]: ExternalPostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "ExternalPostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416111[thr=23167]: MVCCGarbageCollector, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "MVCCGarbageCollector", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416113[thr=23168]: IndexingQueue, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "IndexingQueue", method: "", detail: "_SYS_REPO:ACTIVE_OBJECTen.CDATA", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416115[thr=23169]: CatalogWatchdog, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "CatalogWatchdog", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416119[thr=23170]: Request, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Request", method: "EPOCH_CLIENT_REQUEST", detail: "", command: "" at 0x00007fe2c854e896 in __GI___poll+0x66 (libc.so.6)

1416126[thr=23171]: RemotePostCommitHandler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "RemotePostCommitHandler", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416128[thr=23172]: IndexingQueue, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "IndexingQueue", method: "", detail: "_SYS_REPO:ACTIVE_OBJECT_TEXT_CONTENTen.CONTENT", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1416130[thr=23173]: Request, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Request", method: "EPOCH_CLIENT_REQUEST", detail: "", command: "" at 0x00007fe2c854e896 in __GI___poll+0x66 (libc.so.6)

4233[thr=23038]: JobexMainDispatcher, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4235[thr=23039]: JobWrkDiag, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobexDiag", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4237[thr=23040]: JobWrk0002, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4239[thr=23041]: JobWrk0003, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobWorker", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4258[thr=23061]: SqlExecutor, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "SqlExecutor", method: "", detail: "", command: "" at 0x00007fe2c85583f3 in __epoll_wait_nocancel+0x2a (libc.so.6)

4270[thr=23064]: SelfWatchDog, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "SelfWatchDog", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4273[thr=23065]: CalcEngineGarbageCollector, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "CalcEngineGarbageCollector", method: "", detail: "inactive", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4298[thr=23067]: SubmitThread-DATA_BACKUP-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4301[thr=23068]: FileCompletionThread-DATA_BACKU, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2bd9eb6a4 in io_queue_run+0x64 (libaio.so.1)

4320[thr=23070]: SubmitThread-LOG_BACKUP-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4323[thr=23072]: FileCompletionThread-LOG_BACKUP, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2bd9eb6a4 in io_queue_run+0x64 (libaio.so.1)

4353[thr=23073]: SubmitThread-LOG-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4356[thr=23075]: FileCompletionThread-LOG-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2bd9eb6a4 in io_queue_run+0x64 (libaio.so.1)

4377[thr=23077]: SubmitThread-DATA-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4380[thr=23079]: FileCompletionThread-DATA-0, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2bd9eb6a4 in io_queue_run+0x64 (libaio.so.1)

4388[thr=23215]: Savepoint, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "PeriodicSavepoint", method: "waiting for wake up", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

5[thr=0]: <SYSTEM>, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c854e896 in __GI___poll+0x66 (libc.so.6)

1386[thr=23001]: TimerThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

1417[thr=23005]: TraceSegmentCompressor, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "Wait", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

3193[thr=23000]: MemoryCompactor, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8803ae7 in sem_timedwait+0x57 (libpthread.so.0)

3195[thr=23002]: CrashWatchThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

3201[thr=23003]: NetworkChannelCompletionThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c85583f3 in __epoll_wait_nocancel+0x2a (libc.so.6)

3202[thr=23004]: NetworkChannelCompletionThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c85583f3 in __epoll_wait_nocancel+0x2a (libc.so.6)

3216[thr=23006]: WakeupThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c880476d in __read_nocancel+0x24 (libpthread.so.0)

3295[thr=23015]: FlushResourcesThread, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

3304[thr=23014]: ResManPagedAttributeUnloadThrea, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4159[thr=23026]: PlanExecutorActivity, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "PlanExecutorActivity", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4166[thr=23271]: SegmentPreallocator, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "Generic", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4187[thr=23028]: ServiceThreadSampler, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: 0, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "ServiceThreadSampler", method: "interval 1 sec.", detail: "", command: "" at 0x00007fe2c8525f0d in __nanosleep_nocancel+0x24 (libc.so.6)

4201[thr=23030]: SignalQueue, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "SignalQueue", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

4231[thr=23037]: JobexWatchdog, TID: -1, UTID: -1, CID: -1, LCID: 0, parent: ---, SQLUserName: "", AppUserName: "", AppName: "", ConnCtx: ---, StmtCtx: ---, type: "JobexWatchdog", method: "", detail: "", command: "" at 0x00007fe2c8554789 in syscall+0x19 (libc.so.6)

[OK]

[MEMORY_OOM] Information about current out of memory situation: (2016-05-25 02:23:08 833 Local)

OUT OF MEMORY occurred.

Host: svlidpdb

Executable: hdbindexserver

PID: 22979

Current callstack:

1: 0x00007fe2eae9a685 in Executor::X2::~X2()+0x3e1 at X2.cpp:692 (libhdbexecutor.so)

2: 0x00007fe2eae67f02 in Executor::PlanExecutor::calculateX2(TRexCommonObjects::TRexApiError&, Executor::X2Statistics&)+0x380 at PlanExecutor.cpp:115 (libhdbexecutor.so)

3: 0x00007fe2eae686af in Executor::PlanExecutor::calculate(TRexCommonObjects::TRexApiError&, Executor::X2Statistics&)+0x18b at PlanExecutor.cpp:679 (libhdbexecutor.so)

4: 0x00007fe2cbf9bcf5 in QueryMediator::OLAPExecutionPlan::execute(TRexAPI::TRexApiSearchTableResult&, TRexCommonObjects::TRexApiError&)+0x3b1 at PlanExecutor.h:61 (libhdbolap.so)

5: 0x00007fe2cbf6d453 in QueryMediator::QueryMediator::executePlan(QueryMediator::OLAPQuery const&, QueryMediator::OLAPExecutionPlan&, TRexAPI::TRexApiSearchTableResult&, TRexCommonObjects::TRexApiError&) const+0x120 at QueryMediator.cpp:887 (libhdbolap.so)

6: 0x00007fe2cbf72609 in QueryMediator::QueryMediator::executeQuery(QueryMediator::OLAPQuery const&, TRexAPI::TRexApiSearchTableResult&, TRexCommonObjects::TRexApiError&) const+0x265 at QueryMediator.cpp:966 (libhdbolap.so)

7: 0x00007fe2cb9bac36 in OlapEngine::OlapEngine::executeOLAPQuery(TRexAPI::TRexApiSearch const&, TRexAPI::TRexApiSearchTableResult&, TRexCommonObjects::TRexApiError&) const+0x72 at OlapEngine.cpp:61 (libhdbolap.so)

8: 0x00007fe2e832bbde in TRexAPI::TRexApiSearch::doSearch(TRexAPI::TRexApiSearchTableResult&)+0x531a at TRexApiSearch.cpp:6429 (libhdbcsapi.so)

9: 0x00007fe2e832f40d in TRexAPI::TRexApiSearch::search(TRexAPI::TRexApiSearchTableResult&)+0x59 at TRexApiSearch.cpp:5311 (libhdbcsapi.so)

10: 0x00007fe2ce1493c9 in ptime::TrexSearchBase::search(ptime::TrexResultWrapper&, int)+0xd25 at trex_query.cc:1226 (libhdbcswrapper.so)

11: 0x00007fe2cff27bab in ptime::Trex_search::do_open_trex(ptime::OperatorEnv&, ptime::TrexSearchWrapper*, ptime::TrexResultWrapper*) const+0xf7 at qe_trex_search.cc:112 (libhdbrskernel.so)

12: 0x00007fe2cff32bc4 in ptime::Trex_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x28d0 at qe_trex_search.cc:2904 (libhdbrskernel.so)

13: 0x00007fe2cfeb554c in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0xe8 at qe_table.cc:160 (libhdbrskernel.so)

14: 0x00007fe2cff75b15 in ptime::Itab_materializer::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x171 at qe_itab_materializer.cc:88 (libhdbrskernel.so)

15: 0x00007fe2cfeb554c in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0xe8 at qe_table.cc:160 (libhdbrskernel.so)

16: 0x00007fe2cff22923 in ptime::Trex_oltp_search::evaluateChildren(ptime::OperatorEnv&, TRexAPI::QueryRuntimeData&, ptime::QEParams) const+0x80 at qe_trex_search.cc:4033 (libhdbrskernel.so)

17: 0x00007fe2cff3504a in ptime::Trex_oltp_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x176 at qe_trex_search.cc:4345 (libhdbrskernel.so)

18: 0x00007fe2cfeb554c in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0xe8 at qe_table.cc:160 (libhdbrskernel.so)

19: 0x00007fe2cff75b15 in ptime::Itab_materializer::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x171 at qe_itab_materializer.cc:88 (libhdbrskernel.so)

20: 0x00007fe2cfeb554c in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0xe8 at qe_table.cc:160 (libhdbrskernel.so)

21: 0x00007fe2ce32ffb9 in ptime::TrexPlanOp::executePtimeOp(ltt_adp::vector<Executor::PlanData*, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<Executor::PlanData*, ltt::integral_constant<bool, true> > const&, TRexCommonObjects::TRexApiError&, Executor::ExecutionInfo const&)+0x2d5 at trex_plan.cc:398 (libhdbcswrapper.so)

22: 0x00007fe2ce330219 in ptime::TrexPlanOp::executePop(ltt_adp::vector<Executor::PlanData*, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<Executor::PlanData*, ltt::integral_constant<bool, true> > const&, TRexCommonObjects::TRexApiError&, Executor::ExecutionInfo const&)+0x25 at trex_plan.cc:256 (libhdbcswrapper.so)

23: 0x00007fe2eae979c8 in Executor::X2::runPopTask(Executor::X2::PopTaskInfo&, int&, ltt::allocator&, ltt::allocator&)+0x1364 at X2.cpp:2725 (libhdbexecutor.so)

24: 0x00007fe2eae993f1 in Executor::X2::runPopJob(Executor::X2Job*)+0x70 at X2.cpp:2339 (libhdbexecutor.so)

25: 0x00007fe2eae9e4b7 in Executor::X2Job::run(Execution::JobObject&)+0x1a3 at X2.cpp:4817 (libhdbexecutor.so)

26: 0x00007fe2cc83443e in Execution::JobObjectImpl::run(Execution::JobWorker*)+0xefa at JobExecutorImpl.cpp:1086 (libhdbbasis.so)

27: 0x00007fe2cc83f4a3 in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x390 at JobExecutorThreads.cpp:203 (libhdbbasis.so)

28: 0x00007fe2cc841aba in Execution::JobWorker::run(void*&)+0x1b6 at JobExecutorThreads.cpp:411 (libhdbbasis.so)

29: 0x00007fe2cc895b10 in Execution::Thread::staticMainImp(void**)+0x700 at Thread.cpp:461 (libhdbbasis.so)

30: 0x00007fe2cc8970e8 in Execution::Thread::staticMain(void*)+0x34 at ThreadMain.cpp:26 (libhdbbasis.so)

Top allocators (component, name, size). Ordered descending by inclusive_size_in_use.

1: System: / 129.47gb (139024492402b)

2: System: Pool 122.64gb (131685989913b)

3: Column Store Tables: Pool/ColumnStoreTables 48.81gb (52416912474b)

4: System: Pool/PersistenceManager 46.72gb (50174389420b)

5: Column Store Tables: Pool/ColumnStoreTables/Main 44.85gb (48164538690b)

6: System: Pool/PersistenceManager/PersistentSpace 40.12gb (43089914912b)

7: System: Pool/PersistenceManager/PersistentSpace/DefaultLPA 37.13gb (39875418720b)

8: System: Pool/PersistenceManager/PersistentSpace/DefaultLPA/Page 36.88gb (39606398976b)

9: Column Store Tables: Pool/ColumnStoreTables/Main/Dictionary 24.63gb (26449063054b)

10: Column Store Tables: Pool/ColumnStoreTables/Main/Dictionary/RoDict 23.52gb (25260531994b)

11: Row Store Tables: Pool/RowStoreTables 9.45gb (10155894784b)

12: Row Store Tables: Pool/RowStoreTables/CpbTree 8.73gb (9382248032b)

13: Column Store Tables: Pool/ColumnStoreTables/Main/Index 6.79gb (7299760156b)

14: System: AllocateOnlyAllocator-unlimited 5.91gb (6350790464b)

15: Column Store Tables: Pool/ColumnStoreTables/Main/Index/Single 5.63gb (6055360300b)

16: Column Store Tables: Pool/PersistenceManager/UnifiedTableContainer 5.45gb (5860451744b)

17: System: AllocateOnlyAllocator-unlimited/FLA-UL<3145728,1>/MemoryMapLevel2Blocks 5.41gb (5816451072b)

18: System: AllocateOnlyAllocator-unlimited/FLA-UL<3145728,1> 5.41gb (5816451072b)

19: Column Store Tables: Pool/ColumnStoreTables/Main/Uncompressed 4.74gb (5090043376b)

20: System: Pool/malloc 4.29gb (4613952351b)

Top allocators (component, name, size). Ordered descending by exclusive_size_in_use.

1: System: Pool/PersistenceManager/PersistentSpace/DefaultLPA/Page 36.88gb (39606398976b)

2: Column Store Tables: Pool/ColumnStoreTables/Main/Dictionary/RoDict 23.52gb (25260531994b)

3: Row Store Tables: Pool/RowStoreTables/CpbTree 8.73gb (9382248032b)

4: Column Store Tables: Pool/ColumnStoreTables/Main/Index/Single 5.63gb (6055360300b)

5: Column Store Tables: Pool/PersistenceManager/UnifiedTableContainer 5.45gb (5860451744b)

6: System: AllocateOnlyAllocator-unlimited/FLA-UL<3145728,1>/MemoryMapLevel2Blocks 5.41gb (5816451072b)

7: Column Store Tables: Pool/ColumnStoreTables/Main/Uncompressed 4.74gb (5090043376b)

8: Column Store Tables: Pool/ColumnStoreTables/Main/Rowid 4.21gb (4524904584b)

9: Monitoring & Statistical Data: Pool/Statistics 3.97gb (4269013920b)

10: Column Store Tables: Pool/ColumnStoreTables/Main/Compressed/Indirect 3.64gb (3909247280b)

11: System: Pool/PersistenceManager/PersistentSpace/RowStoreLPA 2.87gb (3085959712b)

12: Caches: Pool/RowEngine/SQLPlan 2.52gb (2716621076b)

13: Column Store Tables: Pool/ColumnStoreTables/Delta/LeafNodes 1.76gb (1893090912b)

14: Column Store Tables: Pool/ColumnStoreTables/Delta 1.39gb (1496455504b)

15: Column Store Tables: Pool/SerializedObject 1.37gb (1475231161b)

16: Column Store Tables: Pool/ColumnStoreTables/Main/Index/Block 1.15gb (1244399472b)

17: Column Store Tables: Pool/ColumnStoreTables/Main/Dictionary/ValueDict 1.10gb (1188530676b)

18: System: Pool/ResourceContainer 1.03gb (1107623640b)

19: Statement Execution & Intermediate Results: StackAllocator 936.14mb (981618688b)

20: Column Store Tables: Pool/malloc/libhdbcsstore.so 900.01mb (943734888b)

Memory consumption information:

[No information available.]

Top UnifiedTable allocators:

Top allocators (component, name, size). Ordered descending by inclusive_size_in_use.

1: Column Store Tables: UnifiedTableComposite 5.46gb (5869615648b)

2: Column Store Tables: UnifiedTableComposite/0xfe000d7e30 97.80mb (102559696b)

3: Column Store Tables: UnifiedTableComposite/0xfe000ea925 47.75mb (50074152b)

4: Column Store Tables: UnifiedTableComposite/0xfe000ea9ce 46.17mb (48415552b)

5: Column Store Tables: UnifiedTableComposite/0xfe000ea921 41mb (42995520b)

6: Column Store Tables: UnifiedTableComposite/0xfe000ea97f 30.13mb (31603008b)

7: Column Store Tables: UnifiedTableComposite/0xfe0011d470 29.09mb (30510544b)

8: Column Store Tables: UnifiedTableComposite/0xfe0011d427 28.82mb (30227776b)

9: Column Store Tables: UnifiedTableComposite/0xfe000ea9a1 26.36mb (27647816b)

10: Column Store Tables: UnifiedTableComposite/0xfe000ea983 24.60mb (25800368b)

11: Column Store Tables: UnifiedTableComposite/0xfe000ea9c2 21.48mb (22525840b)

12: Column Store Tables: UnifiedTableComposite/0xfe000ea9ad 20.82mb (21839984b)

13: Column Store Tables: UnifiedTableComposite/0xfe000ea7b9 19.30mb (20243360b)

14: Column Store Tables: UnifiedTableComposite/0xfe000ea94f 14.78mb (15504208b)

15: Column Store Tables: UnifiedTableComposite/0xfe0011d473 10.55mb (11068352b)

16: Column Store Tables: UnifiedTableComposite/0xfe0011d86d 10.54mb (11056368b)

17: Column Store Tables: UnifiedTableComposite/0xfe000ea958 9.49mb (9959536b)

18: Column Store Tables: UnifiedTableComposite/0xfe000ea736 6.06mb (6362608b)

19: Column Store Tables: UnifiedTableComposite/0xfe000ea735 5.97mb (6268176b)

20: Column Store Tables: UnifiedTableComposite/0xfe000ea4d8 5.60mb (5874976b)

Top allocators (component, name, size). Ordered descending by exclusive_size_in_use.

1: Column Store Tables: UnifiedTableComposite/0xfe000d7e30 97.80mb (102559696b)

2: Column Store Tables: UnifiedTableComposite/0xfe000ea925 47.75mb (50074152b)

3: Column Store Tables: UnifiedTableComposite/0xfe000ea9ce 46.17mb (48415552b)

4: Column Store Tables: UnifiedTableComposite/0xfe000ea921 41mb (42995520b)

5: Column Store Tables: UnifiedTableComposite/0xfe000ea97f 30.13mb (31603008b)

6: Column Store Tables: UnifiedTableComposite/0xfe0011d470 29.09mb (30510544b)

7: Column Store Tables: UnifiedTableComposite/0xfe0011d427 28.82mb (30227776b)

8: Column Store Tables: UnifiedTableComposite/0xfe000ea9a1 26.36mb (27647816b)

9: Column Store Tables: UnifiedTableComposite/0xfe000ea983 24.60mb (25800368b)

10: Column Store Tables: UnifiedTableComposite/0xfe000ea9c2 21.48mb (22525840b)

11: Column Store Tables: UnifiedTableComposite/0xfe000ea9ad 20.82mb (21839984b)

12: Column Store Tables: UnifiedTableComposite/0xfe000ea7b9 19.30mb (20243360b)

13: Column Store Tables: UnifiedTableComposite/0xfe000ea94f 14.78mb (15504208b)

14: Column Store Tables: UnifiedTableComposite/0xfe0011d473 10.55mb (11068352b)

15: Column Store Tables: UnifiedTableComposite/0xfe0011d86d 10.54mb (11056368b)

16: Column Store Tables: UnifiedTableComposite/0xfe000ea958 9.49mb (9959536b)

17: Column Store Tables: UnifiedTableComposite 8.73mb (9163904b)

18: Column Store Tables: UnifiedTableComposite/0xfe000ea736 6.06mb (6362608b)

19: Column Store Tables: UnifiedTableComposite/0xfe000ea735 5.97mb (6268176b)

20: Column Store Tables: UnifiedTableComposite/0xfe000ea4d8 5.60mb (5874976b)

Out of memory reasons:

!:! <1> 7x BigBlockAllocator failure, --- precharge ok ---.