Ad Widget

Collapse

Zabbix 6 cannot import template after migration from MySQL to TimescaleDB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tuxmartin
    Junior Member
    • Jan 2017
    • 12

    #1

    Zabbix 6 cannot import template after migration from MySQL to TimescaleDB

    Last week I migrated our Zabbix server (6.0.17) database from MySQL (Percona 8.0.32) to the TimescaleDB (PostgreSQL 14.7.1, TimescaleDB 2.9.3) using pgloader.

    Everything works great, and all data is present.

    Yesterday I tried to import some Zabbix templates. One of them was PostgreSQL by Zabbix agent and second my template from another Zabbix server.
    The import was successful (without any error). But on https://zabbix.example.net/templates.php there is no imported template. If I try to import the template again, I get an info box: "Templates: No changes.".

    How can I fix it? It is a blocking problem for me because I need to import some new templates.
    Attached Files
  • Glencoe
    Zabbix developer
    • Oct 2019
    • 152

    #2
    Are you sure the templates are not there? Try pressing "Reset" in templates.php and repeat your search.

    Comment

    • tuxmartin
      Junior Member
      • Jan 2017
      • 12

      #3
      Glencoe yes, I'm sure. I tried different web browser, restart postgresql and zabbix server. Still the same problem.

      Comment

      • tuxmartin
        Junior Member
        • Jan 2017
        • 12

        #4
        I already solved it. Triggers were missing in the database.

        Comment

        Working...