Actions
Architecture #4526
closed
Architecture #4428: Avoid useless requests and commits in SQL database
Change the validation query for the database
Status:
Released
Priority:
2
Assignee:
Category:
Performance and scalability
Target version:
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
Updated by Nicolas CHARLES about 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
PR is there : https://github.com/Normation/rudder/pull/449
Updated by François ARMAND about 10 years ago
- Category changed from Architecture - Code maintenance to Performance and scalability
Updated by Nicolas CHARLES about 10 years ago
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
Applied in changeset bb97ca1e422d442b3998ad68762d8bbad56434e8.
Updated by Anonymous about 10 years ago
Applied in changeset 3fe07c253401cc47d44aef5429bc9541fc5df6ce.
Updated by Nicolas CHARLES about 10 years ago
- Parent task changed from #4525 to #4428
Updated by Vincent MEMBRÉ about 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/
Updated by Benoît PECCATTE about 9 years ago
- Tracker changed from Enhancement to Architecture
Actions