Uploaded image for project: 'Percona Backup for MongoDB'
  1. Percona Backup for MongoDB
  2. PBM-694

Fix restoring from a backup when it contains VIEWS collection

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 1.5.0
    • 1.6.0
    • None
    • OS : CentOS Linux release 7.7.1908 (Core)

       MongoDB Community server version: 4.0.6 

      pbm 1.5.0

    Description

      I have taken a pbm backup of my MongoDB server version: 4.0.6 use pbm 1.5.0  with few views defined in my mongodb database the backup was taken on local file system

      When I tried to restore it to a new environment It get stuck while restoring my first view collection with below message

       
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.756+0530 skipping restoring admin.system.version metadata, it is excluded
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.766+0530 first non special collection sms.view_rsd_bill_items found. The demultiplexer will handle it and the remainder
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.766+0530 restoring up to 20 collections in parallel
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.769+0530 collection sms.view_rsd_bill_items doesn't exist, skipping drop command
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.769+0530 reading metadata for sms.view_rsd_bill_items from archive on stdin
      Jul 04 21:18:51 ip-172-31-9-209.ap-south-1.compute.internal pbm-agent[27375]: 2021-07-04T21:18:51.769+0530 finished restoring sms.view_rsd_bill_items (0 documents, 0 failures)

       

      Than I drop the views from my Database and create a new pbm backup and try to restore than it gets restored successfully.

      Environment Details

      OS : CentOS Linux release 7.7.1908 (Core)

       

      Attachments

        Issue Links

          Activity

            People

              andrew.pogrebnoi Andrew Pogrebnoi
              danqam Danish Qamar
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 6 hours
                  6h

                  Smart Checklist