Ad Widget

Collapse

7.0.2 to 7.0.4 error:null value in column "value" of relation "housekeeper"..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • daizhilong
    Junior Member
    • Sep 2024
    • 4

    #1

    7.0.2 to 7.0.4 error:null value in column "value" of relation "housekeeper"..

    My Zabbix server was upgraded from 7.0.2 to 7.0.4. The upgrade process was normal. After the upgrade, error logs appeared in zabbix-server.log at a frequency of 15 per minute for two days. However, it does not affect the normal operation of the zabbix-server.


    Thank you very much for your help

    System environment: CentOS 8.2
    Database: TimescaleDB 2.15.2 (PG14)

    error logs:
    [
    191085:20240926:213340.224 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: null value in column "value" of relation "housekeeper" violates not-null constraint
    DETAIL: Failing row contains (28633535, events, itemid, null).
    [insert into housekeeper (housekeeperid,tablename,field,value) values (28633535,'events','itemid',null);
    ]

    Click image for larger version

Name:	zabbix update error.png
Views:	186
Size:	197.9 KB
ID:	491835
    ​​​
    Attached Files
Working...