Ошибки при запросе к БД

bereg101 · 28 Авг 2020

Народ, от чего могут появляться ошибки при обращении к БД по типу

[08/28/20 18:12:37] [ERROR] error #2013 while executing query "SELECT * FROM `fraction_bl` WHERE BINARY `f_bl_accused` = 'Den_Delorenzy'": Lost connection to MySQL server during query

Запрос рабочий, возвращает 0
Код запроса в моде:

Код:

    new sql_string[128];
    format(sql_string, sizeof(sql_string), "SELECT * FROM `fraction_bl` WHERE BINARY `f_bl_accused` = '%s'", player_name[playerid]);
    mysql_pquery(connects, sql_string, "bl_loading_callback", "i", playerid);

Потом обращается к паблику bl_loading_callback

Код:

CB: bl_loading_callback(playerid) {
    new rows;
    cache_get_row_count(rows);
    if(rows) {
        for(new i, fr_id; i < rows; i++) {
            cache_get_value_int(i,"f_bl_id", fr_id);

            bl_info[playerid][bl_fraction][fr_id] = true;

            cache_get_value(i, "f_bl_reason", bl_info[playerid][bl_reason][fr_id], 32);
        }
    }
    return 1 ;
}

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

Все ошибки за 5 часов работы. Все запросы рабочие - проверил. (ну кроме error #1054, исправил там было неправильное поле в обращении написано)

[08/28/20 15:57:22] [ERROR] error #2013 while executing query "SELECT * FROM `fraction_bl` WHERE BINARY `f_bl_accused` = 'Taras_GRob'": Lost connection to MySQL server during query

[08/28/20 15:59:52] [ERROR] error #2013 while executing query "UPDATE `accounts` SET `pOnline` = '28-08-2020' WHERE `pID` = '221' LIMIT 1": Lost connection to MySQL server during query

[08/28/20 15:59:53] [ERROR] error #2013 while executing query "SELECT * FROM online_player WHERE date >= CURDATE() AND accountid = 221": Lost connection to MySQL server during query

[08/28/20 15:59:53] [ERROR] cache_get_row_count: no active cache

[08/28/20 15:59:53] [ERROR] cache_delete: invalid cache id '0' rp\pawno\include\nex-ac.inc:3211)

[08/28/20 16:08:27] [ERROR] error #1054 while executing query "UPDATE `accounts` SET `pFMute` = '0' WHERE `pID` = '298' LIMIT 1": Unknown column 'pFMute' in 'field list'

[08/28/20 17:02:48] [ERROR] error #2013 while executing query "SELECT * FROM online_player WHERE date >= CURDATE() AND accountid = 274": Lost connection to MySQL server during query

[08/28/20 17:02:48] [ERROR] cache_get_row_count: no active cache

[08/28/20 17:02:48] [ERROR] cache_delete: invalid cache id '0' rp\pawno\include\nex-ac.inc:3211)

[08/28/20 17:44:40] [ERROR] error #2013 while executing query "SELECT * FROM `banip` WHERE `IP` = '176.59.73.17' LIMIT 1": Lost connection to MySQL server during query

[08/28/20 17:46:27] [ERROR] error #2013 while executing query "UPDATE `accounts` SET `pOnline` = '28-08-2020' WHERE `pID` = '0' LIMIT 1": Lost connection to MySQL server during query

[08/28/20 18:12:37] [ERROR] error #2013 while executing query "SELECT * FROM `fraction_bl` WHERE BINARY `f_bl_accused` = 'Den_Delorenzy'": Lost connection to MySQL server during query

[08/28/20 18:18:15] [ERROR] error #2013 while executing query "SELECT `Name`,`pMember`,`MedHeal` FROM `accounts` WHERE `pMember` = 8 ORDER BY `MedHeal` DESC LIMIT 5": Lost connection to MySQL server during query

[08/28/20 18:18:15] [ERROR] cache_get_row_count: no active cache

[08/28/20 18:18:15] [ERROR] cache_delete: invalid cache id '0'

[08/28/20 18:33:44] [ERROR] error #2013 while executing query "UPDATE `others` SET `gun_mats` = '84203916',`oil_mats` = '147688',`woodsklad` = '2542892',`disease` = '2'": Lost connection to MySQL server during query

Ошибки при запросе к БД

bereg101

Умник