Queries sporadically fail with LOCAL_ONE/LOCAL_QUORUM

Queries in multi-datacenter clusters sporadically fail with a replication factor set to LOCAL_ONE or LOCAL_QUORUM.

The DataStax Enterprise Help Center also provides troubleshooting information.

The DataStax Enterprise database will sporadically fail in a multi-datacenter cluster using SimpleStrategy if a query uses LOCAL_ONE or LOCAL_QUORUM. This affects DSE Graph queries in a multi-datacenter cluster as well. If you use DataStax Studio to auto-create graphs in Development mode, this issue is likely to appear.

To avoid this issue, in or multi-datacenter clusters, create graphs with appropriate DSE database settings.