Skip to content

And again Detected Oracle driver stuck during Statement initialization#196

New issue
New issue
Closed
Closed
And again Detected Oracle driver stuck during Statement initialization#196
@alesana-san

Description

@alesana-san
alesana-san
opened on Mar 30, 2021

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions