Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-8775

database upgrade failed from v2.2.5 to 2.4.0

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Incomplete
    • Icon: Blocker Blocker
    • None
    • 2.4.0
    • Server (S)
    • None
    • FreeBSD 10.0-RELEASE-p9,x64
      psql (PostgreSQL) 9.3.5, with table partitions

      Hi support,
      Get this error during database updates.

      31515:20140917:163413.167 completed 27% of database upgrade
       31515:20140917:163413.241 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot drop table history_sync because other objects depend on it
      DETAIL:  default for table tpl_history_sync column id depends on sequence history_sync_id_seq
      table partitions.history_sync_20140904 depends on table history_sync
      
      table partitions.history_sync_20140918 depends on table history_sync
      HINT:  Use DROP ... CASCADE to drop the dependent objects too.
       [drop table history_sync]
       31515:20140917:163413.243 completed 28% of database upgrade
       31515:20140917:163413.243 database upgrade fully completed
       31515:20140917:163413.273 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "bulk" does not exist
      LINE 1: ...ct interfaceid,hostid,type,main,useip,ip,dns,port,bulk from ...
                                                                   ^
       [select interfaceid,hostid,type,main,useip,ip,dns,port,bulk from interface]
      
      31661:20140917:163414.880 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column t.headers does not exist
      LINE 1: ...tid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,...
                                                                   ^
       [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_k
       31660:20140917:163414.881 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column t.headers does not exist
      LINE 1: ...tid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,...
                                                                   ^
      

      table partitions may be a problem.
      here only help a db restore from the latest db backup v.2.2.5

            Unassigned Unassigned
            stefans Stefan Sabolowitsch
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: