Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-19540

infer command does not give correct results after a bucket with indexes built using defer_build is restored

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.0
    • 4.5.0
    • tools
    • 4.5.0-2489
    • Untriaged
    • Unknown

    Description

      1.create a bucket with 1000 docs and create moi indexes using defer_build=True.Make sure you have enough memory for moi indexes.

      2. Take backup of this bucket using new cbbackupmgr.
      ./cbbackupmgr config --archive /tmp/backup --repo simple_table —-host http://127.0.0.1:8091 —-username Administrator —-password password

      ./cbbackupmgr backup --archive /tmp/backup --repo simple_table --host http://172.23.107.87:8091 --username Administrator --password password

      I am attaching the backup taken in this bug.

      3. Do cbrestore using this command:
      ./cbbackupmgr restore --archive /tmp/backup --repo simple_table --host http://172.23.107.56:8091 --username Administrator --password password

      Restore happens correctly and we see 1000 documents restored in the bucket on 172.23.107.56.

      4. Check query tab. Try expanding simple_table in bucket analyzer, you dont see the list of fields there.Please see attachment.

      5. Result of infer command in query tab:

      { "status": "Unexpected server error" }

      6. Result of infer command in cbq:
      cbq> infer simple_table;
      N1QL: Query nodes not responding

      I am able to execute other queries. Attaching logs from machine on which bucket is restored.
      Please let me know if you need more logs.

      Attachments

        1. Screen Shot 2016-05-06 at 12.52.42 PM.png
          98 kB
          Prerna Manaktala
        2. backup.tar.gz
          3.28 MB
          Prerna Manaktala
        3. logs.zip.gz
          44.41 MB
          Prerna Manaktala
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            eben Eben Haber
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty