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

    • 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), Documentation backlog
    • 1

      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

        1. data.log.7z
          673 kB
          Sergey Yudin
        2. Screenshot 2021-07-21 at 20.24.38.png
          1.15 MB
          Sergey Yudin
        3. Screenshot 2021-07-21 at 20.24.53.png
          1.38 MB
          Sergey Yudin

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

              Created:
              Updated: