Server Hangs On Lotto Message

[StoneMage]

I was testing a server today and keep getting server hang on lotto message

the CruelDragon3G exe program locks up for like 4 minutes and uses 100% cpu then comes back and reports these errors
4:29:58 AM:[RunDB] DB Wait Error 4:29:58 AM
4:30:03 AM:[RunDB] DB Wait Error 4:30:03 AM
4:30:08 AM:[RunDB] DB Wait Error 4:30:08 AM
4:30:13 AM:[RunDB] DB Wait Error 4:30:13 AM
4:30:18 AM:[RunDB] DB Wait Error 4:30:18 AM
4:30:23 AM:[RunDB] DB Wait Error 4:30:23 AM
4:30:29 AM:[RunDB] DB Wait Error 4:30:29 AM
4:30:34 AM:[RunDB] DB Wait Error 4:30:34 AM
4:30:35 AM:[RunDB] DB Wait Error 4:30:35 AM

also at the same time
Rungate

7200 Client-SocketRead function is not work! in the top left of the screen

the server is running 1gb ram

this happens every hour on the lotto message hope someone can help thanks

also server is running 3G latest halley files

 

[Demonic]

Sounds like its Doing a SQL Query on the DB Holding the Lotto, cannot find the required parts and hangs, chuck a SQL Trace and wait for the Lotto to kick in - soo see what the problem is.

 

[StoneMage]

thanks demonic ill get rite on it see if i can source the prob,

also if any1 else has any ideas all welcome please

 

[Demonic]

The one your after BTW is Profiler, this is installed with SQL Client Utils. Best to wait till you know when a problem is about to occur and then start the trace running, the Server will generate a lot of Read/Writes on its normal running so will take you a while to pick that out.

The databases it writes to anyhow are in Game3G as follows:

TBL_LottoServer
TBL_LottoUser

 

[StoneMage]

how easy would it to be just to disabled the lotto message and function see if that fixes it?

 

[Coly]

In your 00Default.txt Clear the LottoItemClick Event ^^ this Stop the Lotto full. (make a Copy of your 00Default.txt and then Clear this Event full, not with ";" ) then Test. ;-)

Edit: with Trace I belive Demonic mean the Tracer in your Profiler, you find this by your Enterprise Manager.

 

[StoneMage]

I ok ive tried disabling all lotto system but it still hangs anyway, im thinking it not to do with lotto system.

 

[Coly]

hmm then Trace the DB Connection...
or cut the Lotto NPC.

I belive with CD3.xx the Main function has big problems this make a new Instance and don't clean the old Instance -.- and with this you have Running
more , and with @ReloadDefaultNPC you have many more. We have Test ist
many many Times.

 

[StoneMage]

i dont know if it is something to do with the loto system now, i just know it is every hr guarenteed at the exact same time the crueldragon exe hangs for 3 minutes and then spams that db wait time. this then causes the hole server to lag out.

hope this helps thanks

 

[TritoN]

tbh it looks like your hosting pc cant handle all the serverparts rather than a db problem
maybe post your pc specs

 

[StoneMage]

server is dedicated box 1gb ram 2.6ghz all its running is microsoft sql / mysql / iis / php / and the lom3 server files

also the last hang we got a new error

[Exception] ExecGateMsg

with the other one

 

[StoneMage]

ok i have attached two screen shots one of the db check on the loto system and the other which is the crueldragon program when it locks up

hope someone can please help thanks

 

[StoneMage]

its officialy not RAM i had a upgrade on the server today to 2gb ram and it is still doing the same

 

[mythonline]

do u think old windows can create the problem?