1 to 100 of 687951 (estimate) errors and website gone

[BFD Calendar]

My provider shut down my website www.birthfactdeathcalendar.net because my database is getting more requests than the Web Hosting plan can handle.

Matomo statistics tell me I have an average of 60 visitors a day.

But I'm getting plenty of errors - like 100 in one minute - in the ProcessWire log for all kinds of page requests:

• Error: Exception: SQLSTATE[42000] [1226] User 'birthfacbfdcal' has exceeded the 'max_questions' resource (current value: 8780)
  In /wire/core/WireDatabasePDO.php line 549

This started after upgrading from ProcessWire 3.0.123 to ProcessWire 3.0.246.

How can I solve this problem? I'm trying to go back to a provider backup from two weeks ago, before the ProcessWire upgrade, hoping to get my website back. For now I can still get into the ProcessWire 3.0.246 admin pages but I don't know for how long. I have several sql backups of my site and made a site profile today. Again I'm not sure how safe it will be to use them without running into the same problem — as long as I don't know what's causing them and how to solve them.

If anybody can help....

[BFD Calendar]

Update. I restored to a backup from two weeks ago provided by my provider. Now I'm getting an error on both front and back end:

Fatal Error: Uncaught Error: Class 'ProcessWire\InputfieldText' not found in /home/birthfac/www/wire/modules/Inputfield/InputfieldName.module:7
Stack trace:
#0 /home/birthfac/www/wire/core/Modules.php(1545): include_once()
#1 /home/birthfac/www/wire/core/Modules.php(1502): ProcessWire\Modules->includeModuleFile('/home/birthfac/...', 'InputfieldName')
#2 /home/birthfac/www/wire/core/WireClassLoader.php(202): ProcessWire\Modules->includeModule(Object(ProcessWire\ModulePlaceholder))
#3 [internal function]: ProcessWire\WireClassLoader->loadClass('ProcessWire\\Inp...')
#4 /home/birthfac/www/wire/modules/Inputfield/InputfieldPageName/InputfieldPageName.module(20): spl_autoload_call('ProcessWire\\Inp...')
#5 /home/birthfac/www/wire/core/Modules.php(1545): include_once('/home/birthfac/...')
#6 /home/birthfac/www/wire/core/Modules.php(1502): ProcessWire\Modules->includeModuleFile('/home/birthfac/...', 'InputfieldPageN...')
#7 /home/birthfac/www/wire/core/WireClassLoader.php(202): ProcessWire\Modules->includeModule(Object(ProcessWi (line 7 of /home/birthfac/www/wire/modules/Inputfield/InputfieldName.module)

This error message was shown because: you are logged in as a Superuser. Error has been logged.

How to solve this?

[matjazp]

I suspect that restore was not complete, maybe some files are missing or permissions are not correct? Can you roll back to PW 3.0.123?

[ryan]

@BFD Calendar You can usually downgrade PW as easily as upgrading it, so I would probably just replace the /wire/ with the 3.0.123 version that was working well before. But I think it's unlikely that the version change is the issue, as newer versions are generally more efficient and reliable than older versions. For most sites a version upgrade like this would help the situation. Though there could be something unique in this case, who knows. I would guess you got hit by an AI bot (or a bunch of them) that went nuts and used up the resource limits. If you are hitting this query limit regularly, then your web host would need to increase the resources for your site, or you'd want to upgrade to a plan with more resources. An alternative would be to use WireRequestBlocker to keep the bots from consuming all the resources, and/or using ProCache so that most output can be cached and not hit the database. The most recent error that you posted sounds like something is missing on the file system (per what Matjaz mentioned), or that PHP's opcache needs to be cleared, perhaps a call to opcache_reset() could help matters. 

[BFD Calendar]

@ryan Well there were quite a few errors that occured after the upgrade from PW 3.0.123 and PHP 7.x to 8.2. Like in all templates "$feature->template==bfd_events" didn't work and needed change to "$feature->template=='bfd_events'".  Or "$webimage = $page->images->random()->url;" no longer worked. I managed to find out everything and got the site back working, when the above mentioned errors started appearing and my provider shut down the site. I went back two weeks in time with a backup option from my provider to make sure I'd get it all as it was before upgrading anything. But now I only see the first lines of the site, and the admin site is no longer reachable: internal error or misconfiguration. Even downgrading to PW 3.0.98 doesn't make any difference and of course now I can't even see any error logs as admin.

Other pages like https://www.birthfactdeathcalendar.net/phpinfo.php load normal. With my provider I upgraded my hosting to allow more resources.

The AI bot option might be the culprit, could it be Google trying to crawl/index the whole site? There are over 30.000 pages.... Report from Google Search Console: https://search.google.com/search-console/index/drilldown?resource_id=sc-domain%3Abirthfactdeathcalendar.net&pages=ALL_URLS&hl=en&sharing_key=N-nvEOUPuUWWfngX3zI85w.

[psy]

13 hours ago, matjazp said:

I suspect that restore was not complete, maybe some files are missing or permissions are not correct? Can you roll back to PW 3.0.123?

Had a similar nightmare today. Nothing to do with PW itself. Some files were corrupted during upload to the site.

Fix was to do a manual PW upgrade, ie:

1. rename wire dir to .wire-3.0.xxx (whatever version) and do the same for index.php
2. upload clean wire directory and index.php
3. To be on the safe side, I also re-uploaded site files I knew were clean

Everything then worked 100% as expected.

Hope this helps

 

[BFD Calendar]

@psy That's an option indeed. First I'll ask my provider why the backup version was restored corrupted. I do have older PW wire versions on my site, but none of them managed to get anything back. While I usually only add/edit pages and change almost nothing to modules or other PW settings.

[psy]

17 minutes ago, BFD Calendar said:

I do have older PW wire versions on my site

I didn't have the same version of PW locally either. I went to PW github and downloaded the next release version from what was on the site.