proxysql

Commit Graph

Author	SHA1	Message	Date
copilot-swe-agent[bot]	04c5e58e6b	fix: escape restapi config values Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com> Agent-Logs-Url: https://github.com/sysown/proxysql/sessions/40d309f0-bd3d-4616-9cd6-fa7d8f1cb355	3 months ago
copilot-swe-agent[bot]	8d358cbfdc	feat: load restapi routes from config aliases Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com> Agent-Logs-Url: https://github.com/sysown/proxysql/sessions/40d309f0-bd3d-4616-9cd6-fa7d8f1cb355	3 months ago
Rene Cannao	5004d827b1	Fix proxysql-tester.py to fail when expected tests don't run	3 months ago
copilot-swe-agent[bot]	f1212015f2	Initial plan	3 months ago
Rene Cannao	0d891b8941	Fix variable escaping in run-multi-group.bash subshell	3 months ago
Rene Cannao	64d8149a53	Add COVERAGE to run-multi-group.bash configuration summary output	3 months ago
Rene Cannao	9f6ba655bf	Add optional code coverage support for isolated test runs	3 months ago
Rene Cannao	40e5d785a6	Change multi-group startup delay from 0-15 to 1-20 seconds	3 months ago
René Cannaò	0e955cd4bc	Merge pull request #5465 from sysown/v3.0-mac260320 Fix macOS compilation and add static zstd linking	3 months ago
René Cannaò	7918e1737d	Merge pull request #5464 from sysown/freebsd-build-fixes Fix FreeBSD build compatibility	3 months ago
Rene Cannao	3a27d7f225	Fix pkglist targets to preserve original output format The previous fix incorrectly prepended 'binaries/' to the output. Now we match the full path and strip the prefix to get just filenames. - Match 'binaries/proxysql...' instead of just 'proxysql...' - Use sed to strip 'binaries/' prefix from the matched output - This maintains the original output format (just filenames)	3 months ago
René Cannaò	9fd4bcfe24	Add zstd to cleanall target and .gitignore - Add zstd cleanup to deps/Makefile cleanall target - Add deps/zstd/zstd-*/ to .gitignore for extracted sources	3 months ago
René Cannaò	df97ae9009	Add documentation for zstd static linking - Add README.md to deps/zstd documenting source and usage - Add comments in deps/Makefile for zstd build rule - Add comments in include/makefiles_paths.mk for ZSTD paths - Update INSTALL.md to note zstd is bundled and statically linked Related: #5462	3 months ago
Rene Cannao	cf54bff262	Fix docker-proxy-post.bash to use absolute path for .env sourcing The scripts were using relative path [ -f .env ] which failed when called from test/infra/control/, causing all SQL template variables (PREFIX, WHG, RHG, etc.) to be empty. This resulted in query rules with NULL match_digest patterns and incorrect rule IDs.	3 months ago
René Cannaò	3f1b0a1510	Add static linking for zstd compression library - Add zstd v1.5.7 as a static dependency in deps/ - Add zstd build rules to deps/Makefile - Add ZSTD_PATH, ZSTD_IDIR, ZSTD_LDIR to makefiles_paths.mk - Add zstd include path to lib/Makefile and src/Makefile - Link zstd statically in LIBPROXYSQLAR for all platforms - Remove -lzstd from dynamic linking flags (Linux and macOS) - Replace clickhouse-cpp bundled zstd with our static zstd This eliminates the runtime dependency on system/Homebrew zstd and ensures consistent behavior across platforms. Related: #5462	3 months ago
Rene Cannao	c5ebab5589	Fix FreeBSD build compatibility - Replace grep -Po (Perl regex) with grep -Eo (extended regex) for BSD compatibility - Use CC ?= cc instead of export CC=gcc to respect user's compiler choice - Add FreeBSD to std::conjunction check (already defined in BSD libc++) - Use reinterpret_cast<uintptr_t> for pthread_self() (pointer type on BSD) - Add missing FreeBSD headers: sys/socket.h and netinet/in.h Tested on FreeBSD 14.3 with clang and Linux with gcc.	3 months ago
Rene Cannao	758b8116c8	Fix reg_test_3223 RESTAPI test by adding TAP group setup hook Fix reg_test_3223-restapi_return_codes-t failure: 1. Created test/tap/groups/legacy/setup-infras.bash: - TAP group hook that copies RESTAPI scripts to ProxySQL data directory - Sets execute permissions on all scripts EXCEPT script_no_permissions - Keeps script_no_permissions without execute permissions for EACCES test 2. Modified test/tap/groups/legacy/env.sh: - Added REGULAR_INFRA_DATADIR=/var/lib/proxysql - Points to where scripts are mounted inside ProxySQL container This follows the architectural principle that test-specific setup belongs in TAP group hooks, not in the generic test runner or infrastructure scripts.	3 months ago
Rene Cannao	33aae3b1c2	Fix reg_test_3223 RESTAPI scripts path and add group env inheritance Fix reg_test_3223-restapi_return_codes-t failure by properly configuring REGULAR_INFRA_DATADIR in group environment files: 1. test/tap/groups/legacy/env.sh: Add REGULAR_INFRA_DATADIR pointing to test/tap/tests where reg_test_3223_scripts directory exists 2. test/tap/groups/mysql84/env.sh: Same REGULAR_INFRA_DATADIR setting 3. Create env.sh for feature-specific groups: - mysql-auto_increment_delay_multiplex=0 - mysql-multiplexing=false - mysql-query_digests=0 - mysql-query_digests_keep_comment=1 4. test/scripts/bin/proxysql-tester.py: Add fallback logic to load base group env.sh when subgroup env.sh doesn't exist (e.g., legacy-g1 falls back to legacy). This follows the same pattern as ensure-infras.bash. This follows the architectural principle that test-specific setup belongs in TAP group configuration, not in the generic test runner.	3 months ago
Rene Cannao	ba7f45474e	Fix run-multi-group.bash bugs and improve robustness Fixes: - Fix array parsing issue with bash arithmetic expansion on group names Changed from 'read -ra GROUPS' to simple for-loop iteration Group names like 'legacy-g1' were being evaluated as arithmetic (1004-114-1=889) - Fix exit code capture from timeout command Changed from 'if ! timeout ...; then exit_code=$?' to proper '\|\| cmd_exit_code=$?' The old code was capturing the if-test exit code (0) instead of the command's - Change PARALLEL_JOBS default from 0 (unlimited) to 2 for resource safety Improvements: - Add random 0-15 second startup delay per group to stagger infrastructure initialization and prevent Docker/resource contention when running multiple groups in parallel - Update header documentation with new default values Tested with RUN_ID="abd123" TAP_GROUPS="legacy-g1 legacy-g2 ai-g1 mysql84-g1" which ran successfully with staggered startup.	3 months ago
copilot-swe-agent[bot]	e274862857	feat: introduce stats_global table and move TLS metrics out of stats_mysql_global; add TAP tests - Add STATS_SQLITE_TABLE_GLOBAL definition (stats_global table for non-MySQL/PgSQL metrics) - Register stats_global in Admin_Bootstrap.cpp - Add stats___global() implementation and declaration; document with Doxygen comment - Remove TLS_* variables from stats___mysql_global() - they were misplaced there - Move all TLS tracking metrics to stats___global() under ssl_mutex - Wire up stats_global query detection and refresh in GenericRefreshStatistics() - Add TAP test test_tls_stats-t.cpp: - Verifies stats_global contains all 6 TLS tracking variables - Checks value ranges and validity of each TLS variable - Verifies stats_tls_certificates has 2 rows (server + ca) with correct fields - Verifies TLS_Load_Count increments and TLS_Last_Load_Timestamp increases after PROXYSQL RELOAD TLS - Confirms TLS variables are absent from stats_mysql_global Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com>	3 months ago
Rene Cannao	472e3644f7	Add parallel TAP group execution scripts New scripts for running multiple TAP groups in parallel: - run-multi-group.bash: Orchestrates parallel execution of multiple TAP groups * RUN_ID: Links all groups in a single test run (e.g., commit SHA) * TAP_GROUPS: Space-separated list of groups to run * PARALLEL_JOBS: Limit concurrent groups (default: unlimited) * TIMEOUT_MINUTES: Per-group timeout (default: 60) * EXIT_ON_FIRST_FAIL: Stop on first failure (default: 0) * AUTO_CLEANUP: Destroy successful groups automatically (default: 0) * SKIP_CLUSTER_START: Skip ProxySQL cluster init (default: 0) - destroy-multi-group.bash: Bulk cleanup for a specific RUN_ID * Destroys all infrastructures matching -{RUN_ID} Can target specific groups or auto-discover from log directories Each group gets fully isolated infrastructure: - INFRA_ID: {TAP_GROUP}-{RUN_ID} - Network: {INFRA_ID}_backend - Per-group logs in ci_infra_logs/{INFRA_ID}/ Fixes #5463	3 months ago
Rene Cannao	679d758e24	Fix ai-g1 env.sh to be POSIX sh compatible The Python tester sources env files using /bin/sh, but the previous implementation used bash-specific features (BASH_SOURCE[0] and source). Changed to inline the values from ai/env.sh for POSIX compatibility.	3 months ago
René Cannaò	88be1449d3	Fix compilation issues on macOS - Add Homebrew include paths for zstd headers on macOS - Fix pthread_t cast on macOS where it's a pointer type On macOS, pthread_t is defined as _opaque_pthread_t * (a pointer), unlike Linux where it's an integral type. Use reinterpret_cast<uintptr_t> for proper conversion. Related: #5462	3 months ago
Rene Cannao	2f8e63cef2	Address code review feedback for AI TAP group migration Fixes from PR #5461 review: 1. Fix BASE_GROUP derivation inconsistency in run-tests-isolated.bash - Changed from bash pattern matching `${TAP_GROUP%%-g[0-9]}` to sed - Now uses same pattern as ensure-infras.bash: `sed -E "s/[-_]g[0-9]+.//"` - Removed redundant BASE_GROUP reassignment 2. Update outdated comments in seed files - seed-mysql.sql and seed-pgsql.sql now correctly reference setup-infras.bash 3. Change INSERT OR IGNORE to INSERT OR REPLACE in mcp-config.sql - Ensures credentials are updated on reruns for deterministic state 4. Add shellcheck directives to env.sh files - Added `# shellcheck shell=bash` to ai/env.sh and ai-g1/env.sh 5. Add explicit validation for derived infrastructure names - setup-infras.bash now validates DEFAULT_MYSQL_INFRA and DEFAULT_PGSQL_INFRA - Provides clear error messages if infras.lst is misconfigured 6. Add WORKSPACE export to README examples - All runnable examples now include `export WORKSPACE=$(pwd)` Test verification: - ai-g1 group infrastructure setup works correctly - legacy-g2 group tests still pass (backward compatibility verified)	3 months ago
Rene Cannao	0b9806c46e	Migrate AI TAP group to Unified CI Infrastructure pattern This commit migrates the ai TAP group from its legacy hook-based approach to the standard test/infra/ Unified CI Infrastructure pattern. Changes: - Added generic hook system to infrastructure scripts: * ensure-infras.bash: Executes group-specific setup-infras.bash hook * run-tests-isolated.bash: Executes group-specific pre-cleanup.bash hook - Migrated ai group infrastructure: * Created infras.lst with infra-mysql84 and docker-pgsql16-single * Renamed seed files: mysql-seed.sql -> seed-mysql.sql, pgsql-seed.sql -> seed-pgsql.sql * Deleted legacy docker-compose.yml, docker-compose-init.bash, docker-compose-destroy.bash * Deleted legacy hooks: pre-proxysql.bash, post-proxysql.bash - Added group-specific MCP configuration: * setup-infras.bash: Configures MCP targets and seeds test data * pre-cleanup.bash: Removes MCP configuration after tests * mcp-config.sql: SQL template for MCP setup * cleanup.sql: SQL template for MCP cleanup * seed-mysql.sql & seed-pgsql.sql: Test data for AI tests - Updated documentation in README.md with usage examples Architecture: - ai is the supergroup (defines infrastructure and shared config) - ai-g1, ai-g2, etc. are subgroups (define test sets in groups.json) - Group-specific hooks live in test/tap/groups/ai/ directory - Infrastructure scripts remain generic and delegate to group hooks	3 months ago
René Cannaò	540fa174b4	Merge pull request #5458 from sysown/copilot/support-zstd-compression Add MySQL protocol ZSTD compression support	3 months ago
René Cannaò	e336a12aa5	Merge pull request #5460 from sysown/public/pr260319 Fix TAP tests for CI migration to per-container hostnames	3 months ago
René Cannaò	b541328985	Update test/tap/tap/utils.cpp Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com> Signed-off-by: René Cannaò <rene.cannao@gmail.com>	3 months ago
Rene Cannao	834785e170	Merge branch 'private-origin/v3.0' into public/pr260319	3 months ago
René Cannaò	0c4e0cae6a	Merge pull request #8 from sysown/copilot/fix-tap-tests-legacy-g1 Fix legacy-g1 TAP tests broken by CI migration to per-container hostnames	3 months ago
René Cannaò	7e8ae3595e	Merge pull request #11 from sysown/agents/sysown1/9 fix(tests): Replace hardcoded 127.0.0.1 with env-driven host/port for CI isolation	3 months ago
sysown1	b354cb6639	fix(tests): Replace hardcoded 127.0.0.1 with env-driven host/port CI migration to Docker containers requires tests to use environment variables for host/port configuration instead of hardcoded localhost addresses. Changes: - test_cluster_sync-t.cpp: Use cl.host and cl.admin_port for DELETE queries - test_cluster_sync_mysql_servers-t.cpp: Use cl.host and cl.admin_port - test_read_only_actions_offline_hard_servers-t.cpp: Use cl.host and cl.admin_port - test_simple_embedded_HTTP_server-t.cpp: Use cl.host for HTTP requests The CommandLine class reads from TAP_ADMINHOST and TAP_ADMINPORT environment variables set by CI infrastructure, enabling tests to work in containerized environments where ProxySQL runs on a different hostname.	3 months ago
Rene Cannao	2fcfd648e5	Merge remote-tracking branch 'origin/v3.0' into copilot/support-zstd-compression # Conflicts: # test/infra/infra-mysql84/docker-compose-init.bash # test/tap/groups/groups.json	3 months ago
Rene Cannao	8c6a6444db	fix: support zstd compression in mysql84 TAP	3 months ago
Rene Cannao	3458cbd28b	fix: address zstd review feedback	3 months ago
René Cannaò	1a0dea6da0	Merge pull request #5457 from sysown/copilot/fix-admin-credentials-logging Redact `admin-admin_credentials` from admin SET command logs	3 months ago
Rene Cannao	ffb610f4b8	Fix no-infra TAP group setup	3 months ago
Rene Cannao	c22056c37c	Finalize fixes and add TAP group for no-infra tests	3 months ago
Rene Cannao	d21c165ae9	Merge branch 'copilot/fix-proxysql-multiple-modules-port' into copilot/fix-admin-credentials-logging	3 months ago
Rene Cannao	4517edea78	Address review feedback and create no-infra TAP group - Fix retry loop in admin_set_credentials_logging-t.cpp to clear eofbit (CodeRabbit) - Fix spelling in lib/Admin_Handler.cpp (CodeRabbit) - Create new 'no-infra-g1' TAP group in groups.json - Add 'tests_no_infra' target to Makefiles to run tests without backends	3 months ago
René Cannaò	40716dcb46	Merge pull request #5455 from sysown/copilot/fix-proxysql-multiple-modules-port Fail fast on cross-module listener port conflicts	3 months ago
Rene Cannao	eac20e5287	Add Doxygen documentation for listener validation logic	3 months ago
Rene Cannao	71c4742b56	Address review: improve listener parsing and startup failure integration - Corrected listener parsing to avoid misclassifying malformed TCP endpoints as UNIX sockets. - Refactored ProxySQL_Main_init_phase3___start_all() to return failure status instead of direct exit, enabling cleaner daemon shutdown and preventing unwanted restart loops. - Added regression test for malformed listener strings.	3 months ago
copilot-swe-agent[bot]	307fff98e0	Fix TAP tests failing in legacy/legacy-g1 after CI migration to per-container hostnames Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com>	3 months ago
copilot-swe-agent[bot]	bf4c511b1a	Initial plan	3 months ago
René Cannaò	680fac46c0	Merge pull request #6 from sysown/fix-clickhouse-php-test-1773942157 docs(infra): Add unique INFRA_ID and debug build instructions	3 months ago
sysown1	c2a45700ba	docs(infra): Add unique INFRA_ID and debug build instructions - Document that INFRA_ID must be unique using timestamps - Add ProxySQL debug build instructions for LOAD DEBUG FROM DISK support - Fix clickhouse-mysql_ifaces to listen on all interfaces (0.0.0.0) Related: #5	3 months ago
René Cannaò	458ef01970	Merge pull request #5453 from sysown/v3.0-ci_84 [WIP] multiple changes related to CI	3 months ago
copilot-swe-agent[bot]	33e125ef59	fix: tighten zstd handshake parsing Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com>	3 months ago
copilot-swe-agent[bot]	ec44a15058	feat: add mysql protocol zstd compression support Co-authored-by: renecannao <3645227+renecannao@users.noreply.github.com>	3 months ago

... 5 6 7 8 9 ...

9275 Commits (mysqlx-plugin-impl) All Branches Search

9275 Commits (mysqlx-plugin-impl)

All Branches