René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"And again Detected Oracle driver stuck during Statement initialization","articleBody":"Hi!\r\n\r\nI will put my outcomes about `Detected Oracle driver stuck during Statement initialization` error.\r\nWhen running tests without file mapping it runs ok. See:\r\n````\r\nMicrosoft Windows [Version 10.0.19042.867]\r\n(c) Корпорация Майкрософт (Microsoft Corporation), 2020. Все права защищены.\r\n\r\nC:\\Users\\usr\\Desktop\\test\u003eC:\\Oracle\\utPLSQL-cli\\bin\\utplsql.bat run stat_adm/stat_adm@dev ^\r\nПродолжить?  -d ^\r\nПродолжить?  -p=\"STAT_INT_TESTS:ods\" ^\r\nПродолжить?  -include=\"STAT_INT.SA_METRIC_PKG\" ^\r\nПродолжить?  -f=UT_COVERAGE_HTML_REPORTER -o=coverage1.html\r\nPicked up JAVA_TOOL_OPTIONS: -Duser.language=en\r\n2021-03-30 11:46:45 [main] INFO  org.utplsql.cli.RunAction - ################# utPLSQL cli #################\r\n#                                             #\r\n#   utPLSQL-cli 3.1.8-SNAPSHOT.local          #\r\n#   utPLSQL-java-api 3.1.8.546                #\r\n#   Java-Version: 1.8.0_271                   #\r\n#   ORACLE_HOME: null                         #\r\n#   NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1   #\r\n#                                             #\r\n#   Thanks for testing!                       #\r\n#                                             #\r\n###############################################\r\n2021-03-30 11:46:45 [main] INFO  org.utplsql.cli.RunAction -\r\n2021-03-30 11:46:45 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2021-03-30 11:46:47 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev\r\n2021-03-30 11:46:50 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268\r\n2021-03-30 11:46:51 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\r\n2021-03-30 11:47:10 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE0B2113E723F6E053C0C50F0AF318\r\n2021-03-30 11:47:13 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2021-03-30 11:47:13 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2021-03-30 11:47:13 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2021-03-30 11:47:13 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268\r\n2021-03-30 11:47:13 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2021-03-30 11:47:15 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running tests\r\n2021-03-30 11:48:20 [main] INFO  org.utplsql.cli.RunAction - --------------------------------------\r\n2021-03-30 11:48:20 [main] INFO  org.utplsql.cli.RunAction - All tests done.\r\n\r\nC:\\Users\\Roman.Shiryaev\\Desktop\\test\u003e\r\n````\r\nAnd when it comes to mapping to source files occasionally it fails after 4 unsuccessfull tries:\r\n````\r\nC:\\Users\\usr\\Desktop\\test\u003eC:\\Oracle\\utPLSQL-cli\\bin\\utplsql.bat run stat_adm/stat_adm@dev ^\r\nПродолжить?  -d ^\r\nПродолжить?  -p=\"STAT_INT_TESTS:ods\" ^\r\nПродолжить?  -include=\"STAT_INT.SA_METRIC_PKG\" ^\r\nПродолжить?  -source_path=\"db-scripts\" ^\r\nПродолжить?    -regex_expression=\"\\/(\\w+)\\/(\\w+)\\/(\\w+?)(_b|)\\.sql$\" ^\r\nПродолжить?    -type_mapping=\"packages=PACKAGE BODY/types=TYPE BODY/triggers=TRIGGER/procedures=PROCEDURE/functions=FUNCTION\" ^\r\nПродолжить?    -owner_subexpression=1 ^\r\nПродолжить?    -name_subexpression=3 ^\r\nПродолжить?    -type_subexpression=2 ^\r\nПродолжить?  -test_path=\"db-scripts\" ^\r\nПродолжить?    -regex_expression=\"\\/(\\w+)\\/(\\w+)\\/(\\w+?)(_b|)\\.sql$\" ^\r\nПродолжить?    -type_mapping=\"tests=PACKAGE BODY\" ^\r\nПродолжить?    -owner_subexpression=1 ^\r\nПродолжить?    -name_subexpression=3 ^\r\nПродолжить?    -type_subexpression=2 ^\r\nПродолжить?  -f=UT_COVERAGE_HTML_REPORTER -o=coverage.html\r\nPicked up JAVA_TOOL_OPTIONS: -Duser.language=en\r\n2021-03-30 11:46:15 [main] INFO  org.utplsql.cli.RunAction - ################# utPLSQL cli #################\r\n#                                             #\r\n#   utPLSQL-cli 3.1.8-SNAPSHOT.local          #\r\n#   utPLSQL-java-api 3.1.8.546                #\r\n#   Java-Version: 1.8.0_271                   #\r\n#   ORACLE_HOME: null                         #\r\n#   NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1   #\r\n#                                             #\r\n#   Thanks for testing!                       #\r\n#                                             #\r\n###############################################\r\n2021-03-30 11:46:15 [main] INFO  org.utplsql.cli.RunAction -\r\n2021-03-30 11:46:15 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2021-03-30 11:46:18 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev\r\n2021-03-30 11:46:21 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268\r\n2021-03-30 11:46:21 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE095EFA8723C7E053C0C50F0A2C96\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:46:41 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:46:44 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2021-03-30 11:46:44 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2021-03-30 11:46:44 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2021-03-30 11:46:44 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268\r\n2021-03-30 11:46:44 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2021-03-30 11:46:44 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray\r\n2021-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\r\n2021-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\r\n... many lines omitted ...\r\n2021-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\r\n2021-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\r\n2021-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\r\n2021-03-30 11:46:46 [pool-1-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization\r\n2021-03-30 11:47:51 [main] WARN  org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (1)\r\n2021-03-30 11:47:51 [main] INFO  org.utplsql.cli.RunAction - ################# utPLSQL cli #################\r\n#                                             #\r\n#   utPLSQL-cli 3.1.8-SNAPSHOT.local          #\r\n#   utPLSQL-java-api 3.1.8.546                #\r\n#   Java-Version: 1.8.0_271                   #\r\n#   ORACLE_HOME: null                         #\r\n#   NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1   #\r\n#                                             #\r\n#   Thanks for testing!                       #\r\n#                                             #\r\n###############################################\r\n2021-03-30 11:47:51 [main] INFO  org.utplsql.cli.RunAction -\r\n2021-03-30 11:47:51 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2021-03-30 11:47:54 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev\r\n2021-03-30 11:47:57 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268\r\n2021-03-30 11:47:57 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\r\n2021-03-30 11:48:17 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE0F24A3F9244DE053C0C50F0ABDD6\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:48:18 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:48:20 [pool-4-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2021-03-30 11:48:20 [pool-4-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2021-03-30 11:48:20 [pool-4-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2021-03-30 11:48:21 [pool-4-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268\r\n2021-03-30 11:48:21 [pool-4-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2021-03-30 11:48:21 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray\r\n2021-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\r\n2021-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\r\n... many lines omitted ...\r\n2021-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\r\n2021-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\r\n2021-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\r\n2021-03-30 11:48:23 [pool-4-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization\r\n2021-03-30 11:49:28 [main] WARN  org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (2)\r\n2021-03-30 11:49:28 [main] INFO  org.utplsql.cli.RunAction - ################# utPLSQL cli #################\r\n#                                             #\r\n#   utPLSQL-cli 3.1.8-SNAPSHOT.local          #\r\n#   utPLSQL-java-api 3.1.8.546                #\r\n#   Java-Version: 1.8.0_271                   #\r\n#   ORACLE_HOME: null                         #\r\n#   NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1   #\r\n#                                             #\r\n#   Thanks for testing!                       #\r\n#                                             #\r\n###############################################\r\n2021-03-30 11:49:28 [main] INFO  org.utplsql.cli.RunAction -\r\n2021-03-30 11:49:28 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2021-03-30 11:49:31 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev\r\n2021-03-30 11:49:34 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268\r\n2021-03-30 11:49:34 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\r\n2021-03-30 11:49:54 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE14EAAC9B24C6E053C0C50F0AAE64\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:49:55 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:49:57 [pool-7-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2021-03-30 11:49:57 [pool-7-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2021-03-30 11:49:57 [pool-7-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2021-03-30 11:49:58 [pool-7-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268\r\n2021-03-30 11:49:58 [pool-7-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2021-03-30 11:49:58 [pool-8-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray\r\n2021-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\r\n2021-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\r\n... many lines omitted ...\r\n2021-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\r\n2021-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\r\n2021-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\r\n2021-03-30 11:50:00 [pool-7-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization\r\n2021-03-30 11:51:05 [main] WARN  org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (3)\r\n2021-03-30 11:51:05 [main] INFO  org.utplsql.cli.RunAction - ################# utPLSQL cli #################\r\n#                                             #\r\n#   utPLSQL-cli 3.1.8-SNAPSHOT.local          #\r\n#   utPLSQL-java-api 3.1.8.546                #\r\n#   Java-Version: 1.8.0_271                   #\r\n#   ORACLE_HOME: null                         #\r\n#   NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1   #\r\n#                                             #\r\n#   Thanks for testing!                       #\r\n#                                             #\r\n###############################################\r\n2021-03-30 11:51:05 [main] INFO  org.utplsql.cli.RunAction -\r\n2021-03-30 11:51:05 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2021-03-30 11:51:08 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:****/****@dev\r\n2021-03-30 11:51:11 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3268\r\n2021-03-30 11:51:11 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\r\n2021-03-30 11:51:31 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: BEBE1AB36215255EE053C0C50F0A319D\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: C:\\Users\\usr\\Desktop\\test\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: db-scripts\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files:\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_b.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_int\\packages\\ct_error_pkg_s.sql\r\n... many lines omitted ...\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_b.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\packages\\umc_api_s.sql\r\n2021-03-30 11:51:32 [main] DEBUG org.utplsql.cli.RunAction - db-scripts\\stat_switchover\\triggers\\after_logon_trg.sql\r\n2021-03-30 11:51:34 [pool-10-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2021-03-30 11:51:34 [pool-10-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2021-03-30 11:51:34 [pool-10-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2021-03-30 11:51:35 [pool-10-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3268\r\n2021-03-30 11:51:35 [pool-10-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2021-03-30 11:51:35 [pool-11-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray\r\n2021-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\r\n2021-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\r\n... many lines omitted ...\r\n2021-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\r\n2021-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\r\n2021-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\r\n2021-03-30 11:51:37 [pool-10-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization\r\n2021-03-30 11:52:42 [main] WARN  org.utplsql.cli.RunAction - WARNING: Caught Oracle stuck during creation of Runner-Statement. Retrying (4)\r\n\r\nC:\\Users\\usr\\Desktop\\test\u003e\r\n````\r\nWhen 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).\r\n\r\nIn 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:\r\n````\r\nselect d.last_active_time, d.sql_id, d.sql_text, d.module, s.owner, s.object_name, d.program_line#\r\nfrom v$sql d\r\nleft join dba_objects s on d.program_id = s.object_id\r\nwhere d.module in ('utPLSQL', 'java.exe') -- I found just these modules that are used by utplsql-cli\r\nand d.last_active_time \u003e to_date('30.03.2021 09:20:00', 'DD.MM.YYYY HH24:MI:SS') -- I catch exact time after which I started utplsql-cli\r\norder by 1 desc;\r\n````\r\nHere'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\r\n\r\nFeel free to ask any questions or offer other test-cases. Let's help our beloved `utPLSQL` framework to live long!","author":{"url":"https://github.com/alesana-san","@type":"Person","name":"alesana-san"},"datePublished":"2021-03-30T09:29:13.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/196/utPLSQL-cli/issues/196"}