Lost connection to MySQL server during query

[marafon4k]

Операционная система

Windows

Текст ошибки

Спойлер

L 04/13/2021 - 17:17:56: SourceMod error session started
L 04/13/2021 - 17:17:56: Info (map "seek_cache") (file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\errors_20210413.log")
L 04/13/2021 - 17:17:56: [SM] Unable to load plugin "levels_ranks\levelsranks_exstats_geoip.smx": Native "GeoipCity" was not found
L 04/13/2021 - 17:17:56: [SM] Fatal error encountered parsing translation file "lkcrash.phrases.txt"
L 04/13/2021 - 17:17:56: [SM] Error (line 0, column 0): Stream failed to open
L 04/13/2021 - 17:17:56: [SM] Unable to load plugin "name_reward.smx": Native "Store_GetClientCredits" was not found
L 04/13/2021 - 17:31:44: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/13/2021 - 17:31:44: [vip\VIP_Core.smx] SQL_Callback_OnClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 17:31:44: [Admins_Def.smx] [Admins] DB_GetAuthCallback: Lost connection to MySQL server during query
L 04/13/2021 - 17:31:44: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 17:31:44: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 17:32:12: [SM] Exception reported: Could not open file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\admin_Д_STEAM_1-0-571100037.log"
L 04/13/2021 - 17:32:12: [SM] Blaming: admin_logging_full.smx
L 04/13/2021 - 17:32:12: [SM] Call stack trace:
L 04/13/2021 - 17:32:12: [SM] [0] LogToFileEx
L 04/13/2021 - 17:32:12: [SM] [1] Line 129, admin_logging_full.sp::OnClientDisconnect
L 04/13/2021 - 17:32:20: [SM] Exception reported: Client 2 is not in game
L 04/13/2021 - 17:32:20: [SM] Blaming: WS_PunishModule.smx
L 04/13/2021 - 17:32:20: [SM] Call stack trace:
L 04/13/2021 - 17:32:20: [SM] [0] ForcePlayerSuicide
L 04/13/2021 - 17:32:20: [SM] [1] Line 345, E:\Git\ProWarnSystem\scripting\WS_PunishModule.sp::UTIL_SlayClient
L 04/13/2021 - 17:32:20: [SM] [2] Line 164, E:\Git\ProWarnSystem\scripting\WS_PunishModule.sp::OnPunishGetted
L 04/13/2021 - 17:43:23: [vip\VIP_Core.smx] SQL_Callback_OnVIPClientAdded: Lost connection to MySQL server during query
L 04/13/2021 - 17:43:33: [levelsranks.smx] Reconnect to the Database!
L 04/13/2021 - 17:43:33: [levelsranks.smx] Successfully! Attempt #0.
L 04/13/2021 - 17:43:40: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/13/2021 - 17:43:40: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 17:43:40: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 17:43:40: [weapons.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 18:01:17: [levels_ranks\levelsranks_exstats_maps.smx] [LR] Module - ExStats Maps : SQL_SaveDataPlayer - error while working with data (Lost connection to MySQL server during query)
L 04/13/2021 - 18:07:07: [mapchooser_extended.smx] No maps available for vote.
L 04/13/2021 - 18:07:51: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/13/2021 - 18:07:51: [vip\VIP_Core.smx] SQL_Callback_OnClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 18:07:51: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 18:07:52: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 18:23:47: [weapons.smx] Update Player failed! query: "UPDATE weapons SET knife_outdoor_trak_count = 11 WHERE steamid = 'STEAM_1:1:569032494'" error: "Lost connection to MySQL server during query"
L 04/13/2021 - 18:24:17: Error log file session closed.
L 04/13/2021 - 18:24:31: SourceMod error session started
L 04/13/2021 - 18:24:31: Info (map "seek_cache") (file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\errors_20210413.log")
L 04/13/2021 - 18:24:31: [SM] Unable to load plugin "levels_ranks\levelsranks_exstats_geoip.smx": Native "GeoipCity" was not found
L 04/13/2021 - 18:24:31: [SM] Fatal error encountered parsing translation file "lkcrash.phrases.txt"
L 04/13/2021 - 18:24:31: [SM] Error (line 0, column 0): Stream failed to open
L 04/13/2021 - 18:24:31: [SM] Unable to load plugin "name_reward.smx": Native "Store_GetClientCredits" was not found
L 04/13/2021 - 19:00:29: [SM] Exception reported: Could not open file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\admin_Д_STEAM_1-0-571100037.log"
L 04/13/2021 - 19:00:29: [SM] Blaming: admin_logging_full.smx
L 04/13/2021 - 19:00:29: [SM] Call stack trace:
L 04/13/2021 - 19:00:29: [SM] [0] LogToFileEx
L 04/13/2021 - 19:00:29: [SM] [1] Line 129, admin_logging_full.sp::OnClientDisconnect
L 04/13/2021 - 19:00:45: [mapchooser_extended.smx] No maps available for vote.
L 04/13/2021 - 19:03:38: Error log file session closed.
L 04/13/2021 - 19:03:39: SourceMod error session started
L 04/13/2021 - 19:03:39: Info (map "seek_cache") (file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\errors_20210413.log")
L 04/13/2021 - 19:03:39: [SM] Fatal error encountered parsing translation file "lkcrash.phrases.txt"
L 04/13/2021 - 19:03:39: [SM] Error (line 0, column 0): Stream failed to open
L 04/13/2021 - 19:03:41: [vip\VIP_Core.smx] SQL_Callback_SelectExpiredAndOutdated: Lost connection to MySQL server during query
L 04/13/2021 - 19:03:46: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/13/2021 - 19:03:46: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 19:03:46: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 19:36:02: [weapons.smx] Update Player failed! query: "UPDATE weapons SET knife_survival_bowie_trak_count = 8 WHERE steamid = 'STEAM_1:0:529691778'" error: "Lost connection to MySQL server during query"
L 04/13/2021 - 19:36:20: [SM] Exception reported: Could not open file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\admin_Д_STEAM_1-1-569032494.log"
L 04/13/2021 - 19:36:20: [SM] Blaming: admin_logging_full.smx
L 04/13/2021 - 19:36:20: [SM] Call stack trace:
L 04/13/2021 - 19:36:20: [SM] [0] LogToFileEx
L 04/13/2021 - 19:36:20: [SM] [1] Line 129, admin_logging_full.sp::OnClientDisconnect
L 04/13/2021 - 19:36:40: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/13/2021 - 19:36:40: [vip\VIP_Core.smx] SQL_Callback_OnClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 19:36:40: [Admins_Def.smx] [Admins] DB_GetAuthCallback: Lost connection to MySQL server during query
L 04/13/2021 - 19:36:40: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/13/2021 - 19:36:40: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/13/2021 - 19:45:15: [SM] Exception reported: Client index 5 is not valid
L 04/13/2021 - 19:45:15: [SM] Blaming: CSGO_CSS_RespawnHUD.smx
L 04/13/2021 - 19:45:15: [SM] Call stack trace:
L 04/13/2021 - 19:45:15: [SM] [0] CS_RespawnPlayer
L 04/13/2021 - 19:45:15: [SM] [1] Line 66, C:\Users\user\Desktop\–абота\scripting\CSGO_CSS_RespawnHUD.sp::Timer_Respawn

Есть 5 серверов с разными модами. Сегодня сделал Маньяк и постоянно вылетает связь с бд. С чем связано может быть и как исправить?
На остальных серверах все ок.
Спустя пару часов теперь ещё и крашит кс во время разрыва

 

[RusJJ]

Ты бы лучше ошибки колхозные пофиксил. Интересно наверное эвридей видеть эррор логи по десятку килобайт...

Спустя пару часов теперь ещё и крашит кс во время разрыва

Ожидаемо

С чем связано может быть и как исправить?

Где база данных и где сервер? База ко всем серверам коннект?

 

[marafon4k]

L 04/14/2021 - 15:28:05: SourceMod error session started
L 04/14/2021 - 15:28:05: Info (map "seek_warehouse") (file "d:\servers\gms\servers\3\serverfiles\csgo\addons\sourcemod\logs\errors_20210414.log")
L 04/14/2021 - 15:28:05: [vip\VIP_Core.smx] SQL_Callback_SelectExpiredAndOutdated: Lost connection to MySQL server during query
L 04/14/2021 - 15:28:05: [weapons.smx] Delete Inactive Player Data failed! query: "DELETE FROM weapons WHERE steamid in (SELECT steamid FROM weapons_timestamps WHERE last_seen < 1618403283 - (30 * 86400))" error: "Lost connection to MySQL server during query"
L 04/14/2021 - 15:28:16: [lk\lk_core.smx] Could not load the player, reason: Lost connection to MySQL server during query
L 04/14/2021 - 15:28:16: [Admins_Def.smx] [Admins] DB_GetAuthCallback: Lost connection to MySQL server during query
L 04/14/2021 - 15:28:16: [gloves.smx] Query failed! Lost connection to MySQL server during query
L 04/14/2021 - 15:28:16: [vip\VIP_TEST_1.0.3.smx] SQL_Callback_SelectClientAuthorized: Lost connection to MySQL server during query
L 04/14/2021 - 15:37:52: Error log file session closed.

Снова вылетает бд. Если выдаю випку после ее вылета, то крашит кс у всех почти кто на сервере