Ad Widget

Collapse

Problem with migrate 3.0.2 Mysql to 3.2 Postgresql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mobil1
    Junior Member
    • Apr 2017
    • 3

    #1

    Problem with migrate 3.0.2 Mysql to 3.2 Postgresql

    I am create new DB in postgress and copy by py-mysql2pgsql configs tables. After i copy tables i see error:
    Code:
    –The frontend does not match Zabbix database. Current database version (mandatory/optional): 3010000/3010000. Required mandatory version: 3020000. Contact your system administrator.
    In logs zabbix-server:
    Code:
    14310:20170402:125749.476 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: index "history_log_2" does not exist
    [drop index history_log_2]
    I am create index
    Code:
    CREATE INDEX history_log_2 ON history_log USING btree (itemid, clock);
    but it is not help for resolving this problem.
  • doctorbal82
    Member
    • Oct 2016
    • 39

    #2
    This happened to me when I upgraded from Zabbix 3.0 to 3.2 except I was just using PostgreSQL. I ended up rebuilding the whole environment from scratch as it was still small, thus my answer to your riddle isn't the best but maybe kloczek's post will help you from my initial post: https://www.zabbix.com/forum/showthread.php?t=55699.

    Comment

    Working...