PG::UndefinedTable: ERROR: relation "sidekiq_jobs" does not exist

[supremebeing7]

I installed this once without issue, but was getting this error when my CI was trying to run rake db:schema:load:

/gems/ruby-2.2.2/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `async_exec': PG::UndefinedTable: ERROR:  relation "sidekiq_jobs" does not exist
LINE 5:                WHERE a.attrelid = '"sidekiq_jobs"'::regclass
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                FROM pg_attribute a LEFT JOIN pg_attrdef d
                  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
               WHERE a.attrelid = '"sidekiq_jobs"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum
 (ActiveRecord::StatementInvalid)

I've since dropped my local database, removed all traces of the gem (or so I thought), recreated and re-migrated, and attempted to install the gem again. As soon as I add to my Gemfile, if I try to run rake db:migrate or rake db:rollback, it gives me the above error. I also get this error when trying rails g sidekiq:monitor:install.

Has anyone seen this before? I thought it might be just my database being messed up, but I'm working off a fresh db and getting this.

[jdraths]

+1 I'm having the same issue. Did you find a solution for this?

[supremebeing7]

Unfortunately, the only solution I found was uninstalling the gem. As soon as I did, the problem went away. I didn't have time to dig into the gem internals to try to figure it out.

[janephilipps]

+1 I'm having this issue in production. Going to try testing by uninstalling the gem.

[yogev1]

same issue here. bummer.