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 B
    • Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021), Sprint 84 (Jan 2022), Sprint 85 (Feb 2022), Sprint 86 (Mar 2022), Sprint 87 (Apr 2022), Sprint 88 (May 2022), Sprint 89 (Jun 2022), Sprint 90 (Jul 2022), Sprint 91 (Aug 2022), Sprint 92 (Sep 2022)
    • 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

              martins-v Martins Valkovskis
              beremour Sergey Yudin
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: