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"

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...