MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Saturday, December 12, 2015

Backup Failed ManagerSnapshotExists


Here , I Explained about backup failed with Backup error - The state 'ManagerSnapshotExists' .

Case Study - We are getting backup failed issue frequently due to "general error: Backup error: The state 'ManagerSnapshotExists' of the BackupManager does not allow the requested operation SQLSTATE: HY000".

workaround for this error -

Step 1 -

hdbsql ABC=> backup data create snapshot
* 2: general error: Backup error: The state 'ManagerSnapshotExists' of the BackupManager does not allow the requested operation SQLSTATE: HY000
hdbsql ABC=>

Step 2 -

hdbsql ABC=> select * from m_snapshots
HOST,PORT,VOLUME_ID,ID,TIMESTAMP,FOR_BACKUP,ANCHOR
"vadbabc",30203,2,250977,"2015-08-21 10:12:11.631156000","TRUE",105553125293467
"vadbabc",30205,3,253189,"2015-08-21 10:12:11.634155000","TRUE",105553116282556
"vadbabc",30207,4,255762,"2015-08-21 10:12:11.633535000","TRUE",105553116266501
3 rows selected (overall time 6362 usec; server time 5034 usec)

Step 3 -

hdbsql ABC=>
hdbsql ABC=> backup data drop snapshot
0 rows affected (overall time 2831.081 msec; server time 2829.896 msec)

Step 4 -

hdbsql ABC=> select * from m_snapshots
HOST,PORT,VOLUME_ID,ID,TIMESTAMP,FOR_BACKUP,ANCHOR
0 rows selected (overall time 5886 usec; server time 4689 usec)

After this workaround Data Backup and  snapshot backup has  been completed successfully.

No comments: