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

DATA.SQL build scripts fails with ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

    XMLWordPrintable

Details

    • Team D
    • Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021)
    • 1

    Description

      Steps to reproduce:

      1. On DB server get and install Oracle database 19c (19.11 is last patch as of 2021-june)
      2. On DB server create database with CHARACTER SET AL32UTF8, NATIONAL CHARACTER SET UTF8
      3. On zabbix server install Oracle Instant client 19 and check connectivity
      4. On zabbix server get latest zabbbix src: git checkout tags/5.4.3
      5. On zabbix server run sqlplus and create zabbix user to own schema
      6. On zabbix server run sqlplus and run @schema.sql
      7. On zabbix server run sqlplus and run @images.sql
      8. On zabbix server run sqlplus and run @data.sql

      Result:
      See screenshots with ORA-22835: Buffer too small for CLOB..

      Log also attached

      Expected:
      All scripts runs without error

      Attachments

        Issue Links

          Activity

            People

              yurii Jurijs Klopovskis
              beremour Sergey Yudin
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: