Ad Widget

Collapse

Update from 6.0.30->6.2 , 6.0.30->6.4 or 6.0.30->7.0 fails

Collapse
This topic has been answered.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Tadas
    Junior Member
    • Jun 2024
    • 1

    #1

    Update from 6.0.30->6.2 , 6.0.30->6.4 or 6.0.30->7.0 fails

    OS Debian 12 (upgraded 9.0-> 10-> 11->12)
    Zabbix from 4.4 to 6.0.30
    Updates from 6.0.30 to 6.2, 6.4, or 7.0 always ends with error:

    completed 27% of database upgrade
    hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding "name_upper" column to "hosts" table
    hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding index to "name_upper" column
    completed 28% of database upgrade
    hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of updating "name_upper" column
    hosts_name_upper_insert trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
    hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
    items_name_upper_update trigger for table "items" already exists, skipping patch of adding "name_upper" column to "items" table
    items_name_upper_update trigger for table "items" already exists, skipping patch of adding index to "name_upper" column
    items_name_upper_update trigger for table "items" already exists, skipping patch of updating "name_upper" column
    completed 29% of database upgrade
    items_name_upper_insert trigger for table "items" already exists, skipping patch of adding it to "items" table
    items_name_upper_update trigger for table "items" already exists, skipping patch of adding it to "items" table
    completed 30% of database upgrade
    completed 31% of database upgrade

    Any suggestions?
  • Answer selected by Markku at 02-08-2024, 15:28.
    Markku
    Senior Member
    Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
    • Sep 2018
    • 1782

    What is the error you mentioned? There is no error above, I only see logging indicating controlled skipping ot statements due to them having been applied already (maybe because you have been attempting the upgrade several times?).

    Markku

    Comment

    • Markku
      Senior Member
      Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
      • Sep 2018
      • 1782

      #2
      What is the error you mentioned? There is no error above, I only see logging indicating controlled skipping ot statements due to them having been applied already (maybe because you have been attempting the upgrade several times?).

      Markku

      Comment

      Working...