Freezes when someone logs in

[Auntie Mangos]

Yep, I have read http://getmangos.eu/community/viewtopic.php?id=14420 and I have truncate that tables, also tell the player to delete WTF folder, but this seems to be a infinite loop at login, in that post server crashes, it didn't get freezed I will check a couple of things in the code and tomorrow I will post my findings.

EDIT: Now I think it's not related anyway with login, that output is created for people that tries to log in after the freeze starts, I will research more.

[ankso]

Hi guys,

I have a problem, sometimes when someone logs into the server, it gets freezed and then crashes due to the anti-freeze system, so, someone knows what could be the reason or if someone has had the same problem? Thx

[VladimirMangos]

Possible some corrupted data in player DB data. Ofc, in good case it must be detected by code at load, but possible some checks missing.

If you catch related character, please make pdump (.pdump command in console) and send created file to me by PM.

[ankso]

OK, I think it's related to log-in the account, not with a character. This is the last output in debug mode:

WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::HandleAuthSession: client 12340, unk2 0, account MR_ANKSO, unk3 0,
clientseed 3939015508
[0 ms] SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, v, s, expansion, mu
tetime, locale FROM account WHERE username = 'MR_ANKSO'
WorldSocket::HandleAuthSession: (s,v) check s: FD2D0F58F38A2EC6EA96E5777C9D9F652
C46DDF8484352963A9A061CA7B58E23 v: 42480A2BF0B34612106F2822557932E743A2BD5152D0E
65347CEDE1CDFABF0A2
[0 ms] SQL: SELECT 1 FROM account_banned WHERE id = 5 AND active = 1 AND (unband
ate > UNIX_TIMESTAMP() OR unbandate = bandate)UNION SELECT 1 FROM ip_banned WHER
E (unbandate = bandate OR unbandate > UNIX_TIMESTAMP()) AND ip = '127.0.0.1'
WorldSocket::HandleAuthSession: Client 'MR_ANKSO' authenticated successfully fro
m 127.0.0.1.
[0 ms] SQL: SELECT type, time, data FROM account_data WHERE account='5'
[0 ms] SQL: SELECT tut0,tut1,tut2,tut3,tut4,tut5,tut6,tut7 FROM character_tutori
al WHERE account = '5'
ADDON: Name: Blizzard_AchievementUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x
0
ADDON: Name: Blizzard_ArenaUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_AuctionUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_BarbershopUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0

ADDON: Name: Blizzard_BattlefieldMinimap, Enabled: 0x1, CRC: 0x4c1c776d, Unknown
2: 0x0
ADDON: Name: Blizzard_BindingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_Calendar, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_CombatLog, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_CombatText, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_DebugTools, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GlyphUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GMChatUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GMSurveyUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GuildBankUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_InspectUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_ItemSocketingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2:
0x0
ADDON: Name: Blizzard_MacroUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_RaidUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TalentUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TimeManager, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TokenUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TradeSkillUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0

ADDON: Name: Blizzard_TrainerUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
[0 ms] SQL: UPDATE account SET last_ip = '127.0.0.1' WHERE username = 'MR_ANKSO'

WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::HandleAuthSession: client 12340, unk2 0, account MR_ANKSO, unk3 0,
clientseed 3939015508
[0 ms] SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, v, s, expansion, mu
tetime, locale FROM account WHERE username = 'MR_ANKSO'
WorldSocket::HandleAuthSession: (s,v) check s: FD2D0F58F38A2EC6EA96E5777C9D9F652
C46DDF8484352963A9A061CA7B58E23 v: 42480A2BF0B34612106F2822557932E743A2BD5152D0E
65347CEDE1CDFABF0A2
[0 ms] SQL: SELECT 1 FROM account_banned WHERE id = 5 AND active = 1 AND (unband
ate > UNIX_TIMESTAMP() OR unbandate = bandate)UNION SELECT 1 FROM ip_banned WHER
E (unbandate = bandate OR unbandate > UNIX_TIMESTAMP()) AND ip = '127.0.0.1'
WorldSocket::HandleAuthSession: Client 'MR_ANKSO' authenticated successfully fro
m 127.0.0.1.
[0 ms] SQL: SELECT type, time, data FROM account_data WHERE account='5'
[0 ms] SQL: SELECT tut0,tut1,tut2,tut3,tut4,tut5,tut6,tut7 FROM character_tutori
al WHERE account = '5'
ADDON: Name: Blizzard_AchievementUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x
0
ADDON: Name: Blizzard_ArenaUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_AuctionUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_BarbershopUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0

ADDON: Name: Blizzard_BattlefieldMinimap, Enabled: 0x1, CRC: 0x4c1c776d, Unknown
2: 0x0
ADDON: Name: Blizzard_BindingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_Calendar, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_CombatLog, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_CombatText, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_DebugTools, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GlyphUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GMChatUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GMSurveyUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_GuildBankUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_InspectUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_ItemSocketingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2:
0x0
ADDON: Name: Blizzard_MacroUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_RaidUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TalentUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TimeManager, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TokenUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
ADDON: Name: Blizzard_TradeSkillUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0

ADDON: Name: Blizzard_TrainerUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0
[0 ms] SQL: UPDATE account SET last_ip = '127.0.0.1' WHERE username = 'MR_ANKSO'

WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection
WorldSocket::handle_input: Peer has closed connection

and the same again and again...

This output is repeated until anti-freeze system kill the proccess, so it's not a crash, no crashlog. Anyone knows what could cause this? Do you still want the dumps of the characters of that accounts Vladimir? I'm using rev. 10313 in Ubuntu x64.

[VladimirMangos]

Ah, i see. I read that some account_data form pre-3.3.5 create problems with 3.3.5 client. But this in some way can affect server if client start work incorrectly.

I suggest drop account_data for this account (you will lost macros, some other settings reset to default). And look at affect.

[ankso]

OK, I think it's related with auras. The last output, always, is:

Aura XX now is remove mode X

Then it gets stucked and I have to kill the process, no crash. ¿Anyone knows where it could get freezed there?

[VladimirMangos]

Then possible fixed in [10319]

[crashuncle]

Has this been fixed in the 0.12 branch already? (Still existed on S009x)

[VladimirMangos]

Bug fixed in [10319] not exist in 0.12. It related to aura holders not backported yet to 0.12.