"Error while receiving status info / getting policy package" in fspms-webapp-errors.log

Scholar

"Error while receiving status info / getting policy package" in fspms-webapp-errors.log

Hi there,

 

On and off, I got the captioned errors on my FSPM 11 server. Any idea? The server seems running well. Client can get policy and sig update.

 

Rgds.

Martin

=========================================================

06.11.2013 21:54:55,842 ERROR [com.fsecure.fspms.policy.PolicyFileDownloadHandler] - Error while getting policy package
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id, parent_path FROM domain_tree WHERE host_identity=? AND parent_path IS NOT NULL]; Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? AND parent_path IS NOT NULL [50200-164]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? AND parent_path IS NOT NULL [50200-164]
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:265)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:731)
    at org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:759)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.queryDomainAndParentIdByIdentity(AbstractHostPackageRequestHandler.java:86)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.findDomainAndParentIdsByIdentities(AbstractHostPackageRequestHandler.java:66)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.findDomainIdByIdentities(AbstractHostPackageRequestHandler.java:56)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.findExistingDomainIdByIdentities(AbstractHostPackageRequestHandler.java:48)
    at com.fsecure.fspms.policy.PolicyFileDownloadHandler.access$200(PolicyFileDownloadHandler.java:41)
    at com.fsecure.fspms.policy.PolicyFileDownloadHandler$3.doInTransaction(PolicyFileDownloadHandler.java:161)
    at com.fsecure.fspms.policy.PolicyFileDownloadHandler$3.doInTransaction(PolicyFileDownloadHandler.java:155)
    at com.fsecure.commons.java.spring.transaction.LoggingTransactionCallback.doInTransaction(LoggingTransactionCallback.java:37)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
    at com.fsecure.fspms.policy.PolicyFileDownloadHandler.getPackage(PolicyFileDownloadHandler.java:153)
    at com.fsecure.fspms.hostmodule.HostInterfaceHandler.downloadPolicyFile(HostInterfaceHandler.java:262)
    at com.fsecure.fspms.hostmodule.HostInterfaceHandler.handleRequest(HostInterfaceHandler.java:122)
    at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:516)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:305)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at com.fsecure.fspms.jetty.SingleConnectorHandler.handle(SingleConnectorHandler.java:35)
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:151)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at org.eclipse.jetty.server.Server.handle(Server.java:352)
    at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596)
    at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1051)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:590)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212)
    at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? AND parent_path IS NOT NULL [50200-164]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:169)
    at org.h2.message.DbException.get(DbException.java:146)
    at org.h2.table.RegularTable.doLock(RegularTable.java:500)
    at org.h2.table.RegularTable.lock(RegularTable.java:434)
    at org.h2.table.TableFilter.lock(TableFilter.java:143)
    at org.h2.command.dml.Select.queryWithoutCache(Select.java:591)
    at org.h2.command.dml.Query.query(Query.java:297)
    at org.h2.command.dml.Query.query(Query.java:267)
    at org.h2.command.dml.Query.query(Query.java:36)
    at org.h2.command.CommandContainer.query(CommandContainer.java:82)
    at org.h2.command.Command.executeQuery(Command.java:187)
    at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
    ... 53 more

 

 

 

 

 

07.11.2013 18:53:58,853 ERROR [com.fsecure.fspms.status.StatusUploadHandler$$EnhancerByCGLIB$$4fe863a1] - Error while receiving status info
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id, parent_path FROM domain_tree WHERE host_identity=?]; Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? [50200-164]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? [50200-164]
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:265)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:731)
    at org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:759)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.queryDomainAndParentIdByIdentity(AbstractHostPackageRequestHandler.java:86)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageRequestHandler.findDomainAndParentIdsByIdentities(AbstractHostPackageRequestHandler.java:66)
    at com.fsecure.fspms.status.StatusUploadHandler.uploadPackageInTransaction(StatusUploadHandler.java:85)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageUploadHandler$1.doInTransaction(AbstractHostPackageUploadHandler.java:50)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageUploadHandler$1.doInTransaction(AbstractHostPackageUploadHandler.java:44)
    at com.fsecure.commons.java.spring.transaction.LoggingTransactionCallback.doInTransaction(LoggingTransactionCallback.java:37)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
    at com.fsecure.fspms.hostmodule.AbstractHostPackageUploadHandler.uploadPackage(AbstractHostPackageUploadHandler.java:43)
    at com.fsecure.fspms.hostmodule.HostInterfaceHandler.uploadPackageFromHost(HostInterfaceHandler.java:213)
    at com.fsecure.fspms.hostmodule.HostInterfaceHandler.handleRequest(HostInterfaceHandler.java:115)
    at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:516)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:305)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at com.fsecure.fspms.jetty.SingleConnectorHandler.handle(SingleConnectorHandler.java:35)
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:151)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
    at org.eclipse.jetty.server.Server.handle(Server.java:352)
    at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596)
    at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1051)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:599)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212)
    at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "DOMAIN_TREE"; SQL statement:
SELECT id, parent_path FROM domain_tree WHERE host_identity=? [50200-164]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:169)
    at org.h2.message.DbException.get(DbException.java:146)
    at org.h2.table.RegularTable.doLock(RegularTable.java:500)
    at org.h2.table.RegularTable.lock(RegularTable.java:434)
    at org.h2.table.TableFilter.lock(TableFilter.java:143)
    at org.h2.command.dml.Select.queryWithoutCache(Select.java:591)
    at org.h2.command.dml.Query.query(Query.java:297)
    at org.h2.command.dml.Query.query(Query.java:267)
    at org.h2.command.dml.Query.query(Query.java:36)
    at org.h2.command.CommandContainer.query(CommandContainer.java:82)
    at org.h2.command.Command.executeQuery(Command.java:187)
    at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
    ... 51 more

2 REPLIES 2
Highlighted
Former F-Secure Employee

Re: "Error while receiving status info / getting policy package" in fspms-webapp-errors.lo

Hello Martin,

 

I'd suggest you open up a support ticket about the issue together with an FSDIAG so we could take a closer look at it.

 

http://www.f-secure.com/en/web/business_global/support/contact/request

 

F-Secure

Re: "Error while receiving status info / getting policy package" in fspms-webapp-errors.lo

Hello Martin,

 

This exception is correct. It happens because several transactions try to get access to Domain_Tree table at the same time.