Mysql Problem
#1

Hello i have a problem with my mysql system
when too many players join, failed the connection to the server
here the mysql logs before the server crash is there a bug in the logs ?

Код:
[18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmmm.
[18:09:26] >> mysql_query( Connection handle: 1 )
[18:09:26] CMySQLHandler::Query(SELECT * FROM `playerinfo` WHERE `user` = 'mmm' AND `password` = '1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290' LIMIT 1) - Successfully executed.
[18:09:26] >> mysql_store_result( Connection handle: 1 )
[18:09:26] CMySQLHandler::StoreResult() - Result was stored.
[18:09:26] >> mysql_num_rows( Connection handle: 1 )
[18:09:26] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:09:26] >> mysql_fetch_row_format( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchRow() - Return: mmm|1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290|19|18|19|25497|87.188.177.180|0|NULL|NULL|1|29/4/2012
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("adminlvl") - 0
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("kills") - 19
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("deaths") - 18
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("ratio") - 1
[18:09:26] >> mysql_fetch_field_row( Connection handle: 1 )
[18:09:26] CMySQLHandler::FetchField("regdate") - 29/4/2012
[18:09:26] >> mysql_free_result( Connection handle: 1 )
[18:09:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
[18:09:26] >> mysql_real_escape_string( Connection handle: 1 )
[18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmm.
[18:09:26] >> mysql_query( Connection handle: 1 )
[18:09:26] CMySQLHandler::Query(UPDATE `playerinfo` SET IP = '87.555555' WHERE user='mmm') - Successfully executed.
[18:27:09]  
[18:27:09] ---------------------------
[18:27:09] MySQL Debugging activated (04/29/12)
[18:27:09] ---------------------------
Reply
#2

use crashdetect plugin if server crash it will write you in server log what cause that crash
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)