Constantly logging same messages: .../xorm/session_get.go:99:nocacheGet()

[bkodre]

• Gitea version (or commit ref):1.9
• Git version:git version 2.22.0.windows.1
• Operating system:Windows server 2012 R2
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
  • Not relevant
• Log gist:

Description

After upgrade from 1.8.3 to 1.9 gitea is constantly writing same messages to log file:

2019/08/12 16:04:51 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, owner_id, lower_name, name, description, website, default_branch, num_watches, num_stars, num_forks, num_issues, num_closed_issues, num_pulls, num_closed_pulls, num_milestones, num_closed_milestones, is_private, is_empty, is_archived, is_mirror, is_fork, fork_id, size, is_fsck_enabled, close_issues_via_commit_in_any_branch, topics, avatar, created_unix, updated_unix FROM repository WHERE owner_id=? AND lower_name=? LIMIT 1 []interface {}{2, "proj"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"org"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, owner_id, lower_name, name, description, website, default_branch, num_watches, num_stars, num_forks, num_issues, num_closed_issues, num_pulls, num_closed_pulls, num_milestones, num_closed_milestones, is_private, is_empty, is_archived, is_mirror, is_fork, fork_id, size, is_fsck_enabled, close_issues_via_commit_in_any_branch, topics, avatar, created_unix, updated_unix FROM repository WHERE owner_id=? AND lower_name=? LIMIT 1 []interface {}{2, "proj"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"org"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, owner_id, lower_name, name, description, website, default_branch, num_watches, num_stars, num_forks, num_issues, num_closed_issues, num_pulls, num_closed_pulls, num_milestones, num_closed_milestones, is_private, is_empty, is_archived, is_mirror, is_fork, fork_id, size, is_fsck_enabled, close_issues_via_commit_in_any_branch, topics, avatar, created_unix, updated_unix FROM repository WHERE owner_id=? AND lower_name=? LIMIT 1 []interface {}{2, "proj"}
2019/08/12 16:04:56 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT id, uid, name, token_hash, token_salt, token_last_eight, created_unix, updated_unix FROM access_token WHERE (token_last_eight = ?) []interface {}{"aaa"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"user"}
2019/08/12 16:04:56 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM notification WHERE (user_id = ?) AND (status = ?) []interface {}{5, 0x1}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"org"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, owner_id, lower_name, name, description, website, default_branch, num_watches, num_stars, num_forks, num_issues, num_closed_issues, num_pulls, num_closed_pulls, num_milestones, num_closed_milestones, is_private, is_empty, is_archived, is_mirror, is_fork, fork_id, size, is_fsck_enabled, close_issues_via_commit_in_any_branch, topics, avatar, created_unix, updated_unix FROM repository WHERE owner_id=? AND lower_name=? LIMIT 1 []interface {}{2, "proj"}
2019/08/12 16:04:56 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT id, uid, name, token_hash, token_salt, token_last_eight, created_unix, updated_unix FROM access_token WHERE (token_last_eight = ?) []interface {}{"aaa"}
2019/08/12 16:04:56 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"user"}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, uid, secret, scratch_salt, scratch_hash, last_used_passcode, created_unix, updated_unix FROM two_factor WHERE uid=? LIMIT 1 []interface {}{5}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE id=? LIMIT 1 []interface {}{2}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, repo_id, user_id, mode FROM collaboration WHERE repo_id=? AND user_id=? LIMIT 1 []interface {}{8, 5}
2019/08/12 16:04:57 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT id, repo_id, type, config, created_unix FROM repo_unit WHERE (repo_id = ?) []interface {}{8}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, user_id, repo_id, mode FROM access WHERE user_id=? AND repo_id=? LIMIT 1 []interface {}{5, 8}
2019/08/12 16:04:57 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT * FROM team INNER JOIN team_user ON team_user.team_id = team.id INNER JOIN team_repo ON team_repo.team_id = team.id WHERE (team.org_id = ?) AND (team_user.uid=?) AND (team_repo.repo_id=?) []interface {}{2, 5, 8}
2019/08/12 16:04:57 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT id, org_id, team_id, type FROM team_unit WHERE (team_id = ?) []interface {}{3}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, lower_name, name, full_name, email, keep_email_private, passwd, must_change_password, login_type, login_source, login_name, type, location, website, rands, salt, language, description, created_unix, updated_unix, last_login_unix, last_repo_visibility, max_repo_creation, is_active, is_admin, allow_git_hook, allow_import_local, allow_create_organization, prohibit_login, avatar, avatar_email, use_custom_avatar, num_followers, num_following, num_stars, num_repos, num_teams, num_members, visibility, diff_view_style, theme FROM user WHERE lower_name=? LIMIT 1 []interface {}{"org"}
2019/08/12 16:04:57 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT id, owner_id, lower_name, name, description, website, default_branch, num_watches, num_stars, num_forks, num_issues, num_closed_issues, num_pulls, num_closed_pulls, num_milestones, num_closed_milestones, is_private, is_empty, is_archived, is_mirror, is_fork, fork_id, size, is_fsck_enabled, close_issues_via_commit_in_any_branch, topics, avatar, created_unix, updated_unix FROM repository WHERE owner_id=? AND lower_name=? LIMIT 1 []interface {}{2, "proj"}

[lafriks]

Just disable sql logging in app.ini