Manage - Duplicates causes 504 error

Question

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.

Answer 1

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

Answer 2

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.