00:48:57 Monster database of master branch on crawl.develz.org updated to: 0.30-a0-347-gf58ed5266c 01:31:17 Fork (bcrawl) on crawl.kelbi.org updated to: 0.23-a0-4850-gd9e8576752 02:06:59 -!- Stella is now known as Stella[OotC] 04:22:48 Experimental (bcrawl) branch on underhound.eu updated to: 0.23-a0-4850-gd9e8576752 05:41:38 -!- nabru- is now known as nabru 08:24:37 03advil02 07* 0.30-a0-348-g79de549745: feat: mark some potentially blocking functions 10(18 hours ago, 1 file, 5+ 0-) 13https://github.com/crawl/crawl/commit/79de549745c6 08:24:37 03advil02 07* 0.30-a0-349-gdc488dc59d: refactor: rewrite webtiles db code 10(18 hours ago, 4 files, 486+ 310-) 13https://github.com/crawl/crawl/commit/dc488dc59d06 08:24:37 03advil02 07* 0.30-a0-350-g0c61f328b0: feat: allow customizing recovery token lifetime 10(14 minutes ago, 2 files, 55+ 14-) 13https://github.com/crawl/crawl/commit/0c61f328b095 08:24:37 03advil02 07* 0.30-a0-351-g17a13138e6: fix: replace password tokens when generating new ones 10(9 minutes ago, 1 file, 11+ 2-) 13https://github.com/crawl/crawl/commit/17a13138e6b5 08:31:05 Unstable branch on crawl.akrasiac.org updated to: 0.30-a0-351-g17a13138e6 (34) 08:33:31 Unstable branch on crawl.kelbi.org updated to: 0.30-a0-351-g17a13138e6 (34) 08:51:05 04Build failed for 08master @ 17a13138 06https://github.com/crawl/crawl/actions/runs/3404913009 08:51:06 <06advil> ok, as far as I know that db rewrite works, doesn't break anything, etc 08:51:43 <06advil> man that llvm install process 08:52:43 <06advil> but, just in case, hopefully server admins do regularly make db backups, now is a good time to do it 😄 13:21:19 03advil02 07* 0.30-a0-352-g1e81539c98: fix: more blocking annotation adjustments 10(26 minutes ago, 2 files, 5+ 0-) 13https://github.com/crawl/crawl/commit/1e81539c982e 13:25:49 Unstable branch on crawl.akrasiac.org updated to: 0.30-a0-352-g1e81539c98 (34) 13:34:08 Unstable branch on crawl.kelbi.org updated to: 0.30-a0-352-g1e81539c98 (34) 14:25:46 <06advil> huh, why are there 3 duplicated usernames in cao's db 14:25:54 <06advil> that seems .. bad? 14:27:13 <06advil> I guess the code doesn't really rely on a unique username assumption 14:28:07 <06advil> they're all around the same time and very early, so I guess there must have been bugs 14:30:45 <06advil> early 2007 14:38:08 <06advil> well, I've finally identified one longstanding issue on CAO that was previously mysterious: the user db is big enough that it needs an index on username 14:38:14 <06advil> kind of obvious in retrospect 14:45:26 <10PleasingFungus> does make sense 15:03:49 -!- jfcaron_ is now known as jfcaron 15:18:19 <09gammafunk> how many users does CAO have? 15:19:52 <09gammafunk> looks like beem has almost 4900 across all servers 15:19:57 <09gammafunk> that's subscribers 15:57:44 <09gammafunk> hrm, I can log in fine on CAO with the appropriate options 15:58:00 <09gammafunk> to enable client support for deprecated rsa keys 15:58:14 <09gammafunk> but not only am I going to have to generate a new key for my primary account 15:59:31 <09gammafunk> but I suppose we'll also need to regenerate all the server rsa keys at some point with a more modern signature 16:00:56 <09gammafunk> oh, is this just an issue with cao's sshd being too old? 16:01:48 <09gammafunk> indeed, openssh 6.0p1 16:02:20 I sent advil a set of recommendations based on a conversation with Simon Tatham about that 16:23:37 Unstable branch on underhound.eu updated to: 0.30-a0-352-g1e81539c98 (34) 17:20:15 OT: PleasingFungus: 1) Aimbot is insane but I finally got it done. 2) How on EARTH is 6 scanners or 20 area possible?!?! (surprisingly only just above the speed medal, 211 vs 208) 17:24:00 <10PleasingFungus> 🙂 18:09:54 <06advil> oh huh, it appears that the real speedup was from the unique constraint I added to the index the first time 18:10:10 <06advil> since that col was not otherwise unique (except in practice) 18:11:32 <06advil> looks like a non-unique index + LIMIT 1 on the query accomplishes a similar effect, I wonder if that can be relied on 18:12:21 <06advil> the db has 97151 accounts 18:15:36 <09gammafunk> yeah, I eventaully went and checked myself via dgl command, but thanks 18:36:09 -!- jfcaron_ is now known as jfcaron 19:08:22 03advil02 07* 0.30-a0-353-ge1e7d3de80: fix: add a unique index for dglusers.username 10(8 minutes ago, 1 file, 25+ 3-) 13https://github.com/crawl/crawl/commit/e1e7d3de80dd 19:12:00 Unstable branch on crawl.akrasiac.org updated to: 0.30-a0-353-ge1e7d3de80 (34) 19:18:44 Unstable branch on crawl.kelbi.org updated to: 0.30-a0-353-ge1e7d3de80 (34) 19:30:23 03advil02 07* 0.30-a0-354-g6b83867211: fix: add COLLATE NOCASE to the username index 10(2 minutes ago, 1 file, 4+ 1-) 13https://github.com/crawl/crawl/commit/6b8386721171 19:33:50 Unstable branch on crawl.kelbi.org updated to: 0.30-a0-354-g6b83867211 (34) 19:35:38 <06advil> well, I think that's going to make a difference on cao 19:35:45 <06advil> not that there's not other stuff going on 19:40:38 04Build failed for 08master @ e1e7d3de 06https://github.com/crawl/crawl/actions/runs/3407034036 19:49:50 (flake) 19:58:46 04Build failed for 08master @ 6b838672 06https://github.com/crawl/crawl/actions/runs/3407104339 23:34:56 Unstable branch on crawl.develz.org updated to: 0.30-a0-354-g6b83867211 (34) 23:55:51 Windows builds of master branch on crawl.develz.org updated to: 0.30-a0-354-g6b83867211