And again Detected Oracle driver stuck during Statement initialization
alesana-san opened this issue · 0 comments
alesana-san commented
Hi!
I will put my outcomes about Detected Oracle driver stuck during Statement initialization error.
When running tests without file mapping it runs ok. See:
Microsoft Windows [Version 10.0.19042.867]
(c) Корпорация Майкрософт (Microsoft Corporation), 2020. Все права защищены.
C:\Users\usr\Desktop\test>C:\Oracle\utPLSQL-cli\bin\utplsql.bat run stat_adm/stat_adm@dev ^
Продолжить? -d ^
Продолжить? -p="STAT_INT_TESTS:ods" ^
Продолжить? -include="STAT_INT.SA_METRIC_PKG" ^
Продолжить? -f=UT_COVERAGE_HTML_REPORTER -o=coverage1.html
Picked up JAVA_TOOL_OPTIONS: -Duser.language=en
2021-03-30 11:46:45 [main] INFO org.utplsql.cli.RunAction - ################# utPLSQL cli #################
# #
# utPLSQL-cli 3.1.8-SNAPSHOT.local #
# utPLSQL-java-api 3.1.8.546 #
# Java-Version: 1.8.0_271 #
# ORACLE_HOME: null #
# NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1 #
# #
# Thanks for testing! #
# #
###############################################
2021-03-30 11:46:45 [main] INFO org.utplsql.cli.RunAction -
2021-03-30 11:46:45 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2021-03-30 11:46:47 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev
2021-03-30 11:46:50 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268
2021-03-30 11:46:51 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2021-03-30 11:47:10 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE0B2113E723F6E053C0C50F0AF318
2021-03-30 11:47:13 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2021-03-30 11:47:13 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2021-03-30 11:47:13 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2021-03-30 11:47:13 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268
2021-03-30 11:47:13 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2021-03-30 11:47:15 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running tests
2021-03-30 11:48:20 [main] INFO org.utplsql.cli.RunAction - --------------------------------------
2021-03-30 11:48:20 [main] INFO org.utplsql.cli.RunAction - All tests done.
C:\Users\Roman.Shiryaev\Desktop\test>
And when it comes to mapping to source files occasionally it fails after 4 unsuccessfull tries:
C:\Users\usr\Desktop\test>C:\Oracle\utPLSQL-cli\bin\utplsql.bat run stat_adm/stat_adm@dev ^
Продолжить? -d ^
Продолжить? -p="STAT_INT_TESTS:ods" ^
Продолжить? -include="STAT_INT.SA_METRIC_PKG" ^
Продолжить? -source_path="db-scripts" ^
Продолжить? -regex_expression="\/(\w+)\/(\w+)\/(\w+?)(_b|)\.sql$" ^
Продолжить? -type_mapping="packages=PACKAGE BODY/types=TYPE BODY/triggers=TRIGGER/procedures=PROCEDURE/functions=FUNCTION" ^
Продолжить? -owner_subexpression=1 ^
Продолжить? -name_subexpression=3 ^
Продолжить? -type_subexpression=2 ^
Продолжить? -test_path="db-scripts" ^
Продолжить? -regex_expression="\/(\w+)\/(\w+)\/(\w+?)(_b|)\.sql$" ^
Продолжить? -type_mapping="tests=PACKAGE BODY" ^
Продолжить? -owner_subexpression=1 ^
Продолжить? -name_subexpression=3 ^
Продолжить? -type_subexpression=2 ^
Продолжить? -f=UT_COVERAGE_HTML_REPORTER -o=coverage.html
Picked up JAVA_TOOL_OPTIONS: -Duser.language=en
2021-03-30 11:46:15 [main] INFO org.utplsql.cli.RunAction - ################# utPLSQL cli #################
# #
# utPLSQL-cli 3.1.8-SNAPSHOT.local #
# utPLSQL-java-api 3.1.8.546 #
# Java-Version: 1.8.0_271 #
# ORACLE_HOME: null #
# NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1 #
# #
# Thanks for testing! #
# #
###############################################
2021-03-30 11:46:15 [main] INFO org.utplsql.cli.RunAction -
2021-03-30 11:46:15 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2021-03-30 11:46:18 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev
2021-03-30 11:46:21 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268
2021-03-30 11:46:21 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2021-03-30 11:46:41 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE095EFA8723C7E053C0C50F0A2C96
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:46:44 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2021-03-30 11:46:44 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2021-03-30 11:46:44 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2021-03-30 11:46:44 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268
2021-03-30 11:46:44 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:46:46 [pool-1-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2021-03-30 11:47:51 [main] WARN org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (1)
2021-03-30 11:47:51 [main] INFO org.utplsql.cli.RunAction - ################# utPLSQL cli #################
# #
# utPLSQL-cli 3.1.8-SNAPSHOT.local #
# utPLSQL-java-api 3.1.8.546 #
# Java-Version: 1.8.0_271 #
# ORACLE_HOME: null #
# NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1 #
# #
# Thanks for testing! #
# #
###############################################
2021-03-30 11:47:51 [main] INFO org.utplsql.cli.RunAction -
2021-03-30 11:47:51 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2021-03-30 11:47:54 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev
2021-03-30 11:47:57 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268
2021-03-30 11:47:57 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2021-03-30 11:48:17 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE0F24A3F9244DE053C0C50F0ABDD6
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
... many lines omitted ...
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:48:20 [pool-4-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2021-03-30 11:48:20 [pool-4-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2021-03-30 11:48:20 [pool-4-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2021-03-30 11:48:21 [pool-4-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268
2021-03-30 11:48:21 [pool-4-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:48:23 [pool-4-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2021-03-30 11:49:28 [main] WARN org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (2)
2021-03-30 11:49:28 [main] INFO org.utplsql.cli.RunAction - ################# utPLSQL cli #################
# #
# utPLSQL-cli 3.1.8-SNAPSHOT.local #
# utPLSQL-java-api 3.1.8.546 #
# Java-Version: 1.8.0_271 #
# ORACLE_HOME: null #
# NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1 #
# #
# Thanks for testing! #
# #
###############################################
2021-03-30 11:49:28 [main] INFO org.utplsql.cli.RunAction -
2021-03-30 11:49:28 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2021-03-30 11:49:31 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev
2021-03-30 11:49:34 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268
2021-03-30 11:49:34 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2021-03-30 11:49:54 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE14EAAC9B24C6E053C0C50F0AAE64
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:49:57 [pool-7-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2021-03-30 11:49:57 [pool-7-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2021-03-30 11:49:57 [pool-7-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2021-03-30 11:49:58 [pool-7-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268
2021-03-30 11:49:58 [pool-7-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:50:00 [pool-7-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2021-03-30 11:51:05 [main] WARN org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (3)
2021-03-30 11:51:05 [main] INFO org.utplsql.cli.RunAction - ################# utPLSQL cli #################
# #
# utPLSQL-cli 3.1.8-SNAPSHOT.local #
# utPLSQL-java-api 3.1.8.546 #
# Java-Version: 1.8.0_271 #
# ORACLE_HOME: null #
# NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1 #
# #
# Thanks for testing! #
# #
###############################################
2021-03-30 11:51:05 [main] INFO org.utplsql.cli.RunAction -
2021-03-30 11:51:05 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2021-03-30 11:51:08 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev
2021-03-30 11:51:11 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268
2021-03-30 11:51:11 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0
2021-03-30 11:51:31 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE1AB36215255EE053C0C50F0A319D
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\Users\usr\Desktop\test
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:51:34 [pool-10-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2021-03-30 11:51:34 [pool-10-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2021-03-30 11:51:34 [pool-10-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2021-03-30 11:51:35 [pool-10-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268
2021-03-30 11:51:35 [pool-10-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_b.sql
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_int\packages\ct_error_pkg_s.sql
... many lines omitted ...
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_b.sql
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\packages\umc_api_s.sql
2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: db-scripts\stat_switchover\triggers\after_logon_trg.sql
2021-03-30 11:51:37 [pool-10-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization
2021-03-30 11:52:42 [main] WARN org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (4)
C:\Users\usr\Desktop\test>
When I catch Detected Oracle driver stuck during Statement initialization error I don't see in v$sql any test related stuff (I mean calls to my test packages and tested packages as well). But after getting the error above I still see that new sql statements have its last_active_time refreshed as it is executing even after this error occurs. I'm not fluent in Java but I think maybe cli somehow detaches from db session and the session keeps on going and executing stuff (but strangely without any test calls).
In case of the first run above (I mean the one without file mapping that succeeds) I see the whole bunch of my queries and test calls. Here's a query I use for it:
select d.last_active_time, d.sql_id, d.sql_text, d.module, s.owner, s.object_name, d.program_line#
from v$sql d
left join dba_objects s on d.program_id = s.object_id
where d.module in ('utPLSQL', 'java.exe') -- I found just these modules that are used by utplsql-cli
and d.last_active_time > to_date('30.03.2021 09:20:00', 'DD.MM.YYYY HH24:MI:SS') -- I catch exact time after which I started utplsql-cli
order by 1 desc;
Here's link with results for the query above in case of "bad" run (with mapping to source files): https://docs.google.com/spreadsheets/d/1AkUbTCBCopTCABeNM_9alzgKIPZyL7WC-dgp7YNH3Bc/edit?usp=sharing
Feel free to ask any questions or offer other test-cases. Let's help our beloved utPLSQL framework to live long!