[thimo]

Hello,

So im having a problem with some crashes but i dont know why they are happening. I was hoping that anyone else was getting a better understanding of this readout:

Code:

[09:17:18] [debug] Server crashed while executing ET.amx
[09:17:18] [debug] AMX backtrace:
[09:17:18] [debug] #0 native mysql_connect () [b7186f60] from mysql.so
[09:17:18] [debug] System backtrace:
[09:17:18] [debug] #0 b6712f41 in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[09:17:18] [debug] #1 b670941f in _ZN11crashdetect20PrintSystemBacktraceEPv () from plugins/crashdetect.so
[09:17:18] [debug] #2 b6707963 in _ZN11crashdetect15SystemExceptionEPv () from plugins/crashdetect.so
[09:17:18] [debug] #3 b67123c1 in ?? () from plugins/crashdetect.so
[09:17:18] [debug] #4 b7710600 in ?? ()
[09:17:18] [debug] #5 b7195eb9 in ?? () from plugins/mysql.so
[09:17:18] [debug] #6 b7195af5 in my_net_read () from plugins/mysql.so
[09:17:18] [debug] #7 b718a831 in cli_safe_read () from plugins/mysql.so
[09:17:18] [debug] #8 b718d156 in ?? () from plugins/mysql.so
[09:17:18] [debug] #9 b718d3fc in mysql_real_query () from plugins/mysql.so
[09:17:18] [debug] #10 b7188ffb in _Z18ProcessQueryThreadPv () from plugins/mysql.so
[09:17:18] [debug] #11 b76e8d4c in ?? () from /lib/i386-linux-gnu/libpthread.so.0
[09:17:18] [debug] #12 b74f7dde in clone () from /lib/i386-linux-gnu/libc.so.6

Why could it be crashing?

[Xabi]

Read the mysql.log to see the query that is making the server crash.

[thimo]

Code:

[09:17:18] >> mysql_query_callback(Connection handle: 1)
[09:17:18] >> mysql_ping(Connection handle: 1)
[09:17:18] ProcessQueryThread() - Executing query UPDATE Users SET LastIP = '46.198.119.20' WHERE Name='PePiTo'...
[09:17:18] CMySQLHandler::Ping() - An error has occured (error: 2013, Lost connection to MySQL server during query).
[09:17:18] >> mysql_connect(POOFED OUT, POOFED OUT, POOFED OUT, ***) on port 3306

IT lost connection so how do you establish it without crashing it?

[Xabi]

Maybe you have something wrong in that query that crashes de mysql.

[thimo]

Code:

[09:17:10] >> mysql_query_callback(Connection handle: 1)
[09:17:10] >> mysql_real_escape_string(Connection handle: 1)
[09:17:10] CMySQLHandler::EscapeString(PePiTo) - Escaped 6 characters to PePiTo.
[09:17:10] >> mysql_query_callback(Connection handle: 1)
[09:17:10] ProcessQueryThread(OnAccountCheck) - Executing query SELECT * FROM `Users` WHERE `Name` = 'PePiTo'...
[09:17:10] ProcessQueryThread(OnAccountCheck) - Query was successful.
[09:17:10] ProcessQueryThread(OnAccountCheck) - Data caching enabled.
[09:17:10] CMySQLHandler::StoreResult() - Result was stored.
[09:17:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[09:17:10] ProcessQueryThread(OnAccountCheck) - Data being passed to ProcessTick().
[09:17:10] OnAccountCheck(i) - Callback has been called.
[09:17:10] >> cache_get_data(Connection handle: 1)
[09:17:10] ProcessTick() - The cache has been cleared.
[09:17:10] ProcessQueryThread(OnPlayerHousesLoad) - Executing query SELECT `HouseID` FROM `Houses` WHERE `Houseowner`='PePiTo'...
[09:17:10] ProcessQueryThread(OnPlayerHousesLoad) - Query was successful.
[09:17:10] ProcessQueryThread(OnPlayerHousesLoad) - Data caching enabled.
[09:17:10] CMySQLHandler::StoreResult() - Result was stored.
[09:17:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[09:17:10] ProcessQueryThread(OnPlayerHousesLoad) - Data being passed to ProcessTick().
[09:17:10] OnPlayerHousesLoad(d) - Callback has been called.
[09:17:10] >> cache_get_data(Connection handle: 1)
[09:17:10] ProcessTick() - The cache has been cleared.
[09:17:18] >> mysql_query_callback(Connection handle: 1)
[09:17:18] >> mysql_ping(Connection handle: 1)
[09:17:18] ProcessQueryThread() - Executing query UPDATE Users SET LastIP = '46.198.119.20' WHERE Name='PePiTo'...
[09:17:18] CMySQLHandler::Ping() - An error has occured (error: 2013, Lost connection to MySQL server during query).
[09:17:18] >> mysql_connect(POOF, POOF, POOF, ***) on port 3306
[09:20:32] Plugin succesfully loaded!
[09:20:32] >> mysql_connect(95.47.141.218, root, 10528_Thimo, ***) on port 3306
[09:20:32] CMySQLHandler::CMySQLHandler() - constructor called.
[09:20:32] CMySQLHandler::CMySQLHandler() - Connecting to "POOF" | DB: "POOF" | Username: "Poof"...
[09:20:32] CMySQLHandler::Connect() - Connection was successful.
[09:20:32] CMySQLHandler::Connect() - Auto-reconnect has been enabled.

Anything wrong in something in here?

[Kebab-]

Code:

[09:17:18] ProcessQueryThread() - Executing query UPDATE Users SET LastIP = '46.198.119.20' WHERE Name='PePiTo'...
[09:17:18] CMySQLHandler::Ping() - An error has occured (error: 2013, Lost connection to MySQL server during query).

Your MySQL server seems to be dropping connections. Maybe you've got a query written out wrong?

As far as I understand, it's related to the query listed above the lost connection error code.

[thimo]

But why does it do that? Its just on a Ubuntu Linux VPS

[Kebab-]

Does the same thing happen on your Windows VPS, or have you not tested it?

[thimo]

I cant really test it there. Cus there are no players

[thimo]

Code:

[11:14:33] [debug] Server crashed due to an unknown error
[11:14:33] [debug] System backtrace:
[11:14:33] [debug] #0 b6799f41 in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[11:14:33] [debug] #1 b679041f in _ZN11crashdetect20PrintSystemBacktraceEPv () from plugins/crashdetect.so
[11:14:33] [debug] #2 b678e963 in _ZN11crashdetect15SystemExceptionEPv () from plugins/crashdetect.so
[11:14:33] [debug] #3 b67993c1 in ?? () from plugins/crashdetect.so
[11:14:33] [debug] #4 b7797600 in ?? ()
[11:14:33] [debug] #5 b7211ae0 in mysql_free_result () from plugins/mysql.so
[11:14:33] [debug] #6 b7207597 in _ZN13CMySQLHandler10FreeResultEv () from plugins/mysql.so
[11:14:33] [debug] #7 b72080d5 in _ZN13CMySQLHandlerD2Ev () from plugins/mysql.so
[11:14:33] [debug] #8 b720ec90 in Unload () from plugins/mysql.so
[11:14:33] [debug] #9 080c621b in ?? () from ./samp03svr
[11:14:33] [debug] #10 080b14ff in ?? () from ./samp03svr
[11:14:33] [debug] #11 b74a94d3 in __libc_start_main () from /lib/i386-linux-gnu/libc.so.6

And this was excecuted:

Code:

[11:14:33] Unloading Plugin
[11:14:33] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[11:14:33] CMySQLHandler::FreeResult() - The result is already empty.
[11:14:33] CMySQLHandler::Disconnect() - Connection was closed.
[11:14:33] CMySQLHandler::~CMySQLHandler() - deconstructor called.

Indeed nothing is excecuted the plugin just simply unloads? O_O