Activity Page not showing for all repos.

[C-EO]

Description

I mirrored a repo and converted it into a regular repo. (I mirrored from GitHub). When I visit the Activity tab on the repo page, I get a 500 error.

Gitea Version

1.22.0+dev-3-ge46274b5b

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

Git Version

2.33.1, Wire Protocol Version 2 Enabled

Operating System

linux 6.2.0-1013-gcp

How are you running Gitea?

Binary

Database

MySQL/MariaDB

[KN4CK3R]

release is a reserved keyword in MySQL (https://dev.mysql.com/doc/refman/8.0/en/keywords.html), could be the error here. Still strange that no test detected this.
Could you turn on sql logging? I think the query will deliver more info.

[wxiaoguang]

That's why I have called out many times: use at least 2 words for database tables/columns, to avoid unnecessary keyword conflict in SQL.

[C-EO]

release is a reserved keyword in MySQL (https://dev.mysql.com/doc/refman/8.0/en/keywords.html), could be the error here. Still strange that no test detected this. Could you turn on sql logging? I think the query will deliver more info.

I will get you the log results

[C-EO]

@KN4CK3R Below are the log results:

BSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub label] - 160.098587ms
2023/09/22 17:42:25 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub label] - 160.986377ms
2023/09/22 17:42:25 cmd/web.go:194:serveInstalled() [W] Table label Column archived_unix db default is , struct default is NULL
2023/09/22 17:42:25 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub issue_label] - 171.131776ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub issue_label] - 164.157877ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub milestone] - 161.120707ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub milestone] - 170.148446ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub pull_request] - 170.309907ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub pull_request] - 169.289356ms
2023/09/22 17:42:26 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub reaction] - 176.926916ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub reaction] - 177.036346ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub review] - 186.896065ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub review] - 190.515745ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub stopwatch] - 165.914947ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub stopwatch] - 163.221287ms
2023/09/22 17:42:27 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub tracked_time] - 165.594697ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub tracked_time] - 166.748006ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub repo_transfer] - 161.448627ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub repo_transfer] - 162.337207ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub hook_task] - 161.448126ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub hook_task] - 160.676437ms
2023/09/22 17:42:28 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub webhook] - 169.674237ms
2023/09/22 17:42:29 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub webhook] - 161.994987ms
2023/09/22 17:42:29 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub action] - 165.032937ms
2023/09/22 17:42:29 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub action] - 160.469477ms
2023/09/22 17:42:29 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `COLUMN_COMMENT`, `CHARACTER_MAXIMUM_LENGTH`, (INSTR(VERSION(), 'maria') > 0 && (SUBSTRING_INDEX(VERSION(), '.', 1) > 10 || (SUBSTRING_INDEX(VERSION(), '.', 1) = 10 && (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) > 2 || (SUBSTRING_INDEX(SUBSTRING(VERSION(), 4), '.', 1) = 2 && SUBSTRING_INDEX(SUBSTRING(VERSION(), 6), '-', 1) >= 7))))) AS NEEDS_QUOTE, `COLLATION_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `COLUMNS`.ORDINAL_POSITION ASC [nitehub notification] - 165.101757ms
2023/09/22 17:42:29 models/db/engine.go:198:InitEngineWithMigration() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? ORDER BY `SEQ_IN_INDEX` [nitehub notification] - 161.879707ms
2023/09/22 17:42:29 routers/init.go:137:InitWebInstalled() [I] ORM engine initialization successful!
2023/09/22 17:42:29 ...odels/auth/oauth2.go:632:GetActiveOAuth2ProviderSources() [I] [SQL] SELECT `id`, `type`, `name`, `is_active`, `is_sync_enabled`, `cfg`, `created_unix`, `updated_unix` FROM `login_source` WHERE (is_active = ? and type = ?) [true OAuth2] - 162.154717ms
2023/09/22 17:42:30 ...ls/system/setting.go:141:GetSettings() [I] [SQL] SELECT `id`, `setting_key`, `setting_value`, `version`, `created`, `updated` FROM `system_setting` WHERE setting_key IN (?) [picture.disable_gravatar] - 158.477977ms
2023/09/22 17:42:30 ...ls/system/setting.go:141:GetSettings() [I] [SQL] SELECT `id`, `setting_key`, `setting_value`, `version`, `created`, `updated` FROM `system_setting` WHERE setting_key IN (?) [picture.enable_federated_avatar] - 159.835158ms
2023/09/22 17:42:30 ...odels/auth/oauth2.go:80:Init() [I] [SQL] SELECT `id`, `uid`, `name`, `client_id`, `client_secret`, `confidential_client`, `redirect_uris`, `created_unix`, `updated_unix` FROM `oauth2_application` WHERE `client_id` IN (?,?) [a4792ccc-144e-407e-86c9-5e7d8d9c3269 e90ee53c-94e2-48ac-9358-a874fb9e0662] - 159.407218ms
2023/09/22 17:42:30 ...er/issues/indexer.go:77:func1() [I] PID 630: Initializing Issue Indexer: bleve
2023/09/22 17:42:30 ...exer/code/indexer.go:153:func3() [I] PID: 630 Initializing Repository Indexer at: /home/runner/git/nitesys/indexers/repos.bleve
2023/09/22 17:42:30 ...xer/stats/indexer.go:39:populateRepoIndexer() [I] Populating the repo stats indexer with existing repositories
2023/09/22 17:42:30 ...exer/code/indexer.go:234:func4() [I] Repository Indexer Initialization took 1.00984ms
2023/09/22 17:42:30 ...er/issues/indexer.go:154:func2() [I] Issue Indexer Initialization took 1.24104ms
2023/09/22 17:42:30 ...b727260d35/engine.go:1246:Get() [I] [SQL] SELECT `id`, `revision`, `content` FROM `app_state` WHERE `id`=? LIMIT 1 [runtime-state] - 159.767797ms
2023/09/22 17:42:31 .../actions/artifact.go:162:ListNeedExpiredArtifacts() [I] [SQL] SELECT `id`, `run_id`, `runner_id`, `repo_id`, `owner_id`, `commit_sha`, `storage_path`, `file_size`, `file_compressed_size`, `content_encoding`, `artifact_path`, `artifact_name`, `status`, `created_unix`, `updated_unix`, `expired_unix` FROM `action_artifact` WHERE (expired_unix < ? AND status = ?) [1695404551 2] - 170.996797ms
2023/09/22 17:42:31 ...s/actions/cleanup.go:29:CleanupArtifacts() [I] Found 0 expired artifacts
2023/09/22 17:42:31 .../runtime/asm_amd64.s:1650:goexit() [I] [SQL] SELECT 1 FROM `repository` LIMIT 1 [] - 460.201123ms
2023/09/22 17:42:31 models/db/engine.go:290:GetMaxID() [I] [SQL] SELECT MAX(id) FROM `repository` LIMIT 1 [] - 95.950232ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Cleanup actions expired logs and artifacts has finished 1695404551] - 206.056394ms
2023/09/22 17:42:31 .../issues/pull_list.go:123:GetPullRequestIDsByCheckStatus() [I] [SQL] SELECT `pull_request`.`id` FROM `pull_request` WHERE (status=?) [CHECKING] - 556.254905ms
2023/09/22 17:42:31 .../webhook/hooktask.go:186:FindUndeliveredHookTaskIDs() [I] [SQL] SELECT id FROM `hook_task` WHERE (is_delivered=?) AND (id > ?) ORDER BY `id` ASC LIMIT 100 [false 0] - 564.537794ms
2023/09/22 17:42:31 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_watches!=(SELECT COUNT(*) FROM `watch` WHERE repo_id=repo.id AND mode<>2) [] - 435.573696ms
2023/09/22 17:42:31 modules/system/db.go:34:Set() [I] [SQL] BEGIN TRANSACTION [] - 82.105003ms
2023/09/22 17:42:31 .../cron/tasks_basic.go:156:func1() [I] [SQL] BEGIN TRANSACTION [] - 513.555808ms
2023/09/22 17:42:31 ...chedule_spec_list.go:93:FindSpecs() [I] [SQL] SELECT `id`, `repo_id`, `schedule_id`, `next`, `prev`, `spec`, `created`, `updated` FROM `action_schedule_spec` WHERE next<=? ORDER BY `id` DESC LIMIT 50 [1695404551] - 547.864775ms
[mysql] 2023/09/22 17:42:31 packets.go:446: busy buffer
[mysql] 2023/09/22 17:42:31 connection.go:173: bad connection
[mysql] 2023/09/22 17:42:31 packets.go:427: busy buffer
2023/09/22 17:42:31 ...repo/repo_indexer.go:61:GetUnindexedRepos() [I] [SQL] SELECT `repository`.`id` FROM `repository` LEFT OUTER JOIN `repo_indexer_status` ON repository.id = repo_indexer_status.repo_id AND repo_indexer_status.indexer_type = ? WHERE repo_indexer_status.id IS NULL AND repository.is_empty=? AND repository.id<=? ORDER BY `repository`.`id` DESC LIMIT 50 [1 false 11] - 173.394666ms
2023/09/22 17:42:31 ...xer/stats/indexer.go:85:populateRepoIndexer() [I] Done (re)populating the repo stats indexer with existing repositories
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 [0] - 549.389506ms
2023/09/22 17:42:31 models/user/user.go:904:GetInactiveUsers() [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `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`, `is_restricted`, `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`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE is_active=? AND created_unix<? [false 1694799751] - 550.613006ms
2023/09/22 17:42:31 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_stars!=(SELECT COUNT(*) FROM `star` WHERE repo_id=repo.id) [] - 115.98377ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` LIMIT 50 [] - 551.322596ms
2023/09/22 17:42:31 cmd/web.go:304:listen() [I] Listen: http://0.0.0.0:3000
2023/09/22 17:42:31 cmd/web.go:308:listen() [I] AppURL(ROOT_URL): https://git.c-eo.repl.co/
2023/09/22 17:42:31 cmd/web.go:311:listen() [I] LFS server enabled
2023/09/22 17:42:31 ...s/graceful/server.go:70:NewServer() [I] Starting new Web server: tcp:0.0.0.0:3000 on PID: 630
2023/09/22 17:42:31 ...b727260d35/engine.go:1262:Find() [I] [SQL] SELECT `id`, `type`, `name`, `is_active`, `is_sync_enabled`, `cfg`, `created_unix`, `updated_unix` FROM `login_source` [] - 560.651685ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 [0] - 625.88793ms
2023/09/22 17:42:31 ...actions/task_list.go:100:FindTasks() [I] [SQL] SELECT `id`, `job_id`, `attempt`, `runner_id`, `status`, `started`, `stopped`, `repo_id`, `owner_id`, `commit_sha`, `is_fork_pull_request`, `token_hash`, `token_salt`, `token_last_eight`, `log_filename`, `log_in_storage`, `log_length`, `log_size`, `log_indexes`, `log_expired`, `created`, `updated` FROM `action_task` WHERE status=? AND started<? [running 1695393751] - 640.304229ms
2023/09/22 17:42:31 ...y_authorized_keys.go:178:RegeneratePublicKeys() [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `login_source_id`, `created_unix`, `updated_unix`, `verified` FROM `public_key` WHERE (type != ?) [3] - 643.576498ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` LIMIT 50 OFFSET 3 [] - 98.481962ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE (id>0 AND is_fsck_enabled=?) LIMIT 50 [true] - 652.747577ms
2023/09/22 17:42:31 ...els/repo/archiver.go:142:FindRepoArchives() [I] [SQL] SELECT `id`, `repo_id`, `type`, `status`, `commit_id`, `created_unix` FROM `repo_archiver` WHERE created_unix<? ORDER BY `created_unix` ASC LIMIT 50 [1695318151] - 653.472928ms
2023/09/22 17:42:31 models/db/context.go:148:WithTx() [I] [SQL] UPDATE app_state SET revision=revision+1, content=? WHERE id=? [{"LatestVersion":"1.20.4"} update-checker] - 170.623027ms
2023/09/22 17:42:31 .../cron/tasks_basic.go:115:func1() [I] [SQL] DELETE FROM `branch` WHERE (is_deleted=? AND deleted_unix < ?) [true 1695318151] - 659.056898ms
2023/09/22 17:42:31 ...archiver/archiver.go:377:DeleteRepositoryArchives() [I] [SQL] DELETE FROM `repo_archiver` WHERE (1=1) [] - 691.406265ms
2023/09/22 17:42:31 ...on/tasks_extended.go:171:func1() [I] [SQL] DELETE FROM `notice` WHERE (created_unix < ?) [1695318151] - 690.457815ms
2023/09/22 17:42:31 ...ls/repo/repo_list.go:542:SearchRepositoryByCondition() [I] [SQL] SELECT count(*) FROM `repository` [] - 707.579673ms
2023/09/22 17:42:31 ...ervices/user/user.go:319:DeleteInactiveUsers() [I] [SQL] DELETE FROM `email_address` WHERE (is_activated = ?) [false] - 178.268096ms
2023/09/22 17:42:31 ...on/tasks_extended.go:139:func1() [I] [SQL] DELETE FROM `action` WHERE (created_unix < ?) [1695145351] - 750.36002ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Update the '.ssh/authorized_principals' file with Gitea SSH principals. has finished 1695404551] - 750.851669ms
2023/09/22 17:42:31 ...odels/repo/mirror.go:116:MirrorsIterate() [I] [SQL] SELECT `id`, `repo_id`, `interval`, `enable_prune`, `updated_unix`, `next_update_unix`, `lfs_enabled`, `lfs_endpoint`, `remote_address` FROM `mirror` WHERE (next_update_unix<=?) AND (next_update_unix!=0) ORDER BY updated_unix ASC LIMIT 30 [1695404551] - 755.56461ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 [0] - 754.52633ms
2023/09/22 17:42:31 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_issues!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_pull=?) [false] - 204.341294ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `enabled`, `owner_id`, `type`, `keep_count`, `keep_pattern`, `remove_days`, `remove_pattern`, `match_full_name`, `created_unix`, `updated_unix` FROM `package_cleanup_rule` WHERE enabled=? LIMIT 50 [true] - 242.263411ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Start schedule tasks canceled: find specs: Error 1105 (HY000): unknown error: syntax error at position 123 near 'next' 1695404551] - 206.622124ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 OFFSET 3 [0] - 205.646014ms
2023/09/22 17:42:31 modules/system/db.go:34:Set() [I] [SQL] COMMIT [] - 98.376262ms
2023/09/22 17:42:31 ...ls/repo/repo_list.go:552:SearchRepositoryByCondition() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` ORDER BY id ASC LIMIT 64 [] - 88.008712ms
2023/09/22 17:42:31 .../cron/tasks_basic.go:142:func1() [I] [SQL] DELETE FROM `hook_task` WHERE (is_delivered = ? and delivered < ?) [true 1695145351017655047] - 804.009065ms
2023/09/22 17:42:31 ...ions/run_job_list.go:93:FindRunJobs() [I] [SQL] SELECT `id`, `run_id`, `repo_id`, `owner_id`, `commit_sha`, `is_fork_pull_request`, `name`, `attempt`, `workflow_payload`, `job_id`, `needs`, `runs_on`, `task_id`, `status`, `started`, `stopped`, `created`, `updated` FROM `action_run_job` WHERE status IN (?,?) AND updated<? [waiting blocked 1695318151] - 804.358746ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Stop endless tasks has finished 1695404551] - 191.774504ms
2023/09/22 17:42:31 ...rvices/cron/tasks.go:100:func2() [I] [SQL] COMMIT [] - 93.178152ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 OFFSET 3 [0] - 218.285452ms
2023/09/22 17:42:31 ...actions/task_list.go:100:FindTasks() [I] [SQL] SELECT `id`, `job_id`, `attempt`, `runner_id`, `status`, `started`, `stopped`, `repo_id`, `owner_id`, `commit_sha`, `is_fork_pull_request`, `token_hash`, `token_salt`, `token_last_eight`, `log_filename`, `log_in_storage`, `log_length`, `log_size`, `log_indexes`, `log_expired`, `created`, `updated` FROM `action_task` WHERE status=? AND updated<? [running 1695403951] - 848.226812ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 [0] - 849.715302ms
2023/09/22 17:42:31 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [github] - 850.861732ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Delete all old system notices from database has finished 1695404551] - 180.342235ms
2023/09/22 17:42:31 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_closed_issues!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_closed=? AND is_pull=?) [true false] - 191.661294ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Update checker has finished 1695404551] - 190.071795ms
2023/09/22 17:42:31 ...s/repo/pushmirror.go:146:PushMirrorsIterate() [I] [SQL] SELECT `id`, `repo_id`, `remote_name`, `remote_address`, `sync_on_commit`, `interval`, `created_unix`, `last_update`, `last_error` FROM `push_mirror` WHERE (last_update + (`interval` / ?) <= ?) AND (`interval` != 0) ORDER BY last_update ASC LIMIT 20 [1s 1695404551] - 192.421555ms
2023/09/22 17:42:31 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 OFFSET 3 [0] - 192.224685ms
2023/09/22 17:42:31 .../cron/tasks_basic.go:156:func1() [I] [SQL] BEGIN TRANSACTION [] - 98.416512ms
2023/09/22 17:42:31 ...ls/repo/repo_list.go:83:LoadAttributes() [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `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`, `is_restricted`, `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`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE (id > 0) AND `id` IN (?,?) [3 1] - 166.903397ms
2023/09/22 17:42:31 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Cleanup hook_task table has finished 1695404551] - 165.354346ms
2023/09/22 17:42:32 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Stop zombie tasks has finished 1695404551] - 197.778694ms
2023/09/22 17:42:32 ...ions/run_job_list.go:93:FindRunJobs() [I] [SQL] SELECT count(*) FROM `action_run_job` WHERE status IN (?,?) AND updated<? [waiting blocked 1695318151] - 241.673921ms
2023/09/22 17:42:32 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `issue` SET `original_author_id` = ?, `poster_id` = ?, `original_author` = ? WHERE (repo_id IN (SELECT id FROM repository WHERE original_service_type = ?)) AND (original_author_id = ?) [0 1  2 85847352] - 197.184994ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_pulls!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_pull=?) [true] - 201.859444ms
2023/09/22 17:42:32 ...ckage_blob_upload.go:78:FindExpiredBlobUploads() [I] [SQL] SELECT `id`, `bytes_received`, `hash_state_bytes`, `created_unix`, `updated_unix` FROM `package_blob_upload` WHERE (updated_unix < ?) [1695318151] - 202.168883ms
2023/09/22 17:42:32 ...ls/repo/repo_list.go:95:LoadAttributes() [I] [SQL] SELECT `id`, `repo_id`, `commit_id`, `is_primary`, `language`, `size`, `created_unix` FROM `language_stat` WHERE (`is_primary` = ? AND `language` != ?) AND `repo_id` IN (?,?,?) [true other 6 10 11] - 185.586875ms
2023/09/22 17:42:32 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Update Mirrors has finished 1695404551] - 203.578093ms
2023/09/22 17:42:32 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Cancel abandoned jobs has finished 1695404552] - 206.837963ms
2023/09/22 17:42:32 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `comment` SET `poster_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) AND (comment.original_author_id = ?) [1  0 2 85847352] - 206.551654ms
2023/09/22 17:42:32 .../container/search.go:243:SearchExpiredUploadedBlobs() [I] [SQL] SELECT * FROM `package_file` INNER JOIN `package_version` ON package_version.id = package_file.version_id INNER JOIN `package` ON package.id = package_version.package_id WHERE package.type=? AND package_version.is_internal=? AND package_version.lower_version=? AND package_file.created_unix<? [container true _upload 1695318152] - 196.845004ms
2023/09/22 17:42:32 ...dels/issues/issue.go:584:GetIssueIDsByRepoID() [I] [SQL] SELECT `id` FROM `issue` WHERE (repo_id = ?) [6] - 196.585164ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_closed_pulls!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_closed=? AND is_pull=?) [true true] - 198.079544ms
2023/09/22 17:42:32 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `release` SET `publisher_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE (repo_id IN (SELECT id FROM repository WHERE original_service_type = ?)) AND (original_author_id = ?) [1  0 2 85847352] - 192.564774ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT label.id FROM `label` WHERE label.num_issues!=(SELECT COUNT(*) FROM `issue_label` WHERE label_id=label.id) [] - 100.571462ms
2023/09/22 17:42:32 ...dels/issues/issue.go:584:GetIssueIDsByRepoID() [I] [SQL] SELECT `id` FROM `issue` WHERE (repo_id = ?) [10] - 179.980116ms
2023/09/22 17:42:32 ...s/package_version.go:297:SearchVersions() [I] [SQL] SELECT * FROM `package_version` INNER JOIN `package` ON package.id = package_version.package_id WHERE package_version.is_internal=? AND package.type=? AND package_version.lower_version=? AND NOT EXISTS (SELECT package_file.id FROM package_file WHERE package_file.version_id = package_version.id) ORDER BY `package_version`.`created_unix` DESC [true container _upload] - 199.630164ms
2023/09/22 17:42:32 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `reaction` SET `user_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE (original_author_id = ?) AND issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) [1  0 85847352 2] - 161.050667ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT `label`.id FROM `label` WHERE `label`.num_closed_issues!=(SELECT COUNT(*) FROM `issue_label`,`issue` WHERE `issue_label`.label_id=`label`.id AND `issue_label`.issue_id=`issue`.id AND `issue`.is_closed=?) [true] - 160.831917ms
2023/09/22 17:42:32 ...dels/issues/issue.go:584:GetIssueIDsByRepoID() [I] [SQL] SELECT `id` FROM `issue` WHERE (repo_id = ?) [11] - 159.426827ms
2023/09/22 17:42:32 ...s/package_version.go:297:SearchVersions() [I] [SQL] SELECT count(*) FROM `package_version` INNER JOIN `package` ON package.id = package_version.package_id WHERE package_version.is_internal=? AND package.type=? AND package_version.lower_version=? AND NOT EXISTS (SELECT package_file.id FROM package_file WHERE package_file.version_id = package_version.id) [true container _upload] - 181.035946ms
2023/09/22 17:42:32 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `review` SET `reviewer_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE (original_author_id = ?) AND issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) [1  0 85847352 2] - 159.285027ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT `milestone`.id FROM `milestone` WHERE `milestone`.num_closed_issues!=(SELECT COUNT(*) FROM `issue` WHERE `issue`.milestone_id=`milestone`.id AND `issue`.is_closed=?) OR `milestone`.num_issues!=(SELECT COUNT(*) FROM `issue` WHERE `issue`.milestone_id=`milestone`.id) [true] - 159.582517ms
2023/09/22 17:42:32 ...ls/repo/repo_list.go:542:SearchRepositoryByCondition() [I] [SQL] SELECT count(*) FROM `repository` [] - 92.036003ms
2023/09/22 17:42:32 .../packages/package.go:295:FindUnreferencedPackages() [I] [SQL] SELECT `id`, `owner_id`, `repo_id`, `type`, `name`, `lower_name`, `semver_compatible`, `is_internal` FROM `package` WHERE package.id IN (SELECT id FROM (SELECT package.id FROM package LEFT JOIN package_version ON package_version.package_id = package.id WHERE package_version.id IS NULL) temp) [] - 81.684223ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT `user`.id FROM `user` WHERE `user`.num_repos!=(SELECT COUNT(*) FROM `repository` WHERE owner_id=`user`.id) [] - 80.054503ms
2023/09/22 17:42:32 ...ls/repo/repo_list.go:552:SearchRepositoryByCondition() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` ORDER BY id ASC LIMIT 64 OFFSET 64 [] - 89.129314ms
2023/09/22 17:42:32 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitlab] - 156.786667ms
2023/09/22 17:42:32 models/repo.go:219:CheckRepoStats() [I] [SQL] SELECT `issue`.id FROM `issue` WHERE `issue`.num_comments!=(SELECT COUNT(*) FROM `comment` WHERE issue_id=`issue`.id AND type=0) [] - 80.626044ms
2023/09/22 17:42:32 models/git/lfs.go:330:GetRepoLFSSize() [I] [SQL] SELECT COALESCE(sum(`size`),0) FROM `lfs_meta_object` WHERE (repository_id = ?) [6] - 157.846727ms
2023/09/22 17:42:32 ...ages/package_blob.go:85:FindExpiredUnreferencedBlobs() [I] [SQL] SELECT * FROM `package_blob` LEFT JOIN `package_file` ON package_file.blob_id = package_blob.id WHERE (package_file.id IS NULL AND package_blob.created_unix < ?) [1695318152] - 160.393937ms
2023/09/22 17:42:33 ...rvices/cron/tasks.go:100:func2() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_forks!=(SELECT COUNT(*) FROM `repository` WHERE fork_id=repo.id) [] - 82.029893ms
2023/09/22 17:42:33 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE (id>0 AND is_fsck_enabled=?) LIMIT 50 OFFSET 3 [true] - 158.712307ms
2023/09/22 17:42:33 ...els/system/notice.go:54:CreateNotice() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?,?,?) [2 Cron: Rebuild issue indexer has finished 1695404552] - 171.716836ms
2023/09/22 17:42:33 ...rvices/cron/tasks.go:100:func2() [I] [SQL] COMMIT [] - 78.390384ms
2023/09/22 17:42:33 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `issue` SET `poster_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE (repo_id IN (SELECT id FROM repository WHERE original_service_type = ?)) AND (original_author_id = ?) [1  0 4 9808481] - 164.005327ms
2023/09/22 17:42:33 .../repository/check.go:105:GitGcRepo() [I] [SQL] UPDATE `repository` SET `size` = ?, `git_size` = ?, `lfs_size` = ? WHERE `id`=? [7896822 7896822 0 6] - 157.744868ms
2023/09/22 17:42:33 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `comment` SET `poster_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) AND (comment.original_author_id = ?) [1  0 4 9808481] - 161.363657ms
2023/09/22 17:42:33 models/git/lfs.go:330:GetRepoLFSSize() [I] [SQL] SELECT COALESCE(sum(`size`),0) FROM `lfs_meta_object` WHERE (repository_id = ?) [10] - 163.549827ms
2023/09/22 17:42:33 ...eb/routing/logger.go:102:func1() [I] router: completed GET / for 172.31.196.1:49166, 200 OK in 5.8ms @ web/home.go:32(web.Home)
2023/09/22 17:42:33 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `release` SET `original_author` = ?, `original_author_id` = ?, `publisher_id` = ? WHERE (repo_id IN (SELECT id FROM repository WHERE original_service_type = ?)) AND (original_author_id = ?) [ 0 1 4 9808481] - 165.459327ms
2023/09/22 17:42:33 .../repository/check.go:105:GitGcRepo() [I] [SQL] UPDATE `repository` SET `size` = ?, `git_size` = ?, `lfs_size` = ? WHERE `id`=? [30524 30524 0 10] - 161.358777ms
2023/09/22 17:42:33 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `reaction` SET `user_id` = ?, `original_author` = ?, `original_author_id` = ? WHERE (original_author_id = ?) AND issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) [1  0 9808481 4] - 158.114817ms
2023/09/22 17:42:33 models/git/lfs.go:330:GetRepoLFSSize() [I] [SQL] SELECT COALESCE(sum(`size`),0) FROM `lfs_meta_object` WHERE (repository_id = ?) [11] - 157.086697ms
2023/09/22 17:42:33 ...migrations/update.go:65:updateMigrationPosterIDByGitService() [I] [SQL] UPDATE `review` SET `original_author` = ?, `original_author_id` = ?, `reviewer_id` = ? WHERE (original_author_id = ?) AND issue_id IN (SELECT issue.id FROM issue INNER JOIN repository ON issue.repo_id = repository.id WHERE repository.original_service_type=?) [ 0 1 9808481 4] - 164.002737ms
2023/09/22 17:42:33 .../repository/check.go:105:GitGcRepo() [I] [SQL] UPDATE `repository` SET `size` = ?, `git_size` = ?, `lfs_size` = ? WHERE `id`=? [30538 30538 0 11] - 162.169347ms
2023/09/22 17:42:33 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitea] - 160.028547ms
2023/09/22 17:42:34 models/db/iterate.go:24:]() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE id>? LIMIT 50 OFFSET 3 [0] - 159.166787ms
2023/09/22 17:42:34 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gogs] - 160.708647ms
2023/09/22 17:42:34 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [onedev] - 161.368637ms
2023/09/22 17:42:34 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitbucket] - 159.510107ms
2023/09/22 17:42:34 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [codebase] - 227.630542ms
2023/09/22 17:42:51 models/user/user.go:915:GetUserByID() [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `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`, `is_restricted`, `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`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [1] - 162.241548ms
2023/09/22 17:42:52 .../issues/stopwatch.go:149:HasUserStopwatch() [I] [SQL] SELECT * FROM `stopwatch` INNER JOIN `issue` ON issue.id = stopwatch.issue_id INNER JOIN `repository` ON repository.id = issue.repo_id WHERE (user_id = ?) LIMIT 1 [1] - 161.411758ms
2023/09/22 17:42:52 ...b727260d35/engine.go:1246:Get() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [1 .profile] - 164.168076ms
2023/09/22 17:42:52 ...epo/collaboration.go:84:IsCollaborator() [I] [SQL] SELECT `id`, `repo_id`, `user_id`, `mode`, `created_unix`, `updated_unix` FROM `collaboration` WHERE `repo_id`=? AND `user_id`=? LIMIT 1 [10 1] - 160.644607ms
2023/09/22 17:42:52 ...ls/repo/repo_unit.go:268:getUnitsByRepoID() [I] [SQL] SELECT `id`, `repo_id`, `type`, `config`, `created_unix` FROM `repo_unit` WHERE (repo_id = ?) [10] - 160.476116ms
2023/09/22 17:42:52 ...s/repo/pushmirror.go:125:GetPushMirrorsByRepoID() [I] [SQL] SELECT `id`, `repo_id`, `remote_name`, `remote_address`, `sync_on_commit`, `interval`, `created_unix`, `last_update`, `last_error` FROM `push_mirror` WHERE (repo_id = ?) [10] - 158.926317ms
2023/09/22 17:42:52 ...s/repo/pushmirror.go:125:GetPushMirrorsByRepoID() [I] [SQL] SELECT count(*) FROM `push_mirror` WHERE (repo_id = ?) [10] - 162.880387ms
2023/09/22 17:42:53 ...ules/context/repo.go:539:RepoAssignment() [I] [SQL] SELECT count(*) FROM `release` WHERE repo_id=? AND sha1<>? [10 ] - 160.803627ms
2023/09/22 17:42:53 ...ules/context/repo.go:548:RepoAssignment() [I] [SQL] SELECT count(*) FROM `release` WHERE repo_id=? AND is_draft=? AND is_tag=? [10 false false] - 161.171298ms
2023/09/22 17:42:53 .../organization/org.go:532:GetOrgsCanCreateRepoByUserID() [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `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`, `is_restricted`, `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`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE id IN (SELECT `user`.id FROM `user` INNER JOIN `team_user` ON `team_user`.org_id = `user`.id INNER JOIN `team` ON `team`.id = `team_user`.team_id WHERE `team_user`.uid=? AND (`team`.authorize=? OR `team`.can_create_org_repo=?)) ORDER BY `user`.`name` ASC [1 owner true] - 160.024038ms
2023/09/22 17:42:53 ...ules/context/repo.go:564:RepoAssignment() [I] [SQL] SELECT 1 FROM `repository` WHERE (owner_id=? AND fork_id=?) LIMIT 1 [3 10] - 164.338186ms
2023/09/22 17:42:53 models/repo/fork.go:47:GetUserFork() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE (fork_id = ?) AND (owner_id = ?) LIMIT 1 [10 1] - 163.080277ms
2023/09/22 17:42:53 models/repo/fork.go:93:FindUserOrgForks() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `num_action_runs`, `num_closed_action_runs`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `git_size`, `lfs_size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix`, `archived_unix` FROM `repository` WHERE fork_id=? AND owner_id IN (SELECT org_id FROM org_user WHERE uid=?) [10 1] - 163.130327ms
2023/09/22 17:42:54 models/repo/watch.go:46:GetWatch() [I] [SQL] SELECT `id`, `user_id`, `repo_id`, `mode`, `created_unix`, `updated_unix` FROM `watch` WHERE `user_id`=? AND `repo_id`=? LIMIT 1 [1 10] - 158.756648ms
2023/09/22 17:42:54 models/repo/star.go:70:IsStaring() [I] [SQL] SELECT `id`, `uid`, `repo_id`, `created_unix` FROM `star` WHERE `uid`=? AND `repo_id`=? LIMIT 1 [1 10] - 161.576507ms
2023/09/22 17:42:54 ...ules/context/repo.go:671:RepoAssignment() [I] [SQL] SELECT count(*) FROM `branch` WHERE repo_id=? AND is_deleted=? [10 false] - 159.723098ms
2023/09/22 17:42:54 ...ies/repo_activity.go:347:FillReleases() [I] [SQL] SELECT `id`, `repo_id`, `publisher_id`, `tag_name`, `original_author`, `original_author_id`, `lower_tag_name`, `target`, `title`, `sha1`, `num_commits`, `note`, `is_draft`, `is_prerelease`, `is_tag`, `created_unix` FROM `release` WHERE (release.repo_id = ?) AND (release.is_draft = ?) AND (release.created_unix >= ?) ORDER BY release.created_unix DESC [10 false 1694799774] - 78.524994ms
2023/09/22 17:42:54 ...web/repo/activity.go:59:Activity() [E] GetActivityStats: FillReleases: Error 1105 (HY000): unknown error: syntax error at position 245 near 'release'
2023/09/22 17:42:54 ...eb/routing/logger.go:102:func1() [I] router: completed GET /C-EO/.profile/activity for 172.31.196.1:37342, 500 Internal Server Error in 2696.8ms @ repo/activity.go:21(repo.Activity)

[C-EO]

The last two log entries appear when I browse to the Activity page of any repo.

[KN4CK3R]

Can't reproduce the error on my setup but position 245 is the end of a release, so I'm sure it's because of the reserved keyword. Still strange that this issue does not appear more often.