• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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

Joined
Jan 24, 2007
Messages
652
Reaction score
324
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