#62 Log information missing in database

[David Suendermann-Oeft]

There seems to be information available in log files which is missing in the database, haleflogs table. For example, below are log snippets taken from Ticket https://sourceforge.net/p/halef/tickets/39, which belong to callId fdf179e7831442ea8ca347b68c63c3bd@141.31.8.62 (JVXML Session ID 2055fc8a-c35d-4eae-a848-b71e89f0343b), see view callsExt. However, neither the mentioning of the "NullPointerException" nor that of "NoresourceError"/"Pool exhausted" made it into the database.

Exception in thread "RTPEventHandler" java.lang.NullPointerException
at org.speechforge.cairo.rtp.server.RTPStreamReplicator.streamInactive(RTPStreamReplicator.java:160)
at org.speechforge.cairo.rtp.RTPConsumer.update(RTPConsumer.java:265)
at com.sun.media.rtp.RTPEventHandler.processEvent(RTPEventHandler.java:62)
at com.sun.media.rtp.RTPEventHandler.dispatchEvents(RTPEventHandler.java:96)
at com.sun.media.rtp.RTPEventHandler.run(RTPEventHandler.java:115)

JVXML says
[java] 2015-06-24 02:11:36,081 ERROR interpreter.JVoiceXmlSession [2055fc8a-c35d-4eae-a848-b71e89f0343b]: error processing application 'Unknown application'
[java] org.jvoicexml.event.error.NoresourceError: error.noresource: Pool exhausted
[java] at org.jvoicexml.implementation.pool.KeyedResourcePool.borrowObject(KeyedResourcePool.java:119) ~[classes/:?]
[java] at org.jvoicexml.implementation.jvxml.JVoiceXmlImplementationPlatform.getExternalResourceFromPool(JVoiceXmlImplementationPlatform.java:774) ~[classes/:?]
[java] at org.jvoicexml.implementation.jvxml.JVoiceXmlImplementationPlatform.getSystemOutput(JVoiceXmlImplementationPlatform.java:298) ~[classes/:?]
[java] at org.jvoicexml.implementation.jvxml.JVoiceXmlPromptAccumulator.renderPrompts(JVoiceXmlPromptAccumulator.java:123) ~[classes/:?]
[java] at org.jvoicexml.implementation.jvxml.JVoiceXmlImplementationPlatform.renderPrompts(JVoiceXmlImplementationPlatform.java:1111) ~[classes/:?]
[java] at org.jvoicexml.interpreter.FormInterpretationAlgorithm.queuePrompts(FormInterpretationAlgorithm.java:807) ~[classes/:?]
[java] at org.jvoicexml.interpreter.FormInterpretationAlgorithm.collect(FormInterpretationAlgorithm.java:620) ~[classes/:?]
[java] at org.jvoicexml.interpreter.FormInterpretationAlgorithm.mainLoop(FormInterpretationAlgorithm.java:432) ~[classes/:?]
[java] at org.jvoicexml.interpreter.VoiceXmlInterpreter.process(VoiceXmlInterpreter.java:272) ~[classes/:?]
[java] at org.jvoicexml.interpreter.VoiceXmlInterpreterContext.interpret(VoiceXmlInterpreterContext.java:798) ~[classes/:?]
[java] at org.jvoicexml.interpreter.VoiceXmlInterpreterContext.process(VoiceXmlInterpreterContext.java:484) ~[classes/:?]
[java] at org.jvoicexml.interpreter.JVoiceXmlSession.run(JVoiceXmlSession.java:328) [classes/:?]
[java] Caused by: java.util.NoSuchElementException: Pool exhausted
[java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1110) ~[commons-pool-1.6.jar:1.6]
[java] at org.jvoicexml.implementation.pool.KeyedResourcePool.borrowObject(KeyedResourcePool.java:117) ~[classes/:?]
[java] ... 11 more

[Patrick L. Lange]

Oh yes. Exceptions might not be logged, good point. I will have a look at the issue.

[Patrick L. Lange]

Changed in log4j2.xml the line
<column name="message" pattern="%message"></column>

to
<column name="message" pattern="%message%exception"></column>

Please check if this solved the problem of missing exceptions.

[David Suendermann-Oeft]

Dear Patrick,

There is still information missing in the database which is available in Cairo logs: For example, on Line 152984 of nohup.out on TJR215, there is the exception

javax.websocket.DeploymentException: Connection failed

which is not written into the DB. Please take a look at your earliest convenience, since this is important to extract bug statististics (in this case the fact whether Kaldi is down).

Yours,

DSO

[Patrick L. Lange]

See ticket 86