[MCOL-394] Document that a node will auto-restart when it is using too much swap Created: 2016-11-08  Updated: 2023-10-26  Resolved: 2017-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?, Documentation
Affects Version/s: 1.0.4
Fix Version/s: Icebox

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: David Hill (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

When an InfiniDB server uses more than 80% of its available swap, the server auto-restarts to prevent the server from locking up due to excessive swapping. I believe that MariaDB Columnstore also behaves the same way. If so, this behavior should probably be documented.

Here is an error log showing an example of this behavior:

Nov 01 11:21:03 [ServerMonitor] 03.469313 |0|0|0| I 09 CAL0000: Swap above Minor Memory threshold with a percentage of 79
 
Nov 01 11:21:04 [ServerMonitor] 04.639494 |0|0|0| I 09 CAL0000: Swap usage at percentage of 79 , Alarm set: 12
 
Nov 01 11:22:07 [ServerMonitor] 07.671901 |0|0|0| I 09 CAL0000: Swap above Minor Memory threshold with a percentage of 79
 
Nov 01 11:22:08 [ServerMonitor] 08.938831 |0|0|0| I 09 CAL0000: Swap usage at percentage of 79 , Alarm set: 12
 
Nov 01 11:23:11 [ServerMonitor] 11.957031 |0|0|0| I 09 CAL0000: Swap above Major Memory threshold with a percentage of 80
 
Nov 01 11:23:13 [ServerMonitor] 13.293215 |0|0|0| I 09 CAL0000: Swap usage at percentage of 80 , Alarm set: 11
 
Nov 01 11:23:13 [ServerMonitor] 13.306324 |0|0|0| C 09 CAL0000: Swap Space usage over Major threashold, perform OAM command restartSystem
 
Nov 01 11:23:13 [ProcessManager] 13.475097 |0|0|0| I 17 CAL0000: MSG RECEIVED: Restart System request...
 
Nov 01 11:23:13 [ProcessMonitor] 13.565122 |0|0|0| I 18 CAL0000: MSG RECEIVED: Stop All process request...
 
Nov 01 11:23:13 [ProcessMonitor] 13.591417 |0|0|0| I 18 CAL0000: STOPALL: ACK back to ProcMgr, STATUS_UPDATE only performed
 
Nov 01 11:23:14 [ProcessMonitor] 14.593576 |0|0|0| I 18 CAL0000: MSG RECEIVED: Stop All process request...



 Comments   
Comment by David Thompson (Inactive) [ 2016-12-01 ]

This has been added here: https://mariadb.com/kb/en/mariadb/columnstore-system-monitoring-configuration/#automated-restart-based-on-excessive-swapping

Comment by David Thompson (Inactive) [ 2016-12-01 ]

Can you double check the doc, it's based on the support ticket and this.

Generated at Thu Feb 08 02:20:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.