Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.11.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Duplicate entry '2147483647' for key 'PRIMARY'

My ocs database is not being updated anymore (ocs server and agents are That is happening from the very moment that below error message is registered in Apache error.log :

DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'PRIMARY' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.

The ocurrence of the issue suddenly started some days ago, after some two weeks when I started to update the ocs windows agent. So I could think is something related to the last agent.
in OCS Inventory NG server for Unix by (4.6k points)

1 Answer

0 votes

I changed the type of the ID column in software table from INT to BIGINT and it seems that solved my issue.

"INT has a maximum signed value of 2147483647. Any number greater than that will be truncated to that value."

For some reason, my IDs in the software table are too big.

by (4.6k points)
Powered by Question2Answer