search

cachethq / cachet

🚦 The open-source status page system.
https://cachethq.io
MIT License
14.01k stars 1.56k forks source link

Import Subscribers #4409

Closed Artic6 closed 3 months ago

Artic6 commented 3 months ago

I am trying to import 11,920 subscribers, its accepted the list but the server is giving me lots of HTTP 500 errors - the "to busy to handle you request" not the "apache 500 error"

However they are importing, I will give it more time, however what I have observed is the counter for Subscribers is stuck on 1143 but the list of the subscribers when you scroll though is more than 1143?

Is this a bug in the counting, or are we trying to subscribe to many subscribers and will this give us issue when sending updates to that many people?

image

Artic6 commented 3 months ago

Right it does go up, but you need to add them slowly however after getting to just over 2050 subscribers when you click on the subscribers you get this all the time now, which means I cannot add anymore subscribers.....

image

I get this is not suitable for lots of people over 2000 ?

Artic6 commented 3 months ago

In the time it took me to write that update, the server does recover briefly, however now when not even clicking on subscribers I get the error from the previous post all the time, I guess I need to use a distribution list - which people cannot manage their subscriptions......

image

I will give it some more time to see if it recovers again.

Artic6 commented 3 months ago

it does make me wonder if I need to increase the size of the memory allocation for PHP and Apache

I wonder if the server is literally getting to its upper limits of the allocated resources which is why the error is happening

Artic6 commented 3 months ago

I have all the Subscribers imported that is 10,250 - however when I try to login to the Dashboard it does not load and returns me to the main status page screen ?

Why would it do this ? Cannot see anything in the logs?

Artic6 commented 3 months ago

All these issue are around PHP not having the memory allocation :

[Thu Jul 04 08:24:29.019806 2024] [php7:error] [pid 2788] [client 10.245.186.77:59493] PHP Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/Cachet/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php on line 389, referer:

PHP now requires a 2GB max memory size and this seems to work, however am I going to get other issue sending to all those subscribers?

Artic6 commented 3 months ago

I’ve also figured this one out myself