Attaching foreman-rake migrate:status output El jueves, 20 de julio de 2017, 13:06:54 (UTC+2), María Sierra escribió: > > Hello, > > Our foreman GUI is currently reporting > > ERF64-6496 [Foreman::MaintenanceException]: There are migrations pending > in the system. > > And the same does hammer. foreman-rake migrate:status output seems to be > ok also (attached) > > This is a little context on how we reached the current status: > > After a problem with postgresql we had to recover foreman and candlepin > DBs from dump files. > > Our instance is Foreman 1.15 - Katello 3.4. Unfortunately, we didn't know > about katello-backup and katello-restore being introduced in version 3.1, > so we backed up the DBs like we used to in our old katello 2: > > pg_dump -Fc foreman > $BDIR/foreman.dump pg_dump -Fc candlepin > > $BDIR/candlepin.dump > > And we recovered them like this: > > dropdb foreman dropdb candlepin > pg_restore -C -d postgres $BDIR/foreman.dump pg_restore -C -d postgres > $BDIR/candlepin.dump > > > Now, Postgresql is up, the databases are there: > > List of databases > Name | Owner | Encoding | Collate | Ctype | Access > privileges > > -----------+----------+----------+-------------+-------------+------------------------ > candlepin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | > =Tc/postgres + > | | | | | > postgres=CTc/postgres + > | | | | | > candlepin=CTc/postgres > foreman | foreman | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/foreman > + > | | | | | > foreman=CTc/foreman + > | | | | | > postgres=CTc/foreman > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > + > | | | | | > postgres=CTc/postgres > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > + > | | | | | > postgres=CTc/postgres > (5 rows) > > Foreman and candlepin users have access privileges, I've seen our data is > in the tables and there are even connections going on. All components have > started up successfully but we still can't access the GUI or execute hammer > commands. > > Could anybody please shed some light on this issue? Is there any > post-recover step that we may have missed? > > Thanks! > >
-- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
[root@rbalvforeprd run]# foreman-rake db:migrate:status database: foreman Status Migration ID Migration Name -------------------------------------------------- up 20090714132448 Create hosts up 20090714132449 Add audits table up 20090715143858 Create architectures up 20090717025820 Create media up 20090718060746 Create domains up 20090718064254 Create subnets up 20090720134126 Create operatingsystems up 20090722140138 Create models up 20090722141107 Create environments up 20090729132209 Create reports up 20090730152224 Create ptables up 20090802062223 Create puppetclasses up 20090804130144 Create parameters up 20090820130541 Create auth sources up 20090905150131 Create hostgroups up 20090905155444 Add type to parameter up 20090907045751 Add domain to parameter up 20090915030726 Change report field type to text up 20090916053824 Change host build default to false up 20090920043521 Add index to host up 20090920064156 Add index to parameters up 20090920065522 Add index to reports up 20091012135004 Create users up 20091016031017 Create sessions up 20091022054108 Add status to report up 20091214045923 Calc existing reports up 20091219132338 Create lookup keys up 20091219132839 Create lookup values up 20100115021803 Change mysql reports column up 20100310080727 Add family to os up 20100325142616 Update fact names and values to bin up 20100414125652 Add releasename to os up 20100416124600 Create usergroups up 20100419151910 Add owner to hosts up 20100523114430 Add ubuntu custom lvm ptable up 20100523141204 Create media operatingsystems and migrate data up 20100524080302 Migrate installation medium uri up 20100525094200 Simplify parameters up 20100601221000 Update os minor up 20100616114400 Change family in os up 20100625155400 Create notices up 20100628123400 Add internal auth up 20100629093200 Create roles up 20100701081235 Add user domains and hostgroups up 20100822072954 Create user facts up 20100823181036 Add enabled to hosts up 20100914092104 Add my booleans to user up 20101018120548 Create messages up 20101018120603 Create sources up 20101018120621 Create logs up 20101019122857 Add metrics to report up 20101019183859 Convert reports up 20101103150254 Add owned filter to user up 20101118130026 Correct media up 20101121080425 Create config templates up 20101121135521 Create template combinations up 20101122132041 Create operatingsystems config templates up 20101123152150 Create template kinds up 20101123153303 Create os default templates up 20101125153351 Add default templates up 20101130093613 Add sub systems to subnet up 20101130100315 Create proxies up 20101202104444 Add proxy to domain up 20101213085232 Add grubby template up 20110117162722 Add host group defaults up 20110128130239 Add default pxe menu template up 20110213104226 Create proxy features up 20110216101848 Change puppetmaster column up 20110301154453 Add managed to hosts up 20110321070954 Revert face names and values to text records up 20110327123639 Add priority to parameter up 20110404150043 Add media path to medium up 20110407091150 Add image to host up 20110412103238 Remove unused fields from puppet classes up 20110417102947 Add table bookmarks up 20110420150600 Add solaris templates up 20110613141800 Add solaris disks up 20110616080444 Add look up key id to puppet class up 20110617190131 Add sparc info to model up 20110619130336 Add ancestry to hostgroup up 20110628115422 Create settings up 20110712064120 Update audits table up 20110712070522 Create host class up 20110725142054 Add suse templates up 20110801090318 Add vm defaults to hostgroup up 20110803114134 Add subnet and domain to host groups up 20111124095053 Rename changes to audited changes up 20111124095054 Add remote address to audits up 20111124095055 Rename parent to association up 20111205231500 Add gateway and dns to subnets up 20111227095806 Ensure all hostnames are lowercase up 20120102071633 Add from and to ranges to subnets up 20120110113051 Create subnet domain up 20120122131037 Create compute resources up 20120126113850 Add uuid and compute id to host up 20120127141602 Add windows templates up 20120311081257 Create nics up 20120313081913 Add puppet master proxy to host and host group up 20120502105518 Update report field to large int up 20120506143325 Create images up 20120509131302 Add cert name to host up 20120510113417 Create key pairs up 20120521142924 Add dns id to subnet up 20120523065531 Add image id to host up 20120529113900 Add user compute resources up 20120529115814 Add compute resources boolean to user up 20120604114049 Add epel snippets up 20120607074318 Convert params to text up 20120612070100 Change bookmark column to text up 20120613082125 Rename association to associated up 20120620124658 Fix auditable type up 20120620124659 Fix associated type up 20120621135042 Create taxonomies up 20120623002052 Add ok hosts book mark up 20120624081510 Add auditable name and associated name to audit up 20120624093958 Add os family to media up 20120624094034 Add os family to ptable up 20120705130038 Add attributes to compute resources up 20120824142048 Add some indexes up 20120905095532 Create environment classes up 20120905131841 Add lookup keys override and required up 20120916080843 Add lookup values count to lookup keys up 20120916080926 Cache lookup values count up 20120921000313 Add iam role to images up 20120921105349 Create tokens up 20120927020752 Add bmc feature to proxy up 20121003172526 Add taxonomy ids to hosts up 20121011115320 Change domain character count up 20121012170851 Create trends up 20121012170936 Create trend counters up 20121015113502 Update media path limit up 20121018152459 Create hostgroup classes up 20121026160433 Add localboot template up 20121029164911 Rename reply adress setting up 20121101141448 Add locations organizations up 20121118120028 Migrate hypervisors to compute resources up 20121118125341 Create taxable taxonomies up 20121119102104 Add my taxonomy to user up 20121210214810 Add subscribe to all hostgroups to users up 20121218084123 Change smart variable length up 20121219040534 Remove replay address setting up 20130109155024 Add ignore types to taxonomy up 20130121130826 Add digest to messages up 20130211160200 Add sti to hosts up 20130228145456 Add digest to sources up 20130329195742 Remove duplicate snippets up 20130409081924 Add label to host group up 20130417110127 Add sti to settings up 20130418134513 Fix sti host auditable type up 20130419145808 Add id to user hostgroup up 20130430150500 Add locale to users up 20130520152000 Remove duplicate fact names up 20130520161514 Add unique constraint to fact name up 20130523131455 Add unique constraints to fact values up 20130530061844 Change column lengths up 20130625113217 Add templates to features up 20130725081334 Remove environment from host up 20130804131949 Add public to key pairs up 20130813105054 Change compute resource password to text up 20130814132531 Add ldap filter to auth sources up 20130908100439 Delete orphaned records up 20130908170524 Add keys up 20130914211030 Create host bootdisk template up 20130915104500 Edit host bootdisk template multinic up 20130915133321 Create kickstart bootdisk template up 20130915201457 Create generic host bootdisk template up 20130924145800 Remove unused role fields up 20131003143143 Fix auditable type2 up 20131014133347 Add compose flag and short name to fact name up 20131014135042 Katello tables up 20131014225132 Add users fields up 20131016124255 Add foreign keys engine up 20131017142515 Allow null values on fact value up 20131021095100 Edit host bootdisk template dns secondary up 20131021125612 Add type to fact name up 20131021152315 Change name index on fact name up 20131104132542 Update foreman url up 20131107094849 Add ancestry to fact names up 20131114084718 Extend user role up 20131114094841 Create cached user roles up 20131120225132 Add organization fields up 20131122093940 Calculate cache for user role up 20131122150434 Add pxegrub localboot template up 20131122170726 Create cached usergroup members up 20131125230654 Create realms up 20131127112625 Rename seeded templates up 20131128150357 Add admin flag to usergroup up 20131202120621 Create permissions up 20131202131847 Create filters up 20131202144415 Create filterings up 20131204174455 Add description to operatingsystem up 20131205204140 Create foreman tasks up 20131209122644 Create foreman tasks locks up 20131212125626 Add ldap avatar support up 20131216212502 Add quantity to katello key pools up 20131216212621 Add cp id to katello activation keys up 20131218174203 Drop katello key pools table up 20131223120945 Add userdata flag to images up 20131224153518 Create compute profiles up 20131224153743 Create compute attributes up 20131224154836 Add compute profile to hostgroup up 20140110000001 Update environments add katello up 20140110164135 Add foreign keys to filters and filterings up 20140115130443 Add password to images up 20140117160939 Refactor content views up 20140123185537 Add default organization id to users up 20140123194519 Add default location id to users up 20140128123153 Add ancestry to taxonomies up 20140206200439 Create content view puppet modules up 20140212131812 Create content view package filter rules up 20140212143454 Create content view package group filter rules up 20140212143642 Create content view erratum filter rules up 20140217145303 Remove changeset up 20140217160132 Create content view history up 20140219183342 Change label to title up 20140219183343 Migrate permissions up 20140219183345 Add taxonomy searches to filter up 20140222022712 Remove provider discovery up 20140304184854 Add provision method to hosts up 20140305101813 Allow null for repository content up 20140306132108 Create content view puppet environments up 20140310102051 Repository add checksum type up 20140314004243 Add counter caches up 20140318153157 Fix puppetclass counters up 20140318174203 Drop cdn import success column up 20140318221513 Change host managed default to false up 20140320000449 Add server type to auth source up 20140320004050 Add groups base to auth source up 20140324104010 Remove foreman tasks progress up 20140325093623 Add lowerlogin to users up 20140325185413 Create content view foreign keys up 20140404122011 Drop repositories enabled column up 20140407161817 Create config groups up 20140407162007 Create config group classes up 20140407162059 Create host config groups up 20140409031625 Create external usergroups up 20140410134234 Remove subscribe to all hostgroups from users up 20140411134235 Update content view description type up 20140413123650 Add counters to config groups up 20140414214152 Allow null content view to activation key up 20140415032811 Add config group counter defaults up 20140415052549 Cleanup users properties up 20140415053029 Remove user join tables up 20140418124032 Add next version to katello content views up 20140422000001 Update products add organization up 20140423191446 Add anonymous providers to orgs up 20140425155126 Add host id to system up 20140429193743 Add release version to activation keys up 20140502164009 Rename system groups to host collections up 20140502174412 Update host collections foreign keys up 20140514165842 Create capsule lifecycle environments up 20140522122215 Add hidden value to parameter up 20140522185700 Change templatekind to bootdisk up 20140531160506 Package filter add original packages up 20140610083129 Add pulp proxy to host up 20140610154745 Content view puppet environment up 20140610170142 Add uuid to content view package group filter rule up 20140617100300 Add description to content view filter rules up 20140623103442 Drop taxonomies owner auto attach all systems task id column up 20140623144932 Fix integer settings up 20140624183938 Add foreign keys for organizations up 20140624184401 Remove label from activation key up 20140626055258 Add missing foreign keys up 20140626204657 Add unlimited to activation keys up 20140626204902 Add unlimited to host collection up 20140630114339 Add boot mode to subnet up 20140705173549 Add locked and default and vendor to config template up 20140707113214 Remove architecture default up 20140707203534 Location add katello default up 20140709150428 Remove deletion task id from taxonomies up 20140710132249 Extract nic attributes up 20140711142510 Add attributes to nic base up 20140716102950 Add managed to nics up 20140716140436 Change auditable name column to text up 20140716211853 Repo rename feed to url up 20140725101621 Add primary interface to hosts up 20140728190218 Add ip suggestion to subnets up 20140805114754 Add unique index to parameter up 20140807175457 Remove hidden column from user up 20140811141742 Remove delayed jobs up 20140813215942 Add parent task up 20140821084214 Add sync plan enabled to sync plan up 20140826104209 Add merge overrides and avoid duplicates to lookup key up 20140828111505 Fix counters up 20140901115249 Add request uuid to audits up 20140902102858 Convert ipam to string up 20140908082450 Remove signo setting up 20140908192300 Change nil admin users to false up 20140910111148 Add bond attributes to nic base up 20140910153654 Move host nics to interfaces up 20140912113254 Add password hash to operatingsystem up 20140912114124 Add grub password to hosts up 20140912145052 Add grub password to hostgroup up 20140915141937 Add should use puppet default to lookup value and key up 20140928131124 Add title to os up 20140928140206 Create widgets up 20140928210618 Add description to content view versions up 20140929073150 Create mail notifications up 20140929073343 Create user mail notifications up 20140930170628 Add errata up 20140930175337 Add email to compute resource up 20140930201523 Add mail enabled to user up 20141001170628 Add system repository up 20141003210742 Add docker container registry url to providers up 20141005233312 Create containers up 20141007225130 Add compute resource id to container up 20141009001613 Add tag to container up 20141009011026 Add attributes to container up 20141010173220 Create docker images up 20141014131912 Add subscription type to mail notifications up 20141015164522 Remove failed report setting up 20141015173220 Add docker image fields up 20141018110810 Add uuid to containers up 20141021105446 Rename subnet name to unique up 20141023114229 Add timezone to user up 20141024163003 Create docker registries up 20141028164206 Change memory in container up 20141028164633 Change cpuset in container up 20141031150814 Add tag repository id index up 20141109131448 Rename hosts count column up 20141110084848 Fix puppetclass total hosts up 20141112165600 Add type to parameter index up 20141112180709 Add auto attach to activation keys up 20141116131324 Add mail query to user mail notification up 20141117093914 Add queryable to mail notification up 20141120123003 Add user credentials to docker registries up 20141120140051 Remove audit user fk up 20141124055509 Rename smart proxy auth related settings up 20141124182205 Content view version add minor up 20141203082104 Make templates default up 20141203123206 Add timestamps to repository join tables up 20141204203609 Add default value to auto attach up 20141209103005 Disown foreman templates up 20141209182008 Remove docker tables up 20141210173220 Create docker tables up 20141215213720 Track version components up 20141217101211 Add compute attributes to nics up 20141222113313 Create wizard states up 20141222151001 Add host content view environment up 20141225073211 Add description to taxonomies up 20150109012657 Add capsule id to container up 20150114141626 Actually rename smart proxy auth related settings up 20150114225023 Add upstream name to repository up 20150119153452 Update promote errata email description up 20150122011747 Add katello flag to docker wizard image up 20150127085513 Set ptable layout to text up 20150129054944 Add katello flag to containers up 20150202094307 Add range to trend counters up 20150212161904 Move description fields to text up 20150224083608 Remove docker registry url up 20150225124617 Add default widgets up 20150225131946 Change default subnet boot mode up 20150227213850 Change descriptions to text fields up 20150303175646 Remove katello flag from containers up 20150312144232 Migrate websockets setting up 20150423134004 Add content host id to smart proxy up 20150428070436 Add index to logs source up 20150428110835 Change os default password hash up 20150505180030 Change errata timestamps to dates up 20150507131145 Update composite default for content view up 20150508124600 Copy unmanaged hosts to interfaces up 20150513034751 Add ostree branches up 20150514072626 Add type to config template up 20150514114044 Migrate ptables to templates up 20150514121649 Add usergroup sync to auth sources up 20150519142008 Remove total hosts audits up 20150521121315 Rename config template to provisioning template up 20150525081931 Remove duplicate tokens up 20150602153751 Change usergroup name to be required up 20150602153753 Remove help tips up 20150602153754 Remove search histories up 20150602153755 Remove search favorites up 20150602153756 Remove user notices up 20150602153757 Remove notices up 20150603045418 Remove user fields up 20150604104449 Remove counter cache audits up 20150605073820 Fix template snippet flag up 20150605103059 Assign ptables to taxonomies up 20150606021722 Create puppet modules up 20150606065713 Add sti to lookup keys up 20150611140455 Remove default and custom info up 20150612105614 Rename taxonomy ignored type to provisioning templates up 20150612135546 Create host status up 20150613134559 Add rpm up 20150614171717 Rename puppetclass counters for lk sti up 20150618093433 Remove unused fields from hosts up 20150622090115 Change reported at up 20150623135424 Create package groups up 20150705131449 Add type to reports up 20150708070742 Add full name to setting up 20150713143226 Add unique to operatingsystems title up 20150714132601 Remove is param up 20150714140850 Remove new from compute attributes up 20150714151223 Remove chef proxy up 20150715142649 Assign content host to smart proxies up 20150717142559 Add distributions to repository up 20150721131324 Change bookmark report controller up 20150728122736 Change report permissions up 20150811170401 Add merge default to lookup key up 20150813185339 Create subscriptions up 20150814204140 Add task type value index up 20150814205620 Change container column type up 20150817102538 Add delay attributes up 20150819105725 Add lookup value match to host and hostgroup up 20150826165942 Add subscription facet up 20150826170004 Add content facet up 20150901213759 Remove distributors up 20150902164543 Remove apply info task id from taxonomies up 20150907124936 Create recurring logic up 20150907131503 Create task groups up 20150908222711 Drop marketing engineering products up 20150917155300 Update host status status field int up 20150928221648 Update location katello default up 20150930183738 Migrate content hosts up 20151009084350 Drop ptables up 20151014144004 Host collection to hosts up 20151015152947 Add virt only to katello pools up 20151019174035 Rename domain host count up 20151022123457 Add recurring logic state up 20151025120534 Add hidden value to lookup key up 20151104100257 Add hosts count to hostgroup up 20151109152507 Add host status host id index up 20151112152108 Create triggerings up 20151120153254 Delete bootable interface up 20151203230940 Add date type to content view erratum filter rules up 20151210143537 Add type to mail notification up 20151219152536 Rename index repository errata up 20151219203225 Rename index repository puppet module up 20151220093801 Remove spaces from smart variable key up 20160114200145 Add mirror on sync to repositories up 20160129192548 Add docker v2 schema up 20160131182301 Add download policy to katello repositories up 20160201131211 Add expired logs to smart proxy up 20160203110216 Add default value for bookmark public field up 20160203195736 Remove docker image schema up 20160211134035 Remove system errata up 20160215143900 Add subnet domain relation constraints up 20160222143432 Move system description to host up 20160224155909 Add registered at to subscription facet up 20160225115638 Remove default user role up 20160225131917 Rename anonymous role up 20160228140111 Update params priority up 20160301070319 Add version ostree branches up 20160307120453 Remove hostgroups count from puppetclasses up 20160308102459 Remove permissions from roles up 20160315161936 Add encrypted to settings up 20160317070258 Add view params to filters with edit up 20160317171813 Change activation key column names up 20160323065901 Increase cdn length up 20160404074723 Downcase display types up 20160404132250 Remove katello from notification name up 20160413230128 Add kickstart repository to hosts and hostgroups up 20160414063050 Add sti to subnets up 20160415134454 Add ipv6 to hosts up 20160415135858 Add ipv6 subnet up 20160426145517 Move host description to host comment up 20160505181337 Rename katello settings up 20160516070529 Divide lookup key permissions up 20160520175340 Add host applicable package up 20160527093031 Limit os description up 20160530184400 Add repo id indexes up 20160605160933 Remove jobs up 20160605162929 Remove system smart proxy up 20160609092110 Remove nil from merge override up 20160613150922 Add event queue up 20160616074718 Remove host counter cache up 20160617124149 Remove duplicate view filters up 20160619223332 Fix viewer role up 20160626085636 Remove puppet counters up 20160627125310 Delete system up 20160701180402 Add sortable version to puppet modules up 20160715131352 Set role builtin default up 20160717125402 Unify permissions up 20160719081324 Change templates type default up 20160719095445 Change template taxable taxonomies type up 20160719100624 Change template audits type up 20160722193256 Add verify ssl on sync to repository up 20160725142557 Add pxe loader to host up 20160726085358 Rename lookup value use puppet default up 20160727084256 Add description to user up 20160727142242 Add pxe loader to hostgroup up 20160727144242 Add registered through to katello subscription facets up 20160728005028 Add latest version to content view component up 20160728095626 Add description to role up 20160808002834 Add files up 20160817125655 Reset override params up 20160818091420 Add override flag to filter up 20160831121418 Rename lookup key use puppet default up 20160906181923 Add puppet path to smart proxy up 20160907231049 Add username password to repository up 20160908234510 Add rpm nvra up 20160914125418 Update parameter priorities up 20160920151810 Add more lock indexes up 20160922144222 Change fact name to puppet fact name up 20160923143611 Add action to content view histories up 20160924213018 Change widget names up 20160924213020 Change katello widget names up 20160924213030 Change tasks widget names up 20160927071039 Create notification blueprints up 20160927071147 Create notifications up 20160927073233 Create notification recipients up 20160930121245 Content view force puppet env up 20160930150810 Add smart proxy download policy up 20161003091412 Add missing indexes up 20161003130853 Add architecture to katello content view package filter rule up 20161003204325 Add user to katello subscription facets up 20161006070258 Migrate common parameter permissions up 20161007115719 Rename ipmi boot permission up 20161014133811 Move content view version description to histories up 20161021072346 Fix subscription permissions up 20161026191118 Fix invalid interfaces up 20161028153131 Sub facet user index not uniq up 20161031204903 Add tracer support up 20161102194100 Create content view docker filter rules up 20161129091049 Remove puppet doc root setting up 20161205142618 Delete orphaned smart class parameters up 20161209162947 Add virt who to katello pools up 20161214151548 Move content source id to content facets up 20161227082709 Change architecture name limit up 20161227082721 Change usergroup name limit up 20170110113824 Change id value range up 20170114051758 Add depth to repositories up 20170118142654 Add auto increment to bigint ids up 20170118154134 Add type index to reports up 20170122204325 Add hypervisor to subscription facets up 20170125152421 Move default location to settings up 20170127094357 Add caching enabled to compute resource up 20170131142526 Fix builtin roles up 20170208215148 Add docker repo name up 20170209084517 Add actions to notification blueprint up 20170209113134 Remove unused permissions up 20170213154641 Add index reports on host id type up 20170214132230 Create ssh keys up 20170220679403 Remove system permissions up 20170221075203 Singularize resource type for permissions up 20170221100747 Add origin to roles up 20170221195674 Tidy current roles up 20170222131211 Change pool columns to dates up 20170223114114 Lock seeded templates up 20170223161638 Lock seeded roles up 20170226193446 Move subject to notifications up 20170228134258 Add clone info to role up 20170301155205 Remove widget hide up 20170306100129 Add message to notification up 20170315154334 Add report time type host index up 20170316142703 Add missing indexes to notification up 20170319131341 Add ancestry name index on fact name up 20170321012632 Fill in content view components up 20170405065305 Remove image password audit up 20170629080604 Change preseed default pxe grub2 kind
