Symptom
When checking the Alerts tab in HANA Studio or Solution Manager,
there is an alert called “Param lock_wait_timeout in indexserver.ini
section transaction is set to value: 1”
- For HANA Studio, you would find the alert by going to Administration
Console -> Alerts -> Show: all alerts -> Filter input ‘lock’.
- For Solution Manager, you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts.
Remember for this “Check lock waittimeout” alert in Solution Manager, it is auto-refreshed every 15 minutes, so the time stamp on the alert may be not the exact time when the alert occurs.
To check the exact time, please go to
Administration Console -> Alerts -> double click on the
alerts -> more occurrence for this alert.
Environment
All tests are performed on HANA 1.0 revision 41 and BW on HANA NW7.3 SP8
Cause
Normally this alert occurs for the following reason:
The lock_wait_timeout value in "indexserver.ini" is too small, The value should be set between 100000 and 7200000.
The lock_wait_timeout value in "indexserver.ini" is too small, The value should be set between 100000 and 7200000.
Resolution
If the alert has been triggered due to an improper setting of
parameter ‘lock_wait_timeout’ value , it can be resolved by resetting
the same to its default value. In order to do so go to:
Administration Console -> Configuration -> indexserver.ini -> transaction -> lock_wait_timeout.
Administration Console -> Configuration -> indexserver.ini -> transaction -> lock_wait_timeout.
See Also
- Are there any Functional Constraints?
- Parameter ‘lock_wait_timeout’ limits how long time current transaction will wait for other transactions to release locked tables, so if its value is very small, then when you run transactions in parallel, errors like “transaction rolled back by lock wait timeout” often occurs. For more details please refer to developer.
- Are there any Non-functional Constraints?
- It is related to HANA DB working principle, the developer could explain it more detailed.
- Are there any side-effects?
- Lots of errors will seriously influence the users’ experience. For more details please refer to developer.
- Is there any suggestion to avoid this alert?
- For reason 1, a more reasonable value could avoid this alert.
Keywords
Operations Recommendation, #OpsRec-HANA
Header Data
| Released On | 29.10.2014 07:21:42 | ||
| Release Status | Released to Customer | ||
| Component | SV-BO-DB-HAN Backoffice Service Delivery - DB/HANA Performance | ||
| Priority | Normal | ||
| Category | Problem | ||
| Database |
|
No comments:
Post a Comment