Beginners Guide to Install Discourse on Ubuntu for Development

This worked great for me, except for the fact that the logo in the upper left of the navigation bar is showing as a broken image. When I inspect the image I get this as the URL:
src=“http://localhost:3000/uploads/default/original/1X/1233b191a44c75447212ae753ac6446b436fae26.png
Which means that it’s trying to go to localhost:3000 even though I’m accessing the page remotely. Is there a way to fix this or otherwise configure the dev installation so that the image will use a relative URL?

ok found it - had to change the host_names in the config/database.yml file to be the IP address instead of the default which is “localhost”

Hello all ;D
For a production forum, is the better way installl over a docker with discourse ?

Greetings
Gerriet

Yep, that’s the easier install method for a production environment.

For production use discourse/INSTALL-cloud.md at master · discourse/discourse · GitHub

3 Likes

import backup database
now error
POST http://127.0.0.1:3000/session 403 (Forbidden)

Hi, when doing

I get the following error:
`

== Seed from /home/uwe/Software/discourse/db/fixtures/990_topics.rb
rake aborted!
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “polls” does not exist
LINE 8: WHERE a.attrelid = ‘“polls”’::regclass
^
/home/uwe/Software/discourse/plugins/poll/plugin.rb:234:in schedule_jobs' /home/uwe/Software/discourse/plugins/poll/plugin.rb:454:inblock (2 levels) in activate!’
/home/uwe/Software/discourse/lib/plugin/instance.rb:316:in block in on' /home/uwe/Software/discourse/lib/discourse_event.rb:14:inblock in trigger’
/home/uwe/Software/discourse/lib/discourse_event.rb:13:in trigger' /home/uwe/Software/discourse/lib/post_creator.rb:233:intrigger_after_events’
/home/uwe/Software/discourse/lib/post_creator.rb:202:in create' /home/uwe/Software/discourse/lib/post_creator.rb:213:increate!’
/home/uwe/Software/discourse/lib/post_creator.rb:249:in create!' /home/uwe/Software/discourse/lib/seed_data/topics.rb:130:increate_topic’
/home/uwe/Software/discourse/lib/seed_data/topics.rb:16:in block (2 levels) in create' /home/uwe/Software/discourse/lib/seed_data/topics.rb:15:ineach’
/home/uwe/Software/discourse/lib/seed_data/topics.rb:15:in block in create' /home/uwe/Software/discourse/lib/seed_data/topics.rb:14:increate’
(eval):18:in block (2 levels) in run_file' /home/uwe/Software/discourse/lib/tasks/db.rake:61:inblock in ’

Caused by:
PG::UndefinedTable: ERROR: relation “polls” does not exist
LINE 8: WHERE a.attrelid = ‘“polls”’::regclass
^
/home/uwe/Software/discourse/plugins/poll/plugin.rb:234:in schedule_jobs' /home/uwe/Software/discourse/plugins/poll/plugin.rb:454:inblock (2 levels) in activate!’
/home/uwe/Software/discourse/lib/plugin/instance.rb:316:in block in on' /home/uwe/Software/discourse/lib/discourse_event.rb:14:inblock in trigger’
/home/uwe/Software/discourse/lib/discourse_event.rb:13:in trigger' /home/uwe/Software/discourse/lib/post_creator.rb:233:intrigger_after_events’
/home/uwe/Software/discourse/lib/post_creator.rb:202:in create' /home/uwe/Software/discourse/lib/post_creator.rb:213:increate!’
/home/uwe/Software/discourse/lib/post_creator.rb:249:in create!' /home/uwe/Software/discourse/lib/seed_data/topics.rb:130:increate_topic’
/home/uwe/Software/discourse/lib/seed_data/topics.rb:16:in block (2 levels) in create' /home/uwe/Software/discourse/lib/seed_data/topics.rb:15:ineach’
/home/uwe/Software/discourse/lib/seed_data/topics.rb:15:in block in create' /home/uwe/Software/discourse/lib/seed_data/topics.rb:14:increate’
(eval):18:in block (2 levels) in run_file' /home/uwe/Software/discourse/lib/tasks/db.rake:61:inblock in ’
Tasks: TOP => db:migrate
(See full trace by running task with --trace)`

Any idea how to fix?

Hey @JoshuaJoma,

Could you try instead of running bundle exec rake db:create db:migrate, split it into two separated commands?

bundle exec rake db:create
bundle exec rake db:migrate

I think this will solve that problem.

6 Likes

Dear Sir
While Installing Discourse I am stuck on
bundle exec rake autospace command . This command gets failures. I am sharing screenshots.

2 Likes

Hey Mahesh,

This step is just automated tests and it is not essential to run Discourse.

Nevertheless, if you want to make them pass, this solution worked for me.

2 Likes

Question - why does that help? What is causing this error to happen when they are combined?

I’m asking this out of curiosity but also because I think the recent errors that people have been experiencing lately might be caused by the same thing.

Has something changed in the last few days with respect to this procedure? I ran this a few days ago (not more than a week) on a bare, updated Ubuntu 18.04 system, and it worked. I then tried it twice more between Monday and yesterday, and I’m getting “connection refused” when I try to connect to the Discourse instance. I’m using the --binding=0.0.0.0 option, and trying to connect from another computer on my LAN. As far as I can tell, I ran the same commands (the commands noted in the OP), in the same environment, each time. Where should I start looking for the cause?

@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

2 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
2 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?

3 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.

3 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