6 Commits (feature/pgsql-native-backend-protocol)

Author	SHA1	Message	Date
Rene Cannao	df76a3dc06	test: implement comprehensive noise injection across MySQL TAP tests ... Integrated the enhanced noise framework into multiple MySQL-specific tests. Each test now optionally spawns: - Random Stats Poller - REST Prometheus Poller (with auto-enable support) - PgSQL Traffic v2 (configured with 100 conns and 300ms delay) This significantly increases the background load during test execution to better uncover potential race conditions and stability issues.	4 months ago
Rene Cannao	dc4694d656	Refactor idle session scanning and improve test precision ... Code improvements: - Extract SESS_TO_SCAN_idle_thread constant to header file for better maintainability - Replace magic number 128 with named constant in idle_thread_to_kill_idle_sessions() - Improve code readability and consistency in session scanning logic Test enhancements: - Add mysql-poll_timeout configuration for more precise timeout testing - Reduce test sleep times to 13 seconds for faster test execution - Add diagnostic messages to clearly show timeout configurations in test output - Ensure tests properly validate timeout enforcement with precise timing The changes improve code maintainability and make tests more reliable and faster while maintaining accurate timeout validation.	7 months ago
Rene Cannao	0c5e75a064	Fix wait_timeout timeout calculations and add proper newline characters ... Key improvements: - Fix timeout comparison in MySQL_Thread::idle_thread_to_kill_idle_sessions() to prevent underflow - Use effective wait_timeout (minimum of global and session values) for idle timeout calculations - Add proper newline characters to proxy_warning messages for consistent log formatting - Increase test sleep times to account for global timeout enforcement - Fix session timeout test durations to properly test timeout behavior Technical changes: - Replace broken min_idle calculation with proper effective wait_timeout logic - Add std::min() usage to determine effective timeout from global and session values - Ensure warning messages end with newline characters for proper log formatting - Update test sleep durations to ensure proper timeout testing Resolves potential timeout calculation bugs and ensures consistent timeout enforcement behavior.	7 months ago
Rene Cannao	0c9c938d66	Fix mysql-set_wait_timeout-t.cpp compilation and JSON testing ... - Replace <json/json.h> include with <json.hpp> and proper nlohmann namespace - Replace manual JSON parsing with fetch_internal_session() utility function - Replace fail() calls with ok(false, ...) to follow TAP framework standards - Add comprehensive JSON validation test for various wait_timeout values - Include edge case testing: zero values, maximum values, and clamping behavior Resolves compilation issues and enables proper testing of wait_timeout JSON output.	7 months ago
Rene Cannao	6539587c9a	test: Add comprehensive wait_timeout JSON validation tests ... - Add JSON parsing helper for PROXYSQL INTERNAL SESSION responses - Add test_wait_timeout_json_values() function with 8 test cases: * Zero value (should clamp to 1 second) * Valid values (1s, 10s, 5min, 1hr, 24hr, 20 days) * Value exceeding 20 days (should clamp to maximum) - Validate that wait_timeout appears in session JSON output - Test plan increased from 4 to 12 tests total - Provides comprehensive validation of wait_timeout clamping behavior	7 months ago
Wazir Ahmed	fd9ce84b34	Add TAP test for session wait timeout ... Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	11 months ago