Ad Widget

Collapse

Partitioning and Zabbix 2.1.4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hard
    Member
    • Feb 2013
    • 65

    #1

    Partitioning and Zabbix 2.1.4

    I have PostgreSQL database with partitioning and Zabbix 2.0.6.
    I just tried to test the Zabbix upgrade from 2.0.6 to 2.1.4 but run into some errors
    Code:
      2944:20130911:110011.564 current database version (mandatory/optional): 02010000/02010000
      2944:20130911:110011.564 required mandatory version: 02010175
      2944:20130911:110011.564 starting automatic database upgrade
      2944:20130911:110011.699 completed 0% of database upgrade
      2944:20130911:110011.834 completed 1% of database upgrade
      2944:20130911:110012.054 completed 2% of database upgrade
      2944:20130911:110012.263 completed 3% of database upgrade
      2944:20130911:110012.271 completed 4% of database upgrade
      2944:20130911:110012.288 completed 5% of database upgrade
      2944:20130911:110012.305 completed 6% of database upgrade
      2944:20130911:110012.322 completed 7% of database upgrade
      2944:20130911:110012.339 completed 8% of database upgrade
      2944:20130911:110012.447 completed 9% of database upgrade
      2944:20130911:110012.464 completed 10% of database upgrade
      2944:20130911:110012.481 completed 11% of database upgrade
      2944:20130911:110012.682 completed 12% of database upgrade
      2944:20130911:110013.234 completed 13% of database upgrade
      2944:20130911:110013.576 completed 14% of database upgrade
      2944:20130911:110013.918 completed 15% of database upgrade
      2944:20130911:110013.926 completed 16% of database upgrade
      2944:20130911:110013.944 completed 17% of database upgrade
      2944:20130911:110014.061 completed 18% of database upgrade
      2944:20130911:110014.121 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ОШИБКА:  удалить объект таблица events колонка value_changed нельзя, так как от него зависят другие объекты
    DETAIL:  правило route_2013_08 для отношения: таблица events зависит от объекта таблица events колонка value_changed
    правило route_2013_09 для отношения: таблица events зависит от объекта таблица events колонка value_changed
    HINT:  Для удаления зависимых объектов используйте DROP ... CASCADE.
     [alter table only events drop column value_changed]
      2944:20130911:110014.122 database upgrade failed
    Zabbix 2.1.4 supports partitioning tables?
  • Pada
    Senior Member
    • Apr 2012
    • 236

    #2
    I may be wrong, but this may be a PostgreSQL issue only.

    I had to use Google Translate to "understand" your error, because I can't read Russian at all:
    2944:20130911:110014.061 completed 18% of database upgrade
    2944:20130911:110014.121 [Z3005] query failed: [0] PGRES_FATAL_ERROR: ERROR: delete the object table column value_changed events can not, because it depends on other objects
    DETAIL: route_2013_08 rule for the relationship: Table of events depends on the object table of events column value_changed
    route_2013_09 rule for the relationship: table events depends on the object table of events column value_changed
    HINT: To delete the dependent objects, use the DROP ... CASCADE.
    [alter table only events drop column value_changed]
    2944:20130911:110014.122 database upgrade failed
    It appears that Zabbix has configured relationships in PG, which I haven't seen in MySQL yet.

    Comment

    Working...