René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Connection issue with utplsql-cli and multiple reporters","articleBody":"```\n2024-11-15 06:40:07 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_TFS_JUNIT_REP_NEW, ID: 3CD0F310D73B47348A0747748AF24391\n2024-11-15 06:40:12 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_COBERTURA_REP_NEW, ID: 79B64FFB0A0B4935A307DD326FD56013\njava.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation\n\n\tat oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1157)\n\tat oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1054)\n\tat oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:764)\n\tat oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:1007)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)\n\tat oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)\n\tat oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)\n\tat oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)\n\tat org.utplsql.api.outputBuffer.OutputBufferProvider.hasOutput(OutputBufferProvider.java:67)\n\tat org.utplsql.api.outputBuffer.OutputBufferProvider.getCompatibleOutputBuffer(OutputBufferProvider.java:33)\n\tat org.utplsql.api.compatibility.CompatibilityProxy.getOutputBuffer(CompatibilityProxy.java:187)\n\tat org.utplsql.api.reporter.DefaultReporter.initOutputBuffer(DefaultReporter.java:21)\n\tat org.utplsql.api.reporter.Reporter.init(Reporter.java:50)\n\tat org.utplsql.cli.ReporterManager.initReporters(ReporterManager.java:95)\n\tat org.utplsql.cli.RunAction.initReporters(RunAction.java:222)\n\tat org.utplsql.cli.RunAction.doRun(RunAction.java:71)\n\tat org.utplsql.cli.RunAction.run(RunAction.java:122)\n\tat org.utplsql.cli.RunPicocliCommand.run(RunPicocliCommand.java:265)\n\tat org.utplsql.cli.Cli.runPicocliWithExitCode(Cli.java:47)\n\tat org.utplsql.cli.Cli.main(Cli.java:17)\nCaused by: Error : 1013, Position : 0, Sql = declare    l_result int;begin    begin        execute immediate '       begin            :x := case ' || dbms_assert.simple_sql_name( :1  ) || '() is of (ut_output_reporter_base) when true then 1 else 0 end;       end;'       using out l_result;   end;   :2  := l_result;end;, OriginalSql = declare    l_result int;begin    begin        execute immediate '       begin            :x := case ' || dbms_assert.simple_sql_name( ? ) || '() is of (ut_output_reporter_base) when true then 1 else 0 end;       end;'       using out l_result;   end;   ? := l_result;end;, Error Msg = ORA-01013: user requested cancel of current operation\n\n\tat oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1170)\n\t... 20 more\n```\n\nthis happens frequently without any pattern. Typlically it looks like this:\n\n```\n2024-11-15 06:15:07 [main] INFO  org.utplsql.cli.RunAction - \n2024-11-15 06:15:07 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:oci8:****/****@######\n2024-11-15 06:15:09 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@#####\n2024-11-15 06:15:11 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.10.3349\n2024-11-15 06:15:11 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\n2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_TFS_JUNIT_REP_NEW, ID: 0F92B9EA282F4ABBBFD840FFC4AE1886\n2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_COBERTURA_REP_NEW, ID: AB6C473B14A5415789CC9703CCC77B9E\n2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: 2C1C1B6E9B0F4A26AFBBB7572D0A49F1\n2024-11-15 06:15:16 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_DOCUMENTATION_REPORTER, ID: AFA09F6B1D9D49CDAB19FE02857D4C8F\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.10.3349\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\n2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running tests\n```\n\ni added the timeout parameter `--ora-stuck-timeout=60` but it doesn't look like that it has any affect.\n\nInteresstingly im running the same sources with same scripts on two different servers. One server is working fine and the other one is failing frequently. The used cdb / pdb is configured identically. The used pdb-base is identically, the servers are hosted on ms-azure and are setup identically. There are no entries in alert.log, no incidents, no crash-dumps, ... nothing. It just looks like an timeout which doesn't follow any pattern.\n\nHow can i debug the issue?","author":{"url":"https://github.com/al-hexagon","@type":"Person","name":"al-hexagon"},"datePublished":"2024-11-15T07:45:17.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/226/utPLSQL-cli/issues/226"}