Skip to content

Instantly share code, notes, and snippets.

@sshaikh
Created May 24, 2020 14:52
Show Gist options
  • Save sshaikh/4bfd4219e4dcdfa2a8c96893c5c02c56 to your computer and use it in GitHub Desktop.
Save sshaikh/4bfd4219e4dcdfa2a8c96893c5c02c56 to your computer and use it in GitHub Desktop.
2020/05/24 15:48:38 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1590331706 1590331716 1] - 576.245µs
2020/05/24 15:48:44 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 504.29µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 439.577µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [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" 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=$1 AND ("team".authorize=$2 OR "team".can_create_org_repo=$3)) ORDER BY "user"."updated_unix" DESC [1 owner true] - 813.856µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 279.919µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:36:BeginTx() [I] [SQL] BEGIN TRANSACTION [] - 59.234µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [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", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [2 omv-config] - 349.706µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] INSERT INTO "repository" ("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","is_private","is_empty","is_archived","is_mirror","status","is_fork","fork_id","is_template","template_id","size","is_fsck_enabled","close_issues_via_commit_in_any_branch","topics","avatar","created_unix","updated_unix") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34) RETURNING "id" [2 atal omv-config omv-config 0 0 0 0 0 0 0 0 0 0 true true false false 0 false 0 false 0 0 true false null 1590331728 1590331728] - 347.488µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] DELETE FROM "repo_redirect" WHERE "owner_id"=$1 AND "lower_name"=$2 [2 omv-config] - 225.114µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] INSERT INTO "repo_unit" ("repo_id","type","config","created_unix") VALUES ($1, $2, $3, $4),($5, $6, $7, $8),($9, $10, $11, $12),($13, $14, $15, $16),($17, $18, $19, $20) [32 UnitTypeCode <nil> 1590331728 32 UnitTypeIssues {"EnableTimetracker":false,"AllowOnlyContributorsToTrackTime":true,"EnableDependencies":true} 1590331728 32 UnitTypePullRequests {"IgnoreWhitespaceConflicts":false,"AllowMerge":true,"AllowRebase":true,"AllowRebaseMerge":true,"AllowSquash":true} 1590331728 32 UnitTypeReleases <nil> 1590331728 32 UnitTypeWiki <nil> 1590331728] - 200.912µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] UPDATE "user" SET "last_repo_visibility" = $1, "updated_unix" = $2 WHERE "id"=$3 [true 1590331728 2] - 225.092µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] UPDATE "user" SET "updated_unix" = $1, "num_repos" = "num_repos" + $2 WHERE "id"=$3 [1590331728 1 2] - 195.764µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "org_id", "lower_name", "name", "description", "authorize", "num_repos", "num_members", "includes_all_repositories", "can_create_org_repo" FROM "team" WHERE (org_id=$1) ORDER BY CASE WHEN name LIKE 'Owners' THEN '' ELSE name END [2] - 242.378µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] INSERT INTO "team_repo" ("org_id","team_id","repo_id") VALUES ($1, $2, $3) RETURNING "id" [2 1 32] - 183.011µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] UPDATE "team" SET "num_repos" = "num_repos" + $1 WHERE "id"=$2 [1 1] - 145.868µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "repo_id", "user_id", "mode" FROM "collaboration" WHERE "repo_id"=$1 [32] - 164.816µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "org_id", "team_id", "uid" FROM "team_user" WHERE (team_id=$1) [1] - 137.695µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 237.273µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "org_id", "team_id", "repo_id" FROM "team_repo" WHERE (org_id=$1) AND (team_id=$2) AND (repo_id=$3) LIMIT 1 [2 3 32] - 165.466µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] DELETE FROM "access" WHERE "repo_id"=$1 [32] - 129.911µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] INSERT INTO "access" ("user_id","repo_id","mode") VALUES ($1, $2, $3) [1 32 owner] - 123.911µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "org_id", "team_id", "uid" FROM "team_user" WHERE (team_id=$1) [1] - 122.773µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 227.685µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "user_id", "repo_id", "mode" FROM "watch" WHERE "user_id"=$1 AND "repo_id"=$2 LIMIT 1 [1 32] - 148.653µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] INSERT INTO "watch" ("user_id","repo_id","mode") VALUES ($1, $2, $3) RETURNING "id" [1 32 1] - 148.657µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:130:ExecContext() [I] [SQL] UPDATE "repository" SET num_watches = num_watches + $1 WHERE id = $2 [1 32] - 199.772µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "user_id", "repo_id", "mode" FROM "watch" WHERE "user_id"=$1 AND "repo_id"=$2 LIMIT 1 [1 32] - 138.805µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [I] [SQL] SELECT "id", "repo_id", "org_id", "is_system_webhook", "url", "signature", "http_method", "content_type", "secret", "events", "is_ssl", "is_active", "hook_task_type", "meta", "last_status", "created_unix", "updated_unix" FROM "webhook" WHERE (repo_id=$1 AND org_id=$2 AND is_system_webhook=$3) [0 0 false] - 182.203µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1590331716 1590331726 1] - 565.383µs
2020/05/24 15:48:48 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 192.079µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 414.09µs
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "org_id", "lower_name", "name", "description", "authorize", "num_repos", "num_members", "includes_all_repositories", "can_create_org_repo" FROM "team" WHERE (org_id=$1) ORDER BY CASE WHEN name LIKE 'Owners' THEN '' ELSE name END [2] - 278.554µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:36:BeginTx() [I] [SQL] BEGIN TRANSACTION [] - 92.044µs
2020/05/24 15:48:48 ...m.io/xorm/core/tx.go:157:QueryContext() [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", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 AND "owner_id"=$2 LIMIT 1 [32 2] - 328.766µs
2020/05/24 15:48:48 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 51.913µs
2020/05/24 15:48:48 ...sitory/repository.go:23:CreateRepository() [E] Rollback deleteRepository: repository does not exist [id: 32, uid: 2, owner_name: , name: ]
2020/05/24 15:48:48 routers/repo/repo.go:175:handleCreateError() [E] CreatePost: initRepository: createDelegateHooks: Unable to set /appdata/repositories/atal/omv-config.git/hooks/update executable. Error stat /appdata/repositories/atal/omv-config.git/hooks/update.d/gitea: interrupted system call
2020/05/24 15:48:48 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT count(*) FROM "notification" WHERE (user_id = $1) AND (status = $2) [1 1] - 246.632µs
2020/05/24 15:48:49 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 475.527µs
2020/05/24 15:48:49 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "lower_name"=$1 LIMIT 1 [sshaikh] - 352.979µs
2020/05/24 15:48:49 ...m.io/xorm/core/db.go:154:QueryContext() [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" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 452.081µs
2020/05/24 15:48:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1590331726 1590331736 1] - 559.364µs
2020/05/24 15:49:08 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1590331736 1590331746 1] - 544.643µs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment