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:

1. Is the drive full
2. Do you see many log files for mariadB or MySQL
   1. If so then proceed on delete the oldest to the newest date and the onse with a .gz extention
      1. Then investigate the growing log to figure out what is adding to the logs
   2. If not then go to step one below

Steps:

1. Stop all xmgenmenu links
2. Stop any other services running on the linux server
   1. For example PrePrint service (kprt-service.sh -stop)
   2. Check to see all have been stopped by running "ps -ef | grep xmgen"
   3. If any are still running use "kill -9 (id)"
3. Turn off Java Services in $VBIN
   1. ./stopservers.sh
4. Go to ESP and turn off agents for that plant
5. Once everything is down, then get into root (sudo su)
   1. "systemctl stop mariadb"
   2. cd /var/log/mariadb/
   3. Verify the mariadb.log file is no longer growing (couple ls -lart)
   4. rm mariadb.log … "yes"
   5. "systemctl restart mariadb"
   6. Then turn on all xmgenmenu links
      1. followed by any plant specific service like PrePrint (kprt-service.sh -start)
6. Turn on Java services
7. Go back into ESP and start Agents for that plant