Ad Widget

Collapse

zabbix5.0.1 crash

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zhujian
    Junior Member
    • Sep 2020
    • 14

    #16
    | actions | CREATE TABLE `actions` (
    `actionid` bigint(20) unsigned NOT NULL,
    `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `eventsource` int(11) NOT NULL DEFAULT '0',
    `evaltype` int(11) NOT NULL DEFAULT '0',
    `status` int(11) NOT NULL DEFAULT '0',
    `esc_period` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '1h',
    `formula` varchar(500) COLLATE utf8_bin DEFAULT NULL,
    `pause_suppressed` int(11) NOT NULL DEFAULT '1',
    PRIMARY KEY (`actionid`),
    UNIQUE KEY `actions_2` (`name`),
    KEY `actions_1` (`eventsource`,`status`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

    Comment

    • dimir
      Zabbix developer
      • Apr 2011
      • 1080

      #17
      Can you spot the difference, here's what it should be:

      | actions | CREATE TABLE `actions` (
      `actionid` bigint(20) unsigned NOT NULL,
      `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
      `eventsource` int(11) NOT NULL DEFAULT 0,
      `evaltype` int(11) NOT NULL DEFAULT 0,
      `status` int(11) NOT NULL DEFAULT 0,
      `esc_period` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '1h',
      `formula` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
      `pause_suppressed` int(11) NOT NULL DEFAULT 1,
      PRIMARY KEY (`actionid`),
      UNIQUE KEY `actions_2` (`name`),
      KEY `actions_1` (`eventsource`,`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

      Comment

      • zhujian
        Junior Member
        • Sep 2020
        • 14

        #18
        Thank you very much, the problem is solved

        Comment

        Working...