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

image export to xml broken with postgresql

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.0.0
    • 1.8.8, 1.9.1 (alpha), 1.9.6 (beta)
    • Frontend (F)
    • Centos 5.5 + PostgreSQL 8.4

      Error while trying to import a network map in 1.9.2 that was previously exported from Zabbix 1.8.5. Frontend error output:

      1. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ??????: ??????? ??? ?????????? ? ??????? "sysmaps_links" ???????? ??????????? ???????? ????? "c_sysmaps_links_2" ????????: ???? (selementid1)=(50) ??????????? ? ??????? "sysmaps_elements".[/usr/share/zabbix/include/db.inc.php:519]
      2. Error in query [INSERT INTO sysmaps_links (linkid,sysmapid,label,selementid1,selementid2,drawtype,color) VALUES (2,5,'',50,10,0,'0000CC')] [??????: ??????? ??? ?????????? ? ??????? "sysmaps_links" ???????? ??????????? ???????? ????? "c_sysmaps_links_2" ????????: ???? (selementid1)=(50) ??????????? ? ??????? "sysmaps_elements".]
        #
      3. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ??????: ??????? ?????????? ????????, ??????? ?? ????? ????? ?????????? ????????????[/usr/share/zabbix/include/db.inc.php:441]
      4. Error in query [SELECT u.userid, u.autologout FROM sessions s, users u WHERE s.sessionid='dff570ea735a5d90a6617870a90665e1' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1298292471) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [??????: ??????? ?????????? ????????, ??????? ?? ????? ????? ?????????? ????????????]
      5. pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:594]
      6. pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/usr/share/zabbix/include/db.inc.php:596]
      7. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ??????: ??????? ?????????? ????????, ??????? ?? ????? ????? ?????????? ????????????[/usr/share/zabbix/include/db.inc.php:519]
      8. Error in query [INSERT INTO sysmaps_links (linkid,sysmapid,label,selementid1,selementid2,drawtype,color) VALUES (0,5,'',51,10,0,'0000CC')] [??????: ??????? ?????????? ????????, ??????? ?? ????? ????? ?????????? ????????????]

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

              Created:
              Updated:
              Resolved: