ruby on rails - Running Heroku rake db:migrate on Heroku not migrating the database -
so when run heroku rake db:migrate, after pushing latest code heroku doesn't alter tables. however, when try on pc(where use postgresql) , run rake db:migrate, migrates database , adds necessary tables , fields existing tables.
however, heroku, don't errors, response get.
sql (2.4ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'flow_elements' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.2ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"flows"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.7ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"flows"'::regclass sql (2.7ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'flows' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.3ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"images"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.3ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"images"'::regclass sql (2.3ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'images' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.2ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"login_histories"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.8ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"login_histories"'::regclass sql (2.7ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'login_histories' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.1ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"projects"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.2ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"projects"'::regclass sql (2.6ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'projects' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.3ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"projects_users"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.5ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"projects_users"'::regclass sql (2.4ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'projects_users' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (2.2ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"questions"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.2ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"questions"'::regclass sql (2.4ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'questions' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname columns index questions_fts_idx on questions (1.8ms) select a.attnum, a. attname pg_attribute a.attrelid = 48972 , a.attnum in (0) sql (2.1ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"screens"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (4.3ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"screens"'::regclass sql (2.4ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'screens' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname sql (3.0ms) select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull pg_attribute left join pg_attrdef d on a.attrelid = d.adrelid , a.attnum = d.adnum a.attrelid = '"users"'::regclass , a.attnum > 0 , not a.attisdropped order a.attnum pk , serial sequence (3.6ms) select attr.attname, seq.relname pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons seq.oid = dep.objid , seq.relkind = 's' , attr.attrelid = dep.refobjid , attr.attnum = dep.refobjsubid , attr.attrelid = cons.conrelid , attr.attnum = cons.conkey[1] , cons.contype = 'p' , dep.refobjid = '"users"'::regclass sql (2.4ms) select distinct i.relname, d.indisunique, d.indkey, t.oid pg_class t, pg_class i, pg_index d i.relkind = 'i' , d.indexrelid = i.oid , d.indisprimary = 'f' , t.oid = d.indrelid , t.relname = 'users' , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') ) order i.relname
any ideas ?
you need restart heroku servers using "heroku restart".
Comments
Post a Comment