ResetStats

[D1esel]

Ошибка

[AMXX] Run time error 10 (plugin "csstats_mysql.amxx") (native "SQL_ThreadQuery")

ОС

Linux

Amx Mod X

MX Mod X 1.9.0.5294

Билд

ReHLDS version: 3.14.0.838-dev

ReGamedll

ReGameDLL version: 5.27.0.724-dev

Версия Metamod

Metamod-r v1.3.0.150, API (5:13)

Список метамодулей

description     stat pend  file                        vers             src  load  unload

          [ 1] Reunion         RUN   -    reunion_mm_i386.so          v0.2.0.13        ini  Start Never

          [ 2] ReAuthCheck     RUN   -    reauthcheck_mm_i386.so      v0.1.6           ini  Start Never

          [ 3] Revoice         RUN   -    revoice_mm_i386.so          v0.1.0.34        ini  Start Never

          [ 4] Rechecker       RUN   -    rechecker_mm_i386.so        v2.7             ini  Chlvl ANY  

          [ 5] ReSemiclip      RUN   -    resemiclip_mm_i386.so       v2.4.3           ini  Chlvl ANY  

          [ 6] HitBox Fix      RUN   -    hitbox_fix_mm_i386.so       v2.0.3           ini  Start ANY  

          [ 7] WHBlocker       RUN   -    whblocker_mm_i386.so        v1.5.697         ini  Chlvl ANY  

          [ 8] YaPB            RUN   -    yapb.so                     v4.5.1126        ini  Chlvl ANY  

          [ 9] AMX Mod X       RUN   -    amxmodx_mm_i386.so          v1.9.0.5294      ini  Start ANY  

          [10] CStrike         RUN   -    cstrike_amxx_i386.so        v1.9.0.5294      pl10  ANY   ANY  

          [11] ReAPI           RUN   -    reapi_amxx_i386.so          v5.24.0.300-dev  pl10  ANY   Never

          [12] Admins Kit      RUN   -    adminskit_amxx_i386.so      v2.1.1           pl10  ANY   Never

          [13] FakeMeta        RUN   -    fakemeta_amxx_i386.so       v1.9.0.5294      pl10  ANY   ANY  

          [14] Engine          RUN   -    engine_amxx_i386.so         v1.9.0.5294      pl10  ANY   ANY  

          [15] Ham Sandwich    RUN   -    hamsandwich_amxx_i386.so    v1.9.0.5294      pl10  ANY   ANY  

          [16] MySQL           RUN   -    mysql_amxx_i386.so          v1.9.0.5294      pl10  ANY   ANY  

          [17] CSX             RUN   -    csx_amxx_i386.so            v1.9.0.5294      pl10  ANY   ANY  

          [18] GeoIP           RUN   -    geoip_amxx_i386.so          v1.9.0.5294      pl10  ANY   ANY  

          [19] ReAimDetector   RUN   -    reaimdetector_amxx_i386.so  v0.2.2           pl10  ANY   Never

          [20] hackdetector    RUN   -    hackdetector_amxx_i386.so   v0.15.328.lite   pl10  ANY   ANY  

          [21] Amxx Easy Http  RUN   -    easy_http_amxx_i386.so      v1.4.0           pl10  ANY   ANY  

         21 plugins, 21 running

Список плагинов

[  1] Unreal Cheater Cry      1.7         Karaulov          unreal_cheater_  running  

          [  2] Unreal Demo Plugin      1.54        karaulov          unreal_demo_plu  running  

          [  3] [ReAPI] AdminFreeLook   1.0         ReHLDS Team       adminfreelook.a  running  

          [  4] Auto Logs Cleaner       0.0.1       b0t.              AutoLogsCleaner  running  

          [  5] Demorecord              1.0         BiZaJe            demorecord.amxx  running  

          [  6] Admin Commands          1.9.0.5294  AMXX Dev Team     admincmd.amxx    running  

          [  7] Multi-Lingual System    1.9.0.5294  AMXX Dev Team     multilingual.am  running  

          [  8] New Kick Menu           0.9.4       Radius            newkickmenu.amx  running  

          [  9] Commands Menu           1.9.0.5294  AMXX Dev Team     cmdmenu.amxx     running  

          [ 10] Players Menu            1.9.0.5294  AMXX Dev Team     plmenu.amxx      running  

          [ 11] Maps Menu               1.9.0.5294  AMXX Dev Team     mapsmenu.amxx    running  

          [ 12] Admin Chat              1.9.0.5294  AMXX Dev Team     adminchat.amxx   running  

          [ 13] Admin Votes             1.9.0.5294  AMXX Dev Team     adminvote.amxx   running  

          [ 14] Pause Plugins           1.9.0.5294  AMXX Dev Team     pausecfg.amxx    running  

          [ 15] Block TextMsg           1.0         AcE               block_textmsg.a  running  

          [ 16] C4 Timer on roundtime   0.3.3a      neygomon          c4timer.amxx     running  

          [ 17] [182] Parachute RBS     20.06.06    SKAJIbnEJIb & KR  parachute_rbs.a  running  

          [ 18] Bullet Damage           0.0.1       ConnorMcLeod      bullet_damage_v  running  

          [ 19] AFK Control             1.0         mx?!              afk_control.amx  running  

          [ 20] Mode 2x2                2.5.1re     s1lent            mode.amxx        running  

          [ 21] Reset Score             1.1.1       Nordic Warrior    reset_score.amx  running  

          [ 22] ACS Mute                1.0.1.1     ACADEMY-CS.RU     acs_mute.amxx    running  

          [ 23] Lite Auto Restart       1.0         CHEL74            lite_auto_resta  running  

          [ 24] Say me and Say hp       1.4         neygomon          sayme.amxx       running  

          [ 25] Custom Smoke            lite 1.0    medusa            custom_smoke_li  running  

          [ 26] AMXX Gag                1.5.0       xPaw & Exolent (  amx_gag.amxx     running  

          [ 27] Kills Counter           0.3         serfreeman1337    kills_counter.a  running  

          [ 28] AMX Blind               v1.0        T(+)rget          amx_blind.amxx   running  

          [ 29] Killer ScreenFade       0.0.5       Vaqtincha         reapi_killer_sc  running  

          [ 30] C4 & Grenade Explode S  1.0         BodyBuilder | Ma  c4_grenade_expl  running  

          [ 31] [ReAPI] Colored Flash   1.0         ReHLDS Team       colored_flash.a  running  

          [ 32] Ultimate Gore           1.6         JTP10181          amx_gore_ultima  running  

          [ 33] Weapons Skins Manager   0.0.1       Vaqtincha         weapons_skins_m  running  

          [ 34] Time for info           1.0         neugomon          time_for_info.a  running  

          [ 35] Top Bomber              0.2.0       Albertio          top_bomber.amxx  running  

          [ 36] [GM] Weapon Models      0.0.1.0     [GM] NWC          gm_weapon_model  running  

          [ 37] AMXX reloadadmins       0.1         9 rpamm!?         reloadadmins.am  running  

          [ 38] Advanced Kill Assists   1.5         Xelson            next21_kill_ass  running  

          [ 39] Quick Defuse Bomb       0.0.2       Albertio          quick_defuse_bo  running  

          [ 40] C4 CD Voice             1.1         c4timer_by_msk18  c4_cd_voice.amx  running  

          [ 41] Knife Duel with Telepo  1.5.1f      neygomon          knife_duel_with  running  

          [ 42] Style C4 Timer          2.0         OciXCrom          crx_c4timer.amx  running  

          [ 43] MOTD Model              1.1.0       fl0wer            motd_model.amxx  running  

          [ 44] [ReAPI] Healthnade      0.0.17f     DEV-CS.RU Commun  reapi_healthnad  running  

          [ 45] ACS injection med-kit   1.0.6.2     DEV-CS.RU         acs_injection.a  running  

          [ 46] Weapon Kill             1.2         Slove. & AcE      weaponkill.amxx  running  

          [ 47] [ReAPI] Block 'Fire in  0.0.1       sergrib           reapi_block_FIT  running  

          [ 48] Back Weapons New        0.1         Vaqtincha         backweapon.amxx  running  

          [ 49] Welcom                  1.0         4el               welcome_music.a  running  

          [ 50] unknown                 unknown     unknown           hide_cvars_RP_A  running  

          [ 51] [RP] Connect Info       1.0.0       Nordic Warrior    geoip_connect_i  running  

          [ 52] ReAimDetector API       0.2.2       ReHLDS Team       reaimdetector.a  running  

          [ 53] HPP_BLOCK               1.1         UNKNOWN + bristo  hpp_blocker.amx  running  

          [ 54] Client Autoexec         1.2         miRror            client_autoexec  running  

          [ 55] WeaponBox Angles        0.0.1       b0t.              WeaponBoxAngles  running  

          [ 56] Teamwin msg             0.1         Subb98            winteam.amxx     running  

          [ 57] Plugins Core            1.7.0       Radius            plugins_core.am  running  

          [ 58] Count Unique Players    1.1.0       Radius            count_unique_pl  running  

          [ 59] HackDetector            0.15.lite   Lev @ AGHL.RU De  hackdetector.am  running  

          [ 60] Telegram Reports Sende  3.0.1       @pywave & Albert  telegram_report  running  

          [ 61] recoil_manager          1.0.1f      fl0wer            recoil_manager.  running  

          [ 62] Revive Teammates: Core  2.3.15      DEV-CS.RU Commun  rt_core.amxx     running  

          [ 63] Revive Teammates: Plan  2.3.15      DEV-CS.RU Commun  rt_planting.amx  running  

          [ 64] Revive Teammates: Rest  2.3.15      DEV-CS.RU Commun  rt_restrictions  running  

          [ 65] Revive Teammates: Time  2.3.15      DEV-CS.RU Commun  rt_timer.amxx    running  

          [ 66] Revive Teammates: Effe  2.3.15      DEV-CS.RU Commun  rt_effects.amxx  running  

          [ 67] Revive Teammates: Soun  2.3.15      DEV-CS.RU Commun  rt_sounds.amxx   running  

          [ 68] Revive Teammates: Bonu  2.3.15      DEV-CS.RU Commun  rt_bonus.amxx    running  

          [ 69] Revive Teammates: Mode  2.3.15      mx?!              rt_revive_model  running  

          [ 70] [190] AMXBans RBS       24.09.09BE  SKAJIbnEJIb & La  amxbans_rbs.amx  running  

          [ 71] Menus Front-End         20.06.06    SKAJIbnEJIb & AM  amxmodmenu_rbs.  running  

          [ 72] [190] Army Ranks Ultim  20.06.06    SKAJIbnEJIb       army_ranks_ulti  running  

          [ 73] [190] C4 Destroyer      22.12.07BE  SKAJIbnEJIb       c4_destroyer.am  running  

          [ 74] [190] Chat RBS          22.12.07BE  SKAJIbnEJIb       chat_rbs.amxx    running  

          [ 75] [190] CsStats MySQL     22.11.15    SKAJIbnEJIb       csstats_mysql.a  running  

          [ 76] [190] First Players Re  20.06.06    SKAJIbnEJIb       FirstPlayersRes  running  

          [ 77] [190] Maps Helper       20.06.06    SKAJIbnEJIb       maps_helper.amx  running  

          [ 78] [190] Skill ELO         22.11.15    SKAJIbnEJIb       skill_elo.amxx   running  

          [ 79] [190] StatsX Unlimited  22.12.08    SKAJIbnEJIb       statsx_unlimite  running  

          [ 80] [190] Stats Configurat  20.06.06    SKAJIbnEJIb & AM  statscfg_rbs.am  running  

          [ 81] [190] StatsX RBS        21.03.23    SKAJIbnEJIb & AM  statsx_rbs.amxx  running  

          [ 82] [190] Top Award RBS     20.06.06    SKAJIbnEJIb       topaward_rbs.am  running  

          [ 83] [190] Ultimate Flags    22.11.15    SKAJIbnEJIb       ultimate_flags.  running  

          [ 84] [190] Ultimate Weapons  22.11.15    SKAJIbnEJIb       ultimate_weapon  running  

          [ 85] [190] Vanga Detector    24.09.07    SKAJIbnEJIb & Pr  vanga_detector.  running  

          [ 86] [190] VIP RBS           22.12.08BE  SKAJIbnEJIb       vip_rbs.amxx     running  

          [ 87] [190] RestMenu RBS      20.06.06    SKAJIbnEJIb & AM  restmenu_rbs.am  running  

          [ 88] [182] High Ping Kicker  20.06.06    SKAJIbnEJIb       hpk_rbs.amxx     running  

          [ 89] [190] SlayLosers RBS    20.06.06    SKAJIbnEJIb & d3  slaylosers_rbs.  running  

          [ 90] [190] Snipers RBS       20.06.06    SKAJIbnEJIb       snipers_rbs.amx  running  

          [ 91] [190] VoteBan RBS       20.06.06    SKAJIbnEJIb       voteban_rbs.amx  running  

          [ 92] [190] No Team Flash     20.06.06    SKAJIbnEJIb       NoTeamFlash.amx  running  

          [ 93] [190] Stimulation RBS   20.06.06    SKAJIbnEJIb       stimulation_rbs  running  

          [ 94] Custom Player Models A  0.2.7       F@nt0M & BlackSi  custom_player_m  running  

          [ 95] Custom Player Models C  0.2.3       BlackSignature    custom_player_m  running  

          [ 96] Custom Player Models T  0.2.1       BlackSignature    custom_player_m  running

Автор плагина

SergeyShorokhov

Версия плагина

1.0

Исходный код

#include <amxmodx>

#include <csstats_mysql>



const DAY = 1;

const HOUR = 6;



public plugin_init()

    register_plugin("ResetStats", "1.0", "SomeScripter");



public csstats_initialized_post()

{

    new CurDay[4], CurHour[4];

    get_time("%d", CurDay, charsmax(CurDay));

    get_time("%H", CurHour, charsmax(CurHour));



    if(str_to_num(CurDay) == DAY)

    {

        if(str_to_num(CurHour) < HOUR)

            ClearTopData();

    }

}



public ClearTopData()

{

    server_cmd("csstats_remove all");

    server_cmd("echo Stats has been reset");

    log_amx("Stats has been reset");

}

Использую плагин из данного топика для ежемесячного сброса статистики в автоматическом режиме.
лог csstats_mysql.log

L 12/01/2024 - 00:31:39: Log file started (file "cstrike/addons/amxmodx/logs/csstats_mysql.log") (game "cstrike") (amx "1.9.0.5294")
L 12/01/2024 - 00:31:39: Статистика была полностью очищена! Удалено 1488 игроков
L 12/01/2024 - 00:31:48: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:31:58: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:07: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:16: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:25: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:35: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:44: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:32:53: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:02: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:12: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:21: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:30: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:40: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:50: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:33:59: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:34:32: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:34:57: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:07: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:16: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:25: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:34: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:43: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:35:53: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:09: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:18: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:27: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:37: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:46: Статистика была полностью очищена! Удалено 0 игроков
L 12/01/2024 - 00:36:56: Статистика была полностью очищена! Удалено 0 игроков

лог error_20241201.log

L 12/01/2024 - 00:34:41: Start of error session.
L 12/01/2024 - 00:34:41: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20241201.log")
L 12/01/2024 - 00:34:41: [MySQL] Thread worker was unable to start.
L 12/01/2024 - 00:34:41: [AMXX] Run time error 10 (plugin "csstats_mysql.amxx") (native "SQL_ThreadQuery") - debug not enabled!
L 12/01/2024 - 00:34:41: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
L 12/01/2024 - 00:36:02: Start of error session.
L 12/01/2024 - 00:36:02: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20241201.log")
L 12/01/2024 - 00:36:02: [MySQL] Thread worker was unable to start.
L 12/01/2024 - 00:36:02: [AMXX] Run time error 10 (plugin "csstats_mysql.amxx") (native "SQL_ThreadQuery") - debug not enabled!
L 12/01/2024 - 00:36:02: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
L 12/01/2024 - 00:37:05: Start of error session.
L 12/01/2024 - 00:37:05: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20241201.log")
L 12/01/2024 - 00:37:05: [MySQL] Thread worker was unable to start.
L 12/01/2024 - 00:37:05: [AMXX] Run time error 10 (plugin "csstats_mysql.amxx") (native "SQL_ThreadQuery") - debug not enabled!
L 12/01/2024 - 00:37:05: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).

после чего сервер может упасть, видимо из-за того что плагин сброса статистики продолжает работать, а сбрасывать нечего.
можно ли это как-то пофиксить?

p.s. на сервере всегда одна и та же карта, смена происходит по mp_winlimit "50"

 

[RedStreet]

Возможно у тебя плагин не успевает приконнектится к бд, а в это время следует выполнение команд. Попробуй добавить таск на 0.5 - 1 секунду