Displaying 6 results from an estimated 6 matches for "source_file_id".
2006 Dec 29
5
sqlite errors
...lo,
When I kick off SVN1992 with storeconfigs=yes, I get the following error:
err: Could not store configs: SQLite3::SQLException: SQL logic error
or missing database: INSERT INTO resources ("exported", "line",
"title", "host_id", "restype", "source_file_id") VALUES(NULL, 23,
''svnpkgadd-emacs-nox-etc'', NULL, NULL, NULL)
The database does exist, and when I attempt to execute the SQL
statement from sqlite3 I get:
# sqlite3 clientconfigs.sqlite3
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> INSERT INTO...
2008 Mar 29
10
create new clientconfigs database
Hi, I''m upgrading from 23.2 to the latest and have "dbmigrate = true"
in my config.
When I try to run puppetd, I''m getting:
Could not migrate database: SQLite3::SQLException: no such table:
schema_info: SELECT version FROM schema_info
I''m perfectly blowing away my old db (by deleting /var/lib/puppet/
state/clientconfigs.sqlite3 ?), but I haven''t
2013 Oct 08
4
'puppet storeconfigs export' killed
...InnoDB_trx_id: A93
SET timestamp=1381244774;
SELECT `hosts`.`id` AS t0_r0, `hosts`.`name` AS t0_r1, `hosts`.`ip` AS
t0_r2, `hosts`.`environment` AS t0_r3, `hosts`.`last_compile` AS t0_r4,
`hosts`.`last_freshcheck` AS t0_r5, `
hosts`.`last_report` AS t0_r6, `hosts`.`updated_at` AS t0_r7,
`hosts`.`source_file_id` AS t0_r8, `hosts`.`created_at` AS t0_r9,
`resources`.`id` AS t1_r0, `resources`.`title` AS t1
_r1, `resources`.`restype` AS t1_r2, `resources`.`host_id` AS t1_r3,
`resources`.`source_file_id` AS t1_r4, `resources`.`exported` AS t1_r5,
`resources`.`line` AS t1_r6, `resources
`.`updated_at` AS t1...
2007 Sep 11
25
Re: #786: exported resources not refreshed
Hello all,
what exactly is the "design decision" that is needed here?
We currently have the problem that 0.23.2-3 (debian package) does not
work when it comes to collecting exported resources. The resources are
saved in the database, so picking them up is the problem (db is Mysql5.x).
This is a major problem for us, since we are using this a lot for our
monitoring services. I
2013 Oct 16
9
puppetdb, foreman, one particular node has a problem
...del_id", "name", "operatingsystem_id",
"organization_id", "owner_id", "owner_type", "ptable_id", "puppet_ca_proxy_id",
"puppet_proxy_id","puppet_status", "root_pass", "serial", "source_file_id",
"subnet_id", "type", "updated_at", "use_image", "uuid") VALUES ($1, $2, $3,
$4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19,
$20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34,
$35, $36, $37...
2007 Jun 14
19
Please test export/collect from svn
For those of you out there using export/collect (which we really need
to come up with a better name for...), can you test the current SVN
code?
I''m mostly wondering if the performance is any better. To use it,
you''ll have to remove your current database, since the database
schema is significantly changed.
I''m getting what looks like an additional 25% reduction