Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connection issue with utplsql-cli and multiple reporters #226

Open
al-hexagon opened this issue Nov 15, 2024 · 0 comments
Open

Connection issue with utplsql-cli and multiple reporters #226

al-hexagon opened this issue Nov 15, 2024 · 0 comments

Comments

@al-hexagon
Copy link

al-hexagon commented Nov 15, 2024

2024-11-15 06:40:07 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_TFS_JUNIT_REP_NEW, ID: 3CD0F310D73B47348A0747748AF24391
2024-11-15 06:40:12 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_COBERTURA_REP_NEW, ID: 79B64FFB0A0B4935A307DD326FD56013
java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1157)
	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1054)
	at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:764)
	at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:1007)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
	at org.utplsql.api.outputBuffer.OutputBufferProvider.hasOutput(OutputBufferProvider.java:67)
	at org.utplsql.api.outputBuffer.OutputBufferProvider.getCompatibleOutputBuffer(OutputBufferProvider.java:33)
	at org.utplsql.api.compatibility.CompatibilityProxy.getOutputBuffer(CompatibilityProxy.java:187)
	at org.utplsql.api.reporter.DefaultReporter.initOutputBuffer(DefaultReporter.java:21)
	at org.utplsql.api.reporter.Reporter.init(Reporter.java:50)
	at org.utplsql.cli.ReporterManager.initReporters(ReporterManager.java:95)
	at org.utplsql.cli.RunAction.initReporters(RunAction.java:222)
	at org.utplsql.cli.RunAction.doRun(RunAction.java:71)
	at org.utplsql.cli.RunAction.run(RunAction.java:122)
	at org.utplsql.cli.RunPicocliCommand.run(RunPicocliCommand.java:265)
	at org.utplsql.cli.Cli.runPicocliWithExitCode(Cli.java:47)
	at org.utplsql.cli.Cli.main(Cli.java:17)
Caused 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

	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1170)
	... 20 more

this happens frequently without any pattern. Typlically it looks like this:

2024-11-15 06:15:07 [main] INFO  org.utplsql.cli.RunAction - 
2024-11-15 06:15:07 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:oci8:****/****@######
2024-11-15 06:15:09 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@#####
2024-11-15 06:15:11 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.10.3349
2024-11-15 06:15:11 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_TFS_JUNIT_REP_NEW, ID: 0F92B9EA282F4ABBBFD840FFC4AE1886
2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_COBERTURA_REP_NEW, ID: AB6C473B14A5415789CC9703CCC77B9E
2024-11-15 06:15:15 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: 2C1C1B6E9B0F4A26AFBBB7572D0A49F1
2024-11-15 06:15:16 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_DOCUMENTATION_REPORTER, ID: AFA09F6B1D9D49CDAB19FE02857D4C8F
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.10.3349
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters
2024-11-15 06:15:19 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running tests

i added the timeout parameter --ora-stuck-timeout=60 but it doesn't look like that it has any affect.

Interesstingly 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.

How can i debug the issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant