Bug #4849
closed
Bug #4831: Reports cannot be inserted into postgresql due to a limit on ids
Add an entry in the FAQ about limit on id
Added by Vincent MEMBRÉ almost 10 years ago.
Updated almost 10 years ago.
Description
We need to add an entry in our FAQ on http://rudder-project.org to explain the problem, how to detect it, how t analyse it, and the available solutions.
- It should include a request to see if the problem islikely to occur (select max(id) from ruddersysevents)
- Some explanation (we use integeer id which is limiter to 2 billion ...)
- Some different workaround ( upgrade to 2.10.2, and run the script ...)
- Pull Request set to https://github.com/Normation/rudder/pull/511
- Subject changed from Migration script to bigint locks databases for a too long time, having lots of casualties to Add an entry in the FAQ about limit on id
- Description updated (diff)
- Category changed from System integration to Documentation
- Target version changed from 2.6.13 to 2.10.1
- Pull Request deleted (
https://github.com/Normation/rudder/pull/511)
- Status changed from New to Pending technical review
- Assignee changed from Vincent MEMBRÉ to Nicolas CHARLES
- Status changed from Pending technical review to In progress
- Assignee changed from Nicolas CHARLES to Vincent MEMBRÉ
Vincent, this is fine, but a bit complex for standart user.
Could you modify the entry by having two cases:
- I upgraded to Rudder 2.10.1: run the script /opt/rudder/bin/rudder-upgrade-database , it will tell you if you need to upgrade Database, and let you choose your upgrade path (purge all reports from nodes, upgrade only last reports for each nodes, upgrade all reports)
- I can't upgrade to 2.10.1 or greater:here you put the "check if you are concerned" and "alter reports"
- Target version changed from 2.10.1 to 2.10.2
- Target version changed from 2.10.2 to 2.10.1
- Status changed from In progress to Pending technical review
- Assignee changed from Vincent MEMBRÉ to Nicolas CHARLES
- Status changed from Pending technical review to Pending release
- Status changed from Pending release to Released
This bug has been fixed in Rudder 2.10.1, which was released today.
Check out:
Also available in: Atom
PDF
Updated by 
Updated by