server path, frequent log printing occurs causing the page to freeze. #5075

New issue

Closed

opened 2026-03-01 15:38:59 +03:00 by kerem · 1 comment

kerem commented

2026-03-01 15:38:59 +03:00

Owner

Originally created by @everhopingandwaiting on GitHub (Jun 26, 2025).
Original GitHub issue: https://github.com/0xJacky/nginx-ui/issues/1180

Describe the bug
When accessing the /#/dashboard/server path, frequent log printing occurs causing the page to freeze.

To Reproduce
Steps to reproduce the behavior:

Go to path : /#/dashboard/server
docker logs -f nginxui

Expected behavior
logs:

nginx-ui  | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99
nginx-ui  | [0.026ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc
nginx-ui  | [GIN] 2025/06/26 - 09:51:55 | 200 |     394.287µs |   192.168.5.211 | GET      "/api/environments?page=2736&enabled=true"
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45
nginx-ui  | [0.092ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67
nginx-ui  | [0.019ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56
nginx-ui  | [0.076ms] [rows:1] SELECT * FROM `users` WHERE id=1  AND `users`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99
nginx-ui  | [0.022ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc
nginx-ui  | [GIN] 2025/06/26 - 09:51:55 | 200 |     377.153µs |   192.168.5.211 | GET      "/api/environments?page=2737&enabled=true"
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45
nginx-ui  | [0.120ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67
nginx-ui  | [0.018ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56
nginx-ui  | [0.094ms] [rows:1] SELECT * FROM `users` WHERE id=1  AND `users`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99
nginx-ui  | [0.024ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc
nginx-ui  | [GIN] 2025/06/26 - 09:51:55 | 200 |      460.09µs |   192.168.5.211 | GET      "/api/environments?page=2738&enabled=true"
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45
nginx-ui  | [0.112ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67
nginx-ui  | [0.016ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56
nginx-ui  | [0.089ms] [rows:1] SELECT * FROM `users` WHERE id=1  AND `users`.`deleted_at` IS NULL LIMIT 1
nginx-ui  |
nginx-ui  | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99
nginx-ui  | [0.027ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc
nginx-ui  | [GIN] 2025/06/26 - 09:51:55 | 200 |     463.099µs |   192.168.5.211 | GET      "/api/environments?page=2739&enabled=true"

Screenshots

Info (please complete the following information):

Server OS: [debian 12]
Server Arch: [ x86, ]
Nginx UI Version: [2.1.8]
Your Browser: [Edge 版本 137.0.3296.93 (正式版本) (64 位)]

Additional context
Add any other context about the problem here.

Originally created by @everhopingandwaiting on GitHub (Jun 26, 2025). Original GitHub issue: https://github.com/0xJacky/nginx-ui/issues/1180 **Describe the bug** When accessing the /#/dashboard/server path, frequent log printing occurs causing the page to freeze. **To Reproduce** Steps to reproduce the behavior: 1. Go to path : /#/dashboard/server 2. `docker logs -f nginxui` **Expected behavior** logs: ```logs nginx-ui | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99 nginx-ui | [0.026ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc nginx-ui | [GIN] 2025/06/26 - 09:51:55 | 200 | 394.287µs | 192.168.5.211 | GET "/api/environments?page=2736&enabled=true" nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45 nginx-ui | [0.092ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67 nginx-ui | [0.019ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56 nginx-ui | [0.076ms] [rows:1] SELECT * FROM `users` WHERE id=1 AND `users`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99 nginx-ui | [0.022ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc nginx-ui | [GIN] 2025/06/26 - 09:51:55 | 200 | 377.153µs | 192.168.5.211 | GET "/api/environments?page=2737&enabled=true" nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45 nginx-ui | [0.120ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67 nginx-ui | [0.018ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56 nginx-ui | [0.094ms] [rows:1] SELECT * FROM `users` WHERE id=1 AND `users`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99 nginx-ui | [0.024ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc nginx-ui | [GIN] 2025/06/26 - 09:51:55 | 200 | 460.09µs | 192.168.5.211 | GET "/api/environments?page=2738&enabled=true" nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:45 nginx-ui | [0.112ms] [rows:1] SELECT * FROM `auth_tokens` WHERE `auth_tokens`.`token` = ".eyJuYW1lIjoiYWRtaW4iLCJ1c2VyX2lkIjoxLCJpc3MiOiJOZ2lueCBVSSIsInN1YiI6ImFkbWluIiwiZXhwIjoxNzUwOTQ1NDM4LCJuYmYiOjE3NTA4NTkwMzgsImlhdCI6MTc1MDg1OTAzOCwianRpIjoiMSJ9.hJS0pWsBCuTrPHn28hvjRTxAiy_yfifKxH-WZj2Idic" ORDER BY `auth_tokens`.`user_id` LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/model/user.go:67 nginx-ui | [0.016ms] [rows:0] SELECT * FROM `passkeys` WHERE `user_id` = 1 AND `passkeys`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/work/nginx-ui/nginx-ui/internal/user/user.go:56 nginx-ui | [0.089ms] [rows:1] SELECT * FROM `users` WHERE id=1 AND `users`.`deleted_at` IS NULL LIMIT 1 nginx-ui | nginx-ui | 2025/06/26 09:51:55 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.22.1/list.go:99 nginx-ui | [0.027ms] [rows:0] SELECT * FROM `environments` WHERE enabled = 1 AND `environments`.`deleted_at` IS NULL ORDER BY id desc nginx-ui | [GIN] 2025/06/26 - 09:51:55 | 200 | 463.099µs | 192.168.5.211 | GET "/api/environments?page=2739&enabled=true" ``` **Screenshots** ![Image](https://github.com/user-attachments/assets/e1762fe8-417c-48bc-ab26-3614e877fe7a) **Info (please complete the following information):** - Server OS: [debian 12] - Server Arch: [ x86, ] - Nginx UI Version: [2.1.8] - Your Browser: [Edge 版本 137.0.3296.93 (正式版本) (64 位)] **Additional context** Add any other context about the problem here.

kerem

2026-03-01 15:38:59 +03:00

closed this issue
added the
bug
label

kerem commented

2026-03-01 15:39:00 +03:00

Author

Owner

@0xJacky commented on GitHub (Jun 26, 2025):

Thanks you for your report, this issue has been fixed in b486cc6.

@0xJacky commented on GitHub (Jun 26, 2025): Thanks you for your report, this issue has been fixed in [b486cc6](https://github.com/0xJacky/nginx-ui/commit/b486cc6c2060158d43eed74bdfb7c7b1daa824c2).