|
You last visited: Today at 10:10
Advertisement
Disconnect (DC) And Rollback Verison = SQL Server 2008
Discussion on Disconnect (DC) And Rollback Verison = SQL Server 2008 within the Shaiya PServer Development forum part of the Shaiya Private Server category.
02/04/2017, 21:45
|
#1
|
elite*gold: 0 
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
|
Disconnect (DC) And Rollback Verison = SQL Server 2008
Hello,
There is no error code, and a system running smoothly.
But the game constantly to roll back.
I spent 15 minutes in the game.
But game itself rollback.
How to fix this problem?
Server Files Version: 5.4
Help me Please.  
|
|
|
|
02/04/2017, 22:22
|
#2
|
elite*gold: 0
Join Date: Jan 2013
Posts: 147
Received Thanks: 174
|
You need check usp_Save_Char_ApplySkill_Add_E & usp_Save_Char_ApplySkill_Add_E2 procedure or please send logs here.
|
|
|
|
|
02/04/2017, 22:33
|
#3
|
elite*gold: 0
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
|
Thank you for reply.
|
|
|
|
|
02/04/2017, 22:51
|
#4
|
elite*gold: 0
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
|
Procedures Here
usp_Save_Char_ApplySkill_Add_E Procedure Here:
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E] Script Date: 02/04/2017 23:54:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E]
[MENTION=395373]Chari[/MENTION]D int, [MENTION=563598]Skilli[/MENTION]D smallint, [MENTION=1658622]skilll[/MENTION]evel tinyint, [MENTION=595758]left[/MENTION]ResetTime smallint
AS
SET NOCOUNT ON
INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES [MENTION=395373]Chari[/MENTION]D [MENTION=563598]Skilli[/MENTION]d [MENTION=1658622]skilll[/MENTION]evel [MENTION=595758]left[/MENTION]ResetTime)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
SET NOCOUNT OFF
usp_Save_Char_ApplySkill_Add_E2 Procedure Here:
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2] Script Date: 02/04/2017 23:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]
[MENTION=395373]Chari[/MENTION]D int, [MENTION=563598]Skilli[/MENTION]D smallint, [MENTION=1658622]skilll[/MENTION]evel tinyint, [MENTION=595758]left[/MENTION]ResetTime int
AS
SET NOCOUNT ON
INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES [MENTION=395373]Chari[/MENTION]D [MENTION=563598]Skilli[/MENTION]d [MENTION=1658622]skilll[/MENTION]evel [MENTION=595758]left[/MENTION]ResetTime)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
SET NOCOUNT OFF
PS_GAME LOG :
Code:
2017-02-04 21:36:53 PS_GAME__system log start (Game01) [GERMANY]
2017-02-04 21:36:53 RandomOption Error : ItemID=24070, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24111, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24112, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24118, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24119, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24125, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24126, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24154, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24240, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24249, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24250, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24251, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24252, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24253, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=24254, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39070, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39111, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39112, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39118, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39119, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39125, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39126, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39154, byServer=2, Wis=0
2017-02-04 21:36:53 RandomOption Error : ItemID=39240, byServer=2, Wis=0
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:54 error mob item drop info load error
2017-02-04 21:36:55 connect mgr 1012
2017-02-04 21:36:55 Server Version : 0
2017-02-04 21:36:55 connect dbagent 1016
2017-02-04 21:36:55 connect gamelog 1032
2017-02-04 21:36:55 Market End -----------------------
2017-02-04 21:36:56 cannot open .\Data\Lua\135.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\145.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\144.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\129.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\126.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\141.lua: No such file or directory
2017-02-04 21:36:56 cannot open .\Data\Lua\126.lua: No such file or directory
2017-02-04 21:36:56 Start CWorldSendThread=2252
Module list:
C:\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08
2017-02-04 21:37:07 <Console input> /nprotectoff
2017-02-04 21:37:07 <Console output> cmd NProtect off ok
2017-02-04 21:53:30 discon client: (104, 1236) T=000:12:00:000, RC=1750,RCS=2, RB=25775,RBS=33, SC=4327,SCS=5, SB=75430,SBS=98
2017-02-04 22:13:32 3 1 SERVICE_CONTROL_STOP
2017-02-04 22:13:32 Call save all waiting...
2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)
2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)
2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=45,RCS=0, RB=5506,RBS=2, SC=110,SCS=0, SB=1927,SBS=0
2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=12,RCS=0, RB=345,RBS=0, SC=20,SCS=0, SB=257,SBS=0
2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)
2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=12,SCS=0, SB=196,SBS=0
2017-02-04 22:13:32 discon dbagent ((3,1236, 5506,1927)
2017-02-04 22:13:32 discon userlog ((3,1236, 24,196)
2017-02-04 22:13:32 userlog Connection Lost INFO : T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=12,SCS=0, SB=196,SBS=0
2017-02-04 22:13:32 dbagent Connection Lost INFO : T=000:36:00:000, RC=45,RCS=0, RB=5506,RBS=2, SC=110,SCS=0, SB=1927,SBS=0
2017-02-04 22:13:32 userlog log server disconnection
2017-02-04 22:13:32 db agent server disconnected...
2017-02-04 22:13:32 call disconnectAll...
2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)
2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=59,SCS=0, SB=6823,SBS=3
2017-02-04 22:13:32 discon mgr ((3,1236, 345,257)
2017-02-04 22:13:32 discon gamelog ((3,1236, 24,6823)
2017-02-04 22:13:32 mgr Connection Lost INFO : T=000:36:00:000, RC=12,RCS=0, RB=345,RBS=0, SC=20,SCS=0, SB=257,SBS=0
2017-02-04 22:13:32 gamelog Connection Lost INFO : T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=59,SCS=0, SB=6823,SBS=3
2017-02-04 22:13:32 mgr server disconnection
2017-02-04 22:13:32 game log server disconnection
2017-02-04 22:13:32 server shutdown Connection INFO : T=000:36:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=3,CReq=3,CCnt=3,DCCnt=3, CTimeT=000:14:00:000,CTimeAvg=000:04:00:000, RBT=26074,RBS=11,RBSC=29,SBT=79566,SBS=36,SBSC=89
2017-02-04 22:13:32 PS_GAME__system log end (Game01)
2017-02-04 22:13:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_DBAGENT LOG:
Code:
2017-02-04 21:36:50 PS_DBAGENT__system log start (DBAgent01)
Module list:
C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57
2017-02-04 21:36:55 ### Connect[144] : Game[?][0x00F6EB30], Addr=127.0.0.1, DBJobEnd=1
2017-02-04 21:36:55 ### DB_SYSTEM_CONNECT[3964] :Game[1][0x00F6EB30], Name=Game01, Addr=127.0.0.1
2017-02-04 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable [MENTION=563598]Skilli[/MENTION]d"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2017-02-04 21:53:29 ::SaveCharacter 6 Basaran ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(6,46,1,900)}
2017-02-04 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable [MENTION=563598]Skilli[/MENTION]d"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2017-02-04 21:53:29 ::SaveCharacter 6 Basaran ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(6,46,1,900)}
2017-02-04 22:13:32 1 1 SAgent::Disconnect: (4, 64)
2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=110,RCS=0, RB=1927,RBS=0, SC=45,SCS=0, SB=5506,SBS=2
2017-02-04 22:13:32 ### Disconnect[3172] : Game[1][0x00F6EB30], Name=Game01, Addr=127.0.0.1, DBJobEnd=0
2017-02-04 22:13:32 ### PostDispatchDB[3172] : DB_DISPATCHER_EXIT Game[1][0x00F6EB30]
2017-02-04 22:13:32 ### OnDispatchDB[584] : => DB_DISPATCHER_EXIT Game[1][0x00F6EB30]
2017-02-04 22:13:32 3 1 SERVICE_CONTROL_STOP
2017-02-04 22:13:32 ### Save[584] : Game[1][0x00F6EB30]
2017-02-04 22:13:32 ### OnDispatchDB[584] : <= DB_DISPATCHER_EXIT Game[1][0x00F6EB30]
2017-02-04 22:13:32 PS_DBAGENT__system log end (DBAgent01)
2017-02-04 22:13:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Please help.
|
|
|
|
|
02/05/2017, 10:27
|
#5
|
elite*gold: 0
Join Date: Jan 2013
Posts: 147
Received Thanks: 174
|
Hello,
in 2 procedure you see "Skillid" you need change to SkillID.
|
|
|
|
 |
Similar Threads
|
[Verkaufe] Windows Server 2008 / 2008 R2 Lizenzen
03/27/2012 - Off Topic - 2 Replies
Windows Server 2008 / 2008 R2 Lizenzen und falls gewüscht stelle ich auch dem Käufer das Passende Image dazu zur verfügung. Alles 100% legale Keys und auch aus 100% legalen Quellen (Microsoft Partnerprogramme) erworben. Ich kann euch von Web Server Edition bis hin zu Itanium Based alles bieten. Nur solange der Vorrat reicht.
Bezahlungsmittel: Paypal (anderes nur in Einzelfällen akzeptabel)
Also NUR SOLANGE DER VORRAT REICHT ^^
|
Rollback bei Server shutdown
06/29/2005 - World of Warcraft - 6 Replies
jeden dienstag oder mittwoch ancht werden ja server runtergefahren, geht das, dsa man maybe mit dem guide ausm hack forum so rollbacked ?
also 2 spieler brauch man.
spieler 1 stells shice ins AH für xxxx Gold
spieler 2 kauft es ~ 10 sekunden vor server shut down und der andere spieler 1 nimmts ausm briefkasten und geht schnel lraus (maybe macht mans 20 sekunden vor shutdown damit man mehr zeit hat)
spieler 2 bleibt drinnen bsi er gekcikt wird.
|
All times are GMT +1. The time now is 10:10.
|
|
![[GM]SkyLine.™'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar5006420_8.gif){kind=avatar}
