Kiwiplan - MySQL log is fill or filled the drive

This document is to explain the procedure on how to get the plant operational again. 

 Couple of things to think about: 

 

 Is the drive full 

 Do you see many log files for mariadB or MySQL

 

 If so then proceed on delete the oldest to the newest date and the onse with a .gz extention

 

 Then investigate the growing log to figure out what is adding to the logs 

 

 

 If not then go to step one below 

 

 

 

 Steps: 

 

 Stop all xmgenmenu links 

 Stop any other services running on the linux server

 

 For example PrePrint service (kprt-service.sh -stop) 

 Check to see all have been stopped by running "ps -ef | grep xmgen" 

 If any are still running use "kill -9 (id)" 

 

 

 Turn off Java Services in $VBIN

 

 ./stopservers.sh 

 

 

 Go to ESP and turn off agents for that plant 

 Once everything is down, then get into root (sudo su)

 

 "systemctl stop mariadb" 

 cd /var/log/mariadb/ 

 Verify the mariadb.log file is no longer growing (couple ls -lart) 

 rm mariadb.log … "yes" 

 "systemctl restart mariadb" 

 Then turn on all xmgenmenu links

 

 followed by any plant specific service like PrePrint (kprt-service.sh -start) 

 

 

 

 

 Turn on Java services 

 Go back into ESP and start Agents for that plant