[YCQL] Improve error code sent from the server to the driver

[dr0pdb]

Jira Link: DB-12280

Description

Came up in a customer incident. Right now, the CQL server doesn't send the appropriate error codes to the driver in some scenarios.

For example, it never sends the READ_TIMEOUT and WRITE_TIMEOUT errors even in case of timeouts.

The list of errors that we send from the server:

1. SERVER_ERROR: example, authentication failure
2. PROTOCOL_ERROR: example, unsupported compression method
3. BAD_CREDENTIALS: example, password mismatch or ldap failure
4. OVERLOADED
   When we run out of cql processors
   Soft memory limit hit
   Shutdown
5. SYNTAX_ERROR: wrong syntax (parser)
6. UNAUTHORIZED
7. INVALID: example, stale metadata cache
8. UNPREPARED: couldn’t understand when we send it.

We never send the following error codes:

1. UNAVAILABLE
2. IS_BOOTSTRAPPING
3. TRUNCATE_ERROR
4. WRITE_TIMEOUT
5. READ_TIMEOUT
6. READ_FAILURE
7. FUNCTION_FAILURE
8. WRITE_FAILURE
9. CONFIG_ERROR
10. ALREADY_EXISTS

Investigate and see if there are scenarios where a different error code can be sent. It'll help the driver better guage the issue and retry if needed.

Issue Type

kind/enhancement

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.