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

Author	SHA1	Message	Date
Rene Cannao	e24ac092f6	test(mysql): enlarge grace close binlog to ~50 MB to un-flake target>8s iterations ... fast_forward_grace_close-t writes a binlog, then for each target_time in {0..7, 20, 30, 60} reads it via a throttled client and asserts that target_time <= 8s reaches EOF and target_time > 8s does not (because the 8s grace_close_ms should cut the session before the binlog is drained). The >8s iterations have been flaky on GitHub runners. Analysis of the actual CI logs (proxysql.log timestamps vs test TAP output) shows what goes wrong: during the 8s grace window, ProxySQL keeps pushing bytes into the client's kernel recv buffer as fast as the buffer accepts them. If the whole binlog — including the empty-event EOF marker — fits into "what the client has already read" + "what is sitting in the client's recv buffer" by t=8s, grace_close does fire and cut the session, but the client's next mysql_binlog_fetch just returns the already-buffered EOF event and reports reached_EOF=TRUE. The test then fails the "Expected FALSE" assertion. With total_bytes = N and client recv-buffer capacity R, the test is only robust when N > ~1.7*R. Prior bumps (3 events -> 50 events, 2026-04-13) lifted N from 150 KB to 2.5 MB, which is enough on dbdeployer but too close to the margin on GH runners whose TCP recv autotune can grow past a couple of MB. 1000 x 50 KB = ~50 MB puts N well above any realistic R (kernels cap autotune around a few MB), so the grace close always fires while there is still many MB of undelivered binlog sitting in ProxySQL's output queue — the client cannot reach EOF. Side effects on other tests: none. The only other binlog-reading test in the same group, fast_forward_switch_replication_deprecate_eof-t, is already incidentally reading grace_close's binlog (it picks the first file from SHOW BINARY LOGS, which ends up being grace_close's rotated file). It reads at full speed and only asserts reached_EOF==true, which stays correct — it just reports ~50 MB instead of ~2.5 MB in its informational TAP message. Full-speed read of 50 MB over the Docker bridge is sub-second per config (4 configs -> ~1-2 s added). Data generation cost at test start is ~1-2 s for the extra INSERTs.	2 months ago
Rene Cannao	6d42ec2c97	fix(infra+tests): resolve SSL cert and binlog size issues with dbdeployer ... SSL certs: dbdeployer generates separate SSL certs per MySQL node. Collect CA certs from ALL nodes (master, node1, node2) instead of just node1. Also revert max_connect_errors to default — the real fix is having correct certs so SSL connections don't fail. Binlog size: fast_forward_grace_close test needs enough binlog data for throttled reads to exceed the 8s grace close period. Generate 50 x 50KB events instead of 3, creating enough per-event sleeps.	3 months ago
Rene Cannao	cfa2e3b940	fix(tests): use first binlog file size, not total, in grace close test ... fast_forward_grace_close_libmysql-t calculated the throttled read rate using total_bytes across ALL binlog files but only read the FIRST file. With dbdeployer, the binlog accumulates data from all earlier tests in the group, making total_bytes much larger than the first file. The resulting high rate meant the first file was read instantly, reaching EOF before the grace close could trigger. Fix: use the size of the first binlog file (the one actually read).	3 months ago
Rene Cannao	582c22333f	test: Migration to new testing infrastructure and cleanup ... - Update CommandLine to support TAP_CLUSTER_NODES, TAP_WORKDIR, and other env vars. - Update default admin credentials to 'radmin' in CommandLine to match CI standards. - Enforce connections via ProxySQL in fast-forward and binlog tests. - Replace hardcoded credentials and hosts with CommandLine variables in cluster tests. - Improve portability of tests by using dynamic host/port and TEST_DEPS. - Ensure strict equality checks for query counts in binlog reader tests.	4 months ago
Rene Cannao	83300374c7	Use right user in fast_forward_grace_close	7 months ago
Rene Cannao	140745a95a	Change default schema in fast_forward_grace_close	7 months ago
Rene Cannao	494dbf37fc	Minor enhancement in TAP fast_forward_grace_close ... Added `CREATE DATABASE IF NOT EXISTS test`	7 months ago
Rene Cannao	3329a671e5	Add extensive documentation for fast forward grace close feature	8 months ago
Rene Cannao	846c4de500	Replace spaces with tabs in fast_forward_grace_close.cpp	8 months ago
Rene Cannao	ae93966603	Add TAP test for fast forward grace close feature ... - Rename and modify test to use MySQL C API mysql_binlog_* functions - Implement throttled binlog reading with 5 iterations (no limit, 2s, 5s, 20s, 60s targets) - Add diagnostics for debugging binlog fetch issues - Set RPL options for file, position, server_id, and non-blocking flag - Update Makefile to compile with MySQL client library	8 months ago