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

image export to xml broken with postgresql

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8.8, 1.9.1 (alpha), 1.9.6 (beta)
    • Fix Version/s: 2.0.0
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Centos 5.5 + PostgreSQL 8.4

      Description

      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')] [??????: ??????? ?????????? ????????, ??????? ?? ????? ????? ?????????? ????????????]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: