Displaying 6 results from an estimated 6 matches for "resource_tags".
2007 Aug 13
1
update from 0.22.4 to 0.23.x, not migrating database schema
...0.23.0 (and today to
0.23.2). Although ''dbmigrate=true'' is turned on AND the puppetmaster is
saying it migrates the databse at startup, this does not happen.
When it should store configs, I get the error:
Could not store configs: Mysql::Error: #42S02Table
''database.resource_tags'' doesn''t exist: SELECT * FROM resource_tags
WHERE (resource_tags.resource_id
I had the error after updating from 0.22.4 to 0.23.0, I created the one
or the other column by hand, as it seems not all of them.
Would be nice if this would be done by puppet itself.
Thanks,
udo.
2008 Feb 11
9
Storeconfigs purge Perl
...m hosts)'');
print "$result\n";
print "Delete from param_values, Affected rows: ";
$result = $dbh->do(''delete from param_values where resource_id not in (select id from resources)'');
print "$result\n";
print "Delete from resource_tags, Affected rows: ";
$result = $dbh->do(''delete from resource_tags where resource_id not in (select id from resources)'');
print "$result\n";
print "Delete from puppet_tags, Affected rows: ";
$result = $dbh->do(''delete from puppet_t...
2008 Jul 09
1
Deleting an exported resource
...''m wondering if there''s a better way to handle this
situation.
FYI, the SQL commands I ran were:
SET @host_id = ...
DELETE FROM fact_values WHERE host_id=@host_id;
DELETE FROM param_values WHERE resource_id IN (
SELECT id FROM resources WHERE host_id=@host_id
);
DELETE FROM resource_tags WHERE resource_id IN (
SELECT id FROM resources WHERE host_id=@host_id
);
DELETE FROM resources WHERE host_id=@host_id;
DELETE FROM hosts WHERE id=@host_id;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Pup...
2009 Dec 08
5
Cleaning Out Stored Configs
...way, or change considerably.
If we get rid of a server then all it''s stored config is still present
in the database, as well as it''s nagios and munin configurations.
We created a script that iterates through the database deleting
associated lines from
hosts/fact_values/resources/resource_tags/param_values tables cleaning
out information for old hosts, but then doing a puppet run on say our
Munin or Nagios doesn''t seem to fix things, Puppet doesn''t seem to
notice that the extra Nagios or virtual configurations we''re using for
Munin have vanished, so isn'...
2013 Oct 08
4
'puppet storeconfigs export' killed
...AS t3_r0, `puppet_tags`.`name`
AS t3_r1, `puppet_tags`.`updated_at` AS t3_r2, `puppet_tags`.`created_at`
AS t3_r3 FROM `hosts` LEFT OUTER JOIN `resources` ON `resources`.`host_id`
= `hosts`.`id` LEFT OUTER JOIN
`param_values` ON `param_values`.`resource_id` = `resources`.`id` LEFT
OUTER JOIN `resource_tags` ON `resource_tags`.`resource_id` =
`resources`.`id` LEFT OUTER JOIN `puppet_tags`
ON `puppet_tags`.`id` = `resource_tags`.`puppet_tag_id` WHERE
`resources`.`exported` = 1;
When the process gets stuck, an strace shows a constant and very quick flow
of:
30666 stat("/etc/localtime",...
2006 Jan 27
20
bundled_resource v.0.9
Original announcement at http://blog.inquirylabs.com/ [1]
== What is bundled_resource? ==
If your development is in any way similar to mine, there are a number
of useful resources out there that make web applications shine
beautifully. For example, there?s the Dynarch calendar and the
textarea tools. There are a number of others?too many, in fact. The
problem is that as a web developer,