Items increment in Zabbix 2.2

[FineMEDIA]

Hi,

I need info where in Zabbix 2.2 is stored last item id.When i added new item to database with sql query i have this info: '[Duplicate entry '123110' for key 'PRIMARY']' . I don't want to remove sql added items.

Best regards,

[Atsushi]

Have you added values directly to the database?
If you want to add directly in the database, you need to add data that is consistent.
It is not recommended to manipulate the database directly.

Depending on the item, you may be able to add item values using the zabbix_sender command.
You can also create a file and register the value of an item with a specific time stamp.

https://www.zabbix.com/documentation/2.2/manpages/zabbix_sender

[FineMEDIA]

Hi,

Thanks for response. Now i need information how can i repair this. I don;t wanna remove inserted data from database.

[kernbug]

Hi,

Thanks for response. Now i need information how can i repair this. I don;t wanna remove inserted data from database.

Hi

Backup and try to replace table, example:

https://www.tutorialspoint.com/mysql/mysql-handling-duplicates.htm

[FineMEDIA]

Do you know where intems_id couter are stored? In database or some config file?

[kernbug]

Do you know where intems_id couter are stored? In database or some config file?

Database, items table, also get a backup and check foreign keys before doing something.