MySQL_Reconnect
#1

It appears that my server keeps losing connection to mysql after investigating many many logs.

this is the latest log print I get:

Код:
[20:59:13] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:59:13] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:59:13] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
This was at the time/after the crash.

How could I use MySQL_Reconnect?


Log around the time of the crash.
Код:
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password` FROM `accounts` WHERE id = 35", callback: "CheckPass", format: "si"
[20:59:11] [DEBUG] CMySQLQuery::Execute[CheckPass] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[CheckPass] - query was successfully executed within 10.714 milliseconds
[20:59:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:59:11] [DEBUG] Calling callback "CheckPass"..
[20:59:11] [DEBUG] cache_get_data - connection: 1
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "D70D08084DE814F8F592168EE27B6F4BDD5F55E8F78755A26CE6D3E239732D634358FF7B09525DE60AD5731AC628F900680409B9A0928231703B04A4DB20EA2F"
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts WHERE `id` = 35 LIMIT 1", callback: "LoadAccount", format: "i"
[20:59:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:59:11] [DEBUG] CMySQLQuery::Execute[LoadAccount] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[LoadAccount] - query was successfully executed within 11.40 milliseconds
[20:59:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:59:11] [DEBUG] Calling callback "LoadAccount"..
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET PlayerIP = '77.103.166.185' WHERE `id` = 35 ", callback: "(null)", format: "(null)"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 32, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '32', data: "0"
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET BanTime = 0 WHERE id = 35 LIMIT 1", callback: "(null)", format: "(null)"
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET Banned = 1 WHERE id = 35 LIMIT 1", callback: "(null)", format: "(null)"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 16, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '16', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 5, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "5"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 7, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "3920"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 51, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '51', data: "58980"
[20:59:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET PlayerIP = '77.103.166.185' WHERE id = 35 LI", callback: "(null)", format: "(null)"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 6, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 35, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '35', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 34, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '34', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 81, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '81', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 33, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '33', data: "26305087"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 40, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '40', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 22, connection: 1, max_len: 24
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '22', data: ""
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 39, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '39', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 17, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '17', data: "3"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 19, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '19', data: "214"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 20, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '20', data: "11"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 21, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '21', data: "69"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 18, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '18', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 50, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '50', data: "4556"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 27, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '27', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 28, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '28', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 10, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 29, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '29', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 30, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '30', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 25, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '25', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 12, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "2341"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 13, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 102, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '102', data: "25"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 11, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 68, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '68', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 14, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 15, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '15', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 9, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 8, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 37, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '37', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 65, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '65', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 66, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '66', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 67, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '67', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 41, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '41', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 42, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '42', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 43, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '43', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 44, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '44', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 45, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '45', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 46, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '46', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 47, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '47', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 48, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '48', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 49, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '49', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 36, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '36', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 69, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '69', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 70, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '70', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 72, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '72', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 73, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '73', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 74, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '74', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 75, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '75', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 76, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '76', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 77, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '77', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 73, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '73', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 80, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '80', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 79, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '79', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 94, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '94', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 95, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '95', data: "21"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 84, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '84', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 85, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '85', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 86, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '86', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 87, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '87', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 88, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '88', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 89, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '89', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 90, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '90', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 91, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '91', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 92, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '92', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 93, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '93', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 95, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '95', data: "21"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 96, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '96', data: "1466964174"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 98, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '98', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 97, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '97', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 99, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '99', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 101, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '101', data: "4"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 100, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '100', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 103, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '103', data: "1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 104, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '104', data: "19931013"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 105, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '105', data: "2"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 106, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '106', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 107, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '107', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 108, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '108', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 118, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '118', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 119, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '119', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 120, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '120', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 112, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '112', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 113, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '113', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 114, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '114', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 115, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '115', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 116, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '116', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 117, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '117', data: "-1"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 109, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '109', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 110, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '110', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 111, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '111', data: "-1"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 139, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '139', data: "0"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 140, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '140', data: "2096.63"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 141, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '141', data: "-1775.64"
[20:59:11] [DEBUG] cache_get_row - row: 0, field_idx: 142, connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '142', data: "13.5559"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 144, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '144', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 143, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '143', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 121, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '121', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 122, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '122', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 123, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '123', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 124, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '124', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 125, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '125', data: "2"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 126, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '126', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 127, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '127', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 128, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '128', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 129, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '129', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 71, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '71', data: "10"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 130, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '130', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 131, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '131', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 132, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '132', data: "1"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 133, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '133', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 134, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '134', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 135, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '135', data: "1"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 136, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '136', data: "36"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 137, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '137', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 138, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '138', data: "60"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 145, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '145', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 146, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '146', data: "3"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 147, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '147', data: "1"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 148, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '148', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 149, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '149', data: "0"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 150, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '150', data: "649"
[20:59:11] [DEBUG] cache_get_row_int - row: 0, field_idx: 151, connection: 1
[20:59:11] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '151', data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon0", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon0", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon1", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon1", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon2", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon2", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon3", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon3", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon4", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon4", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon5", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon5", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon6", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon6", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon7", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon7", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon8", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon8", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon9", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon9", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon10", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon10", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon11", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon11", data: "0"
[20:59:11] [DEBUG] cache_get_field_content - row: 0, field_name: "Weapon12", connection: 1, max_len: 512
[20:59:11] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon12", data: "0"
[20:59:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.696 milliseconds
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.683 milliseconds
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.707 milliseconds
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.624 milliseconds
[20:59:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM apartments", callback: "LoadAparts", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM houses", callback: "LoadHouses", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM businesses", callback: "LoadBusinesses", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM factions", callback: "LoadFactions", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM furniture", callback: "LoadFurni", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM vehicles", callback: "LoadVehicles", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM ptickets", callback: "LoadPTickets", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM fines", callback: "LoadFines", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM weapons", callback: "LoadWeapons", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM misc", callback: "LoadMisc", format: "(null)"
[20:59:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM gates", callback: "LoadGates", format: "(null)"
Reply
#2

No need to, there is a parameter in mysql_connect function for auto reconnect and it is set to true by default.

Read also this: http://dev.mysql.com/doc/refman/5.7/en/gone-away.html
Reply
#3

Why would this lose connection like this?

It's always a different reason on the server log but ultimately it's random.
Reply
#4

Still unresolved!
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)