Data Restoration issue

Hello Team,

We have two Influx DB instances one for prod and sandbox. Now we are trying to syncing prod data to sandbox account. Restoration is successful, but we have once strange issue. Let’s say i have two databases 1. jenkins and 2. linux.

When i select any one measurement by entering in to any data base to print the data. Even though the measurement not present in data base, data is being displayed. There are no errors or much information to troubleshoot.

Note: But it is not happening in prod instance.

Below are the steps followed to take a full backup.

sudo docker exec $CONTAINER_NAME influxd backup /tmp/backup
sudo docker exec $CONTAINER_NAME influxd backup -portable /tmp/backup

Restore steps:

  1. Step influxdb container.
  2. Remove data, wal and meta folders.
    3… Start Infuxdb container
  3. sudo docker exec ${CONTAINER_NAME} influxd restore -portable “${BACKUP_DIR}”
  4. sudo docker stop ${CONTAINER_NAME}
  5. echo “Restore meta database with users and grants”
  6. sudo docker run --rm
    –name ${CONTAINER_NAME}_meta_restore
    -e INFLUXDB_DATA_DIR=“/var/lib/influxdb/data/”
    -e INFLUXDB_META_DIR=“/var/lib/influxdb/meta/”
    -v $BACKUP_LOCATION:/tmp/backup/
    -v ${META_DIR}/:/var/lib/influxdb/meta/
    -v ${DATA_DIR}/:/var/lib/influxdb/data/
    influxdb:current
    influxd restore -metadir /var/lib/influxdb/meta/ /tmp/backup/
  7. sudo docker start ${CONTAINER_NAME}
    ===

Can you support here ? Thanks in Advance !!

Hello @Jagadeeswar,
I’m sorry I’m having trouble understanding your issue.
How are you doing:

When i select any one measurement by entering in to any data base to print the data. Even though the measurement not present in data base, data is being displayed. There are no errors or much information to troubleshoot.

Can you please be as specific as possible? Thank you.
What version of influxDB are you using?