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.
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:
Post a Comment