Activity Page not showing for all repos. #27174

C-EO · 2023-09-21T14:51:18Z

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

The text was updated successfully, but these errors were encountered:

KN4CK3R · 2023-09-22T09:47:23Z

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 · 2023-09-22T10:26:56Z

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 · 2023-09-22T17:37:40Z

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 · 2023-09-22T17:44:13Z

@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 · 2023-09-22T17:47:14Z

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

KN4CK3R · 2023-09-23T07:57:06Z

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.

Fixes #27174 `release` is a reserved keyword in MySql. I can't reproduce the issue on my setup and we have a test for that code but it seems there can be setups where it fails. https://github.com/go-gitea/gitea/blob/a101dbaa7952e359843c6d8303ca24a0e63c865c/tests/integration/repo_activity_test.go#L45-L46

Fixes go-gitea#27174 `release` is a reserved keyword in MySql. I can't reproduce the issue on my setup and we have a test for that code but it seems there can be setups where it fails. https://github.com/go-gitea/gitea/blob/a101dbaa7952e359843c6d8303ca24a0e63c865c/tests/integration/repo_activity_test.go#L45-L46

Fixes go-gitea#27174 `release` is a reserved keyword in MySql. I can't reproduce the issue on my setup and we have a test for that code but it seems there can be setups where it fails.

@KN4CK3R

Backport #27205 by @KN4CK3R Fixes #27174 `release` is a reserved keyword in MySql. I can't reproduce the issue on my setup and we have a test for that code but it seems there can be setups where it fails. https://github.com/go-gitea/gitea/blob/a101dbaa7952e359843c6d8303ca24a0e63c865c/tests/integration/repo_activity_test.go#L45-L46 Co-authored-by: KN4CK3R <admin@oldschoolhack.me>

Backport of #27205 Fixes #27174 `release` is a reserved keyword in MySql. I can't reproduce the issue on my setup and we have a test for that code but it seems there can be setups where it fails.

C-EO added the type/bug label Sep 21, 2023

C-EO changed the title ~~Activity Page not showing for mirrored repos.~~ Activity Page not showing for all repos. Sep 22, 2023

KN4CK3R mentioned this issue Sep 23, 2023

Quote table release in sql queries #27205

Merged

KN4CK3R closed this as completed in #27205 Sep 23, 2023

GiteaBot mentioned this issue Sep 23, 2023

Quote table release in sql queries (#27205) #27218

Merged

KN4CK3R mentioned this issue Sep 23, 2023

Quote table release in sql queries (#27205) #27219

Merged

github-actions bot locked as resolved and limited conversation to collaborators Nov 8, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Activity Page not showing for all repos. #27174

Activity Page not showing for all repos. #27174

C-EO commented Sep 21, 2023

KN4CK3R commented Sep 22, 2023

wxiaoguang commented Sep 22, 2023

C-EO commented Sep 22, 2023

C-EO commented Sep 22, 2023

C-EO commented Sep 22, 2023

KN4CK3R commented Sep 23, 2023

Activity Page not showing for all repos. #27174

Activity Page not showing for all repos. #27174

Comments

C-EO commented Sep 21, 2023

Description

Gitea Version

Can you reproduce the bug on the Gitea demo site?

Log Gist

Screenshots

Git Version

Operating System

How are you running Gitea?

Database

KN4CK3R commented Sep 22, 2023

wxiaoguang commented Sep 22, 2023

C-EO commented Sep 22, 2023

C-EO commented Sep 22, 2023

C-EO commented Sep 22, 2023

KN4CK3R commented Sep 23, 2023