You might want to try and set the slow-query log, and review your db logs.
I am wondering next time if you just try and restart the database, and see if that works, at least it will narrow your issue down. Then try the web server if the db does not work.
Not sure how much sysadmin skills you have, but also check your load avg next time prior to rebooting. That might give you a hint if you see the load is high, then you can start looking at processes that are taking up the majority of resources.
Let me know if you need any help with that, but there are plenty of resources on the web.
Yeah, I would start with restarting the services first, and see where that gets you.
Once you can isolate it to which the part of the stack, at least that will give you a little more info where you should start looking.
Understand also, that as root, you may still be able to connect to a database, yet it may not be processing other connections, due to the privileged nature of root super cedes other lesser connections.
Anyways, uptime is your friend for load avg.
As long as your load avg is 2 or below, it should be safe to use the top command. Ideally, once it is above that, it is generally not advised to use top, as that is a resource intensive command. Then you should solely rely on the ps command. i.e ps aux | sort -nrk 3,3 | head -n 5
With top, you can look at what is consuming Memory vs CPU via the sorting function. It would probably be a good idea to at least familiarize yourself with those commands as a start.
Yeah, Mary in finance messed up the accounts payable spreadsheet so Florence in HR laid off all the voat IT staff last week due to no funding. The whole voat corporate office is up in arms and some are even threatening to quit the donut club over this.
Someone said the other day about how voat is run by fbi and that's why it always stays up so the fbi caught wind of this and took the site down to look legit.
[ - ] Just_me 1 point 1.3 yearsJan 27, 2023 20:32:02 ago (+1/-0)
I was looking on other sites for any clues these past 2 days. Are there any plan b type sites for this place. Poal blows and I won't do reddit. I'm mostly illiterate when it comes to this stuff.
[ - ] Kung_Flu 1 point 1.3 yearsJan 27, 2023 19:36:52 ago (+1/-0)*
A day ago there was a thread about an imminent nuclear attack on US soil. For 48 hours after, stability of the site is very low. Really makes one think.
[ + ] ParnellsUprising
[ - ] ParnellsUprising 43 points 1.3 yearsJan 27, 2023 16:52:04 ago (+43/-0)
[ + ] diggernicks
[ - ] diggernicks 5 points 1.3 yearsJan 27, 2023 17:22:53 ago (+7/-2)
[ + ] PostWallHelena
[ - ] PostWallHelena 3 points 1.3 yearsJan 27, 2023 18:41:46 ago (+3/-0)
[ + ] Clubberlang
[ - ] Clubberlang 2 points 1.3 yearsJan 27, 2023 18:22:46 ago (+2/-0)
[ + ] OftenWrong
[ - ] OftenWrong 2 points 1.3 yearsJan 27, 2023 19:07:04 ago (+2/-0)
[ + ] Jiggggg
[ - ] Jiggggg 2 points 1.3 yearsJan 27, 2023 21:17:29 ago (+2/-0)
[ + ] Monica
[ - ] Monica 0 points 1.3 yearsJan 27, 2023 22:05:21 ago (+0/-0)
[ + ] WhiteRonin
[ - ] WhiteRonin 15 points 1.3 yearsJan 27, 2023 16:56:23 ago (+15/-0)
[ + ] lord_nougat
[ - ] lord_nougat 7 points 1.3 yearsJan 27, 2023 17:15:51 ago (+7/-0)
[ + ] OftenWrong
[ - ] OftenWrong 1 point 1.3 yearsJan 27, 2023 19:07:41 ago (+1/-0)
[ + ] lord_nougat
[ - ] lord_nougat 3 points 1.3 yearsJan 27, 2023 19:30:28 ago (+3/-0)
[ + ] ItsOk2bArian
[ - ] ItsOk2bArian 1 point 1.3 yearsJan 27, 2023 23:56:29 ago (+1/-0)
[ + ] WhiteRonin
[ - ] WhiteRonin 2 points 1.3 yearsJan 27, 2023 20:45:22 ago (+2/-0)
[ + ] deleted
[ - ] deleted 1 point 1.3 yearsJan 28, 2023 02:03:09 ago (+1/-0)
[ + ] shitface9000
[ - ] shitface9000 0 points 1.3 yearsJan 27, 2023 21:51:11 ago (+0/-0)
[ + ] PostWallHelena
[ - ] PostWallHelena 12 points 1.3 yearsJan 27, 2023 18:49:06 ago (+12/-0)
I felt like something was missing all day, because I couldnt talk to you faggots. Really glad to have this place.
[ + ] Sector7
[ - ] Sector7 12 points 1.3 yearsJan 27, 2023 16:51:30 ago (+12/-0)
[ + ] system
[ - ] system 8 points 1.3 yearsJan 27, 2023 16:56:05 ago (+8/-0)
[ + ] ParnellsUprising
[ - ] ParnellsUprising 3 points 1.3 yearsJan 27, 2023 16:58:57 ago (+3/-0)
[ + ] system
[ - ] system 3 points 1.3 yearsJan 27, 2023 17:00:56 ago (+3/-0)
[ + ] ParnellsUprising
[ - ] ParnellsUprising 4 points 1.3 yearsJan 27, 2023 17:20:17 ago (+4/-0)
I am wondering next time if you just try and restart the database, and see if that works, at least it will narrow your issue down. Then try the web server if the db does not work.
Not sure how much sysadmin skills you have, but also check your load avg next time prior to rebooting. That might give you a hint if you see the load is high, then you can start looking at processes that are taking up the majority of resources.
Let me know if you need any help with that, but there are plenty of resources on the web.
[ + ] system
[ - ] system 2 points 1.3 yearsJan 27, 2023 18:00:38 ago (+2/-0)
I've never worked in a professional setting and my knowledge is scattered, networking stuff is my weakest link.
I can still access the DB when it does this so I don't believe it's the issue. It's like a port is getting jammed or something.
[ + ] ParnellsUprising
[ - ] ParnellsUprising 3 points 1.3 yearsJan 27, 2023 19:06:38 ago (+3/-0)
Once you can isolate it to which the part of the stack, at least that will give you a little more info where you should start looking.
Understand also, that as root, you may still be able to connect to a database, yet it may not be processing other connections, due to the privileged nature of root super cedes other lesser connections.
Anyways, uptime is your friend for load avg.
As long as your load avg is 2 or below, it should be safe to use the top command. Ideally, once it is above that, it is generally not advised to use top, as that is a resource intensive command. Then you should solely rely on the ps command. i.e ps aux | sort -nrk 3,3 | head -n 5
With top, you can look at what is consuming Memory vs CPU via the sorting function. It would probably be a good idea to at least familiarize yourself with those commands as a start.
[ + ] doginventer
[ - ] doginventer 2 points 1.3 yearsJan 27, 2023 18:19:46 ago (+2/-0)
[ + ] diggernicks
[ - ] diggernicks 1 point 1.3 yearsJan 27, 2023 18:21:54 ago (+1/-0)
[ + ] ParnellsUprising
[ - ] ParnellsUprising 0 points 1.3 yearsJan 29, 2023 19:22:47 ago (+0/-0)
[ + ] Cantaloupe
[ - ] Cantaloupe 2 points 1.3 yearsJan 27, 2023 17:02:06 ago (+2/-0)
[ + ] knightwarrior41
[ - ] knightwarrior41 1 point 1.3 yearsJan 27, 2023 18:42:04 ago (+1/-0)
ask anal schwab he might know something about that
[ + ] Master_Foo
[ - ] Master_Foo 3 points 1.3 yearsJan 27, 2023 17:02:47 ago (+3/-0)
[ + ] Clubberlang
[ - ] Clubberlang 2 points 1.3 yearsJan 27, 2023 18:25:48 ago (+2/-0)
[ + ] BoomerChristCuckFinalForm
[ - ] BoomerChristCuckFinalForm 3 points 1.3 yearsJan 27, 2023 18:28:22 ago (+4/-1)
[ + ] bosunmoon
[ - ] bosunmoon [op] 2 points 1.3 yearsJan 27, 2023 17:18:57 ago (+2/-0)
[ + ] lord_nougat
[ - ] lord_nougat 0 points 1.3 yearsJan 27, 2023 17:44:49 ago (+0/-0)
[ + ] OftenWrong
[ - ] OftenWrong 7 points 1.3 yearsJan 27, 2023 19:08:31 ago (+7/-0)
[ + ] con77
[ - ] con77 6 points 1.3 yearsJan 27, 2023 17:03:17 ago (+7/-1)
[ + ] Sunman_Omega
[ - ] Sunman_Omega 15 points 1.3 yearsJan 27, 2023 17:15:43 ago (+15/-0)
[ + ] lord_nougat
[ - ] lord_nougat 5 points 1.3 yearsJan 27, 2023 17:17:14 ago (+5/-0)
That is an excellent idea.
[ + ] HeavyBrain
[ - ] HeavyBrain 4 points 1.3 yearsJan 27, 2023 18:55:15 ago (+4/-0)
[ + ] AngryWhiteKeyboardWarrior
[ - ] AngryWhiteKeyboardWarrior 3 points 1.3 yearsJan 27, 2023 20:44:14 ago (+3/-0)
[ + ] BulletStopper
[ - ] BulletStopper 2 points 1.3 yearsJan 27, 2023 18:34:09 ago (+2/-0)
That can't be very comfortable.
[ + ] Thyhorrorcosmic103
[ - ] Thyhorrorcosmic103 1 point 1.3 yearsJan 27, 2023 18:18:13 ago (+1/-0)
[ + ] PeckerwoodPerry
[ - ] PeckerwoodPerry 1 point 1.3 yearsJan 27, 2023 18:54:40 ago (+1/-0)
Making that shit count.
[ + ] shitface9000
[ - ] shitface9000 0 points 1.3 yearsJan 27, 2023 21:51:31 ago (+0/-0)
[ + ] diggernicks
[ - ] diggernicks -3 points 1.3 yearsJan 27, 2023 18:21:09 ago (+0/-3)
[ + ] WhiteRonin
[ - ] WhiteRonin 0 points 1.3 yearsJan 27, 2023 17:43:30 ago (+0/-0)
[ + ] PeckerwoodPerry
[ - ] PeckerwoodPerry 5 points 1.3 yearsJan 27, 2023 18:56:20 ago (+5/-0)
[ + ] FacelessOne
[ - ] FacelessOne 4 points 1.3 yearsJan 27, 2023 18:57:47 ago (+4/-0)
[ + ] AugustineOfHippo2
[ - ] AugustineOfHippo2 4 points 1.3 yearsJan 27, 2023 17:26:02 ago (+4/-0)
[ + ] lord_nougat
[ - ] lord_nougat 6 points 1.3 yearsJan 27, 2023 17:46:13 ago (+6/-0)
And system stole my stapler!
[ + ] MuricaPersonified
[ - ] MuricaPersonified 2 points 1.3 yearsJan 27, 2023 18:51:32 ago (+2/-0)
[ + ] AugustineOfHippo2
[ - ] AugustineOfHippo2 2 points 1.3 yearsJan 27, 2023 20:09:22 ago (+2/-0)
Oh, the travesty.
[ + ] Jiggggg
[ - ] Jiggggg 2 points 1.3 yearsJan 27, 2023 21:16:27 ago (+2/-0)
[ + ] lord_nougat
[ - ] lord_nougat 1 point 1.3 yearsJan 27, 2023 21:27:55 ago (+1/-0)
[ + ] bosunmoon
[ - ] bosunmoon [op] 5 points 1.3 yearsJan 27, 2023 17:30:34 ago (+5/-0)
[ + ] lord_nougat
[ - ] lord_nougat 4 points 1.3 yearsJan 27, 2023 17:47:00 ago (+4/-0)
[ + ] MuricaPersonified
[ - ] MuricaPersonified 3 points 1.3 yearsJan 27, 2023 18:45:17 ago (+3/-0)
HR said it was a "forcible donation" and I should check my privilege.
[ + ] lord_nougat
[ - ] lord_nougat 4 points 1.3 yearsJan 27, 2023 19:28:56 ago (+4/-0)
[ + ] Clubberlang
[ - ] Clubberlang 1 point 1.3 yearsJan 27, 2023 18:26:37 ago (+1/-0)
I thought they all died
[ + ] AugustineOfHippo2
[ - ] AugustineOfHippo2 2 points 1.3 yearsJan 27, 2023 20:10:47 ago (+2/-0)
[ + ]deleted
[ - ] deleted 4 points 1.3 yearsJan 27, 2023 17:11:36 ago (+4/-0)
[ + ] shitface9000
[ - ] shitface9000 3 points 1.3 yearsJan 27, 2023 17:13:22 ago (+3/-0)
[ + ] Monica
[ - ] Monica 3 points 1.3 yearsJan 27, 2023 22:04:40 ago (+3/-0)
[ + ] shitface9000
[ - ] shitface9000 2 points 1.3 yearsJan 27, 2023 17:12:39 ago (+2/-0)
[ + ] Clubberlang
[ - ] Clubberlang 3 points 1.3 yearsJan 27, 2023 18:27:45 ago (+3/-0)
[ + ] Just_me
[ - ] Just_me 1 point 1.3 yearsJan 27, 2023 20:32:02 ago (+1/-0)
[ + ] bosunmoon
[ - ] bosunmoon [op] 1 point 1.3 yearsJan 27, 2023 20:41:30 ago (+1/-0)
[ + ] PeckerwoodPerry
[ - ] PeckerwoodPerry 0 points 1.3 yearsJan 27, 2023 21:20:29 ago (+0/-0)
[ + ] lord_nougat
[ - ] lord_nougat 0 points 1.3 yearsJan 27, 2023 21:35:08 ago (+0/-0)
[ + ] Kung_Flu
[ - ] Kung_Flu 1 point 1.3 yearsJan 27, 2023 19:36:52 ago (+1/-0)*
Edit: https://www.voat.xyz/viewpost.php?postid=63d221dab5be8 https://archive.is/S2J43
[ + ] oyveyo
[ - ] oyveyo 0 points 1.3 yearsJan 27, 2023 21:36:04 ago (+0/-0)
[ + ] lord_nougat
[ - ] lord_nougat 1 point 1.3 yearsJan 27, 2023 17:15:28 ago (+1/-0)
[ + ] Crackinjokes
[ - ] Crackinjokes 1 point 1.3 yearsJan 27, 2023 16:49:33 ago (+1/-0)
[ + ] bossman131
[ - ] bossman131 0 points 1.3 yearsJan 28, 2023 08:27:04 ago (+0/-0)
[ + ] Jerd34
[ - ] Jerd34 0 points 1.3 yearsJan 27, 2023 21:49:06 ago (+0/-0)
[ + ] Thought_Criminal
[ - ] Thought_Criminal 0 points 1.3 yearsJan 27, 2023 18:11:53 ago (+0/-0)