Upgrade zabbix-server postgresql database 3.4.4 to 3.5 fails on debian stretch

[vchrizz]

what i did:
1. changed 3.4 to 3.5 in /etc/apt/sources.list.d/zabbix.list
2. issued aptitude update && aptitude safe-upgrade
3. rebooted the system

now the frontend displays:

Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 3050016/3050016. Required mandatory version: 3050028. Contact your system administrator.

looking at the zabbix-server logs:

  1467:20171225:100447.411 Starting Zabbix Server. Zabbix 4.0.0alpha1 (revision 76230).
  1467:20171225:100447.411 ****** Enabled features ******
  1467:20171225:100447.411 SNMP monitoring:           YES
  1467:20171225:100447.411 IPMI monitoring:           YES
  1467:20171225:100447.411 Web monitoring:            YES
  1467:20171225:100447.411 VMware monitoring:         YES
  1467:20171225:100447.411 SMTP authentication:       YES
  1467:20171225:100447.411 Jabber notifications:      YES
  1467:20171225:100447.411 Ez Texting notifications:  YES
  1467:20171225:100447.411 ODBC:                      YES
  1467:20171225:100447.411 SSH2 support:              YES
  1467:20171225:100447.411 IPv6 support:              YES
  1467:20171225:100447.411 TLS support:               YES
  1467:20171225:100447.411 ******************************
  1467:20171225:100447.411 using configuration file: /etc/zabbix/zabbix_server.conf
  1467:20171225:100447.444 current database version (mandatory/optional): 03050016/03050016
  1467:20171225:100447.444 required mandatory version: 03050028
  1467:20171225:100447.444 starting automatic database upgrade
  1467:20171225:100447.445 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view get_discovered_hosts_without_dns depends on column "dns"
 [alter table dservices alter dns type varchar(255);
alter table dservices alter dns set default '']
  1467:20171225:100447.445 database upgrade failed

reverted back by applying a backup.
just noticed the version 4.0.0alpha1 after starting zabbix server again, maybe this thread should be moved to alpha/beta forum?
i thought i would upgrade to 3.5 stable by using source "http://repo.zabbix.com/zabbix/3.5/debian stretch main" in apt?

[volter]

Unless you modified anything in your database, this sounds like a bug that should be reported. But since Zabbix doesn't use Rules, I guess you may have done something there.

[glebs.ivanovskis]

view get_discovered_hosts_without_dns

This does not sound like default database schema.