Search found 90 matches

by kestasjk
Fri Jul 23, 2021 6:22 pm
Forum: Off Topic
Topic: Diplomacy Dreamin'
Replies: 3
Views: 85

Re: Diplomacy Dreamin'

Diplomacy, bacon and casinos eh.. The dreams I remember seem to be mostly my mother forcing me to go back to high school to complete some unit I didn't finish and me doing anything to avoid it / postpone it. Weird business, I'd prefer casino-bacon :(
by kestasjk
Fri Jul 23, 2021 5:35 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 97
Views: 5861

Re: webDiplomacy.net new server

Afraid so :( I don't think they're very worthwhile myself, but what can you do :raging:
by kestasjk
Fri Jul 23, 2021 12:47 am
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 97
Views: 5861

Re: webDiplomacy.net new server

Okay I think I've found what's going wrong; there was a hook in ajax.php that meant when orders were submitted that could act as a trigger, but I was looking in the vote code.

Processing should hopefully continue when all players are ready now, but let me know how it goes.
by kestasjk
Thu Jul 22, 2021 9:58 pm
Forum: Development
Topic: Cookies; accept or deny
Replies: 2
Views: 103

Re: Cookies; accept or deny

Okay .. reading into it more it looks like there are exemptions for "strictly necessary" cookies, which includes storing user preferences, authentication, website functionality etc, so the Accept/Deny cookies banners are really only for cookies relating to tracking. Well that's a relief .. still not...
by kestasjk
Thu Jul 22, 2021 9:21 pm
Forum: Development
Topic: Cookies; accept or deny
Replies: 2
Views: 103

Cookies; accept or deny

We're doing a few things to try and modernize webDip a bit, one of which is getting compliant with the GDPR cookie rules. I think it's absurd; it can only affect cookies on the site you're visiting not tracking cookies in 3rd party requests, and it's something a user should set themselves in their b...
by kestasjk
Fri Jul 16, 2021 4:05 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 97
Views: 5861

Re: webDiplomacy.net new server

Righto, well let's see how it goes. The change shouldn't have any negative effects at least
by kestasjk
Fri Jul 16, 2021 3:34 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 97
Views: 5861

Re: webDiplomacy.net new server

Thanks guys, that is good news. I've made a change so that right after order submission there is now a check to see if the game needs to be processed, but now that I think about it I'm not sure if that's the issue here. The problem is that everyone is Ready and has voted that they're Ready in a game...
by kestasjk
Thu Jul 15, 2021 9:24 pm
Forum: Announcements
Topic: webDiplomacy.net new server
Replies: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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: 97
Views: 5861

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 ...