[Help]Why crash?

[rodanio14]

Why alway's when i turn on clanwar server after 3/4 clanwars done server lag's enorm and then just lags and crashes?

[MentaL]

[Psychopath]

could you post the log ?

[rodanio14]

kinda hard to find the log:o i have 10+ mb of logs:o

[rodanio14]

could you post the log ?

nhn server mode is real
Load XML from memory : strings.xml(0x0001) - SUCCESS
Load XML from memory : cserror.xml(0x0001) - SUCCESS
[02/26/08 23:20:29] DBMS connected
[02/26/08 23:20:29] Command registeration completed
10
MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 8-2-29 23:50
10
Inited client file list (1)
success init security.
FILE PATH : C:\Documents and Settings\rodanio\Bureaublad\SkyGamerZ Server File's\GunzServer\MatchServer\MD5HashValue.txt
MD5 Hash Value => 6e ff 40 c1 22 1e 4b 2b 33 ce 22 41 7d c4 3a 3d
================================== Server configure info ==================================
[02/26/08 23:20:30] Release Date : Jun 13 2007
[02/26/08 23:20:30] X-Trap Off
[02/26/08 23:20:30] MD5 Check Off
[02/26/08 23:20:30] Server Country : US
[02/26/08 23:20:30] Command version : (56)
[02/26/08 23:20:30] Event usable state : (false)
[02/26/08 23:20:30] Load event size : (0)
[02/26/08 23:20:30] FileCRCCheckSum usable state : (false)
[02/26/08 23:20:30] FileCRC size : (1)
[02/26/08 23:20:30] Country Code Filter usalbe state : (false)
[02/26/08 23:20:30] Accept Invalied IP state : (true)
[02/26/08 23:20:30] Keeper IP : (212.187.5.89)
[02/26/08 23:20:30] Monitor IP : (127.0.0.1)
===========================================================================================
[02/26/08 23:20:30] Match Server Created (Port:6000)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:25:30] GARBAGE SESSION CLEANING : ClientCount=22, SessionCount=23, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:30:30] GARBAGE SESSION CLEANING : ClientCount=22, SessionCount=23, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:35:30] GARBAGE SESSION CLEANING : ClientCount=23, SessionCount=24, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:40:30] GARBAGE SESSION CLEANING : ClientCount=23, SessionCount=24, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:45:30] GARBAGE SESSION CLEANING : ClientCount=24, SessionCount=25, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:50:30] GARBAGE SESSION CLEANING : ClientCount=24, SessionCount=25, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/26/08 23:55:30] GARBAGE SESSION CLEANING : ClientCount=26, SessionCount=27, AgentCount=1
[02/26/08 23:55:55] ChatRoom Created : 'Staff.'
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::WinTheClanGame - Cannot find either column "game" or the user-defined function or aggregate "game.fnGetMax", or the name is ambiguous.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
[00:00:27] Async DB Query(OnAsyncWinTheClanGame) Failed
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
[02/27/08 00:00:30] GARBAGE SESSION CLEANING : ClientCount=27, SessionCount=28, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.
MMatchDBMgr::UpdateCharLevel - De time-out is verstreken
DB UpdateCharLevel Error : -TaZZ-

[7-Eleven]

WinTheClanGame

Search up for the procs Hakurah posted somewhere in maxtrax thread

not so sure where but im sure its there

USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spWinTheClanGame] Script Date: 12/11/2007 14:40:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object: Stored Procedure dbo.spWinTheClanGame Script Date: 5/10/2007 3:42:10 PM ******/

-- 클랜전 결과 업데이트
ALTER PROC [dbo].[spWinTheClanGame]
@WinnerCLID int,
@LoserCLID int,
@IsDrawGame tinyint,
@WinnerPoint int,
@LoserPoint int,
@WinnerClanName varchar(24),
@LoserClanName varchar(24),
@RoundWins tinyint,
@RoundLosses tinyint,
@MapID tinyint,
@GameType tinyint,
@WinnerMembers varchar(110),
@LoserMembers varchar(110)
AS
SET NOCOUNT ON -- 추가.

IF @IsDrawGame = 0
BEGIN
BEGIN TRAN
-- 이긴팀 Wins+1
UPDATE Clan SET Wins=Wins+1, Point=Point+@WinnerPoint, TotalPoint=TotalPoint+@WinnerPoint WHERE CLID=@WinnerCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END

-- 진팀 Losses+1
UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
-- UPDATE Clan SET Point=0 WHERE CLID=@LoserCLID AND Point<0

-- 전적 로그를 남긴다.
INSERT INTO ClanGameLog(WinnerCLID, LoserCLID, WinnerClanName, LoserClanName, RoundWins, RoundLosses, MapID, GameType, RegDate, WinnerMembers, LoserMembers, WinnerPoint, LoserPoint)
VALUES (@WinnerCLID, @LoserCLID, @WinnerClanName, @LoserClanName, @RoundWins, @RoundLosses, @MapID, @GameType, GETDATE(), @WinnerMembers, @LoserMembers, @WinnerPoint, @LoserPoint)
IF 0 <> @@ERROR BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
COMMIT TRAN
END
ELSE
BEGIN
UPDATE Clan SET Draws=Draws+1 WHERE CLID=@WinnerCLID OR CLID=@LoserCLID
END

and this, fnGetMax

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fnGetMax]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[fnGetMax]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/****** Object: Function fnGetMax by tester001 Script Date: 12/11/2007 14:40:03 ******/
-- Function to return the highest of two numbers

CREATE function [dbo].[fnGetMax] (@num1 int, @num2 int)
returns int
as
begin
if @num1 > @num2
begin
return @num1
end
return @num2
end



GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[rodanio14]

Thxx hope it will work ill tell if it still is crashing.