[MCOL-2033] restore script required cleaning dbrm files on pm1 of fresh install Created: 2018-12-15  Updated: 2023-10-26  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Thompson (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Did a backup of 2um3pm non root. Blew instances away and created fresh install on new instances. Now restore to this instance complains:
2018-12-15 05:08:25] ERROR: PM1: data directory found – /home/mysql/mariadb/columnstore/data1/000.dir
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesA_em
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesA_vbbm
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesA_vss
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesB_em
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesB_vbbm
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_savesB_vss
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_saves_current
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_saves_em
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_saves_journal
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_saves_vbbm
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – BRM_saves_vss
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – oidbitmap
[2018-12-15 05:08:26] ERROR: PM1: dbrm directory file found – SMTxnID
[2018-12-15 05:08:27] ERROR: Table data was found. Cleanup the installation and rerun.
[2018-12-15 05:08:27] Restore Status: Failed

Clearing:
rm -rf mariadb/columnstore/data*/data1/systemFiles/dbrm/*

solved this but seems like a restore should just work on a fresh install? Also even if it's not its kind of clunky to make users go through a gazillion steps on each node to do a restore (this has to be balanced against accidental restore of course).



 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

Generated at Thu Feb 08 02:33:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.