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

DELETE query from housekeeper table is too long on Oracle database

    XMLWordPrintable

Details

    Description

      46133:20121116:172221.922 [Z3005] query failed: [-1] ORA-00913: too many values [delete from housekeeper where (housekeeperid in (1001000000223308,1001000000223309,1001000000223310,...1001000000330563,1001000000330565,1001000000330566,1001000000330567,1001000000330568))]

      Query length is 1729345 characters.

      Attachments

        Issue Links

          is duplicated by

          Incident report - Incident report ZBX-5949 SELECT query is too long on Oracle database

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-4190 Need to break apart the compounding of deletes followed by a logical or up in housekeeper.c

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              dotneft Alexey Pustovalov
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: