Which indications exist for SAP HANA memory problems?
May I Know the existence of indication for SAP HANA memory problems?
Comments
28 Jan 2015 6:24 pm Shalesh Singh Helpful Answer
The following error messages can indicate OOM situations. Be aware that some of the errors can also be issued in other scenarios. To make sure that they are really memory related, you have to check the related trace file.
SQL error -10108: Session has been reconnected
SQL error 129 while accessing table
transaction rolled back by an internal error: exception during deltalog replay.
transaction rolled back by an internal error: TableUpdate failed
transaction rolled back by an internal error: exception
The following error messages can indicate OOM situations. Be aware that some of the errors can also be issued in other scenarios. To make sure that they are really memory related, you have to check the related trace file.
SQL error -10108: Session has been reconnected
SQL error 129 while accessing table
transaction rolled back by an internal error: exception during deltalog replay.
transaction rolled back by an internal error: TableUpdate failed
transaction rolled back by an internal error: exception
1000002: Allocation failed ; $size$=1191936; $name$=TableUpdate; $type$=pool;
$inuse_count$=2180; $allocated_size$=8180736; $alignment$=16#
transaction rolled back by an internal error: TrexUpdate
failed on table with error:
commitOptimizeAttributes() failed with rc=6900, Attribute engine
failed;object=$delta_1$en, rc=6900 - enforce TX rollback
transaction rolled back by an internal error: TrexUpdate
failed on table '' with error: Attribute load
failed;index=en,attribute='$trexexternalkey$' (207), rc=6923 - enforce TX rollback
transaction rolled back by an internal error: TrexUpdate
failed on table '' with error: AttributeEngine: not enough
memory, rc=6952 - enforce TX rollback
SQL error 403 while accessing table
internal error: ""."": [133] (range 2)
SQL error 2048 while accessing table
column store error: search table error: [9] Memory allocation failed
column store error: search table error: [1999] general error (no further information available)
column store error: search table error: [2575] flatten scenario failed; Allocation failed
column store error: search table error: [6900] Attribute engine failed
column store error: search table error: [6923] Attribute load failed
column store error: search table error: [6952] Error during optimizer search
column store error: search table error: [6952] AttributeEngine: not enough memory
SQL error 3584 while accessing table
distributed SQL error: [9] Memory allocation failed
distributed SQL error: [2617] executor: plan operation execution failed with an exception
SQL error 3587 at CON
invalid protocol or service shutdown during distributed query execution:
[2613] executor: communication problem