Applicable scenario
-log time to Unix time
sample log:
2017-03-21 00:00:00,291 INFO [dubboserverhandler-10.135.6.53:20885-thread-98] I.w.w.r.m.requirementmanager [ REQUIREMENTMANAGER.JAVA:860] Fetch no data from Oracle 2017-03-21 00:00:00,294 INFO [DubboServerHandler-10.135.6.53 : 20885-thread-98] i.w.w.r.m.requirementmanager [requirementmanager.java:1549] begin fetch data from Oracle 2017-03-21 00:00:00,301 ERROR [dubboserverhandler-10.135.6.53:20885-thread-98] I.w.w.h.d.testdao [testDao.java:265] Find test Project failed, error code={} java.sql.sqlexception:ora-00942:table or view does not exist at ORACLE.JDBC.DRIVER.D Atabaseerror.throwsqlexception (databaseerror.java:112) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-" 10.2.0.1.0XE "] at Oracle.jdbc.driver.T4CTTIoer.processError (t4cttioer.java:331) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver Version-"10.2.0.1.0XE"] at Oracle.jdbc.driver.T4CTTIoer.processError (t4cttioer.java:288) ~[ojdbc14-10.2 .0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at ORACLE.JDBC.Driver. T4c8oall.receive (t4c8oall.java:743) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at ORACLE.JD Bc.driver.T4CPreparedStatement.doOall8 (t4cpreparedstatement.java:216) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver Version-"10.2.0.1.0XE"] at Oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe (T4cpreparedstatement.java : 799) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at Oracle.jdbc.driver.OracleStatement.exec Utemaybedescribe (oraclestatement.java:1038) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at O Racle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (t4cpreparedstatement.java:839) ~[ Ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver Version-"10.2.0.1.0XE"] at Oracle.jdbc.driver.OracleStatement.doExecuteWi Thtimeout (oraclestatement.java:1133) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at ORACLE.J Dbc.driver.OraclePreparedStatement.executeInternal (Oraclepreparedstatement.java:3285) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at Oracle.jdbc.driver. Oraclepreparedstatement.executequery (oraclepreparedstatement.java:3329) ~[ojdbc14-10.2.0.1.0.jar:oracle JDBC Driver version-"10.2.0.1.0XE"] at Org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery ( delegatingpreparedstatement.java:96) ~[commons-dbcp-1.4.jar:1.4] at Org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (delegatingpreparedstatement.java:96) ~[ commons-dbcp-1.4.jar:1.4] at Io.jiankunking.demo.haier.dao.testDao.findBigResourceMaterialByStatus (Testdao.java : 252) ~[demo-requirement-1.0-snapshot.jar:na] at Io.jiankunking.demo.requirement.manager.RequirementManager.findBigResourceMaterialByStatus ( REQUIREMENTMANAGER.JAVA:1550) [Demo-requirement-1.0-snapshot.jar:na] at io.jiankunking.demo.requirement.manager.requirementmanager$ $FastClassByCGLIB $ $b 97dbf5c.invoke (<generated >) [Spring-core-3.2.6.release.jar:na] AT Org.springframework.cglib.proxy.MethodProxy.invoke (methodproxy.java:204) [spring-core-3.2.6.release.jar:3.2.6. RELEASE] at Org.springframework.aop.framework.cglibaopproxy$cglibmethodinvocation.invokejoinpoint ( cglibaopproxy.java:701) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:150) [ Spring-aop-3.2.6.release.jar:3.2.6.release] At Org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation ( TRANSACTIONINTERCEPTOR.JAVA:96) [Spring-tx-3.2.6.release.jar:3.2.6.release] at Org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction ( transactionaspectsupport.java:260) [Spring-tx-3.2.6.release.jar:3.2.6.release] at Org.springframework.transaction.interceptor.TransactionInterceptor.invoke (transactioninterceptor.java:94) [ Spring-tx-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiVemethodinvocation.proceed (reflectivemethodinvocation.java:172) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept (CglibAopProxy.java:634) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at io.jiankunking.demo.requirement.manager.requirementmanager$$
enhancerbycglib$ $de 554283.findBigResourceMaterialByStatus (<generated>) [Spring-core-3.2.6.release.jar:na] At Io.jiankunking.demo.requirement.service.RequirementServiceImpl.fetchBigResourceMaterial ( requirementserviceimpl.java:4791) [Demo-requirement-1.0-snapshot.jar:na] at io.jiankunking.demo.requirement.service.requirementserviceimpl$ $FastClassByCGLIB $$15e55a9c.invoke (< generated>) [Spring-core-3.2.6.release.jar:na] at Org.springframework.cglib.proxy.MethodProxy.invoke ( methodproxy.java:204) [Spring-core-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.cglibaopproxy$cglibmethodinvocation.invokejoinpoint (CglibAopproxy.java:701) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:150) [ Spring-aop-3.2.6.release.jar:3.2.6.release] At Org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke ( METHODBEFOREADVICEINTERCEPTOR.JAVA:51) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] At Org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke ( METHODBEFOREADVICEINTERCEPTOR.JAVA:51) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke (aspectjafterthrowingadvice.java:55) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed ( reflectivemethodinvocation.java:172) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke (aspectjafterthrowingadvice.java:55) [ Spring-aop-3.2.6.release.jar:3.2.6.release] At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.aspectj.AspectJAfterAdvice.invoke ( ASPECTJAFTERADVICE.JAVA:42) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.aspectj.AspectJAfterAdvice.invoke ( ASPECTJAFTERADVICE.JAVA:42) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocatiOn.proceed (reflectivemethodinvocation.java:172) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke ( METHODBEFOREADVICEINTERCEPTOR.JAVA:51) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.aspectj.AspectJAfterAdvice.invoke ( ASPECTJAFTERADVICE.JAVA:42) [Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:172) [ Spring-aop-3.2.6.release.jar:3.2.6.release] At Org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke (exposeinvocationinterceptor.java:91) [ Spring-aop-3.2.6.release.jar:3.2.6.release] at Org.springframework