When are you going to fix the SQL.....
TappedOut forum
Posted on Oct. 26, 2015, 8:37 a.m. by xGhostx
All weekend the DeckBuilder has been essentially non-functional.... Changes revert, sometimes to 3 or 4 revisions when trying to make updates..... The SQL Tables seem to be hosed.....
xGhostx what deck are you having a problem with? is it on the deck's page that you are not seeing the update or the playtester?
October 26, 2015 11:22 a.m.
derankerdave says... #4
I am having the same issue, and it basically boils down to the following:
-Enter cards in the Edit tab
-Save, go back to deck page
-Cards appear!
-Refresh page
-Coin flip as to whether the newly entered cards appear and stick around
-Check Edit Tab again
-ANOTHER Coin flip as to whether the cards appear
-3 hours later, flip another coin for a chance for those edits you made hours ago to appear suddenly
This has happened with all of my decks, it is not one specific case. There's really no other way to be specific, as sometimes just waiting 30 minutes then attempting to save a new change will actually allow the change through.
This has been happening since at least last Thursday for me, but I didn't try to make any decks that week until Thursday itself. So, something in the last week is causing the issue, and it mainly revolves around decks updating themselves either on a delay or not at all.
October 26, 2015 12:09 p.m.
@ yeaGO As derankerdave said above....
My deck:
Dromoka Abzan (8-Rhino) Playtest
Standard
SCORE: 4 | 0 COMMENTS | 401 VIEWS
Today seems to be better so far, but your SQL is certainly having issues. I assume the site is based on a Linux box, I would take a peek to see what the load is at, specifically for mysql processes. a killall to mysql followed by a force restart would not be bad idea either to just flush the cache.
October 26, 2015 12:20 p.m.
@ yeaGO As derankerdave said above....
My deck:
Dromoka Abzan (8-Rhino) Playtest
Standard
SCORE: 4 | 0 COMMENTS | 401 VIEWS
Today seems to be better so far, but your SQL is certainly having issues. I assume the site is based on a Linux box, I would take a peek to see what the load is at, specifically for mysql processes. a killall to mysql followed by a force restart would not be bad idea either to just flush the cache.
NOTE
Yeah certainly SQL table that handles the decks as well as the comments, this comment took 3 attempts to post.
October 26, 2015 12:22 p.m.
And then, it does seem to cache the changes/posts and posts them as soon as the server is responding to the SQL talks. I would put my money on the SQL cache is just running super laggy as it is more then likely bogged down by a massive tmp log or the likes. a killall -9 followed by a fresh restart of SQL will do the trick.
October 26, 2015 12:32 p.m.
I have also noticed since last week that the Feature Queue has been wonky, sometimes will not cycle decks, sometimes will not be there at all (as of right now) this would also point to the same issue.
Wasted 3 feature coins trying to get my Deck to be featured :P
October 26, 2015 12:36 p.m.
this should be fixed. let me know if the problem persists.
October 26, 2015 4:41 p.m.
derankerdave says... #10
Just tried to modify my deck again - worked for the first edit, then promptly failed in the same way again. For example, I keep going in to Edit, remove a Font of Mythos from a list, then upon saving neither the actual decklist nor the Edit page have the Font removed. Again, I'll keep watching to see if it's only delayed, but as of right now it's busted.
October 26, 2015 4:59 p.m.
weird. i just added that card to your deck and then dropped down the qty and then removed it and it all seemed to happen normally. i was messing around with it this weekend and i wasn't able to reproduce anyone's problem. please continue to report here.
October 26, 2015 5:09 p.m.
derankerdave says... #12
yeaGO Are you using Chrome, by chance?
And xGhostx, are you using Firefox?
I just switched browsers (was using firefox before), and chrome is doing it all just fine for some reason.
I just made some changes to the list using chrome, and no matter how much I refresh the changes persist and act normally. I then tried refreshing on Firefox, and the changes never showed up. I think it is an error with the browser itself.
October 26, 2015 5:26 p.m.
threepwood27 says... #13
I have been having this issue for several days using Chrome on two machines desktops, but I do not experience it yet when using MS Edge on a Surface tablet.
October 26, 2015 6:02 p.m.
Firefox 64 bit on Windows 10 for me. Problem still persists as of 2 hours ago. I will check again now.
October 26, 2015 7:51 p.m.
Problem persists. Not a local cache issue. Cleared as well as launched firefox in a new private session. Still delay on making changes and/or forum posts.
Do you happen to know if the server is a Linux/UNIX box? If so do you have SSH access? If so, I can help try to find a problem.... WebHosting is kind of my thing lol
If you do, check the Apache log and the access logs ( I can PM you my IP for a more detailed search in the access logs) there may be errors showing this.
Also, from a shell, if you have Root or SuperUser privileges run the following.
killall -9 mysqld
(Wait for the process to die with all child processes once that is done run)
/etc/init.d/mysqld start
(wait for the message saying MySQL started successfully. This will purge the SQL cache and temp log files.)
Again, this is ONLY if the site is being hosted from an Apache based web server.
October 26, 2015 8 p.m.
A trace from what looks to be a Level3 backbone server also comes up clean so I dont think its an isolated routing issue....
http://www.monitis.com/traceroute/index.jsp?url=tappedout.net&testId;=1001578
October 26, 2015 8:11 p.m.
threepwood27 says... #18
Yes, refreshing a deck after editing still reverts all my changes in Chrome as of two minutes prior to this post.
October 26, 2015 10:21 p.m.
Yeah still seems to be doing it..... Spent another Feature coin and never posted the Deck to feature list.....
October 27, 2015 8:54 a.m.
Ghost is right- this is a server / database issue, and I strongly suspect it is due to resource spiking. Over the weekend I was having huge latency working with the deck builder, timeouts trying to playtest, and even got a site offline notice on trying to reload at one point.
October 27, 2015 2:20 p.m.
Femme_Fatale says... #22
A lot of users over at untap.in are reporting this very thing is still occurring.
October 27, 2015 8:03 p.m.
does anyone observe this off peak hours? now for example?
October 28, 2015 12:51 a.m.
what ratio of edits would you all say reveal this bug?
pretty frustrating. tried 20 times and nothing.
October 28, 2015 3:01 a.m.
when it seems to be happening can someone pull up a debugger of some kind and tell me if the response is actually coming from my server or if it seems like its coming from cache. screenshots welcome.
October 28, 2015 3:14 a.m.
It's pretty consistent- I've been trying to update the same list for the last four days. I haven't been able to nail down any rhyme or reason to it- last night I logged in and a set of changes I'd made previously showed up that hadn't appeared at the time, but then I tried to update it with some corrections and they wouldn't take. Checked today and they're still not showing.
I'm not sure what kind of debugger you'd be looking for client-side that will show anything in terms of database problems, but I can tinker with it if you have ideas.
October 28, 2015 1 p.m.
yeaGO its certainly a DB issue no doubt about it..... Do you have root access to the server? I just want this fixed.... I love TappedOut and the site is essentially non-functional to me right now.... Just want to help fix it. SadFace
October 28, 2015 5:37 p.m.
Made some changes, hows it looking.
Google Chrome -> Developer Toolbar -> Network tab -> Filter line, filter for Doc -> click row for /the url you are on/ -> Look right pane Headers tab, paste all Response-Headers
October 28, 2015 7:55 p.m.
threepwood27 says... #32
Problem still there for me. In one of my decks I changed 1x Bear Umbra to 4x, after two refreshes it shows that change at least. Then I lower it down to 2x and refresh. No matter how many times I refresh, it will not show 2x. It alternates between 4x and 1x.
October 28, 2015 10:22 p.m.
threepwood27 says... #33
Turned off my Chrome extension, uBlock Origin and the issue went away. And now holy cow this website is glitchy every time I load a page.
October 28, 2015 10:30 p.m.
Correct, Still happening to me yeaGO when making virtually any change to the deck. (Edit the board, Sideboard, Title, Discription manually from the edit screen, or by simply changing numbers using the +/- options)
October 29, 2015 6:43 a.m.
Can you try nuking your site cookies and cache and see if the problem doesn't go away entirely? Sorry about that, but I am interested to know if it fixes the problem.
So far I can pull up anyone's deck and edit it immediately and the changes are reflected fine.
October 29, 2015 6:04 p.m.
Femme_Fatale says... #37
Okay, for the +/- buttons, this issue has actually been around for a really really long time, but because T/O had fast loading times before now, this wasn't an issue because it can process the information. Basically what is happening is that it takes the system a long time for it to process those changes, and if you do anything else like refresh or what not, it can mess with the data transfer and the error "There is a problem with that action." will pop up on occasion.
The occurrence of this in the past was very much proportional to A) the deck size, and B) what categories you were using. Basically things that could potentially cause the site to load really slowly. I have an error script of that exact occurrence ... and it is massive, so yeaGO, I hope you don't mind as I put it in a public pastebin. If you want I can delete it easily.
As for everything else, I cannot say. I don't really experience them or haven't just yet.
October 29, 2015 7:01 p.m.
derankerdave says... #38
I began having these issues around the time that I switched from adblock plus to ublock origin. I think Ublock was the issue - I just fully disabled it in my browser, and the entire site is back to normal - decks function as they should, and I have no loading errors anywhere.
Just food for thought.
October 29, 2015 7:04 p.m.
Femme_Fatale says... #39
I can say however that it was worse when I turned adblock plus off because the ads made everything go slower which is the cause of the occurrence.
October 29, 2015 7:18 p.m.
derankerdave says... #40
Adblock plus does not seem to be hindering my editing at all, but I may just be crazy.
October 29, 2015 7:21 p.m.
@ yeaGO have cleared cookies and cache multiple times as well as loading in private sessions in both Chrome and Firefox. Have also disabled most/all add-ons. Same results here..... :(
October 30, 2015 7:06 a.m.
Femme_Fatale says... #42
Okay, more information. I actually now have had the issue affected to me, however, my deck is over 450 cards (it's a cube put into a deck list for easier management because the cube doesn't have access to the graphs nor the +/- buttons).
Whenever I hit the +/- button, it registers as being removed (the animation happens) but when I refresh, it comes back, and the card count and graphs have not changed. When I go into the edit instead of refreshing, and go to the card that I just attempted to remove, it is listed as this:
Which I find interesting.
October 30, 2015 12:26 p.m.
Seems to also be issues with the notifications system now. It will refresh Notifications that have already been checked, not allow you to select the notification etc.
October 30, 2015 12:44 p.m.
interesting. can you open up a google chrome developer tab and look at the console as you are toggling these quantities? There's an XHR tab. Could you open that and tell me what the response is (aka 200 status code from tappedout?).
I really wish I could reproduce this problem.
October 30, 2015 3:17 p.m. Edited.
derankerdave says... #48
I've stopped having the issue entirely, and I'll once again state my solution.
-Disable any adblock programs
-See if issues go away
-Re-enable as you go
Completely removing Ublock Origin took away my problem (NOT just disabling, full remova). AdBlock doesn't cause the issue.
October 31, 2015 6:11 p.m.
mobiusunderpants says... #49
this is happening on the deck paste tool (the one with the cmc and color charts) as well; after making some initial list, trying to save changes just ends up with a blank page with a "update paste" button, which then leads to a 404
October 31, 2015 9:43 p.m.
Seeing a few Syntax errors....
beacon?viewId=curse_auction_api&rand=813&informer=7713456&type=fpads&loc=tappedout.net&v=1.2:1 Uncaught SyntaxError: Unexpected token <
As well as some 502's from http://soundwave.bnmla.com
GET http://soundwave.bnmla.com/usersync?sspid=15&r=http://ums.adtechus.com/mapuser?providerid=1029;userid=$UID 502 (Bad Gateway)(index):1 GET http://soundwave.bnmla.com/usersync?sspid=15&r=http://ums.adtechus.com/mapuser?providerid=1029;userid=$UID 502 (Bad Gateway)
xGhostx says... #2
Seems to be working......better...
October 26, 2015 9:03 a.m.