proxysql

Commit Graph

Author	SHA1	Message	Date
Miro Stauder	b91dac044a	groups.json: add missing test Signed-off-by: Miro Stauder <miro@proxysql.com>	3 months ago
René Cannaò	a8e759c970	Merge pull request #5289 from sysown/v3.0_buildTap Improve build performance by preserving test dependencies during 'make clean'	3 months ago
René Cannaò	8b2b29918a	Merge pull request #5291 from sysown/v3.0-misc260111 [skip-ci] Remove deprecated read_only_action implementations from MySQL and PgSQL HostGroups managers	3 months ago
René Cannaò	b1e37b3387	Merge branch 'v3.0' into v3.0_pgsql-use-ssl-issue-5284 Signed-off-by: René Cannaò <rene@proxysql.com>	3 months ago
René Cannaò	c6ed5b96cd	Merge pull request #5282 from sysown/v3.0_bind-format-issue-5273-fix Fix malformed Bind packets when client provides a single parameter format	3 months ago
Rene Cannao	4aedacd83b	[skip-ci] Remove deprecated read_only_action implementations from MySQL and PgSQL HostGroups managers The old read_only_action() implementations were marked for deletion after 2025-07-14. These were replaced with new implementation that doesn't depend on the admin table. This change removes the deprecated code paths to clean up the codebase.	3 months ago
Rene Cannao	f2ac54e677	Optimize find commands in test/tap/tap/Makefile for better performance Combine multiple find commands into a single command to reduce directory traversal from 4 passes to 1 pass, improving both performance and readability. Suggestion from gemini-code-assist review.	3 months ago
Rene Cannao	4be31efd91	Fix cpp-dotenv preservation in clean target and add proper cleanall support - Fix: Exclude cpp-dotenv directories from find commands in 'make clean' (was removing build artifacts even when preserving source directories) - Add: proper 'cleanall' target in test/tap/tap/Makefile that removes cpp-dotenv source - Update: test/tap/Makefile cleanall to call tap's cleanall instead of clean - Now cpp-dotenv directories are properly preserved during development This fixes a bug where: 1. cpp-dotenv build artifacts were still being deleted during 'make clean' 2. There was no way to properly clean cpp-dotenv except manually 3. The preservation optimization was ineffective due to the above Behavior now: - 'make clean': preserves cpp-dotenv source and build artifacts (~213MB saved) - 'make cleanall': removes everything including cpp-dotenv source	3 months ago
Rene Cannao	ca224cfbdd	Preserve cpp-dotenv source during 'make clean' to improve build performance - Remove cpp-dotenv source cleanup from 'make clean' in test/tap/tap/Makefile - This prevents accidental removal of 213MB of extracted cpp-dotenv source - Build targets force full rebuild anyway if libraries are missing - Typical 'make clean' operation is now faster and preserves compiled artifacts Similar optimization as test/deps: - Regular development workflow preserves expensive-to-rebuild dependencies - Only 'cleanall' removes everything including source directories - Reduces repeated downloads and extraction of cpp-dotenv sources This change complements the previous test/deps optimization, further improving development workflow performance.	3 months ago
Rene Cannao	2ecda902e6	Improve build performance and clean behavior - Remove test/deps from 'make clean' to prevent accidental 2.8GB cleanup - 'make clean' now preserves test dependencies, speeding up development workflow - 'make cleanall' still removes test dependencies as intended - In test/deps/Makefile, make 'clean' an alias of 'cleanall' since incremental clean was practically redundant due to build targets forcing full rebuilds This change: - Reduces typical 'make clean' time by ~30 minutes - Prevents accidental loss of compiled test dependencies (2.8GB) - Makes development workflow more efficient while preserving explicit control Resolves issue with repeated MySQL connector compilation during development.	3 months ago
Rahim Kanji	c0086a56e4	Add test to groups.json	3 months ago
Rahim Kanji	b0ce03cc0e	Add test to groups.json	3 months ago
Rahim Kanji	f5074a535f	Removed unused executeQueries function	3 months ago
Rahim Kanji	ba53c75c63	Add Regression Test	3 months ago
René Cannaò	ef872c7f48	Merge pull request #5280 from sysown/v3.0-timezone-parser-fix Fix timezone parsing to support 3-component IANA names and hyphens	3 months ago
Rahim Kanji	3f46d4a5cc	Updated pg_lite_client and Added TAP test	3 months ago
Rene Cannao	662d8a0c47	Address gemini-code-assist review: improve hyphen test case Replace 'Atlantic/Canary' with 'US/East-Indiana' in the hyphen test cases. The previous test case (Atlantic/Canary) did not contain a hyphen and would have been matched by the old regex, so it did not actually test the new hyphen support. The new test case (US/East-Indiana) contains a hyphen and properly validates the hyphen support feature. Thanks to @gemini-code-assist for the excellent review feedback!	4 months ago
Rene Cannao	6e9abed581	Fix timezone parsing to support 3-component IANA names and hyphens This commit fixes a parsing error in the MySQL SET statement parser that occurred when processing `SET time_zone` statements with: 1. Three-component IANA timezone names (e.g., America/Argentina/Buenos_Aires) 2. Timezone names containing hyphens (e.g., America/Port-au-Prince) Previously, the regex pattern `(?:\w+/\w+)` only matched 2-component timezone names and did not support hyphens. This caused parsing errors logged as: "[ERROR] Unable to parse query. If correct, report it as a bug: SET time_zone=\"America/Argentina/Buenos_Aires\";" When multiplexing is enabled, this bug causes timestamps to be incorrectly written to the database. Changes: - Updated timezone regex from `(?:\w+/\w+)` to `(?:[\w-]+(?:/[\w-]+){1,2})` - Supports 2-3 components: Area/Location or Area/Country/Location - Supports hyphens in component names (e.g., Port-au-Prince) - Added comprehensive Doxygen documentation for timezone parsing - Extended TAP test cases with new timezone formats Note: Bare words like 'SYSTEM' and 'UTC' were already supported via other patterns in the parser (vp2 pattern for word matching). Fixes: #4993 Related: gemini-code-assist review comments	4 months ago
Rene Cannao	acf2e28905	Fix TAP test for mysql-select_version_forwarding with default mode 3 The test was failing because the default mode 3 (smart with fallback to proxying) tries to proxy the query when no backends exist, causing the query to fail. Changes: - Split test into two scenarios: 1. Mode 3 (explicitly set): Expected to FAIL with no backends 2. Mode 2: Expected to SUCCEED with no backends (fallback to internal) - Added extensive documentation explaining: * All 4 modes of mysql-select_version_forwarding * Why mode 3 fails with no backends (correct behavior) * Why mode 2 succeeds with no backends (fallback to internal version) * Test execution flow and why both scenarios matter - Refactored test into test_mode() helper function for clarity	4 months ago
Wazir Ahmed	40a1c787f7	TAP: Add proper comments in unit_test.h Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	4 months ago
Wazir Ahmed	facba20055	doc: Add information about groups in TAP test guide Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	4 months ago
Wazir Ahmed	0e537ddb3b	Fix typo in 'EXCLUDE_TRACKING_VARIABLES' macro Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	4 months ago
Wazir Ahmed	67ca39e248	doc: Update TAP documentation with unit test instructions Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	4 months ago
Javier Jaramago Fernández	e73ba2b64c	Fix changing server defaults for 'reg_test_unexp_ping_pkt' - Fixed was changing server defaults ('max_allowed_packet') in the same connection as the subsequent INSERT. - Use direct MySQL connection for table/data preparation. - ProxySQL connection pool required cleanup 'connection_pool' to ensure defaults reload.	4 months ago
Javier Jaramago Fernández	7efc85cee3	Fix TAP 'groups.json' file syntax	4 months ago
Javier Jaramago Fernández	5c8a32a0b0	Merge branch 'v3.0' of github.com:sysown/proxysql into v3.0-handle_unexp_ping	4 months ago
Javier Jaramago Fernández	b9cf5b1689	Remove empty spaces at end of lines for TAP tests 'groups.json'	4 months ago
Javier Jaramago Fernández	54e2b3e6dc	Add new test 'reg_test_unexp_ping_pkt-t' to TAP groups	4 months ago
René Cannaò	0f7ff1f374	Merge branch 'v3.0' into v3.0_pgsql-query-digest-gen-5253 Signed-off-by: René Cannaò <rene@proxysql.com>	4 months ago
René Cannaò	2667540fcc	Merge pull request #5237 from sysown/v3.0_pgsql-monitor-sslsupport-5205 Add SSL support for backend connections in PGSQL monitor	4 months ago
Javier Jaramago Fernández	503b0975c6	Add new TAP test exercising unexpected COM_PING packets logic Also fixes 'random_string' utility function for large strings, avoiding the previous shuffle repetition from the dictionary.	4 months ago
Rahim Kanji	febb650abb	Added Multiple Keep Comments test	4 months ago
Rahim Kanji	5e75264bb3	Updated TAP test	4 months ago
Rahim Kanji	e70fcbf021	* Add dedicated handling for double-quoted PostgreSQL identifiers * Added crash payload testing * Fixed unterminated comments handling	4 months ago
Rahim Kanji	fd53642f12	Added pgsql-query_digests_stages_test-t to groups.json	4 months ago
Rahim Kanji	f9b9ede64c	Fixed TAP test	4 months ago
Rahim Kanji	1b16a3938b	Added TAP test	4 months ago
Rene Cannao	66119b74fb	Add comments to select @@version queries to bypass ProxySQL interception ProxySQL now responds directly to `select @@version` queries, which prevents these queries from reaching the backend MySQL server. This commit adds `/* set_testing */` comments to these queries in test files to prevent perfect match interception and allow them to run on the backend. Modified files: - test/tap/tap/utils.cpp - test/tap/tests/set_testing-240.h - test/tap/tests/set_testing.h - test/tap/tests/test_firewall-t.cpp	4 months ago
René Cannaò	5a314d2364	Merge pull request #4889 from sysown/v3.0_get_server_version Added handling of SELECT @@version and SELECT VERSION() without backend	4 months ago
Rahim Kanji	d1b003a0e4	Added TAP test to groups.json	4 months ago
Rahim Kanji	0e7b5e2ba8	Added TAP test	4 months ago
Rene Cannao	a206828609	Add test_load_from_config_prefix_stripping-t to test groups Adds the new prefix stripping validation test to the default-g4 test group along with mysql-auto_increment_delay_multiplex=0-g4, mysql-multiplexing=false-g4, mysql-query_digests=0-g4, and mysql-query_digests_keep_comment=1-g4 groups. This ensures the test is run as part of the regular test suite.	4 months ago
Rene Cannao	7ebdf561ca	Fix automatic prefix stripping to work with libconfig lookup The previous implementation stripped the prefix before calling group.lookupValue(), which would fail because the config file contains the prefixed name (e.g., "mysql-log_unhealthy_connections"). The lookup must use the original name from the config file. This commit moves the prefix stripping logic to after the value lookup but before constructing the SQL query, ensuring both: 1. The correct value is retrieved from the config using the original prefixed name 2. The variable is stored in the database with a single prefix Also includes a test to verify the fix works for mysql_variables, pgsql_variables, and admin_variables sections.	4 months ago
René Cannaò	b73160ef5f	Merge pull request #4901 from sysown/v3.0_wait_timeout [WIP] Setting client side wait_timeout	5 months ago
René Cannaò	0d55ab5ea2	Merge branch 'v3.0' into v3.0_get_server_version Signed-off-by: René Cannaò <rene@proxysql.com>	5 months ago
Rene Cannao	2b900b3465	Update test groups configuration	5 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.	5 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.	5 months ago
René Cannaò	6534a152b2	Merge pull request #5241 from sysown/v3.0-5062_2 Add fast forward replication deprecate EOF test and update test infrastructure (closes #5062)	5 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.	5 months ago

1 2 3 4 5 ...

1553 Commits (3.0.6)