Ad Widget

Collapse

only getting the last day's data after PostgreSQL Partitioning Zabbix 3.0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • adam_smith@sundance.org
    Junior Member
    • Jun 2015
    • 3

    #1

    only getting the last day's data after PostgreSQL Partitioning Zabbix 3.0

    I'm having an issue after partitioning my Postgresql database.

    I used this guide to partition the data.
    Join the friendly and open Zabbix community on our forums and social media platforms.



    After partitioning and creating a cronjob to drop the history tables that are 7 days old and trends after 12 months old, I only get the last days worth of data.

    I am on ubuntu using zabbix 3.0.1 originally installed with 3.0
    PostgreSQL version is 9.3.11
    Last edited by [email protected]; 14-04-2016, 19:53. Reason: added the wrong partitioning guide
  • adam_smith@sundance.org
    Junior Member
    • Jun 2015
    • 3

    #2
    I think I found the issue

    I thought that the numbers submitted in the function were going to be variables in the function somewhere, however they are hardcoded and as such the system corrupts the data if you put different numbers in than what is hardcoded in the delete function.

    Comment

    • kloczek
      Senior Member
      • Jun 2006
      • 1771

      #3
      Originally posted by [email protected]
      I thought that the numbers submitted in the function were going to be variables in the function somewhere, however they are hardcoded and as such the system corrupts the data if you put different numbers in than what is hardcoded in the delete function.
      Administration -> General -> Housekeeping -> and uncheck "Enable internal housekeeping" on History and Trends.
      http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
      https://kloczek.wordpress.com/
      zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
      My zabbix templates https://github.com/kloczek/zabbix-templates

      Comment

      • adam_smith@sundance.org
        Junior Member
        • Jun 2015
        • 3

        #4
        Thanks I didn't see this, however my previous post still seems to have mostly fixed the problem. I was totally unaware that area of the administration tab existed.

        Comment

        Working...