Monitoring for ipa backups #12992
Labels
No labels
announcement
anubis
authentication
aws
backlog
blocked
bodhi
ci
cloud
communishift
copr
database
day-to-day
dc-move
deprecated
dev
discourse
dns
downloads
easyfix
epel
firmitas
forgejo_migration
Gain
High
Gain
Low
Gain
Medium
gitlab
greenwave
hardware
help wanted
high-trouble
koji
koschei
lists
low-trouble
medium-trouble
mirrorlists
monitoring
Needs investigation
odcs
OpenShift
ops
outage
packager_workflow_blocker
pagure
permissions
Priority
Needs Review
Priority
Next Meeting
Priority
🔥 URGENT 🔥
Priority
Waiting on Assignee
Priority
Waiting on External
Priority
Waiting on Reporter
rabbitmq
release-monitoring
releng
request-for-resources
s390x
security
SMTP
sprint-0
sprint-1
src.fp.o
staging
unfreeze
waiverdb
websites-general
wiki
Backlog Status
Needs Review
Backlog Status
Ready
chore
documentation
points
01
points
02
points
03
points
05
points
08
points
13
Priority
High
Priority
Low
Priority
Medium
Sprint Status
Blocked
Sprint Status
Done
Sprint Status
In Progress
Sprint Status
Review
Sprint Status
To Do
Technical Debt
Work Item
Bug
Work Item
Epic
Work Item
Spike
Work Item
Task
Work Item
User Story
No milestone
No project
No assignees
4 participants
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
infra/tickets#12992
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
In #12969 we found (and fixed) a failure in the ipa backups. We should add a monitor for this to Zabbix.
Metadata Update from @james:
Metadata Update from @gwmngilfen:
I'll note that ipa01 seems fixed, but 02/03 aren't. :(
I didn't noticed 02/03 are still having issues.
Those failing cron jobs are complaining about space, so it's not an issue with cronjob itself, we just need to clear some space.
So we have 13 G available on ipa01, but the whole db has 16 G. So it can't back it up. I assume it got bloated during the spam :/
For ipa02 17 G vs 20 G free, so it should have enough space to create backup. Same for ipa03. It's strange that all of them are failing then.
I remember @gwmngilfen saying something about out of inode error on ipa machines, so that could be it.
It really needs more space, I tried to do backup manually and it consumed all available space during that.
Hm, the backups are being kept in /var/ipa/backups and taking up space. I thought those are moved to backup01 and then deleted.
And I see only ipa01 on backup01:/fedora_backups/, but all of them are already there.
It's keeping the latest 7 backups in cron https://pagure.io/fedora-infra/ansible/blob/main/f/roles/ipa/server/files/data-only-backup.sh, so we either give it more space or lower the number of kept backups on the machine.
Yeah, we keep the last 7 and we back that up to backup01 (on ipa01 only, because all of the cluster servers should be the same due to replication).
I guess we could keep less there, but it seemed handy to be able to easily restore.
Note that stage users were not being deleted correctly, so perhaps after thats fixed things will work better...
They are deleted now, but the db size is still the same. I tried to cleanup the tombstones, but it didn't changed the db size. From what I found we probably have to do re-indexing as well, but that needs to be done on stopped db.
TL;DR;: The backups are working again and there should be enough space to keep 7 of them.
With the help from LDAP folks I was able to reduce the size of LDAP db to 8G from 16G.
The problem why the size of the DB was so big was the
replication_changelog. We still had some replication entries foripaXX.aid2, which it couldn't reach and for some reasonipa01.rdu3was there twice. This caused the replication to fail and the changelog to grow incrementally till the migration, the users created by spammers were just the last drop.So I cleared the RUVs (Replication Update Vectors) and that helped me to finally clean the db manually.
Cool. Great detective work!
Shall we close this?
This ticket was originally opened for adding these checks to zabbix monitoring, backups were just something that we resolved during that. I don't think the checks are in place, so let's keep this open.
Oh, indeed. ok.
So, I have a prototype for this on STG, see this page
The setup returns the timestamp of the newest thing in /var/lib/ipa/backup, with a trigger to alert if that value is more than 26 hours old.
However, the backups filder is currently set
700 root:rootmeaning Zabbix can't read it. For testing I have set that to750 root:zabbix- @kevin @zlopez is that ok with you?I can do the Ansible parts and roll it out if you're good with that change.
@gwmngilfen wrote in #12992 (comment):
I don't think that would be a problem.
I think thats fine, as long as the backup tool doesn't complain.
Given this morning's backup seems to have run, I'd say we're golden. I'll roll it out.
Closed via 01ab355