DB wait error

smoochy boys on tour

ash816

Dedicated Member
Dedicated Member
Jun 2, 2007
89
0
52
every now and then i get a DB wait error , any1 know why ? server is fine for about 2-3 hours then bam the cruel dragon and holley control panel goes white andu h vae to wait 10 seconds for it to regain responsivness ..
 

Coly

LOMCN Developer
Developer
Mar 31, 2005
1,399
33
195
Germany
It is your Database, with new SQLServer and some CPUs you need a Patch for the CPU to Syncrone the Timer (is a known bug on some CPUs and you get the patch by your CPU Company).
Other is, if you have the SQL Server on the same PC / Server with low power (to littel RAM / CPU) then the error occurs same.
 
Upvote 0

ash816

Dedicated Member
Dedicated Member
Jun 2, 2007
89
0
52
no i didnt change it from origional proiority kaori and i have 4GM ram
 
Upvote 0

Kaori

LOMCN MiR3 Queen!
VIP
Jun 3, 2004
3,584
38
285
Canada
4gb 100gb ram won't make a difference.

db wait error is cpu related.

If all YES:
1. cpu is 100% during those error?
2. running db server, game server on 1 computer?

you have to tune your game server to use a lower priority so that your db server won't choke.

how? task manager in the process tab.
 
Upvote 0

ash816

Dedicated Member
Dedicated Member
Jun 2, 2007
89
0
52
crueldragon exe was set to highest priority and still got unresponsiveness and also got these errors

12:27:51:List index out of bounds (1)
12:27:51:List index out of bounds (1)
12:27:51:[RunDB] DB Wait Error 12:27:47
12:27:51:List index out of bounds (1)

game and db server are on 1 comp yes
 
Upvote 0

ash816

Dedicated Member
Dedicated Member
Jun 2, 2007
89
0
52
here screen
 

Attachments

  • ScreenShot056.jpg
    ScreenShot056.jpg
    164.3 KB · Views: 42
Last edited:
Upvote 0

Kaori

LOMCN MiR3 Queen!
VIP
Jun 3, 2004
3,584
38
285
Canada
restart selgate?

see if it'll goto 50%


oh wait... what's holleymir3.exe??? don't play mir on the same computer as the server.
 
Last edited:
Upvote 0

ash816

Dedicated Member
Dedicated Member
Jun 2, 2007
89
0
52
[SelGate]
Title=华立软件
ServerAddr=127.0.0.1
ServerPort=5100
GateAddr=0.0.0.0
GatePort=7100
ShowLogLevel=1
MaxConnOfIPaddr=20
BlockMethod=0
KeepConnectTimeOut=80000
 
Upvote 0

Kaori

LOMCN MiR3 Queen!
VIP
Jun 3, 2004
3,584
38
285
Canada
you may need to lower your selgate's cpu priority as well for the test.

when selgate is 50%, can you take a screenshot of your selgate?

and also check if the selgate is being hit.
 
Upvote 0