Crash info

[Matthias]

Hello,

I've been attempting to track down the random crashes that have been occuring the past weeks or months on LVP. We did not have a lot of information about the problem prior to today. All we knew was that the server almost always crashed at night, and most likely when the last player quits the server. I've used this plugin to debug the main server when running, and this is the information I gathered:

Crash #1 (30/12/11)

What we saw from IRC:

[30/12/2011 14:02:48] <%Nuwuni> [8] *** y0rika left the game (leaving).
[30/12/2011 14:02:57] <%Nuwoni> [7] *** eF.Pedro left the game (leaving).
[30/12/2011 14:03:27] <%Nowani> *** First player to solve (95-79) * 3 wins $10.000!
[30/12/2011 14:04:41] <&Nuwani> *** Newsmessage: Visit us on IRC: #LVP on irc.gtanet.com
[30/12/2011 14:04:42] *&Nuwini:%#lvp.echo* *** Announce: Visit us on IRC: #LVP on irc.gtanet.com, By Nuwani (IRC)
[30/12/2011 14:07:07] * Tpimp (Tpimp@gtanet-bbc.895.32.70.IP) Quit (Changing host)
[30/12/2011 14:07:07] * Tpimp (Tpimp@why.so.serious) has joined #lvp.echo
[30/12/2011 14:07:07] * LVP sets mode: +v Tpimp
[30/12/2011 14:09:41] <%Nuwuni> *** Newsmessage: New on LVP? Read the rules! /rules
[30/12/2011 14:14:41] <&Nuweni> *** Newsmessage: New on LVP? Read the rules! /rules
[30/12/2011 14:14:46] <@Kase> !players
[30/12/2011 14:14:46] <%Nuwuni> Online Players (0): Noone...
[30/12/2011 14:19:41] <%Nowani> *** Newsmessage: Visit us on IRC: #LVP on irc.gtanet.com
[30/12/2011 14:20:10] * m0niSx (m0niSx@gtanet-7ao.mai.0.197.IP) has joined #lvp.echo
[30/12/2011 14:24:41] <&Nuwini> *** Newsmessage: Visit us on IRC: #LVP on irc.gtanet.com
[30/12/2011 14:26:29] * carbon (mAzz@gtanet-s4b4dr.bb.dnainternet.fi) has joined #lvp.echo
[30/12/2011 14:29:41] <&Nuweni> *** Newsmessage: Join the Las Venturas Playground Forums: forum.sa-mp.nl!
[30/12/2011 14:33:47] * carbon (mAzz@gtanet-s4b4dr.bb.dnainternet.fi) Quit (Quit: )
[30/12/2011 14:34:41] <&Nuwini> *** Newsmessage: Do not ask to become admin/moderator, we invite them.
[30/12/2011 14:39:41] <%Nuwuni> *** Newsmessage: Do not ask to become admin/moderator, we invite them.
[30/12/2011 14:40:54] * m0niSx (m0niSx@gtanet-7ao.mai.0.197.IP) Quit (Ping timeout: 121 seconds)
[30/12/2011 14:44:41] <%Nuwoni> *** Newsmessage: Join the Las Venturas Playground Forums: forum.sa-mp.nl!
[30/12/2011 14:48:20] * carbon (mAzz@gtanet-tqg.k8g.95.87.IP) has joined #lvp.echo
[30/12/2011 14:48:37] * carbon (mAzz@gtanet-tqg.k8g.95.87.IP) Quit (Quit: )
[30/12/2011 14:49:24] * Mafo (mafo_93@gtanet-ffg.qk3.109.83.IP) has joined #lvp.echo
[30/12/2011 14:49:41] <&Nuwini> *** Newsmessage: New on LVP? Read the rules! /rules
[30/12/2011 14:57:31] <@Kase> derp
[30/12/2011 14:57:34] <@Kase> !players
[30/12/2011 14:57:34] <%Nuwoni> Online Players (0): Noone...
[30/12/2011 14:59:41] <%Nowani> *** Newsmessage: Visit us on IRC: #LVP on irc.gtanet.com
[30/12/2011 15:04:41] <&Nuwani> *** Newsmessage: Visit us on IRC: #LVP on irc.gtanet.com
[30/12/2011 15:06:48] <~Badeend> !raw gmx
[30/12/2011 15:09:41] <&Nuweni> *** Newsmessage: Join the Las Venturas Playground Forums: forum.sa-mp.nl!
[30/12/2011 15:11:52] <%Nuwoni> *** Global Gamemode Initialization

What we saw in the log file:

[14:04:26] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[14:04:26] TextDrawShowForPlayer (playerid = 6 text = TEXTDRAW:321, result = 1);
[14:04:26] TextDrawSetString (text = TEXTDRAW:14 string = ">>~p~ ~w~Loading...", result = 1);
[14:10:15] Incoming connection: 122.172.22.168:62843
[14:32:23] Incoming connection: 81.96.11.71:1974
[14:42:23] Incoming connection: 85.241.165.89:61672

Crash #2 (30/12/11)

What we saw on IRC:

[22:00:35] <%Nowani> [7] *** Batu_theDog left the game (leaving).
[22:04:42] <&Nuwini> *** Newsmessage: Join the Las Venturas Playground Forums: forum.sa-mp.nl!
[22:04:42] *&Nuweni:%#lvp.echo* *** Announce: Join the Las Venturas Playground Forums: forum.sa-mp.nl!, By Nuwani (IRC)
[22:05:52] <%Nuwuni> *** First player to solve 59+81-7 wins $10.000!
[22:09:42] <%Nowani> *** Newsmessage: New on LVP? Read the rules! /rules
[22:09:43] *&Nuwani:%#lvp.echo* *** Announce: New on LVP? Read the rules! /rules, By Nuwani (IRC)
[22:13:18] <&Matthias> !nplayers
[22:13:18] <&Boteend> Players: 0/200
[22:14:42] <&Nuwini> *** Newsmessage: Join the Las Venturas Playground Forums: forum.sa-mp.nl!

What we saw in the log file

[22:09:53] TextDrawSetString (text = TEXTDRAW:14 string = ">> ~p~L~w~oading...", result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 0 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 1 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 2 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 3 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 4 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 5 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:53] TextDrawShowForPlayer (playerid = 6 text = TEXTDRAW:321, result = 1);
[22:09:53] TextDrawSetString (text = TEXTDRAW:14 string = ">> L~p~o~w~ading...", result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 0 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 1 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 2 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 3 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 4 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 5 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawBoxColor (text = TEXTDRAW:321 color = 0, result = 1);
[22:09:54] TextDrawShowForPlayer (playerid = 6 text = TEXTDRAW:321, result = 1);
[22:09:54] TextDrawSetString (text = TEXTDRAW:14 string = ">> Lo~p~a~w~ding...", result = 1);
[22:12:26] Incoming connection: 81.243.161.176:56474

I think it's related to TextDrawSetString and/or TextDrawShowForPlayer being called on an NPC (at both times the server was empty, and the loop only shows data for IDs 0 until 6, those are all NPCs). I'm going to attempt to write a "dirty" fix first thing tomorrow if I can't find the timer calling these functions tonight.

Matthias

[MrBondt]

Alright, cool. Thanks for looking into this

[Matthias]

You're welcome . The test fix is live right now, let's hope it works.

[Jay]

Sorry I've been a bit inactive recently.
I've come to the conclusion it's MySQL related. Either it's a problem in the MySQL plugin or its being caused by a native being incorrectly called (bad query?)

I have been running a build of LVP on the test server with the MySQL plugin completely unloaded and no problems or crashes have occured.

In addition:

the crashes are happening just after the lotto runs.

I believe there is a MySQL query running every few minutes, which would be based on the same timer as the lotto to update some website stuff so perhaps this is a useful area to research.

EDIT: It should also be noted that the MySQL plugin was updated to the latest version for 2.94. It was only a minor update though, and I don't think it made a difference when reverting.

EDIT2: And because these natives are handled in an external plugin, they won't show on that other debug plugin you loaded.

If I get a chance tonight, I'll take a look. Can't promise though.

[MacSto]

Sounds good, thanks