[Netarchivesuite-devel] FW: [SBForge JIRA] Commented: (NAS-1845) Database Deadlock
Nicolas Giraud
nikokode at gmail.com
Thu Apr 14 09:48:02 CEST 2011
Hi Mikis,
I have a similar error when attempting to activate a harvest definition. I
will continue investigating but so far I don't understand what's happening.
Regards,
Nicolas
2011/4/14 Mikis Seth Sørensen <mss at statsbiblioteket.dk>
> Hi Nicolas
>
> Have you got any idea of the cause for Colins problem is. Could you try to
> reproduce the error in your environment based on Colins instructions?
>
> Note that this is a Blocker.
>
> ~Mikis
>
> From: "Colin Rosenthal (JIRA)" <jira at sbforge.org>
> Date: Thu, 14 Apr 2011 09:15:37 +0200
> To: Mikis Seth Sørensen <mss at statsbiblioteket.dk>
> Subject: [SBForge JIRA] Commented: (NAS-1845) Database Deadlock
>
> *Issue* (*View Online <https://sbforge.org/jira/browse/NAS-1845>*)
> *Key:* NAS-1845 <https://sbforge.org/jira/browse/NAS-1845> Issue Type: [image:
> Bug] <https://sbforge.org/jira/browse/NAS-1845> Bug Status: [image:
> Triage] Triage Priority: [image: Blocker] Blocker Assignee: Unassigned
> Reporter: Colin Rosenthal<https://sbforge.org/jira/secure/ViewProfile.jspa?name=csr>
> Operations *View all<https://sbforge.org/jira/browse/NAS-1845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel>
> * *View comments<https://sbforge.org/jira/browse/NAS-1845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel>
> * *View history<https://sbforge.org/jira/browse/NAS-1845?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel>
> * *Database Deadlock <https://sbforge.org/jira/browse/NAS-1845>*
> Updated: 14/Apr/11 9:14 AM Created: 13/Apr/11 2:53 PM
> The following comment has been added to this issue: [ Permalink<https://sbforge.org/jira/browse/NAS-1845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=26252#comment-26252>]
> *Author:* Colin Rosenthal<https://sbforge.org/jira/secure/ViewProfile.jspa?name=csr>
> *Date:* 14/Apr/11 9:14 AM
> *Comment:*
>
> The issue appears to be reproducible:
> i) Create a new install
> ii) add an alias (netarkivet.dk is an alias for kb.dk)
> iii) Run a snapshot harvest with byte limit 100000
> iv) After the harvest is finished, edit sulnudu.dk to make it an alias of
> kb.dk. This step deadlocks.
>
> *Project:* NetarchiveSuite <https://sbforge.org/jira/browse/NAS> *
> Components:* GUI *Affects Versions:* 3.16.0 *Fix Versions:* 3.16.0
> Description
>
> Received the following deadlock when trying to update alias information
> (Step 9 of Test 2).
>
> SQL error updating domain Domain:sulnudu.dk;
> Comment:;
> Configurations:
> defaultconfig;
> Seedlists:
> defaultseeds;
> Passwords:
> ---------------
> in database
> SQLException trace:
> SQL State:40XL2
> Error Code:-1
> java.sql.SQLTransactionRollbackException: A lock could not be obtained
> within the time requested. The lockTable dump is:
> 2011-04-13 12:50:14.632 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 ***
> 6641 |ROW |S |0 |(2,15) |WAIT |T |NULL |DOMAINS |
> - The above row is the victim ***
> 6630 |ROW |X |4 |(2,15) |GRANT|T |NULL |DOMAINS |
> 6630 |TABLE |IX |4 |Tablelock |GRANT|T |NULL |DOMAINS |
> 6641 |TABLE |IS |1 |Tablelock |GRANT|T |NULL |DOMAINS |
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> 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.executeUpdate(Unknown
> Source)
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> at
> dk.netarkivet.harvester.datamodel.DomainDBDAO.updateHarvestInfo(DomainDBDAO.java:646)
> at
> dk.netarkivet.harvester.datamodel.DomainDBDAO.update(DomainDBDAO.java:292)
> at
> dk.netarkivet.harvester.webinterface.DomainDefinition.updateDomain(DomainDefinition.java:195)
> at
> dk.netarkivet.harvester.webinterface.DomainDefinition.processRequest(DomainDefinition.java:138)
> at
> org.apache.jsp.Definitions_002dedit_002ddomain_jsp._jspService(org.apache.jsp.Definitions_002dedit_002ddomain_jsp:125)
> 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: A lock could not be
> obtained within the time requested. The lockTable dump is:
> 2011-04-13 12:50:14.632 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 ***
> 6641 |ROW |S |0 |(2,15) |WAIT |T |NULL |DOMAINS |
> - The above row is the victim ***
> 6630 |ROW |X |4 |(2,15) |GRANT|T |NULL |DOMAINS |
> 6630 |TABLE |IX |4 |Tablelock |GRANT|T |NULL |DOMAINS |
> 6641 |TABLE |IS |1 |Tablelock |GRANT|T |NULL |DOMAINS |
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
> at
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
> Source)
> at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
> Source)
> at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
> at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
> Source)
> at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
> at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
> at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
> Source)
> ... 29 more
> End of SQLException trace
>
> This message was automatically generated by Atlassian JIRA<http://www.atlassian.com/c/JIRA/10140> Enterprise
> Edition, Version: 4.2.1-b588-588 - Bug/feature request<http://jira.atlassian.com/default.jsp?clicked=footer>.
>
> If you think it was sent incorrectly, contact one of this server's
> administrators .
>
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>
>
--
Nicolas Giraud
---------------------------------------------------------------------------------------------
Développeur Archives du Web - Bibliothèque Nationale de France
Web Archiving Developper - National Library of France
---------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-devel/attachments/20110414/fcf91e70/attachment-0002.html>
More information about the Netarchivesuite-devel
mailing list