Rafi Shamim
Rafi Shamim
To clarify, the `sql.defaults.results_buffer.size` setting has been in CockroachDB since v19.1. (see https://github.com/cockroachdb/cockroach/pull/32366) The recent change that happened is in v24.1.1, where the default value of this setting was changed...
To assist with the investigation, it would help tremendously if you could share instructions on how to reproduce the issue. In our own testing, we have not yet seen the...
Here's one more thing to try, which should be easier than coming up with a self-contained examples that reproduces the problem. I read more about concurrency and deadlocks in Rails...
Thanks for sharing more details @harelsafra. As part of your reproducer example, can you please also share the commands you use to connect to CockroachDB and the definition of the...
> The 3 nodes are accessed through an AWS network load balancer. The NLB connects the client to a single server in the cluster @harelsafra Can you try to see...
This issue in the ruby-pg repo might also be related. It describes a situation where the driver can hang. https://github.com/ged/ruby-pg/issues/583 To test if that is at play here, could you...
``` "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Collect: CollectRows: \"WITH \\\"descriptors\\\" AS (SELECT\\n\\t\\tdescriptor.id,\\n\\t\\t\\\"parentSchemaID\\\" AS schema_id,\\n\\t\\tnamespace.name AS name,\\n\\t\\tcrdb_internal.pb_to_json('desc', descriptor) AS descriptor\\n\\tFROM system.descriptor\\n\\tJOIN system.namespace ON namespace.id = descriptor.id\\n\\tWHERE \\\"parentID\\\"...
An improvement has landed in CockroachDB v25.1 (see https://github.com/cockroachdb/cockroach/issues/128774 and https://github.com/cockroachdb/cockroach/issues/113292). It was just released a few weeks ago. I believe this should make this query perform better as well.
tftr! bors r+