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
Zabbix 2.1.4 supports partitioning tables?
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
Comment