Lighhouse stopped working after auditting all sites

Hello, I installed and tried the Lighthouse extension which is amazing :slight_smile: First I tried the first 15 reports, then I stopped loading, looked at the reports and everything worked great. So I decided to click on the “Audit all sites” button, which is 281 sites. Everything went fine.

Since then, the Lighhouse extension settings page says “There has been a critical error on this website” and the default Manage Sites overview page won’t load either - I get a JS error “DataTables warning: table id=mainwp-manage-sites-table - Ajax error.”. I tried disabling “Optimize for shared hosting or big networks” - then the error disappears, but the pages on Manage Sites still don’t load. When I deactivate the Lighthouse extension, everything loads fine. Changing PHP versions didn’t help either.

Then i discovered, that the _mainwp_lighthouse table is 258 MB (for 281 sites). By gradually deleting rows from this table, I got up to 199 sites and at that point everything started working again.

Is there some limitation in the php, mysql, or plugin settings that I should modify to be able to keep Lighthouse data on all (200+) sites?

Thank you for your help.

Hey @softmedia

Welcome to the MainWP community.

It’s possible that the issue can be resolved by increasing the WP / PHP memory limits of your server.

Can you please post the community system report from your MainWP Dashboard so we can take a look at the current settings?
The report is located in your Dashboard under Info → Server, on the top right of the page.

Be sure to use the button like the one below; this button hides all your private information:

image

Pressing the button auto-copies the report to your clipboard then just paste it in a reply here.

Ok, here it is :slight_smile:


### WordPress Check                Required                                               Detected                                     Status   ###

FileSystem Method                  = direct                                               direct                                       Pass        
MultiSite Disabled                 =true                                                  true                                         Pass        
WordPress Memory Limit             >=64M                                                  512M                                         Pass        
WordPress Version                  >=6.2                                                  6.4.3                                        Pass        

### PHP                            Required                                               Detected                                     Status   ###

cURL Extension Enabled             =true                                                  true                                         Pass        
cURL Timeout                       >=300 seconds                                          300                                          Pass        
cURL Version                       >=7.29.0                                               7.64.0                                       Pass        
OpenSSL Version                    >=OpenSSL/1.1.0                                        OpenSSL/1.1.1n                               Pass        
OpenSSL Working Status             Yes                                                    Yes                                          Pass        
PCRE Backtracking Limit            >=10000                                                1000000                                      Pass        
PHP Allow URL fopen                N/A                                                    YES                                                      
PHP Disabled Functions             N/A                                                    backtick,  dl,  eval,  exec,  is_executable,  leak,  passthru,  pclose,  pcntl_alarm,  pcntl_exec,  pcntl_fork,  pcntl_get_last_error,  pcntl_getpriority,  pcntl_setpriority,  pcntl_signal,  pcntl_signal_dispatch,  pcntl_sigprocmask,  pcntl_sigtimedwait,  pcntl_sigwaitinfo,  pcntl_strerror,  pcntl_wait,  pcntl_waitpid,  pcntl_wexitstatus,  pcntl_wifexited,  pcntl_wifsignaled,  pcntl_wifstopped,  pcntl_wstopsig,  pcntl_wtermsig,  popen,  posix_getpwuid,  posix_kill,  posix_mkfifo,  posix_setpgid,  posix_setsid,  posix_setuid,  posix_uname,  proc_close,  proc_get_status,  proc_nice,  proc_open,  proc_terminate,  putenv,  shell_exec,  show_source,  socket_connect,  socket_create,  socket_last_error,  socket_read,  socket_select,  socket_set_nonblock,  socket_set_option,  socket_strerror,  syslog,  system,  zlib_decode, apache_child_terminate,            
PHP Exif Support                   N/A                                                    YES                                                      
PHP IPTC Support                   N/A                                                    YES                                                      
PHP Loaded Extensions              N/A                                                    Core, FFI, PDO, PDO_Firebird, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, igbinary, imagick, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_dblib, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, pspell, random, readline, redis, session, shmop, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib            
PHP Max Execution Time             >=30 seconds                                           600                                          Pass        
PHP Max Input Time                 >=30 seconds                                           600                                          Pass        
PHP Memory Limit                   >=256M                                                 512M                                         Pass        
PHP Post Max Size                  >=2M                                                   500M                                         Pass        
PHP Safe Mode Disabled             =true                                                  true                                         Pass        
PHP Upload Max Filesize            >=2M                                                   500M                                         Pass        
PHP Version                        >=7.4                                                  8.2.15                                       Pass        
PHP XML Support                    N/A                                                    YES                                                      
SSL Extension Enabled              =true                                                  true                                         Pass        
SSL Warnings                       = empty                                                error:24070079:random number generator:RAND_write_file:Cannot open file
error:2406F079:random number generator:RAND_load_file:Cannot open fileWarning     

### MySQL                          Required                                               Detected                                     Status   ###

MySQL Client Encoding              N/A                                                    utf8mb4                                                  
MySQL Mode                         N/A                                                    ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION            
MySQL Version                      >=5.0                                                  10.3.39-MariaDB-0+deb10u2                    Pass        

### Server Configuration           Detected Value                                      ###

Accept Content                     text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
Accept-Charset Content             N/A                                                    
Architecture                       64		 bit                                               
Gateway Interface                  CGI/1.1                                                
HTTPS                              ON                                                     
Memory Usage                       16.81 MB                                               
Operating System                   Linux                                                  
Request Time                       1708952169                                             
Server Protocol                    HTTP/2.0                                               
Server self connect                Not expected HTTP response body:                       
Server Software                    nginx/1.14.2                                           
User Agent                         Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36

### MainWP Dashboard Settings      Detected Value                                      ###

Abandoned plugins/themes tolerance 365                                                    
Basic uptime monitoring enabled    No                                                     
MainWP Dashboard Version           Latest: 4.6.0.1 | Detected: 4.6.0.1 Pass               
MainWP legacy backups enabled      Yes                                                    
Maximum number of pages to return  50                                                     
Maximum number of posts to return  10                                                     
Maximum simultaneous install and update requests24                                                     
Maximum simultaneous requests      16                                                     
Maximum simultaneous requests per ip12                                                     
Maximum simultaneous sync requests 36                                                     
Minimum delay between requests     200                                                    
Minimum delay between requests to the same ip2000                                                   
Number of connected sites          293                                                    
Optimize for shared hosting or big networksYes                                                    
Plugin advanced automatic updates enabledNo                                                     
Primary Backup System              MainWP UpdraftPlus Extension                           
REST API enabled                   Yes                                                    
Site health monitoring enabled     No                                                     
Theme advanced automatic updates enabledNo                                                     
Use WP Cron                        Yes                                                    
WP Core advanced automatic updates enabledNo                                                     

### Extensions                     Version                                                License                                      Status   ###

Activity Log for MainWP            2.1.1                                                                                                           
Advanced Uptime Monitor Extension  5.2.2                                                  Active                                       Pass        
MainWP Cache Control Extension     4.0.3                                                  Inactive                                     Warning     
MainWP Lighthouse Extension        4.0.5                                                  Active                                       Pass        
MainWP UpdraftPlus Extension       4.0.10                                                 Active                                       Pass        
MainWP White Label Extension       4.1.4                                                  Active                                       Pass        
MainWP Wordfence Extension         4.0.10                                                 Active                                       Pass        

### Plugin                         Version                                                Status                                    ###

Activity Log for MainWP            2.1.1                                                  Active                                       
Maintenance Mode                   2.4.4                                                  Active                                       
MainWP Child                       4.6                                                    Active                                       
MainWP Dashboard                   4.6.0.1                                                Active                                       
Post SMTP                          2.8.11                                                 Active                                       
Really Simple SSL                  7.2.3                                                  Inactive                                     
Simple 301 Redirects               2.0.9                                                  Inactive                                     
Softmedia Basic Stats              1.3.1                                                  Active                                       
Solid Security Basic               9.3.1                                                  Inactive                                     
UpdraftPlus - Backup/Restore       1.24.1                                                 Active                                       

Thanks for the system report.

We recommend 512MB for the Dashboard with over 100 child sites, so for your dashboard with 293 sites, we’d recommend you try setting PHP Memory and WP Memory to 1024MB and cURL Timeout to 600.

After that, try auditing all your sites again and see if that helps resolve the issue.

1 Like

You’re a genius :slight_smile: it works! Thank you so much.

2 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.