Jump to content

[RÉSOLU] Erreur 500 -> BDD avec : "exceeded the 'max_questions' ressource"

Asu34

By Asu34
in Discussion générale

 Share

Recommended Posts

Asu34 Community Regular

Asu34

Posted
Posted

Bonjour à tous,

Depuis ce matin j'ai mon site qui se retrouve HS avec erreur 500.
Débug m'indique l'objet ci-dessus, soit trop de requête sont effectuées...

J'ai regardé les logs serveurs et j'ai ceci en permanence sur toutes les dernières :
  

3.145.108.43 monsite.fr - [25/Nov/2024:10:47:03 +0100] "GET /31-materiels-pizzeria-professionnels?p=5&selected_filters=%2F%3Famp%3Famp%3Famp%3Fp%3D10%3Famp%3Fp%3D12%3Famp%3Famp%3Fp%3D12%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.142.200.247 monsite.fr - [25/Nov/2024:10:47:03 +0100] "GET /31-materiels-pizzeria-professionnels?selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Fp%3D8%3Famp%3Fp%3D11%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D11%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
18.118.146.180 monsite.fr - [25/Nov/2024:10:47:03 +0100] "GET /31-materiels-pizzeria-professionnels?selected_filters=%2F%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp%3Fp%3D5%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
18.226.17.251 monsite.fr - [25/Nov/2024:10:47:04 +0100] "GET /31-materiels-pizzeria-professionnels?p=12&selected_filters=%2F%3Famp%3Famp%3Famp%3Fp%3D11%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D11%3Fp%3D11%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.145.34.237 monsite.fr - [25/Nov/2024:10:47:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=12&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Fp%3D6%3Famp%3Famp%3Fp%3D12%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.129.216.15 monsite.fr - [25/Nov/2024:10:47:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=12&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D11%3Famp%3Famp%3Fp%3D8%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
18.225.56.79 monsite.fr - [25/Nov/2024:10:47:06 +0100] "GET /31-materiels-pizzeria-professionnels?p=9&selected_filters=%2F%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp%3Fp%3D9%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D7%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"

J'ai rajouté dans mon .htaccess :
  

# Bloquer Robot | ClaudeBot
RewriteCond %{HTTP_USER_AGENT} ClaudeBot [NC]
RewriteRule .* - [F,L]

Mais ça ne bloque visiblement pas ce robot.

Vous auriez une idée ? :(

Link to comment
Share on other sites
Asu34 Community Regular

Asu34

Posted
  • Author
Posted

Bon bizarre, j'ai téléversé le .htacess est ces lignes que j'avais mis en place :
  

# Bloquer Robot | ClaudeBot
RewriteCond %{HTTP_USER_AGENT} ClaudeBot [NC]
RewriteRule .* - [F,L]

n'y était plus.

Je pense à 2 trucs :
1 - il arrive à modifier mon .htacess
2 - dans la panique est-ce que je n'aurais pas remis l'ancien l'ancien .htacess qui ne contenait pas ce blocage ^^...

Je vais attendre...

Personne n'a eu de soucis avec ce robot déjà ?

Link to comment
Share on other sites
Asu34 Community Regular

Asu34

Posted
  • Author
Posted
7 minutes ago, Eolia said:

C'est surtout que Prestashop n'a pas corrigé ce bug historique de la navigation à facettes (les %3Famp en pagaille)

Tu penses que ça vient de ce module ?

Je viens à l'instant d'être de nouveau en erreur 500.
Avec dans les logs :
  

3.133.137.10 monsitediffusion.fr - [25/Nov/2024:11:22:04 +0100] "GET /31-materiels-pizzeria-professionnels?p=12&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Fp%3D5%3Famp%3Famp%3Fp%3D5%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D10%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
18.117.154.229 monsitediffusion.fr - [25/Nov/2024:11:22:04 +0100] "GET /31-materiels-pizzeria-professionnels?p=4&selected_filters=%2F%3Famp%3Famp%3Famp%3Fp%3D7%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D4 HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.142.172.190 monsitediffusion.fr - [25/Nov/2024:11:22:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=8&selected_filters=%2F%3Famp%3Famp%3Famp%3Fp%3D7%3Famp%3Famp%3Famp%3Fp%3D4%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D5%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.16.47.89 monsitediffusion.fr - [25/Nov/2024:11:22:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=12&selected_filters=%2F%3Famp%3Fp%3D11%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
18.117.154.134 monsitediffusion.fr - [25/Nov/2024:11:22:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=4&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D7%3Famp%3Famp%3Fp%3D4%3Famp%3Fp%3D6%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.128.226.128 monsitediffusion.fr - [25/Nov/2024:11:22:05 +0100] "GET /31-materiels-pizzeria-professionnels?p=10&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Fp%3D11%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D4%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D6%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.141.201.95 monsitediffusion.fr - [25/Nov/2024:11:22:06 +0100] "GET /31-materiels-pizzeria-professionnels?p=9&selected_filters=%2F%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Fp%3D7%3Fp%3D7%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
3.138.121.79 monsitediffusion.fr - [25/Nov/2024:11:22:06 +0100] "GET /31-materiels-pizzeria-professionnels?p=8&selected_filters=%2F%3Famp%3Famp%3Famp%3Famp%3Famp%3Fp%3D10%3Famp%3Famp%3Fp%3D9%3Famp%3Famp%3Famp%3Famp%3Fp%3D8%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp%3Famp HTTP/1.1" 500 2454 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"

Pourtant mon .htacess contient  toujours :
  

# Bloquer Robot | ClaudeBot
RewriteCond %{HTTP_USER_AGENT} ClaudeBot [NC]
RewriteRule .* - [F,L]

ça ne l'empêche de continuer à scrawler... 😕

Tu aurais une idée de ce que je pourrais faire ? :(

Link to comment
Share on other sites
Eolia Grand Master

Eolia

Posted
Posted (edited)

Pour le bloquer complètement : 

BrowserMatchNoCase "claudebot" bad_bot
Order Deny,Allow
Deny from env=bad_bot

Mais comme ce bot respecte le robots.txt il suffit d'ajouter cette ligne au robots.txt 

User-agent: ClaudeBot
Disallow: /

 

Edited by Eolia (see edit history)
Link to comment
Share on other sites
Asu34 Community Regular

Asu34

Posted
  • Author
Posted

@Eolia merci, 

J'ai ajouté dans le .htaccess
  

BrowserMatchNoCase "claudebot" bad_bot
Order Deny,Allow
Deny from env=bad_bot

et le robots.txt
  

User-agent: ClaudeBot
Disallow: /

ça a fonctionné 5 min. 
De nouveau en erreur 500. En debug j'ai ça maintenant :
  

[PrestaShopException]
PrestaShop Fatal error: no utf-8 support. Please check your server configuration.
at line 107 in file classes/db/DbPDO.php

102.             throw new PrestaShopException('Link to database cannot be established:'.$e->getMessage());
103.         }
104. 
105.         // UTF-8 support
106.         if ($this->link->exec('SET NAMES \'utf8\'') === false) {
107.             throw new PrestaShopException('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.');
108.         }
109. 
110.         $this->link->exec('SET SESSION sql_mode = \'\'');
111. 
112.         return $this->link;

:(

Link to comment
Share on other sites
Asu34 Community Regular

Asu34

Posted
  • Author
Posted
20 minutes ago, Eolia said:

Ben là c'est votre serveur qui ne suit pas...

Quelques minutes après ces précédentes insertions de lignes on dirait que c'est revenu à la normal.

Peux être qu'OVH bloque quelques minutes qd cela se produit.

Je surveille ça et espère que ça ne va pas se reproduire.

Merci encore @Eolia :)

Link to comment
Share on other sites
  • Asu34 changed the title to [RÉSOLU] Erreur 500 -> BDD avec : "exceeded the 'max_questions' ressource"
Asu34 Community Regular

Asu34

Posted
  • Author
Posted
Just now, Eolia said:

OVH à bannir définitivement.

Version quoi ? Moi c'est PhenixSuite, c'est 10 fois plus mieux !

Je l'ai testé et je confirme... mais va l'expliquer aux clients... (modules, paiements, transprteurs etc.) Compliqué.

Link to comment
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
Go to topic listing
×
×
  • Create New...