Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Nov 14 18:07
    codecov[bot] commented #1275
  • Nov 14 18:06
    codecov[bot] commented #1275
  • Nov 14 18:06
    codecov[bot] commented #1276
  • Nov 14 18:00

    dependabot[bot] on pip

    (compare)

  • Nov 14 18:00
    dependabot[bot] closed #1273
  • Nov 14 18:00
    dependabot[bot] commented #1273
  • Nov 14 18:00

    dependabot[bot] on pip

    (compare)

  • Nov 14 18:00
    dependabot[bot] closed #1274
  • Nov 14 18:00
    dependabot[bot] commented #1274
  • Nov 14 18:00
    dependabot[bot] opened #1276
  • Nov 14 18:00
    dependabot[bot] labeled #1276
  • Nov 14 18:00
    dependabot[bot] labeled #1275
  • Nov 14 18:00

    dependabot[bot] on pip

    Bump sqlalchemy from 1.4.40 to … (compare)

  • Nov 14 18:00
    dependabot[bot] opened #1275
  • Nov 14 18:00

    dependabot[bot] on pip

    Bump sqlalchemy from 1.4.40 to … (compare)

  • Nov 13 08:42
    MattCzar13 commented #205
  • Nov 08 18:00
    dependabot[bot] closed #1266
  • Nov 08 18:00

    dependabot[bot] on pip

    (compare)

  • Nov 08 18:00
    dependabot[bot] commented #1266
  • Nov 08 18:00
    dependabot[bot] labeled #1274
charmander
@charmander:matrix.org
[m]
PostgreSQL can do replication and it looks like there’s a way to get zero-downtime OS upgrades without introducing any extra software
ikanimew
@ikanimew
ooooh neat!
charmander
@charmander:matrix.org
[m]
but we’d have to upgrade it first :P
<del>and… does that upgrade have to go through every intermediate version?</del> sounds like it doesn’t, phew
ikanimew
@ikanimew
yah.. we do have db3 and db4 which were intended for that, but just never got the DB itself migrated.. and now I'm having to do this workaround, heh
import complete.. booting db1 up now
yaaay and networking came up correctly! We're good to bring the site back up unless you want to poke anything first?
5 replies
charmander
@charmander:matrix.org
[m]
I could start an application-side project to move the welcome table somewhere else in the meantime? It accounts for about 80% of the entire database
1 reply
should make upgrading faster
contrary to their restart policy :/
started pweb1’s container ✅
ikanimew
@ikanimew
oops, that'd do it
charmander
@charmander:matrix.org
[m]
140 million rows, 200k users… should really take more like 5 GB
charmander
@charmander:matrix.org
[m]
@ikanimew pweb1’s memory appears to have been decreased by 2 GB instead of increased :D
Oh, the actual amount is strange and changing though. Not enough physical server memory to go around?
I’m going to try turning off the not-yet-used pweb2 for now, since it also has ~2 GB and will need to be restarted to be useful anyway
seems like that didn’t help, though
well, maybe a bit?
ikanimew
@ikanimew
oh! I think they're doing dynamic RAM assignments.. oops, I can set them to static
the host still has about 100GB free so we're good on that end
1 reply
charmander
@charmander:matrix.org
[m]
Weasyl started having memory issues again at some point, and this time I actually remembered to debug 🎉
the (an?) issue appears to be a 1 GB ImageMagick temporary file sticking around in /tmp
there are also temporary files not being cleared from /weasyl/temp
It might be worth finishing up that project to get rid of ImageMagick for more than just security reasons, then…
charmander
@charmander:matrix.org
[m]
Luckily, it appears that only avatar uploads were affected.
Not sure how that works. Maybe only the animated GIF ones, or…?
charmander
@charmander:matrix.org
[m]
Restarted the container this time instead of just clearing its /tmp because of the other memory leak(s)
it’s possible that ImageMagick only creates these temporary files based on the amount of free memory
if that’s true, it’s also probable that tmpfs use counts against the free memory used in this calculation 🙃
seems like it might be possible to configure ImageMagick to never write to “disk” with its policy.xml thing, but again, it’s better just to replace it
unfortunately I won’t have time to do that for a while :/
charmander
@charmander:matrix.org
[m]
Pillow has this cool thing where there’s an ImageCms function to create a few predefined color profiles
one of them is XYZ, which is the one I want to use
except there’s no way to select the mode XYZ uses, so there’s no way to use the predefined XYZ profile
LAB exists but with no support for alpha
charmander
@charmander:matrix.org
[m]
if you want non-palette color alpha, your choices of Pillow modes are:
  1. RGBA
looks like we’re resizing in sRGB for the foreseeable future! ✨
deer-spangle
@deer-spangle:matrix.org
[m]
Pillow does seem to have odd little gaps like that at times x_x
philpem
@philpem
there's a bunch of folks messaging about broken avatar upload, if anyone siteside can please take a look?
Sender: Alexus L ~alexusl
Date: September 25, 2022 12:34:50 GMT+1
Subject: I can't set an icon
Is there maybe a way you can help? Please?
and a journal I thought was recent but turns out to be from like ... july: https://www.weasyl.com/journal/170020/502-gateway-error-when-trying-to-update-avatar
philpem
@philpem
The July journal has a post from October 8th re. avatar upload issues, @charmander:matrix.org / @ikanimew , any chance you can look into this?
philpem
@philpem
Also hmm, I was just about to label Weasyl/weasyl#1267 as "moderation" and "new dev friendly" and assign it to me, but I don't seem to have privs on the github repo
deer-spangle
@deer-spangle:matrix.org
[m]
Two philpems, huh
1 reply
That makes some sense
philpem
@philpem
@charmander:matrix.org / @ikanimew , if either of you have a moment can you please take a look at the Matrix chat, and the avatar upload issue?
(sorry to be a nag!)
charmander
@charmander:matrix.org
[m]
Okay, avatars and custom/character thumbnails should be fixed now.
(And by that I mean I swapped to a new instance. The underlying cause remains.)
I don’t understand how the rest of the backend operated for so long with no memory available… unless the only memory leak is ImageMagick, and breaking it stops further memory from leaking :D