[ https://issues.apache.org/jira/browse/CONNECTORS-453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13263090#comment-13263090 ]
Karl Wright commented on CONNECTORS-453: ---------------------------------------- Clicking pause during the job run yields the following to be displayed in the UI: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, JOBS, (1,7) Waiting XID : {147028, X} , APP, UPDATE jobs SET status=? WHERE id=? Granted XID : {146703, S} , {146941, S} Lock : ROW, JOBQUEUE, (481,10) Waiting XID : {146941, S} , APP, SELECT jobid,CAST(COUNT(dochash) AS bigint) AS doccount FROM jobqueue t1 WHERE EXISTS(SELECT 'x' FROM jobs t0 WHERE t0.id=t1.jobid AND id=?) GROUP BY jobid Granted XID : {146612, X} Lock : ROW, HOPCOUNT, (1734,27) Waiting XID : {146612, S} , APP, SELECT parentidhash,linktype,distance FROM hopcount WHERE jobid=? AND parentidhash IN (?,?,?,?,?,?,?,?,?,?) AND linktype=? Granted XID : {146666, X} Lock : ROW, JOBS, (1,7) Waiting XID : {146666, S} , APP, INSERT INTO hopcount (deathmark,parentidhash,id,distance,jobid,linktype) VALUES (?,?,?,?,?,?) . The selected victim is XID : 147028. > ManifoldCF running with Derby 10.8.1.1 has severe performance problems > ---------------------------------------------------------------------- > > Key: CONNECTORS-453 > URL: https://issues.apache.org/jira/browse/CONNECTORS-453 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 0.5 > Reporter: Karl Wright > Assignee: Karl Wright > Fix For: ManifoldCF 0.6 > > > Since upgrading to Derby 10.8.x.x, tt takes minutes to crawl just 20 > documents. Clearly the Derby contention/locking bugs are back with a > vengeance in 10.8.x.x. Either we use 10.7.x.x or we get the Derby team to > look at them again. > In the interim, maybe it is time to use hsqldb as the default embedded > database for the single-process example instead of Derby. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira