go-gitea / gitea

Git with a cup of tea! Painless self-hosted all-in-one software development service, including Git hosting, code review, team collaboration, package registry and CI/CD
https://gitea.com
MIT License
45.07k stars 5.49k forks source link

SQL log flood #13189

Closed zig closed 4 years ago

zig commented 4 years ago

Description

Using the gitea:latest docker image, there is a log appearing every 10 seconds, is there a way to disable it ?

oct. 17 17:26:05 xxx-server-1 docker-compose[27711]: server_1  | 2020/10/17 17:26:05 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1602948353 1602948363 1] - 1.297709ms

Screenshots

lunny commented 4 years ago

You cannot disable only this log. When anyone stay on the notification page, it will display.

zig commented 4 years ago

@lunny thanks for your answer. Is there a way to disable all SQL logs ?

zig commented 4 years ago

OK I think I found in the doc : https://docs.gitea.io/en-us/logging-configuration/#:~:text=It%20is%20enabled%20by%20default,log%20SQL%20events%20by%20default.

Thanks for your attention, I guess I can close this bug :)