Оочень долгая загрузка vip/lvl/rank/admin

Тема в разделе "Counter-Strike: Global Offensive", создана пользователем B1g, 18 ноя 2015.

  1. B1g

    B1g

    Сообщения:
    703
    Симпатии:
    24
    Такое дело , сервера на винде, не лагают, choke и loss по нулям , но получение данных с баз випа , ранк и тд , ну очень долгое , т.е лагов нет , ничего не дергается и не виснет , но прикол после захода на сервер , админка и вип даются минут через 5, а то и больше , а иногда могут и не даться. а лвл ранк вообще сбрасывается до сильвера. Думал дело в производительности ПК , перенес 1 сервер который больше всего потреблял но отдельную машину. Но проблема осталась!
    В логи срет этим:
    L 11/18/2015 - 00:09:51: SourceMod error session started
    L 11/18/2015 - 00:09:51: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 00:09:51: [UPDATER] --- BEGIN ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 00:09:51: [UPDATER] Could not download "http://update.sourcemod.net/update/"
    L 11/18/2015 - 00:09:51: [UPDATER] Error: Failure when receiving data from the peer
    L 11/18/2015 - 00:09:51: [UPDATER] --- END ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 00:09:51: Error log file session closed.
    L 11/18/2015 - 00:42:50: SourceMod error session started
    L 11/18/2015 - 00:42:50: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 00:42:50: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 00:55:56: Error log file session closed.
    L 11/18/2015 - 06:37:15: SourceMod error session started
    L 11/18/2015 - 06:37:15: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 06:37:15: [rankme_connect_announcer.smx] RankMe Unloaded. Plugin won't work.
    L 11/18/2015 - 06:37:15: Error log file session closed.
    L 11/18/2015 - 06:37:36: SourceMod error session started
    L 11/18/2015 - 06:37:36: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 06:37:36: [UPDATER] --- BEGIN ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 06:37:36: [UPDATER] Could not download "http://update.sourcemod.net/update/"
    L 11/18/2015 - 06:37:36: [UPDATER] Error: Failure when receiving data from the peer
    L 11/18/2015 - 06:37:36: [UPDATER] --- END ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 06:50:12: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 07:22:20: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 07:22:20: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 07:22:20: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 07:23:10: Error log file session closed.
    L 11/18/2015 - 07:50:27: SourceMod error session started
    L 11/18/2015 - 07:50:27: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 07:50:27: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 08:03:28: SourceMod error session started
    L 11/18/2015 - 08:03:28: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 08:03:28: [rankme_connect_announcer.smx] RankMe Unloaded. Plugin won't work.
    L 11/18/2015 - 08:03:54: SourceMod error session started
    L 11/18/2015 - 08:03:54: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 08:03:54: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 08:49:39: Error log file session closed.
    L 11/18/2015 - 10:12:55: SourceMod error session started
    L 11/18/2015 - 10:12:55: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 10:12:55: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 10:12:55: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 10:12:55: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 10:13:03: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 10:13:03: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 10:13:03: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 10:13:08: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 10:13:08: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 10:13:08: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 10:13:17: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 10:13:17: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 10:13:17: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 10:20:45: Error log file session closed.
    L 11/18/2015 - 10:44:48: SourceMod error session started
    L 11/18/2015 - 10:44:48: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 10:44:48: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 11:06:15: Error log file session closed.
    L 11/18/2015 - 12:01:13: SourceMod error session started
    L 11/18/2015 - 12:01:13: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 12:01:13: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 12:18:59: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 12:36:37: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 12:37:31: Error log file session closed.
    L 11/18/2015 - 12:37:51: SourceMod error session started
    L 11/18/2015 - 12:37:51: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 12:37:51: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 12:56:41: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 13:22:55: Error log file session closed.
    L 11/18/2015 - 13:23:45: SourceMod error session started
    L 11/18/2015 - 13:23:45: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 13:23:45: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 14:03:54: [rankme_connect_announcer.smx] RankMe Unloaded. Plugin won't work.
    L 11/18/2015 - 14:03:54: Error log file session closed.
    L 11/18/2015 - 14:04:07: SourceMod error session started
    L 11/18/2015 - 14:04:07: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 14:04:07: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 14:04:13: [UPDATER] --- BEGIN ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 14:04:13: [UPDATER] Could not download "http://update.sourcemod.net/update/"
    L 11/18/2015 - 14:04:13: [UPDATER] Error: Failure when receiving data from the peer
    L 11/18/2015 - 14:04:13: [UPDATER] --- END ERRORS FROM AUTOMATIC UPDATER ---
    L 11/18/2015 - 14:24:41: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 14:35:52: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 14:49:51: Error log file session closed.
    L 11/18/2015 - 14:50:21: SourceMod error session started
    L 11/18/2015 - 14:50:21: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 14:50:21: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 15:35:40: Error log file session closed.
    L 11/18/2015 - 15:37:37: SourceMod error session started
    L 11/18/2015 - 15:37:37: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 15:37:37: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 15:37:42: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 15:44:47: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 15:47:03: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 15:56:50: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:09:13: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:14:08: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:14:56: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:20:14: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:21:21: Error log file session closed.
    L 11/18/2015 - 16:21:30: SourceMod error session started
    L 11/18/2015 - 16:21:30: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 16:21:30: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:33:49: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:49:34: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 16:54:42: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:04:07: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:06:46: Error log file session closed.
    L 11/18/2015 - 17:18:57: SourceMod error session started
    L 11/18/2015 - 17:18:57: Info (map "awp_lego_2") (file "errors_20151118.log")
    L 11/18/2015 - 17:18:57: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:19:38: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:20:22: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:23:24: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:26:01: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 17:26:08: [LevelsRanks_Core.smx] SQL_LoadPlayerCallback failure: Lost connection to MySQL server during query
    L 11/18/2015 - 12:38:55: [SM] Native "SQL_FetchString" reported: Invalid query Handle e283d0b3 (error: 4)
    L 11/18/2015 - 12:38:55: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 12:38:55: [SM] [0] Line 1388, rankme/cmds.inc::SQL_RankCallback()
    L 11/18/2015 - 12:39:11: [SM] Native "SQL_FetchString" reported: Invalid query Handle e283d0b3 (error: 4)
    L 11/18/2015 - 12:39:11: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 12:39:11: [SM] [0] Line 1388, rankme/cmds.inc::SQL_RankCallback()
    Все базы данных в МУСКУЛЕ кроме стандартных сорсмодовских... Уже не знаю что делать , сервера раскручены , но эту проблему не могу побороть никак :(
    Прошу помощи!

    Добавлено через 1 минуту
    Линукс ставить не предлагать , пробовал , так же проблема. ВДС тоже не предлогать , мой ПК достаточно производителен. 4 ядра по 3 герца (интел) и 6 ГБ РАМ , думаю он должен тянуть 3 сервера по 22 слота.
     
    Последнее редактирование: 18 ноя 2015
  2. White Wolf

    White Wolf [] (int _n) -> double { return (_n % 2) == 0;}); Супер-модератор

    Сообщения:
    1.188
    Симпатии:
    413
    B1g, играешь тоже на том компьютере?
     
  3. B1g

    B1g

    Сообщения:
    703
    Симпатии:
    24
    Нет, даже стим не запускаю , ничего на нем не запущенно кроме серверов.

    Добавлено через 24 минуты
    Может дело в утечке памяти?
    L 11/18/2015 - 10:13:17: [SM] Plugin encountered error 17: Stack memory leaked by native
    L 11/18/2015 - 10:13:17: [SM] Displaying call stack trace for plugin "rankme.smx":
    L 11/18/2015 - 10:13:17: [SM] [0] Line 1405, rankme/cmds.inc::SQL_RankCallback()
    Можно это как нибудь исправить? Файл cmds.inc и исходник RankMe.

    Добавлено через 5 часов 44 минуты
    Не поверите все исправилось когда отключил плагины : http://hlmod.ru/forum/novye-plaginy/11333-rankme-connect-announcer.html и http://hlmod.ru/forum/utverjdionnye-plaginy/26392-rank-info-dopolnenie-dlya-rankme.html , странно конечно но всё же :)
     
    Последнее редактирование: 19 ноя 2015