Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2446

Immutable index - Index vs base table row count does not match when index is created during data load

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.6.0
    • 4.7.0
    • None
    • None

    Description

      I'll add more details later but here's the scenario that consistently produces wrong row count for index table vs base table for immutable async index.

      1. Start data upsert
      2. Create async index
      3. Trigger M/R index build
      4. Keep data upsert going in background during step 2,3 and a while after M/R index finishes.
      5. End data upsert.

      Now count with index enabled vs count with hint to not use index is off by a large factor. Will get a cleaner repro for this issue soon.

      Attachments

        1. PHOENIX-2446-v6.patch
          87 kB
          Thomas D'Silva
        2. PHOENIX-2446-v5.patch
          82 kB
          Thomas D'Silva
        3. PHOENIX-2446-v4.patch
          71 kB
          Thomas D'Silva
        4. output_writes.log
          254 kB
          Thomas D'Silva
        5. output_reads.log
          8 kB
          Thomas D'Silva
        6. output.log
          414 kB
          Thomas D'Silva
        7. PHOENIX-2446_testfix.patch
          12 kB
          James R. Taylor
        8. PHOENIX-2446-wip-v3.patch
          113 kB
          Thomas D'Silva
        9. PHOENIX-2446_partial.patch
          8 kB
          James R. Taylor
        10. server.log
          39 kB
          Thomas D'Silva
        11. PHOENIX-2446-wip.patch
          45 kB
          Thomas D'Silva
        12. PHOENIX-2446.patch
          24 kB
          Thomas D'Silva

        Issue Links

          Activity

            People

              tdsilva Thomas D'Silva
              mujtabachohan Mujtaba Chohan
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: