> I made a backup today, to have a fresh one before we start the database > maintenance. The structurally wrong might not be so far fetched, since we > didn't upgrade from an official 1.0.2 release. My colleague got a patched > version (don't know the details, and can't ask now, as he's on holiday), > because at that time the official release was having an issue with binary > files (http://projects.puppetlabs.com/issues/17216). One consequence was, > that value 8 was missing from the schema_migrations table, even though the > matching modifications were already in place in the database ( 8 > rename-fact-column in /src/com/puppetlabs/puppetdb/scf/migrate.clj ). > Because of that, upgrades failed initially, when PuppetDB tried to rename > non-existing columns. The schema looked like it was actually matching the > migrations up to number 8, so just adding that value seemed to be ok. This > was tested in a lot smaller scale, but there the upgrade seemed fine, never > saw this error. Perhaps we overlooked something. > > If this is the case, then your suggested solution, to recreate the database > from scratch, should solve the problem. This will be up our next step, if > database maintenance doesn't help.
Well, I don't think a vacuum will help you - I imagine something is wrong with the schema right now or some data migration failed during upgrade. Esp. if you had migration issues from your custom PuppetDB. Of course I can't prove this with so little knowledge - but it certainly does raise a red flag. The only other option is to compare the schemas with a known good one, and compare the database data to try and find the fault. This however is prone to error and might be time-consuming. Recreating the database sounds like a far more reliable option with a lot more guarantees around it. ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
