Error 500 & 504 - how to deep dive ? - RAM DB Exceeded

[martin_88]

Hello,

I have a store on OVH Perf1. My store is still in development and I have no client at all. Around 11 000 products.

I don't know why I always have a 500 error or a 504. Even if I activate the debug mode, I don’t have more information on the reason why it is stuck.

Error 500 : Server connection not responding
Error 504: Backend unavailable

On my OVH data base I see that the RAM 512 is exceeded. In the log :

07/11/2020 10:51 stderr 2020-11-07T09:51:26.585667Z 7355 [Note] Aborted connection 7355 to db: xxx user: xxx host: '10.8.113.107' (Got an error reading communication packets)

07/11/2020 11:16 stderr 2020-11-07T10:16:17.110648Z 7525 [Note] Got an error reading communication packets

Config on OVH :

-        PHP 7.2

-        CPU : 1x vCore

-        RAM : 2 Go

-        CND – Activated

-        Drive – 500 go

-        Private MySQL Database :

o   RAM 512 –EXCEEDED 5 time last 3 days.

o   Max_allowad_paket : 16M

o   Wait_timeout : 600

o   Innobd_buffer_pool_sie : 2048 M

o   Max_user_connections : 150

o   Mac_connections : 300

o   Interactive_timeout : 600

o   Tmpdir : /dev/shm

o   Autocommit : On

o   Envent_scheduler : Off

PS Config :

-        1.7.6.

 

Generally, it is blocked for a few times and then if works again for a while. Then I have an issue and it take 10 minutes to log in the backend of open the front end and generally it ends up with the error 500.

 

Do you have any idea how I can debug this and understand deeper what is the issue ?

EDIT : attachemnt logs.docx

 

Log.docx

Edited November 7, 2020 by martin_88 (see edit history)

[musicmaster]

You say you have no client. But as long as the server is on the internet there can still be hackers, search engines, etc scanning your server and causing mysql queries.