Проблемы с кроном

MAXAGENT · 23 Апр 2012

Здравствуйте! В общем поставил движок, все отлично установилось и все работало, но примерно через 2 месяца трекер слетел сам по себе. В данный момент не работает в статистике трекера отображение скорости, а также не ведется учет сколько пользователь скачал и раздал. Помогите пожалуйста решить проблему.

Ошибки sql_error_bb.log

Код:

#002006 MySQL server has gone away
 
UPDATE buf_last_seeder b, bb_bt_torrents tor SET tor.seeder_last_seen = b.seeder_last_seen WHERE tor.topic_id = b.topic_id
 
Source  : includes/cron/jobs/tr_update_seeder_last_seen.php(13) :: db1.torrent
IP      :
Date    : 2012-04-05 19:38:16
Agent  :
Req_URI :
Referer :
Method  :
PID    : 04187
Request : Array
(
)______________________________________________________________________________
 
#002006 MySQL server has gone away
 
SELECT RELEASE_LOCK('torrent_cron') AS lock_result
 
Source  :  :: db1.torrent
IP      :
Date    : 2012-04-05 19:38:16
Agent  :
Req_URI :
Referer :
Method  :
PID    : 04187
Request : Array
(
)______________________________________________________________________________

Ошибки sql_slow_bb.log

Код:

1334789420 | 04-19 02:50:20 | 19    | 2.9  | 26005 | db1 | CREATE TABLE new_bt_last_torstat LIKE bb_bt_last_torstat # includes/cron/jobs/tr_cleanup_and_dlstat.php(19) cron
1334790845 | 04-19 03:14:05 | 35    | 3.8  | 28139 | db1 | CREATE TABLE new_tracker_snap LIKE bb_bt_tracker_snap # includes/cron/jobs/tr_make_snapshot.php(15) cron
1334790881 | 04-19 03:14:40 | 77    | 6.6  | 28139 | db1 | CREATE TABLE new_dlstatus_snap LIKE bb_bt_dlstatus_snap # includes/cron/jobs/tr_make_snapshot.php(77) cron
1334790958 | 04-19 03:15:57 | 71    | 6.8  | 28139 | db1 | CREATE TABLE new_torhelp LIKE bb_bt_torhelp # includes/cron/jobs/tr_make_snapshot.php(119) cron
1334794818 | 04-19 04:20:18 | 22    | 6    | 01375 | db1 | REPLACE INTO bb_config (config_name, config_value) VALUES ('cron_last_check', 1334794811) # 2 rows # includes/functions.php(1298)
1334795164 | 04-19 04:26:04 | 11    | 3.2  | 01679 | db1 | CREATE TABLE new_tracker_snap LIKE bb_bt_tracker_snap # includes/cron/jobs/tr_make_snapshot.php(15) cron
1334901604 | 04-20 10:00:03 | 17    | 2.6  | 09705 | db1 | CREATE TABLE new_tracker_snap LIKE bb_bt_tracker_snap # includes/cron/jobs/tr_make_snapshot.php(15) cron
1334912404 | 04-20 13:00:04 | 33    | 1.7  | 26026 | db1 | CREATE TABLE new_tracker_snap LIKE bb_bt_tracker_snap # includes/cron/jobs/tr_make_snapshot.php(15) cron
1334980804 | 04-21 08:00:03 | 37    | 2.4  | 19770 | db1 | CREATE TABLE new_tracker_snap LIKE bb_bt_tracker_snap # includes/cron/jobs/tr_make_snapshot.php(15) cron

Ошибки sql_slow_tr.log

Код:

04-19 02:57:43 | 016 | 5.0 |  |  # 1 rows | bt/scrape.php(53)
04-19 03:01:45 | 032 | 7.8 |  |  # 1 rows | bt/announce.php(245)
04-19 03:01:45 | 032 | 7.8 | SELECT COUNT(DISTINCT topic_id) AS active_torrents FROM bb_bt_tracker WHERE user_id = 972 AND seeder = 0 AND topic_id != 321 GROUP BY user_id |  # 1 rows | bt/announce.php(296)
04-19 03:01:45 | 032 | 7.8 |  |  # 1 rows | bt/announce.php(245)
04-19 03:01:45 | 032 | 7.8 |  |  # 1 rows | bt/announce.php(245)
04-19 03:04:32 | 016 | 5.7 |  |  # 1 rows | bt/announce.php(245)
04-19 03:05:47 | 025 | 7.8 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('6f8bdc0711ea17c549d12851aaec0172', 180, 472, '5f3acdfa', 36353, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334790322) |  # 2 rows | bt/announce.php(411)
04-19 03:06:20 | 015 | 6.5 |  |  # 1 rows | bt/announce.php(245)
04-19 03:15:57 | 035 | 6.6 | SELECT COUNT(DISTINCT topic_id) AS active_torrents FROM bb_bt_tracker WHERE user_id = 335 AND seeder = 0 AND topic_id != 478 AND update_time > 1334787323 GROUP BY user_id |  # 1 rows | bt/announce.php(296)
04-19 03:15:57 | 039 | 6.6 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('c0591e975dffbe0993fc9863794b408a', 588, 524, '5f3b0374', 39568, 1, 1, 0, 15581184, 0, 0, 0, 0, 0, 0, 1334790919) |  # 2 rows | bt/announce.php(411)
04-19 03:15:57 | 024 | 6.6 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('c45bd50086099065fabbb3e3f7f16464', 587, 524, '5f3b0374', 39568, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1334790934) |  # 2 rows | bt/announce.php(411)
04-19 03:15:57 | 027 | 6.6 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('743bd5794fe50d15684b5c4e39555adb', 356, 543, '0286b3a6', 6663, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334790931) |  # 2 rows | bt/announce.php(411)
04-19 03:17:08 | 040 | 6.8 |  |  # 1 rows | bt/announce.php(245)
04-19 03:17:08 | 043 | 6.8 |  |  # 1 rows | bt/announce.php(245)
04-19 03:19:08 | 011 | 5.3 |  |  # 1 rows | bt/announce.php(245)
04-19 03:19:08 | 031 | 5.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('f5c9aa1e901b4d6ca3590e1b019f5dcf', 323, 823, '5c2f0482', 49069, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334791116) |  # 2 rows | bt/announce.php(411)
04-19 03:19:08 | 022 | 5.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('f9e9d16d842868276f0024c14e052494', 579, 524, '5f3b0374', 39568, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1334791126) |  # 2 rows | bt/announce.php(411)
04-19 03:19:08 | 024 | 5.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('0f55f191064eb2702001a51680c96a1b', 97, 543, '0286b3a6', 6663, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334791123) |  # 2 rows | bt/announce.php(411)
04-19 03:24:48 | 016 | 4.3 |  |  # 1 rows | bt/announce.php(245)
04-19 03:24:48 | 012 | 4.3 |  |  # 1 rows | bt/announce.php(245)
04-19 04:01:35 | 011 | 3.0 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('6a23159011aeb5b4acbbebb4da78ac41', 194, 301, '5c2fc2ec', 18347, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334793684) |  # 2 rows | bt/announce.php(411)
04-19 04:01:35 | 013 | 3.0 | SELECT COUNT(DISTINCT topic_id) AS active_torrents FROM bb_bt_tracker WHERE user_id = 823 AND seeder = 0 AND topic_id != 71 GROUP BY user_id |  # 1 rows | bt/announce.php(296)
04-19 04:02:31 | 012 | 2.4 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('69d86f0701e7534d0ef62a2ce7648729', 427, 335, 'b25af39f', 35691, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334793733) |  # 2 rows | bt/announce.php(411)
04-19 04:02:31 | 012 | 2.4 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('3c59536b735cc5a378df921d233c4e61', 522, 301, '5c2fc2ec', 18347, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1334793733) |  # 2 rows | bt/announce.php(411)
04-19 04:08:12 | 013 | 2.9 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('a34472b0301b3a3fa72353c39636c777', 619, 1897, 'b25a299a', 63072, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1334794076) |  # 2 rows | bt/announce.php(411)
04-19 04:09:19 | 015 | 4.8 |  |  #  | bt/announce.php(245)
04-19 04:11:33 | 077 | 8.6 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('b9cb9cea229c263c2c9577df81f4fd7c', 590, 2028, '5c2f720d', 20401, 1, 0, 0, 0, 1470197760, 0, 0, 0, 0, 0, 1334794215) |  # 2 rows | bt/announce.php(411)
04-19 04:11:33 | 076 | 8.6 | SELECT COUNT(DISTINCT topic_id) AS active_torrents FROM bb_bt_tracker WHERE user_id = 335 AND seeder = 0 AND topic_id != 478 AND update_time > 1334790616 GROUP BY user_id |  # 1 rows | bt/announce.php(296)
04-19 04:29:04 | 012 | 4.1 |  |  # 1 rows | bt/announce.php(245)
04-19 04:29:21 | 017 | 4.9 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('d5241063e6c01eb45daba68e4559d107', 505, 472, '5f3acdfa', 36353, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1334795344) |  # 2 rows | bt/announce.php(411)
04-19 04:30:15 | 036 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:30:15 | 032 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:30:15 | 028 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:30:15 | 035 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:30:15 | 028 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:30:15 | 030 | 5.8 |  |  # 1 rows | bt/announce.php(245)
04-19 04:36:39 | 029 | 3.6 |  |  # 1 rows | bt/announce.php(245)
04-19 04:36:39 | 021 | 3.6 |  |  # 1 rows | bt/announce.php(245)
04-19 04:36:39 | 027 | 3.6 |  |  # 1 rows | bt/announce.php(245)
04-19 20:00:23 | 014 | 1.8 |  |  #  | bt/announce.php(245)
04-20 20:00:42 | 010 | 1.4 |  |  # 1 rows | bt/announce.php(245)
04-21 05:00:41 | 012 | 1.9 | SELECT ip, port FROM bb_bt_tracker WHERE topic_id = 611 ORDER BY RAND() LIMIT 50 |  # 5 rows | bt/announce.php(455)
04-21 05:00:41 | 012 | 1.9 |  |  # 1 rows | bt/announce.php(245)
04-21 05:00:41 | 012 | 1.9 |  |  # 1 rows | bt/announce.php(245)
04-21 13:00:53 | 018 | 2.7 |  |  # 1 rows | bt/announce.php(245)
04-21 14:45:57 | 018 | 3.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('d92d32f9ab6e0a4184ec05b030deb53d', 627, 3, 'd49af93e', 6911, 1, 1, 0, 1476475797, 0, 0, 0, 0, 0, 0, 1335005140) |  # 2 rows | bt/announce.php(411)
04-21 14:45:57 | 017 | 3.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('c1adf8f0fe7a8f464b04d1b5630d688f', 590, 3, 'd49af93e', 6911, 1, 1, 0, 1160814738, 0, 0, 0, 0, 0, 0, 1335005141) |  # 2 rows | bt/announce.php(411)
04-21 14:45:57 | 017 | 3.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('e9f2001c0487b50db2a6312ea3454ddd', 631, 4, 'd49af93e', 6911, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1335005141) |  # 2 rows | bt/announce.php(411)
04-21 14:45:57 | 016 | 3.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('2ae5c7d639c43258af1bb9742c044eed', 404, 3, 'd49af93e', 6911, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1335005141) |  # 2 rows | bt/announce.php(411)
04-21 14:45:57 | 018 | 3.3 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('2326c70873a6c25e1db1597e7f1365e7', 264, 3, 'd49af93e', 6911, 1, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1335005139) |  # 2 rows | bt/announce.php(411)
04-21 19:00:29 | 013 | 1.7 |  |  #  | bt/announce.php(245)
04-21 21:12:59 | 015 | 2.1 |  |  # 1 rows | bt/announce.php(245)
04-22 09:19:09 | 019 | 7.8 |  |  # 1 rows | bt/announce.php(245)
04-22 09:24:29 | 019 | 6.6 |  |  # 1 rows | bt/scrape.php(53)
04-22 13:00:40 | 019 | 1.3 |  |  # 1 rows | bt/announce.php(245)
04-22 13:00:40 | 018 | 1.3 |  |  # 1 rows | bt/announce.php(245)
04-22 17:00:22 | 011 | 1.8 | REPLACE INTO bb_bt_tracker (peer_hash, topic_id, user_id, ip, port, seeder, releaser, tor_type, uploaded, downloaded, remain, speed_up, speed_down, up_add, down_add, update_time) VALUES ('6329c3a8695a784b4bdb3b55ce267875', 208, 844, '5c2ff2bb', 16532, 1, 0, 0, 320432128, 0, 0, 0, 0, 0, 0, 1335099611) |  # 1 rows | bt/announce.php(411)

Gemini_13 · 23 Апр 2012

#002006 MySQL server has gone away

MAXAGENT · 23 Апр 2012

Gemini_13 написал(а):
#002006 MySQL server has gone away

Предлагаете перезапустить MySQL?

Gemini_13 · 23 Апр 2012

MAXAGENT, я просто процетировал ошибку. это значит, что нет связи с мускулом. либо ребут, либо запуск мускула. а еше лучше найти причину его падений и устранить и о проблеме забудете с чистой душой

kenny · 23 Апр 2012

MAXAGENT, говорит что сервер убежал, догоняй скорее!!!!!! А то скроется вдали

А если серьезно проверяем логи, этого вашего монстроскуэля.

MAXAGENT · 23 Апр 2012

Gemini_13,
Причина падения понятна, иногда сам хост перезагружает сервак. Возможно ведутся какие-то работы...
Сейчас перезапустил MySQL и вот какие ошибки теперь.

Ошибки sql_error_tr.log

Код:

#000000 not connected
 
connect
 
Source  : bt/announce.php(234)
IP      : 95.58.201.106
Date    : 2012-04-23 12:06:58
Agent  : uTorrent/2200(23071)
Req_URI : /bt/announce.php?uk=J0MY1EqExA&info_hash=%d9%3b%a7%00%8a%c6%9a%7c%23%2a%90%d1%f7%b6%e4L%3d%13_%c9&peer_id=-UT2200-%1fZ%c7%16%07%c2%bf%ef%1f%d2P%fa&port=35691&uploaded=0&downloaded=0&left=2028978855&corrupt=0&key=F02B81EC&event=started&numwant=200&compact=1&no_peer_id=1&ipv6=fe80%3a%3a21b%3afcff%3afe2b%3a27e1
Referer :
Method  : GET
Request : Array
(
    [uk] => J0MY1EqExA
    [info_hash] => Щ;§ownloaded] => 0
    [left] => 0
    [corrupt] => 0
    [key] => 76D25418
    [numwant] => 200
    [compact] => 1
    [no_peer_id] => 1
)______________________________________________________________________________
 
#000000 not connected
 
connect
 
Source  : bt/announce.php(234)
IP      : 2.135.29.108
Date    : 2012-04-23 12:07:03
Agent  : uTorrent/3120(26773)
Req_URI : /bt/announce.php?uk=rRn1oVQZFf&info_hash=%e5%d3~%f4%7f%d6%dd%bc%3e%bd%7b%27%8a%3f%ca%a9%d5%fb%98F&peer_id=-UT3120-%95h%07%1b%19%fc%87%0e%914%8e%ac&port=14671&uploaded=0&downloaded=0&left=13557694464&corrupt=0&key=1C34689D&event=started&numwant=200&compact=1&no_peer_id=1&ipv6=2001%3a0%3a4137%3a9e76%3a34ca%3a2ff3%3afd78%3ae293
Referer :
Method  : GET
Request : Array
(
    [uk] => rRn1oVQZFf
    [info_hash] => еУ~фЦЭј>Ѕ{'Љ?К©ХыF
    [peer_id] => -UT3120-•hь‡‘4Ћ¬
    [port] => 14671
    [uploaded] => 0
    [downloaded] => 0
    [left] => 13557694464
    [corrupt] => 0
    [key] => 1C34689D
    [event] => started
    [numwant] => 200
    [compact] => 1
    [no_peer_id] => 1
    [ipv6] => 2001:0:4137:9e76:34ca:2ff3:fd78:e293
)______________________________________________________________________________
 
#000000 not connected
 
connect
 
Source  : bt/announce.php(234)
IP      : 178.91.163.5
Date    : 2012-04-23 12:07:03
Agent  : uTorrent/3120(26773)
Req_URI : /bt/announce.php?uk=n06BeZ88yj&&info_hash=%91%a3%de%d1%d3%09%0eC%fa%01%da%1f~%e3%8d%99Q%a31%14&peer_id=-UT3120-%95hd%11v%f9K%3cp%d5I%86&port=55290&uploaded=0&downloaded=0&left=0&corrupt=0&key=63433520&numwant=200&compact=1&no_peer_id=1
Referer :
Method  : GET
Request : Array
(
    [uk] => n06BeZ88yj
    [info_hash] => ‘ЈЮСУ    CъЪ~гЌ™QЈ1
    [peer_id] => -UT3120-•hdvщK<pХI†
    [port] => 55290
    [uploaded] => 0
    [downloaded] => 0
    [left] => 0
    [corrupt] => 0
    [key] => 63433520
    [numwant] => 200
    [compact] => 1
    [no_peer_id] => 1
)______________________________________________________________________________
 
#000000 not connected
 
connect
 
Source  : bt/scrape.php(45)
IP      : 178.91.163.5
Date    : 2012-04-23 12:07:04
Agent  : uTorrent/3120(26773)
Req_URI : /bt/scrape.php?uk=n06BeZ88yj&&info_hash=%91%a3%de%d1%d3%09%0eC%fa%01%da%1f~%e3%8d%99Q%a31%14
Referer :
Method  : GET
Request : Array
(
    [uk] => n06BeZ88yj
    [info_hash] => ‘ЈЮСУ    CъЪ~гЌ™QЈ1
)______________________________________________________________________________

Lange · 23 Апр 2012

Код:

#000000 not connected

MAXAGENT · 23 Апр 2012

В общем понятно все. Здесь никто не шарит глубоко в TorrentPier II. Спрашивается, зачем тогда нужен этот форум? Знаю - поприкалываться как модератор kenny. Никакой серьезности у администрации и ответственности.

kenny · 23 Апр 2012

Школьники совсем уже оборзели!
За вас что тут думать обязаны?
Да я стебался и буду стебаться над глупостью и нежеланием думать!
Уже и так ответили на вопрос,если в гугле бан никто не виноват

Lange · 23 Апр 2012

kenny, ох жаль тебя, особенно когда в тебя грязью кидается школота

Проблемы с кроном

MAXAGENT

Gemini_13

MAXAGENT

Gemini_13

kenny

MAXAGENT

Lange

MAXAGENT

kenny

Lange