You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Detected Oracle Driver stuck during Statement initialization #145
I get the error message above regularly after two or three succesfull testings.
Then I have two or three unsuccesful tries with the Oracle Driver stucks, after that in the next try can be succesfull again.
There is no unpredictability if the driver stucks or not.
So we have
I tried to experiment with different Clients and Java Versions but as it is said here in the other issues, there is not much scope for experiments while we have to use
Oracle Client 12.2 with jdbc 8 for the 3.1.6 Version of the utPLSQL-cli.
Since it's actually working and it's also the correct configuration I wonder what I can do to become more stability in the testings.
Perhaps I can send you a debug file of a failed test or you can suggest some better working versions of the ojdbc8.jar or the orai18n.jar ( both from 22.02.2019 ) ?
what happens after the Detected Oracle driver stuck during Statement initialization?
The expected behavior would be that CLI does an automatic retry (and potentially some error stacks are written). Does this happen?
It's a problem we investigate since several months now and our solution (because it is very likely to be a driver bug) was to have an internal watchdog which detects such stuck scenario and does up to 5 retries. In that case the outcome of your tests wouldn't be changed, the only thing that happens is that the previous connection is abandoned and a second one is started.
Also: what would be your expectation how CLI deals with such a scenario?
Cheers,
Samuel
P.S. If you happen to be at ApexConnect in Bonn next week, make sure to say hello :)
Hello Samuel,
Thanks for the quick response.
As you probably have noticed the utPLSQL Command starts from a Bamboo – Powershell – Skript – Task.
I do not notice any retry .
Last entry in the Log is "Detected Oracle Driver stuck …" and the build runs endless until it is stopped manually.
As you can see in the picture the build ran for 21 minutes.
Maybe I have to set some special parameters for the retries ?
As you already found out retrying the connection for 1 – n times is the only thing you can offer in such cases.
But in my case ist seems there is nor real retrying happening ….
[cid:image003.jpg@01D4FF7A.0CC66A90]
Mit freundlichen Grüßen
Derik Wehrmann
_________________________________________________________________
Tel: -551 | Test- und Qualitätsmanager | IT SCM und Support
Von: Samuel Nitsche <notifications@github.com>
Gesendet: Dienstag, 30. April 2019 16:04
An: utPLSQL/utPLSQL-cli <utPLSQL-cli@noreply.github.com>
Cc: Wehrmann, Derik <D.Wehrmann@wertgarantie.com>; Mention <mention@noreply.github.com>
Betreff: Re: [utPLSQL/utPLSQL-cli] Detected Oracle Driver stuck during Statement initialization (#145)
Hi @DrErique<https://github.com/DrErique>
what happens after the Detected Oracle driver stuck during Statement initialization?
The expected behavior would be that CLI does an automatic retry (and potentially some error stacks are written). Does this happen?
It's a problem we investigate since several months now and our solution (because it is very likely to be a driver bug) was to have an internal watchdog which detects such stuck scenario and does up to 5 retries. In that case the outcome of your tests wouldn't be changed, the only thing that happens is that the previous connection is abandoned and a second one is started.
Also: what would be your expectation how CLI deals with such a scenario?
Cheers,
Samuel
P.S. If you happen to be at ApexConnect in Bonn next week, make sure to say hello :)
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#145 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AIPTY43SEIDGFHTFQWDVQA3PTBGWPANCNFSM4HJLZYZA>.
Hm, this is strange - the Stuck is detected but it's not aborted (for whatever reason).
Can you try a different OJDBC driver?
I use ojdbc8-12.2.0.1.jar currently.
_________________________________________________________________
Tel: -551 | Test- und Releasemanager | IT SCM
Von: Samuel Nitsche <notifications@github.com>
Gesendet: Freitag, 3. Mai 2019 10:55
An: utPLSQL/utPLSQL-cli <utPLSQL-cli@noreply.github.com>
Cc: Wehrmann, Derik <D.Wehrmann@wertgarantie.com>; Mention <mention@noreply.github.com>
Betreff: Re: [utPLSQL/utPLSQL-cli] Detected Oracle Driver stuck during Statement initialization (#145)
Hm, this is strange - the Stuck is detected but it's not aborted (for whatever reason).
Can you try a different OJDBC driver?
I use ojdbc8-12.2.0.1.jar currently.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#145 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AIPTY44UZUODUCVDHWFEV4TPTP4UPANCNFSM4HJLZYZA>.
Unfortunately that didn't solve the problem.
Do we have any debug option ?
You mentioned the –d Parameter in another issue ?
What about this "HikariPool-1 - Driver does not support get/set network timeout for connections. " report. Perhaps we have a problem with the HikariCP ?
Yeah, this line is strange - didn't notice it so far in any of my runs.
Did you use the latest version of cli from the github page? (yes, there's still something wrong with putting the build number into the version automatically)
I'll try that also, downloading latest version.
We see if this works better … ☺
Von: Samuel Nitsche <notifications@github.com>
Gesendet: Donnerstag, 9. Mai 2019 09:24
An: utPLSQL/utPLSQL-cli <utPLSQL-cli@noreply.github.com>
Cc: Wehrmann, Derik <D.Wehrmann@wertgarantie.com>; Mention <mention@noreply.github.com>
Betreff: Re: [utPLSQL/utPLSQL-cli] Detected Oracle Driver stuck during Statement initialization (#145)
Yeah, this line is strange - didn't notice it so far in any of my runs.
Did you use the latest version of cli from the github page? (yes, there's still something wrong with putting the build number into the version automatically)
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#145 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AIPTY426DNC4Z4JRGNBDL4TPUPGQ5ANCNFSM4HJLZYZA>.
Hi,
I am also facing same issue here with Oracle DB 11.2,Java-Version: 1.8.0_212 , latest utPLSQL-cli 3.1.6 and jdbc 6 (the one from oracle site)
Actually I wanted to file a request for allowing to specifying more HikariConfig options, i.e. addDataSourceProperty (e.g. allowPoolSuspension)...maybe it would help slightly to debug the problem ("enterprise configurations")
I should also add that utPLSQL 3.1.2 was working well (as expected) - Hikari update ....
2019-05-10 11:03:22 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2019-05-10 11:03:22 [main] DEBUG c.z.hikari.util.DriverDataSource - Loaded driver with class name oracle.jdbc.OracleDriver for jdbcUrl=jdbc:oracle:thin:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2019-05-10 11:03:23 [main] INFO com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Driver does not support get/set network timeout for connections. (oracle.jdbc.driver.T4CConnection.getNetworkTimeout()I)
2019-05-10 11:03:23 [main] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@2d928643
2019-05-10 11:03:23 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
2019-05-10 11:03:23 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:thin:****/****@//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2019-05-10 11:03:23 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=1, active=1, idle=0, waiting=0)
2019-05-10 11:03:23 [main] INFO org.utplsql.cli.RunCommand - Successfully connected to database. UtPLSQL core: v3.1.1.1868
2019-05-10 11:03:23 [main] INFO org.utplsql.cli.RunCommand - Oracle-Version: 11.2.0.4.0
2019-05-10 11:03:23 [main] DEBUG c.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Executed rollback on connection oracle.jdbc.driver.T4CConnection@2d928643 due to dirty commit state on close().
2019-05-10 11:03:23 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: 8885D6BC54DF5E4BE05311C8130A76B7
2019-05-10 11:03:23 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@483c7db7
2019-05-10 11:03:23 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_DOCUMENTATION_REPORTER, ID: 8885D6BC54E35E4BE05311C8130A76B7
2019-05-10 11:03:23 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@46fb8ac0
2019-05-10 11:03:23 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@42c416c7
2019-05-10 11:03:23 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=4, active=0, idle=4, waiting=0)
2019-05-10 11:03:25 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2019-05-10 11:03:25 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2019-05-10 11:03:25 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2019-05-10 11:03:25 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.1.1868
2019-05-10 11:03:25 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2019-05-10 11:03:27 [pool-1-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2019-05-10 11:03:31 [pool-1-thread-1] DEBUG c.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Executed rollback on connection oracle.jdbc.driver.T4CConnection@2d928643 due to dirty commit state on close().
2019-05-10 11:03:53 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=4, active=2, idle=2, waiting=0)
2019-05-10 11:04:23 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=4, active=2, idle=2, waiting=0)
2019-05-10 11:04:53 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=4, active=2, idle=2, waiting=0)
2019-05-10 11:05:23 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=4, active=2, idle=2, waiting=0)
EDIT: so using jdbc8 --the one for 12c on the database 11.2; instead of jdbc6 for 11.2), error has changed to .... This is also retried 4 times. I wonder if it has really something to do with Hikari, e.g brettwooldridge/HikariCP#198
2019-05-10 12:51:32 [pool-1-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2019-05-10 12:51:32 [pool-2-thread-1] WARN c.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - **Connection oracle.jdbc.driver.T4CConnection@3b088d51 marked as broken because of SQLSTATE(08006)**, ErrorCode(17002)
java.sql.SQLRecoverableException: IO Error: Socket read interrupted
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:929)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyCallableStatement.execute(HikariProxyCallableStatement.java)
at org.utplsql.api.FileMapper.buildFileMappingArray(FileMapper.java:84)
at org.utplsql.api.FileMapper.buildFileMappingList(FileMapper.java:90)
at org.utplsql.api.testRunner.AbstractTestRunnerStatement.createStatement(AbstractTestRunnerStatement.java:60)
at org.utplsql.api.testRunner.AbstractTestRunnerStatement.<init>(AbstractTestRunnerStatement.java:33)
at org.utplsql.api.testRunner.Pre312TestRunnerStatement.<init>(Pre312TestRunnerStatement.java:17)
at org.utplsql.api.testRunner.TestRunnerStatementProvider.getCompatibleTestRunnerStatement(TestRunnerStatementProvider.java:37)
at org.utplsql.api.compatibility.CompatibilityProxy.getTestRunnerStatement(CompatibilityProxy.java:157)
at org.utplsql.api.TestRunner.lambda$initStatementWithTimeout$0(TestRunner.java:199)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketTimeoutException: Socket read interrupted
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:152)
at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:82)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:139)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:101)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:80)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
... 20 common frames omitted
2019-05-10 12:51:32 [pool-1-thread-3] WARN c.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@1fb473a8 marked as broken because of SQLSTATE(08003), ErrorCode(17008)
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.clearWarnings(PhysicalConnection.java:2573)
at com.zaxxer.hikari.pool.ProxyConnection.close(ProxyConnection.java:246)
at org.utplsql.cli.ReporterManager.lambda$startReporterGatherers$0(ReporterManager.java:130)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2019-05-10 12:51:32 [pool-1-thread-2] WARN c.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@742dfdaf marked as broken because of SQLSTATE(08003), ErrorCode(17008)
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.clearWarnings(PhysicalConnection.java:2573)
at com.zaxxer.hikari.pool.ProxyConnection.close(ProxyConnection.java:246)
at org.utplsql.cli.ReporterManager.lambda$startReporterGatherers$0(ReporterManager.java:130)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
ok, that sounds awesome if it can be done. Actually I wanted to build several versions of utplsql-cli with different HakariCP and jdbc drivers to test it out where the problem may be. i would try to report my results on this friday...though do no wait on me, just go ahead.
EDIT: @pesse ok. so i have just tried 2 recent versions of utPLSQL with different versions of Hakari and jdbc
For utPLSQL 3.1.6 code base:
Hakari 2.7.9 and 3.3.1 did not work
For utPLSQL 3.1.2 code base:
Hakari 2.7.9 and 3.3.1 did not work
what works is only 2.7.2 version with this codebase, with jdbc7.
Hello Samuel,
Thanks for contacting.
I'll try some builds with that next week and tell you about the results.
Nice weekend !
Mit freundlichen Grüßen
Derik Wehrmann
I did a test using the OJDBC8 from Oracle website and the message was a bit more verbose:
# Thanks for testing! #
# #
########################################
Use connection string jdbc:oracle:thin:****/****@***
Successfully connected to database. UtPLSQL core: v3.1.10.3349
Oracle-Version: 19.0.0.0.0
Running tests now.
--------------------------------------
TestRunner initialized
Running on utPLSQL v3.1.10.3349
Initializing reporters
Detected Oracle driver stuck during Statement initialization
java.lang.NullPointerException
at oracle.net.nt.TcpNTAdapter.abort(TcpNTAdapter.java:423)
at oracle.net.ns.NSProtocol.abort(NSProtocol.java:532)
at oracle.jdbc.driver.T4CConnection.doAbort(T4CConnection.java:5161)
at oracle.jdbc.driver.PhysicalConnection.abort(PhysicalConnection.java:9353)
at org.utplsql.cli.RunTestRunnerTask.call(RunTestRunnerTask.java:50)
at org.utplsql.cli.RunTestRunnerTask.call(RunTestRunnerTask.java:24)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
##[error]Process completed with exit code 1.```
I can see a strange pattern between these failures and around 4 sessions (all from JDBC Thin Client) getting stuck while running the following command:
SELECT TEXT, ITEM_TYPE FROM TABLE((:B1 ).GET_LINES(:B2 , :B3 ))
Every time utPLSQL retries "Retrying (n)" I can see another 3 new sessions running the same funny select. The wait event for these sessions is PL/SQL lock timer 🤔
Once utPLSQL finally fails, the sessions will be still "Active" for around 2 or 3 minutes.
Another interesting finding is that I have only 1 report, I get the error once let's say every 10 times I run. With the 3 reports altogether I get the error every 2 or 3 times. Hope that makes sense and helps narrow down this nasty bug.
Either access the file $JAVA_HOME/jre/lib/security/java.security and change securerandom.source=file:/dev/random to securerandom.source=file:/dev/urandom
After sleeping over it I have little hopes this is the problem source (I'm actually quite convinced it's not)
I would still love to get some feedback from you folks, since this is something I cannot test/reproduce myself.
I am unable to run any code coverage reporter from the cli 9/10 times.
Switching back to running project based coverage through a .sql script requires that I list out every file to be checked. (Unless I'm wrong about that).
Here's how I'm running it from .sql
Create a .sql script to run coverage for corbertura and sonar. (If you're not using sqlcl, remove the !rm... lines)
utplsql_coverage.sql
set serveroutput on
set timing off
set linesize 32767
set termout off
set feedback off
set verify off
!rm cobertura_coverage.xml
spool cobertura_coverage.xml
begin
ut.run(
ut_varchar2_list('unit_test'),
ut_coverage_cobertura_reporter(),
a_source_file_mappings =>
ut_file_mapper.build_file_mappings(
a_file_paths => ut_varchar2_list('&1')
),
a_test_file_mappings =>
ut_file_mapper.build_file_mappings(
a_file_paths => ut_varchar2_list('&2')
)
);
end;
/
spool off
!rm sonar_coverage.xml
spool sonar_coverage.xml
begin
ut.run(
ut_varchar2_list('unit_test'),
ut_coverage_sonar_reporter(),
a_source_file_mappings =>
ut_file_mapper.build_file_mappings(
a_file_paths => ut_varchar2_list('&1')
),
a_test_file_mappings =>
ut_file_mapper.build_file_mappings(
a_file_paths => ut_varchar2_list('&2')
)
);
end;
/
spool off
exit;
My source files are in source/plsql, my tests are in tests/utplsql
Activity
pesse commentedon Apr 30, 2019
Hi @DrErique
what happens after the
Detected Oracle driver stuck during Statement initialization?The expected behavior would be that CLI does an automatic retry (and potentially some error stacks are written). Does this happen?
It's a problem we investigate since several months now and our solution (because it is very likely to be a driver bug) was to have an internal watchdog which detects such stuck scenario and does up to 5 retries. In that case the outcome of your tests wouldn't be changed, the only thing that happens is that the previous connection is abandoned and a second one is started.
Also: what would be your expectation how CLI deals with such a scenario?
Cheers,
Samuel
P.S. If you happen to be at ApexConnect in Bonn next week, make sure to say hello :)
DrErique commentedon Apr 30, 2019
pesse commentedon May 3, 2019
Hm, this is strange - the Stuck is detected but it's not aborted (for whatever reason).
Can you try a different OJDBC driver?
I use ojdbc8-12.2.0.1.jar currently.
DrErique commentedon May 3, 2019
DrErique commentedon May 8, 2019
Hello Samuel,
Unfortunately that didn't solve the problem.
Do we have any debug option ?
You mentioned the –d Parameter in another issue ?
What about this "HikariPool-1 - Driver does not support get/set network timeout for connections. " report. Perhaps we have a problem with the HikariCP ?
pesse commentedon May 9, 2019
Yeah, this line is strange - didn't notice it so far in any of my runs.
Did you use the latest version of cli from the github page? (yes, there's still something wrong with putting the build number into the version automatically)
DrErique commentedon May 9, 2019
dmpe commentedon May 10, 2019
Hi,
I am also facing same issue here with Oracle DB 11.2,Java-Version: 1.8.0_212 , latest utPLSQL-cli 3.1.6 and jdbc 6 (the one from oracle site)
Actually I wanted to file a request for allowing to specifying more HikariConfig options, i.e.
addDataSourceProperty(e.g. allowPoolSuspension)...maybe it would help slightly to debug the problem ("enterprise configurations")I should also add that utPLSQL 3.1.2 was working well (as expected) - Hikari update ....
EDIT: so using jdbc8 --the one for 12c on the database 11.2; instead of jdbc6 for 11.2), error has changed to .... This is also retried 4 times. I wonder if it has really something to do with Hikari, e.g brettwooldridge/HikariCP#198
pesse commentedon May 13, 2019
For we don't necessarily need a connection pool, I'll try to remove HikariCP completely.
dmpe commentedon May 13, 2019
ok, that sounds awesome if it can be done. Actually I wanted to build several versions of utplsql-cli with different HakariCP and jdbc drivers to test it out where the problem may be. i would try to report my results on this friday...though do no wait on me, just go ahead.
EDIT:
@pesse ok. so i have just tried 2 recent versions of utPLSQL with different versions of Hakari and jdbc
For utPLSQL 3.1.6 code base:
Hakari 2.7.9 and 3.3.1 did not work
For utPLSQL 3.1.2 code base:
Hakari 2.7.9 and 3.3.1 did not work
what works is only 2.7.2 version with this codebase, with jdbc7.
guicampos commentedon Jun 5, 2019
I had a similar issue:
UtPLSQL core: v3.1.6.2735
Oracle Database 12.1.0.2
utPLSQL-cli 3.1.6.local
utPLSQL-java-api 3.1.6.411
Java-Version: 1.8.0_211
ojdbc7.jar
When i first executed the command:
../utPLSQL-cli/bin/utplsql run -d user/passwd@mydb:1521/mysid -source_path=sources -test_path=tests -f=ut_documentation_reporter -c -f=ut_coverage_sonar_reporter -o=coverage.xml -f=ut_sonar_test_reporter -o=test_results.xml --failure-exit-code=0The command hanged for sometime with
After a quite long wait time, and every time it retried the warning was reissued
after the 4th attempt the test runned smoothly:
And now there's no more wait time in new executions.
I'm sending my current debug output, maybe it can help solving it.
and Hey! utPLSQL is awesome!
utplsql-cli-log.txt
pesse commentedon Jun 27, 2019
Hey @DrErique @dmpe @guicampos
could you try out the latest cli and tell me if you still experience the stuck problems?
https://bintray.com/utplsql/utPLSQL-cli/download_file?file_path=utPLSQL-cli-develop-201906272140.zip
DrErique commentedon Jun 28, 2019
19 remaining items
rafael-trevisan commentedon Jun 29, 2020
rafael-trevisan commentedon Jun 29, 2020
I did a test using the OJDBC8 from Oracle website and the message was a bit more verbose:
rafael-trevisan commentedon Jun 29, 2020
Again, the issue is intermittent. If I just re-run the job to re-execute the tests is may pass - or not.
pesse commentedon Jun 30, 2020
Hey @rafael-trevisan , could you attach the full logs of a failing run with
-d(for extensive debug messages)?This looks different to the original stuck statement error.
rafael-trevisan commentedon Jul 23, 2020
Here is it @pesse
rafael-trevisan commentedon Jul 23, 2020
I can see a strange pattern between these failures and around 4 sessions (all from
JDBC Thin Client) getting stuck while running the following command:Every time utPLSQL retries "Retrying (n)" I can see another 3 new sessions running the same funny
select. The wait event for these sessions isPL/SQL lock timer🤔Once utPLSQL finally fails, the sessions will be still "Active" for around 2 or 3 minutes.
rafael-trevisan commentedon Jul 23, 2020
Ha! The number of hanging session is directly related to the number of reports I am generating in my tests!
In my case, I am using the following reports:
Another interesting finding is that I have only 1 report, I get the error once let's say every 10 times I run. With the 3 reports altogether I get the error every 2 or 3 times. Hope that makes sense and helps narrow down this nasty bug.
tplazaro commentedon Dec 14, 2020
Is there any update on this one, any workaround? I'm having the same issue :(
pesse commentedon Dec 14, 2020
This issue is very likely an Oracle bug and highly related to your used Oracle database, used driver etc.
Please provide
pesse commentedon Jan 27, 2021
@rafael-trevisan @tplazaro can you try the steps mentioned in https://github.com/utPLSQL/utPLSQL/issues/1121?
Either access the file
$JAVA_HOME/jre/lib/security/java.securityand changesecurerandom.source=file:/dev/randomtosecurerandom.source=file:/dev/urandomOr set up JAVA_TOOL_OPTIONS:
export JAVA_TOOL_OPTIONS='-Djava.security.egd=file:/dev/./urandom -Dsecurerandom.source=file:/dev/./urandom'pesse commentedon Jan 28, 2021
After sleeping over it I have little hopes this is the problem source (I'm actually quite convinced it's not)
I would still love to get some feedback from you folks, since this is something I cannot test/reproduce myself.
dmpe commentedon Jan 28, 2021
Hi, I am sorry but cannot test it anymore :(
OsBlaineOra commentedon Jul 15, 2021
I am unable to run any code coverage reporter from the cli 9/10 times.
Switching back to running project based coverage through a .sql script requires that I list out every file to be checked. (Unless I'm wrong about that).
Here's how I'm running it from .sql
Create a .sql script to run coverage for corbertura and sonar. (If you're not using sqlcl, remove the !rm... lines)
utplsql_coverage.sql
My source files are in source/plsql, my tests are in tests/utplsql
Create an env for my source and test list.
Run the script
I can use this in my CICD pipeline until we can find a fix for the stuck problem.
jgebal commentedon Sep 27, 2026
Closing as removal of connection Hikari connection pool in #158 seem to fix it