Jump to content

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


martin_88
 Share

Recommended Posts

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 by martin_88 (see edit history)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More