Jump to content

Xenithar

getMaNGOS Staff
  • Posts

    1395
  • Joined

  • Last visited

  • Days Won

    3
  • Donations

    0.00 GBP 

Everything posted by Xenithar

  1. Alright, without changing anything, EXACTLY fifty minutes after starting the server and not a soul playing, the SQL errors started being logged. [code] 2015-10-18 23:27:34 SERVER STARTUP TIME: 0 minutes 6 seconds 2015-10-18 23:27:34 2015-10-18 23:27:34 2015-10-18 23:28:02 GameEvent 61 "Stormwind City - Stockades Jail Break" started. 2015-10-18 23:37:08 ERROR:Creature (GUIDLow: 15251) X: -2242.801025 Y: -2199.574707 (original) in grid[27,27]cell[12,13] instead grid[27,27]cell[12,14] 2015-10-18 23:38:01 GameEvent 61 "Stormwind City - Stockades Jail Break" removed. 2015-10-18 23:58:01 GameEvent 61 "Stormwind City - Stockades Jail Break" started. 2015-10-19 00:00:01 GameEvent 16 "Gurubashi Arena Booty Run" started. 2015-10-19 00:00:01 GameEvent 29 "Edge of Madness, Gri'lek" removed. 2015-10-19 00:07:34 2015-10-19 00:07:34 >> Flushed all ranking points 2015-10-19 00:07:34 2015-10-19 00:07:34 >> Loaded 0 Horde and 0 Ally honor standing definitions 2015-10-19 00:08:01 GameEvent 61 "Stormwind City - Stockades Jail Break" removed. 2015-10-19 00:17:20 ERROR:SQL: can not execute 'UPDATE account SET active_realm_id = ? WHERE id = ?' 2015-10-19 00:17:20 ERROR:SQL ERROR: Lost connection to MySQL server during query 2015-10-19 00:24:46 ERROR:SQL: can not execute 'UPDATE account SET last_ip = ? WHERE username = ?' 2015-10-19 00:24:46 ERROR:SQL ERROR: Lost connection to MySQL server during query 2015-10-19 00:24:46 ERROR:SQL: can not execute 'UPDATE realmlist SET population = ? WHERE id = ?' 2015-10-19 00:24:46 ERROR:SQL ERROR: Lost connection to MySQL server during query 2015-10-19 00:25:00 ERROR:SQL: can not execute 'UPDATE account SET active_realm_id = ? WHERE id = ?' 2015-10-19 00:25:00 ERROR:SQL ERROR: Lost connection to MySQL server during query 2015-10-19 00:25:50 ERROR:SQL: can not execute 'UPDATE account SET active_realm_id = ? WHERE id = ?' 2015-10-19 00:25:50 ERROR:SQL ERROR: Lost connection to MySQL server during query [/code] I logged in and out a few times after midnight and that is what happened. Something is happening that within roughly one hour, causes the SQL connections to go bonkers. I will continue working on this with this knowledge. I am simply posting it here as a record for myself as well as for others.
  2. The server loses connection to the DB constantly Alright, I have a fairly hefty server and am running Zero and a MySQL 5.5 DB server on it. These are actually separate entities as XenServer is installed and these are guest VMs. This is so when I begin working on One and Two, I have all of my databases in one spot as would be done in the professional world. This means that the MaNGOS server process is communicating via IP address to the other VM to do SQL queries. I am seeing a TON of "ERROR:SQL ERROR: Lost connection to MySQL server during query" on the server's console output. It gets so bad at times (usually after ten or so hours) that characters no longer save and strange things happen. What I have done thus far is verified that there is zero packet-loss between the VMs, increased the MySQL server's maximum connections from the default of 100 to 1024, tried using MySQL 5.5, MariaDB 5.5, and MariaDB 10.1, and enabled IPv4 syn cookies on both servers. The only thing which helped was increasing the max connections from 100 to 1024. This allowed the server to run for one hour and ten minutes before the errors returned. I am currently rebooting the server and waiting to see if it takes another hour to screw up again. If it does, I will double the connections to 2048. If that doubles my time, we can assume that the server is creating way too many connections over time and not closing them for some reason. A side-effect of this troubleshooting was fixing a problem I have had since the AHBot was merged into the core. Since it was merged it would NOT sell me any items. It would buy my items, but had nothing for me to buy. As soon as I increased the connections the AHBot began working. This leads me to believe that during the merge something did not like being part of the core and may be creating connections but not closing them. After the test I am running now I will be disabling the AHBot and seeing if the SQL errors disappear. If they do, I will begin looking at the bot code.
  3. That may be true, but just today while I was troubleshooting the SQL connection issue I increased MySQL's connection count from the default 100 to 1024 and the bot began working. It also fixed the SQL errors completely until the server had been running for an hour. I am still researching it, but for the past year AHBot has been dead. Increasing the connection limit appeared to have fixed it. I will continue this along with the SQL connection research.
  4. Yes, this is still bugged. It does the animation one round, then the next round a bunch of damage is applied.
  5. Quest 9816 incomplete... During quest 9816 you are to release a cage full of Murlocs in a Lost One camp. On official the Murlocs spawned and started chasing the now terrified Lost Ones. Currently only one baby murloc spawns and it does nothing.
  6. Quest 9447 incorrect speech... When you heal grunts during this quest, the 'v' is missing from the text "You've found a cure...". Currently it says "You'e found a cure...".
  7. Quest 9472 incomplete ending... In "Arelion's Mistress", you change the mistress into a rat. Her cat is nearby and is supposed to emote something about being hungry and then chase her off. Currently, they just stand still until fading out. The quest IS completed however.
  8. Quest 10086 broken... Quest 10086 cannot be completed. You are supposed to pick up wood and metal objects but while those objects are there and sparkling, you cannot use them unless in GM mode. A normal user would be unable to complete the quest. This MAY affect One also, but I noticed it in Two.
  9. Quet 12779 broken... During quest 12779 youa re supposed to ride a frost wyrm and kill a bunch of elite enemies. The problem is that the wyrm starts with no mana and the spell to eat a crusader is broken. It assumes everything is an invalid target. Due to this you cannot do anything, and the wyrm only has a single HP. This is another quest which will block progression through the prologue.
  10. Quest 12698 is broken... The item you throw at the miners does nothing. I have thrown it at them and waited for it to despawn, thrown it at them and killed them while within range of it, and even thrown it onto corpses. Nothing works. The quest cannot be completed. This is a core quest for DKs and as such only a GM may proceed. A normal player would be stuck.
  11. Alright, Max recompiled 0.20 and I tried the quest again. As soon as you attempt to use the "Eye of Acherus control mechanism", you get "Interrupted" and the server crashes. This prevents DKs of all races and factions from doing more than five minutes of gameplay and traps them in the floating fortress with The Lich King.
  12. You know I wonder if this is just on the Covenant servers. I seem to recall this working on my private testing server before.
  13. Quest 756 incorrect speech... At the end of quest 756 when you turn the stuff in to Mull Thunderhorn, he incorrectly says the following. "Good day to you both. I would speak to Lord Escovar." "Of course. He awaits you in the library." If my memory serves me, he is supposed to say something like "Wait while I prepare the cleasing stuff" and then emote something.
  14. I do not believe it was removed. I believe it was simply no longer dropped. I never recall a player losing an item they earned through combat because Blizzard removed it. Nerfed it, yes, but not removed.
  15. Incorrect NPC speech... When turning in quest "Rite of Vision" (771 I believe) the Tauren speaks and emote the wrong text. He currently says "Yes, sir!", then emotes something about waiting for the guards to be gone. I believe that is the text for an Alliance quest, not the shaman/Horde quest. This happened on Covenant.
  16. Using The Eye of Archeaus brings down the server... Topic says it all. Played maybe five minutes on Covenant with a new DK. Got to the part where I had to use the eye. Used it and the server went down. This MIGHT be a script issue, not sure. *EDIT* Max, sorry I brought the server down again. I guess either I am one unlucky guy, or Two has a handful of bugs left!
  17. Antz I am not sure. My RAID array had that bad disk (see my forum thread) and I won't even know if WD will replace the BRAND NEW disk until Tuesday. Once I get my disk I can install XenServer and get my systems back online.
  18. Greatmother Hawkwind text incorrect... During the quest "A Humble Task", Greathmother Hawkwind should emote "Gestures towards the water pitchers..." and instead she says it. I am assuming Covenant (Cosmic Ray) is running 0.20. Sorry I cannot provide the quest ID, but I am messing around on Covenant while my server is down when I noticed this.
  19. I wanted one of those so bad when I was a kid. I loved the way they rigged that old lady's chair. Looked like a fun ride! Anyway, I am home again, server is booting (yay RAID10!) and I will be provisioning my VM's now. Do you need help with this or are we good now?
  20. Sorry I was busy, and will be out of town until Friday. I know for a fact you could unlearn the LW skills in vanilla. I do not remember BS unlearning, but I wa snot a warrior and did not focus on BS. There should be NO GOSSIP to learn anything like this. There should be gossip to unlearn the three LW skills. I will check my book when I get back. I have my strategy guide from 2004 or 2005. *EDIT* I do know that you CAN drop BS all together and re-level it, and then learn another spec. So when dropping LW or BS, you should also drop your specialization. *UPDATE* I did a quick search. Just after BC was released they added unlearning. I must be wrong on the LW. The link below states it. I do remember unlearning an entire profession in vanilla to change specializations. I do not remember how long ago that was... [url=http://www.wowwiki.com/Patch_2.0.3]Patch 2.0.3[/url]
  21. Nuke, I use Valgrind. It is one of the best in the Linux/Unix/BSD world. I do not know of something comparable on Windows that is free, open-source, or similar. As for the versioning, this is why I have continually warned against staying bleeding-edge with ACE and the like. Unless you run Gentoo or something similar, you are NOT going to have the latest ACE stuff. Binary distributions (Debian, Ubuntu, Fedora, etc) update with new releases and possibly once between releases with a backport. This means that staying bleeding-edge can cause some issues in every world except Windows. Sure, you can just grab a binary downlaod in Windows and further bloat the install, but this is not how Linux works. I believe some of our issues would go away if we fix them and then choose a version of ACE to stick with for a period of time before doing a planned upgrade, which should come after testing. Kind of like an extended service release (ESR) like so much software does now.
  22. Your link contains good info, but we're using ACE, not pure C++, so we are creating and terminating threads using ACE if I recall correctly. The information in your link would have to be applied to the ACE library or we'd have to dump ACE for threading. I am not sure how we would use CreateThread() alongside the ACE function to handle threads. Maybe it can be done and I am wrong, but I normally only do pure C++ for things like threading, so I know very little about ACE and threads. *EDIT* Also, threading DOES appear broken to an extent. I had been working on realmd not showing realms before my server died and I figured out that the ACE functions we call to create the threads were NOT working. They would create a thread and instantly exit it, resulting in no servers being shown. This is under Debian, not Windows.
  23. Why would this not affect the Linux build though? Seems odd. I am finishing my install now. Hopefully I will be up by Friday. No time anymore. Company is growing and I am being monopolized.
  24. Will this affect pets and such? Currently our pets are hosed in major ways (hunter, lock, all of them!) and warlock pets do not regenerate mana and hunter pets won't regenerate focus. This results in a "your pet is in combat" message if you attempt to use a pet skill which uses focus or mana.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use