Getting this error while accessing any DB-dependant page: Internal server error
2023-10-17 29042, 2023
plibither8
(psycopg2.OperationalError) FATAL: remaining connection slots are reserved for non-replication superuser connections (Background on this error at: https://sqlalche.me/e/14/e3q8) Anyone else facing this issue?
The main LB site? That works for me here, interesting
2023-10-17 29017, 2023
reosarevok
Hopefully the pinged LB team members can help figure it out
2023-10-17 29038, 2023
plibither8
Yep, the main one. I was logged in first and accessing my profile and got the error, so I thought to try to clear the website storage and retry. That didn't work.
2023-10-17 29047, 2023
plibither8
Thanks for the quick response guys!
2023-10-17 29018, 2023
plibither8
Seems to be working now!
2023-10-17 29002, 2023
reosarevok
Thanks for reporting the issue in any case, worth investigating for the team to try to avoid it happening again!
2023-10-17 29004, 2023
plibither8
( ☞˙ᵕ˙)☞
2023-10-17 29026, 2023
reosarevok
yvanzo: ok, installed prereqs for mb-docker - how do I set it to run and create containers in a different SSD than the default?
2023-10-17 29037, 2023
reosarevok
Is this something to set up before I run all the commands?
Yes, I knew about that one, I didn't remember I still had the MBS containers around tho
2023-10-17 29039, 2023
yvanzo
Those are probably MeB.o containers too.
2023-10-17 29015, 2023
yvanzo
MeB.o uses both Redis and PG.
2023-10-17 29044, 2023
reosarevok
Yeah, but I assume musicbrainz-docker_indexer_1 and whatnot are MBS :)
2023-10-17 29023, 2023
reosarevok
Anyway, I'd be happy to just clear all this and start from scratch - so stop all, remove all, remove all images?
2023-10-17 29031, 2023
yvanzo
reosarevok: It’s probably fine to wipe everything out: `docker system prune --all --volumes
2023-10-17 29043, 2023
yvanzo
Oops, `docker system prune --all --volumes`
2023-10-17 29002, 2023
yvanzo
Everything is stopped already (status = exited)
2023-10-17 29015, 2023
reosarevok
Is it? some said Up 10 minutes
2023-10-17 29028, 2023
reosarevok
Anyway, running that for now, let it purge as much as it will
2023-10-17 29031, 2023
yvanzo
oh sorry
2023-10-17 29049, 2023
yvanzo
Had to scroll down.
2023-10-17 29056, 2023
yvanzo
So you actually have had some containers part of MB-docker running for about 15 months.
2023-10-17 29001, 2023
reosarevok
Seems so :D
2023-10-17 29011, 2023
yvanzo
`prune` won’t remove the running containers and the images they use.
2023-10-17 29020, 2023
plibither8 has quit
2023-10-17 29024, 2023
reosarevok
Any reason not to just stop them and then pruning again?
2023-10-17 29039, 2023
yvanzo
You can just use them.
2023-10-17 29002, 2023
reosarevok
So I can move them to a different partition?
2023-10-17 29013, 2023
yvanzo
You probably have enough disk space on this partition anyway.
2023-10-17 29008, 2023
reosarevok
I probably do, but it's HDD not SSD :)
2023-10-17 29017, 2023
reosarevok
Will that difference make, well, a difference?
2023-10-17 29041, 2023
reosarevok
(I *think* those are running on my secondary HDD, anyway)
2023-10-17 29047, 2023
reosarevok
(not sure how to tell exactly)
2023-10-17 29015, 2023
yvanzo
Dunno what is faster for you: internal HDD or external SSD, it depends on buses.
2023-10-17 29014, 2023
reosarevok
Well, we can just put them in the HDD I guess for now, less thinking
2023-10-17 29040, 2023
yvanzo
You can use either `dd` or `hdparm` to find it out.
2023-10-17 29017, 2023
nawcom has quit
2023-10-17 29030, 2023
nawcom_ joined the channel
2023-10-17 29015, 2023
reosarevok
To find out where my docker containers are, or what is faster? :)
2023-10-17 29023, 2023
nawcom_ is now known as nawcom
2023-10-17 29054, 2023
reosarevok
(reading on those, what is faster I guess)
2023-10-17 29010, 2023
reosarevok
I can probably live with slower, let's just get it set up in the HDD
2023-10-17 29020, 2023
yvanzo
what is faster ^
2023-10-17 29005, 2023
yvanzo
Since there already are performance issues, it's probably safer not to pile up hardware issues.
2023-10-17 29055, 2023
yvanzo
To find out where your current compose project files are: `docker container inspect --format '{{.Config.Labels}}' musicbrainz-docker-db-1`
2023-10-17 29030, 2023
yvanzo
See `com.docker.compose.project.working_dir`
2023-10-17 29047, 2023
reosarevok
com.docker.compose.project.working_dir:/media/data/musicbrainz-docker - ok, that's the HDD
2023-10-17 29021, 2023
yvanzo
That's only for the config files, not for the containers.
2023-10-17 29054, 2023
reosarevok
What about for the containers themselves?
2023-10-17 29057, 2023
yvanzo
`docker system info -f '{{.DockerRootDir}}'`
2023-10-17 29040, 2023
reosarevok
That's /media/data/docker so also the HDD. Guess we moved that there last time we tried - but then we tried to reuse the existing MB local install for dev and it was messy
2023-10-17 29002, 2023
reosarevok
IIRC that's why I gave up eventually
2023-10-17 29016, 2023
reosarevok
So let's just make this a fully separate install this time
2023-10-17 29053, 2023
yvanzo
Then stop everything and prune.
2023-10-17 29056, 2023
reosarevok
Perfect
2023-10-17 29031, 2023
reosarevok
Ok, done
2023-10-17 29041, 2023
reosarevok
I guess now I just follow the dev install instructions?
2023-10-17 29052, 2023
yvanzo
👍
2023-10-17 29042, 2023
reosarevok
Doing the setup
2023-10-17 29045, 2023
reosarevok
A red line says "dpkg-preconfigure: unable to re-open stdin:"
2023-10-17 29051, 2023
reosarevok
should I worry?
2023-10-17 29000, 2023
reosarevok
Seems to be happily continuing so I guess not?
2023-10-17 29025, 2023
reosarevok
heh
2023-10-17 29027, 2023
reosarevok
DEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip can be found at https://pip.pypa.io/en/latest/development/release… pip 21.0 will remove support for this functionality.
It is! Golu, chintu, monu, etc, reosarevok 😂 But I would like to see an example pf it being used incorrectly somewhere to understand the context better
