Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Slow Azimutt.app after docker compose install #289

Open
jmrenouard opened this issue Apr 12, 2024 · 1 comment
Open

Slow Azimutt.app after docker compose install #289

jmrenouard opened this issue Apr 12, 2024 · 1 comment

Comments

@jmrenouard
Copy link

Hi,

Working on a big 19 vCPU (I7 vPRO) and 64 Go RAM server with recent and decent docker version (24)

docker.compose install works perfectly (without authentication)

we can see in logs (docker.compose logs) that most of screen took more than 5 to 20 seconds to be displayed

Is there anything I have miss ?

` jrenouard   main  ~/GIT_REPOS/azimutt  docker-compose logs
azimutt-db |
azimutt-db |
azimutt-db | PostgreSQL Database directory appears to contain a database; Skipping initialization
azimutt-db |
azimutt-db |
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: starting PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: listening on IPv6 address "::", port 5432
azimutt-db | 2024-04-12 13:56:06.652 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
azimutt-db | 2024-04-12 13:56:06.654 UTC [29] LOG: database system was shut down at 2024-04-12 13:55:56 UTC
azimutt-db | 2024-04-12 13:56:06.657 UTC [1] LOG: database system is ready to accept connections
azimutt-backend | Setup Local file storage
azimutt-backend | Setup Local email provider
azimutt-backend | Setup Password auth
azimutt-backend | 13:56:07.105 [info] Migrations already up
azimutt-backend | Setup Local file storage
azimutt-backend | Setup Local email provider
azimutt-backend | Setup Password auth
azimutt-backend | 13:56:07.786 [info] Running AzimuttWeb.Endpoint with cowboy 2.10.0 at :::4000 (http)
azimutt-backend | 13:56:07.787 [info] Access AzimuttWeb.Endpoint at https://localhost
azimutt-backend | 13:56:20.404 request_id=F8WM7HAS8hIezdcAABMQ [info] GET /
azimutt-backend | 13:56:20.406 request_id=F8WM7HAS8hIezdcAABMQ [info] Sent 302 in 1ms
azimutt-backend | 13:56:20.409 request_id=F8WM7HBcj0-0oaAAABNQ [info] GET /login
azimutt-backend | 13:56:20.410 request_id=F8WM7HBcj0-0oaAAABNQ [info] Sent 200 in 426µs
azimutt-backend | 13:56:24.501 request_id=F8WM7WQ6k3MyRaEAABOQ [info] GET /register
azimutt-backend | 13:56:27.940 request_id=F8WM7jFAiv7bN4wAABPQ [info] GET /register
azimutt-backend | 13:56:35.946 request_id=F8WM7jFAiv7bN4wAABPQ [info] Sent 200 in 8006ms
azimutt-backend | 13:56:46.919 request_id=F8WM8px155A4UEAAABQQ [info] POST /register
azimutt-backend | 13:56:54.931 request_id=F8WM8px155A4UEAAABQQ [info] Sent 200 in 8011ms
azimutt-backend | 13:57:07.099 request_id=F8WM909HAgkgORsAABUQ [info] POST /register
azimutt-backend | 13:57:31.278 request_id=F8WM909HAgkgORsAABUQ [info] Sent 302 in 24179ms
azimutt-backend | 13:57:31.281 request_id=F8WM_PCuQK_7M0QAABWQ [info] GET /home
azimutt-backend | 13:57:39.291 request_id=F8WM_PCuQK_7M0QAABWQ [info] Sent 302 in 8009ms
azimutt-backend | 13:57:39.300 request_id=F8WM_s6j6cWV4YoAABYQ [info] GET /onboarding/welcome
azimutt-backend | 13:57:55.329 request_id=F8WM_s6j6cWV4YoAABYQ [info] Sent 200 in 16029ms
azimutt-backend | 13:58:01.409 request_id=F8WNA_Rs5YLGPuUAABaQ [info] POST /onboarding/welcome
azimutt-backend | 13:58:17.554 request_id=F8WNA_Rs5YLGPuUAABaQ [info] Sent 302 in 16144ms
azimutt-backend | 13:58:17.562 request_id=F8WNB7cxtQjELt0AABcQ [info] GET /onboarding/explore-or-design
azimutt-backend | 13:58:33.589 request_id=F8WNB7cxtQjELt0AABcQ [info] Sent 200 in 16027ms
azimutt-backend | 13:58:36.803 request_id=F8WNDDIT1An4L1kAABdQ [info] POST /onboarding/explore-or-design
azimutt-backend | 13:58:39.255 request_id=F8WNDMQw9h3-3GIAAAAM [info] POST /onboarding/explore-or-design
azimutt-backend | 13:58:55.271 request_id=F8WNDMQw9h3-3GIAAAAM [info] Sent 302 in 16016ms
azimutt-backend | 13:58:55.276 request_id=F8WNEH8prrFrxfAAABeQ [info] GET /onboarding/solo-or-team
azimutt-backend | 13:59:11.291 request_id=F8WNEH8prrFrxfAAABeQ [info] Sent 200 in 16015ms
azimutt-backend | 13:59:13.204 request_id=F8WNFKu8e7UPx48AABfQ [info] POST /onboarding/solo-or-team
azimutt-backend | 13:59:15.086 request_id=F8WNFRvmkCGreK4AABgQ [info] POST /onboarding/solo-or-team
azimutt-backend | 13:59:31.112 request_id=F8WNFRvmkCGreK4AABgQ [info] Sent 302 in 16026ms
azimutt-backend | 13:59:31.120 request_id=F8WNGNebI844S80AABhQ [info] GET /onboarding/role
jrenouard   main  ~/GIT_REPOS/azimutt  docker-compose logs -f
azimutt-backend | Setup Local file storage
azimutt-backend | Setup Local email provider
azimutt-backend | Setup Password auth
azimutt-db |
azimutt-db |
azimutt-db | PostgreSQL Database directory appears to contain a database; Skipping initialization
azimutt-db |
azimutt-db |
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: starting PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
azimutt-db | 2024-04-12 13:56:06.651 UTC [1] LOG: listening on IPv6 address "::", port 5432
azimutt-db | 2024-04-12 13:56:06.652 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
azimutt-db | 2024-04-12 13:56:06.654 UTC [29] LOG: database system was shut down at 2024-04-12 13:55:56 UTC
azimutt-db | 2024-04-12 13:56:06.657 UTC [1] LOG: database system is ready to accept connections
azimutt-backend | 13:56:07.105 [info] Migrations already up
azimutt-backend | Setup Local file storage
azimutt-backend | Setup Local email provider
azimutt-backend | Setup Password auth
azimutt-backend | 13:56:07.786 [info] Running AzimuttWeb.Endpoint with cowboy 2.10.0 at :::4000 (http)
azimutt-backend | 13:56:07.787 [info] Access AzimuttWeb.Endpoint at https://localhost
azimutt-backend | 13:56:20.404 request_id=F8WM7HAS8hIezdcAABMQ [info] GET /
azimutt-backend | 13:56:20.406 request_id=F8WM7HAS8hIezdcAABMQ [info] Sent 302 in 1ms
azimutt-backend | 13:56:20.409 request_id=F8WM7HBcj0-0oaAAABNQ [info] GET /login
azimutt-backend | 13:56:20.410 request_id=F8WM7HBcj0-0oaAAABNQ [info] Sent 200 in 426µs
azimutt-backend | 13:56:24.501 request_id=F8WM7WQ6k3MyRaEAABOQ [info] GET /register
azimutt-backend | 13:56:27.940 request_id=F8WM7jFAiv7bN4wAABPQ [info] GET /register
azimutt-backend | 13:56:35.946 request_id=F8WM7jFAiv7bN4wAABPQ [info] Sent 200 in 8006ms
azimutt-backend | 13:56:46.919 request_id=F8WM8px155A4UEAAABQQ [info] POST /register
azimutt-backend | 13:56:54.931 request_id=F8WM8px155A4UEAAABQQ [info] Sent 200 in 8011ms
azimutt-backend | 13:57:07.099 request_id=F8WM909HAgkgORsAABUQ [info] POST /register
azimutt-backend | 13:57:31.278 request_id=F8WM909HAgkgORsAABUQ [info] Sent 302 in 24179ms
azimutt-backend | 13:57:31.281 request_id=F8WM_PCuQK_7M0QAABWQ [info] GET /home
azimutt-backend | 13:57:39.291 request_id=F8WM_PCuQK_7M0QAABWQ [info] Sent 302 in 8009ms
azimutt-backend | 13:57:39.300 request_id=F8WM_s6j6cWV4YoAABYQ [info] GET /onboarding/welcome
azimutt-backend | 13:57:55.329 request_id=F8WM_s6j6cWV4YoAABYQ [info] Sent 200 in 16029ms
azimutt-backend | 13:58:01.409 request_id=F8WNA_Rs5YLGPuUAABaQ [info] POST /onboarding/welcome
azimutt-backend | 13:58:17.554 request_id=F8WNA_Rs5YLGPuUAABaQ [info] Sent 302 in 16144ms
azimutt-backend | 13:58:17.562 request_id=F8WNB7cxtQjELt0AABcQ [info] GET /onboarding/explore-or-design
azimutt-backend | 13:58:33.589 request_id=F8WNB7cxtQjELt0AABcQ [info] Sent 200 in 16027ms
azimutt-backend | 13:58:36.803 request_id=F8WNDDIT1An4L1kAABdQ [info] POST /onboarding/explore-or-design
azimutt-backend | 13:58:39.255 request_id=F8WNDMQw9h3-3GIAAAAM [info] POST /onboarding/explore-or-design
azimutt-backend | 13:58:55.271 request_id=F8WNDMQw9h3-3GIAAAAM [info] Sent 302 in 16016ms
azimutt-backend | 13:58:55.276 request_id=F8WNEH8prrFrxfAAABeQ [info] GET /onboarding/solo-or-team
azimutt-backend | 13:59:11.291 request_id=F8WNEH8prrFrxfAAABeQ [info] Sent 200 in 16015ms
azimutt-backend | 13:59:13.204 request_id=F8WNFKu8e7UPx48AABfQ [info] POST /onboarding/solo-or-team
azimutt-backend | 13:59:15.086 request_id=F8WNFRvmkCGreK4AABgQ [info] POST /onboarding/solo-or-team
azimutt-backend | 13:59:31.112 request_id=F8WNFRvmkCGreK4AABgQ [info] Sent 302 in 16026ms
azimutt-backend | 13:59:31.120 request_id=F8WNGNebI844S80AABhQ [info] GET /onboarding/role
azimutt-backend | 13:59:47.269 request_id=F8WNGNebI844S80AABhQ [info] Sent 200 in 16149ms
azimutt-backend | 13:59:49.423 request_id=F8WNHRqNUxXfV9oAABiQ [info] POST /onboarding/role
azimutt-backend | 14:00:05.445 request_id=F8WNHRqNUxXfV9oAABiQ [info] Sent 302 in 16021ms
azimutt-backend | 14:00:05.447 request_id=F8WNINWt3DUjbn4AABjQ [info] GET /onboarding/about-you
azimutt-backend | 14:00:13.336 request_id=F8WNIqvee3O0ZHwAABkQ [info] POST /onboarding/role
azimutt-backend | 14:00:17.773 request_id=F8WNI7ReqhFgYtwAABlQ [info] POST /onboarding/role
azimutt-backend | 14:00:33.803 request_id=F8WNI7ReqhFgYtwAABlQ [info] Sent 302 in 16029ms
azimutt-backend | 14:00:33.806 request_id=F8WNJ2_6DoPSqWAAABmQ [info] GET /onboarding/about-you
azimutt-backend | 14:00:49.926 request_id=F8WNJ2_6DoPSqWAAABmQ [info] Sent 200 in 16120ms
azimutt-backend | 14:00:53.500 request_id=F8WNLAXXu5IJAngAABnQ [info] POST /onboarding/about-you
azimutt-backend | 14:01:01.579 request_id=F8WNLedhPjPSQkMAAACP [info] POST /onboarding/about-you
azimutt-db | 2024-04-12 14:01:06.754 UTC [27] LOG: checkpoint starting: time
azimutt-db | 2024-04-12 14:01:10.280 UTC [27] LOG: checkpoint complete: wrote 38 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.513 s, sync=0.007 s, total=3.527 s; sync files=28, longest=0.004 s, average=0.001 s; distance=37 kB, estimate=37 kB; lsn=0/1AA7A48, redo lsn=0/1AA5020
azimutt-backend | 14:01:17.598 request_id=F8WNLedhPjPSQkMAAACP [info] Sent 302 in 16019ms
azimutt-backend | 14:01:17.602 request_id=F8WNMaJtFiL_568AABoQ [info] GET /onboarding/about-your-company
azimutt-backend | 14:01:33.621 request_id=F8WNMaJtFiL_568AABoQ [info] Sent 200 in 16018ms
azimutt-backend | 14:01:52.187 request_id=F8WNOa_benjBVSwAABpQ [info] POST /onboarding/about-your-company
azimutt-backend | 14:02:08.203 request_id=F8WNOa_benjBVSwAABpQ [info] Sent 200 in 16016ms
azimutt-backend | 14:02:16.617 request_id=F8WNP2AEpTINeUoAABqQ [info] POST /onboarding/about-your-company
^Z
[1]+ Stoppé docker-compose logs -f
jrenouard   main  ~/GIT_REPOS/azimutt  148  bg
[1]+ docker-compose logs -f &
azimutt-backend | 14:02:32.634 request_id=F8WNP2AEpTINeUoAABqQ [info] Sent 302 in 16017ms
azimutt-backend | 14:02:32.640 request_id=F8WNQxsNiarzNo0AABrQ [info] GET /onboarding/plan
jrenouard   main  ~/GIT_REPOS/azimutt  docker
docker docker-compose docker.compose docker.help docker.moni-tools.aws docker-slim
jrenouard   main  ~/GIT_REPOS/azimutt  docker.compose top
azimutt-backend
UID PID PPID C STIME TTY TIME CMD
nobody 277939 277914 0 15:56 ? 00:00:00 sh -c /app/bin/migrate && /app/bin/server
nobody 278121 277939 1 15:56 ? 00:00:07 /app/erts-13.1.4/bin/beam.smp -- -root /app -bindir /app/erts-13.1.4/bin -progname erl -- -home /nonexistent -- -noshell -s elixir start_cli -mode embedded -setcookie BK4ZRO2GHAFILXHBJ4NHTUCOV5HNTRFLYJAYKLW6QTAIZ7R5HJEA==== -sname azimutt -config /app/releases/2.0.1712926513/sys -boot /app/releases/2.0.1712926513/start -boot_var RELEASE_LIB /app/lib -- -extra --no-halt
nobody 278154 277939 0 15:56 ? 00:00:00 /app/erts-13.1.4/bin/epmd -daemon
nobody 278158 278121 0 15:56 ? 00:00:00 erl_child_setup 524288
nobody 278219 278158 0 15:56 ? 00:00:00 /app/erts-13.1.4/bin/inet_gethost 4
nobody 278220 278219 0 15:56 ? 00:00:00 /app/erts-13.1.4/bin/inet_gethost 4

azimutt-db
UID PID PPID C STIME TTY TIME CMD
mainten+ 277818 277797 0 15:56 ? 00:00:00 postgres
mainten+ 277919 277818 0 15:56 ? 00:00:00 postgres: checkpointer
mainten+ 277920 277818 0 15:56 ? 00:00:00 postgres: background writer
mainten+ 277932 277818 0 15:56 ? 00:00:00 postgres: walwriter
mainten+ 277933 277818 0 15:56 ? 00:00:00 postgres: autovacuum launcher
mainten+ 277934 277818 0 15:56 ? 00:00:00 postgres: logical replication launcher
mainten+ 278221 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50924) idle
mainten+ 278222 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50934) idle
mainten+ 278223 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50944) idle
mainten+ 278224 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50954) idle
mainten+ 278225 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50964) idle
mainten+ 278226 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50966) idle
mainten+ 278227 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50970) idle
mainten+ 278228 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50982) idle
mainten+ 278229 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50980) idle
mainten+ 278230 277818 0 15:56 ? 00:00:00 postgres: postgres azimutt_dev 172.21.0.3(50996) idle

jrenouard   main  ~/GIT_REPOS/azimutt  azimutt-backend | 14:02:48.654 request_id=F8WNQxsNiarzNo0AABrQ [info] Sent 200 in 16013ms
azimutt-backend | 14:02:54.496 request_id=F8WNSDG_feBFwVUAABsQ [info] POST /onboarding/plan
azimutt-backend | 14:03:02.511 request_id=F8WNSDG_feBFwVUAABsQ [info] Sent 302 in 8015ms
azimutt-backend | 14:03:02.517 request_id=F8WNSg_T7FGJg_0AABtQ [info] GET /onboarding/discovered-azimutt
azimutt-backend | 14:03:18.536 request_id=F8WNSg_T7FGJg_0AABtQ [info] Sent 200 in 16019ms
azimutt-backend | 14:03:25.173 request_id=F8WNT1ZJ7HrxDwEAABuQ [info] POST /onboarding/discovered-azimutt
azimutt-backend | 14:03:41.198 request_id=F8WNT1ZJ7HrxDwEAABuQ [info] Sent 302 in 16024ms
azimutt-backend | 14:03:41.206 request_id=F8WNUxHlLAZr8YEAABvQ [info] GET /onboarding/previous-solutions
azimutt-backend | 14:03:57.221 request_id=F8WNUxHlLAZr8YEAABvQ [info] Sent 200 in 16014ms
azimutt-backend | 14:04:01.655 request_id=F8WNV9TDgJVpC8QAABwQ [info] POST /onboarding/previous-solutions
`
@jmrenouard jmrenouard changed the title Slow docker compose install Slow Azimutt.app after docker compose install Apr 12, 2024
@loicknuchel
Copy link
Contributor

Quite strange...
Sometimes I got a slow Elixir every after working a lot but it when I restart it's fine and never had this problem in production.
But I don't use the docker-compose 😅
My guess is it's from the Elixir/Phoenix server but not really sure. Will have to look at it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jmrenouard @loicknuchel