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. backup.tar.gz
          3.28 MB
        2. logs.zip.gz
          44.41 MB
        3. Screen Shot 2016-05-06 at 12.52.42 PM.png
          Screen Shot 2016-05-06 at 12.52.42 PM.png
          98 kB
        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