summaryrefslogtreecommitdiffstats
path: root/ext/dbfix.sql
Commit message (Collapse)AuthorAgeFilesLines
* Removed extra whitespace from end of linesIan Taylor2009-06-061-21/+21
|
* dbfix - fix typo and close another possible inconsistencyBrice Figureau2009-03-041-3/+37
| | | | | | | | | | | This patch fixes a typo in one request producing a SQL error. It also close an issue where param_values could point to inexistant param_names after the deduplications of those. It does this by rewriting the param_values to point to the highest id of the param_names of the same name. The same operation is performed on the tags. Signed-off-by: Brice Figureau <brice-puppet@daysofwonder.com>
* This script fixes the most common issues with inconsistentJames Turnbull2009-02-281-0/+98
storeconfigs database (including duplicate resources record, duplicate param_values records, dangling records...). Usage: stop all puppetmasters backup your database! % cat ext/dbfix.sql | mysql puppet relaunch all puppetmasters Signed-off-by: Brice Figureau <brice-puppet@daysofwonder.com> ---