Ad Widget

Collapse

Zabbix 5.0. После обновления ошибки в логе mariadb error.log

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • deemass
    Junior Member
    • Oct 2017
    • 9

    #1

    Zabbix 5.0. После обновления ошибки в логе mariadb error.log

    InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
    2020-05-19 13:30:53 19 [ERROR] InnoDB: Clustered record for sec rec not found index `history_1` of table `zabbix`.`history`
    InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
    0: len 8; hex 0000000000005b32; asc [2;;
    1: len 4; hex de845c12; asc \ ;;
    2: len 6; hex 0001fb06065a; asc Z;;
  • deemass
    Junior Member
    • Oct 2017
    • 9

    #2
    Сделал

    optimize table history

    zabbix.history optimize note Table does not support optimize, doing recreate + ...
    zabbix.history optimize status OK

    теперь новая таблица с ошибками.

    InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
    2020-05-19 16:59:04 675 [ERROR] InnoDB: Clustered record for sec rec not found index `history_uint_1` of table `zabbix`.`history_uint`
    InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
    0: len 8; hex 0000000000009d57; asc W;;
    1: len 4; hex de845a3f; asc Z?;;
    2: len 6; hex 0001fb056189; asc a ;;

    InnoDB: clust index record PHYSICAL RECORD: n_fields 7; compact format; info bits 0
    0: len 6; hex 0001fb056188; asc a ;;
    1: len 6; hex 00008f83d067; asc g;;
    2: len 7; hex 7b0000160709d6; asc { ;;
    3: len 8; hex 000000000000995b; asc [;;
    4: len 4; hex de847ecf; asc ~ ;;
    5: len 8; hex 0000000000000000; asc ;;
    6: len 4; hex a24c217e; asc L!~;;

    TRANSACTION 421648369325240, ACTIVE 210 sec starting index read
    mysql tables in use 1, locked 0
    0 lock struct(s), heap size 1136, 0 row lock(s)
    MySQL thread id 675, OS thread handle 140168412907264, query id 213975 192.168.162.9 zabbix Sending data
    select itemid,min(clock) from history_uint group by itemid

    Comment

    Working...