Ad Widget

Collapse

Upgrading from 3.4.8 to 4.4.4 failed due to missing db table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dumkaz
    Junior Member
    • Jan 2020
    • 2

    #1

    Upgrading from 3.4.8 to 4.4.4 failed due to missing db table

    Hi

    I am upgrading zabbix-server from version 3.4.8 to version 4.4.4 via compiling binaries from the source. I am dumping database from production zabbix setup, then i install the same zabbix version
    on stage, and restore the database.
    Finally i start upgrading process
    Zabbix-4.4.4 configured and compiled successfully, but when starting new 4.4.4 binary i get the following error message from zabbix_server.log

    Code:
     28828:20200102:185856.087 Starting Zabbix Server. Zabbix 4.4.4 (revision 3131fdac04).
     28828:20200102:185856.087 ****** Enabled features ******
     28828:20200102:185856.087 SNMP monitoring:           YES
     28828:20200102:185856.087 IPMI monitoring:           YES
     28828:20200102:185856.087 Web monitoring:            YES
     28828:20200102:185856.087 VMware monitoring:         YES
     28828:20200102:185856.087 SMTP authentication:       YES
     28828:20200102:185856.087 ODBC:                       NO
     28828:20200102:185856.087 SSH2 support:              YES
     28828:20200102:185856.087 IPv6 support:              YES
     28828:20200102:185856.087 TLS support:                NO
     28828:20200102:185856.088 ******************************
     28828:20200102:185856.088 using configuration file: /usr/local/etc/zabbix_server.conf
     28828:20200102:185856.100 current database version (mandatory/optional): 03050000/03050000
     28828:20200102:185856.100 required mandatory version: 04040000
     28828:20200102:185856.101 [Z3005] query failed: [1146] Table 'zabbix.widget' doesn't exist [select wf.widgetid,wf.name from widget w,widget_field wf where w.widgetid=wf.widgetid and w.type='problems' and wf.name like 'tags.tag.%']
     28828:20200102:185856.101 database upgrade failed
    Searching in google how to modify db schema/add table did not bring any reasonable results about this specific table.
    Please advise
    Last edited by dumkaz; 03-01-2020, 03:23.
  • dumkaz
    Junior Member
    • Jan 2020
    • 2

    #2
    I have found the issue: I used database dump that did not include many tables in it. Have to fix my mysqldump script

    Comment

    Working...