Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-9286

Add Keyspace/Table details to CollectionType.java error message

    XMLWordPrintableJSON

    Details

      Description

      The error message for too many element in a collection does not give keyspace or column family information. This makes it a pain point to try to determine which table is the offending table.

      Example Error message:

      ERROR [Native-Transport-Requests:809453] 2015-04-23 22:48:21,189 CollectionType.java (line 116) Detected collection with 136234 elements, more than the 65535 limit. Only the first 65535 elements will be returned to the client. Please see http://cassandra.apache.org/doc/cql3/CQL.html#collections for more details.
      

      Currently, to try to pinpoint the table in question. We need to trace all requests and then try to match up the timestamps in the CQL tracing session with the log timestamps to try and match. If prepared statements are used, this is a dead end due to the logged tracing information missing the query. In which case, we have to look at other 3rd party methods for capturing the queries to try and match up. This is extremely tedious when many tables have collections and a high number of ops against them.

      Requesting that the error contain the keyspace.table name in the error message.

        Attachments

        1. 9286-2.1-v2.txt
          4 kB
          Carl Yeksigian
        2. 9286-2.1.txt
          3 kB
          Carl Yeksigian
        3. 9286-2.0-v2.txt
          7 kB
          Carl Yeksigian
        4. 9286-2.0.txt
          7 kB
          Carl Yeksigian

          Activity

            People

            • Assignee:
              carlyeks Carl Yeksigian
              Reporter:
              sequoyha sequoyha pelletier
              Authors:
              Carl Yeksigian
              Reviewers:
              Tom Hobbs
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: