на обсуждении Логи сервера

WinWoolF

Пользователь
В логах постоянно появляются записи MySQL server has gone away.

#002006 MySQL server has gone away

SELECT RELEASE_LOCK('admin_mttntp_cron') AS lock_result

Source : :: db1.admin_mttntp
IP : 93.170.169.103
Date : 2016-06-08 06:35:24
Agent : Wget/1.13.4 (linux-gnu)
Req_URI : /cron.php
Referer :
Method : GET
PID : 17363
Request : Array
(
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271717 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=272002
Referer :
Method : GET
PID : 03602
Request : Array
(
[p] => 272002
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271723 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=272008
Referer :
Method : GET
PID : 03581
Request : Array
(
[p] => 272008
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271714 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=271999
Referer :
Method : GET
PID : 03683
Request : Array
(
[p] => 271999
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271719 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=272004
Referer :
Method : GET
PID : 03595
Request : Array
(
[p] => 272004
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 33132 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 66.249.66.135
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (compatible; Googlebot/2.1; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?t=33132
Referer :
Method : GET
PID : 02787
Request : Array
(
[t] => 33132
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271724 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=272009
Referer :
Method : GET
PID : 03589
Request : Array
(
[p] => 272009
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 237259 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 66.249.66.139
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (compatible; Googlebot/2.1; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?p=237516
Referer :
Method : GET
PID : 02535
Request : Array
(
[p] => 237516
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 68317 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?t=68317
Referer :
Method : GET
PID : 03320
Request : Array
(
[t] => 68317
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 52247 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 66.249.66.130
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?t=52247
Referer :
Method : GET
PID : 03306
Request : Array
(
[t] => 52247
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 145978 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 130.193.37.18
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (compatible; YandexBot/3.0; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?p=145979
Referer :
Method : GET
PID : 03587
Request : Array
(
[p] => 145979
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 22022 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 66.249.66.135
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (compatible; Googlebot/2.1; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?t=22022
Referer :
Method : GET
PID : 03318
Request : Array
(
[t] => 22022
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 214797 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 66.249.66.135
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (compatible; Googlebot/2.1; +

Please Login or Register to view hidden text.

)
Req_URI : /viewtopic.php?p=214804
Referer :
Method : GET
PID : 02532
Request : Array
(
[p] => 214804
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 68316 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?t=68316
Referer :
Method : GET
PID : 03308
Request : Array
(
[t] => 68316
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 68319 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?t=68319
Referer :
Method : GET
PID : 03571
Request : Array
(
[t] => 68319
)______________________________________________________________________________

#002006 MySQL server has gone away

SELECT u.username, u.user_id, u.user_rank, u.user_posts, u.user_from, u.user_regdate, u.user_sig, u.avatar_ext_id, u.user_opt, u.user_gender, u.user_birthday, p.*, g.group_name, g.group_id, g.group_signature, g.avatar_ext_id as rg_avatar_id, u2.username as mc_username, u2.user_rank as mc_user_rank, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) LEFT JOIN bb_users u2 ON(u2.user_id = p.mc_user_id) LEFT JOIN bb_groups g ON(g.group_id = p.poster_rg_id) WHERE p.topic_id = 271720 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 15

Source : viewtopic.php(404) :: db1.admin_mttntp
IP : 195.182.131.107
Date : 2016-06-08 06:35:25
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.1) Gecko/2008070208
Req_URI : /viewtopic.php?p=272005
Referer :
Method : GET
PID : 03585
Request : Array
(
[p] => 272005
)______________________________________________________________________________
Насколько я понимаю, это говорит о том, что сервер закрывает соединение в результате долго таймаута. Но как видно с логов это происходит только с ботами поисковиков, неужели боты столь долгое время ни чего не делают, что сервер прерывает ихние сессии? Хотелось бы избавиться от этих записей в логах, но при этом увеличивать в конфиге время wait_timeout из за ботов желания тоже нет.
 

Exile

Администратор
WinWoolF, боты просто запускают крон-задачу, вот из-за нее сервер и уходит в оффлайн. Попробуйте запустить все крон-задачи поочередно, чтобы понять, какая убивает сервер.
 

WinWoolF

Пользователь
Attach maintenance и Board maintenance вот эти две стали вешать при каждом запуске после того как на трекере стало более 270к раздач и я их отрубил в админке, все остальные работают без нареканий даже по несколько сразу.
 

Exile

Администратор
WinWoolF, ну я так и думал собственно. В новой версии обработки аттачей вообще нет, а общая задача сильно упрощена будет. Так что сейчас пока что отключить - не самый плохой вариант, особо критичного там ничего нет.
 
Сверху