Beginners Guide to Install Discourse on Ubuntu for Development

@featheredtoast FYI :pleading_face::innocent:

1 Like

Hey there - I’m assuming you’re running your dev env against unicorn (eg: bin/unicorn rather than bundle exec rails server? I recently changed the defaults in dev environments to ensure that they bind to localhost (this was not happening previously; --binding=0.0.0.0 I believe is puma not unicorn). To bind to all interfaces under that env, you’ll need to set an env var explicitly: UNICORN_BIND_ALL=true

3 Likes

No, I’m following the instructions in the OP, which use bundle exec rails server --binding=0.0.0.0 to start the instance.

Not sure, That still works for me. What is your output when you start this? Can you confirm that the “listening on” line looks like this?

Puma starting in single mode...
* Version 3.12.1 (ruby 2.6.1-p33), codename: Llamas in Pajamas
* Min threads: 0, max threads: 16
* Environment: development
* Listening on tcp://0.0.0.0:3000
3 Likes

Quite a lot:

dan@ubuntu:~/discourse$ bundle exec rails server --binding=0.0.0.0
I, [2019-10-30T17:07:06.180281 #73939]  INFO -- : Refreshing Gem list
Starting CSS change watcher
   (0.7ms)  SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'en'
DEPRECATION WARNING: Initialization autoloaded the constants Migration::SafeMigrate, SiteSettings, SiteSettings::DeprecatedSettings, SiteSettingExtension, SiteSettings::YamlLoader, SiteSettings::DefaultsProvider, SiteSettings::Validations, SiteSettings::TypeSupervisor, Enum, RegexSettingValidation, StringSettingValidator, EmailSettingValidator, UsernameSettingValidator, GroupSettingValidator, AllowUserLocaleEnabledValidator, IntegerSettingValidator, RegexPresenceValidator, CategoryPageStyle, EnableInviteOnlyValidator, EnableLocalLoginsViaEmailValidator, EnableSsoValidator, SsoOverridesEmailValidator, MinUsernameLengthValidator, MaxUsernameLengthValidator, UnicodeUsernameValidator, UnicodeUsernameWhitelistValidator, TrustLevelSetting, EnablePrivateEmailMessagesValidator, MarkdownTypographerQuotationMarksValidator, EmojiSetSiteSetting, ReplyByEmailEnabledValidator, ReplyByEmailAddressValidator, AlternativeReplyByEmailAddressesValidator, POP3PollingEnabledSettingValidator, S3RegionSiteSetting, ExternalSystemAvatarsValidator, ColorListValidator, ReviewableSensitivitySetting, ReviewablePrioritySetting, BackupLocationSiteSetting, CategorySearchPriorityWeightsValidator, SlugSetting, DigestEmailSiteSetting, EmailLevelSiteSetting, MailingListModeSiteSetting, PreviousRepliesSiteSetting, NewTopicDurationSiteSetting, AutoTrackDurationSiteSetting, NotificationLevelWhenReplyingSiteSetting, LikeNotificationFrequencySiteSetting, TrustLevelAndStaffSetting, RemoveMutedTagsFromLatestSiteSetting, SiteSetting, SiteSettings::DbProvider, Site, Searchable, Roleable, HasCustomFields, SecondFactorManager, HasDestroyedWebHook, UserFullNameValidator, AllowedIpAddressValidator, User, MobileDetection, CrawlerDetection, Guardian, TwitterApi, Email, Email::BuildEmailHelper, TranslationOverride, and LocaleSiteSetting.

Being able to do this is deprecated. Autoloading during initialization is going
to be an error condition in future versions of Rails.

Reloading does not reboot the application, and therefore code executed during
initialization does not run again. So, if you reload Migration::SafeMigrate, for example,
the expected changes won't be reflected in that stale Class object.

These autoloaded constants have been unloaded.

Please, check the "Autoloading and Reloading Constants" guide for solutions.
 (called from <top (required)> at /home/dan/discourse/config/environment.rb:7)
Creating scope :open. Overwriting existing method Poll.open.
I, [2019-10-30T17:07:09.564131 #73939]  INFO -- : listening on addr=127.0.0.1:3000 fd=29
  User Load (1.2ms)  SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1
  Poll Load (0.7ms)  SELECT "polls".* FROM "polls" ORDER BY "polls"."id" ASC LIMIT 1
  PollOption Load (0.5ms)  SELECT "poll_options".* FROM "poll_options" ORDER BY "poll_options"."id" ASC LIMIT 1
  PollVote Load (0.8ms)  SELECT "poll_votes".* FROM "poll_votes" LIMIT 1
  UserFieldOption Load (0.4ms)  SELECT "user_field_options".* FROM "user_field_options" ORDER BY "user_field_options"."id" ASC LIMIT 1
  TopicLink Load (0.7ms)  SELECT "topic_links".* FROM "topic_links" ORDER BY "topic_links"."id" ASC LIMIT 1
  Upload Load (0.7ms)  SELECT "uploads".* FROM "uploads" ORDER BY "uploads"."id" ASC LIMIT 1
  PostTiming Load (0.4ms)  SELECT "post_timings".* FROM "post_timings" LIMIT 1
  TopicUser Load (0.5ms)  SELECT "topic_users".* FROM "topic_users" ORDER BY "topic_users"."id" ASC LIMIT 1
  Notification Load (0.8ms)  SELECT "notifications".* FROM "notifications" ORDER BY "notifications"."id" ASC LIMIT 1
  PostStat Load (0.5ms)  SELECT "post_stats".* FROM "post_stats" ORDER BY "post_stats"."id" ASC LIMIT 1
  EmbeddableHost Load (0.4ms)  SELECT "embeddable_hosts".* FROM "embeddable_hosts" ORDER BY "embeddable_hosts"."id" ASC LIMIT 1
  UserProfileView Load (0.5ms)  SELECT "user_profile_views".* FROM "user_profile_views" ORDER BY "user_profile_views"."id" ASC LIMIT 1
  GroupMention Load (0.5ms)  SELECT "group_mentions".* FROM "group_mentions" ORDER BY "group_mentions"."id" ASC LIMIT 1
  UserArchivedMessage Load (0.4ms)  SELECT "user_archived_messages".* FROM "user_archived_messages" ORDER BY "user_archived_messages"."id" ASC LIMIT 1
  GroupArchivedMessage Load (0.4ms)  SELECT "group_archived_messages".* FROM "group_archived_messages" ORDER BY "group_archived_messages"."id" ASC LIMIT 1
  Post Load (1.2ms)  SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) ORDER BY "posts"."id" ASC LIMIT 1
  PostReply Load (0.4ms)  SELECT "post_replies".* FROM "post_replies" LIMIT 1
  InstagramUserInfo Load (0.4ms)  SELECT "instagram_user_infos".* FROM "instagram_user_infos" ORDER BY "instagram_user_infos"."id" ASC LIMIT 1
  Topic Load (1.4ms)  SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) ORDER BY "topics"."id" ASC LIMIT 1
  SiteSetting Load (0.5ms)  SELECT "site_settings".* FROM "site_settings" ORDER BY "site_settings"."id" ASC LIMIT 1
  UserOpenId Load (0.4ms)  SELECT "user_open_ids".* FROM "user_open_ids" ORDER BY "user_open_ids"."id" ASC LIMIT 1
  CategoryFeaturedTopic Load (0.5ms)  SELECT "category_featured_topics".* FROM "category_featured_topics" ORDER BY "category_featured_topics"."id" ASC LIMIT 1
  IncomingLink Load (0.5ms)  SELECT "incoming_links".* FROM "incoming_links" ORDER BY "incoming_links"."id" ASC LIMIT 1
  Category Load (1.3ms)  SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."suppress_from_latest", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id" FROM "categories" ORDER BY "categories"."id" ASC LIMIT 1
  EmailChangeRequest Load (0.5ms)  SELECT "email_change_requests".* FROM "email_change_requests" ORDER BY "email_change_requests"."id" ASC LIMIT 1
  GivenDailyLike Load (0.4ms)  SELECT "given_daily_likes".* FROM "given_daily_likes" LIMIT 1
  OnceoffLog Load (0.4ms)  SELECT "onceoff_logs".* FROM "onceoff_logs" ORDER BY "onceoff_logs"."id" ASC LIMIT 1
  TranslationOverride Load (0.4ms)  SELECT "translation_overrides".* FROM "translation_overrides" ORDER BY "translation_overrides"."id" ASC LIMIT 1
  IncomingEmail Load (0.6ms)  SELECT "incoming_emails".* FROM "incoming_emails" ORDER BY "incoming_emails"."id" ASC LIMIT 1
  PostActionType Load (0.5ms)  SELECT "post_action_types".* FROM "post_action_types" ORDER BY "post_action_types"."id" ASC LIMIT 1
  UserOption Load (0.7ms)  SELECT "user_options".* FROM "user_options" ORDER BY "user_options"."user_id" ASC LIMIT 1
  TopicLinkClick Load (0.4ms)  SELECT "topic_link_clicks".* FROM "topic_link_clicks" ORDER BY "topic_link_clicks"."id" ASC LIMIT 1
  PostAction Load (0.8ms)  SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) ORDER BY "post_actions"."id" ASC LIMIT 1
  UserAction Load (0.7ms)  SELECT "user_actions"."id", "user_actions"."action_type", "user_actions"."user_id", "user_actions"."target_topic_id", "user_actions"."target_post_id", "user_actions"."target_user_id", "user_actions"."acting_user_id", "user_actions"."created_at", "user_actions"."updated_at" FROM "user_actions" ORDER BY "user_actions"."id" ASC LIMIT 1
  TopicTag Load (0.4ms)  SELECT "topic_tags".* FROM "topic_tags" ORDER BY "topic_tags"."id" ASC LIMIT 1
  TagUser Load (0.5ms)  SELECT "tag_users".* FROM "tag_users" ORDER BY "tag_users"."id" ASC LIMIT 1
  CategoryTag Load (0.5ms)  SELECT "category_tags".* FROM "category_tags" ORDER BY "category_tags"."id" ASC LIMIT 1
  Tag Load (1.5ms)  SELECT "tags".* FROM "tags" ORDER BY "tags"."id" ASC LIMIT 1
  TagGroup Load (1.0ms)  SELECT "tag_groups".* FROM "tag_groups" ORDER BY "tag_groups"."id" ASC LIMIT 1
  TagGroupMembership Load (0.5ms)  SELECT "tag_group_memberships".* FROM "tag_group_memberships" ORDER BY "tag_group_memberships"."id" ASC LIMIT 1
  CategoryTagGroup Load (1.2ms)  SELECT "category_tag_groups".* FROM "category_tag_groups" ORDER BY "category_tag_groups"."id" ASC LIMIT 1
  TopicAllowedUser Load (0.5ms)  SELECT "topic_allowed_users".* FROM "topic_allowed_users" ORDER BY "topic_allowed_users"."id" ASC LIMIT 1
  Developer Load (1.3ms)  SELECT "developers".* FROM "developers" ORDER BY "developers"."id" ASC LIMIT 1
  EmailLog Load (1.7ms)  SELECT "email_logs".* FROM "email_logs" ORDER BY "email_logs"."id" ASC LIMIT 1
  UserApiKey Load (0.6ms)  SELECT "user_api_keys".* FROM "user_api_keys" ORDER BY "user_api_keys"."id" ASC LIMIT 1
  Draft Load (0.4ms)  SELECT "drafts".* FROM "drafts" ORDER BY "drafts"."id" ASC LIMIT 1
  WebHookEventType Load (0.8ms)  SELECT "web_hook_event_types".* FROM "web_hook_event_types" ORDER BY id ASC LIMIT 1
  EmailToken Load (0.5ms)  SELECT "email_tokens".* FROM "email_tokens" ORDER BY "email_tokens"."id" ASC LIMIT 1
  WebHook Load (1.4ms)  SELECT "web_hooks".* FROM "web_hooks" ORDER BY id ASC LIMIT 1
  WebHookEvent Load (2.2ms)  SELECT "web_hook_events".* FROM "web_hook_events" ORDER BY created_at DESC LIMIT 1
  TopicInvite Load (1.8ms)  SELECT "topic_invites".* FROM "topic_invites" ORDER BY "topic_invites"."id" ASC LIMIT 1
  UserVisit Load (1.0ms)  SELECT "user_visits".* FROM "user_visits" ORDER BY "user_visits"."id" ASC LIMIT 1
  DraftSequence Load (0.4ms)  SELECT "draft_sequences".* FROM "draft_sequences" ORDER BY "draft_sequences"."id" ASC LIMIT 1
  Invite Load (0.6ms)  SELECT "invites"."id", "invites"."invite_key", "invites"."email", "invites"."invited_by_id", "invites"."user_id", "invites"."redeemed_at", "invites"."created_at", "invites"."updated_at", "invites"."deleted_at", "invites"."deleted_by_id", "invites"."invalidated_at", "invites"."moderator", "invites"."custom_message", "invites"."emailed_status" FROM "invites" WHERE ("invites"."deleted_at" IS NULL) ORDER BY "invites"."id" ASC LIMIT 1
  GroupHistory Load (1.2ms)  SELECT "group_histories".* FROM "group_histories" ORDER BY "group_histories"."id" ASC LIMIT 1
  GithubUserInfo Load (0.7ms)  SELECT "github_user_infos".* FROM "github_user_infos" ORDER BY "github_user_infos"."id" ASC LIMIT 1
  UserHistory Load (0.7ms)  SELECT "user_histories".* FROM "user_histories" ORDER BY "user_histories"."id" ASC LIMIT 1
  GroupUser Load (0.5ms)  SELECT "group_users".* FROM "group_users" ORDER BY "group_users"."id" ASC LIMIT 1
  TopicAllowedGroup Load (0.4ms)  SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" ORDER BY "topic_allowed_groups"."id" ASC LIMIT 1
  CustomEmoji Load (0.4ms)  SELECT "custom_emojis".* FROM "custom_emojis" ORDER BY "custom_emojis"."id" ASC LIMIT 1
  UserAuthToken Load (0.5ms)  SELECT "user_auth_tokens".* FROM "user_auth_tokens" ORDER BY "user_auth_tokens"."id" ASC LIMIT 1
  CategoryGroup Load (0.5ms)  SELECT "category_groups".* FROM "category_groups" ORDER BY "category_groups"."id" ASC LIMIT 1
  Group Load (0.7ms)  SELECT "groups".* FROM "groups" ORDER BY "groups"."id" ASC LIMIT 1
  UserAuthTokenLog Load (0.5ms)  SELECT "user_auth_token_logs".* FROM "user_auth_token_logs" ORDER BY "user_auth_token_logs"."id" ASC LIMIT 1
  OptimizedImage Load (0.5ms)  SELECT "optimized_images".* FROM "optimized_images" ORDER BY "optimized_images"."id" ASC LIMIT 1
  ScreenedEmail Load (0.5ms)  SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."id" ASC LIMIT 1
  PostUpload Load (0.5ms)  SELECT "post_uploads".* FROM "post_uploads" ORDER BY "post_uploads"."id" ASC LIMIT 1
  Oauth2UserInfo Load (0.5ms)  SELECT "oauth2_user_infos".* FROM "oauth2_user_infos" ORDER BY "oauth2_user_infos"."id" ASC LIMIT 1
  ScreenedUrl Load (0.5ms)  SELECT "screened_urls".* FROM "screened_urls" ORDER BY "screened_urls"."id" ASC LIMIT 1
  PluginStoreRow Load (1.6ms)  SELECT "plugin_store_rows".* FROM "plugin_store_rows" ORDER BY "plugin_store_rows"."id" ASC LIMIT 1
  ApiKey Load (0.5ms)  SELECT "api_keys".* FROM "api_keys" ORDER BY "api_keys"."id" ASC LIMIT 1
  ChildTheme Load (0.7ms)  SELECT "child_themes".* FROM "child_themes" ORDER BY "child_themes"."id" ASC LIMIT 1
  PostDetail Load (0.5ms)  SELECT "post_details".* FROM "post_details" ORDER BY "post_details"."id" ASC LIMIT 1
  ScreenedIpAddress Load (0.5ms)  SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" ORDER BY "screened_ip_addresses"."id" ASC LIMIT 1
  TopicTimer Load (1.6ms)  SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) ORDER BY "topic_timers"."id" ASC LIMIT 1
  Theme Load (0.6ms)  SELECT "themes".* FROM "themes" ORDER BY "themes"."id" ASC LIMIT 1
  PostRevision Load (0.5ms)  SELECT "post_revisions".* FROM "post_revisions" ORDER BY "post_revisions"."id" ASC LIMIT 1
  CategoryUser Load (0.5ms)  SELECT "category_users".* FROM "category_users" ORDER BY "category_users"."id" ASC LIMIT 1
  TopicEmbed Load (0.5ms)  SELECT "topic_embeds".* FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) ORDER BY "topic_embeds"."id" ASC LIMIT 1
  SingleSignOnRecord Load (1.3ms)  SELECT "single_sign_on_records".* FROM "single_sign_on_records" ORDER BY "single_sign_on_records"."id" ASC LIMIT 1
  RemoteTheme Load (0.5ms)  SELECT "remote_themes".* FROM "remote_themes" ORDER BY "remote_themes"."id" ASC LIMIT 1
  BadgeType Load (1.6ms)  SELECT "badge_types".* FROM "badge_types" ORDER BY "badge_types"."id" ASC LIMIT 1
  ColorScheme Load (0.5ms)  SELECT "color_schemes".* FROM "color_schemes" ORDER BY "color_schemes"."id" ASC LIMIT 1
  ThemeField Load (0.5ms)  SELECT "theme_fields".* FROM "theme_fields" ORDER BY "theme_fields"."id" ASC LIMIT 1
  ColorSchemeColor Load (0.4ms)  SELECT "color_scheme_colors".* FROM "color_scheme_colors" ORDER BY "color_scheme_colors"."id" ASC LIMIT 1
  UserBadge Load (0.6ms)  SELECT "user_badges".* FROM "user_badges" ORDER BY "user_badges"."id" ASC LIMIT 1
  UserCustomField Load (0.5ms)  SELECT "user_custom_fields".* FROM "user_custom_fields" ORDER BY "user_custom_fields"."id" ASC LIMIT 1
  CategoryCustomField Load (0.5ms)  SELECT "category_custom_fields".* FROM "category_custom_fields" ORDER BY "category_custom_fields"."id" ASC LIMIT 1
  GroupCustomField Load (0.4ms)  SELECT "group_custom_fields".* FROM "group_custom_fields" ORDER BY "group_custom_fields"."id" ASC LIMIT 1
  PostCustomField Load (0.9ms)  SELECT "post_custom_fields".* FROM "post_custom_fields" ORDER BY "post_custom_fields"."id" ASC LIMIT 1
  TopicCustomField Load (0.5ms)  SELECT "topic_custom_fields".* FROM "topic_custom_fields" ORDER BY "topic_custom_fields"."id" ASC LIMIT 1
  WatchedWord Load (0.5ms)  SELECT "watched_words".* FROM "watched_words" ORDER BY "watched_words"."id" ASC LIMIT 1
  InvitedGroup Load (0.4ms)  SELECT "invited_groups".* FROM "invited_groups" ORDER BY "invited_groups"."id" ASC LIMIT 1
  Badge Load (0.8ms)  SELECT "badges".* FROM "badges" ORDER BY "badges"."id" ASC LIMIT 1
  UserAvatar Load (0.5ms)  SELECT "user_avatars".* FROM "user_avatars" ORDER BY "user_avatars"."id" ASC LIMIT 1
  UserEmail Load (0.6ms)  SELECT "user_emails".* FROM "user_emails" ORDER BY "user_emails"."id" ASC LIMIT 1
  SearchLog Load (0.6ms)  SELECT "search_logs".* FROM "search_logs" ORDER BY "search_logs"."id" ASC LIMIT 1
  QuotedPost Load (0.5ms)  SELECT "quoted_posts".* FROM "quoted_posts" ORDER BY "quoted_posts"."id" ASC LIMIT 1
  BadgeGrouping Load (0.4ms)  SELECT "badge_groupings".* FROM "badge_groupings" ORDER BY "badge_groupings"."id" ASC LIMIT 1
  IncomingReferer Load (0.5ms)  SELECT "incoming_referers".* FROM "incoming_referers" ORDER BY "incoming_referers"."id" ASC LIMIT 1
  IncomingDomain Load (0.4ms)  SELECT "incoming_domains".* FROM "incoming_domains" ORDER BY "incoming_domains"."id" ASC LIMIT 1
  UserWarning Load (0.5ms)  SELECT "user_warnings".* FROM "user_warnings" ORDER BY "user_warnings"."id" ASC LIMIT 1
  UserExport Load (0.4ms)  SELECT "user_exports".* FROM "user_exports" ORDER BY "user_exports"."id" ASC LIMIT 1
  Permalink Load (0.5ms)  SELECT "permalinks".* FROM "permalinks" ORDER BY "permalinks"."id" ASC LIMIT 1
  UnsubscribeKey Load (0.7ms)  SELECT "unsubscribe_keys".* FROM "unsubscribe_keys" ORDER BY "unsubscribe_keys"."key" ASC LIMIT 1
  ApplicationRequest Load (0.4ms)  SELECT "application_requests".* FROM "application_requests" ORDER BY "application_requests"."id" ASC LIMIT 1
  UserField Load (0.4ms)  SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."id" ASC LIMIT 1
  UserSecondFactor Load (0.5ms)  SELECT "user_second_factors".* FROM "user_second_factors" ORDER BY "user_second_factors"."id" ASC LIMIT 1
  ThemeSetting Load (0.4ms)  SELECT "theme_settings".* FROM "theme_settings" ORDER BY "theme_settings"."id" ASC LIMIT 1
  CategoryTagStat Load (0.5ms)  SELECT "category_tag_stats".* FROM "category_tag_stats" ORDER BY "category_tag_stats"."id" ASC LIMIT 1
  TopTopic Load (1.4ms)  SELECT "top_topics".* FROM "top_topics" ORDER BY "top_topics"."id" ASC LIMIT 1
  WebCrawlerRequest Load (0.5ms)  SELECT "web_crawler_requests".* FROM "web_crawler_requests" ORDER BY "web_crawler_requests"."id" ASC LIMIT 1
  TagGroupPermission Load (0.4ms)  SELECT "tag_group_permissions".* FROM "tag_group_permissions" ORDER BY "tag_group_permissions"."id" ASC LIMIT 1
  SharedDraft Load (0.4ms)  SELECT "shared_drafts".* FROM "shared_drafts" ORDER BY "shared_drafts"."id" ASC LIMIT 1
  PushSubscription Load (0.4ms)  SELECT "push_subscriptions".* FROM "push_subscriptions" ORDER BY "push_subscriptions"."id" ASC LIMIT 1
  DirectoryItem Load (0.6ms)  SELECT "directory_items".* FROM "directory_items" ORDER BY "directory_items"."id" ASC LIMIT 1
  MutedUser Load (0.4ms)  SELECT "muted_users".* FROM "muted_users" ORDER BY "muted_users"."id" ASC LIMIT 1
  StylesheetCache Load (7.7ms)  SELECT "stylesheet_cache".* FROM "stylesheet_cache" ORDER BY "stylesheet_cache"."id" ASC LIMIT 1
  PostReplyKey Load (0.4ms)  SELECT "post_reply_keys".* FROM "post_reply_keys" ORDER BY "post_reply_keys"."id" ASC LIMIT 1
  SkippedEmailLog Load (0.5ms)  SELECT "skipped_email_logs".* FROM "skipped_email_logs" ORDER BY "skipped_email_logs"."id" ASC LIMIT 1
  UserUpload Load (0.4ms)  SELECT "user_uploads".* FROM "user_uploads" ORDER BY "user_uploads"."id" ASC LIMIT 1
  UserAssociatedAccount Load (0.5ms)  SELECT "user_associated_accounts".* FROM "user_associated_accounts" ORDER BY "user_associated_accounts"."id" ASC LIMIT 1
  ThemeTranslationOverride Load (0.4ms)  SELECT "theme_translation_overrides".* FROM "theme_translation_overrides" ORDER BY "theme_translation_overrides"."id" ASC LIMIT 1
  Reviewable Load (0.7ms)  SELECT "reviewables".* FROM "reviewables" ORDER BY "reviewables"."id" ASC LIMIT 1
  UserStat Load (0.5ms)  SELECT "user_stats".* FROM "user_stats" ORDER BY "user_stats"."user_id" ASC LIMIT 1
  ReviewableHistory Load (0.5ms)  SELECT "reviewable_histories".* FROM "reviewable_histories" ORDER BY "reviewable_histories"."id" ASC LIMIT 1
  GroupRequest Load (0.6ms)  SELECT "group_requests".* FROM "group_requests" ORDER BY "group_requests"."id" ASC LIMIT 1
  IgnoredUser Load (0.5ms)  SELECT "ignored_users".* FROM "ignored_users" ORDER BY "ignored_users"."id" ASC LIMIT 1
  ReviewableScore Load (0.6ms)  SELECT "reviewable_scores".* FROM "reviewable_scores" ORDER BY "reviewable_scores"."id" ASC LIMIT 1
  ReviewableClaimedTopic Load (0.4ms)  SELECT "reviewable_claimed_topics".* FROM "reviewable_claimed_topics" ORDER BY "reviewable_claimed_topics"."id" ASC LIMIT 1
  UserProfile Load (0.6ms)  SELECT "user_profiles"."user_id", "user_profiles"."location", "user_profiles"."website", "user_profiles"."bio_raw", "user_profiles"."bio_cooked", "user_profiles"."dismissed_banner_key", "user_profiles"."bio_cooked_version", "user_profiles"."badge_granted_title", "user_profiles"."views", "user_profiles"."profile_background_upload_id", "user_profiles"."card_background_upload_id" FROM "user_profiles" ORDER BY "user_profiles"."user_id" ASC LIMIT 1
  AnonymousUser Load (0.5ms)  SELECT "anonymous_users".* FROM "anonymous_users" ORDER BY "anonymous_users"."id" ASC LIMIT 1
  TopicGroup Load (0.4ms)  SELECT "topic_groups".* FROM "topic_groups" ORDER BY "topic_groups"."id" ASC LIMIT 1
  UserSecurityKey Load (0.6ms)  SELECT "user_security_keys".* FROM "user_security_keys" ORDER BY "user_security_keys"."id" ASC LIMIT 1
  BackupDraftTopic Load (0.4ms)  SELECT "backup_draft_topics".* FROM "backup_draft_topics" ORDER BY "backup_draft_topics"."id" ASC LIMIT 1
  BackupDraftPost Load (0.4ms)  SELECT "backup_draft_posts".* FROM "backup_draft_posts" ORDER BY "backup_draft_posts"."id" ASC LIMIT 1
   (0.6ms)  SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'en'
  Permalink Exists? (0.7ms)  SELECT 1 AS one FROM "permalinks" WHERE "permalinks"."url" = 'abc' LIMIT 1
  Permalink Exists? (0.7ms)  SELECT 1 AS one FROM "permalinks" WHERE "permalinks"."url" = 'abc' LIMIT 1
Starting up 1 supervised sidekiqs
Loading Sidekiq in process id 74013
  User Load (1.5ms)  SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1
  Poll Load (2.5ms)  SELECT "polls".* FROM "polls" ORDER BY "polls"."id" ASC LIMIT 1
  PollOption Load (0.5ms)  SELECT "poll_options".* FROM "poll_options" ORDER BY "poll_options"."id" ASC LIMIT 1
  PollVote Load (0.9ms)  SELECT "poll_votes".* FROM "poll_votes" LIMIT 1
  UserFieldOption Load (0.8ms)  SELECT "user_field_options".* FROM "user_field_options" ORDER BY "user_field_options"."id" ASC LIMIT 1
  TopicLink Load (2.5ms)  SELECT "topic_links".* FROM "topic_links" ORDER BY "topic_links"."id" ASC LIMIT 1
  Upload Load (1.3ms)  SELECT "uploads".* FROM "uploads" ORDER BY "uploads"."id" ASC LIMIT 1
  PostTiming Load (0.9ms)  SELECT "post_timings".* FROM "post_timings" LIMIT 1
  TopicUser Load (0.9ms)  SELECT "topic_users".* FROM "topic_users" ORDER BY "topic_users"."id" ASC LIMIT 1
  Notification Load (1.5ms)  SELECT "notifications".* FROM "notifications" ORDER BY "notifications"."id" ASC LIMIT 1
  PostStat Load (0.8ms)  SELECT "post_stats".* FROM "post_stats" ORDER BY "post_stats"."id" ASC LIMIT 1
  EmbeddableHost Load (0.4ms)  SELECT "embeddable_hosts".* FROM "embeddable_hosts" ORDER BY "embeddable_hosts"."id" ASC LIMIT 1
  UserProfileView Load (0.9ms)  SELECT "user_profile_views".* FROM "user_profile_views" ORDER BY "user_profile_views"."id" ASC LIMIT 1
  GroupMention Load (0.8ms)  SELECT "group_mentions".* FROM "group_mentions" ORDER BY "group_mentions"."id" ASC LIMIT 1
  UserArchivedMessage Load (0.8ms)  SELECT "user_archived_messages".* FROM "user_archived_messages" ORDER BY "user_archived_messages"."id" ASC LIMIT 1
  GroupArchivedMessage Load (1.0ms)  SELECT "group_archived_messages".* FROM "group_archived_messages" ORDER BY "group_archived_messages"."id" ASC LIMIT 1
  Post Load (3.1ms)  SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) ORDER BY "posts"."id" ASC LIMIT 1
  PostReply Load (0.6ms)  SELECT "post_replies".* FROM "post_replies" LIMIT 1
  InstagramUserInfo Load (1.0ms)  SELECT "instagram_user_infos".* FROM "instagram_user_infos" ORDER BY "instagram_user_infos"."id" ASC LIMIT 1
  Topic Load (2.0ms)  SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) ORDER BY "topics"."id" ASC LIMIT 1
  SiteSetting Load (0.6ms)  SELECT "site_settings".* FROM "site_settings" ORDER BY "site_settings"."id" ASC LIMIT 1
  UserOpenId Load (1.0ms)  SELECT "user_open_ids".* FROM "user_open_ids" ORDER BY "user_open_ids"."id" ASC LIMIT 1
  CategoryFeaturedTopic Load (0.6ms)  SELECT "category_featured_topics".* FROM "category_featured_topics" ORDER BY "category_featured_topics"."id" ASC LIMIT 1
  IncomingLink Load (1.0ms)  SELECT "incoming_links".* FROM "incoming_links" ORDER BY "incoming_links"."id" ASC LIMIT 1
  Category Load (1.7ms)  SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."suppress_from_latest", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id" FROM "categories" ORDER BY "categories"."id" ASC LIMIT 1
  EmailChangeRequest Load (1.0ms)  SELECT "email_change_requests".* FROM "email_change_requests" ORDER BY "email_change_requests"."id" ASC LIMIT 1
  GivenDailyLike Load (1.0ms)  SELECT "given_daily_likes".* FROM "given_daily_likes" LIMIT 1
  OnceoffLog Load (1.3ms)  SELECT "onceoff_logs".* FROM "onceoff_logs" ORDER BY "onceoff_logs"."id" ASC LIMIT 1
  TranslationOverride Load (0.6ms)  SELECT "translation_overrides".* FROM "translation_overrides" ORDER BY "translation_overrides"."id" ASC LIMIT 1
  IncomingEmail Load (0.7ms)  SELECT "incoming_emails".* FROM "incoming_emails" ORDER BY "incoming_emails"."id" ASC LIMIT 1
  PostActionType Load (0.6ms)  SELECT "post_action_types".* FROM "post_action_types" ORDER BY "post_action_types"."id" ASC LIMIT 1
  UserOption Load (0.9ms)  SELECT "user_options".* FROM "user_options" ORDER BY "user_options"."user_id" ASC LIMIT 1
  TopicLinkClick Load (0.6ms)  SELECT "topic_link_clicks".* FROM "topic_link_clicks" ORDER BY "topic_link_clicks"."id" ASC LIMIT 1
  PostAction Load (1.3ms)  SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) ORDER BY "post_actions"."id" ASC LIMIT 1
  UserAction Load (1.2ms)  SELECT "user_actions"."id", "user_actions"."action_type", "user_actions"."user_id", "user_actions"."target_topic_id", "user_actions"."target_post_id", "user_actions"."target_user_id", "user_actions"."acting_user_id", "user_actions"."created_at", "user_actions"."updated_at" FROM "user_actions" ORDER BY "user_actions"."id" ASC LIMIT 1
  TopicTag Load (0.8ms)  SELECT "topic_tags".* FROM "topic_tags" ORDER BY "topic_tags"."id" ASC LIMIT 1
  TagUser Load (0.9ms)  SELECT "tag_users".* FROM "tag_users" ORDER BY "tag_users"."id" ASC LIMIT 1
  CategoryTag Load (0.8ms)  SELECT "category_tags".* FROM "category_tags" ORDER BY "category_tags"."id" ASC LIMIT 1
  Tag Load (0.9ms)  SELECT "tags".* FROM "tags" ORDER BY "tags"."id" ASC LIMIT 1
  TagGroup Load (1.6ms)  SELECT "tag_groups".* FROM "tag_groups" ORDER BY "tag_groups"."id" ASC LIMIT 1
  TagGroupMembership Load (0.6ms)  SELECT "tag_group_memberships".* FROM "tag_group_memberships" ORDER BY "tag_group_memberships"."id" ASC LIMIT 1
  CategoryTagGroup Load (0.8ms)  SELECT "category_tag_groups".* FROM "category_tag_groups" ORDER BY "category_tag_groups"."id" ASC LIMIT 1
  TopicAllowedUser Load (0.8ms)  SELECT "topic_allowed_users".* FROM "topic_allowed_users" ORDER BY "topic_allowed_users"."id" ASC LIMIT 1
  Developer Load (1.0ms)  SELECT "developers".* FROM "developers" ORDER BY "developers"."id" ASC LIMIT 1
  EmailLog Load (1.2ms)  SELECT "email_logs".* FROM "email_logs" ORDER BY "email_logs"."id" ASC LIMIT 1
  UserApiKey Load (1.6ms)  SELECT "user_api_keys".* FROM "user_api_keys" ORDER BY "user_api_keys"."id" ASC LIMIT 1
  Draft Load (1.0ms)  SELECT "drafts".* FROM "drafts" ORDER BY "drafts"."id" ASC LIMIT 1
  WebHookEventType Load (1.3ms)  SELECT "web_hook_event_types".* FROM "web_hook_event_types" ORDER BY id ASC LIMIT 1
  EmailToken Load (0.9ms)  SELECT "email_tokens".* FROM "email_tokens" ORDER BY "email_tokens"."id" ASC LIMIT 1
  WebHook Load (0.8ms)  SELECT "web_hooks".* FROM "web_hooks" ORDER BY id ASC LIMIT 1
  WebHookEvent Load (1.4ms)  SELECT "web_hook_events".* FROM "web_hook_events" ORDER BY created_at DESC LIMIT 1
  TopicInvite Load (0.8ms)  SELECT "topic_invites".* FROM "topic_invites" ORDER BY "topic_invites"."id" ASC LIMIT 1
  UserVisit Load (0.8ms)  SELECT "user_visits".* FROM "user_visits" ORDER BY "user_visits"."id" ASC LIMIT 1
  DraftSequence Load (0.8ms)  SELECT "draft_sequences".* FROM "draft_sequences" ORDER BY "draft_sequences"."id" ASC LIMIT 1
  Invite Load (1.2ms)  SELECT "invites"."id", "invites"."invite_key", "invites"."email", "invites"."invited_by_id", "invites"."user_id", "invites"."redeemed_at", "invites"."created_at", "invites"."updated_at", "invites"."deleted_at", "invites"."deleted_by_id", "invites"."invalidated_at", "invites"."moderator", "invites"."custom_message", "invites"."emailed_status" FROM "invites" WHERE ("invites"."deleted_at" IS NULL) ORDER BY "invites"."id" ASC LIMIT 1
  GroupHistory Load (1.4ms)  SELECT "group_histories".* FROM "group_histories" ORDER BY "group_histories"."id" ASC LIMIT 1
  GithubUserInfo Load (1.2ms)  SELECT "github_user_infos".* FROM "github_user_infos" ORDER BY "github_user_infos"."id" ASC LIMIT 1
  UserHistory Load (1.6ms)  SELECT "user_histories".* FROM "user_histories" ORDER BY "user_histories"."id" ASC LIMIT 1
  GroupUser Load (0.7ms)  SELECT "group_users".* FROM "group_users" ORDER BY "group_users"."id" ASC LIMIT 1
  TopicAllowedGroup Load (1.5ms)  SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" ORDER BY "topic_allowed_groups"."id" ASC LIMIT 1
  CustomEmoji Load (0.9ms)  SELECT "custom_emojis".* FROM "custom_emojis" ORDER BY "custom_emojis"."id" ASC LIMIT 1
  UserAuthToken Load (0.8ms)  SELECT "user_auth_tokens".* FROM "user_auth_tokens" ORDER BY "user_auth_tokens"."id" ASC LIMIT 1
  CategoryGroup Load (1.3ms)  SELECT "category_groups".* FROM "category_groups" ORDER BY "category_groups"."id" ASC LIMIT 1
  Group Load (1.4ms)  SELECT "groups".* FROM "groups" ORDER BY "groups"."id" ASC LIMIT 1
  UserAuthTokenLog Load (0.7ms)  SELECT "user_auth_token_logs".* FROM "user_auth_token_logs" ORDER BY "user_auth_token_logs"."id" ASC LIMIT 1
  OptimizedImage Load (1.6ms)  SELECT "optimized_images".* FROM "optimized_images" ORDER BY "optimized_images"."id" ASC LIMIT 1
  ScreenedEmail Load (0.7ms)  SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."id" ASC LIMIT 1
  PostUpload Load (0.8ms)  SELECT "post_uploads".* FROM "post_uploads" ORDER BY "post_uploads"."id" ASC LIMIT 1
  Oauth2UserInfo Load (0.8ms)  SELECT "oauth2_user_infos".* FROM "oauth2_user_infos" ORDER BY "oauth2_user_infos"."id" ASC LIMIT 1
  ScreenedUrl Load (1.0ms)  SELECT "screened_urls".* FROM "screened_urls" ORDER BY "screened_urls"."id" ASC LIMIT 1
  PluginStoreRow Load (0.9ms)  SELECT "plugin_store_rows".* FROM "plugin_store_rows" ORDER BY "plugin_store_rows"."id" ASC LIMIT 1
  ApiKey Load (1.0ms)  SELECT "api_keys".* FROM "api_keys" ORDER BY "api_keys"."id" ASC LIMIT 1
  ChildTheme Load (0.8ms)  SELECT "child_themes".* FROM "child_themes" ORDER BY "child_themes"."id" ASC LIMIT 1
  PostDetail Load (0.7ms)  SELECT "post_details".* FROM "post_details" ORDER BY "post_details"."id" ASC LIMIT 1
  ScreenedIpAddress Load (1.2ms)  SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" ORDER BY "screened_ip_addresses"."id" ASC LIMIT 1
  TopicTimer Load (1.8ms)  SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) ORDER BY "topic_timers"."id" ASC LIMIT 1
  Theme Load (0.9ms)  SELECT "themes".* FROM "themes" ORDER BY "themes"."id" ASC LIMIT 1
  PostRevision Load (0.8ms)  SELECT "post_revisions".* FROM "post_revisions" ORDER BY "post_revisions"."id" ASC LIMIT 1
  CategoryUser Load (1.3ms)  SELECT "category_users".* FROM "category_users" ORDER BY "category_users"."id" ASC LIMIT 1
  TopicEmbed Load (1.4ms)  SELECT "topic_embeds".* FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) ORDER BY "topic_embeds"."id" ASC LIMIT 1
  SingleSignOnRecord Load (0.9ms)  SELECT "single_sign_on_records".* FROM "single_sign_on_records" ORDER BY "single_sign_on_records"."id" ASC LIMIT 1
  RemoteTheme Load (1.2ms)  SELECT "remote_themes".* FROM "remote_themes" ORDER BY "remote_themes"."id" ASC LIMIT 1
  BadgeType Load (1.3ms)  SELECT "badge_types".* FROM "badge_types" ORDER BY "badge_types"."id" ASC LIMIT 1
  ColorScheme Load (1.2ms)  SELECT "color_schemes".* FROM "color_schemes" ORDER BY "color_schemes"."id" ASC LIMIT 1
  ThemeField Load (0.9ms)  SELECT "theme_fields".* FROM "theme_fields" ORDER BY "theme_fields"."id" ASC LIMIT 1
  ColorSchemeColor Load (1.5ms)  SELECT "color_scheme_colors".* FROM "color_scheme_colors" ORDER BY "color_scheme_colors"."id" ASC LIMIT 1
  UserBadge Load (1.0ms)  SELECT "user_badges".* FROM "user_badges" ORDER BY "user_badges"."id" ASC LIMIT 1
  UserCustomField Load (1.2ms)  SELECT "user_custom_fields".* FROM "user_custom_fields" ORDER BY "user_custom_fields"."id" ASC LIMIT 1
  CategoryCustomField Load (0.7ms)  SELECT "category_custom_fields".* FROM "category_custom_fields" ORDER BY "category_custom_fields"."id" ASC LIMIT 1
  GroupCustomField Load (1.4ms)  SELECT "group_custom_fields".* FROM "group_custom_fields" ORDER BY "group_custom_fields"."id" ASC LIMIT 1
  PostCustomField Load (1.1ms)  SELECT "post_custom_fields".* FROM "post_custom_fields" ORDER BY "post_custom_fields"."id" ASC LIMIT 1
  TopicCustomField Load (0.9ms)  SELECT "topic_custom_fields".* FROM "topic_custom_fields" ORDER BY "topic_custom_fields"."id" ASC LIMIT 1
  WatchedWord Load (0.6ms)  SELECT "watched_words".* FROM "watched_words" ORDER BY "watched_words"."id" ASC LIMIT 1
  InvitedGroup Load (0.4ms)  SELECT "invited_groups".* FROM "invited_groups" ORDER BY "invited_groups"."id" ASC LIMIT 1
  Badge Load (1.2ms)  SELECT "badges".* FROM "badges" ORDER BY "badges"."id" ASC LIMIT 1
  UserAvatar Load (0.7ms)  SELECT "user_avatars".* FROM "user_avatars" ORDER BY "user_avatars"."id" ASC LIMIT 1
  UserEmail Load (1.1ms)  SELECT "user_emails".* FROM "user_emails" ORDER BY "user_emails"."id" ASC LIMIT 1
  SearchLog Load (0.6ms)  SELECT "search_logs".* FROM "search_logs" ORDER BY "search_logs"."id" ASC LIMIT 1
  QuotedPost Load (0.6ms)  SELECT "quoted_posts".* FROM "quoted_posts" ORDER BY "quoted_posts"."id" ASC LIMIT 1
  BadgeGrouping Load (1.0ms)  SELECT "badge_groupings".* FROM "badge_groupings" ORDER BY "badge_groupings"."id" ASC LIMIT 1
  IncomingReferer Load (0.8ms)  SELECT "incoming_referers".* FROM "incoming_referers" ORDER BY "incoming_referers"."id" ASC LIMIT 1
  IncomingDomain Load (1.0ms)  SELECT "incoming_domains".* FROM "incoming_domains" ORDER BY "incoming_domains"."id" ASC LIMIT 1
  UserWarning Load (0.8ms)  SELECT "user_warnings".* FROM "user_warnings" ORDER BY "user_warnings"."id" ASC LIMIT 1
  UserExport Load (0.7ms)  SELECT "user_exports".* FROM "user_exports" ORDER BY "user_exports"."id" ASC LIMIT 1
  Permalink Load (2.5ms)  SELECT "permalinks".* FROM "permalinks" ORDER BY "permalinks"."id" ASC LIMIT 1
  UnsubscribeKey Load (0.9ms)  SELECT "unsubscribe_keys".* FROM "unsubscribe_keys" ORDER BY "unsubscribe_keys"."key" ASC LIMIT 1
  ApplicationRequest Load (1.2ms)  SELECT "application_requests".* FROM "application_requests" ORDER BY "application_requests"."id" ASC LIMIT 1
  UserField Load (1.0ms)  SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."id" ASC LIMIT 1
  UserSecondFactor Load (1.4ms)  SELECT "user_second_factors".* FROM "user_second_factors" ORDER BY "user_second_factors"."id" ASC LIMIT 1
  ThemeSetting Load (0.6ms)  SELECT "theme_settings".* FROM "theme_settings" ORDER BY "theme_settings"."id" ASC LIMIT 1
  CategoryTagStat Load (0.7ms)  SELECT "category_tag_stats".* FROM "category_tag_stats" ORDER BY "category_tag_stats"."id" ASC LIMIT 1
  TopTopic Load (2.0ms)  SELECT "top_topics".* FROM "top_topics" ORDER BY "top_topics"."id" ASC LIMIT 1
  WebCrawlerRequest Load (0.5ms)  SELECT "web_crawler_requests".* FROM "web_crawler_requests" ORDER BY "web_crawler_requests"."id" ASC LIMIT 1
  TagGroupPermission Load (0.9ms)  SELECT "tag_group_permissions".* FROM "tag_group_permissions" ORDER BY "tag_group_permissions"."id" ASC LIMIT 1
  SharedDraft Load (0.6ms)  SELECT "shared_drafts".* FROM "shared_drafts" ORDER BY "shared_drafts"."id" ASC LIMIT 1
  PushSubscription Load (0.7ms)  SELECT "push_subscriptions".* FROM "push_subscriptions" ORDER BY "push_subscriptions"."id" ASC LIMIT 1
  DirectoryItem Load (1.1ms)  SELECT "directory_items".* FROM "directory_items" ORDER BY "directory_items"."id" ASC LIMIT 1
  MutedUser Load (0.5ms)  SELECT "muted_users".* FROM "muted_users" ORDER BY "muted_users"."id" ASC LIMIT 1
  StylesheetCache Load (11.8ms)  SELECT "stylesheet_cache".* FROM "stylesheet_cache" ORDER BY "stylesheet_cache"."id" ASC LIMIT 1
  PostReplyKey Load (1.2ms)  SELECT "post_reply_keys".* FROM "post_reply_keys" ORDER BY "post_reply_keys"."id" ASC LIMIT 1
  SkippedEmailLog Load (0.8ms)  SELECT "skipped_email_logs".* FROM "skipped_email_logs" ORDER BY "skipped_email_logs"."id" ASC LIMIT 1
  UserUpload Load (0.6ms)  SELECT "user_uploads".* FROM "user_uploads" ORDER BY "user_uploads"."id" ASC LIMIT 1
  UserAssociatedAccount Load (0.6ms)  SELECT "user_associated_accounts".* FROM "user_associated_accounts" ORDER BY "user_associated_accounts"."id" ASC LIMIT 1
  ThemeTranslationOverride Load (0.6ms)  SELECT "theme_translation_overrides".* FROM "theme_translation_overrides" ORDER BY "theme_translation_overrides"."id" ASC LIMIT 1
  Reviewable Load (1.2ms)  SELECT "reviewables".* FROM "reviewables" ORDER BY "reviewables"."id" ASC LIMIT 1
  UserStat Load (1.1ms)  SELECT "user_stats".* FROM "user_stats" ORDER BY "user_stats"."user_id" ASC LIMIT 1
  ReviewableHistory Load (0.7ms)  SELECT "reviewable_histories".* FROM "reviewable_histories" ORDER BY "reviewable_histories"."id" ASC LIMIT 1
  GroupRequest Load (0.6ms)  SELECT "group_requests".* FROM "group_requests" ORDER BY "group_requests"."id" ASC LIMIT 1
  IgnoredUser Load (1.0ms)  SELECT "ignored_users".* FROM "ignored_users" ORDER BY "ignored_users"."id" ASC LIMIT 1
  ReviewableScore Load (0.6ms)  SELECT "reviewable_scores".* FROM "reviewable_scores" ORDER BY "reviewable_scores"."id" ASC LIMIT 1
  ReviewableClaimedTopic Load (0.9ms)  SELECT "reviewable_claimed_topics".* FROM "reviewable_claimed_topics" ORDER BY "reviewable_claimed_topics"."id" ASC LIMIT 1
  UserProfile Load (0.9ms)  SELECT "user_profiles"."user_id", "user_profiles"."location", "user_profiles"."website", "user_profiles"."bio_raw", "user_profiles"."bio_cooked", "user_profiles"."dismissed_banner_key", "user_profiles"."bio_cooked_version", "user_profiles"."badge_granted_title", "user_profiles"."views", "user_profiles"."profile_background_upload_id", "user_profiles"."card_background_upload_id" FROM "user_profiles" ORDER BY "user_profiles"."user_id" ASC LIMIT 1
  AnonymousUser Load (0.6ms)  SELECT "anonymous_users".* FROM "anonymous_users" ORDER BY "anonymous_users"."id" ASC LIMIT 1
  TopicGroup Load (0.7ms)  SELECT "topic_groups".* FROM "topic_groups" ORDER BY "topic_groups"."id" ASC LIMIT 1
  UserSecurityKey Load (1.1ms)  SELECT "user_security_keys".* FROM "user_security_keys" ORDER BY "user_security_keys"."id" ASC LIMIT 1
  BackupDraftTopic Load (0.8ms)  SELECT "backup_draft_topics".* FROM "backup_draft_topics" ORDER BY "backup_draft_topics"."id" ASC LIMIT 1
  BackupDraftPost Load (0.8ms)  SELECT "backup_draft_posts".* FROM "backup_draft_posts" ORDER BY "backup_draft_posts"."id" ASC LIMIT 1
I, [2019-10-30T17:07:16.038972 #73939]  INFO -- : master process ready
  Upload Load (1.0ms)  SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" = -5 LIMIT 1
  Upload Load (1.2ms)  SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" = -6 LIMIT 1
  OptimizedImage Load (5.3ms)  SELECT "optimized_images".* FROM "optimized_images" WHERE "optimized_images"."upload_id" = -6 AND "optimized_images"."height" = 32 AND "optimized_images"."width" = 32 LIMIT 1
I, [2019-10-30T17:07:18.452857 #74039]  INFO -- : worker=0 ready
I, [2019-10-30T17:07:19.332481 #74047]  INFO -- : worker=1 ready
I, [2019-10-30T17:07:20.422208 #74056]  INFO -- : worker=2 ready
   (0.2ms)  BEGIN
  MiniScheduler::Stat Create (0.8ms)  INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PollMailbox', 'ubuntu', 74013, 835136, '2019-10-30 21:07:23.042027') RETURNING "id"
   (1.3ms)  COMMIT
   (0.4ms)  BEGIN
  MiniScheduler::Stat Update (0.7ms)  UPDATE "scheduler_stats" SET "duration_ms" = 28, "live_slots_finish" = 848294, "success" = TRUE WHERE "scheduler_stats"."id" = 2201
   (0.7ms)  COMMIT
   (0.2ms)  BEGIN
  MiniScheduler::Stat Create (0.7ms)  INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ProcessBadgeBacklog', 'ubuntu', 74013, 874235, '2019-10-30 21:07:28.047923') RETURNING "id"
   (0.8ms)  COMMIT
   (0.4ms)  BEGIN
  MiniScheduler::Stat Update (0.4ms)  UPDATE "scheduler_stats" SET "duration_ms" = 7, "live_slots_finish" = 877837, "success" = TRUE WHERE "scheduler_stats"."id" = 2202
   (0.7ms)  COMMIT
   (0.2ms)  BEGIN
  MiniScheduler::Stat Create (0.5ms)  INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::MigrateUploadScheme', 'ubuntu', 74013, 984385, '2019-10-30 21:08:11.115620') RETURNING "id"
   (1.1ms)  COMMIT
   (0.4ms)  BEGIN
  MiniScheduler::Stat Update (0.5ms)  UPDATE "scheduler_stats" SET "duration_ms" = 8, "live_slots_finish" = 988019, "success" = TRUE WHERE "scheduler_stats"."id" = 2203
   (0.8ms)  COMMIT
   (0.2ms)  BEGIN
  MiniScheduler::Stat Create (0.7ms)  INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ProcessBadgeBacklog', 'ubuntu', 74013, 1056629, '2019-10-30 21:08:28.134253') RETURNING "id"
   (1.1ms)  COMMIT
   (0.5ms)  BEGIN
  MiniScheduler::Stat Update (0.8ms)  UPDATE "scheduler_stats" SET "duration_ms" = 8, "live_slots_finish" = 1062512, "success" = TRUE WHERE "scheduler_stats"."id" = 2204
   (0.9ms)  COMMIT

It’s at this point that I attempted to browse to this instance at http://192.168.1.213:3000, and got a “connection refused” error. I find no mention of “Puma” or “Llamas” in the output, but I do see this (as the only mention of “listening”):

I, [2019-10-30T17:07:09.564131 #73939]  INFO -- : listening on addr=127.0.0.1:3000 fd=29

…which may indicate the problem. But if that’s saying what I think it’s saying, it leaves the question of why it’s only listening on localhost rather than on 0.0.0.0, when I told it to listen on 0.0.0.0.

out of curiosity, do you listen on a different address if you run:
UNICORN_BIND_ALL=true bundle exec rails server?

5 Likes

Yes, this does make a difference:

I, [2019-10-30T18:21:35.582274 #75218]  INFO -- : listening on addr=0.0.0.0:3000 fd=12

…and I’m able to browse to the installation as well.

5 Likes

Would these changes or something similar have affected the Docker dev version too?

I’ve been tearing my hair out trying to connect, even from localhost using the Docker dev method.

For what it’s worth, I could only connect from the same host, but prepending UNICORN_BIND_ALL=true permitted me to connect from other hosts.

Edit: checking out an earlier rev seems to sort connectivity issues for Docker-dev instances, but I’ve yet to investigate what it changes here

Using the above command partially solved the issue, but then I got a “Blocked host” error page saying:

To allow requests to www.mydiscoursedev.io, add the following to your environment configuration:
config.hosts << "www.mydiscoursedev.io"

So the command that finally worked for me is:

UNICORN_BIND_ALL=true DISCOURSE_DEV_HOSTS=www.mydiscoursedev.io bundle exec rails server

(solution picked from here)

4 Likes

Hello…

I have followed all the steps above and can open Discourse forum. To be frank, I am not familiar with shell command in linux, and just followed them blindly.

Unfortunately, I have several problems which I need help:

  1. The loading of the forum seems very long, around 6-8 seconds to open the main forum page. How to make the loading page become faster, since this is localhost, and logically should be loading faster.
    Screenshot - 26-Nov-19 , 10_56_54

  2. Using Chorme DevTools in Network tab, I found out that several items (mostly are png image file) are marked red (failed) and cannot be loaded. I think this is due to the default link was set to port 3000, while my setup is set to port 9292. How to change the port 9292 to become 3000?
    EDIT: found out solution: use bundle exec puma -p 3000

Thank you in advanced…

Edit /config/site_settings.yml and make sure your port is reflected here (in my case it’s 3000).

  port:
    hidden: true
    default: "3000"

You may need to rebake/rebuild the post in question.

That is to be expected. That has to do with how the development environment works. It loads everything all the time rather than having a bunch of stuff cached in various ways

3 Likes

I see. I have to bear witht he slow loading then, no choice… :slight_smile:

It should not be slow once things are ‘running’, but yes, if you stop the server, make a change and then restart it, you will need a few additional seconds.

3 Likes

I am new to Linux and I am stuck on how to find my Discourse folder to git clone it. Little help?

You should be at the root directory when you ssh into your VPS or spin up your VM.

The discourse folder will be at /discourse or ~/discourse

Just cd ~/discourse … ie change directory to the discourse folder in root.

Is that one of these…?

Use the command line (you’ll only be using the command line in production so you’d better get used to it! :slight_smile: )

I meant to say, the ~ directory. Not sure what that is.

[/edit] what the hell is production? :woozy_face:

~ means home directory for current user

‘production’ means the technical environment in which you ultimately run your public forum.

Open a terminal and doing as I have advised will take you to the discourse directory.

1 Like