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

PostgreSQL 8.x fails to store non-ASCII characters, supplied by zabbix agent or auto-discovery when client uname contains non-ASCII

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.3
    • Fix Version/s: 1.8.5
    • Component/s: Agent (G)
    • Labels:
      None
    • Environment:
      Zabbix 1.8.3, PostgreSQL 8.4.4, CentOS 5.5

      Description

      ???????? ?????. ???? ?????? Zabbix 1.8.3 ? PostgreSQL 8.4.4. ??? ??? ???????? ?? CentOS 5. ???? ?????????? ??????, ??????? ???? ??????????. ?? ??? ????? ????????????? Linux ? ????? ????? 2.4 ? ????????? ?????????? koi8. ?? ?????????? ?????? ????? ????? Zabbix.

      ??????? uname -a ?? ?????????? ?????? ?????? ??????, ?????????? ??????? ????? ? ????????? koi8, - ???? ?????? ????. ??? ??????? ????????? ?????? uname -a ? ???? ?????? ???? Postgres ???????? ?? ?????????. ????????? ?? ??????? ? ?????? ???????? Zabbix ? Postgres ????? ?????? ???????? ????????? ????? ?? ?????.

      ??? ???????? ?? ????? ??????? ??????? Zabbix:
      [CODE]1889:20100727:120026.858 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: ???????? ?????????????????? ???? ??? ????????? "UTF8": 0xfe
      HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
      [update dservices set status=0,lastup=1280217626,lastdown=0,value='Linux client 2.4.32-release #1 SMP ??? ??? 11 12:13:14 MSD 2008 i686 i686 i386 GNU/Linux' where dserviceid=330]
      1889:20100727:120026.858 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block[/CODE]

      ????????? ?????? ??????????? ? ???????? ??????????? ?? ?????????? ?????????? ????? ?? ?????.
      ?????????? ????? ? ???? ????????????? ???????? ? ??? ?????, ??????????? ???? ??? ??????? ???? ??????????? ???.

      ??????, ????? ???, ??? ????????? ?????? ?????? ??????? "uname -a", ???? ?????????? ?????????? ?????? ? ???? ?????????????? ?? ? utf8, ???? ?????? ??????? "?????" ??? ??????? ???????, ?? ??? ???????? ?? ?? ????? ???????, ????????.

      ????????? ????????? ??????? Zabbix. ?????? ???????????? ???????? ?? ?????? sysName.0 ? ?? ?????????? ? ???????? update_dservice ? update_dservice_value, ??????? ?????????? ? ????? src/zabbix_server/discovery/discover.c. ????? ??????? ? ?? ?????? ???????????? ????? ??????? DBdyn_escape_string_len, ??????? ?????????? ? ????? src/libs/zbxdbhigh/db.c, ? ?????? ?????????? ?, ??? ?????????? ????????? ??????? ??????? ? SQL-??????. ????? ??????????? ? ???? ??????? ?????? ???????? ???????, ???????????? ? utf8, ?? ???????.

      ??? ????? http://www.zabbix.com/forum/showthread.php?t=18552 - ????? ????????? ???????? ????????.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            sire Sergey Syreskin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: