SQL error getting sparse domains SQLException trace: SQL State:40XL2 Error Code:-1 java.sql.SQLTransactionRollbackException: 2011-04-14 07:54:40.507 GMT XID |TYPE |MODE|LOCKCOUNT|LOCKNAME |STATE|TABLETYPE / LOCKOBJ |INDEXNAME / CONTAINER_ID / (MODE for LATCH only) |TABLENAME / CONGLOM_ID | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- *** The following row is the victim *** 3296 |ROW |S |0 |(1,7) |WAIT |T |NULL |HARVEST_CONFIGS | *** The above row is the victim *** 3292 |ROW |X |2 |(1,20) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,19) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |TABLE |IX |2 |Tablelock |GRANT|T |NULL |HARVESTDEFINITIONS | 3292 |ROW |X |2 |(1,22) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,21) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,24) |GRANT|T |NULL |HARVEST_CONFIGS at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.getSparseDomainConfigurations(HarvestDefinitionDBDAO.java:1054) at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.createHarvestConfigsEntries(HarvestDefinitionDBDAO.java:275) at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.flipActive(HarvestDefinitionDBDAO.java:701) at org.apache.jsp.Definitions_002dselective_002dharvests_jsp._jspService(org.apache.jsp.Definitions_002dselective_002dharvests_jsp:123) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: org.apache.derby.client.am.SqlException: 2011-04-14 07:54:40.507 GMT XID |TYPE |MODE|LOCKCOUNT|LOCKNAME |STATE|TABLETYPE / LOCKOBJ |INDEXNAME / CONTAINER_ID / (MODE for LATCH only) |TABLENAME / CONGLOM_ID | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- *** The following row is the victim *** 3296 |ROW |S |0 |(1,7) |WAIT |T |NULL |HARVEST_CONFIGS | *** The above row is the victim *** 3292 |ROW |X |2 |(1,20) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,19) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |TABLE |IX |2 |Tablelock |GRANT|T |NULL |HARVESTDEFINITIONS | 3292 |ROW |X |2 |(1,22) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,21) |GRANT|T |NULL |HARVEST_CONFIGS | 3292 |ROW |X |2 |(1,24) |GRANT|T |NULL |HARVEST_CONFIGS at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.am.Statement.completeOpenQuery(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parseOpenQueryFailure(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source) at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source) at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source) at org.apache.derby.client.am.Statement.readOpenQuery(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source) ... 28 more End of SQLException trace