The Official Status Thread
-
-
Do THAT MANY people get Presidents' Day off? Jesus. I've never had a job where we got Presidents' Day off.
-
-
-
I arrived at work today.
I have 75 unread emails (they are sent to my group everytime the user reports a bug). Thankfully none of those were assigned to me...yet. But I've been getting those every 5 minutes. Fucking automated notifications.
-
**Status:**strong text
RUN AWAY!!!!!!!!!!!!!!!!! THEY MECHANIZED HIM!
FLEE! FLEE WHILE YOUS TILL CAN YOU FOOLS!
-
Status: Just home from probably the most useless advanced training ever.
First hour consisted of one guy waxing poetically over the structure of his new school network (they're using Shitrix).
The problems with that:
a) we all are not IT administrators and *all have external companies doing that stuff for us.
b) for people like me who already are knowledgable in this area, this presentation amounted to the equivalent of "2+2" ("Oh, wow, a firewall. Yes, you're using a VPN to tie two physically separate locations together. yawn") and a few WTFs ("Why on earth are you saving connection data for 6 months? You're not a public ISP and I can't believe the data protection agency signed off on this.")
c) for people not in the know, this went straight over their heads as several of the other attendees told me afterwards.Second hour: Unintelligible talk about how to use the Sharepoint20(/13/07/) to upload QM books to do something. No, that /13/07/ is not a typo. They wanted to migrate from '07 to '13 but only went halfway there for raisins. And this made the upload weird. And one guy took three(3) months to add an additional column on one Sharepoint feature.
I have to talk to my principal a bit about this QM shit but largely, it sounded to me like a solution in desperate search of a problem.
-
Status: If the forum's a little slow, that's because I'm downloading the database so I can make sure my NodeBB importer doesn't mess anything up formatting-wise. It shouldn't affect much given my internet speed, though.
Behold:
ssh root@what.thedailywtf.com 'docker exec -i app su postgres -c "pg_dump -C discourse" | bzip2' | bunzip2 docker run -i --link wtdwtf-postgres:postgres --rm postgres:9.3 sh -c PGPASSWORD=discourse exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres
-
You mean the ngix error pages and time outs?
-
Strange, bzip2 is still running but the rest of the process isn't.
-
This is either you or somebody looking at user pages
-
I just used renice to set it to 10, which should mean everything gets priority over it. There's a few hundred megs of free RAM, so there shouldn't be a problem.
-
Status:
pg_dump: Dumping the contents of table "post_timings" failed: PQgetCopyData() failed. pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: The command was: COPY backup.post_timings (topic_id, post_number, user_id, msecs) TO stdout;
Why is the database server dropping connections?
-
There's a few hundred megs of free RAM, so there shouldn't be a problem.
Have you ever used Discourse?
-
Status:
pg_dump: Dumping the contents of table "post_timings" failed: PQgetCopyData() failed. pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: The command was: COPY backup.post_timings (topic_id, post_number, user_id, msecs) TO stdout;
Why is the database server dropping connections over a unix socket?
-
Well, whatever it is you're doing it's constantly bringing the server to its knees
-
Something's using up all the swap. I'm not running anything right now.
-
Zombie process? Left over from something you were doing?
I'm not blaming you btw; we all know how sucky this software is.
-
Ok, I just walked away from my computer to talk to someone and came back and
Nobody else had been on the same floor of the building I'm in in that time.
-
Yeah, it does seem to have stabilised now.
Β
Sorry if me posting that causes cooties
-
Ok, one last attempt at making the copy of the database.
That blue stuff on the CPU is
repulsion gelnice processes that don't want to get in the way.
-
Okay, turns out pg_dump uses all available RAM and swap. I'm open to suggestions for how we're gonna get the data.
-
Something's using up all the swap.
What kind of OS puts all that shit in Swap when there's room for it in actual RAM?
Probably some process running a few minutes before filled RAM & swap and you're seeing the aftermath of cleaning-up after it.
Okay, turns out pg_dump uses all available RAM and swap.
Blerp.
If it's like SQL Server, the only alternative is to detach the database, copy the files, then re-attach.
-
there shouldn't be a problem.
you are funny when you assume such sane things from Discourse
-
Wait... that report is 14 years old! How can it still be that bad?
INB4 'open sores lol'
-
Not only that, but he was still quoting in mere Megabytes. Discourse isn't safe with anything less than several Gigabytes of RAM.
-
From what I can tell, postgres has to keep everything that changes in the database from the start of the backup to the end of the backup in memory. Is Discourse really updating that much data constantly?
-
Between all the read timings, the posts that never get to be posts, and the constantly saved drafts, probably, yeah
-
root@what:~# docker exec -ti app su postgres -c 'psql -c "CREATE DATABASE discourse_backup WITH TEMPLATE discourse OWNER postgres;"' ERROR: source database "discourse" is being accessed by other users DETAIL: There are 8 other sessions using the database. root@what:~# /var/discourse/launcher enter app root@what:/# discourse enable_readonly The site is now in readonly mode. root@what:/# exit root@what:~# docker exec -ti app su postgres -c 'psql -c "CREATE DATABASE discourse_backup WITH TEMPLATE discourse OWNER postgres;"' ERROR: source database "discourse" is being accessed by other users DETAIL: There are 12 other sessions using the database.
Fuck you too, Discourse.
-
So... How does it usually get backed up?
-
I think the answer right now is "it doesn't".
-
Status: Going to make a backup with readonly enabled and then download it after I disable readonly. Hopefully there's enough disk space left.
-
.... That's a handy state for an alleged production system to be in
-
Status: I discussed this on IRC, but reposting here:
I stopped the docker container, made a copy of the postgres_data directory, and am now downloading it using
nice -n 10 tar cJv postgres_data_backup
piped over ssh. There's still 2-ish gigabytes of space left on the filesystem, so Discourse hopefully won't shit itself before I get the data downloaded. Once it's downloaded, I can delete the copy that's on the server (/root/postgres_data_backup
) unless @PJH wants it for something.
-
-
I'm guessing you aren't done yet? I was wondering what was causing all the cooties...
-
If a process running at a lower priority than every other process on the system that is using 2.4% of system memory can cause cooties, I'm not sure what to believe anymore.
-
-
I'm not sure what to believe anymore.
Might I suggest death, taxes and in infinite ability of discourse to suck balls?
-
They both look the same to me.
-
Status: Wondering how performance can be so ba- oh, right, Discourse
-
Even better, now there are no images (instead you have 'Uploading...') rather than two that look the same.
-
I hooked it up yesterday and god damn smart TVs are awful. Somehow, despite being contained in a tiny space, the FireTV stick on his DumbTV manages to be infinitely more responsive and delivers more functinoality.
In my limited experience Smart TVs are like most Android tablets--cheaped out on the CPU to save a buck or two.
-
-
In case someone is reading this once the site has stabilized, @LB_'s graph looks to be the latest response graph from http://servercooties.com/#graph.
-
What's amazing is that it's not running out of any resource and the compression process is running with low priority. Yet Discourse still can't run consistently.
-
President's day is nice.
-
More I'm Bored And Surfing StackOverflow:
I'm looking for a word that can describe a person who does nice things for other people (e.g holding the door open, carrying someone's things) but only for self gain; this person only does nice things to make themselves look good in the eyes of others, but doesn't actually care about the well-being of the people they're helping.
Hm, that's an interesting request. Maybe "selfish altruism?" Let's see what the comments have to say:
Hi! Welcome to EL&U SE. Please see the single-word-requests tag info to know more about asking SWR questions. To ensure your question is not closed as off-topic, please be specific about the intended use of the word. YOU MUST INCLUDE A SAMPLE SENTENCE DEMONSTRATING HOW THE WORD WOULD BE USED. Is there an example sentence you could add to the question?* β BiscuitBoy 16 hours ago
Wow! Do you think BiscuitBoy has any idea how much of a dickhole he is? Jesus. Fuck off, BiscuitBoy.
http://movies.stackexchange.com/questions/48796/top-billed-actor-with-the-least-screen-time
I think the Superman example has me beat, but I was thinking Beneath the Planet of the Apes, where Charlton Heston only agreed to do the movie if his two terms were met:
- He was in less than 10 minutes
- The planet gets destroyed at the end of the film (seriously) so that there could be no more sequels
The studio accommodated him, but then make another sequel despite the destruction of the planet. Huh.
... then I Googled it and found out Heston wasn't credited as a lead in that film anyway. Well poops.
This one's fun because the guy responds to every single answer pushing his "plastic windows" position despite all logic and rationality.
I actually think that recycling is yet another argument against glass windows. A couple of times a window has broken for me, and it has been expensive to call a specialist to reinstall a new one. But I have consumed thousands of plastic transparent soda bottles and none of them ever broke. Nor have I heard of anyone ever getting hurt by a plastic bottle. There's an elaborate consumer recycling system for PET bottles, melting and reforming them, although they really only need to be cleaned and refilled since they are practically unbreakable. β LocalFluff 2 days ago
Teach the glass window conspiracy, sheeple!
Argument nobody mentions: plastics are made from oil; glass only requires easily-available silicon and a heat source.
http://scifi.stackexchange.com/questions/119511/what-is-a-hrung
Humorlessness that rivals this forum's members:
OTOH, if nobody knows, then why does there exist a name for boys who aren't βable to satisfactorily explain what a Hrung is, nor why it should choose to collapse on Betelgeuse Sevenβ? β leftaroundabout 4 hours ago
@leftaroundabout: That's the joke. β Nate Eldredge 3 hours ago
-
-
Haha I was just reading that one.
I assume the dragon here is sentient and we can communicate with him, because otherwise I think he'd be pretty pissed when a rocket-blast hits his tail.
BTW, I'm not a Tolkien fan-- when he says "as big as Smaug", how big is that? He can carry a shuttle? That's a big-ass dragon. A shuttle's like 2/3rds the size of a 747.