Created
April 10, 2017 00:07
-
-
Save guanix/2da9c05ce891df8210881e081c3315e0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
web_1 | [26933f4d-0773-445b-ad02-ae510cf6a280] method=GET path=/.well-known/host-meta format=html controller=XrdController action=host_meta status=200 duration=4.66 view=1.53 db=0.00 | |
web_1 | [58cc12e8-0c8b-4adc-8965-3cf119f6c0e6] Account Load (1.2ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'guan') AND "accounts"."domain" IS NULL LIMIT $1 [["LIMIT", 1]] | |
web_1 | [58cc12e8-0c8b-4adc-8965-3cf119f6c0e6] method=GET path=/.well-known/webfinger format=html controller=XrdController action=webfinger status=200 duration=13.23 view=3.29 db=1.21 | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] Account Load (1.0ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'jcape') AND (lower(accounts.domain) = 'mstdn.io') LIMIT $1 [["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] Looking up webfinger for jcape@mstdn.io | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] [httplog] GET https://mstdn.io/.well-known/host-meta completed with status code 200 in 0.6050295620007091 seconds | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] [httplog] GET https://mstdn.io/.well-known/webfinger?resource=acct:jcape@mstdn.io completed with status code 200 in 3.1107786190004845 seconds | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'jcape') AND (lower(accounts.domain) = 'mstdn.io') LIMIT $1 [["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] Creating new remote account for jcape@mstdn.io | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] DomainBlock Load (1.0ms) SELECT "domain_blocks".* FROM "domain_blocks" WHERE "domain_blocks"."domain" = $1 LIMIT $2 [["domain", "mstdn.io"], ["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] [httplog] GET https://mstdn.io/users/jcape.atom completed with status code 200 in 0.6095108340014121 seconds | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] (0.3ms) BEGIN | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] Account Exists (0.9ms) SELECT 1 AS one FROM "accounts" WHERE "accounts"."username" = $1 AND "accounts"."domain" = $2 LIMIT $3 [["username", "jcape"], ["domain", "mstdn.io"], ["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] SQL (1.0ms) INSERT INTO "accounts" ("username", "domain", "public_key", "remote_url", "salmon_url", "hub_url", "created_at", "updated_at", "uri", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id" [["username", "jcape"], ["domain", "mstdn.io"], ["public_key", "-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyiogpXIo0qNqPc8tf8AX\nmSZAjPHvsM1jZSTuMoABW6GcyoEN3inTY7g2dWSlWn/HjlzQ9Bqgf4GW/QpkS9cH\nDttnbpytILmSEvi9nDl6rV6vE2urNevvVEdwrn33RSHOl/N8g6aBQjYDgWM6vDVZ\nl5pton9IyngzyPhxxJdE1MZeE6tVHlZRvpZbMsgViRv0q2nw7LPsuTFaKD66sl+B\nc9MyQmyyVun854RCT5Roo/J2wJDLs0fX0kszAS1zUdYL2JkSuSpjXekd/oYqWwsn\nX4wVFgh/62qjyuRfNOBeuEBa37g+kY02fbHUszz73T4F3UTKVLtx7ittSiAVHFn4\ngQIDAQAB\n-----END PUBLIC KEY-----\n"], ["remote_url", "https://mstdn.io/users/jcape.atom"], ["salmon_url", "https://mstdn.io/api/salmon/11277"], ["hub_url", "https://mstdn.io/api/push"], ["created_at", 2017-04-10 00:04:33 UTC], ["updated_at", 2017-04-10 00:04:33 UTC], ["uri", "https://mstdn.io/users/jcape"], ["url", "https://mstdn.io/@jcape"]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] (0.9ms) COMMIT | |
sidekiq_1 | 2017-04-10T00:04:33.388Z 1 TID-gnottqbs4 RemoteProfileUpdateWorker JID-5e1b4b6f6b040c923dcc65b3 INFO: start | |
sidekiq_1 | Account Load (0.8ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
sidekiq_1 | DomainBlock Load (0.5ms) SELECT "domain_blocks".* FROM "domain_blocks" WHERE "domain_blocks"."domain" = $1 LIMIT $2 [["domain", "mstdn.io"], ["LIMIT", 1]] | |
web_1 | [807d441d-0ee4-4b6b-a45c-d39ebd868dfc] method=GET path=/authorize_follow format=html controller=AuthorizeFollowController action=new status=200 duration=4375.79 view=6.08 db=6.74 | |
sidekiq_1 | [httplog] GET http://mstdn.io:443/system/accounts/avatars/000/011/277/original/e306225381720abd.jpg?1491780273 completed with status code 200 in 0.1451495330002217 seconds | |
sidekiq_1 | Command :: file -b --mime '/tmp/bb45726d8b5299685d719b72ea66ae0420170410-1-j3ba2h.jpg' | |
sidekiq_1 | Command :: identify -format '%wx%h,%[exif:orientation]' '/tmp/bb45726d8b5299685d719b72ea66ae0420170410-1-8xh92n.jpg[0]' 2>/dev/null | |
sidekiq_1 | Command :: identify -format %m '/tmp/bb45726d8b5299685d719b72ea66ae0420170410-1-8xh92n.jpg[0]' | |
sidekiq_1 | Command :: convert '/tmp/bb45726d8b5299685d719b72ea66ae0420170410-1-8xh92n.jpg[0]' -auto-orient -resize "120x" -crop "120x120+0+0" +repage -quality 80 -strip '/tmp/58f25ca769edc17fd39bee567fd692a820170410-1-14di0wq' | |
sidekiq_1 | [httplog] GET http://mstdn.io:443/headers/original/missing.png completed with status code 200 in 0.2897365249991708 seconds | |
sidekiq_1 | Command :: file -b --mime '/tmp/ea21841da70e6405af19fabc4ff8bdd920170410-1-13o7o28.png' | |
sidekiq_1 | Command :: identify -format '%wx%h,%[exif:orientation]' '/tmp/ea21841da70e6405af19fabc4ff8bdd920170410-1-faol7b.png[0]' 2>/dev/null | |
sidekiq_1 | Command :: identify -format %m '/tmp/ea21841da70e6405af19fabc4ff8bdd920170410-1-faol7b.png[0]' | |
sidekiq_1 | Command :: convert '/tmp/ea21841da70e6405af19fabc4ff8bdd920170410-1-faol7b.png[0]' -auto-orient -resize "700x" -crop "700x335+0+182" +repage -quality 80 -strip '/tmp/93b8e8f37aa250dc40c387c17196380320170410-1-wbhwdp' | |
sidekiq_1 | (0.3ms) BEGIN | |
sidekiq_1 | Account Exists (0.7ms) SELECT 1 AS one FROM "accounts" WHERE "accounts"."username" = $1 AND ("accounts"."id" != $2) AND "accounts"."domain" = $3 LIMIT $4 [["username", "jcape"], ["id", 44], ["domain", "mstdn.io"], ["LIMIT", 1]] | |
sidekiq_1 | Command :: file -b --mime '/tmp/bb45726d8b5299685d719b72ea66ae0420170410-1-nwn98d.jpg' | |
sidekiq_1 | Command :: file -b --mime '/tmp/ea21841da70e6405af19fabc4ff8bdd920170410-1-1odj8rv.png' | |
sidekiq_1 | SQL (1.2ms) UPDATE "accounts" SET "display_name" = $1, "note" = $2, "avatar_remote_url" = $3, "avatar_file_name" = $4, "avatar_content_type" = $5, "avatar_file_size" = $6, "avatar_updated_at" = $7, "header_remote_url" = $8, "header_file_name" = $9, "header_content_type" = $10, "header_file_size" = $11, "header_updated_at" = $12, "updated_at" = $13 WHERE "accounts"."id" = $14 [["display_name", "James Cape"], ["note", "'You are a rude fucking piece of shit. Learn some manners.'"], ["avatar_remote_url", "https://mstdn.io/system/accounts/avatars/000/011/277/original/e306225381720abd.jpg?1491780273"], ["avatar_file_name", "e306225381720abd.jpg"], ["avatar_content_type", "image/jpeg"], ["avatar_file_size", 3608], ["avatar_updated_at", 2017-04-10 00:04:33 UTC], ["header_remote_url", "https://mstdn.io/headers/original/missing.png"], ["header_file_name", "missing.png"], ["header_content_type", "image/png"], ["header_file_size", 144], ["header_updated_at", 2017-04-10 00:04:34 UTC], ["updated_at", 2017-04-10 00:04:34 UTC], ["id", 44]] | |
sidekiq_1 | (0.9ms) COMMIT | |
sidekiq_1 | 2017-04-10T00:04:34.958Z 1 TID-gnottqbs4 RemoteProfileUpdateWorker JID-5e1b4b6f6b040c923dcc65b3 INFO: done: 1.57 sec | |
web_1 | [8e0e5f04-c0c4-49c0-aac5-517d938f5681] User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [8e0e5f04-c0c4-49c0-aac5-517d938f5681] Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [8e0e5f04-c0c4-49c0-aac5-517d938f5681] Account Load (1.2ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'jcape') AND (lower(accounts.domain) = 'mstdn.io') LIMIT $1 [["LIMIT", 1]] | |
web_1 | [8e0e5f04-c0c4-49c0-aac5-517d938f5681] method=GET path=/authorize_follow format=html controller=AuthorizeFollowController action=new status=200 duration=21.63 view=6.88 db=2.86 | |
web_1 | [0f1e53ad-0302-4bcc-bf60-1871360973e1] User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [0f1e53ad-0302-4bcc-bf60-1871360973e1] Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [0f1e53ad-0302-4bcc-bf60-1871360973e1] method=GET path=/system/accounts/avatars/000/000/044/original/e306225381720abd.jpg format=jpeg controller=ApplicationController action=raise_not_found status=404 duration=10.85 view=0.00 db=1.45 | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Account Load (1.1ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'jcape') AND (lower(accounts.domain) = 'mstdn.io') LIMIT $1 [["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Account Exists (0.9ms) SELECT 1 AS one FROM "accounts" INNER JOIN "blocks" ON "accounts"."id" = "blocks"."target_account_id" WHERE "blocks"."account_id" = $1 AND "accounts"."id" = $2 LIMIT $3 [["account_id", 44], ["id", 1], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Account Exists (0.7ms) SELECT 1 AS one FROM "accounts" INNER JOIN "blocks" ON "accounts"."id" = "blocks"."target_account_id" WHERE "blocks"."account_id" = $1 AND "accounts"."id" = $2 LIMIT $3 [["account_id", 1], ["id", 44], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Follow Load (0.7ms) SELECT "follows".* FROM "follows" WHERE "follows"."account_id" = $1 AND "follows"."target_account_id" = 44 ORDER BY "follows"."id" ASC LIMIT $2 [["account_id", 1], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] (0.3ms) BEGIN | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Follow Exists (0.5ms) SELECT 1 AS one FROM "follows" WHERE "follows"."account_id" = $1 AND "follows"."target_account_id" = $2 LIMIT $3 [["account_id", 1], ["target_account_id", 44], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] SQL (0.7ms) INSERT INTO "follows" ("account_id", "target_account_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["account_id", 1], ["target_account_id", 44], ["created_at", 2017-04-10 00:04:49 UTC], ["updated_at", 2017-04-10 00:04:49 UTC]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] SQL (0.8ms) UPDATE "accounts" SET "following_count" = COALESCE("following_count", 0) + 1 WHERE "accounts"."id" = $1 [["id", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] SQL (1.0ms) UPDATE "accounts" SET "followers_count" = COALESCE("followers_count", 0) + 1 WHERE "accounts"."id" = $1 [["id", 44]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] (0.8ms) COMMIT | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] [httplog] POST https://mstdn.io/api/push completed with status code 202 in 0.6376183169995784 seconds | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] (0.3ms) BEGIN | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] Account Exists (0.9ms) SELECT 1 AS one FROM "accounts" WHERE "accounts"."username" = $1 AND ("accounts"."id" != $2) AND "accounts"."domain" = $3 LIMIT $4 [["username", "jcape"], ["id", 44], ["domain", "mstdn.io"], ["LIMIT", 1]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] SQL (0.7ms) UPDATE "accounts" SET "secret" = $1, "updated_at" = $2 WHERE "accounts"."id" = $3 [["secret", "a6dd9a0195a2a80ae1d6c61aa668b38c"], ["updated_at", 2017-04-10 00:04:50 UTC], ["id", 44]] | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] (0.9ms) COMMIT | |
sidekiq_1 | 2017-04-10T00:04:50.526Z 1 TID-gnottqoj0 NotificationWorker JID-1b174ecd34b5f066d6d5908c INFO: start | |
sidekiq_1 | 2017-04-10T00:04:50.527Z 1 TID-gnottqbd4 AfterRemoteFollowWorker JID-96de3869f4859d98ec06af83 INFO: start | |
web_1 | [cb1752f0-a29c-4426-a941-ecda06dd5ded] method=POST path=/authorize_follow format=html controller=AuthorizeFollowController action=create status=302 duration=718.64 view=0.00 db=16.85 location=https://nsfw.finance/web/accounts/44 | |
sidekiq_1 | 2017-04-10T00:04:50.528Z 1 TID-gnottqbs4 MergeWorker JID-fd48c219c5979767062132ba INFO: start | |
sidekiq_1 | Account Load (1.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
sidekiq_1 | Account Load (1.7ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
sidekiq_1 | Follow Load (3.5ms) SELECT "follows".* FROM "follows" WHERE "follows"."id" = $1 LIMIT $2 [["id", 33], ["LIMIT", 1]] | |
sidekiq_1 | Account Load (2.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
sidekiq_1 | Account Load (8.9ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
sidekiq_1 | Account Load (6.1ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
sidekiq_1 | Status Load (9.2ms) SELECT "statuses".* FROM "statuses" WHERE "statuses"."account_id" = $1 ORDER BY id desc LIMIT $2 [["account_id", 44], ["LIMIT", 100]] | |
sidekiq_1 | 2017-04-10T00:04:50.554Z 1 TID-gnottqbs4 MergeWorker JID-fd48c219c5979767062132ba INFO: done: 0.026 sec | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] Account Load (0.4ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] Doorkeeper::Application Load (0.5ms) SELECT "oauth_applications".* FROM "oauth_applications" WHERE "oauth_applications"."superapp" = $1 ORDER BY "oauth_applications"."id" ASC LIMIT $2 [["superapp", true], ["LIMIT", 1]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] (0.2ms) BEGIN | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] Doorkeeper::AccessToken Exists (0.5ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] SQL (0.5ms) INSERT INTO "oauth_access_tokens" ("resource_owner_id", "token", "created_at", "scopes") VALUES ($1, $2, $3, $4) RETURNING "id" [["resource_owner_id", 1], ["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["created_at", 2017-04-10 00:04:50 UTC], ["scopes", "read write follow"]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] (0.6ms) COMMIT | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] Web::Setting Load (0.6ms) SELECT "web_settings".* FROM "web_settings" WHERE "web_settings"."user_id" = 1 LIMIT $1 [["LIMIT", 1]] | |
web_1 | [951a8c89-307a-4d48-9b7a-942212afb9d5] method=GET path=/web/accounts/44 format=html controller=HomeController action=index status=200 duration=32.48 view=10.10 db=4.09 | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] Account Load (1.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] (0.2ms) BEGIN | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] Account Exists (0.7ms) SELECT 1 AS one FROM "accounts" WHERE "accounts"."username" = $1 AND ("accounts"."id" != $2) AND "accounts"."domain" = $3 LIMIT $4 [["username", "jcape"], ["id", 44], ["domain", "mstdn.io"], ["LIMIT", 1]] | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] SQL (0.7ms) UPDATE "accounts" SET "subscription_expires_at" = $1, "updated_at" = $2 WHERE "accounts"."id" = $3 [["subscription_expires_at", 2017-04-17 00:04:49 UTC], ["updated_at", 2017-04-10 00:04:50 UTC], ["id", 44]] | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] (1.2ms) COMMIT | |
web_1 | [f3a6e3db-e6cc-414f-93d4-afc42e1cdfe5] method=GET path=/api/subscriptions/44 format=html controller=Api::SubscriptionsController action=show status=200 duration=17.65 view=0.46 db=3.79 | |
sidekiq_1 | [httplog] POST https://mstdn.io/api/salmon/11277 completed with status code 201 in 0.6101677929982543 seconds | |
sidekiq_1 | 2017-04-10T00:04:51.161Z 1 TID-gnottqoj0 NotificationWorker JID-1b174ecd34b5f066d6d5908c INFO: done: 0.635 sec | |
sidekiq_1 | [httplog] HEAD https://mstdn.io/users/jcape.atom completed with status code 200 in 0.6336732559975644 seconds | |
sidekiq_1 | Remote status HEAD request returned code 200 | |
sidekiq_1 | Remote status GET request returned code 200 | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] User Load (2.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] Doorkeeper::AccessToken Load (0.5ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] Account Load (0.9ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] (0.5ms) SELECT "follows"."target_account_id" FROM "follows" WHERE "follows"."target_account_id" = 44 AND "follows"."account_id" = $1 [["account_id", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] (0.5ms) SELECT "follows"."account_id" FROM "follows" WHERE "follows"."account_id" = 44 AND "follows"."target_account_id" = $1 [["target_account_id", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] (0.5ms) SELECT "blocks"."target_account_id" FROM "blocks" WHERE "blocks"."target_account_id" = 44 AND "blocks"."account_id" = $1 [["account_id", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] (0.6ms) SELECT "mutes"."target_account_id" FROM "mutes" WHERE "mutes"."target_account_id" = 44 AND "mutes"."account_id" = $1 [["account_id", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] (0.7ms) SELECT "follow_requests"."target_account_id" FROM "follow_requests" WHERE "follow_requests"."target_account_id" = 44 AND "follow_requests"."account_id" = $1 [["account_id", 1]] | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] Account Load (0.4ms) SELECT "accounts"."id" FROM "accounts" WHERE "accounts"."id" = 44 | |
web_1 | [3876faed-4316-459e-b203-4e29aad21da9] method=GET path=/api/v1/accounts/relationships format=html controller=Api::V1::AccountsController action=relationships status=200 duration=38.17 view=4.88 db=7.52 | |
web_1 | [3bfd987b-7c6e-4d7d-82b4-8320230bb809] method=GET path=/.well-known/host-meta format=html controller=XrdController action=host_meta status=200 duration=4.17 view=1.36 db=0.00 | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Doorkeeper::AccessToken Load (0.4ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
streaming_1 | verb c220fc51-323d-45d8-b7aa-354b77d25436 Starting stream from timeline:1 for 1 | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Notification Load (0.6ms) SELECT "notifications"."id", "notifications"."updated_at", "notifications"."activity_type", "notifications"."activity_id" FROM "notifications" WHERE "notifications"."account_id" = 1 AND ("notifications"."activity_type" != 'FollowRequest') ORDER BY "notifications"."id" DESC LIMIT $1 [["LIMIT", 15]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] User Load (3.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Account Load (3.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [2a2a3f82-32de-4e0c-ab6e-0690d1c0e438] User Load (7.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] User Load (1.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
sidekiq_1 | [httplog] GET https://mstdn.io/users/jcape.atom completed with status code 200 in 0.60855607099802 seconds | |
sidekiq_1 | Going to webfinger jcape@mstdn.io | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Doorkeeper::AccessToken Load (7.9ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
web_1 | [2a2a3f82-32de-4e0c-ab6e-0690d1c0e438] Account Load (4.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
sidekiq_1 | Account Load (1.0ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'jcape') AND (lower(accounts.domain) = 'mstdn.io') LIMIT $1 [["LIMIT", 1]] | |
sidekiq_1 | 2017-04-10T00:04:51.804Z 1 TID-gnottqbd4 AfterRemoteFollowWorker JID-96de3869f4859d98ec06af83 INFO: done: 1.277 sec | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Account Load (1.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Status Load (3.0ms) SELECT "statuses"."id", "statuses"."updated_at" FROM "statuses" WHERE "statuses"."id" IN (86, 84, 76, 73, 68, 63, 55, 45, 43, 39, 38, 35, 34, 32, 31, 30, 25, 21, 20, 19) ORDER BY id desc | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Account Load (0.9ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" IN (38, 37, 24, 23, 14, 13, 12, 11, 3, 7, 5, 4) | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Doorkeeper::AccessToken Load (6.2ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Status Load (0.5ms) SELECT "statuses"."reblog_of_id" FROM "statuses" WHERE ("statuses"."reblog_of_id" IN (35, 72, 3, 13, 8) OR "statuses"."reblog_of_id" IS NULL) AND "statuses"."account_id" = 1 ORDER BY id desc | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Favourite Load (0.4ms) SELECT "favourites"."status_id" FROM "favourites" WHERE ("favourites"."status_id" IN (35, 72, 3, 13, 8) OR "favourites"."status_id" IS NULL) AND "favourites"."account_id" = 1 | |
web_1 | [2a2a3f82-32de-4e0c-ab6e-0690d1c0e438] Doorkeeper::AccessToken Load (7.5ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 [["token", "c0155f3d87cb61358444d3011c273810b3fe46e3253bf8287dac770506bbaf19"], ["LIMIT", 1]] | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Account Load (35.2ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
web_1 | [2a2a3f82-32de-4e0c-ab6e-0690d1c0e438] Account Load (6.4ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 44], ["LIMIT", 1]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Account Load (7.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" IN (1, 18, 41, 26, 39, 16, 29, 28, 25, 23, 3, 11) | |
web_1 | [2a2a3f82-32de-4e0c-ab6e-0690d1c0e438] method=GET path=/api/v1/accounts/44 format=html controller=Api::V1::AccountsController action=show status=200 duration=83.19 view=4.20 db=25.55 | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Account Exists (15.1ms) SELECT 1 AS one FROM "accounts" INNER JOIN "blocks" ON "accounts"."id" = "blocks"."target_account_id" WHERE "blocks"."account_id" = $1 AND "accounts"."id" = $2 LIMIT $3 [["account_id", 44], ["id", 1], ["LIMIT", 1]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Status Load (1.7ms) SELECT "statuses"."reblog_of_id" FROM "statuses" WHERE ("statuses"."reblog_of_id" IN (86, 84, 85, 76, 73, 68, 69, 63, 55, 45, 43, 44, 39, 40, 38, 35, 34, 32, 33, 31, 3, 30, 25, 21, 22, 20, 19) OR "statuses"."reblog_of_id" IS NULL) AND "statuses"."account_id" = 1 ORDER BY id desc | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Account Exists (1.5ms) SELECT 1 AS one FROM "accounts" INNER JOIN "follows" ON "accounts"."id" = "follows"."target_account_id" WHERE "follows"."account_id" = $1 AND "accounts"."id" = $2 LIMIT $3 [["account_id", 1], ["id", 44], ["LIMIT", 1]] | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] Favourite Load (1.5ms) SELECT "favourites"."status_id" FROM "favourites" WHERE ("favourites"."status_id" IN (86, 84, 85, 76, 73, 68, 69, 63, 55, 45, 43, 44, 39, 40, 38, 35, 34, 32, 33, 31, 3, 30, 25, 21, 22, 20, 19) OR "favourites"."status_id" IS NULL) AND "favourites"."account_id" = 1 | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] Account Load (0.9ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'cuemacro') AND "accounts"."domain" IS NULL LIMIT $1 [["LIMIT", 1]] | |
web_1 | [d3d44ad2-eedb-4146-ad10-c70f31c76fdf] method=GET path=/api/v1/notifications format=html controller=Api::V1::NotificationsController action=index status=200 duration=141.21 view=80.09 db=4.94 | |
web_1 | [b46ab49b-8f39-43c4-8d3f-036c15f912d6] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [b46ab49b-8f39-43c4-8d3f-036c15f912d6] Account Load (0.3ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [b46ab49b-8f39-43c4-8d3f-036c15f912d6] method=GET path=/system/accounts/avatars/000/000/044/original/e306225381720abd.jpg format=jpeg controller=ApplicationController action=raise_not_found status=404 duration=6.60 view=0.00 db=1.07 | |
web_1 | [f82c4fb4-97c6-4ef3-8fa7-b54fe4613ab9] User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [f82c4fb4-97c6-4ef3-8fa7-b54fe4613ab9] Account Load (0.7ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [f82c4fb4-97c6-4ef3-8fa7-b54fe4613ab9] method=GET path=/system/accounts/headers/000/000/044/original/missing.png format=png controller=ApplicationController action=raise_not_found status=404 duration=15.80 view=0.00 db=1.39 | |
web_1 | [f25a1f60-18a5-48a5-8cb1-5450b1138ba1] method=GET path=/api/v1/timelines/home format=html controller=Api::V1::TimelinesController action=home status=200 duration=387.67 view=281.25 db=28.67 | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Status Load (283.9ms) SELECT "statuses"."id", "statuses"."updated_at" FROM "statuses" LEFT OUTER JOIN mentions ON statuses.id = mentions.status_id AND mentions.account_id = 1 WHERE "statuses"."account_id" = $1 AND (statuses.visibility != 3 OR mentions.id IS NOT NULL) ORDER BY id desc, "statuses"."id" DESC LIMIT $2 [["account_id", 44], ["LIMIT", 20]] | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Account Load (1.2ms) SELECT "accounts".* FROM "accounts" WHERE 1=0 | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Status Load (0.4ms) SELECT "statuses"."reblog_of_id" FROM "statuses" WHERE 1=0 AND "statuses"."account_id" = 1 ORDER BY id desc | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] Favourite Load (0.3ms) SELECT "favourites"."status_id" FROM "favourites" WHERE 1=0 AND "favourites"."account_id" = 1 | |
web_1 | [422416ff-f279-4bbb-909a-d1e8e2c14e52] method=GET path=/api/v1/accounts/44/statuses format=html controller=Api::V1::AccountsController action=statuses status=200 duration=383.44 view=1.15 db=347.28 | |
web_1 | [dcbfb244-004b-446a-b06c-9b0c950bd4c1] Account Load (1.0ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'guan') AND "accounts"."domain" IS NULL LIMIT $1 [["LIMIT", 1]] | |
web_1 | [dcbfb244-004b-446a-b06c-9b0c950bd4c1] method=GET path=/.well-known/webfinger format=html controller=XrdController action=webfinger status=200 duration=11.53 view=2.79 db=1.02 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Account Load (1.1ms) SELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'guan') AND "accounts"."domain" IS NULL LIMIT $1 [["LIMIT", 1]] | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] StreamEntry Load (1.0ms) SELECT "stream_entries".* FROM "stream_entries" WHERE "stream_entries"."activity_type" = $1 AND "stream_entries"."account_id" = $2 AND "stream_entries"."hidden" = $3 ORDER BY id desc, "stream_entries"."id" DESC LIMIT $4 [["activity_type", "Status"], ["account_id", 1], ["hidden", false], ["LIMIT", 20]] | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Status Load (1.0ms) SELECT "statuses".* FROM "statuses" WHERE "statuses"."id" IN (86, 35, 25, 23, 15, 12, 9, 6, 5, 3) ORDER BY id desc | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = 1 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] MediaAttachment Load (0.5ms) SELECT "media_attachments".* FROM "media_attachments" WHERE "media_attachments"."status_id" IN (86, 35, 25, 23, 9, 6, 5, 3) ORDER BY id asc | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] HABTM_Tags Load (0.4ms) SELECT "statuses_tags".* FROM "statuses_tags" WHERE "statuses_tags"."status_id" IN (86, 35, 25, 23, 9, 6, 5, 3) | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Tag Load (0.4ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = 1 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Mention Load (0.5ms) SELECT "mentions".* FROM "mentions" WHERE "mentions"."status_id" IN (86, 35, 25, 23, 9, 6, 5, 3) | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Account Load (0.7ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" IN (5, 2, 37) | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Status Load (0.5ms) SELECT "statuses".* FROM "statuses" WHERE "statuses"."id" = 22 ORDER BY id desc | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] StreamEntry Load (0.5ms) SELECT "stream_entries".* FROM "stream_entries" WHERE "stream_entries"."activity_type" = $1 AND "stream_entries"."activity_id" = 22 [["activity_type", "Status"]] | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = 16 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] MediaAttachment Load (0.5ms) SELECT "media_attachments".* FROM "media_attachments" WHERE "media_attachments"."status_id" = 22 ORDER BY id asc | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] HABTM_Tags Load (0.4ms) SELECT "statuses_tags".* FROM "statuses_tags" WHERE "statuses_tags"."status_id" = 22 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Mention Load (0.3ms) SELECT "mentions".* FROM "mentions" WHERE "mentions"."status_id" = 22 | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Status Load (0.5ms) SELECT "statuses".* FROM "statuses" WHERE "statuses"."id" IN (72, 16, 4) ORDER BY id desc | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] StreamEntry Load (0.4ms) SELECT "stream_entries".* FROM "stream_entries" WHERE "stream_entries"."activity_type" = $1 AND "stream_entries"."activity_id" IN (72, 16, 4) [["activity_type", "Status"]] | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" IN (37, 2, 5) | |
web_1 | [fcfe26d6-b976-4736-89ba-be626e83a92d] method=GET path=/users/guan.atom format=atom controller=AccountsController action=show status=200 duration=133.13 view=0.22 db=15.18 | |
web_1 | [6da1b9b0-96f2-490c-8d4c-de7de6537c71] User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [6da1b9b0-96f2-490c-8d4c-de7de6537c71] Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] | |
web_1 | [6da1b9b0-96f2-490c-8d4c-de7de6537c71] method=GET path=/system/accounts/avatars/000/000/044/original/e306225381720abd.jpg format=jpeg controller=ApplicationController action=raise_not_found status=404 duration=13.03 view=0.00 db=1.68 | |
r |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment