Ad Widget

Collapse

Issues adding primary keys to TimescaleDB v2.x

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MarGeta
    Junior Member
    • Nov 2021
    • 6

    #1

    Issues adding primary keys to TimescaleDB v2.x

    I am trying to upgrade the primary keys after going from Zabbix 5.4 to 6.0

    I have done the steps for adding primary keys using TimescaleDB v2.x as per the documentation here: https://www.zabbix.com/documentation...b_primary_keys

    I repeated the steps for each table
    history
    history_log
    history_str
    history_text
    history_uint

    I do however still get the error message database could be upgraded to use primary keys in history tables at startup.
    Is there any way to confirm why this is? I did not receive any obvious errors when running the script.

    Zabbix started normally and the data is all there, it just seems like the patch to add primary keys did not do anything.
Working...