Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-16650

"lld worker" process produces empty transaction, causes ORA-06550 SQL error

XMLWordPrintable

    • Sprint 56 (Sep 2019), Sprint 57 (Oct 2019), Sprint 59 (Dec 2019)
    • 0.125

      Server version 4.2.4.

      This error:

       11702:20190917:013549.510 [Z3005] query failed: [-1] ORA-06550: line 2, column 1:
      PLS-00103: Encountered the symbol "END" when expecting one of the following:
      
         ( begin case declare exit for goto if loop mod null pragma
         raise return select update while with <an identifier>
         <a double-quoted delimited-identifier> <a bind variable> <<
         continue close current delete fetch lock insert open rollback
         savepoint set sql execute commit forall merge pipe purge
         json_exists json_value json_query json_object json_array [begin
      end;]
      

      is repeating time to time (200 times per 3 days).
      It generated by different lld worker processes (I have 10).

      Maybe it's not critical, but it probably should not be generated at all.

            ak Andrejs Kozlovs
            zalex_ua Oleksii Zagorskyi
            Team A
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: