Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3508

causal_reads=global results in missing data reads

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.10
    • Fix Version/s: 2.5.15
    • Component/s: readwritesplit
    • Labels:
      None
    • Environment:
      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

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              alexcool Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration