GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — Test execution killed due to ORA-04036 when running with coverage reporters · Issue #1248 · utPLSQL/utPLSQL Closed Labels DescriptionDescribe the bug When executing our test suite with coverage reporters enabled the executing session is killed due to Observing memory usage of the session via a custom reporter dumping the following query result into a table via an SELECT ROUND(p.pga_used_mem/1024/1024,2) AS pga_used_mem_mb, ROUND(p.pga_alloc_mem/1024/1024,2) AS pga_alloc_mem_mb, ROUND(p.pga_freeable_mem/1024/1024,2) AS pga_freeable_mem_mb, ROUND(p.pga_max_mem/1024/1024,2) AS pga_max_mem_mb FROM v$session s, v$process p WHERE s.paddr = p.addr AND s.AUDSID = (select sys_context ('USERENV', 'SESSIONID') from dual); Executing the same suite without a coverage reporter the memory usage is steady at ~a few hundred MB of memory usage. It feels like the PL/SQL Profiler is keeping all coverage data in memory throughout, leading us to the out of memory situation and session being killed. Modifying https://github.com/utPLSQL/utPLSQL/blob/develop/source/core/coverage/ut_coverage_helper_profiler.pkb#L44 to call We also attempted to add a 'profiler flusher' reporter which periodically invoked Provide version info set serveroutput on declare l_version varchar2(255); l_compatibility varchar2(255); begin dbms_utility.db_version( l_version, l_compatibility ); dbms_output.put_line( l_version ); dbms_output.put_line( l_compatibility ); end; / select substr(ut.version(),1,60) as ut_version from dual; select * from v$version; select * from nls_session_parameters; select substr(dbms_utility.port_string,1,60) as port_string from dual; 21.0.0.0.0 21.0.0 PL/SQL procedure successfully completed. UT_VERSION ------------------------------------------------------------ v3.1.12.3589 BANNER BANNER_FULL BANNER_LEGACY CON_ID -------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production 0 Version 21.3.0.0.0 PARAMETER VALUE ------------------------------ ---------------------------------------------------------------- NLS_LANGUAGE ENGLISH NLS_TERRITORY UNITED KINGDOM NLS_CURRENCY £ NLS_ISO_CURRENCY UNITED KINGDOM NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE ENGLISH NLS_SORT BINARY NLS_TIME_FORMAT HH24.MI.SSXFF NLS_TIMESTAMP_FORMAT DD-MON-RR HH24.MI.SSXFF PARAMETER VALUE ------------------------------ ---------------------------------------------------------------- NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH24.MI.SSXFF TZR NLS_DUAL_CURRENCY € NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE 17 rows selected. PORT_STRING ------------------------------------------------------------ x86_64/Linux 2.4.xx Information about client software To Reproduce
begin ut.run(ut_coverage_sonar_reporter()); end; /
Repeat above comparing to a test run without a coverage reporter enabled. Expected behavior Example code Additional context
Activity
MetadataMetadataAssigneesLabelsTypeProjectsMilestoneRelationshipsDevelopmentIssue actions |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |
