Jira (PDB-3515) Clean up orphaned edges

Adam Bottchen (JIRA) Mon, 15 May 2017 09:06:07 -0700

Title: Message Title

PDB-3515

I ran a `puppet node purge` on iebzu95xg1zlr4o.delivery.puppetlabs.net pn 5/12 at 11:58:

2017-05-12 11:58:12.886 PDT [db:pe-puppetdb,sess:59160585.3dd5,pid:15829,vtid:29/23,tid:0] DETAIL:  parameters: $1 = 'iebzu95xg1zlr4o.delivery.puppetlabs.net'

2017-05-12 11:58:12.887 PDT [db:pe-puppetdb,sess:59160585.3dd5,pid:15829,vtid:29/23,tid:0] LOG:  execute <unnamed>: UPDATE certnames SET deactivated = $1

                              WHERE certname=$2

                                AND (deactivated IS NULL OR deactivated < $3)

The delete ran several times with a node-purge-ttl of 1d:

2017-05-15 00:47:13.176 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1007,tid:0] DETAIL:  parameters: $1 = '2017-05-15 00:47:13.172-07', $2 = '2017-05-08 00:47:13.172-07', $3 = '2017-05-08 00:47:13.172-07', $4 = '2017-05-08 00:47:13.172-07'

2017-05-15 00:47:13.177 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1007,tid:0] LOG:  execute S_1: COMMIT

2017-05-15 00:47:13.177 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1008,tid:0] LOG:  execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED

2017-05-15 00:47:13.177 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1009,tid:0] LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL

2017-05-15 00:47:13.178 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1010,tid:0] LOG:  execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED

2017-05-15 00:47:13.178 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1011,tid:0] LOG:  execute <unnamed>: BEGIN

2017-05-15 00:47:13.178 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1011,tid:0] LOG:  execute <unnamed>: DELETE FROM certnames WHERE deactivated < $1 OR expired < $2

2017-05-15 00:47:13.178 PDT [db:pe-puppetdb,sess:591959a8.1477,pid:5239,vtid:17/1011,tid:0] DETAIL:  parameters: $1 = '2017-05-14 00:47:13.178-07', $2 = '2017-05-14 00:47:13.178-07'

The node is now no longer in the certnames table:

# su - pe-postgres -s /bin/bash -c "/opt/puppetlabs/server/bin/psql -d pe-puppetdb -c \"select * from certnames\""

 id |             certname              | latest_report_id | deactivated | expired

----+-----------------------------------+------------------+-------------+---------

  1 | pe-201621-master.puppetdebug.vlan |             6971 |             |

(1 row)

However, it and several other nodes, is still present in the edges table.

# su - pe-postgres -s /bin/bash -c "/opt/puppetlabs/server/bin/psql -d pe-puppetdb -c \"select distinct certname from edges order by certname\""

                 certname

-------------------------------------------

 iebzu95xg1zlr4o.delivery.puppetlabs.net

 iuq7zoo9k5ku0qp.delivery.puppetlabs.net

 pe-201621-agent.puppetdebug.vlan

 pe-201621-master.puppetdebug.vlan

 pe-aix-61-support.delivery.puppetlabs.net

 wkj27v5mqzzvdfq.delivery.puppetlabs.net

(6 rows)

Add Comment

This message was sent by Atlassian JIRA

--
You received this message because you are subscribed to the Google Groups "Puppet Bugs" 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/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.

Jira (PDB-3515) Clean up orphaned edges

Reply via email to