Search found 123 matches

by kestasjk
Thu Jul 15, 2021 9:24 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Yep that should be what it's doing. Previously in that circumstance the game would get processed immediately within the board page itself, but now a flag is written so that the gamemaster knows to process the game next round (which should occur every 15 seconds or so)
by kestasjk
Thu Jul 15, 2021 9:06 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Hmmm.. well you do need to view the game in order for it to get marked that processing is ready. The idea is that previously games would get processed when they needed processing and were viewed by a user, so instead the game is flagged as being ready for processing when viewed by a user and should ...
by kestasjk
Mon Jul 12, 2021 10:29 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

How long would you say you have to wait for? It shouldn't really take very long, the rate should be once every 5 seconds or so
by kestasjk
Wed Jul 07, 2021 7:43 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

The bots weren't giving orders briefly there, thanks for letting me know about that, and there was some brief gamemaster downtime. Just getting more familiar with how memcached works in practice
by kestasjk
Wed Jul 07, 2021 6:09 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Okay I've changed the functionality so that when a player sees that all members are ready it leaves a hint/flag for the gamemaster to process it next round, rather than it getting processed within the board directly. Let's see how this goes
by kestasjk
Wed Jul 07, 2021 11:43 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Ah thanks I think I missed that. Okay, I think this should be straightforward. Good news that it seems smoother. Are there any pages in particular or just in general? Votes previously caused an immediate process in the board code. The api/board code is best to tally votes/orders but not a good place...
by kestasjk
Wed Jul 07, 2021 2:45 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Yep that's fixed, I just turned up the error reporting to show warnings and previously that was under the threshold to report. Looking promising.. no deadlocks, stable speeds and no issues for a few hours at least .. https://webdiplomacy.net/images/Untitled.png Still more optimizations to go but I t...
by kestasjk
Tue Jul 06, 2021 2:40 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Hi Nescio, Did you put in any votes or did you have any votes going before it started processing in a loop? The issue should be resolved, but if this happened due to you placing a vote it would make sense, but if it happened spontaneously there might be something strange going on with the bot voting...
by kestasjk
Tue Jul 06, 2021 1:57 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

The process for my game just got rebooted multiple times over the span of 5 minutes or so resulting in all players going into civil disorder and getting booted (then turning into a draw which I wasn't part of :cry: ) https://webdiplomacy.net/board.php?gameID=354868 Not sure if this can be reversed ...
by kestasjk
Tue Jul 06, 2021 5:14 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Thanks guys good feedback. I thought the main gamemaster could recognize vote and order complete conditions but it looks like it doesn't. I've made a change so that the board can trigger a process by setting the process time to now, so that it'll then get picked up by the gamemaster within a few mom...
by kestasjk
Mon Jul 05, 2021 11:01 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Hmm.. not expected but that could well be due to changes made to reduce simultaneous game processing. How many minutes was it delayed for? It looks like it has moved on now, so did it eventually move on because of the votes or did it move on due to timing out? The current processor is running on a 3...
by kestasjk
Mon Jul 05, 2021 5:38 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Interesting and promising results from analyzing the error logs to extract all deadlocking queries: A) 98x : sql => UPDATE wD_Members SET timeLoggedIn = 1624155999 WHERE id = 1680167 file => /var/www/webdiplomacy.net/public_html/board.php B) 105x : sql => SELECT g.id, g.variantID, LOWER(HEX(g.passwo...
by kestasjk
Fri Jul 02, 2021 8:02 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Thanks for coming up with some ideas Tjappator, but we're pretty confident this is due to locking issues, and we're fairly confident that is because the query optimizer has changed a lot since the system was written and there may be some queries that weren't designed with locking in mind, and we're ...
by kestasjk
Tue Jun 29, 2021 8:56 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Thanks FxFocus, we’ll get it sorted asap
by kestasjk
Sat Jun 26, 2021 6:43 am
Forum: Off Topic
Topic: I'm back... and I'm sorry
Replies: 7
Views: 1750

Re: I'm back... and I'm sorry

Welcome back squigs! We are not doing just fine without you buddy.. we've just moved server and things are somehow worse, it's a bit of a nightmare. I've taken some leave to try and really get my teeth into reoptimizing the system and do the server move but I need to take more and will be week after...
by kestasjk
Thu Jun 24, 2021 11:31 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Dang it.. Thanks for reporting these issues guys, we're collecting the error logs and will sort out the deadlocking issues
by kestasjk
Sun Jun 20, 2021 1:14 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Apologies I've restarted processing. Clearly need to dedicate some time to this locking issue
by kestasjk
Sun Jun 13, 2021 2:34 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

Yep fair point; the downtime was 3-4 hours and I think I added 12? Should have done 24.
by kestasjk
Sat Jun 12, 2021 10:15 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

I just sorted the last known issue, and had to wipe the map/order cache as maps/orders were being generated with an inconsistent database state causing javascript errors. Might be a bit slow while it regenerates. Keep letting me know when you experience issues; looking at the logs I had rebooted the...
by kestasjk
Sat Jun 12, 2021 7:31 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 106
Views: 27459

Re: webDiplomacy.net new server

A while ago while tuning the database for the new system I did accidentally take the database down for a few minutes, so I think that's all that was. There are logs whenever there is a failure, and I have also enabled logging for slow queries. I made some config changes to make the system use the in...