Some MySQL errors

Started by wonder22, June 03, 2008, 09:30:51 AM

Previous topic - Next topic

wonder22

As I understand this can be something related to the MySQL server. But if any of you encounter the same problems and have a fix (just in case) I like to share them with you:

1.

Lost connection to MySQL server during query


INSERT INTO smf_log_errors(id_member, log_time, ip, url, message, session, error_type, file, line)
VALUES
(0, 1212493021, SUBSTRING('74.6.22.103', 1, 16), SUBSTRING('?topic=46263.msg546321', 1, 65534), SUBSTRING('Eroare în baza de date: Server shutdown in progress


UPDATE smf_topics
SET num_views = num_views + 1
WHERE id_topic = 46263', 1, 65534), '40c7efe266fdf48ed1cda69247f3bf5b', 'database', SUBSTRING('/home/quebec/public_html/forum/Sources/Display.php', 1, 255), 174)
Apply Filter: Only show the errors from this file
File: /home/quebec/public_html/forum/Sources/Errors.php
Line: 150
=================================================================
2.
Database error: Unknown error


INSERT IGNORE INTO smf_log_search_results
(id_search, relevance, id_topic, id_msg, num_matches)
SELECT
139,
1000 * (30 * COUNT(*) / (MAX(t.num_replies) + 1) + 25 * CASE WHEN MAX(m.id_msg) < 423464 THEN 0 ELSE (MAX(m.id_msg) - 423464) / 181485 END + 20 * CASE WHEN MAX(t.num_replies) < 200 THEN MAX(t.num_replies) / 200 ELSE 1 END + 15 * CASE WHEN MAX(lst.id_topic) IS NULL THEN 0 ELSE 1 END + 10 * CASE WHEN MIN(m.id_msg) = MAX(t.id_first_msg) THEN 1 ELSE 0 END + 0 * MAX(t.is_sticky)) / 100 AS relevance,
t.id_topic,
MAX(m.id_msg) AS id_msg,
COUNT(*) AS num_matches
FROM smf_topics AS t
INNER JOIN smf_messages AS m ON (m.id_topic = hxxp:t.id [nonactive]_topic)
LEFT JOIN smf_tmp_log_search_topics AS lst ON (lst.id_topic = hxxp:t.id [nonactive]_topic)
WHERE m.body LIKE '%ankh%'
AND hxxp:m.id [nonactive]_board IN (15, 32, 33, 35, 7, 29, 11, 25, 23, 14, 6, 1, 48, 5, 50, 24, 30, 37, 38, 39, 40, 41, 43, 47, 49, 22, 36, 34, 44, 8, 10, 46, 13, 3, 9, 4, 2)
GROUP BY hxxp:t.id [nonactive]_topic
LIMIT 6000
===================================================

3.
Database error: Server shutdown in progress


UPDATE smf_topics
SET num_views = num_views + 1
WHERE id_topic = 46263

====================================================

Those 3 errors are frequently showing up in my Database log. I'm running smf 2.0 beta 3 with php5.

Thanks for any kind of feedback.


Oldiesmann

You will need to talk to your host about the "lost connection" and "server shutdown in progress" errors. It's hard to say what could be causing the "Unknown error" error, but I'm guessing it's related to the other two.

wonder22

Quote from: Oldiesmann on June 03, 2008, 10:48:06 AM
You will need to talk to your host about the "lost connection" and "server shutdown in progress" errors. It's hard to say what could be causing the "Unknown error" error, but I'm guessing it's related to the other two.
Thanks,
I will contact the host.

wonder22

Hi that's the answer they gave me today for the 2 reported errors:

We have a script in place that terminates any queries lasting longer than 15 seconds. After which it will display the error you are seeing. You will need to break up your queries into ones that will complete within 15 seconds of running.

Do you think that's something normal?

Thanks.

Sarge

The queries in 1. and 3. are quite simple queries and shouldn't last more than 15 seconds.


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Advertisement: