Zabbix events and event_suppress table doesn't udpate

[Arvind_94]

I use Zabbix 4.0. It is a very large system and gradually we're upgrading to the latest version.
The issue I am facing is when maintenance is applied I cannot see any problem even after selecting the ""show suppressed problems " option. I am setting up maintenance with data collection. The older problems still show though with a spanner icon next to it.(it shows even without selecting the show suppressed events option).
In the zabbix server log I see the error

query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "event_suppress" violates foreign key constraint "c_event_suppress_1"

Postgresql complains of

ERROR: insert or update on table "event_suppress" violates foreign key constraint "c_event_suppress_1"
DETAIL: Key (eventid)=(xxx) is not present in table "events".
STATEMENT: insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_u ntil) values (xx,xx,xx,xx);

The events table isn't getting updated, but if so where is this eventid coming from?
How do I go about troubleshooting this?

[cyber]

IIRC there is a table "ids" where last value for id-s are stored and updated. I have seen here couple of times, that people have had some values out of sync and then such errors start to appear...

[Arvind_94]

I do see the ids table.. Any idea how I can try to brig it back in sync?

[cyber]

Update it to correct one... But I cannot remember was there a "last one used" or "next one to use" ..:P