Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Mobile]Dragon Nest Mobile 1.5.461 Multilangue(Centos Server)

Joined
Jan 24, 2007
Messages
651
Reaction score
323
my game dont save progress character...
i'm level 20, relog, come back to lvl 4.
any ideia for this erro?

ps: in local server work fine, this error for vps (wan)

Code:
08:06:50 [Debug] ProcessReply(mysqlthread.cpp:128) task GlobalUpdateTask finished, sql use 2(ms), total use 5(ms) threadtype 56112896
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:247) [rolecache] push role write task 285784415931931 into thread 6
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:255) [rolecache] pop write task fail 285784415931931
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountRoleUpdateTask finished, sql use 4(ms), total use 12(ms) threadtype 22542080
[SIZE=2][B][COLOR=#ff0000]08:07:35 [Error] OnReply(rolewritetask.cpp:81) Write role data task failed, roleid: 285784415931931, errMsg: ErrDesc: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline., ErrNo: 1118
[/COLOR][/B][/SIZE]08:07:35 [Debug] OnReply(rolewritetask.cpp:99) Role 285784415931931 update data, totalSize 24440, fieldNum 59, details: WeekEnd4v4Data=7 SQARecord=10 RoleMiscData=133 BagContent=542 CompeteDragonInfo2DB=10 PkRecord=153 DragonRecord2DB=20 FashionRecord=48 SChatRecord=8 DragonGroupDB=0 SpActivity=606 TowerRecord2DB=8 FlowerRecord=10 PayV2Record=287 MilitaryRecord=14 ReportDataRecord=38 PetSysData=19 BattleFieldData=69 LiveRecord=0 PvpData=28 ActivityRecord=28 RoleSystem=1627 IdipData=14 TShowVoteRecord=6 RolePartnerData=20 SBuffRecord=0 AchieveDbInfo=0 NpcFeelingRecord=6 QQVipInfo=0 Designation2DB=38 SpriteRecord=138 SkillRecord=776 ArenaRecord=8 TajieHelp2DB=0 HeroBattleRecord=52 RiskInfo2DB=24 IBShopAllRecord=5460 DragonGuildRecordData=1168 FirstPassRecord=0 RoleTask=78 RoleLotteryInfo=41 RoleFindBackRecord=195 LoginRecord=15 TeamRecord=140 RolePushInfo=0 RoleExtraInfo=26 BuyGoldFatInfo=18 ShopRecord=10195 PlatformShareResult=34 CampRoleRecord=0 RoleConfig=215 StageInfo=144 RoleBrief=120 Attribute=1480 SAtlasRecord=0 RewardRecord=300 LevelSealRecord=19 GuildRecord=37 CheckinRecord=8 
08:07:35 [Debug] OnReply(rolewritetask.cpp:119) Role 285784415931931 update ex data, totalSize 153, fieldNum 8, details: DataMore=63 MechaInfoRecord=0 PasswordProtectInfo=12 DuelRecord=24 Nightmarerecord=16 RiftRecord2Db=0 AncientEquipment=30 FollowerRecord=8 
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleWriteTask finished, sql use 6(ms), total use 12(ms) threadtype 5756672
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountReadTask finished, sql use 0(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountLastSelectTask finished, sql use 1(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleReadTask finished, sql use 2(ms), total use 5(ms) threadtype 5756672
08:07:47 [Info] Execute(onlinewritetask.cpp:51) Online Write insert into tb_dragonnest_onlinecnt(`gameappid`,`timekey`,`gsid`,`zoneareaid`,`onlinecntios`,`onlinecntandroid`, `onlinecntzh`, `onlinecntcht`, `onlinecntkor`, `onlinecnten`, `onlinecntjp`, `onlinecntthai`, `onlinecntind`, `onlinecnttukey`, `onlinecntarab`,`onlinecntna`,`onlinecntfr`,`onlinecntnazh`,`onlinecntes`,`onlinecntpt`,`onlinecntru`,`onlinecntita`,`onlinecntde`) values('wxfdab5af74990787a',1587024467,1003,1003,0,2,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0)
08:07:47 [Debug] ProcessReply(mysqlthread.cpp:128) task OnlineWriteTask finished, sql use 3(ms), total use 5(ms) threadtype 4267153152
08:07:48 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleTaskUpdateTask finished, sql use 3(ms), total use 5(ms) threadtype 30934784
 
Last edited:
Joined
Apr 6, 2012
Messages
545
Reaction score
217
my game dont save progress character...
i'm level 20, relog, come back to lvl 4.
any ideia for this erro?

ps: in local server work fine, this error for vps (wan)

Code:
08:06:50 [Debug] ProcessReply(mysqlthread.cpp:128) task GlobalUpdateTask finished, sql use 2(ms), total use 5(ms) threadtype 56112896
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:247) [rolecache] push role write task 285784415931931 into thread 6
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:255) [rolecache] pop write task fail 285784415931931
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountRoleUpdateTask finished, sql use 4(ms), total use 12(ms) threadtype 22542080
[SIZE=2][B][COLOR=#ff0000]08:07:35 [Error] OnReply(rolewritetask.cpp:81) Write role data task failed, roleid: 285784415931931, errMsg: ErrDesc: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline., ErrNo: 1118
[/COLOR][/B][/SIZE]08:07:35 [Debug] OnReply(rolewritetask.cpp:99) Role 285784415931931 update data, totalSize 24440, fieldNum 59, details: WeekEnd4v4Data=7 SQARecord=10 RoleMiscData=133 BagContent=542 CompeteDragonInfo2DB=10 PkRecord=153 DragonRecord2DB=20 FashionRecord=48 SChatRecord=8 DragonGroupDB=0 SpActivity=606 TowerRecord2DB=8 FlowerRecord=10 PayV2Record=287 MilitaryRecord=14 ReportDataRecord=38 PetSysData=19 BattleFieldData=69 LiveRecord=0 PvpData=28 ActivityRecord=28 RoleSystem=1627 IdipData=14 TShowVoteRecord=6 RolePartnerData=20 SBuffRecord=0 AchieveDbInfo=0 NpcFeelingRecord=6 QQVipInfo=0 Designation2DB=38 SpriteRecord=138 SkillRecord=776 ArenaRecord=8 TajieHelp2DB=0 HeroBattleRecord=52 RiskInfo2DB=24 IBShopAllRecord=5460 DragonGuildRecordData=1168 FirstPassRecord=0 RoleTask=78 RoleLotteryInfo=41 RoleFindBackRecord=195 LoginRecord=15 TeamRecord=140 RolePushInfo=0 RoleExtraInfo=26 BuyGoldFatInfo=18 ShopRecord=10195 PlatformShareResult=34 CampRoleRecord=0 RoleConfig=215 StageInfo=144 RoleBrief=120 Attribute=1480 SAtlasRecord=0 RewardRecord=300 LevelSealRecord=19 GuildRecord=37 CheckinRecord=8 
08:07:35 [Debug] OnReply(rolewritetask.cpp:119) Role 285784415931931 update ex data, totalSize 153, fieldNum 8, details: DataMore=63 MechaInfoRecord=0 PasswordProtectInfo=12 DuelRecord=24 Nightmarerecord=16 RiftRecord2Db=0 AncientEquipment=30 FollowerRecord=8 
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleWriteTask finished, sql use 6(ms), total use 12(ms) threadtype 5756672
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountReadTask finished, sql use 0(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountLastSelectTask finished, sql use 1(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleReadTask finished, sql use 2(ms), total use 5(ms) threadtype 5756672
08:07:47 [Info] Execute(onlinewritetask.cpp:51) Online Write insert into tb_dragonnest_onlinecnt(`gameappid`,`timekey`,`gsid`,`zoneareaid`,`onlinecntios`,`onlinecntandroid`, `onlinecntzh`, `onlinecntcht`, `onlinecntkor`, `onlinecnten`, `onlinecntjp`, `onlinecntthai`, `onlinecntind`, `onlinecnttukey`, `onlinecntarab`,`onlinecntna`,`onlinecntfr`,`onlinecntnazh`,`onlinecntes`,`onlinecntpt`,`onlinecntru`,`onlinecntita`,`onlinecntde`) values('wxfdab5af74990787a',1587024467,1003,1003,0,2,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0)
08:07:47 [Debug] ProcessReply(mysqlthread.cpp:128) task OnlineWriteTask finished, sql use 3(ms), total use 5(ms) threadtype 4267153152
08:07:48 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleTaskUpdateTask finished, sql use 3(ms), total use 5(ms) threadtype 30934784

you have not follow the tuto and verify you db is on compressed



Anyone interest on discord group for fixing this game?

fix this game what you mean ? he run really well and only 2 thing api (for topup and giftcode) and homeshop
 
Last edited:
Joined
Apr 6, 2012
Messages
545
Reaction score
217
it seems your db still on compact not compressed
check if you have same my.cnf then the one on root.tar.gz (installer) if yes try restart mysql and import db again

Code:
mysql> SHOW ENGINES;

for see if innodb work
 
Last edited:
Joined
Apr 6, 2012
Messages
545
Reaction score
217
yes it is ,close debug login and open everywhere else
after on mysql gmaccount find your id (a number for identify account) and enter it in account column in gm account
N.B.: id colomn is for indexing in gmaccount so can left it blank (auto completion)
 
Back
Top