processing on items attached to a template that no longer exists

[bvivi57]

Hello,

Our zabbix platform (6.2.4) crashes permanently on Utilization of preprocessing manager processes.

We can increase the pooler but it does not change anything.

We followed the elements found here: https://support.zabbix.com/browse/ZBX-20874

The items we identify that are at the origin of the preprocessing jobs, give us a template that does not exist.

  itemid:264093 values:1
==
== preprocessing diagnostic information ==
Values:89371 done:83148 queued:0 processing:1048 pending:5175 time:1.258213
Top.values:
  itemid:488374 values:10 steps:0
  itemid:488470 values:10 steps:0
​

Example for the item 488374

We query the zabbix API

{
    "jsonrpc": "2.0",
    "method": "item.get",
    "params": {
        "output": "extend",
        "itemids": "488374",
        "sortfield": "name"
    },
    "auth": "3b3dc3ff02726f6af0a05503bee6e11d",
    "id": 1
}​

The API returns that the item belongs to template 487741

 {
            "itemid": "488374",
            "type": "0",
            "snmp_oid": "",
            "hostid": "13383",
            "name": "Uptime",
            "key_": "system.uptime",
            "delay": "30s",
            "history": "2w",
            "trends": "0d",
            "status": "0",
            "value_type": "3",
            "trapper_hosts": "",
            "units": "uptime",
            "formula": "",
            "logtimefmt": "",
            "templateid": "487741",
            "valuemapid": "0",
            "params": "",
            "ipmi_sensor": "",
            "authtype": "0",
            "username": "",
            "password": "",
            "publickey": "",
            "privatekey": "",
            "flags": "0",
            "interfaceid": "2839",
            "description": "System uptime in 'N days, hh:mm:ss' format.",​

Except that if we query the zabbix API to know the details of this template :

{
    "jsonrpc": "2.0",
    "method": "template.get",
    "params": {
        "output": "extend",
        "templateids": "487741"
    },
    "auth": "3b3dc3ff02726f6af0a05503bee6e11d",
    "id": 1
} zz0.q7js1oiikrrzz

The API tells us that the template does not exist, even when we try to delete it.

{
    "jsonrpc": "2.0",
    "result": [],
    "id": 1
} zz0.ai2399ospsazz

{
    "jsonrpc": "2.0",
    "error": {
        "code": -32500,
        "message": "Application error.",
        "data": "No permissions to referred object or it does not exist!"
    },
    "id": 1
} zz0.z8o51nv3bzzz

We don't understand where these checks come from and how to stop them. The platform does not hold anymore and our supervision is failing (we have already greatly revised the dimensioning of the server and the database, it does not change anything)

How can we clean up and remove these phantom items/templates?