Project

General

Profile

Actions

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.

Status:
Released
Priority:
2
Assignee:
Jonathan CLARKE
Category:
System techniques
Target version:
Effort required:
Name check:
Fix check:
Regression:

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;

Actions #1

Updated by Nicolas CHARLES over 10 years ago

  • Parent task changed from #4525 to #4428
Actions #2

Updated by Jonathan CLARKE over 10 years ago

  • Tracker changed from Bug to Enhancement
  • Status changed from New to 8
Actions #3

Updated by Nicolas CHARLES over 10 years ago

  • 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
Actions #4

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100

Applied in changeset policy-templates:commit:4368c42681e39696bb72826fcd0bb407b15dedcd.

Actions #5

Updated by Jonathan CLARKE over 10 years ago

Applied in changeset policy-templates:commit:537b3e3b1b2e607edbf6e5d166d2f28fea9f1dea.

Actions #6

Updated by Vincent MEMBRÉ over 10 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.10.0~beta1, which was released today.
Check out:

The release announcement: http://www.rudder-project.org/pipermail/rudder-announce/2014-March/000084.html
The full ChangeLog: http://www.rudder-project.org/foswiki/bin/view/System/Documentation:ChangeLog210
Download information: https://www.rudder-project.org/site/get-rudder/downloads/
Actions #7

Updated by Benoît PECCATTE over 9 years ago

  • Tracker changed from Enhancement to Architecture
Actions

Also available in: Atom PDF