René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Coverage Report doesn't run (or takes forever)","articleBody":"The coverage report doesn't run or takes forever.\r\n\r\nversion: 18.0.0.0.0\r\ncompatibility: 18.0.0\r\nut_version: v3.1.3.2402\r\nEdition: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 \r\nPort String: x86_64/Linux 2.4.xx\r\n\r\n**Information about client software**\r\nSQLDeveloper, SQLPlus, utPLSQL-cli\r\n\r\n**To Reproduce**\r\n`./utplsql run ***/***@host:1521/***  -f=ut_coverage_html_reporter -o=coverage.html`\r\n\r\n**Expected behavior**\r\nA HTML file with the coverage report\r\n\r\n**Details of the issue**\r\nA couple of \"utPLSQL\" and \"JDBC Thin Client\" database sessions get stuck waiting forever for the following wait-events:\r\n\r\n- resmgr:cpu quantum\r\n- PL/SQL lock timer\r\n- PX Deq: Execute Reply\r\n\r\nThe SQL running queries are:\r\n\r\n```\r\nselect full_name\r\n       , owner\r\n       , name\r\n       , line\r\n       , to_be_skipped\r\n       , text\r\nfrom (\r\n  select lower(s.owner || '.' || s.name) as full_name\r\n         , s.owner\r\n         , s.name\r\n         , s.line - coalesce(\r\n    case\r\n      when type != 'TRIGGER' then\r\n        0\r\n    end\r\n  ,(\r\n    select min(t.line) - 1\r\n    from dba_source t\r\n    where t.owner = s.owner\r\n          and t.type = s.type\r\n          and t.name = s.name\r\n          and regexp_like(t.text, '[A-Za-z0-9$#_]*(begin|declare|compound).*', 'i')\r\n  )) as line\r\n         , s.text\r\n         , case\r\n    when\r\n                     -- to avoid execution of regexp_like on every line\r\n                     -- first do a rough check for existence of search pattern keyword\r\n     ( lower(s.text) like '%procedure%'\r\n           or lower(s.text) like '%function%'\r\n           or lower(s.text) like '%begin%'\r\n           or lower(s.text) like '%end%'\r\n           or lower(s.text) like '%package%' )\r\n         and regexp_like ( s.text\r\n    , '^([\\t ]*(((not)?\\s*(overriding|final|instantiable)[\\t ]*)*(static|constructor|member)?[\\t ]*(procedure|function)|package([\\t ]+body)|begin|end([\\t ]+\\S+)*[ \\t]*;))'\r\n    , 'i' ) then\r\n      'Y'\r\n  end as to_be_skipped\r\n  from dba_source s\r\n  where s.owner in (\r\n    select upper(t.column_value)\r\n    from table ( :l_schema_names ) t\r\n  )\r\n        and s.type not in (\r\n    'PACKAGE'\r\n    , 'TYPE'\r\n    , 'JAVA SOURCE'\r\n  )\r\n             --Exclude calls to utPLSQL framework, Unit Test packages and objects from a_exclude_list parameter of coverage reporter\r\n        and ( s.owner\r\n  , s.name ) not in (\r\n    select el.owner\r\n           , el.name\r\n    from table ( :l_skipped_objects ) el\r\n  )\r\n)\r\nwhere line \u003e 0\r\n```\r\n\r\nand\r\n\r\n```\r\nselect column_value as text\r\nfrom table ( ( :b1 ).get_lines ( :b2\r\n, :b3 ) )\r\n```\r\n\r\nRunning the tests works fine. Only the Coverage Report doesn't run.","author":{"url":"https://github.com/rafael-trevisan","@type":"Person","name":"rafael-trevisan"},"datePublished":"2019-07-07T16:28:58.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":37},"url":"https://github.com/970/utPLSQL/issues/970"}