PS_game crash code=0xC0000005, address=0x004A4915

[andya78]

PHP Code:

2012-04-07 17:17:02 Exception !!!, code=0xC0000005, address=0x004A4915

Minidump write end.....................

0x004A4915 ps_game.exe: <unknown symbol>

Stack trace end.....................



Stack trace(all thread) begin.....................



Module list:

C:\ShaiyaServer\SERVER\PSM_Client\Bin\ps_game.exe, loaded at 0x00400000 - 09/07/15 12:22:00

WARNING: ps_game.exe is not accessible
Symbol search path is: ps_game.pdb
WARNING: ps_game.pdb is not accessible
WARNING: ps_game.pdb is not accessible

Microsoft (R) Windows Debugger  Version 6.3.0017.0
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [C:\ShaiyaServer\SERVER\PSM_Client\Bin\Log\20120407_170233_ps_game.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available

Windows Longhorn Version 6002 (Service Pack 2) MP (2 procs) Free x86 compatible
Product: WinNt, suite: SingleUserTS Personal
Debug session time: Sat Apr 07 17:17:02 2012
System Uptime: not available
Process Uptime: 0 days 0:14:29.000
Symbol search path is: ps_game.pdb
Executable search path is: ps_game.exe
......................................................
The call to LoadLibrary(ext) failed, Win32 error 2
    "The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(exts) failed, Win32 error 2
    "The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(uext) failed, Win32 error 2
    "The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(ntsdexts) failed, Win32 error 2
    "The system cannot find the file specified."
Please check your debugger configuration and/or network access.
(1d3c.1b98): Access violation - code c0000005 (!!! second chance !!!)

thread count = 19
thread 0(4732)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x75B1F4EB ADVAPI32.dll: SetServiceStatus + 735

0x75B1F591 ADVAPI32.dll: SetServiceStatus + 901

0x75B120BB ADVAPI32.dll: StartServiceCtrlDispatcherA + 133

0x004E427D ps_game.exe: <unknown symbol>

0x00540640 ps_game.exe: <unknown symbol>

0x004CCB90 ps_game.exe: <unknown symbol>

0x95E90000 <unknown module>: <unknown symbol>


thread 1(5412)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x7656A910 kernel32.dll: WaitForMultipleObjects + 24

0x004E2B99 ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 2(7564)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D5738 ps_game.exe: <unknown symbol>

0x7656D309 kernel32.dll: BaseThreadInitThunk + 18

0x77481603 ntdll.dll: RtlInitializeExceptionChain + 99

0x774815D6 ntdll.dll: RtlInitializeExceptionChain + 54


thread 3(7656)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 4(3244)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x750C704E MSWSOCK.dll: getnetbyname + 19815

0x7620BBDB WS2_32.dll: WSAAccept + 133

0x004D7ECE ps_game.exe: <unknown symbol>


thread 5(6984)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 6(8068)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 7(984)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 8(6676)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x004DCB92 ps_game.exe: <unknown symbol>


thread 9(8048)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x004DCB92 ps_game.exe: <unknown symbol>


thread 10(7136)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x004DCB92 ps_game.exe: <unknown symbol>


thread 11(5136)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x004DCB92 ps_game.exe: <unknown symbol>


thread 12(5380)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 13(1288)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>


thread 14(6888)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x00406FEC ps_game.exe: <unknown symbol>


thread 15(7064)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x04390A50 dbghelp.dll: SymGetModuleBase

0x52990C45 <unknown module>: <unknown symbol>

0x52990C45 <unknown module>: <unknown symbol>


thread 16(6172)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x0040734B ps_game.exe: <unknown symbol>


thread 17(5852)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x0040734B ps_game.exe: <unknown symbol>


thread 18(7552)

0x774A5CD4 ntdll.dll: KiFastSystemCallRet

0x76569A12 kernel32.dll: WaitForSingleObject + 18

0x004D9E2B ps_game.exe: <unknown symbol>

0xFF006AEC <unknown module>: <unknown symbol>



Stack trace(all thread) end.....................

================================================================ 


This is my last and final issue with my server and i can't for the life of me find anyway to fix it ive searched google and only found 1 thread with this issue but noone replied to the guy and so im here hoping someone will be helpful and open my eyes a bit

[RebeccaBlack]

I went to that address and it's part of a function, but I didn't immediately see what the function's use was.

When does this problem occur? Has it just started to occur? When does PS_Game crash? What all does it load before crashing?

Those questions will help us answer you better, so we can figure out how far the executable is loading before it ***** itself.

[andya78]

nice phrasing of words there lol... it varies sometimes it works fine for a large number of hours sometimes it goes down every 5 mins ive been narrowing down the erros in the databases fixing each one as i see it in the logs and the last one is
2012-04-09 02:46:03 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2012-04-09 02:46:03 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'pita66','******', 3535936494785003521,'75.23.***.***, [Microsoft][ODBC Driver Manager] Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2012-04-09 03:40:50 cmd_auto server info log
but its not always the same account

if you can put the tags in next reply for a spoiler il add the stored procedure up here see if its an error in that

[RebeccaBlack]

Originally Posted by andya78

nice phrasing of words there lol... it varies sometimes it works fine for a large number of hours sometimes it goes down every 5 mins ive been narrowing down the erros in the databases fixing each one as i see it in the logs and the last one is
2012-04-09 02:46:03 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2012-04-09 02:46:03 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'pita66','******', 3535936494785003521,'75.23.***.***, [Microsoft][ODBC Driver Manager] Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2012-04-09 03:40:50 cmd_auto server info log
but its not always the same account

if you can put the tags in next reply for a spoiler il add the stored procedure up here see if its an error in that

[spoiler][/spoiler] is the "spoiler" tags.

The "Cursor" error is due to the SP not returning the proper values, it should return the "Status" of the user, and the UserUID of the user. At the bottom of the SP, it should have this:

SELECT @Status AS [Status], @UserUID AS UserUID

[andya78]

 Spoiler

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 04/09/2012 19:57:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/*================================================= =
@date 2007-12-04
@brief Login Proc( Taiwan )
================================================== */

ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

@UserID varchar(18),
@InPassword varchar(32),

@SessionID bigint,
@UserIP varchar(15),

-- 罹晦梱雖 蹂 檣濠, 釭該雖朝 頂睡 滲熱

@UserUID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@Status smallint,

@CompanyIP varchar(15),
@TempIP varchar(15),
@ChPw varchar(50),
@Check int

SET @Status = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check =1
--------------------------------------------------

SELECT @UserUID=UserUID, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
ELSE
BEGIN
-- Check Password
--EXEC PS_UserData.dbo.sp_LoginSuccessCheck @UserID, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @Status = -1
END
END
ELSE
BEGIN
SET @Status = -1
END

SELECT @UserUID=UserUID,@ChPw=Pw FROM Users_Master WHERE UserID = @UserID

IF ( @InPassword <> @ChPw)
BEGIN
RETURN -1;
END


/* Old
SET @InEnPassword = master.dbo.fn_md5(@InPassword)
IF ( @InEnPassword <> @EnPassword )
BEGIN
SET @Status = -1
END
*/
END

-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
END
END
END

-- Admin IP Check(2006-02-21)
/*
IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
SET @TempIP = LEFT(@UserIP, 9)
IF( @TempIP <> @CompanyIP )
BEGIN
SET @Status = -999
END
END
*/

-- Select
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
END

SET NOCOUNT OFF

oo it worked this time must of used the wrong tags around the spoiler :/ nubbie mistake lol

this is the SP ive got