Project

General

Profile

Actions

Architecture #4526

closed

Architecture #4428: Avoid useless requests and commits in SQL database

Change the validation query for the database

Added by Nicolas CHARLES over 10 years ago. Updated over 9 years ago.

Status:
Released
Priority:
2
Category:
Performance and scalability
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

Rudder does the following query to check the connection validity:

SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';

however, it seems the correct query (and which put less stress on the systems) is

select 1

as said in http://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases

Actions #1

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to François ARMAND
  • Pull Request set to https://github.com/Normation/rudder/pull/449
Actions #2

Updated by François ARMAND over 10 years ago

  • Category changed from Architecture - Code maintenance to Performance and scalability
Actions #3

Updated by Nicolas CHARLES over 10 years ago

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

Updated by Anonymous over 10 years ago

Actions #5

Updated by Nicolas CHARLES over 10 years ago

  • Parent task changed from #4525 to #4428
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