search

Netflix-Skunkworks / Scumblr

Web framework that allows performing periodic syncs of data sources and performing analysis on the identified results
Apache License 2.0
2.64k stars 317 forks source link

rake db:structure:load errors #113

Closed keirendev closed 7 years ago

keirendev commented 7 years ago

From a clean install of Scumblr I'm receiving the following error messages while using rake. I'm installing this on Centos so following the wiki may have caused some mismatched packages.

$ rake db:create
$ rake db:structure:load
psql:/home/x/Scumblr/db/structure.sql:9: ERROR:  unrecognized configuration parameter "lock_timeout"
psql:/home/x/Scumblr/db/structure.sql:14: ERROR:  unrecognized configuration parameter "row_security"
psql:/home/x/Scumblr/db/structure.sql:270: ERROR:  type "jsonb" does not exist
LINE 12:     metadata jsonb,
                      ^
psql:/home/x/Scumblr/db/structure.sql:289: ERROR:  relation "results" does not exist
psql:/home/x/Scumblr/db/structure.sql:481: ERROR:  type "jsonb" does not exist
LINE 6:     metadata jsonb
                     ^
psql:/home/x/Scumblr/db/structure.sql:500: ERROR:  relation "system_metadata" does not exist
psql:/home/x/Scumblr/db/structure.sql:617: ERROR:  type "jsonb" does not exist
LINE 12:     metadata jsonb
                      ^
psql:/home/x/Scumblr/db/structure.sql:636: ERROR:  relation "tasks" does not exist
psql:/home/x/Scumblr/db/structure.sql:694: ERROR:  type "jsonb" does not exist
LINE 19:     metadata jsonb
                      ^
psql:/home/x/Scumblr/db/structure.sql:713: ERROR:  relation "users" does not exist
psql:/home/x/Scumblr/db/structure.sql:957: ERROR:  relation "results" does not exist
psql:/home/x/Scumblr/db/structure.sql:999: ERROR:  relation "system_metadata" does not exist
psql:/home/x/Scumblr/db/structure.sql:1027: ERROR:  relation "tasks" does not exist
psql:/home/x/Scumblr/db/structure.sql:1041: ERROR:  relation "users" does not exist
psql:/home/x/Scumblr/db/structure.sql:1139: ERROR:  relation "results" does not exist
psql:/home/x/Scumblr/db/structure.sql:1163: ERROR:  relation "tasks" does not exist
psql:/home/x/Scumblr/db/structure.sql:1203: ERROR:  relation "system_metadata" does not exist
psql:/home/x/Scumblr/db/structure.sql:1236: ERROR:  relation "users" does not exist
psql:/home/x/Scumblr/db/structure.sql:1354: ERROR:  relation "results" does not exist
psql:/home/x/Scumblr/db/structure.sql:1424: ERROR:  relation "users" does not exist
psql:/home/x/Scumblr/db/structure.sql:1466: ERROR:  relation "results" does not exist
ahoernecke commented 7 years ago

Hello,

Can you see what version of rails and Postgres you're running?

keirendev commented 7 years ago

$ postgres --version postgres (PostgreSQL) 9.2.15 $ rails --version Rails 4.2.6

My bad, thanks for this. I'll follow up with updating to correct version.

ahoernecke commented 7 years ago

Sounds good, np!