华为云type1 快照删除提示没有资源 原因是后台快照删除、数据库没有清理

 现象是后台快照删除掉了  但是数据库的信息还一直在

 

Controller001:/home/fsp # cinder snapshot-show 80f9acae-7b23-42e5-8b7d-35a8bcfcbb25
+---------------------------------------------------+--------------------------------------+
|                      Property                     |                Value                 |
+---------------------------------------------------+--------------------------------------+
|                     created_at                    |      2019-12-25T15:50:32.468361      |
|                    description                    |        Eisoo Backup Snapshot         |
|                         id                        | 80f9acae-7b23-42e5-8b7d-35a8bcfcbb25 |
|                      metadata                     |                  {}                  |
|                        name                       |       Backup_1577289503460227        |
|      os-extended-snapshot-attributes:progress     |                 100%                 |
|     os-extended-snapshot-attributes:project_id    |   ae6e7e749ba14708abcdafdb637db6fb   |
| os-extended-snapshot-attributes:provider_location |                 134                  |
|     os-vendor-ext-attr:vendor_driver_metadata     |                  {}                  |
|                        size                       |                 100                  |
|                       status                      |              available               |
|                     updated_at                    |      2020-10-28T03:22:11.321841      |
|                     volume_id                     | 04c0fa5e-74a4-4b81-b899-70525485de1d |
+---------------------------------------------------+--------------------------------------+
Controller001:/home/fsp # cinder snapshot-delete 80f9acae-7b23-42e5-8b7d-35a8bcfcbb25
Delete for snapshot 80f9acae-7b23-42e5-8b7d-35a8bcfcbb25 failed: VolumeNotFound: Volume 04c0fa5e-74a4-4b81-b899-70525485de1d could not be found. (HTTP 404) (Request-ID: req-1665eba2-9b41-49ce-9642-4c5e61a46736)
ERROR: Unable to delete any of the specified snapshots.
Controller001:/home/fsp # cps template-instance-list --service guassdb gaussdb
Item Not Found!
Controller001:/home/fsp # ^C
Controller001:/home/fsp # cps template-instance-list --service gaussdb gaussdb
+------------+---------------+---------+--------------------------------------+--------------+
| instanceid | componenttype | status  | runsonhost                           | omip         |
+------------+---------------+---------+--------------------------------------+--------------+
| 0          | gaussdb       | active  | 4338265E-3D18-838A-E911-D3AAE829787A | 10.70.52.221 |
| 1          | gaussdb       | standby | 3C38265E-3D18-61BB-E911-D3AA1AD9E19D | 10.70.52.68  |
+------------+---------------+---------+--------------------------------------+--------------+
Controller001:/home/fsp # su gaussdb
su: user gaussdb does not exist
Controller001:/home/fsp # su gaussdb
su: user gaussdb does not exist
Controller001:/home/fsp # su gaussdba
[gaussdba@Controller001 fsp]$ gsqp -d cinder -W FusioNsphere123
bash: gsqp: command not found
[gaussdba@Controller001 fsp]$ gsql -d cinder -W FusioNsphere123
could not change directory to "/home/fsp"
gsql: FATAL:  Invalid username/password,login denied.
[gaussdba@Controller001 fsp]$ gsql -d cinder -W FusionSphere123
could not change directory to "/home/fsp"
gsql (9.2.4)
Type "help" for help.

CINDER=# select * from snapshots where id='80f9acae-7b23-42e5-8b7d-35a8bcfcbb25';
CINDER=# select * from snapshots where id='80f9acae-7b23-42e5-8b7d-35a8bcfcbb25';
CINDER=# update snapshots set DELETED='t' where ID='80f9acae-7b23-42e5-8b7d-35a8bcfcbb25';
UPDATE 1
CINDER=# update snapshots set DELETED='t' where ID='b5e6c9ee-c6b6-4dd5-a432-69a4c3d17ee2';
UPDATE 1
CINDER=#