You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "roel goovaerts (JIRA)" <ji...@apache.org> on 2019/04/03 11:50:00 UTC
[jira] [Commented] (CONNECTORS-1592) Found long running query in
manifold scheduled job
[ https://issues.apache.org/jira/browse/CONNECTORS-1592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808643#comment-16808643 ]
roel goovaerts commented on CONNECTORS-1592:
--------------------------------------------
Hi,
I am also experiencing the same (or likewise) issue; from time to time we notice that manifold gets stuck and has no activity (by way of scheduled crawling) whatsoever.
As far as my knowledge goes this could be related to the 'dead tuple bloat' and could be resolved by 'vacuum full', but the databasemaintenance script is run daily.
An example log from such a moment:
{noformat}
logs/manifoldcf.log: WARN 2019-04-02T18:29:17,988 (Worker thread '94') - Found a long-running query (132676 ms): [UPDATE hopcount SET distance=?,deathmark=? WHERE id IN(SELECT ownerid FROM hopdeletedeps t0 WHERE t0.jobid=? AND t0.childidhash=? AND EXISTS(SELECT 'x' FROM intrinsiclink t1 WHERE t1.jobid=t0.jobid AND t1.linktype=t0.linktype AND t1.parentidhash=t0.parentidhash AND t1.childidhash=t0.childidhash AND t1.isnew=?))] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,988 (Worker thread '15') - Found a long-running query (131477 ms): [UPDATE hopcount SET distance=?,deathmark=? WHERE id IN(SELECT ownerid FROM hopdeletedeps t0 WHERE t0.jobid=? AND t0.childidhash=? AND EXISTS(SELECT 'x' FROM intrinsiclink t1 WHERE t1.jobid=t0.jobid AND t1.linktype=t0.linktype AND t1.parentidhash=t0.parentidhash AND t1.childidhash=t0.childidhash AND t1.isnew=?))] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,989 (Worker thread '23') - Found a long-running query (133229 ms): [UPDATE intrinsiclink SET processid=?,isnew=? WHERE jobid=? AND parentidhash=? AND linktype=? AND childidhash=?] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,989 (Worker thread '8') - Found a long-running query (133217 ms): [SELECT parentidhash FROM intrinsiclink WHERE jobid=? AND (parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=?) AND linktype=? AND childidhash=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,989 (Worker thread '36') - Found a long-running query (133212 ms): [UPDATE intrinsiclink SET processid=?,isnew=? WHERE jobid=? AND parentidhash=? AND linktype=? AND childidhash=?] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,989 (Worker thread '29') - Found a long-running query (133168 ms): [SELECT parentidhash FROM intrinsiclink WHERE jobid=? AND (parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=?) AND linktype=? AND childidhash=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,993 (Worker thread '55') - Found a long-running query (132950 ms): [UPDATE hopcount SET distance=?,deathmark=? WHERE id IN(SELECT ownerid FROM hopdeletedeps t0 WHERE t0.jobid=? AND t0.childidhash=? AND EXISTS(SELECT 'x' FROM intrinsiclink t1 WHERE t1.jobid=t0.jobid AND t1.linktype=t0.linktype AND t1.parentidhash=t0.parentidhash AND t1.childidhash=t0.childidhash AND t1.isnew=?))] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,993 (Worker thread '31') - Found a long-running query (133216 ms): [SELECT parentidhash FROM intrinsiclink WHERE jobid=? AND (parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=? OR parentidhash=?) AND linktype=? AND childidhash=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:17,994 (Worker thread '79') - Found a long-running query (133228 ms): [UPDATE intrinsiclink SET processid=?,isnew=? WHERE jobid=? AND parentidhash=? AND linktype=? AND childidhash=?] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,005 (Worker thread '88') - Found a long-running query (133234 ms): [UPDATE intrinsiclink SET processid=NULL,isnew=? WHERE jobid=? AND childidhash=? AND isnew IN (?,?)] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,036 (Worker thread '45') - Found a long-running query (133329 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,036 (Worker thread '60') - Found a long-running query (133264 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,037 (Worker thread '38') - Found a long-running query (133468 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,037 (Worker thread '42') - Found a long-running query (133285 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,037 (Worker thread '43') - Found a long-running query (133637 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,038 (Worker thread '97') - Found a long-running query (133615 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,038 (Worker thread '16') - Found a long-running query (133293 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,039 (Worker thread '54') - Found a long-running query (133262 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,039 (Worker thread '49') - Found a long-running query (132752 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,106 (Worker thread '98') - Found a long-running query (133608 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,131 (Worker thread '34') - Found a long-running query (133383 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,133 (Worker thread '28') - Found a long-running query (133781 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,133 (Worker thread '2') - Found a long-running query (132787 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,133 (Worker thread '87') - Found a long-running query (133680 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,164 (Worker thread '33') - Found a long-running query (133595 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,170 (Worker thread '80') - Found a long-running query (133461 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,201 (Worker thread '69') - Found a long-running query (131059 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,229 (Worker thread '21') - Found a long-running query (106221 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,252 (Worker thread '92') - Found a long-running query (129938 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,252 (Worker thread '52') - Found a long-running query (134536 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,264 (Worker thread '11') - Found a long-running query (133690 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,290 (Worker thread '37') - Found a long-running query (133914 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,323 (Worker thread '5') - Found a long-running query (88449 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,329 (Worker thread '1') - Found a long-running query (129888 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,331 (Worker thread '77') - Found a long-running query (135453 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,335 (Worker thread '65') - Found a long-running query (134110 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,370 (Worker thread '66') - Found a long-running query (133877 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,385 (Worker thread '95') - Found a long-running query (133710 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,399 (Worker thread '73') - Found a long-running query (134079 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,410 (Worker thread '39') - Found a long-running query (135290 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,423 (Worker thread '50') - Found a long-running query (133831 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,447 (Worker thread '24') - Found a long-running query (133931 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,462 (Worker thread '61') - Found a long-running query (135189 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,486 (Worker thread '53') - Found a long-running query (133938 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,490 (Worker thread '47') - Found a long-running query (135203 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,511 (Worker thread '70') - Found a long-running query (133930 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,515 (Worker thread '67') - Found a long-running query (135069 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,534 (Worker thread '82') - Found a long-running query (133783 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,539 (Worker thread '62') - Found a long-running query (134902 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,561 (Worker thread '75') - Found a long-running query (133742 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,563 (Worker thread '27') - Found a long-running query (134900 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,586 (Worker thread '30') - Found a long-running query (133061 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,587 (Worker thread '14') - Found a long-running query (134118 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,611 (Worker thread '22') - Found a long-running query (134012 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,616 (Worker thread '63') - Found a long-running query (133067 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,632 (Worker thread '18') - Found a long-running query (134005 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,641 (Worker thread '57') - Found a long-running query (132751 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,667 (Worker thread '56') - Found a long-running query (132598 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] logs/manifoldcf.log: WARN 2019-04-02T18:29:18,692 (Worker thread '68') - Found a long-running query (124666 ms): [SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE] [id832933@el6720 example]$
{noformat}
> Found long running query in manifold scheduled job
> --------------------------------------------------
>
> Key: CONNECTORS-1592
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1592
> Project: ManifoldCF
> Issue Type: Bug
> Affects Versions: ManifoldCF 2.12
> Reporter: Subasini Rath
> Priority: Major
>
> Hi Karl,
> I am also facing the above mentioned issue. (Similar to Connector-880)
> I am using manifold2.12 binary version. I am using Solr output connector and Web repository connection. Manifold is using all default configuration.
> When I am running the jobs manually, it runs fine. Same jobs have been scheduled to run everyday.
> I am getting below exceptions and the job gets hanged/ going to waiting stage.
> Could you please help me in resolving the same.
> I am getting the below error -
> Scenario-1
> WARN 2019-03-08T23:58:20,338 (qtp550147359-413) - Found a long-running query (2706114 ms): [SELECT t0.id,t0.description,t0.status,t0.starttime,t0.endtime,t0.errortext FROM jobs t0 ORDER BY description ASC]
> WARN 2019-03-08T23:58:20,337 (Document delete stuffer thread) - Found a long-running query (2737370 ms): [SELECT id FROM jobs WHERE status=? LIMIT 1]
> WARN 2019-03-08T23:58:20,339 (Job reset thread) - Found a long-running query (2770133 ms): [SELECT id FROM jobs WHERE status IN (?,?)]
> WARN 2019-03-08T23:58:20,386 (Document delete stuffer thread) - Parameter 0: 'e'
> WARN 2019-03-08T23:58:20,337 (Set priority thread) - Found a long-running query (2732379 ms): [SELECT id,dochash,docid,jobid FROM jobqueue WHERE needpriority=? LIMIT 1000]
> WARN 2019-03-08T23:58:20,386 (Set priority thread) - Parameter 0: 'T'
> WARN 2019-03-08T23:58:20,386 (Job reset thread) - Parameter 0: 'I'
> WARN 2019-03-08T23:58:20,386 (Job reset thread) - Parameter 1: 'i'
> WARN 2019-03-08T23:58:20,372 (Seeding thread) - Parameter 2: '1552047176062'
> WARN 2019-03-08T23:58:20,474 (Document cleanup stuffer thread) - Found a long-running query (2737524 ms): [SELECT id FROM jobs WHERE status=? LIMIT 1]
> WARN 2019-03-08T23:58:20,474 (Document cleanup stuffer thread) - Parameter 0: 'S'
> WARN 2019-03-08T23:58:20,474 (Finisher thread) - Found a long-running query (2752034 ms): [SELECT id FROM jobs WHERE status IN (?,?,?) FOR UPDATE]
> WARN 2019-03-08T23:58:20,474 (Finisher thread) - Parameter 0: 'A'
> WARN 2019-03-08T23:58:20,475 (Finisher thread) - Parameter 1: 'W'
> WARN 2019-03-08T23:58:20,475 (Finisher thread) - Parameter 2: 'R'
> WARN 2019-03-08T23:58:20,475 (Delete startup thread) - Found a long-running query (2752036 ms): [SELECT id FROM jobs WHERE status=? FOR UPDATE]
> WARN 2019-03-08T23:58:20,475 (Delete startup thread) - Parameter 0: 'E'
> WARN 2019-03-08T23:58:20,483 (qtp550147359-4339) - Found a long-running query (2496641 ms): [SELECT t0.id,t0.description,t0.status,t0.starttime,t0.endtime,t0.errortext FROM jobs t0 ORDER BY description ASC]
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan: isDistinctSelect=[false]
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan: isGrouped=[false]
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan: isAggregated=[false]
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan: columns=[ COLUMN: PUBLIC.JOBS.ID not nullable
> WARN 2019-03-08T23:58:20,492 (qtp550147359-4346) - Found a long-running query (2435908 ms): [SELECT t0.id,t0.description,t0.status,t0.starttime,t0.endtime,t0.errortext FROM jobs t0 ORDER BY description ASC]
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan:
> WARN 2019-03-08T23:58:20,492 (Finisher thread) - Plan: ]
> WARN 2019-03-08T23:58:20,499 (Finisher thread) - Plan: [range variable 1
> WARN 2019-03-08T23:58:20,499 (Finisher thread) - Plan: join type=INNER
> WARN 2019-03-08T23:58:20,499 (Finisher thread) - Plan: table=SYSTEM_SUBQUERY
> WARN 2019-03-08T23:58:20,499 (Finisher thread) - Plan: cardinality=0
> WARN 2019-03-08T23:58:20,499 (Finisher thread) - Plan: access=FULL SCAN
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: join condition = [index=SYS_IDX_13329
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: ]
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: ][range variable 2
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: join type=INNER
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: table=JOBS
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: cardinality=3
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: access=INDEX PRED
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: join condition = [index=I1549955498033
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: start conditions=[
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: ] arg_right=[ COLUMN: C1
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: end condition=[
> WARN 2019-03-08T23:58:20,500 (Finisher thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ] arg_right=[ COLUMN: C1
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: other condition=[
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ] arg_right=[ COLUMN: C1
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: PARAMETERS=[
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: @0[DYNAMIC PARAM: , TYPE = VARCHAR
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: @1[DYNAMIC PARAM: , TYPE = VARCHAR
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: @2[DYNAMIC PARAM: , TYPE = VARCHAR
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: SUBQUERIES[
> WARN 2019-03-08T23:58:20,501 (Finisher thread) - Plan: [level=1
> WARN 2019-03-08T23:58:20,502 (Finisher thread) - Plan: value expression]]
> WARN 2019-03-08T23:58:20,502 (Finisher thread) -
> WARN 2019-03-08T23:58:20,504 (Delete startup thread) - Plan: isDistinctSelect=[false]
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: isGrouped=[false]
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: isAggregated=[false]
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: columns=[ COLUMN: PUBLIC.JOBS.ID not nullable
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan:
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: ]
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: [range variable 1
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: join type=INNER
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: table=JOBS
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: cardinality=3
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: access=INDEX PRED
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: join condition = [index=I1549955498033
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: start conditions=[
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,505 (Delete startup thread) - Plan: ] arg_right=[ DYNAMIC PARAM: , TYPE = CHARACTER
> WARN 2019-03-08T23:58:20,507 (Delete startup thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: isDistinctSelect=[false]
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: isGrouped=[false]
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: isAggregated=[false]
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: columns=[ COLUMN: PUBLIC.JOBS.ID not nullable
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan:
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: ]
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: [range variable 1
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: join type=INNER
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: table=JOBS
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: cardinality=3
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: access=INDEX PRED
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: join condition = [index=I1549955498033
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: start conditions=[
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,507 (Delete startup thread) - Plan: end condition=[
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: ] arg_right=[ DYNAMIC PARAM: , TYPE = CHARACTER
> WARN 2019-03-08T23:58:20,507 (Document cleanup stuffer thread) - Plan: ]]
> WARN 2019-03-08T23:58:20,507 (Delete startup thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
> WARN 2019-03-08T23:58:20,508 (Document cleanup stuffer thread) - Plan: end condition=[
> WARN 2019-03-08T23:58:20,508 (Delete startup thread) - Plan: ] arg_right=[ DYNAMIC PARAM: , TYPE = CHARACTER
> WARN 2019-03-08T23:58:20,508 (Document cleanup stuffer thread) - Plan: EQUAL arg_left=[ COLUMN: PUBLIC.JOBS.STATUS
>
> Scenario-2
> WEB: Illegal seed URL 'http://intranet.abcde.com/wps/wcm/connect/xxx/xxxwebsite/home
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)