Organization list repositories from others organizations #3962

Closed
opened 2025-11-02 05:31:52 -06:00 by GiteaMirror · 29 comments
Owner

Originally created by @camlafit on GitHub (Sep 16, 2019).

  • Gitea version (or commit ref): 1.9.3
  • Git version:
  • Operating system: Debian
  • 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:
    • If needed I can provide any log

Description

Hello

On our gitea instance one organization list all repositories without take in consideration organization state.

On follows screenshot, first repository is related to SPIP organization, two others are related to plugin organization.
All repositories are managed by api (migrate from local path)

Screenshots

Capture d’écran de 2019-09-16 09-30-52

Originally created by @camlafit on GitHub (Sep 16, 2019). - Gitea version (or commit ref): 1.9.3 - Git version: - Operating system: Debian - Database (use `[x]`): - [ ] PostgreSQL - [x] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: - If needed I can provide any log ## Description Hello On our [gitea instance](https://git.spip.net/SPIP) one organization list all repositories without take in consideration organization state. On follows screenshot, first repository is related to SPIP organization, two others are related to plugin organization. All repositories are managed by api (migrate from local path) ## Screenshots ![Capture d’écran de 2019-09-16 09-30-52](https://user-images.githubusercontent.com/209915/64940802-41dfe700-d865-11e9-99bf-b29072bfbcc8.png)
GiteaMirror added the issue/staletype/bug labels 2025-11-02 05:31:52 -06:00
Author
Owner

@typeless commented on GitHub (Sep 16, 2019):

Have you upgraded the instance from an older version of Gitea? If so, which version was it?

@typeless commented on GitHub (Sep 16, 2019): Have you upgraded the instance from an older version of Gitea? If so, which version was it?
Author
Owner

@camlafit commented on GitHub (Sep 16, 2019):

Hello

First version should be 1.6.x , since I update when new release is provided. (local build)
I can't said when this behavior was coming.

@camlafit commented on GitHub (Sep 16, 2019): Hello First version should be 1.6.x , since I update when new release is provided. (local build) I can't said when this behavior was coming.
Author
Owner

@typeless commented on GitHub (Sep 16, 2019):

I am not sure about what the root cause is. It is likely due to some missing database migration steps if I had to guess.

@typeless commented on GitHub (Sep 16, 2019): I am not sure about what the root cause is. It is likely due to some missing database migration steps if I had to guess.
Author
Owner

@camlafit commented on GitHub (Sep 16, 2019):

Hello

I can check and correct manually database if required.

@camlafit commented on GitHub (Sep 16, 2019): Hello I can check and correct manually database if required.
Author
Owner

@typeless commented on GitHub (Sep 16, 2019):

https://github.com/go-gitea/gitea/blob/master/routers/user/home.go#L501-L513
https://github.com/go-gitea/gitea/blob/master/models/repo_list.go#L170
The code is more complicated than I thought. I cannot immediately identify which columns are the most suspicious. But you might get some clues.

@typeless commented on GitHub (Sep 16, 2019): https://github.com/go-gitea/gitea/blob/master/routers/user/home.go#L501-L513 https://github.com/go-gitea/gitea/blob/master/models/repo_list.go#L170 The code is more complicated than I thought. I cannot immediately identify which columns are the most suspicious. But you might get some clues.
Author
Owner

@typeless commented on GitHub (Sep 16, 2019):

By the way, there is a shortcut that could be helpful

  1. in your gitea.log or xorm.log, look for the query when you GET the endpoint of the webpage.
  2. try to replicate the query manually and see what would happen.

Step 1 is probably enough to shed some light on the root cause.

@typeless commented on GitHub (Sep 16, 2019): By the way, there is a shortcut that could be helpful 1. in your `gitea.log` or `xorm.log`, look for the query when you `GET` the endpoint of the webpage. 2. try to replicate the query manually and see what would happen. Step 1 is probably enough to shed some light on the root cause.
Author
Owner

@lunny commented on GitHub (Sep 16, 2019):

I think maybe you can paste the xorm.log when you refresh the page.

@lunny commented on GitHub (Sep 16, 2019): I think maybe you can paste the xorm.log when you refresh the page.
Author
Owner

@camlafit commented on GitHub (Sep 17, 2019):

Hello

I've tried to get data but looks complicated. In xorm.log nothing is not updated.
In gitea.log It's too verbose. I can't identify any relevant information.

@camlafit commented on GitHub (Sep 17, 2019): Hello I've tried to get data but looks complicated. In _xorm.log_ nothing is not updated. In _gitea.log_ It's too verbose. I can't identify any relevant information.
Author
Owner

@camlafit commented on GitHub (Sep 17, 2019):

Hello

Could be some surnumerous data, but all queries should be presents related to GET webpage :

2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{1}
2019/09/17 20:09:04 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) []interface {}{1, 0x1}
2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `lower_name`=? LIMIT 1 []interface {}{"spip"}
2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `lower_name`=? LIMIT 1 []interface {}{"spip"}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `org_id`, `lower_name`, `name`, `description`, `authorize`, `num_repos`, `num_members` FROM `team` WHERE (org_id=?) ORDER BY CA
SE WHEN name LIKE 'Owners' THEN '' ELSE name END []interface {}{2}
2019/09/17 20:09:04 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (((repository.id IN (SELECT repo_id FROM `access` WHERE access.user_id = ?)) OR id IN (SE
LECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?)) AND owner_id<>?)) []interface {}{2, 2, 2, 2}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_iss
ues`, `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=? OR (((repository.id IN (SELECT repo_id FROM `access` WHERE access.user_id = ?)) OR id IN (
SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?)) AND owner_id<>?)) ORDER BY updated_unix DESC LIMIT 15 []interface {}{2, 2, 2, 
2}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `uid`, `org_id`, `is_public` FROM `org_user` WHERE (org_id=?) []interface {}{2}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [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` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY `name` ASC []interface {}{1, 28, 29, 39, 40, 31, 71, 66, 
67, 35, 36, 33, 481, 96, 45, 161, 6, 8, 413, 41, 167, 129, 32, 30, 215, 178, 259, 86, 298, 60, 12, 77, 402}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{429}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{683}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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_m
embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{682}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{681}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{680}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{679}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{678}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{677}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{676}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{675}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{674}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{673}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{672}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{671}
2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3}
2019/09/17 20:09:04 .../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 {}{3}
2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{670}
2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{413, 2, true}
2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{39, 2, true}
2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{30, 2, true}
2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{96, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{41, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{129, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{8, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{71, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{86, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{259, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{215, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{77, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{167, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{40, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{28, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{60, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{1, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{298, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{33, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{481, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{31, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{6, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{67, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{161, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{402, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{32, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{178, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{36, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{35, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{29, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{45, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{12, 2, true}
2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{66, 2, true}
2019/09/17 20:09:06 .../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 {}{1}
2019/09/17 20:09:06 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) []interface {}{1, 0x1}

@camlafit commented on GitHub (Sep 17, 2019): Hello Could be some surnumerous data, but all queries should be presents related to GET webpage : ``` 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{1} 2019/09/17 20:09:04 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) []interface {}{1, 0x1} 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `lower_name`=? LIMIT 1 []interface {}{"spip"} 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `lower_name`=? LIMIT 1 []interface {}{"spip"} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `org_id`, `lower_name`, `name`, `description`, `authorize`, `num_repos`, `num_members` FROM `team` WHERE (org_id=?) ORDER BY CA SE WHEN name LIKE 'Owners' THEN '' ELSE name END []interface {}{2} 2019/09/17 20:09:04 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (((repository.id IN (SELECT repo_id FROM `access` WHERE access.user_id = ?)) OR id IN (SE LECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?)) AND owner_id<>?)) []interface {}{2, 2, 2, 2} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_iss ues`, `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=? OR (((repository.id IN (SELECT repo_id FROM `access` WHERE access.user_id = ?)) OR id IN ( SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?)) AND owner_id<>?)) ORDER BY updated_unix DESC LIMIT 15 []interface {}{2, 2, 2, 2} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `uid`, `org_id`, `is_public` FROM `org_user` WHERE (org_id=?) []interface {}{2} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [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` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY `name` ASC []interface {}{1, 28, 29, 39, 40, 31, 71, 66, 67, 35, 36, 33, 481, 96, 45, 161, 6, 8, 413, 41, 167, 129, 32, 30, 215, 178, 259, 86, 298, 60, 12, 77, 402} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2} 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{429} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{683} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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_m embers`, `visibility`, `diff_view_style`, `theme` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{682} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{681} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{680} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{679} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{678} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{677} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{676} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{675} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{674} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{673} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{672} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{671} 2019/09/17 20:09:04 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{3} 2019/09/17 20:09:04 .../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 {}{3} 2019/09/17 20:09:04 ...xorm/session_find.go:199:noCacheFind() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) []interface {}{670} 2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{413, 2, true} 2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{39, 2, true} 2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{30, 2, true} 2019/09/17 20:09:04 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{96, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{41, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{129, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{8, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{71, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{86, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{259, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{215, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{77, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{167, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{40, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{28, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{60, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{1, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{298, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{33, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{481, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{31, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{6, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{67, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{161, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{402, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{32, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{178, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{36, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{35, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{29, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{45, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{12, 2, true} 2019/09/17 20:09:05 ...orm/session_exist.go:89:Exist() [I] [SQL] SELECT * FROM `org_user` WHERE (uid=?) AND (org_id=?) AND (is_public=?) LIMIT 1 []interface {}{66, 2, true} 2019/09/17 20:09:06 .../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 {}{1} 2019/09/17 20:09:06 .../xorm/session_raw.go:87:queryRow() [I] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) []interface {}{1, 0x1} ````
Author
Owner

@lunny commented on GitHub (Sep 18, 2019):

When I'm a guest, I cannot reproduce that.
image

@lunny commented on GitHub (Sep 18, 2019): When I'm a guest, I cannot reproduce that. ![image](https://user-images.githubusercontent.com/81045/65096766-b5fec400-d9f8-11e9-96f0-84529a2ea975.png)
Author
Owner

@lunny commented on GitHub (Sep 18, 2019):

But when I registry and login, it will display that repositories.

@lunny commented on GitHub (Sep 18, 2019): But when I registry and login, it will display that repositories.
Author
Owner

@camlafit commented on GitHub (Sep 19, 2019):

Hello

If I can do anything more, ask :)

@camlafit commented on GitHub (Sep 19, 2019): Hello If I can do anything more, ask :)
Author
Owner

@camlafit commented on GitHub (Sep 23, 2019):

Hello

Could be have any workaround ? I can launch any sql query to restore to a normal behavior

@camlafit commented on GitHub (Sep 23, 2019): Hello Could be have any workaround ? I can launch any sql query to restore to a normal behavior
Author
Owner

@typeless commented on GitHub (Sep 24, 2019):

@camlafit
I don't find the problem.
image

And maybe you should provide the URL that can reproduce it.

@typeless commented on GitHub (Sep 24, 2019): @camlafit I don't find the problem. ![image](https://user-images.githubusercontent.com/2606021/65475197-33bb4780-deb1-11e9-8eee-9fe0e0c5d139.png) And maybe you should provide the URL that can reproduce it.
Author
Owner

@camlafit commented on GitHub (Sep 24, 2019):

Hello

@typeless problem occurs when you're logged. Confirmed by @lunny at https://github.com/go-gitea/gitea/issues/8195#issuecomment-532485587

You can create an account without any problem.

@camlafit commented on GitHub (Sep 24, 2019): Hello @typeless problem occurs when you're logged. Confirmed by @lunny at https://github.com/go-gitea/gitea/issues/8195#issuecomment-532485587 You can create an account without any problem.
Author
Owner

@typeless commented on GitHub (Sep 24, 2019):

@camlafit I am not sure, but maybe you can try regenerating the indexes of the database.

@typeless commented on GitHub (Sep 24, 2019): @camlafit I am not sure, but maybe you can try regenerating the indexes of the database.
Author
Owner

@camlafit commented on GitHub (Sep 24, 2019):

Hello

I've updated my indexer config as this (complete block):

[indexer]
ISSUE_INDEXER_TYPE = bleve
ISSUE_INDEXER_PATH = [fullpath gitea spip]/data/indexers/issues.bleve

Previously was db.

I've restarted server indexer_path is populated but any change on this orga when I'm connected.

@camlafit commented on GitHub (Sep 24, 2019): Hello I've updated my indexer config as this (complete block): ``` [indexer] ISSUE_INDEXER_TYPE = bleve ISSUE_INDEXER_PATH = [fullpath gitea spip]/data/indexers/issues.bleve ``` Previously was db. I've restarted server indexer_path is populated but any change on this orga when I'm connected.
Author
Owner

@typeless commented on GitHub (Sep 24, 2019):

@camlafit That is not what I was talking about. What I mean is the indexes such as https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html.

@typeless commented on GitHub (Sep 24, 2019): @camlafit That is not what I was talking about. What I mean is the indexes such as https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html.
Author
Owner

@lunny commented on GitHub (Sep 24, 2019):

This should not be related with indexer.

@lunny commented on GitHub (Sep 24, 2019): This should not be related with indexer.
Author
Owner

@camlafit commented on GitHub (Sep 24, 2019):

Hello

Was my bad, i've misread :/
I've done an analyze on database, any change.

@camlafit commented on GitHub (Sep 24, 2019): Hello Was my bad, i've misread :/ I've done an analyze on database, any change.
Author
Owner

@lunny commented on GitHub (Sep 30, 2019):

@camlafit I think we haven't found the reason.

@lunny commented on GitHub (Sep 30, 2019): @camlafit I think we haven't found the reason.
Author
Owner

@camlafit commented on GitHub (Sep 30, 2019):

Hello

If I purge some data directly on database, I can redo team without problem. Default team is done by api. And admin team is with few members.

@camlafit commented on GitHub (Sep 30, 2019): Hello If I purge some data directly on database, I can redo team without problem. Default team is done by api. And admin team is with few members.
Author
Owner

@typeless commented on GitHub (Oct 1, 2019):

@camlafit Did you try dropping the indexes of the database?

@typeless commented on GitHub (Oct 1, 2019): @camlafit Did you try dropping the indexes of the database?
Author
Owner

@stale[bot] commented on GitHub (Nov 30, 2019):

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.

@stale[bot] commented on GitHub (Nov 30, 2019): This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.
Author
Owner

@lafriks commented on GitHub (Dec 2, 2019):

It should not be related to indexes problem must be somewhere in code or data

@lafriks commented on GitHub (Dec 2, 2019): It should not be related to indexes problem must be somewhere in code or data
Author
Owner

@camlafit commented on GitHub (Jan 11, 2020):

Hello

I've updated to 1.10.2 and problem is always present. I can do any complementary test.

Thanks

@camlafit commented on GitHub (Jan 11, 2020): Hello I've updated to 1.10.2 and problem is always present. I can do any complementary test. Thanks
Author
Owner

@camlafit commented on GitHub (Jan 19, 2020):

Hello

We've found a workaround :
Start use case, when logged, from OrgaA listing we see OrgaB repositories.
Workaround :

  • We have create a new organization C and move all repositories from B to C.
  • We have delete orgaB
  • Now in OrgaA we see only their repositories. no more B or C repositoriesss
@camlafit commented on GitHub (Jan 19, 2020): Hello We've found a workaround : Start use case, when logged, from OrgaA listing we see OrgaB repositories. Workaround : * We have create a new organization C and move all repositories from B to C. * We have delete orgaB * Now in OrgaA we see only their repositories. no more B or C repositoriesss
Author
Owner

@stale[bot] commented on GitHub (Mar 19, 2020):

This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.

@stale[bot] commented on GitHub (Mar 19, 2020): This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.
Author
Owner

@stale[bot] commented on GitHub (Apr 2, 2020):

This issue has been automatically closed because of inactivity. You can re-open it if needed.

@stale[bot] commented on GitHub (Apr 2, 2020): This issue has been automatically closed because of inactivity. You can re-open it if needed.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#3962