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.9.1 available

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

Manage - Duplicates causes 504 error

Hello,

recently our OCS server started having this problem - whenever one clicks on the Manage and then Duplicates menu (because we started having many duplicates [duh], but that's a problem for another time) the whole webapp just freezes until it spits 504 Gateway Time-Out error.

We are running OCS server v 2.9.1 on CentOS 8 VM. Right before the 504 error, the VM spikes the CPU usage to 100% all eaten by mysqld process, so obviously its a database issue.

Where would one start debugging this issue? Has anyone ever experienced something simmiliar?

All help would be greatly appreciated.
Thanks.

in OCS Inventory NG server for Unix by (160 points)
edited by

2 Answers

0 votes

I think this can help: "can you apply this PR on your server ? OCSInventory-NG/OCSInventory-Server#358 (https://github.com/OCSInventory-NG/OCSInventory-Server/pull/358/commits/66b7c1d0a402925641cb8ad222bdde3bd9785778)

It add more logs on duplicates merging. After applied, reload apache."

And also, don't forget to set in /etc/httpd/conf.d/z-ocsinventory-server.conf to have more debug info:
  PerlSetEnv OCS_OPT_DBI_PRINT_ERROR 1
by (4.2k points)
0 votes
We fixed the problem.

In the end, the solution was quite simple. Since there was so many duplicates (mostly MAC addresses and with combination with SN and hostname) server simply couldnt handle the requests in time... php, apache, nginx proxy all had too low timeout.

So we increased the timeouts, merged duplicates and now it works normally and fast.

Now to fix the cause of duplicates.

Thanks pchamorro for trying to help, I do appreciate it.
by (160 points)
 
Powered by Question2Answer
...