Ad Widget

Collapse

Database issue after upgrading zabbix

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Adeola
    Junior Member
    • Jul 2023
    • 2

    #1

    Database issue after upgrading zabbix

    I don't know who else has experienced this .
    I upgraded Zabbix from 5.0 to 6.2 following the guidelines.
    It went successfully and when i connect to the front end of Zabbix., i get the error " No such file or directory".
    All efforts to start the MySQL has proved abortive as the Mysql.service just refused to run. In the error log , i kind of see something about a redo log file in innodb.
    Is there anyone with the same or similar experience after upgrade?
  • MRedbourne
    Senior Member
    • Feb 2023
    • 103

    #2
    Can you post the output of the MySQL error log and (your equivalent) to "systemctl status mysql*" or "journalctl -xeu mysqld". Redo logs generally come into play when there's corruption (or incomplete transactions) in the DB. Is this a Linux or Windows servers?

    Just an FYI: Zabbix 6.2 is end of life.

    Comment

    • Adeola
      Junior Member
      • Jul 2023
      • 2

      #3
      Hi Thanks . i have attached the mysql error log message however the journalctl log might have changed as i have now removed the mysql and would try to reinstall it back .any lead would be much appreciated.
      Attached Files

      Comment

      Working...