codfw1dev: we lost the PDNS database content
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	aborrero
	Oct 2 2023, 12:13 PM

Description

It seems we lost the PDNS database content with the recent reimages of cloudservices2004-dev/2005-dev nodes into Debian 12 Bookworm.

There should be at least two procedures to restore the data:

have designate force-recreate it. The data is originally stored in the openstack BD (galera), but designate wont inject it into PDNS unless there is an update in the records. How to force-do-it is unknown at the moment
restore a pdns database backup. Given the hosts were reimaged, restoration might a be a bit trickier.

Status	Assigned	Task
Resolved	fnegri	T341285 Upgrade cloud-vps openstack to version 'Antelope'
Resolved	fnegri	T345810 [openstack] Upgrade codfw hosts to bookworm
Resolved	fnegri	T347856 codfw1dev: we lost the PDNS database content

False, the data seems to be there. In particular:

1	MariaDB [pdns]> select * from domains where name like 'bastion%';
2	+----+----------------------------------------------+------------------------------------+------------+-------+-----------------+---------+--------------+---------+---------+
3	\| id \| name \| master \| last_check \| type \| notified_serial \| account \| designate_id \| catalog \| options \|
4	+----+----------------------------------------------+------------------------------------+------------+-------+-----------------+---------+--------------+---------+---------+
5	\| 56 \| bastioninfra-codfw1dev.codfw1dev.wmcloud.org \| 172.20.5.6:5354 185.15.56.162:5354 \| 1695934592 \| SLAVE \| NULL \| \| NULL \| NULL \| NULL \|
6	+----+----------------------------------------------+------------------------------------+------------+-------+-----------------+---------+--------------+---------+---------+
7	1 row in set (0.001 sec)

fnegri changed the task status from Invalid to Resolved.Oct 3 2023, 6:00 PM