Re: Local read request going across DC

2022-09-21 Thread Erick Ramirez
Would you be open to temporarily posting the full CQL command + full trace output to gist.github.com? I'd like to see what it shows. Cheers! >

Re: Local read request going across DC

2022-09-21 Thread Raphael Mazelier
I lost the beginning of the thread but I raised what seems the same issue recently in this list. I have a worldwide c* cluster with 3dcs (eu, us, ap 8nodes each). For whatever reason I have read with consistency set to local_quorum which trigger reads on other dc(s). I would say it's 1% of the

Re: Local read request going across DC

2022-09-21 Thread Erick Ramirez
Just to circle back here, I've reviewed the trace output and it shows multiple requests fired off for lookups on the `roles` table which indicated to me that the default `cassandra` superuser is being used. To be clear, the original read request is being executed at the configured consistency BUT a

Re: Local read request going across DC

2022-09-21 Thread manish khandelwal
Thanks a lot Erick for your help and support. Regards Manish On Wed, Sep 21, 2022, 19:12 Erick Ramirez wrote: > Just to circle back here, I've reviewed the trace output and it shows > multiple requests fired off for lookups on the `roles` table which > indicated to me that the default `cassandr