00:31:13 Fork (bcrawl) on crawl.kelbi.org updated to: 0.23-a0-4778-g1c48639af6 00:56:48 Fork (bcadrencrawl) on crawl.kelbi.org updated to: 0.03-1054-g4bcc0e761f 03:22:26 Experimental (bcrawl) branch on underhound.eu updated to: 0.23-a0-4778-g1c48639af6 05:07:05 Unstable branch on crawl.akrasiac.org updated to: 0.30-a0-55-g90e3122 (34) 05:16:26 <09gammafunk> @advil not sure if you can see it from a terminal you have active, but taildb seems to have crashed at some point 05:16:38 <09gammafunk> I'm running loaddb right now 05:20:57 <09gammafunk> one thing I do see from this loaddb is a failed fetch on cwz milestones file, but not for logfile, seems it must be intermittent, since I can load the milestones url 05:21:19 <06advil> yeah, I can't find anything in the log 05:21:36 <06advil> somewhat confused about what the time zone is 05:21:43 <06advil> in these log lines 05:22:14 <06advil> 1.8G taildb.log also we should reset this 05:23:36 <06advil> I wonder if an exception would show up in this log, maybe it's not configured that way? 05:26:16 <09gammafunk> ime it only shows up on the terminal where taildb was launched 05:26:25 <09gammafunk> definitely would be helpful to write it to the log 05:26:49 <09gammafunk> heh, yeah probably no reason to keep that much history, guess we can really just reset it every tournament 05:31:48 <09gammafunk> oh 05:31:50 <09gammafunk> this again 05:32:00 <09gammafunk> > Traceback (most recent call last): > File "loaddb.py", line 1335, in > cleanup_listeners(db) > File "loaddb.py", line 1244, in cleanup_listeners > e.cleanup(db) > File "/home/services/crawl/dcss_tourney/loaddb.py", line 162, in cleanup > self.fn(c) > File "update_page.py", line 72, in category_pages > rows = scoring_data.category_leaders(category, c) > File 05:32:01 "/home/services/crawl/dcss_tourney/scoring_data.py", line 121, in category_leaders > return q.rows(cursor) > File "/home/services/crawl/dcss_tourney/query_class.py", line 27, in rows > self.execute(cursor) > File "/home/services/crawl/dcss_tourney/query_class.py", line 18, in execute > cursor.execute(self.query, self.values) > File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute > self.errorhandler(self, 05:32:01 exc, value) > File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler > raise errorvalue > _mysql_exceptions.OperationalError: (1038, 'Out of sort memory, consider increasing server sort buffer size') 05:32:09 <09gammafunk> oof should have pastebinned that 05:32:31 <09gammafunk> do I need to increase it again 05:34:34 <09gammafunk> increased that buffer size and trying again 05:35:24 <09gammafunk> running it with taildb this time if anyone wants to watch the log 05:35:35 <09gammafunk> I probably shouldn't use loaddb in general outside of testing 05:36:20 <09gammafunk> fetch succeeded with cwz milestones so I guess it'll still take a bit to get through all those cwz milestone lines 05:44:06 <09gammafunk> @advil taildb is able to get through the cycle now that I've doubled the size of sorb buffer size again (to 1048576). I assume the tournament will end before this becomes a problem again, but if you have any time/interest in investigating further and need to change anything yourself cdo-side, please feel free. The relevant mysqld config is at ~/mysql/defaults.cnf 05:46:56 <06advil> ah that issue again 05:47:25 <06advil> I became pretty convinced that is a version-specific issue where we should aim to upgrade mysql before the next tournament 05:49:44 <06advil> https://stackoverflow.com/questions/29575835/error-1038-out-of-sort-memory-consider-increasing-sort-buffer-size/67266529#67266529 for a summary 05:50:20 <06advil> 8.0.18 through 8.0.28 or so, iirc we are on 8.0.20? 05:50:57 <06advil> one comment there does suggest creating an index that exactly matches the failing sort criterias, so that's another thing we could try if we need a fix to get through sunday 06:09:22 <09gammafunk> sounds good, I bet napkin can do an upgrade for us by next t 06:09:46 <09gammafunk> and maybe we can also switch to the anaconda python3 06:10:47 <09gammafunk> New tournament issue to debug: riverfiend's account has abandoned a god without rejoining and won, but doesn't have Beogh 1 banner (Heretic): https://crawl.develz.org/tournament/0.29/players/isplatspriggans.html 06:11:44 <09gammafunk> !lm * t gid=ISplatSpriggans:cao:20220808182954S god.worship s=noun 06:11:45 <04Cerebot> 2 milestones for * (t gid=ISplatSpriggans:cao:20220808182954S god.worship): Okawaru, Wu Jian 06:11:51 <09gammafunk> !lm * t gid=ISplatSpriggans:cao:20220808182954S won 06:11:52 <04Cerebot> 68. [2022-09-08 22:58:41] ISplatSpriggans the Ninja (L24 SpTm) abandoned Okawaru on turn 58218. (D:7) 06:12:00 <09gammafunk> !lg * t gid=ISplatSpriggans:cao:20220808182954S god.worship s=noun 06:12:01 <04Cerebot> No keyword 'god.worship' 06:12:09 <09gammafunk> !lg * t gid=ISplatSpriggans:cao:20220808182954S won 06:12:10 <04Cerebot> 1. ISplatSpriggans the Ninja (L24 SpTm of Wu Jian), escaped with the Orb and 3 runes on 2022-09-08 22:59:26, with 1770754 points after 58469 turns and 2:33:21. 06:12:14 <09gammafunk> got there eventually 06:15:23 <06advil> !lg * t gid=ISplatSpriggans:cao:20220808182954S won x=src 06:15:24 <04Cerebot> 1. [src=cao] ISplatSpriggans the Ninja (L24 SpTm of Wu Jian), escaped with the Orb and 3 runes on 2022-09-08 22:59:26, with 1770754 points after 58469 turns and 2:33:21. 06:29:46 <06advil> uh locally game_id appears to be null in milestones, luckily that is the only banner that uses that column? 06:29:59 <06advil> only thing at all, not just banner 06:33:55 <06advil> afaict there's nothing that would insert or update that field 06:35:52 <06advil> this will break heretic 1 for everyone (heretic 2+3 should be fine as they're calculated differently it appears) 06:36:49 <06advil> it actually looks to me like everything else just uses start_time as a proxy for game_id (which is supposed to be a db id number, not sequell game_id), maybe someone started implementing this column instead and got about as far as writing a banner that used it 06:39:26 <09gammafunk> oh 06:39:42 <09gammafunk> right, game_id is a derived sequell field 06:49:00 <06advil> this ought to be fixable but I think something else is wrong with the query that implements heretic 1, and I won't be able to debug until later 06:49:19 <06advil> did heretic 1 actually work in t0.28?? 06:50:33 <09gammafunk> heh, I can check 06:51:37 <06advil> ah, I see the bug 06:51:53 <06advil> this query very specifically isn't right if abandonment is the last milestone in the game 06:51:57 <06advil> which it is for this game 06:52:12 <06advil> should work if there is any other milestone at all 06:53:50 <06advil> prob whoever wrote this forgot that winning isn't a milestone 06:54:26 <09gammafunk> nice 07:11:48 <06advil> not sure this one can be written as a left outer join 07:29:00 <06advil> heh, no one ever does abandon and rejoin a god 07:29:07 <06advil> not surprising, though it makes it annoying to test 07:29:45 <06advil> I will possibly get back to this in the evening if no one does it before 08:51:15 New branch created: free-the-evokes (1 commit) 13https://github.com/crawl/crawl/tree/free-the-evokes 08:51:16 03PleasingFungus02 07[free-the-evokes] * 0.30-a0-50-g973dd446be: Remove the MP cost from evoke blink/invisibility 10(4 days ago, 1 file, 2+ 2-) 13https://github.com/crawl/crawl/commit/973dd446be0b 08:52:08 freevokes! 09:41:34 New branch created: blastspark (4 commits) 13https://github.com/crawl/crawl/tree/blastspark 09:41:35 03PleasingFungus02 07[blastspark] * 0.30-a0-53-g9ed95efff1: New spell: Kindle Blastsparks (L3 Fire/Air/Tloc) 10(3 days ago, 23 files, 201+ 18-) 13https://github.com/crawl/crawl/commit/9ed95efff153 09:41:35 03PleasingFungus02 07[blastspark] * 0.30-a0-54-geb3c853292: New spell: Cigotuvi's Dreadful Rot (L2 Nec/Air/Pois) 10(21 hours ago, 13 files, 67+ 3-) 13https://github.com/crawl/crawl/commit/eb3c8532925f 09:41:35 03PleasingFungus02 07[blastspark] * 0.30-a0-55-g97e582ac12: Remove Conjure Flame 10(11 hours ago, 12 files, 10+ 115-) 13https://github.com/crawl/crawl/commit/97e582ac1246 09:41:35 03PleasingFungus02 07[blastspark] * 0.30-a0-56-g822ee23ba9: Remove Corpse Rot 10(11 hours ago, 18 files, 25+ 184-) 13https://github.com/crawl/crawl/commit/822ee23ba95c 10:04:40 New branch created: batting-nerfhundred (8 commits) 13https://github.com/crawl/crawl/tree/batting-nerfhundred 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-53-g62956b8162: Move hydras a little deeper 10(4 days ago, 1 file, 2+ 2-) 13https://github.com/crawl/crawl/commit/62956b816244 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-54-g1159c4d044: Reduce two-headed ogre damage somewhat 10(4 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/1159c4d04460 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-55-g71f743befe: Reduce orc warrior damage again 10(4 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/71f743befe30 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-56-g6fbcc576d2: Reduce boulder beetle damage somewhat 10(4 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/6fbcc576d298 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-57-g9498099ab9: Pull naga warriors back further 10(4 days ago, 1 file, 2+ 2-) 13https://github.com/crawl/crawl/commit/9498099ab994 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-58-g9138fd3d3f: Reduce orc knight and orc warlord damage 10(4 days ago, 1 file, 2+ 2-) 13https://github.com/crawl/crawl/commit/9138fd3d3fdd 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-59-g386f9ee04f: Reduce shock serpent retaliation damage by 25% 10(4 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/386f9ee04fcb 10:04:41 03PleasingFungus02 07[batting-nerfhundred] * 0.30-a0-60-g60de8ae207: Reduce salamander base damage 10(4 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/60de8ae207ae 10:04:41 New branch created: totally-faded (1 commit) 13https://github.com/crawl/crawl/tree/totally-faded 10:04:41 03PleasingFungus02 07[totally-faded] * 0.30-a0-28-g017cca133b: Show possibilities for faded altars 10(2 weeks ago, 3 files, 143+ 86-) 13https://github.com/crawl/crawl/commit/017cca133b5c 10:24:52 04Build failed for 08blastspark @ 822ee23b 06https://github.com/crawl/crawl/actions/runs/3023966818 11:51:58 Heyo, I've played DCSS on the Akrasiac server a lot in the past, but having not logged in for ~2 years I've forgotten my password. Who should I be reaching out to for account recovery? 11:58:31 ??cao 11:58:32 cao[1/1]: Crawl server, located in Phoenix, AZ. USA. WebTiles: http://crawl.akrasiac.org:8080/ SSH: crawl.akrasiac.org port 22, username:joshua, and either password: joshua or the CAO key. See {console} for details on the key and connecting. Owned by rax, but contact admins advil, |amethyst, or gammafunk in irc or Discord for assistance. 12:03:08 Mattshark89: sent you a PM about it 12:57:28 <05kate> faded altars with the list of god choices sound good, but they probably don't need to/shouldn't grant any bonus piety in that case 12:58:00 <05kate> since you're still getting the effective bonus piety of a d:1-3 god, without much of the previous downside 14:08:47 <10PleasingFungus> interesting. that would certainly simplify the mechanic 14:09:13 <10PleasingFungus> i don’t feel confident speaking to balance 14:13:32 <10PleasingFungus> could try cutting extra piety and see how it feels 14:20:40 <09gammafunk> does seem pretty reasonable 14:42:52 I think the bonus piety is probably still a good idea? like I'd definitely err on the side of making faded altar more attractive 14:43:09 rather than less 14:44:09 and presumably part of the point of early faded altars is to introduce new players to more gods, and they are more likely to get a sense of what the god is about if they start with some piety 14:44:41 <08nicolae> keep faded altars as they are but you immediately get max piety 14:45:38 immediate max piety with Chei would likely be a turn-off to many… 14:47:20 <08nicolae> shouldna been standin there 14:51:47 <09gammafunk> I guess that's a good point re: piety. Perhaps it puts somewhat more pressure on keeping gods balanced at low piety levels, since presumably you'll see early god worship increase noticeably 14:52:21 <09gammafunk> But that's something that needs to be balanced regardless of faded altars 15:06:30 <06advil> kind of obvious question, but just to double check, heretic 1 doesn't require winning right? 15:06:37 <06advil> (nor any heretic banner) 15:09:09 <09gammafunk> yeah, seems so 15:09:23 <09gammafunk> does require that the game completes in order for it to be well-defined, of course 15:13:55 <06advil> this bug affects more players than I thought because (it looks like) there are a lot of quits and deaths right after abandonment 15:14:13 <06advil> (kinda looks like ak -> any altar -> quit is the play to get this banner) 15:15:17 <09gammafunk> hrm, I guess now that I think about it 15:15:35 <09gammafunk> is heretic 1 very meaningful if you can just join and quit? 15:15:48 <09gammafunk> but I guess it's not sensible to require a win for it 15:15:54 <09gammafunk> it'd be stronger than heretic 2 15:16:51 it's a weird banner because it encourages quitting, yes 15:17:50 <09gammafunk> would be nice if we could have the top two tiers move down to tiers 1 and 2 maybe, but then there's no reasonable tier 3 15:18:00 <09gammafunk> we had something more crazy before and it was very unpopular 15:19:15 <09gammafunk> oh well, chalk that up to good banner ideas being hard to come by 15:22:33 <06advil> might be ok to just disallow quit games for this (or any?) banner 15:22:50 <06advil> then heretic 1 is what you get if you die during wrath 15:23:00 <09gammafunk> well that doesn't quite work since you can just suicide 15:23:06 <06advil> fair 15:33:10 <06advil> well, I believe I've fixed heretic 1, lmk if anyone hears of anything odd with it 15:33:38 <06advil> definitely fixed for isplatspriggans (and various others that I spot-checked) 15:36:25 <09gammafunk> thanks! 16:17:07 New branch created: mummers-faith (1 commit) 13https://github.com/crawl/crawl/tree/mummers-faith 16:17:08 03PleasingFungus02 07[mummers-faith] * 0.30-a0-30-g4470ec63ac: Give mummies innate Faith (Lici) 10(2 weeks ago, 11 files, 39+ 9-) 13https://github.com/crawl/crawl/commit/4470ec63ace8 16:17:08 New branch created: out-of-hell (1 commit) 13https://github.com/crawl/crawl/tree/out-of-hell 16:17:08 03PleasingFungus02 07[out-of-hell] * 0.29-a0-1046-g7d0399fd95: Make batty monsters their own BEH (acrobat) 10(4 weeks ago, 8 files, 10+ 6-) 13https://github.com/crawl/crawl/commit/7d0399fd95ae 16:17:08 New branch created: yak-yak-yak (1 commit) 13https://github.com/crawl/crawl/tree/yak-yak-yak 16:17:08 03PleasingFungus02 07[yak-yak-yak] * 0.30-a0-28-g0254ab5b32: Make walking tomes silenceable 10(2 weeks ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/0254ab5b32d0 16:18:11 New branch created: less-big-iron (1 commit) 13https://github.com/crawl/crawl/tree/less-big-iron 16:18:11 03PleasingFungus02 07[less-big-iron] * 0.30-a0-43-g29bfdf5e21: Tweak hand crossbow stats 10(9 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/29bfdf5e217a 17:10:40 03PleasingFungus02 07[mummers-faith] * 0.30-a0-31-gca41477d35: Remove r/atheism 10(44 seconds ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/ca41477d3539 17:58:10 Werew (L14 HOMo) ERROR in 'tilepick.cc' at line 86: Cannot get texture for bad tileidx 8369 (D:10) 19:50:04 New branch created: superignacio64 (1 commit) 13https://github.com/crawl/crawl/tree/superignacio64 19:50:04 03hellmonk02 07[superignacio64] * 0.30-a0-56-gb89df1b42f: rework Ignacio spawn rate 10(3 minutes ago, 1 file, 3+ 8-) 13https://github.com/crawl/crawl/commit/b89df1b42f3e 19:51:07 New branch created: pull/2719 (1 commit) 13https://github.com/crawl/crawl/pull/2719 19:51:07 Branch pull/2719 updated to be equal with superignacio64: 13https://github.com/crawl/crawl/pull/2719 20:12:08 <10PleasingFungus> @hellmonk think we can merge that one into trunk 20:12:47 <09hellmonk> but it will make players play trunk to see ignacio 20:12:48 <09hellmonk> the lad 20:13:02 <10PleasingFungus> we keep trunk and stable in sync during t to encourage people to play stable and to simplify debugging 20:13:33 <10PleasingFungus> we’re not going to do any relevant debugging in the next 1.5 days 20:13:56 <10PleasingFungus> and no one is going to switch to trunk for an increased ignacio chance 20:14:26 <09hellmonk> otoh it makes the commitstorm larger 20:14:32 <10PleasingFungus> lol 20:15:27 <10PleasingFungus> that’s probably a downside? harder to spot bugs, more conflicts, etc 20:15:33 <10PleasingFungus> but it certainly is fun 20:15:39 <10PleasingFungus> follow your heart. 20:15:56 <10PleasingFungus> i’m probably going to merge one or two small things in a sec 20:16:02 <10PleasingFungus> then get my meteoran killed 20:16:36 <09hellmonk> 👍 20:17:46 <10PleasingFungus> @gammafunk fyi that i’ll probably want 1-2 experimentals after t 20:21:36 <10PleasingFungus> update: ded 20:21:42 <10PleasingFungus> high speed high efficiency 20:22:18 <09hellmonk> what killed you 20:22:37 <10PleasingFungus> bad play 20:22:53 <10PleasingFungus> it was your orc end actually 20:23:15 <10PleasingFungus> orc high priest in the final section summoned a sixfirhy - i ran away from the priest and the sixfirhy looped around the other way 20:23:31 <09hellmonk> thank you for padding my killcount 20:23:40 <10PleasingFungus> npnp 20:24:52 <10PleasingFungus> possibly my last game of t. need more player buffs before i can win 20:24:52 <10PleasingFungus> clearly 20:27:36 <09gammafunk> shouldn't be a problem 20:28:33 <10PleasingFungus> thanks! 20:38:20 03PleasingFungus02 07* 0.30-a0-56-ge6a4009bfd: Tweak hand crossbow stats 10(9 days ago, 1 file, 1+ 1-) 13https://github.com/crawl/crawl/commit/e6a4009bfd47 20:51:12 Unstable branch on crawl.kelbi.org updated to: 0.30-a0-56-ge6a4009bfd (34) 22:34:49 Unstable branch on crawl.develz.org updated to: 0.30-a0-56-ge6a4009bfd (34) 22:57:06 Windows builds of master branch on crawl.develz.org updated to: 0.30-a0-56-ge6a4009bfd 23:14:48 Unstable branch on cbro.berotato.org updated to: 0.30-a0-56-ge6a4009bfd (34) 23:54:20 Monster database of master branch on crawl.develz.org updated to: 0.30-a0-56-ge6a4009bfd