Request denied after Migrate image

hshamy

Core license
License owner
Joined
Dec 14, 2017
Messages
46
Points
58
hello
i moved images to new external vps
and i make Migrate image by useing Migrate image tool
https://prnt.sc/m5fnir

images works fine
all url is work ...no image lost

but i start to have Request denied alot for uploading images
not all time ..
i try to open Debug level with 3 level but it Disabled
https://prnt.sc/m5fqxm
i cant chose level to give all report error_log

but that all i have now in error_log
[10-Jan-2019 11:59:35 America/Santiago] Request denied

i also notice that some times if i change name of same image ,,,, uploading is success ...
https://prnt.sc/m5fyfz
first upload you can see it give me Request denied
second one is success because i change name of image
its not Duplicated upload

also after do Migrate image i was have alot of that error
G\DBException: SQLSTATE[08004] [1040] Too many connections in /var/home/*com/public_html/lib/G/classes/class.db.php:100

is that hapend because

- some rong with sql after Migrate image ,,,, or
- just bad setup for external vps


thanks
 

Rodolfo

Chevereto Developer
Chevereto Staff
Joined
Oct 7, 2008
Messages
16,523
Points
237
Location
Chevereto HQ
Website
rodolfoberrios.com
The Storage migration thing only alters the image.image_storage_id column, it simply changes the storage ID associated with a given image and updates the storage stats. The task load is very low.

also after do Migrate image i was have alot of that error
G\DBException: SQLSTATE[08004] [1040] Too many connections in /var/home/*com/public_html/lib/G/classes/class.db.php:100
You should read this to get an idea on that error: https://stackoverflow.com/questions/1202322/mysql-error-too-many-connections

Connections means peers, which is related with people/actions being performed in your website. I can't think in any functionality causing issues here except the external storage queue handler. Basically, Chevereto doesn't remove external stored images on the fly, it uses a queue for doing that job and chances are that your users are trying to delete images but somehow your new external VPS is failing and the queue is being rescheduled. Even so, the queue handler stops after X failed attempts so this behavior should "stop" at some point (if that's the case anyway)

Is really hard to narrow down why you have too many connections, I strongly suggest you to debug your MySQL process. Read this: https://serverfault.com/questions/103767/php-mysql-how-to-debug-a-too-many-connections-error
 

hshamy

Core license
License owner
Joined
Dec 14, 2017
Messages
46
Points
58
thanks Rodolfo for quick response
i setup new chevereto with subdomain to make test
and i add new vps as extrnal storage from another company

i try to upload same images that i get Request denied with my main website
i get same error šŸ˜„

so i think maybe that error from sheard hosting
if that can be possible
if that can be iwill change the hosting


thanks
 
Last edited:
Reactions: Rodolfo