4306 Commits (v3.0.2)

Author	SHA1	Message	Date
René Cannaò	afb1865107	Merge pull request #5043 from sysown/v3.0-pgsql_mon_table_fix ... Fix table definition for 'pgsql_replication_hostgroups'	10 months ago
René Cannaò	471ddfc7aa	Merge pull request #5060 from sysown/v3.0_session_param_reset_connection ... Fix Backend Connection Reset and Parameter Handling for RESET/SET TO DEFAULT	10 months ago
Rahim Kanji	249b3d8725	* Replace C-style array with std::array in PgSQL_Connection ... * Nulling startup_parameters[i] in ~PgSQL_Connection after freeing	10 months ago
Rahim Kanji	50243ef283	Corrected RESET/DEFAULT logic ... * Now will actually reset value to server default (represented by nullptr value), if that parameter is not set in startup parameter. * Default parameter values (pgsql_default_*) will now be set only for critical parameters.	10 months ago
Rahim Kanji	1bcd09044b	Refactor Connection Reset Handling ... * Introduced startup parameters in PgSQL_Connection (removed default session parameters from PgSQL_Session) * Startup parameters are populated during both frontend and backend connection creation * Parameters provided via connection options are set as startup parameters * Backend connection parameter handling updated: only critical variables are now set via connection options to prevent interference with DISCARD ALL during connection reset; remaining parameters will be applied using individual SET commands	10 months ago
Rahim Kanji	0de642559d	Avoid crash when mirroring is set for PostgreSQL: show warning instead	10 months ago
René Cannaò	431fda06b4	Merge pull request #5007 from zuofei/fix-mysql-logging ... Fix mysql binary logging 0 parameters	10 months ago
René Cannaò	87f8355684	Merge pull request #5006 from sysown/v3.0-4976 ... Fix memory leak in 'ProxySQL_Admin::stats___mysql_global' - Closes #4976	10 months ago
Javier Jaramago Fernández	b7b4864729	Fix table definition for 'pgsql_replication_hostgroups' ... - Reduce 'check_type' range to uniquely supported check ('read_only'). - Added table upgrade procedure. - Fixed missing space in table definition (display for '\G').	10 months ago
Rahim Kanji	d3fec0cac7	Deallocate client_addr and proxy_addr memory in __delete_query_rule	10 months ago
Rahim Kanji	bc6f95a1fb	Removed previous_default_client_encoding variable	10 months ago
Javier Jaramago Fernández	25d5681c61	Fix potential overflow for 'sqlite3_status' memory metrics ... The previous call have been replaced by 'sqlite3_status64' when querying 'SQLITE_STATUS_MEMORY_USED' to avoid potential integer overflows.	11 months ago
Javier Jaramago Fernández	6f2798abe0	Fix memory leak in 'ProxySQL_Admin::stats___mysql_global' - Closes #4976 ... The resource leak was associated to prepared statements (sqlite3_stmt). Since the detection of these leaks is tricky, because the resources held by 'SQLite3' never lose their references, a helper type ('stmt_unique_ptr') and a safer variation for 'prepare_v2' have been introduced. This helper type should automatically handle the lifetime of the statements, avoiding these kind of leaks in the future. The non-safe alternative has been flagged as 'deprecated', so it can be easily identified in later refactors or slowly removed during development.	11 months ago
Zuofei Wang	241f17eb98	fix mysql binary logging 0 parameters	11 months ago
René Cannaò	7490af1783	Group Replication support for MySQL 8.4 and 9.x ... Closes #4954	11 months ago
Rahim Kanji	d5451970dc	Added comments	1 year ago
Rahim Kanji	7c46f6c48c	Improved parser	1 year ago
Rahim Kanji	700e8c21ae	Switched PQ error verbosity to formatted mode. ... Implemented a parser to handle the new format.	1 year ago
René Cannaò	2c26a42897	Merge pull request #4819 from sysown/v3.0-ff_conns_eof_caps_match ... Enforce `CLIENT_DEPRECATE_EOF` capability match for `fast-forward` sessions	1 year ago
René Cannaò	66322d05cf	Merge pull request #4851 from sysown/v3.0-ReadySet1 ... First POC for integration with ReadySet	1 year ago
René Cannaò	988d4049ac	Merge pull request #4941 from sysown/v3.0-4935 ... Fix losing database info on first logging for 'caching_sha2_password' - Closes #4935	1 year ago
René Cannaò	b888cb89b9	Readyset: always use proxy_warning() when changing status	1 year ago
René Cannaò	f9575b7ee9	Addressing minor issue on Readyset Monitoring ... - Renamed ReadySet to Readyset - fixed incorrect status variable - added missing newlines	1 year ago
René Cannaò	e5b30282b7	Adding info/warning message when ReadySet server change status ... INFO: if status is changed to ONLINE WARNING : if status is changed to anything else	1 year ago
René Cannaò	d641ca89be	First POC for integration with ReadySet ... Monitor is able to detect if a backend is a ReadySet server, and it enables special monitoring. The special monitoring hacks replication lag checks: a ReadySet server is "monitored for replication lag" , but it has a special query and a special handler. The query for check is "SHOW READYSET STATUS" , and the `Status` line is processed: * Online: the backend is configured as ONLINE * Maintenance* : the backend is configured as OFFLINE_SOFT * anything else, or failed check: SHUNNED A new monitor table is also added: `readyset_status_log` . It has a similar structure of `mysql_server_replication_lag_log` , but instead of storing `repl_lag` (replication lag) the full output of `SHOW READYSET STATUS` is saved as a JSON (that can be queried using `JSON_EXTRACT()`	1 year ago
René Cannaò	edc84ea14b	Merge pull request #4922 from sysown/v3.0-4861_fixes1 ... Further enhancement in prepared statement logging #4861	1 year ago
René Cannaò	d622fcfd4d	Merge pull request #4932 from sysown/v3.0-4918 ... Fix query digests for comments for certain query sizes - Closes #4918.	1 year ago
Javier Jaramago Fernández	f7c5756328	Fix losing database info on first logging for 'caching_sha2_password' ... The database specified in 'HandshakeResponse' was lost on the first logging when 'caching_sha2_password'. In this case a full-authentication was required, and this was the trigger for the context loss.	1 year ago
René Cannaò	216b31feae	Added new event_type PROXYSQL_METADATA ... When creating an event log in binary format, a metadata packet is written. The metadata is in JSON format. It currently only provide the ProxySQL version. For illustration purposes, tool eventlog_reader_to_json.cpp supports it too. This commit includes also some reformatting	1 year ago
Rahim Kanji	0adf56eff1	Improved set parser. SET LOCAL will now lock on hostgroup.	1 year ago
Rahim Kanji	7c7cbd0bc1	Few improvements	1 year ago
Rahim Kanji	9559703a02	Removed extra semicolon	1 year ago
Rahim Kanji	c71aa550df	Added names (alias of client_encoding)	1 year ago
Javier Jaramago Fernández	5c3a063775	Fix digest comment removal for queries over 'query_digests_max_query_length' ... Due to a typo/confusion, the boundary being used for comments check was 'd_max_len' instead of 'q_len'. This prevented the correct detection of a comment start when the query exceeded 'query_digests_max_query_length' which determines the value for 'd_max_len'.	1 year ago
Rahim Kanji	9910a18e84	Some optimisation	1 year ago
Rahim Kanji	979b3a81f4	Added PgSQL_ExplicitTxnStateMgr in session ... Dump transaction state in proxysql internal session output	1 year ago
Rahim Kanji	190e369658	Added Transaction State flag in SQLite3_to_Postgres	1 year ago
Rahim Kanji	d90bf4ac73	Optimized savepoint detection ... Added get_pg_parameter_status	1 year ago
Rahim Kanji	c6fd3cef9c	Added reorder_dynamic_variables_idx flag for server connection variables	1 year ago
Rahim Kanji	d0952275ad	Added PgSQL_ExplicitTxnStateMgr in MakeFile	1 year ago
Rahim Kanji	2f9bb83dda	Added Abort (alias of Rollback)	1 year ago
Rahim Kanji	ae1f3126a2	Added explicit transaction state manager	1 year ago
René Cannaò	9737e0630a	Add variable mysql-eventslog_stmt_parameters #4923 ... Variable mysql-eventslog_stmt_parameters configures the logging of parameters in prepared statements: - 0 : logging disabled - 1 : logging enabled	1 year ago
René Cannaò	97304ffa91	prepared statements logging: use HEX for STRING type ... When parameters are strings or blobs, they are always converted to hex	1 year ago
René Cannaò	65f79a07d2	Changes on write_query_format_1() for datetime ... When logging the parameters of COM_STMT_EXECUTE , use sizeof(MYSQL_TIME) for these types: * MYSQL_TYPE_TIMESTAMP * MYSQL_TYPE_DATE * MYSQL_TYPE_TIME * MYSQL_TYPE_DATETIME Notes: * sizeof(MYSQL_TIME) is 40 * client library may use MYSQL_TYPE_DATETIME for all of these types	1 year ago
René Cannaò	cbb8505ca1	Improvement in prepared statements logging ... In bufferTypeInfoMap , use sizeof(MYSQL_TIME) for the size of these types: * MYSQL_TYPE_TIMESTAMP * MYSQL_TYPE_DATE * MYSQL_TYPE_TIME * MYSQL_TYPE_DATETIME Notes: * sizeof(MYSQL_TIME) is 40 * client library may use MYSQL_TYPE_DATETIME for all of these types	1 year ago
Rahim Kanji	d113bcb193	Use PG_EVENT_WRITE status for PgSQL	1 year ago
Rahim Kanji	4969bd8301	PQconnectPoll can file descriptor (FD) during the connection process. We need to check whether FD has changed and, if so, update it in the thread's poll array.	1 year ago
Rahim Kanji	857e501ca3	Added update_fd_at_index method	1 year ago
Javier Jaramago Fernández	6db52ea942	Fix query digests for certain comments of particular size ... Removed unnecessary boundary check for certain comments.	1 year ago