msql deamon dies and unable to log in
twice in last two weeks the msql demon dies and we are unble to loginto the system. The fix has been to restart the application . please can you advise what is causing ths.
extract on errror file below
AMRCAnalyser.java:197)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:88)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:83)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:77)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.applyThreshold(UrlSequence.java:198)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:139)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
08:43:33:682 AM at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
08:43:33:683 AM java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: Broken pipe
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:109)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1755)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1720)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1141)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1271)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2240)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1765)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1612)
at com.adventnet.appmanager.server.dao.BaseDao.databaseUpdate(BaseDao.java:17)
at com.adventnet.appmanager.server.dao.UrlDataDao.create(UrlDataDao.java:114)
at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:143)
at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
** END NESTED EXCEPTION **
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1778)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1720)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1141)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1271)
08:43:33:683 AM at com.mysql.jdbc.Connection.execSQL(Connection.java:2240)
08:43:33:683 AM at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1765)
08:43:33:683 AM at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1612)
08:43:33:683 AM at com.adventnet.appmanager.server.dao.BaseDao.databaseUpdate(BaseDao.java:17)
08:43:33:683 AM at com.adventnet.appmanager.server.dao.UrlDataDao.create(UrlDataDao.java:114)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:143)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
08:43:33:683 AM at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
08:43:47:347 AM LogFileWriter: error opening nmserr939.txt:java.io.FileNotFoundException: /opt/AdventNet/ME/AppManager6/working/../logs/nms/nmserr939.txt (No such file or directory)
08:43:47:348 AM java.io.FileNotFoundException: /opt/AdventNet/ME/AppManager6/working/../logs/nms/nmserr939.txt (No such file or directory)
08:43:47:348 AM at java.io.FileOutputStream.open(Native Method)
08:43:47:348 AM at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
08:43:47:348 AM at java.io.FileOutputStream.<init>(FileOutputStream.java:70)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.createFileWriter(LogFileWriter.java:412)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.changeFile(LogFileWriter.java:455)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.log(LogFileWriter.java:313)
08:43:47:348 AM at com.adventnet.management.log.LogUser.log(LogUser.java:79)
08:43:47:348 AM at com.adventnet.management.log.LogUser.fail(LogUser.java:126)
08:43:47:348 AM at com.adventnet.nms.poll.NameScheduler.getTheWork(NameScheduler.java:336)
08:43:47:348 AM at com.adventnet.management.scheduler.Scheduler.run(Scheduler.java:794)
extract on errror file below
AMRCAnalyser.java:197)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:88)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:83)
08:43:33:682 AM at com.adventnet.appmanager.fault.AMRCAnalyser.applyRCA(AMRCAnalyser.java:77)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.applyThreshold(UrlSequence.java:198)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:139)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
08:43:33:682 AM at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
08:43:33:682 AM at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
08:43:33:683 AM java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: Broken pipe
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:109)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1755)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1720)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1141)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1271)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2240)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1765)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1612)
at com.adventnet.appmanager.server.dao.BaseDao.databaseUpdate(BaseDao.java:17)
at com.adventnet.appmanager.server.dao.UrlDataDao.create(UrlDataDao.java:114)
at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:143)
at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
** END NESTED EXCEPTION **
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1778)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1720)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1141)
08:43:33:683 AM at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1271)
08:43:33:683 AM at com.mysql.jdbc.Connection.execSQL(Connection.java:2240)
08:43:33:683 AM at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1765)
08:43:33:683 AM at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1612)
08:43:33:683 AM at com.adventnet.appmanager.server.dao.BaseDao.databaseUpdate(BaseDao.java:17)
08:43:33:683 AM at com.adventnet.appmanager.server.dao.UrlDataDao.create(UrlDataDao.java:114)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:143)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlSequence.collectStatistics(UrlSequence.java:84)
08:43:33:683 AM at com.adventnet.appmanager.server.framework.datacollection.UrlMonitor.run(UrlMonitor.java:85)
08:43:33:683 AM at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:66)
08:43:47:347 AM LogFileWriter: error opening nmserr939.txt:java.io.FileNotFoundException: /opt/AdventNet/ME/AppManager6/working/../logs/nms/nmserr939.txt (No such file or directory)
08:43:47:348 AM java.io.FileNotFoundException: /opt/AdventNet/ME/AppManager6/working/../logs/nms/nmserr939.txt (No such file or directory)
08:43:47:348 AM at java.io.FileOutputStream.open(Native Method)
08:43:47:348 AM at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
08:43:47:348 AM at java.io.FileOutputStream.<init>(FileOutputStream.java:70)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.createFileWriter(LogFileWriter.java:412)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.changeFile(LogFileWriter.java:455)
08:43:47:348 AM at com.adventnet.management.log.LogFileWriter.log(LogFileWriter.java:313)
08:43:47:348 AM at com.adventnet.management.log.LogUser.log(LogUser.java:79)
08:43:47:348 AM at com.adventnet.management.log.LogUser.fail(LogUser.java:126)
08:43:47:348 AM at com.adventnet.nms.poll.NameScheduler.getTheWork(NameScheduler.java:336)
08:43:47:348 AM at com.adventnet.management.scheduler.Scheduler.run(Scheduler.java:794)