Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-7598

zabbix can not insert data into mysql when mysql drop partition or create partition

    XMLWordPrintable

Details

    • Change Request
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 5.4.11
    • None
    • Server (S)
    • None
    • os: Linux 1 4.14.141-1.el7.x86_64 #1 SMP Tue Sep 3 14:17:45 CST 2019 x86_64 x86_64 x86_64 GNU/Linux

      server version: 5.4.11

      mysql version : 8.0.2

    Description

      Steps to reproduce:

      1. mysql drop partipion
      2. server log display lock

      Result:

      MySQL creates and deletes partitions in the early morning of every Monday. When mysql is executed in the early morning, there will be a situation where zabbix cannot write data

      I found this article: https://mp.weixin.qq.com/s/H8zRWCJHEG1n13RbCawk7Q

      Expected:
      zabbix can cache data when mysql MDL 

      Attachments

        Activity

          People

            zalex_ua Oleksii Zagorskyi
            yinyaliang yinyaliang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: