Hello i have found today a server crash when someone kill a mob from CT and create guilds i never had this problem till i moved on host and now start lot's of problems on log's i see that only game disconnected here is my log's
I have already run the query's for guild fix but nothing the same error and CT mobs have no ideea how to fix :S:
I have already run the query's for guild fix but nothing the same error and CT mobs have no ideea how to fix :S:
Quote:
2012-03-15 19:05:42 PS_DBAGENT__system log start (DBAgent01)
2012-03-15 19:06:51 connect game, Name=
2012-03-15 19:06:51 connect game, Name=
2012-03-15 19:46:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]??? PRIMARY KEY ?? 'PK_GuildHouses'?????? 'GuildDetails' ???????, SQL STATE: 23000, NATIVE ERROR: 2627 (0xA43)
2012-03-15 19:46:31 DBGuild::CreateGuild Failed 2, Alliance-Of-Lights, 383, Outta, qerr=-1, EXEC usp_Create_Guild2_E 2,'Alliance-Of-Lights','account',383,'char name',0,'------'
2012-03-15 19:46:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]??? PRIMARY KEY ?? 'PK_GuildHouses'?????? 'GuildDetails' ???????, SQL STATE: 23000, NATIVE ERROR: 2627 (0xA43)
2012-03-15 19:46:31 DBGuild::CreateGuild Failed 2, Alliance-Of-Lights, 383, Outta, qerr=-1, EXEC usp_Create_Guild2_E 2,'Alliance-Of-Lights','-----------',383,'Outta',0,'--------'
2012-03-15 20:56:17 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 20:56:17 1 1 T=001:49:00:000, RC=10472,RCS=1, RB=216444,RBS=32, SC=980,SCS=0, SB=207445,SBS=31
2012-03-15 20:56:17 disconnect game, Name=Game01
2012-03-15 20:56:17 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 20:56:17 1 1 T=001:49:00:000, RC=22,RCS=0, RB=121,RBS=0, SC=27,SCS=0, SB=5667,SBS=0
2012-03-15 20:56:17 disconnect game, Name=Game01
2012-03-15 20:56:17 save market... wait plz...
2012-03-15 20:56:17 save all... wait plz... enter /uc
2012-03-15 20:57:41 connect game, Name=
2012-03-15 20:57:41 connect game, Name=
2012-03-15 21:58:22 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 21:58:22 1 1 T=001:00:00:000, RC=5336,RCS=1, RB=98599,RBS=27, SC=573,SCS=0, SB=169990,SBS=46
2012-03-15 21:58:22 disconnect game, Name=Game01
2012-03-15 21:58:22 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 21:58:22 1 1 T=001:00:00:000, RC=13,RCS=0, RB=85,RBS=0, SC=17,SCS=0, SB=5627,SBS=1
2012-03-15 21:58:22 disconnect game, Name=Game01
2012-03-15 21:58:22 save market... wait plz...
2012-03-15 21:58:22 save all... wait plz... enter /uc
2012-03-15 22:03:11 connect game, Name=
2012-03-15 22:03:11 connect game, Name=
Quote:
2012-03-15 19:05:48 PS_LOGIN__system log start (Login01)
2012-03-15 19:06:27 <Console input> /vchkoff
2012-03-15 19:06:27 <Console output> cmd version chk off ok
2012-03-15 20:05:59 cmd_auto server info log
user = 0 (0/5000)
2012-03-15 20:05:59 T=001:00:00:000, NumC=0,CMin=0,CMax=3,CAvg=0.00, CAva=57,CReq=57,CCnt=57,DCCnt=57, CTimeT=000:41:00:000,CTimeAvg=000:00:00:000, RBT=5404,RBS=1,RBSC=2,SBT=7626,SBS=2,SBSC=3
2012-03-15 20:05:59 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2012-03-15 21:05:59 cmd_auto server info log
user = 0 (0/5000)
2012-03-15 21:05:59 T=002:00:00:000, NumC=0,CMin=0,CMax=5,CAvg=0.00, CAva=136,CReq=136,CCnt=136,DCCnt=136, CTimeT=000:54:00:000,CTimeAvg=000:00:00:000, RBT=10779,RBS=1,RBSC=3,SBT=15986,SBS=2,SBSC=4
2012-03-15 21:05:59 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2012-03-15 22:06:00 cmd_auto server info log
user = 0 (0/5000)
2012-03-15 22:06:00 T=003:00:00:000, NumC=0,CMin=0,CMax=5,CAvg=0.00, CAva=198,CReq=198,CCnt=198,DCCnt=198, CTimeT=001:06:00:000,CTimeAvg=000:00:00:000, RBT=17848,RBS=1,RBSC=4,SBT=26402,SBS=2,SBSC=6
2012-03-15 22:06:00 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
Quote:
2012-03-15 20:57:42 connect game
2012-03-15 20:58:01 [Shine] NewUser Enter : Char=Demowerad, Lv=80, Map=1, X=578.0, Z=1762.1
2012-03-15 20:59:04 [Shine] NewUser Enter : Char=Monkey.DLuffy, Lv=80, Map=1, X=1041.6, Z=813.5
2012-03-15 21:01:47 [Shine] NewUser Enter : Char=-Taylor-, Lv=80, Map=68, X=237.6, Z=1691.0
2012-03-15 21:03:23 [Shine] NewUser Enter : Char=Outta, Lv=80, Map=1, X=1003.5, Z=757.8
2012-03-15 21:03:59 [Shine] NewUser Leave : Char=Demowerad, Lv=80, Map=1, X=607.1, Z=1728.1
2012-03-15 21:04:04 [Shine] NewUser Enter : Char=Demowerad, Lv=80, Map=1, X=607.1, Z=1728.1
2012-03-15 21:05:57 [Shine] NewUser Leave : Char=Monkey.DLuffy, Lv=80, Map=42, X=52.1, Z=54.5
2012-03-15 21:06:04 [Shine] NewUser Enter : Char=Red_Lion, Lv=15, Map=18, X=409.3, Z=141.0
2012-03-15 21:08:54 [Shine] NewUser Leave : Char=Red_Lion, Lv=15, Map=18, X=408.7, Z=148.0
2012-03-15 21:09:01 [Shine] NewUser Enter : Char=Free.Boy, Lv=15, Map=18, X=411.3, Z=143.9
2012-03-15 21:12:49 [Shine] NewUser Enter : Char=TacticKing, Lv=80, Map=42, X=58.9, Z=52.7
2012-03-15 21:16:48 [Shine] NewUser Leave : Char=Outta, Lv=80, Map=1, X=1067.5, Z=755.0
2012-03-15 21:17:53 [Shine] NewUser Leave : Char=Free.Boy, Lv=15, Map=18, X=496.2, Z=493.6
2012-03-15 21:17:58 [Shine] NewUser Enter : Char=Red_Lion, Lv=15, Map=18, X=408.7, Z=148.0
2012-03-15 21:23:21 [Shine] NewUser Leave : Char=Demowerad, Lv=80, Map=42, X=51.5, Z=44.2
2012-03-15 21:24:08 [Shine] Money Over : Char=Energy, Old=0, Now=3996824300
2012-03-15 21:26:15 [Shine] NewUser Enter : Char=Outta, Lv=80, Map=1, X=1067.5, Z=755.0
2012-03-15 21:26:20 [Shine] NewUser Enter : Char=CopyRight, Lv=80, Map=42, X=54.8, Z=44.1
2012-03-15 21:30:44 [Shine] NewUser Leave : Char=Outta, Lv=80, Map=42, X=58.0, Z=54.0
2012-03-15 21:35:08 [Shine] NewUser Leave : Char=Red_Lion, Lv=15, Map=18, X=413.1, Z=146.6
2012-03-15 21:35:14 [Shine] NewUser Enter : Char=Monkey.DLuffy, Lv=80, Map=42, X=52.1, Z=54.5
2012-03-15 21:37:38 [Shine] NewUser Leave : Char=Monkey.DLuffy, Lv=80, Map=42, X=53.2, Z=51.6
2012-03-15 21:37:45 [Shine] NewUser Enter : Char=Lion, Lv=80, Map=42, X=46.1, Z=48.9
2012-03-15 21:41:47 [Shine] Money Over : Char=GuessWho, Old=0, Now=2003210483
2012-03-15 21:42:21 [Shine] NewUser Leave : Char=Lion, Lv=80, Map=42, X=49.4, Z=53.8
2012-03-15 21:42:27 [Shine] NewUser Enter : Char=Monkey.DLuffy, Lv=80, Map=42, X=53.2, Z=51.6
2012-03-15 21:49:54 [Shine] NewUser Enter : Char=DivaReborn, Lv=80, Map=2, X=165.2, Z=397.9
2012-03-15 21:57:15 [Shine] NewUser Leave : Char=CopyRight, Lv=80, Map=42, X=55.1, Z=52.1
2012-03-15 21:58:22 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 21:58:22 1 1 T=001:00:00:000, RC=123,RCS=0, RB=8553,RBS=2, SC=34,SCS=0, SB=2081,SBS=0
2012-03-15 21:58:22 disconnect game
2012-03-15 22:00:36 connect game
Quote:
2012-03-15 19:05:35 PS_USERLOG__system log start (UserLog)
2012-03-15 19:05:37 connect
2012-03-15 19:05:48 connect
2012-03-15 19:06:51 connect
2012-03-15 20:56:17 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 20:56:17 1 1 T=001:49:00:000, RC=47,RCS=0, RB=693,RBS=0, SC=22,SCS=0, SB=88,SBS=0
2012-03-15 20:56:17 disconnect
2012-03-15 20:57:41 connect
2012-03-15 21:58:22 1 1 SAgent::Disconnect: (4, 64)
2012-03-15 21:58:22 1 1 T=001:00:00:000, RC=23,RCS=0, RB=342,RBS=0, SC=12,SCS=0, SB=48,SBS=0
2012-03-15 21:58:22 disconnect
2012-03-15 22:03:11 connect
Quote:
2012-03-15 22:02:09 PS_GAME__system log start (Game01) [KR]
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/sorp1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/croco1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/croco2
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Troll1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Spink1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/GoldenPig
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Sorp3
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/SorpNamed1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/SorpNamed2
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Sorp2
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/CrocoNamed1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/CrocoNamed2
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/CrocoNamed3
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/OrcNamed1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/OrcNamed2
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/OrcNamed3
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/TrollNamed1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Deinos
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Parridalis
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Alcarian
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/ZinAlcaria
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Belizabeth
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Kirhiross
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/CrypticOne
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Haruhion
2012-03-15 22:02:09 Loaded Behavior In Factory : data/ai/Freezing
2012-03-15 22:02:57 <Console input> /nprotectoff
2012-03-15 22:02:57 <Console output> cmd NProtect off ok
2012-03-15 22:03:11 connect mgr 596
2012-03-15 22:03:11 connect dbagent 604
2012-03-15 22:03:11 connect dbagent2 616
2012-03-15 22:03:11 connect gamelog 648
2012-03-15 22:03:11 Market End -----------------------
2012-03-15 22:03:12 cannot open .\Data\Lua\145.lua: No such file or directory
2012-03-15 22:03:12 cannot open .\Data\Lua\144.lua: No such file or directory
2012-03-15 22:03:12 cannot open .\Data\Lua\136.lua: No such file or directory
2012-03-15 22:03:12 cannot open .\Data\Lua\129.lua: No such file or directory
2012-03-15 22:03:12 cannot open .\Data\Lua\149.lua: No such file or directory
2012-03-15 22:03:12 cannot open .\Data\Lua\129.lua: No such file or directory