Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-7001 Change Data Capture leveraging Max Lookback and Uncovered Indexes
  3. PHOENIX-7349

Improve the error messaging when CDC index is not yet active

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      A query against CDC with index in building state, you get the below cryptic error:

      Error: ERROR 2014 (INT16): Row Value Constructor Offset Not Coercible to a Primary or Indexed RowKey. No table or index could be coerced to the PK as the offset. Or an uncovered index was attempted (state=INT16,code=2014)

      This situation doesn't happen for regular queries because such indexes get silently dropped.

       

      We need to ensure a more meaningful message in this case.

      Attachments

        Activity

          People

            Unassigned Unassigned
            haridsv Hari Krishna Dara
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: