Architecture #4528
closed
Architecture #4428: Avoid useless requests and commits in SQL database
Change the query made to check the database status in the system Technique
Added by Nicolas CHARLES over 10 years ago.
Updated over 9 years ago.
Category:
System techniques
Description
In the techniques, we check that the database is alive by performing the following query
select id from ruddersysevents limit 0;
and if it fails, we restart it.
we could simply do the following query, with th same success
select 1;
- Parent task changed from #4525 to #4428
- Tracker changed from Bug to Enhancement
- Status changed from New to 8
- Status changed from 8 to Pending technical review
- Assignee changed from Nicolas CHARLES to Jonathan CLARKE
- Pull Request set to https://github.com/Normation/rudder-techniques/pull/321
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
Applied in changeset policy-templates:commit:4368c42681e39696bb72826fcd0bb407b15dedcd.
Applied in changeset policy-templates:commit:537b3e3b1b2e607edbf6e5d166d2f28fea9f1dea.
- Status changed from Pending release to Released
- Tracker changed from Enhancement to Architecture
Also available in: Atom
PDF