Ad Widget

Collapse

Error trying to make optimize table history_uint

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GeorgeKup
    Member
    • Nov 2019
    • 98

    #1

    Error trying to make optimize table history_uint

    When trying to execute optimize table history_uint:

    MariaDB [zabbix]> optimize table history_uint;
    + --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
    | Table | Op | Msg_type | Msg_text |
    + --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
    | zabbix.history_uint | optimize | note | Table does not support optimize, doing recreate + analyze instead |
    | zabbix.history_uint | optimize | error | Temporary file write failure |
    | zabbix.history_uint | optimize | status | Operation failed |
    + --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
    at the same time, if you run optimize table history, then:

    MariaDB [zabbix]> optimize table history;
    + ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
    | Table | Op | Msg_type | Msg_text |
    + ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
    | zabbix.history | optimize | note | Table does not support optimize, doing recreate + analyze instead |
    | zabbix.history | optimize | status | OK |
    + ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
Working...