Hello.
I've been creating my site in D6 for months in offline mode without any major error. But whenever I tried to open it to the public, it totally freezes the webserver wich has other D5 installation, a couple of wordpress and a vbulletin forum.
This hang up comes sometimes after a certain time (like 30 minutes) and other times just after 2-3 minutes. I always had to restore my db manually to a previous (and offline state).
This morning my site gets frozen again but suddenly it started to work so I can put it again in offline mode and I discovered this errors in the log:
error php 31·12·09 Incorrect key file for table ... Anonymous
error php 31·12·09 Incorrect key file for table ... Anonymous
error php 31·12·09 Incorrect key file for table ... Anonymous
This errors expanded are like:
Tipo php
Fecha 31·12·2009 - 14:27
Usuario Anónimo
Ubicación http://mysite/taxonomy/term/65,180,369,101,438
Referente
Mensaje Incorrect key file for table '/tmp/#sql_32c8_0.MYI'; try to repair it query: SELECT td.vid, td.tid, td.name, COUNT(DISTINCT(n.nid)) AS count FROM term_data td INNER JOIN term_node tn ON tn.tid = td.tid INNER JOIN term_node tn0 ON tn.nid = tn0.nid INNER JOIN term_node tn1 ON tn.nid = tn1.nid INNER JOIN term_node tn2 ON tn.nid = tn2.nid INNER JOIN term_node tn3 ON tn.nid = tn3.nid INNER JOIN term_node tn4 ON tn.nid = tn4.nid INNER JOIN node n ON tn.nid = n.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ( td.vid IN (2) AND tn0.tid IN (65) AND tn1.tid IN (180) AND tn2.tid IN (369) AND tn3.tid IN (101) AND tn4.tid IN (438) AND n.status = 1 AND n.moderate = 0 )GROUP BY td.tid ORDER BY vid, weight, name en la línea 476 del archivo /home/macarro/www/sites/all/modules/taxonomy_filter/taxonomy_filter.module.
Severidad error
Nombre de la máquina 66.249.71.186 => WICH IS GOOGLE SPIDER
Operaciones
It seems related to #643698: Searchbot-TF collaboration kills MySQL but in my case the problem happens without too many terms, just 5.
As I said at the beginning, everything worked right in offline mode. So I assume the problem comes when Google is checking a cached URL.
By the way, the server hang up seems to come from an excesive consumption of memory:
4259 myuser 93468 kB /usr/local/php5/bin/php
8620 myuser 93468 kB /usr/local/php5/bin/php
15788 myuser 93468 kB /usr/local/php5/bin/php
20207 myuser 93468 kB /usr/local/php5/bin/php
25880 myuser 93468 kB /usr/local/php5/bin/php
31436 myuser 93468 kB /usr/local/php5/bin/php
29393 myuser 93340 kB /usr/local/php5/bin/php
Regards, thanks in advance... and happy new year ;)
Comments
Comment #1
solotandem commentedRead this comment regarding a significant performance improvement. I believe this change should fix this issue as well.
Let me know if you see the same degree of performance improvement. I encourage others who read this issue to report their findings.