jerry ,
@jerry@infosec.exchange avatar

The migration from one database to another went well, though took about an hour longer than I expected. That's just processing time to dump and then reload a 500GB database.

Once it was complete and I tried to start the instance, I kept getting timeouts. It looks like the problem was with the web processes. I spent way too long debugging them. kept timing out. Nothing I did would fix it.

then I looked at the new database server. all 96 cores were pegged. wtf?

restart the database server, goes right back to being pegged. I stop the mastodon processes, and the load falls to zero.

then I wondered.... surely I wouldn't need to run an "analyze" command on a brand new database?

So I try it. kind of at my wits end. and sure enough the load drops to near zero and everything magically starts working.

jjbaumgartner ,
@jjbaumgartner@infosec.exchange avatar

@jerry You know, I got so much productive work done during that downtime...I don't like it, I'm going to slack off even more for the rest of the week to make up for it.

jerry OP ,
@jerry@infosec.exchange avatar

@jjbaumgartner this is the way

cumulonimbus ,
@cumulonimbus@infosec.exchange avatar

@jerry Thank you for all your efforts 🙏

marshray ,
@marshray@infosec.exchange avatar

@jerry My vague understanding is that a core function of ’analyze’ is gathering the statistics that it needs to optimize queries.

Without up-to-date statistics, it may be “optimizing” queries in highly pathological ways.

jrdepriest ,
@jrdepriest@infosec.exchange avatar

@jerry

I wish I could afford more than the $12.37 or whatever you get from me (after fees) each month.
This isn't even your job job and you work harder than most people.

Muddobbers ,
@Muddobbers@infosec.exchange avatar

@jerry

The "Analyze" issue brought back some memories from a long time ago, damn..

AJCxZ0 ,
@AJCxZ0@infosec.exchange avatar

@jerry You're fired... again.

On the positive side, I've never previously seen this 500 error:

 Error 503 first byte timeout  
 first byte timeout

 Error 54113  
 Details: cache-iad-kiad7000071-IAD 1719852812 1029216601

 Varnish cache server
  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • random
  • test
  • worldmews
  • mews
  • All magazines
    •