change Host macros report SQL Error

XMLWordPrintable

    • Type: Problem report
    • Resolution: Done
    • Priority: Critical
    • None
    • Affects Version/s: 3.4.4
    • Component/s: Frontend (F)
    • None
    • Environment:
      Centos 7.3

      Steps to reproduce:
      Hosts->host>Macros->Inherited and host macros

      change Macro value

      when i Update this host.

      it report SQL error

      Result:

      Cannot update host
      Details
      Error in query [INSERT INTO hostmacro (macro,value,hostid,hostmacroid) VALUES ('{$MAX_RESPONSE}','0.51','11411','365')] [Duplicate entry '365' for key 'PRIMARY']
      SQL statement execution has failed "INSERT INTO hostmacro (macro,value,hostid,hostmacroid) VALUES ('{$MAX_RESPONSE}','0.51','11411','365')". [hosts.php:598 ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? CHost->update() ? CUserMacro->replaceMacros() ? CUserMacro->create() ? DB::insert() ? DB::exception() in include/classes/db/DB.php:468]
      

            Assignee:
            Unassigned
            Reporter:
            misaki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: