Zabbix

/*

** Copyright (C) 2001-2025 Zabbix SIA

**

** This program is free software: you can redistribute it and/or modify it under the terms of

** the GNU Affero General Public License as published by the Free Software Foundation, version 3.

**

** This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

** without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

** See the GNU Affero General Public License for more details.

**

** You should have received a copy of the GNU Affero General Public License along with this program.

** If not, see <https://www.gnu.org/licenses/>.

**/

​

#include "dbupgrade_common.h"

#include "dbupgrade.h"

​

#include "zbxdb.h"

#include "zbxdbhigh.h"

​

int delete_problems_with_nonexistent_object(void)

{

    zbx_db_result_t     result;

    zbx_vector_uint64_t eventids;

    zbx_db_row_t        row;

    zbx_uint64_t        eventid;

    int         sources[] = {EVENT_SOURCE_TRIGGERS, EVENT_SOURCE_INTERNAL};

    int         objects[] = {EVENT_OBJECT_ITEM, EVENT_OBJECT_LLDRULE}, i;

​

    zbx_vector_uint64_create(&eventids);

​

    for (i = 0; i < (int)ARRSIZE(sources); i++)

    {

        result = zbx_db_select(

                "select p.eventid"

                " from problem p"

                " where p.source=%d and p.object=%d and not exists ("

                    "select null"

                    " from triggers t"

                    " where t.triggerid=p.objectid"

                ")",

                sources[i], EVENT_OBJECT_TRIGGER);

​

        while (NULL != (row = zbx_db_fetch(result)))

        {

            ZBX_STR2UINT64(eventid, row[0]);

            zbx_vector_uint64_append(&eventids, eventid);

        }

        zbx_db_free_result(result);

    }

​

    for (i = 0; i < (int)ARRSIZE(objects); i++)

    {

        result = zbx_db_select(

                "select p.eventid"

                " from problem p"

                " where p.source=%d and p.object=%d and not exists ("

                    "select null"

                    " from items i"

                    " where i.itemid=p.objectid"

                ")",

                EVENT_SOURCE_INTERNAL, objects[i]);

​