René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Realtime reporter produces no output","articleBody":"**Describe the bug**\r\n\r\nRunning the realtime reporter from the SQL Developer extension produces sometimes no output due to a `ORA-00001: unique constraint (UT3_LATEST_RELEASE.UT_OUTPUT_BUFFER_INFO_TMP_PK) violated`\r\n\r\n**Provide version info**\r\n\r\n```\r\n19.0.0.0.0\r\n19.0.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.8.3169-develop\r\n\r\n\r\nBANNER                                                                           BANNER_FULL                                                                                                                                                      BANNER_LEGACY                                                                        CON_ID\r\n-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                                                                                           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0\r\n                                                                                 Version 19.4.0.0.0                                                                                                                                                                                                                                          \r\n\r\n\r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_LANGUAGE                   ENGLISH                                                         \r\nNLS_TERRITORY                  SWITZERLAND                                                     \r\nNLS_CURRENCY                   SFr.                                                            \r\nNLS_ISO_CURRENCY               SWITZERLAND                                                     \r\nNLS_NUMERIC_CHARACTERS         .'                                                              \r\nNLS_CALENDAR                   GREGORIAN                                                       \r\nNLS_DATE_FORMAT                DD.MM.YYYY HH24:MI:SS                                           \r\nNLS_DATE_LANGUAGE              ENGLISH                                                         \r\nNLS_SORT                       BINARY                                                          \r\nNLS_TIME_FORMAT                HH24:MI:SSXFF                                                   \r\nNLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF                                          \r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                                               \r\nNLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR HH24:MI:SSXFF TZR                                      \r\nNLS_DUAL_CURRENCY              SF                                                              \r\nNLS_COMP                       BINARY                                                          \r\nNLS_LENGTH_SEMANTICS           BYTE                                                            \r\nNLS_NCHAR_CONV_EXCP            FALSE                                                           \r\n\r\n17 rows selected. \r\n\r\n\r\nPORT_STRING                                                 \r\n------------------------------------------------------------\r\nx86_64/Linux 2.4.xx\r\n```\r\n\r\n**Information about client software**\r\n\r\nutPLSQL for SQL Developer 1.0.0 (or current development version)\r\n\r\n**To Reproduce**\r\n\r\n1. Run a small test in SQL Developer's realtime reporter\r\n2. Rerun test\r\n3. Repeat step 2 until the test is not executed anmore, you get an `initializing...` message for \r\n\r\nIn the SQL Developer logs I find the following:\r\n\r\n```\r\n2019-07-28 11:00:51 SEVERE org.utplsql.sqldev.runner.UtplsqlRunner: Error while producing events for reporter id 1c8f3d5e77a64bbdb523d52c91c47e72: PreparedStatementCallback; SQL [DECLARE\r\n   l_reporter ut_realtime_reporter := ut_realtime_reporter();\r\nBEGIN\r\n   l_reporter.set_reporter_id(?);\r\n   l_reporter.output_buffer.init();\r\n   sys.dbms_output.enable(NULL);\r\n   ut_runner.run(\r\n      a_paths     =\u003e ut_varchar2_list(\r\n                        'PLSCOPE.test_dd_util.test_get_view_source'\r\n                     ),\r\n      a_reporters =\u003e ut_reporters(l_reporter)\r\n   );\r\n   sys.dbms_output.disable;\r\nEND;\r\n]; ORA-00001: unique constraint (UT3_LATEST_RELEASE.UT_OUTPUT_BUFFER_INFO_TMP_PK) violated\r\nORA-06512: at \"UT3_LATEST_RELEASE.UT_OUTPUT_BUFFER_BASE\", line 32\r\nORA-06512: at \"UT3_LATEST_RELEASE.UT_OUTPUT_REPORTER_BASE\", line 34\r\nORA-06512: at line 4\r\n; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UT3_LATEST_RELEASE.UT_OUTPUT_BUFFER_INFO_TMP_PK) violated\r\nORA-06512: at \"UT3_LATEST_RELEASE.UT_OUTPUT_BUFFER_BASE\", line 32\r\nORA-06512: at \"UT3_LATEST_RELEASE.UT_OUTPUT_REPORTER_BASE\", line 34\r\nORA-06512: at line 4\r\n```\r\nas a consequence of this failure the consumer thread does not find result rows.\r\n\r\n**Expected behavior**\r\n\r\nRepeat test runs without technical issues.\r\n","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2019-07-28T09:13:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/985/utPLSQL/issues/985"}