Jump to content
TrinityCore
Sign in to follow this  
Legendwow

[SOLVED]Minor server hangs [help]

Recommended Posts

Server configuration.
Ubunt-16,04-x86_64
CPU frequency
2400 MHz
RAM
3072 MiB
Number of processors
3
HDD
92160 MiB (8445 MiB is used)
Traffic is unlimited. 100mb channel
==========================
Created the server. Online ran 7 bodies (including me) at all stable ping 50-70
There is almost no load on the servo. Busy almost always 500MB of RAM from 3g.
I start the server through the screen.
What changed. Made server currency through the already available. I deleted the square that gave this currency.
Sometimes when you learn skills, there is a pause in 1 second or even 5.
The whole server complains that there are jams.
Assembling off Trinity. As I understood the last revision. I compiled everything myself! I also tuned everything myself.
In TrinityAdmin sometimes shows an update of Diff under 2k is this the norm?

 

 

 

Tell me where to pick?
Strange server logs

 

Spell Id 6940 has DBC ProcFlags 699048, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 7366 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 18499 has DBC ProcFlags 139944, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 28313 has DBC ProcFlags 1581224, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 32065 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 33891 has DBC ProcFlags 174624, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 35244 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 36659 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 40453 has DBC ProcFlags 1581224, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 40879 has DBC ProcFlags 664096, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 41341 has DBC ProcFlags 1747624, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 44586 has DBC ProcFlags 697000, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 45092 has DBC ProcFlags 664232, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 49145 has DBC ProcFlags 131072, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 50462 has DBC ProcFlags 131752, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 50498 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 51809 has DBC ProcFlags 131752, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53032 has DBC ProcFlags 81936, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53578 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53579 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53580 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53581 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53582 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 62142 has DBC ProcFlags 69648, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 64205 has DBC ProcFlags 699048, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 66334 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67905 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67906 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67907 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72151 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72648 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72649 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72650 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Item (Entry: 5828) has wrong (non-existing?) stat_type1 (51)
Item (Entry: 5828) has wrong (non-existing?) stat_type2 (52)
Item (Entry: 5828) has wrong (non-existing?) stat_type3 (54)
Item (Entry: 5828) has wrong (non-existing?) stat_type4 (56)
Item (Entry: 5828) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 17802) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 17802) has wrong (non-existing?) stat_type4 (55)
Item (Entry: 18881) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 19065) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 19158) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20142) has wrong (non-existing?) stat_type4 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type5 (52)
Item (Entry: 20142) has wrong (non-existing?) stat_type6 (54)
Item (Entry: 20142) has wrong (non-existing?) stat_type7 (56)
Item (Entry: 20142) has wrong (non-existing?) stat_type8 (55)
Item (Entry: 20522) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type4 (54)
Item (Entry: 21614) has wrong (non-existing?) stat_type3 (55)
Item (Entry: 22230) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type6 (51)
Item (Entry: 23362) has wrong (non-existing?) stat_type7 (54)
Item (Entry: 23363) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 23363) has wrong (non-existing?) stat_type6 (56)
Item (Entry: 32113) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32114) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32115) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32116) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32117) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32118) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32119) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32121) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32122) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32123) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32128) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32129) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32130) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32131) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32132) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 34187) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 34967) has deprecated stat_type4 (41)
Item (Entry: 34967) has deprecated stat_type5 (42)
Item (Entry: 36942) does not have a correct SoundOverrideSubclass (-1), must be 8 .
Item (Entry: 36942) does not have a correct material (1), must be -1 .
Item (Entry: 36942) does not have a correct display id (65153), must be 46609 .
Item (Entry: 40762) has wrong (non-existing?) stat_type5 (51)
Item (Entry: 45860) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 48945) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 49312) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 49314) has wrong (non-existing?) stat_type5 (51)
Creature template (Entry: 50100) does not exist but has a record in `creature_equip_template`
Table `creature` has creature (GUID: 213876) with non existing creature entry 50100, skipped.
Table `creature` has creature (GUID: 213896 Entry: 36597) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature is not in instance.
Table `creature_queststarter`: Quest 12170 listed for entry 27120 does not exist.
Table `creature_queststarter`: Quest 12443 listed for entry 27495 does not exist.
Table `creature_queststarter`: Quest 12314 listed for entry 27520 does not exist.
Table `creature_queststarter`: Quest 12315 listed for entry 27532 does not exist.
Table `creature_queststarter`: Quest 12317 listed for entry 27563 does not exist.
Table `creature_queststarter`: Quest 12323 listed for entry 27602 does not exist.
Table `creature_queststarter`: Quest 12432 listed for entry 27708 does not exist.
Table `creature_queststarter`: Quest 12444 listed for entry 27783 does not exist.
Table `creature_questender`: Quest 12170 listed for entry 27120 does not exist.
Table `creature_questender`: Quest 12443 listed for entry 27495 does not exist.
Table `creature_questender`: Quest 12314 listed for entry 27520 does not exist.
Table `creature_questender`: Quest 12315 listed for entry 27532 does not exist.
Table `creature_questender`: Quest 12317 listed for entry 27563 does not exist.
Table `creature_questender`: Quest 12323 listed for entry 27602 does not exist.
Table `creature_questender`: Quest 12432 listed for entry 27708 does not exist.
Table `creature_questender`: Quest 12444 listed for entry 27783 does not exist.
Table 'creature_loot_template' Entry 50100 isn't creature entry and not referenced from loot, and thus useless.
Table 'item_loot_template' Entry 50100 isn't item entry and not referenced from loot, and thus useless.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12434), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12443), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12432), skipped.
Quest 12323 (alliance_id) referenced in `player_factionchange_quests` does not exist, pair skipped!
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (70, 11915, 1)
[ERROR]: [1062] Duplicate entry '70-11915' for key 'PRIMARY'
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (70, 11915, 1)
[ERROR]: [1062] Duplicate entry '70-11915' for key 'PRIMARY'
Spell Id 6940 has DBC ProcFlags 699048, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 7366 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 18499 has DBC ProcFlags 139944, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 28313 has DBC ProcFlags 1581224, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 32065 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 33891 has DBC ProcFlags 174624, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 35244 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 36659 has DBC ProcFlags 262144, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 40453 has DBC ProcFlags 1581224, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 40879 has DBC ProcFlags 664096, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 41341 has DBC ProcFlags 1747624, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 44586 has DBC ProcFlags 697000, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 45092 has DBC ProcFlags 664232, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 49145 has DBC ProcFlags 131072, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 50462 has DBC ProcFlags 131752, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 50498 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 51809 has DBC ProcFlags 131752, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53032 has DBC ProcFlags 81936, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53578 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53579 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53580 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53581 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 53582 has DBC ProcFlags 16, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 62142 has DBC ProcFlags 69648, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 64205 has DBC ProcFlags 699048, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 66334 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67905 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67906 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 67907 has DBC ProcFlags 245760, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72151 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72648 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72649 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Spell Id 72650 has DBC ProcFlags 69972, but it's of non-proc aura type, it probably needs an entry in `spell_proc` table to be handled correctly.
Item (Entry: 5828) has wrong (non-existing?) stat_type1 (51)
Item (Entry: 5828) has wrong (non-existing?) stat_type2 (52)
Item (Entry: 5828) has wrong (non-existing?) stat_type3 (54)
Item (Entry: 5828) has wrong (non-existing?) stat_type4 (56)
Item (Entry: 5828) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 17802) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 17802) has wrong (non-existing?) stat_type4 (55)
Item (Entry: 18881) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 19065) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 19158) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20142) has wrong (non-existing?) stat_type4 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type5 (52)
Item (Entry: 20142) has wrong (non-existing?) stat_type6 (54)
Item (Entry: 20142) has wrong (non-existing?) stat_type7 (56)
Item (Entry: 20142) has wrong (non-existing?) stat_type8 (55)
Item (Entry: 20522) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type4 (54)
Item (Entry: 21614) has wrong (non-existing?) stat_type3 (55)
Item (Entry: 22230) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type6 (51)
Item (Entry: 23362) has wrong (non-existing?) stat_type7 (54)
Item (Entry: 23363) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 23363) has wrong (non-existing?) stat_type6 (56)
Item (Entry: 32113) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32114) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32115) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32116) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32117) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32118) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32119) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32121) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32122) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32123) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32128) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32129) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32130) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32131) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32132) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 34187) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 34967) has deprecated stat_type4 (41)
Item (Entry: 34967) has deprecated stat_type5 (42)
Item (Entry: 36942) does not have a correct SoundOverrideSubclass (-1), must be 8 .
Item (Entry: 36942) does not have a correct material (1), must be -1 .
Item (Entry: 36942) does not have a correct display id (65153), must be 46609 .
Item (Entry: 40762) has wrong (non-existing?) stat_type5 (51)
Item (Entry: 45860) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 48945) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 49312) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 49314) has wrong (non-existing?) stat_type5 (51)
Creature template (Entry: 50100) does not exist but has a record in `creature_equip_template`
Table `creature` has creature (GUID: 213876) with non existing creature entry 50100, skipped.
Table `creature_queststarter`: Quest 12170 listed for entry 27120 does not exist.
Table `creature_queststarter`: Quest 12443 listed for entry 27495 does not exist.
Table `creature_queststarter`: Quest 12314 listed for entry 27520 does not exist.
Table `creature_queststarter`: Quest 12315 listed for entry 27532 does not exist.
Table `creature_queststarter`: Quest 12317 listed for entry 27563 does not exist.
Table `creature_queststarter`: Quest 12323 listed for entry 27602 does not exist.
Table `creature_queststarter`: Quest 12432 listed for entry 27708 does not exist.
Table `creature_queststarter`: Quest 12444 listed for entry 27783 does not exist.
Table `creature_questender`: Quest 12170 listed for entry 27120 does not exist.
Table `creature_questender`: Quest 12443 listed for entry 27495 does not exist.
Table `creature_questender`: Quest 12314 listed for entry 27520 does not exist.
Table `creature_questender`: Quest 12315 listed for entry 27532 does not exist.
Table `creature_questender`: Quest 12317 listed for entry 27563 does not exist.
Table `creature_questender`: Quest 12323 listed for entry 27602 does not exist.
Table `creature_questender`: Quest 12432 listed for entry 27708 does not exist.
Table `creature_questender`: Quest 12444 listed for entry 27783 does not exist.
Table 'item_loot_template' Entry 50100 isn't item entry and not referenced from loot, and thus useless.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12434), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12443), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12432), skipped.
Quest 12323 (alliance_id) referenced in `player_factionchange_quests` does not exist, pair skipped!
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (31, 11882, 1)
[ERROR]: [1062] Duplicate entry '31-11882' for key 'PRIMARY'

02c91f4b4a7bd1f5e0f4174ac6e602dc.jpg

Share this post


Link to post
Share on other sites
5 hours ago, Legendwow said:

Sometimes when you learn skills, there is a pause in 1 second or even 5.

That may be your DB that needs more memory allocated. Assuming that your DB is running on the same node.
Try learning all spells for one craft. Log out, clear cache, log back in and open your craft. For example if you open up Blacksmith there should almost no hesitation, if there is, then you need to beef up your DB.

There should be no hesitation when reading the DB. Also, there seems to be some missing entries from your DB as well.

Share this post


Link to post
Share on other sites

I deleted the old world database, installed the updated database of TBD_Full_World ...
Put high priority and 4 cores in the worldserver.conf, I checked
Server speed is this command: curl -s https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py | python

Here's what I got:

Image | 

The suspensions remained ... I do not understand what the problem is, help me)

bs9DLW6Ww0E.jpg

Share this post


Link to post
Share on other sites

And even if it hangs, it hangs around the entire server and all the players. For 5-10 seconds, you can not use anything (abilities, sit on the mount, change weapons or armor, all run on the spot and the chat also hangs in this moment)

pbPRPlST9Xc.jpg

Share this post


Link to post
Share on other sites

Your network seems fine. Especially with an upload of over 20mbits

21 hours ago, Legendwow said:

The whole server complains that there are jams. Assembling off Trinity. As I understood the last revision. I compiled everything myself! I also tuned everything myself. In TrinityAdmin sometimes shows an update of Diff under 2k is this the norm?

What are the errors that the server complains about?

Unfortunately, I don't use TrinityAdmin.

Share this post


Link to post
Share on other sites
9 minutes ago, CDawg said:

Your network seems fine. Especially with an upload of over 20mbits

What are the errors that the server complains about?

Unfortunately, I don't use TrinityAdmin.

I did not understand the essence of the question.

Players complain about server hangs - this means that every 1-2 minutes the server hangs. Players stand still or run on the spot, you can not use any spells, you can not mount, put on or remove a thing, the chat is not updated, the chat message is not sent,
None of the players can not beat the mobs, since the mobs are standing still or running on the spot, and the autoattack is not used, in general the servo hangs dully for 5-10 seconds, it happens for 20 seconds. And I do not understand what's the matter, there is no wild online on the server, a maximum of 9 people play. On the server is unlimited traffic 100mb / sec, 4 gigabytes of RAM, 4 cores. My English is very bad, so I use Google translater.

Used resources when online 9 people:

RAM - 500 / 4000mb
Traffic - 0.258 Gib
Processor% 6%
Input / output operations - 2 IOPS
Memory Usage - 50%
Average system load 0.31
Open Processes - 101
Open files - 1201

I hope you penny me, I'm new, this is my first server.

The server is located on the VDS - firstvds.ru
Please, help.

Share this post


Link to post
Share on other sites

run nload while all 9 players are playing and tell me if Incoming or Outgoing is spiking.

 

This is a test on my server with 8 people playing who volunteered

Your outgoing should be less
Avg: 27.46 kBit/s

Your Incoming should be less
Avg: 12.59 kBit/s

 

Does this happen when only you play by yourself?

If you are getting spikes only with other players, then there is other activity going on. Possible that one of the players is DDOS'ing your network?

  • Upvote 1

Share this post


Link to post
Share on other sites

Hmm, I do not know exactly, but maybe I solved the problem, I created somewhere 10 users for Mysql and did not use them, I deleted them and there were almost no freezes.

 

Share this post


Link to post
Share on other sites

It still sounded like an issue with your DB in the beginning... Creating users on the DB won't solve it, unless it needed a restart.

  • Upvote 1

Share this post


Link to post
Share on other sites

 

And how can you strengthen the database?

8 hours ago, CDawg said:

It still sounded like an issue with your DB in the beginning... Creating users on the DB won't solve it, unless it needed a restart.

 

Share this post


Link to post
Share on other sites

If you are using mysql, dedicate more memory to increase your speed. Use more RAM to increase data storage going back and forth from memory and not use your physical hard drive to write, then upload.

Make a backup of my.cnf file and do minor increases to:
key_buffer_size
sort_buffer
read_buffer
table_cache
innodb_buffer_pool_size

Then restart MySQL. Be sure to keep an eye on your memory usage. You don't want MySQL to much RAM.

Also, see about increasing RAM in your computer. If I'm reading that correctly, you only have 3Gbs of RAM which is extremely low if you have more than 10 players in the future.

  • Upvote 1

Share this post


Link to post
Share on other sites

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Valufa
      Hello, would anyone know if there is an XML OR JSON file with all the class spells from section 3.3.5a?
      If not, would you know how to inform the procedure on how to extract this information from the game client, or some way faster than Web Scraping?
       
    • By Dipdill
      So I got a new Trinity Core server up and running.  For the life of me I can not get my client to connect.  I have edited the Data\enUS\realmlist.wtf to point to my server.  I have confirmed that the firewalls are open to both 8085 and 3724.  When I open the wow.exe client I use my credentials and it immediately goes to Downloading Update screen and sits at 0%.  I have also added set patchlist to my server thinking that might help and still no go.  I downloaded the client from warmane as mentioned in this thread:  
      Did I miss a step on patching the wow.exe file?  I know on the new master branch there is a patching process... but I didn't see one for the 3.3.5 branch.  
      Thanks
    • By kepo
      I made 2 realms, one for 2.4.3, one for 3.3.5 but for some reason when I try to connect to the 3.3.5 realm I'm getting this error in the cosole: 
      WorldSocket::HandleAuthSession: Client *my home pc's ip is here* requested connecting with realm id 22 but this realm has id 2 set in config. I also get this in-game: 
      The game server you have chosen is currently down. Use the Change Realm button to choose another Realm. The Auth.exe that I use is by OregonCore 2.4.3 for both, but Oregon is 50-60% TrinityCore. When I use the auth.exe by TrinityCore the same problem occurs in the 2.4.3 realm but the 3.3.5 starts working. I don't have any other errors like DB & etc. That's the only problem. 
      I checked the DB auth > realmist and everything looks fine. Here's a picture: http://prntscr.com/mhpbmr
      I have also opened all the needed ports.
      Also - worldconfig for 3.3.5:
      LoginDatabaseInfo     = "127.0.0.1;3306;mysql user;mysql pass;auth" WorldDatabaseInfo     = "127.0.0.1;3306;mysql user;mysql pass;world2" CharacterDatabaseInfo = "127.0.0.1;3306;mysql user;mysql pass;characters2" RealmID = 2 WorldServerPort = 8086 and for 2.4.3
      LoginDatabaseInfo     = "127.0.0.1;3306;mysql user;mysql pass;auth" WorldDatabaseInfo     = "127.0.0.1;3306;mysql user;mysql pass;world" CharacterDatabaseInfo = "127.0.0.1;3306;mysql user;mysql pass;characters" RealmID = 1 WorldServerPort = 8085 Also I checked the AuthSocket.cpp and realmlist.cpp, it looks like there is a code or whatever is called for 3.3.5:
      AuthSocket.cpp
          case 8606:                                          // 2.4.3     case 10505:                                         // 3.2.2a     case 11159:                                         // 3.3.0a     case 11403:                                         // 3.3.2     case 11723:                                         // 3.3.3a     case 12340:                                         // 3.3.5a realmlist.cpp
      static RealmBuildInfo ExpectedRealmdClientBuilds[] = {     {12340, 3, 3, 5, 'a'},                                  // highest supported build, also auto accept all above for simplify future supported builds testing     {11723, 3, 3, 3, 'a'},     {11403, 3, 3, 2, ' '},     {11159, 3, 3, 0, 'a'},     {10505, 3, 2, 2, 'a'},     {8606,  2, 4, 3, ' '},     {6005,  1,12, 2, ' '},     {5875,  1,12, 1, ' '},     {0,     0, 0, 0, ' '}                                   // terminator }; My account's gmlevel in account_access is set to '3' and 'RealmID: is 2', since the max rank level in 2.4.3 (RealmID: 1) is '5'.
      Oh, almost forgot... I modified accounts table, also fusioncms recognize the realm: http://prntscr.com/mhpf3f // trinity is fresh-compiled soo... it's latest version, oregon is 2017 rev since we did tons of custom changes (it's fun server) but hey.. oregon is ded - latest rev is 1 year ago. ;c
    • By Hydra_Btforce
      Just finished download & compile fresh trinitycore 4.3.4  From : https://gitlab.com/trinitycore/TrinityCore_434/tree/4.3.4
       
      Creating World database from : https://github.com/TrinityCoreLegacy/TrinityCore/releases
      Downloading the lasted one & create new database named World
      Navigate to my repo applying sql/updates/world/4.3.4
      Trying to apply all updates but an error occurred while applying updates
      And if i don't apply all updates the world is totally bugged and items/creature are missing.
       
      Please help
    • By Hesione
      I'm having a problem with a number of factions not getting the flag "at war" in the reputation tab, and this is unable to be selected by the player. Currently, this is with The Oracles, as my character has their reputation with Frenzyheart. The problem occurs when one of two opposing factions is chosen as the positive reputation one. That said, Bloodsail Buccaneers seems to work fine.
      I did a search on how to fix this, and found this on the TrinityCore issues tracker: https://github.com/TrinityCore/TrinityCore/issues/9469 (specifically https://github.com/TrinityCore/TrinityCore/issues/9469#issuecomment-78925130)
      Do I just go into the ReputationManager.cpp file and edit it directly? I don't understand how the dbc/cpp files are used. Are they called by the client each time the client is started up?
      I found the code for ReputationManager.cpp here: https://github.com/TrinityCore/TrinityCore/blob/master/src/server/game/Reputation/ReputationMgr.cpp
      I don't understand how the fix goes into this code. I can see a Git pull (push?) whereas I thought I could just edit ReputationManager.cpp directly. If so, which lines do I replace (if any)? Otherwise, where should I insert the fix?
       
×
×
  • Create New...