My MSsql database is getting heavy load on CPU !
Hi !
Since october 1st i my MSsqldatabase went from 10-20% CPU load to constant 75% Cpuload. It also started to put out loads of log files. Her is what comes in the log file over and over again. As far as i can udnerstand it is something with the date. Can somone please help me what to do ? I am on a trial license but i stil have like 35 days left on it.
[11:34:41:912]|[10-04-2007]|[com.adventnet.workengine.scheduler.internal.RefreshController]|[SEVERE]|[16]|: |com.adventnet.persistence.DataAccessException: java.sql.SQLException: Syntax error converting datetime from character string.
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:102)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1153)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1143)
at com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:110)
at com.adventnet.persistence.ejb.interceptor.CacheInterceptor.process(CacheInterceptor.java:72)
at com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
at com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
at com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
at com.adventnet.persistence.ejb.PersistenceBean.get(PersistenceBean.java:259)
at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy65.get(Unknown Source)
at com.adventnet.workengine.scheduler.internal.RefreshController.bulkRefresh(RefreshController.java:142)
at com.adventnet.workengine.scheduler.internal.RefreshController.refreshAll(RefreshController.java:103)
at com.adventnet.workengine.scheduler.internal.RefreshController.run(RefreshController.java:66)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Syntax error converting datetime from character string.
at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1042)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:182)
at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:751)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89)
... 44 more
Caused by: java.sql.SQLException: Syntax error converting datetime from character string.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:250)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:174)
... 46 more
Thanks in advance !
Mattias
Since october 1st i my MSsqldatabase went from 10-20% CPU load to constant 75% Cpuload. It also started to put out loads of log files. Her is what comes in the log file over and over again. As far as i can udnerstand it is something with the date. Can somone please help me what to do ? I am on a trial license but i stil have like 35 days left on it.
[11:34:41:912]|[10-04-2007]|[com.adventnet.workengine.scheduler.internal.RefreshController]|[SEVERE]|[16]|: |com.adventnet.persistence.DataAccessException: java.sql.SQLException: Syntax error converting datetime from character string.
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:102)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1153)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1143)
at com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:110)
at com.adventnet.persistence.ejb.interceptor.CacheInterceptor.process(CacheInterceptor.java:72)
at com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
at com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
at com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
at com.adventnet.persistence.ejb.PersistenceBean.get(PersistenceBean.java:259)
at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy65.get(Unknown Source)
at com.adventnet.workengine.scheduler.internal.RefreshController.bulkRefresh(RefreshController.java:142)
at com.adventnet.workengine.scheduler.internal.RefreshController.refreshAll(RefreshController.java:103)
at com.adventnet.workengine.scheduler.internal.RefreshController.run(RefreshController.java:66)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Syntax error converting datetime from character string.
at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1042)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:182)
at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:751)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89)
... 44 more
Caused by: java.sql.SQLException: Syntax error converting datetime from character string.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:250)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:174)
... 46 more
Thanks in advance !
Mattias