Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.10
-
None
-
Debian 10
Description
We have strange problem
When setting causal_reads=global thera are missing data reads after inserts
running 'show processlist' on slave I see MASTER_GTID_WAIT in processlist. But anyway we have missed data.
Setting it back to fast fixes the problem
│ Parameters │ { │
|
│ │ "auth_all_servers": true, │
|
│ │ "causal_reads": "global", │
|
│ │ "causal_reads_timeout": 3000, │
|
│ │ "cluster": "TheMonitor", │
|
│ │ "connection_keepalive": 300, │
|
│ │ "connection_timeout": 0, │
|
│ │ "delayed_retry": true, │
|
│ │ "delayed_retry_timeout": 30000, │
|
│ │ "disable_sescmd_history": false, │
|
│ │ "enable_root_user": false, │
|
│ │ "lazy_connect": false, │
|
│ │ "localhost_match_wildcard_host": true, │
|
│ │ "log_auth_warnings": true, │
|
│ │ "master_accept_reads": true, │
|
│ │ "master_failure_mode": "fail_on_write", │
|
│ │ "master_reconnection": true, │
|
│ │ "max_connections": 0, │
|
│ │ "max_sescmd_history": 1500, │
|
│ │ "max_slave_connections": "255", │
|
│ │ "max_slave_replication_lag": 1000, │
|
│ │ "net_write_timeout": 0, │
|
│ │ "optimistic_trx": false, │
|
│ │ "password": "*****", │
|
│ │ "prune_sescmd_history": true, │
|
│ │ "rank": "primary", │
|
│ │ "retain_last_statements": -1, │
|
│ │ "retry_failed_reads": true, │
|
│ │ "router_options": null, │
|
│ │ "session_trace": false, │
|
│ │ "session_track_trx_state": false, │
|
│ │ "slave_connections": 255, │
|
│ │ "slave_selection_criteria": "ADAPTIVE_ROUTING", │
|
│ │ "strict_multi_stmt": true, │
|
│ │ "strict_sp_calls": true, │
|
│ │ "strip_db_esc": true, │
|
│ │ "targets": null, │
|
│ │ "transaction_replay": true, │
|
│ │ "transaction_replay_attempts": 20, │
|
│ │ "transaction_replay_max_size": "1073741824", │
|
│ │ "transaction_replay_retry_on_deadlock": false, │
|
│ │ "use_sql_variables_in": "master", │
|
│ │ "user": "maxscale", │
|
│ │ "version_string": null │
|
│ │ } │
|
:
|
|
Attachments
Issue Links
- relates to
-
MXS-3695 Causal Consistency with MaxScale's Read/Write Split Router issue
- Closed