AQ Failed! Log Out!! [AQType : 5]

[Saltemo]

Everytime I try to spawn a pickpet or attack pet, i got DC.
And then, the game server gives this message.

 Spoiler

AQ Failed! Log Out!! [AQType : 5]

Try _AddNewCos but is'n solved.

PHP Code:

USE [sro_vt_shard]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewCOS]    Script Date: 1/25/2018 12:42:44 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwNeRCharID    int,  [MENTION=975074]Refo[/MENTION]bjID    int,
@level    int,
@HP    int,
@MP    int,
@HGP    int,
@keeperNPC    int,  [MENTION=1174895]state[/MENTION]    int,
@inventorySize int,
@itemID    int,  [MENTION=830797]Picki[/MENTION]temConfig tinyint,  [MENTION=5344908]renten[/MENTION]dTime smalldatetime
as

begin tran

declare @CoS_ID    int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--    pet_skill_item (ÃÖ¼±È£)    
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

declare @MaxinventorySize tinyint
select @MaxinventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = [MENTION=975074]Refo[/MENTION]bjID and _RefObjCommon.Link = _RefObjChar.ID

if( @@rowcount = 0 or @MaxinventorySize < @inventorySize )
begin
rollback tran
return -5
end

insert into _CharCOS values ( @OwNeRCharID, [MENTION=975074]Refo[/MENTION]bjID, @HP, 0, 1, [MENTION=1174895]state[/MENTION], NULL, @level, 0, @HGP, [MENTION=830797]Picki[/MENTION]temConfig, [MENTION=5344908]renten[/MENTION]dTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @CoS_ID = @@identity
if @CoS_ID = 0 OR ( @@error <> 0)
begin
rollback tran
return -1
end

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--    pet_skill_item (ÃÖ¼±È£)    
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if ( @MaxinventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare [MENTION=303108]slot[/MENTION] int
set [MENTION=303108]slot[/MENTION] = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--    pet_skill_item (ÃÖ¼±È£)    
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while [MENTION=303108]slot[/MENTION] < (@MaxinventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values (@CoS_ID, [MENTION=303108]slot[/MENTION], 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end    

set [MENTION=303108]slot[/MENTION] = [MENTION=303108]slot[/MENTION] + 1
end
end

/*    --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @CoS_ID WHERE CharID = @OwNeRCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @CoS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
end

commit tran

declare @bla varchar(max);
select @bla = codename128 from _refobjcommon where ID = [MENTION=975074]Refo[/MENTION]bjID
if @bla like '%COS_T%'
begin
WAITFOR DELAY '0:00:00.5'
return @CoS_ID
END

return @CoS_ID 


[blapanda]

Just a short question, to make it sure:
Did you initially decreased the total mob count?
If not, that will be your problem, due tobstock server settings having way too much mobs being spawned for a single game server.
Try to decrease it (there are enough queries around for that), and try spawning your pets again.

[Saltemo]

Originally Posted by blapanda

Just a short question, to make it sure:
Did you initially decreased the total mob count?
If not, that will be your problem, due tobstock server settings having way too much mobs being spawned for a single game server.
Try to decrease it (there are enough queries around for that), and try spawning your pets again.

Server spawn is lower mob rate, single area. Idk why ?

[blapanda]

Originally Posted by Saltemo

Server spawn is lower mob rate, single area. Idk why ?

Seems like people are hinting towards the procedure, which you already took a look about.

Do you have the stock files of your server?
Rename your current SRO_VT_SHARD to XSRO_VT_SHARD and create a new database with a clean backup. Retry it. If this ain't working, it might be something with your client (corrupted data, mostly noticable when joining a grid or an instance and getting "data error!!" while HP, MP and such displaying a zero (0)).

[Saltemo]

Originally Posted by blapanda

Seems like people are hinting towards the procedure, which you already took a look about.

Do you have the stock files of your server?
Rename your current SRO_VT_SHARD to XSRO_VT_SHARD and create a new database with a clean backup. Retry it. If this ain't working, it might be something with your client (corrupted data, mostly noticable when joining a grid or an instance and getting "data error!!" while HP, MP and such displaying a zero (0)).

Thank's for ur reply. I'm look in the _CharCOS table, and no row in there. Smt wrong, clean database, all client files is OK.