game01 shuts down randomly

Hello guys, we got a problem.

after starting the server and everyone gets in game we can play and everything works. but of some reason the (Game01) shuts down randomly between 5 min - a couple of hours.

everything running eccept from (Game01) i can restart the server and we can play for again for about 5 min - a couple of hours.. then it shuts down again.

its not a specific time, it does it randomly.

anyone have an ansear on this?

Thanks alot for ansear's

logs?

Logs:

2013-04-22 11:21:55 PS_USERLOG__system log start (UserLog)

2013-04-22 11:21:56 connect

2013-04-22 11:21:57 connect

2013-04-22 11:22:01 connect

2013-04-22 11:38:39 1 1 SAgent::Disconnect: (4, 64)

2013-04-22 11:38:39 1 1 T=000:16:00:000, RC=6,RCS=0, RB=138,RBS=0, SC=3,SCS=0, SB=12,SBS=0

2013-04-22 11:38:39 disconnect

2013-04-22 11:47:49 connect



2013-04-22 11:21:55 PS_SESSION__system log start (Session)

2013-04-22 11:21:57 connect login

2013-04-22 11:22:01 connect game

2013-04-22 11:22:54 [FISTOFSHAIYA] NewUser Enter : Char=.X., Lv=80, Map=42, X=50.4, Z=53.7

2013-04-22 11:23:29 [FISTOFSHAIYA] NewUser Enter : Char=Dragon.Fears, Lv=35, Map=2, X=983.7, Z=1056.5

2013-04-22 11:23:50 [FISTOFSHAIYA] NewUser Leave : Char=.X., Lv=80, Map=42, X=50.4, Z=53.7

2013-04-22 11:24:57 [FISTOFSHAIYA] NewUser Enter : Char=Serf, Lv=1, Map=2, X=1838.9, Z=443.4

2013-04-22 11:25:03 [FISTOFSHAIYA] NewUser Leave : Char=Dragon.Fears, Lv=35, Map=2, X=586.0, Z=1456.5

2013-04-22 11:25:13 [FISTOFSHAIYA] NewUser Enter : Char=DragonFears, Lv=80, Map=40, X=74.3, Z=96.3

2013-04-22 11:31:20 [FISTOFSHAIYA] NewUser Enter : Char=[GM]CaptCaveman, Lv=80, Map=36, X=545.4, Z=337.5

2013-04-22 11:35:20 [FISTOFSHAIYA] NewUser Enter : Char=Lord.Hyperion, Lv=80, Map=47, X=1021.6, Z=240.4

2013-04-22 11:38:39 1 1 SAgent::Disconnect: (4, 64)

2013-04-22 11:38:39 1 1 T=000:16:00:000, RC=40,RCS=0, RB=2649,RBS=2, SC=15,SCS=0, SB=1128,SBS=1

2013-04-22 11:38:39 disconnect game

2013-04-22 11:47:49 connect game

2013-04-22 11:48:31 [FISTOFSHAIYA] NewUser Enter : Char=Lord.Hyperion, Lv=80, Map=47, X=1021.6, Z=240.4

2013-04-22 11:48:35 [FISTOFSHAIYA] NewUser Enter : Char=Danger, Lv=79, Map=68, X=680.7, Z=447.1

2013-04-22 11:48:44 [FISTOFSHAIYA] NewUser Enter : Char=Vex, Lv=80, Map=68, X=680.7, Z=447.1

2013-04-22 11:50:20 [FISTOFSHAIYA] NewUser Enter : Char=Serf, Lv=26, Map=2, X=1838.9, Z=443.4

2013-04-22 11:53:20 [FISTOFSHAIYA] NewUser Enter : Char=Mr-Hex., Lv=1, Map=1, X=578.0, Z=1762.1



2013-04-22 11:21:56 PS_LOGIN__system log start (Login01)

2013-04-22 11:22:20 <Console input> /vchkoff

2013-04-22 11:22:20 <Console output> cmd version chk off ok

2013-04-22 11:47:56 <Console input> /vchkoff

2013-04-22 11:47:56 <Console output> cmd version chk off ok



2013-04-22 11:21:57 PS_GAMELOG__system log start (GameLog01)

2013-04-22 11:22:01 connect game

2013-04-22 11:27:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2013-04-22 11:27:50 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'littledarlings',104,120,'Lelu', 33,2254649,19, 608.533386,8.459998,1825.440918, '2013-04-22 11:27:50' ,133, 1150,1,1700,0,0,NULL,NULL,NULL,NULL,NULL,'Randy's Patron','',NULL,NULL

2013-04-22 11:32:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2013-04-22 11:32:13 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'littledarlings',104,120,'Lelu', 34,2256497,19, 758.062988,10.533087,1638.222290, '2013-04-22 11:32:13' ,131, 1152,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ex plorer's Excavation Equipme ','',NULL,NULL

2013-04-22 11:35:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2013-04-22 11:35:46 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'littledarlings',104,120,'Lelu', 34,2258521,19, 793.893555,27.162588,443.398407, '2013-04-22 11:35:46' ,133, 1152,1,1800,0,0,NULL,NULL,NULL,NULL,NULL,'Explorer 's Excavation Equipme ','',NULL,NULL

2013-04-22 11:35:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2013-04-22 11:35:52 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'littledarlings',104,120,'Lelu', 34,2258521,19, 793.893555,27.162588,443.398407, '2013-04-22 11:35:52' ,131, 1153,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ex plorer's Excavation Equipme ','Rolin Silverhawk',NULL,NULL

2013-04-22 11:38:39 1 1 SAgent::Disconnect: (4, 64)

2013-04-22 11:38:39 1 1 T=000:16:00:000, RC=274,RCS=0, RB=34123,RBS=34, SC=3,SCS=0, SB=12,SBS=0

2013-04-22 11:38:39 disconnect game

2013-04-22 11:47:49 connect game



2013-04-22 11:47:47 PS_GAME__system log start (Game01) [KR]

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/sorp1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/croco1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/croco2

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Troll1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Spink1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/GoldenPig

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Sorp3

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Sorp2

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Deinos

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Parridalis

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Alcarian

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Belizabeth

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Kirhiross

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/CrypticOne

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Haruhion

2013-04-22 11:47:47 Loaded Behavior In Factory : data/ai/Freezing

2013-04-22 11:47:48 RandomOption Error : ItemID=5250, byServer=5, Wis=0

2013-04-22 11:47:48 RandomOption Error : ItemID=16253, byServer=3, Wis=0

2013-04-22 11:47:48 RandomOption Error : ItemID=17253, byServer=3, Wis=0

2013-04-22 11:47:48 RandomOption Error : ItemID=18253, byServer=3, Wis=0

2013-04-22 11:47:48 RandomOption Error : ItemID=20253, byServer=3, Wis=0

2013-04-22 11:47:49 connect mgr 940

2013-04-22 11:47:49 connect dbagent 944

2013-04-22 11:47:49 connect dbagent2 948

2013-04-22 11:47:49 connect gamelog 964

2013-04-22 11:47:49 Market End -----------------------

2013-04-22 11:47:49 cannot open .\Data\Lua\129.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\144.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\149.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\127.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\136.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\137.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\138.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\139.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\141.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\126.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\147.lua: No such file or directory

2013-04-22 11:48:10 <Console input> /nprotectoff

2013-04-22 11:48:10 <Console output> cmd NProtect off ok

2013-04-22 11:49:14 <Console input> /exp2xenable 300

2013-04-22 11:49:14 <Console output> cmd exp2x enable ok(byadmin=1,bysys=0,current ExpX=300.000)

2013-04-22 11:53:20 error exp min usern=jjclark099,charn=Mr-Hex., level=1,exp=0,exppv=2150000



2013-04-22 11:21:57 PS_DBAGENT__system log start (DBAgent01)

2013-04-22 11:22:01 connect game, Name=



2013-04-22 11:22:01 connect game, Name=



2013-04-22 11:38:39 1 1 SAgent::Disconnect: (4, 64)

2013-04-22 11:38:39 1 1 SAgent::Disconnect: (4, 64)

2013-04-22 11:38:39 1 1 T=000:16:00:000, RC=405,RCS=0, RB=9958,RBS=9, SC=200,SCS=0, SB=58821,SBS=58

2013-04-22 11:38:39 1 1 T=000:16:00:000, RC=4,RCS=0, RB=49,RBS=0, SC=9,SCS=0, SB=7332,SBS=7

2013-04-22 11:38:39 disconnect game, Name=Game01



2013-04-22 11:38:39 disconnect game, Name=Game01



2013-04-22 11:38:39 save market... wait plz...



2013-04-22 11:38:39 save all... wait plz... enter /uc



2013-04-22 11:47:49 connect game, Name=



2013-04-22 11:47:49 connect game, Name=

2013-04-22 11:47:49 cannot open .\Data\Lua\129.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\144.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\149.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\127.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\136.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\137.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\138.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\139.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\141.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\126.lua: No such file or directory

2013-04-22 11:47:49 cannot open .\Data\Lua\147.lua: No such file or directory
thats one of your problems
your missing some server side files in you psm_client>bin>data

Quote:

2013-04-22 11:32:13 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'littledarlings',104,120,'Lelu', 34,2256497,19, 758.062988,10.533087,1638.222290, '2013-04-22 11:32:13' ,131, 1152,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ex plorer's Excavation Equipme ','',NULL,NULL 2013-04-22 11:35:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

this part must be fixed too it wont save any log in db if you dont

that wouldnt cause the random disconnect though, but yea the does need to be fixed if you want to see what people are doing

We know those Lua files are missing, But it should not curse the disconnection. How ever the problem are everytime you hit Some Bosses that says the Wierd text "@?!#"&" Or something like that it dcing you. those has the AI 18, 33 Etc. we cant find the problem of those mobs either but we are woking on it atm. we will add those lua files anyways and see if thats a problem. ty for ansear

I had the same, you need to change your ps_game. :)

Quote:

Originally Posted by Nubness's-Son I had the same, you need to change your ps_game. :)

Which Game? upload please

I have the same problem, turns on and off randomly, regarding the line it is obvious NOT TO INSERT or magic because the MSSQL turns off which is the one that sends the queries to the database if it shuts down creates a string that turns off the game_01 and game.