Trouble with Sidekiq on multisite


(Jay Pfaffman) #1

Continuing the discussion from How to specify alternate configuration in multisite:

I’ve got a multisite instance up and sidekiq’s not running on any of the sub-hosts. I noticed some errors like this on rebuild–looks like site_settings didn’t get created?:

I, [2017-05-10T19:08:48.828869 #16]  INFO -- : Purging temp files
Bundling assets
Compressing Javascript and Generating Source Maps

I, [2017-05-10T19:08:48.830823 #16]  INFO -- : > cd /var/www/discourse && sudo -E -u discourse bundle exec rake multisite:
migrate
2017-05-10 19:08:55 UTC [19246-1] discourse@discourse_instance2 ERROR:  relation "site_settings" does not exist at character 3
6
2017-05-10 19:08:55 UTC [19246-2] discourse@discourse_instance2 STATEMENT:  SELECT name, data_type, value FROM site_settings
URGENT: ERROR:  relation "site_settings" does not exist
LINE 1: SELECT name, data_type, value FROM site_settings
                                           ^
 Failed to initialize site discourse_instance2
2017-05-10 19:09:01 UTC [19242-1] discourse@discourse_forum LOG:  duration: 287.092 ms  execute <unnamed>: SELECT COUNT(*)
 FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (id NOT IN (SELECT topic_id from categories where topic_id is not
 null))
^C2017-05-10 19:09:18 UTC [19246-3] discourse@discourse_instance2 LOG:  duration: 179.263 ms  statement: CREATE  INDEX  "index
_top_topics_on_monthly_op_likes_count" ON "top_topics"  ("monthly_op_likes_count")
> Seeding dark and light themes
I, [2017-05-10T19:09:40.931958 #16]  INFO -- : `/root` is not writable.
Bundler will use `/tmp/bundler/home/discourse' as your home directory temporarily.
Migrating default

(Alan Tan) #3

To check for Sidekiq related errors, you can check /shared/log/unicorn.stderr.log.


(Michael - DiscourseHosting.com) #4

Did you rake multisite:migrate and multisite:seed_fu ?