DB Crash

Former Member · ‎04-15-2010

Hi Gurus,

I am writing to ask you for advice.

Everyday my MaxDB suddenly crashes without any aparent reason. When it crashes I open the dbmcli write the command db_online, my DB gets online again and I continue working without any problem.

But the thing is, that the following day, it does exactly the same.

So, reading the DB logs I found some lines that caught my attention and that's why I am posting them in order to see if you give me some light on this.

Before this piece of log, everything seems to be fine, and after this piece, I have DB Crash messages and after them I have DB Restart Requierd messages.

In advance, thanks for any support.

PIECE OF LOG

#1.5 #005056850CF1005D0000002400000B400004844BA45D0C49#1271360365073#/Applications/CC#sap.com/tc_wddispwda#com.virsa.cc.common.util.CCLogger#Guest#0##lince_GRP_1541350#Guest#49bf64ce48c411dfab31005056850cf1#SAPEngine_Application_Thread[impl:3]_20##0#0#Error#1#com.virsa.cc.common.util.CCLogger#Plain#[-9402]: System error: AK Unexpected strategy informationcom.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:65)

com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:1061)

com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:689)

com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:563)

com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:855)

com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:919)

com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:266)

com.sap.dbtech.jdbc.StatementSapDB.executeQuery(StatementSapDB.java:420)

com.sap.dbtech.jdbc.trace.Statement.executeQuery(Statement.java:131)

com.sap.sql.jdbc.direct.DirectStatement.executeQuery(DirectStatement.java:142)

com.sap.sql.jdbc.common.CommonStatementImpl.executeQuery(CommonStatementImpl.java:363)

com.sap.sql.jdbc.common.CommonStatementImpl.executeQuery(CommonStatementImpl.java:119)

com.sap.engine.services.dbpool.wrappers.StatementWrapper.executeQuery(StatementWrapper.java:172)

com.virsa.cc.xsys.util.RuleLoader.getActRuleMatrix(RuleLoader.java:431)

com.virsa.cc.xsys.util.RuleLoader.getActionRules(RuleLoader.java:102)

com.virsa.cc.xsys.riskanalysis.AnalysisEngine.performConfActAnalysisForAlert(AnalysisEngine.java:5005)

com.virsa.cc.xsys.riskanalysis.AnalysisEngine.performConfActAnalysisForAlert(AnalysisEngine.java:5020)

com.virsa.cc.comp.BackendAccessInterface.alertGenerate(BackendAccessInterface.java:2261)

com.virsa.cc.comp.wdp.InternalBackendAccessInterface.alertGenerate(InternalBackendAccessInterface.java:4355)

com.virsa.cc.comp.wdp.InternalBackendAccessInterface$External.alertGenerate(InternalBackendAccessInterface.java:4824)

com.virsa.cc.xsys.bg.BgJob.alertGen(BgJob.java:1078)

com.virsa.cc.xsys.bg.BgJob.runJob(BgJob.java:510)

com.virsa.cc.xsys.bg.BgJob.run(BgJob.java:284)

com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.scheduleJob(AnalysisDaemonBgJob.java:249)

com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.start(AnalysisDaemonBgJob.java:81)

com.virsa.cc.comp.BgJobInvokerView.wdDoModifyView(BgJobInvokerView.java:444)

com.virsa.cc.comp.wdp.InternalBgJobInvokerView.wdDoModifyView(InternalBgJobInvokerView.java:1236)

com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doModifyView(DelegatingView.java:78)

com.sap.tc.webdynpro.progmodel.view.View.modifyView(View.java:337)

com.sap.tc.webdynpro.clientserver.cal.ClientComponent.doModifyView(ClientComponent.java:481)

com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doModifyView(WindowPhaseModel.java:551)

com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:148)

com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:332)

com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741)

com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694)

com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)

com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:46)

javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

java.security.AccessController.doPrivileged(Native Method)

com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

###

#1.5 #005056850CF1005D0000002600000B400004844BA462A332#1271360365526#/Applications/CC#sap.com/tc_wddispwda#com.virsa.cc.common.util.CCLogger#Guest#0##lince_GRP_1541350#Guest#49bf64ce48c411dfab31005056850cf1#SAPEngine_Application_Thread[impl:3]_20##0#0#Info#1#com.virsa.cc.common.util.CCLogger#Plain#No of Systems=1###

#1.5 #005056850CF1005D0000002700000B400004844BA474C4DF#1271360366963#/Applications/CC#sap.com/tc_wddispwda#com.virsa.cc.common.util.CCLogger#Guest#0##lince_GRP_1541350#Guest#49bf64ce48c411dfab31005056850cf1#SAPEngine_Application_Thread[impl:3]_20##0#0#Info#1#com.virsa.cc.common.util.CCLogger#Plain#Action rules cache loaded: memory used in cache=-17M, free=694M, total=1962M###

#1.5 #005056850CF1005D0000002800000B400004844BA4A3B67B#1271360370713#/Applications/CC#sap.com/tc_wddispwda#com.virsa.cc.common.util.CCLogger#Guest#0##lince_GRP_1541350#Guest#49bf64ce48c411dfab31005056850cf1#SAPEngine_Application_Thread[impl:3]_20##0#0#Info#1#com.virsa.cc.common.util.CCLogger#Plain#No of Systems=1###

#1.5 #005056850CF1005D0000002B00000B400004844BA4A766ED#1271360371010#/Applications/CC#sap.com/tc_wddispwda#com.virsa.cc.common.util.CCLogger#Guest#0##lince_GRP_1541350#Guest#49bf64ce48c411dfab31005056850cf1#SAPEngine_Application_Thread[impl:3]_20##0#0#Error#1#com.virsa.cc.common.util.CCLogger#Plain#SQL statement is too long. Increase the DB parameter PACKET_SIZE.com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:941)